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: johnnywalker at gmail dot com 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: I can confirm script failing in 2 different setups with Php 7.4.3 ## Setup 1 ## Mysql Server version: 8.0.31 Distribution: Ubuntu 20.04.5 Linux Kernel: 5.15.0 Php Version: 7.4.3 PHP Warning: Packets out of order. Expected 1 received 0. Packet size=145 in... ## Setup 2 ## Mysql Server version: 8.0.30 Distribution: Ubuntu 20.04.5 LTS Linux Kernel: 5.4.0 Php Version: 7.4.3 PHP Warning: Packets out of order. Expected 1 received 0. Packet size=145 in... Previous Comments: ------------------------------------------------------------------------ [2022-11-03 15:22:22] addi dot hurz at gmail dot com macOS 12.5.1 with arm CPU _ PHP 8.1.12 _ MySQL 8.0.31 all installed and freshly updated with homebrew script still produces: Warning: Packets out of order. Expected 1 received 0. Packet size=145 Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away ------------------------------------------------------------------------ [2022-09-12 07:12:20] myhomeworkhelponline at gmail dot com This is a common problem with all of us, I am an online coding tutor who provides top-notch PHP programming help to students in their assignments. I also suppose that PHP is a server scripting language and a significant tool for creating dynamic and interactive web pages. That's why we also suggest that you take the help of an expert at any time to solve your problem here: myhomeworkhelp.com/php-homework-answers/ ------------------------------------------------------------------------ [2022-09-06 14:06:49] peter dot maatman at rentman dot nl 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. ------------------------------------------------------------------------ [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). ------------------------------------------------------------------------ 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