Bug #76742 [Opn]: PHP PDO mysqlnd ignores InnoDB deadlock errors (1213)

Edit report at https://bugs.php.net/bug.php?id=76742&edit=1 ID: 76742 Updated by: nikic@php.net Reported by: jan at venekamp dot net Summary: PHP PDO mysqlnd ignores InnoDB deadlock errors (1213) Status: Open Type: Bug Package: PDO MySQL Operating System: Centos 7 PHP Version: 7.2.8 Block user comment: N Private report: N New Comment: This should be fixed by https://github.com/php/php-src/commit/b03776adb5bbb9b54731a44377632fcc94a59d2f. Previous Comments: ------------------------------------------------------------------------ [2020-08-08 00:56:03] houxiaoxian1111 at 163 dot com The following pull request has been associated: Patch Name: with ATTR_EMULATE_PREPARES = false, don't ignore deadlock errors On GitHub: https://github.com/php/php-src/pull/5937 Patch: https://github.com/php/php-src/pull/5937.patch ------------------------------------------------------------------------ [2020-08-08 00:53:47] houxiaoxian1111 at 163 dot com The following patch has been added/updated: Patch Name: patch.79914 Revision: 1596848027 URL: https://bugs.php.net/patch-display.php?bug=76742&patch=patch.79914&revision=1596848027 ------------------------------------------------------------------------ [2020-08-05 02:31:23] houxiaoxian1111 at 163 dot com The following patch has been added/updated: Patch Name: patch.79914 Revision: 1596594683 URL: https://bugs.php.net/patch-display.php?bug=76742&patch=patch.79914&revision=1596594683 ------------------------------------------------------------------------ [2020-07-30 03:25:03] houxiaoxian1111 at 163 dot com The following patch has been added/updated: Patch Name: patch.76742 Revision: 1596079503 URL: https://bugs.php.net/patch-display.php?bug=76742&patch=patch.76742&revision=1596079503 ------------------------------------------------------------------------ [2018-12-13 16:09:32] dominik dot fiser at w3w dot cz Probably similar to https://bugs.php.net/bug.php?id=76525 The core of the problem is that Galera Cluster can return deadlock error on commit and MySQL PDO ignores this error and returns always only false instead of PDO error/exception. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=76742 -- Edit this bug report at https://bugs.php.net/bug.php?id=76742&edit=1