Bug #79914 [PATCH]: PHP PDO mysqlnd ignores InnoDB deadlock errors

Edit report at https://bugs.php.net/bug.php?id=79914&edit=1 ID: 79914 Patch added by: houxiaoxian1111@163.com Reported by: houxiaoxian1111 at 163 dot com Summary: PHP PDO mysqlnd ignores InnoDB deadlock errors Status: Open Type: Bug Package: PDO MySQL Operating System: centos 7.8.2003 PHP Version: 7.2.32 Block user comment: N Private report: N New Comment: The following patch has been added/updated: Patch Name: patch.79914 Revision: 1596594009 URL: https://bugs.php.net/patch-display.php?bug=79914&patch=patch.79914&revision=1596594009 Previous Comments: ------------------------------------------------------------------------ [2020-07-30 07:19:21] sjon@php.net could this be related to #77163 ? ------------------------------------------------------------------------ [2020-07-30 06:59:26] houxiaoxian1111 at 163 dot com The following patch has been added/updated: Patch Name: patch.76742 Revision: 1596092366 URL: https://bugs.php.net/patch-display.php?bug=79914&patch=patch.76742&revision=1596092366 ------------------------------------------------------------------------ [2020-07-30 06:58:38] houxiaoxian1111 at 163 dot com Description: ------------ PHP PDO mysqlnd ignores InnoDB deadlock errors (1213) when ATTR_EMULATE_PREPARES = false Test script: --------------- CREATE DATABASE test CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci'; USE test; CREATE TABLE test ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, data MEDIUMTEXT NULL ) ENGINE = InnoDB; <?php $password = 'password'; $dbh = new \PDO("mysql:host=localhost;dbname=test", 'root', $password, [\PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION, \PDO::ATTR_EMULATE_PREPARES => false]); $dbh->query('SET TRANSACTION ISOLATION LEVEL SERIALIZABLE'); $dbh->beginTransaction(); $dbh->prepare("INSERT INTO test (data) VALUES (:data);") ->execute(['data' => 'a']); sleep(5); $sth = $dbh->prepare("SELECT id, data FROM test WHERE 1"); var_dump($sth->execute(), $sth->fetchAll(), $dbh->commit()); Expected result: ---------------- Shell 1: [jan@localhost ~]$ php test.php bool(true) array(1) { [0] => array(4) { 'id' => int(1) [0] => int(1) 'data' => string(1) "a" [1] => string(1) "a" } } bool(true) Shell 2: (started 2 seconds after 1st) [jan@localhost ~]$ php test.php PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /home/jan/test.php:16 Stack trace: #0 /home/jan/test.php(16): PDOStatement->execute() #1 {main} thrown in /home/jan/test.php on line 16 Actual result: -------------- Shell 1: [jan@localhost ~]$ php test.php bool(true) array(1) { [0] => array(4) { 'id' => int(1) [0] => int(1) 'data' => string(1) "a" [1] => string(1) "a" } } bool(true) Shell 2: (started 2 seconds after 1st) [jan@localhost ~]$ php test.php bool(true) array(0) { } bool(true) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=79914&edit=1