Bug #74401 [Opn->Csd]: PDO trigger warning already set throw exception

Edit report at https://bugs.php.net/bug.php?id=74401&edit=1 ID: 74401 Updated by: nikic@php.net Reported by: lusc at jiedaibao dot com Summary: PDO trigger warning already set throw exception -Status: Open +Status: Closed Type: Bug Package: PDO MySQL Operating System: Centos6.x PHP Version: 7.0.17 -Assigned To: +Assigned To: nikic Block user comment: N Private report: N New Comment: This should be fixed since PHP 7.4, by https://github.com/php/php-src/commit/2856afc70e50b85424b2bd2d6653020679160a0b. Previous Comments: ------------------------------------------------------------------------ [2019-01-15 17:43:18] dws dot vad at gmail dot com 7.3.1 this issue actual ------------------------------------------------------------------------ [2017-04-13 02:50:01] lusc at jiedaibao dot com mysqlnd_result.c line 429 php_error_docref(NULL, E_WARNING, "Error reading result set's header"); mysqlnd_wireprotocol.c line 298 and line 310 php_error_docref(NULL, E_WARNING, "%s", mysqlnd_server_gone); ------------------------------------------------------------------------ [2017-04-12 06:45:59] lusc at jiedaibao dot com https://bugs.php.net/bug.php?id=63812 , same problem. ------------------------------------------------------------------------ [2017-04-11 15:04:20] lusc at jiedaibao dot com example: ``` error_reporting(E_ALL); ini_set('display_errors', 'on'); try { $pdo = new PDO('mysql:dbname=qiye;host=100.73.13.5;charset=utf8', 'myroot', 'Hsql1234'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt1 = $pdo->prepare('SELECT * FROM auth limit 1'); $stmt1->execute(); var_dump($stmt1->fetchAll()); sleep('30'); // stop the mysql server at this time $stmt1 = $pdo->prepare('SELECT * FROM jdb_company_info limit 1'); $stmt1->execute(); var_dump($stmt1->fetchAll()); } catch (Throwable $e) { var_dump($e->__toString()); } ``` output: ``` array(0) { } Warning: PDOStatement::execute(): MySQL server has gone away in /mnt/g/workspace/workspace/qiye/tests/web/test.php on line 21 Warning: PDOStatement::execute(): Error reading result set's header in /mnt/g/workspace/workspace/qiye/tests/web/test.php on line 21 string(240) "PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /mnt/g/workspace/workspace/qiye/tests/web/test.php:21 Stack trace: #0 /mnt/g/workspace/workspace/qiye/tests/web/test.php(21): PDOStatement->execute() #1 {main}" ``` ------------------------------------------------------------------------ [2017-04-10 09:56:47] danack@php.net Forgot to update the status to feedback. Also, the reason I'm asking for an example is that the code for generating warning or exceptions looks really quite unlikely to do both. https://github.com/php/php-src/blob/528468579b002ff17e3c38d9330da67749fd85ec/ext/pdo/pdo_dbh.c#L149-L165 ------------------------------------------------------------------------ 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=74401 -- Edit this bug report at https://bugs.php.net/bug.php?id=74401&edit=1