Bug #81335 [Com]: PHP Warning, Packets out of order after connection timeout

Edit report at https://bugs.php.net/bug.php?id=81335&edit=1 ID: 81335 Comment by: peter dot maatman at rentman dot nl Reported by: bohuslav at simek dot si Summary: PHP Warning, Packets out of order after connection timeout Status: Verified Type: Bug Package: PDO MySQL Operating System: Alpine Linux 3.14 PHP Version: 7.4.22 Block user comment: N Private report: N New Comment: We are seeing this issue appear in production after we started migrating our production database servers from mysql 8.0.19 to 8.0.28. Our php version currently is 7.4.16 with pdo_mysql enabled, we run our php in a docker container based on the official php:7.4-fpm image. I can confirm that the test script reproduces the bug. Previous Comments: ------------------------------------------------------------------------ [2022-03-07 16:20:31] maurice dot volaski at einsteinmed dot edu I am seeing this on my Mac with PHP 8.1.2 (Apache module) and MySQL 8.0.28 Homebrew. ------------------------------------------------------------------------ [2021-09-30 20:23:49] vovikems at gmail dot com Having same error using official docker images: php:8.0.9-cli and mysql:8.0.26. Typically this error seen on first DB query since long time (about 10h-15h) keeping DB connection without any query sent. Next query is always ok. FYI i'm using long-running php application (RoadRunner, Spiral Framework, CycleORM). ------------------------------------------------------------------------ [2021-09-14 12:27:24] cmb@php.net Oops, forgot about this. Anyway, result with git-master and MySQL 8.0.26: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Is this Linux specific? ------------------------------------------------------------------------ [2021-08-06 18:16:59] cmb@php.net With MySQL 5.6.44 and 8.0.19 I get: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away I'm waiting for the update to 8.0.26 to finish for about eight hours now. I'll test with that version when it's finished (if it ever finishes). ------------------------------------------------------------------------ [2021-08-06 12:43:21] dharman@php.net Thanks for reporting. This indeed should be fixed in mysqlnd. Tested on git.master and the mysqlnd client doesn't notice the connection has dropped when sending a query. ------------------------------------------------------------------------ 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=81335 -- Edit this bug report at https://bugs.php.net/bug.php?id=81335&edit=1