Bug #80374 [Opn->Fbk]: Mysqli warning Packets out of order. Expected 1 received 0

Edit report at https://bugs.php.net/bug.php?id=80374&edit=1 ID: 80374 Updated by: dharman@php.net Reported by: w2kzx80 at gmail dot com Summary: Mysqli warning Packets out of order. Expected 1 received 0 -Status: Open +Status: Feedback Type: Bug Package: MySQLi related Operating System: CentOs PHP Version: 7.4.12 -Assigned To: +Assigned To: dharman Block user comment: N Private report: N New Comment: Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. Thanks for the bug report. However, we need more information to be able to reproduce the issue. Currently, we can't reproduce the issue. A lot of factors could cause this problem, and its nature requires that we receive extremely thorough reproducible steps. Please let us know: - Platform (Windows/Linux/Mac) - MySQL flavor and version e.g. MariaDB 10.4.1 - Whether mysqli was compiled against libmysqlclient or mysqlnd - Which connection method was used (TCP/IP or socket or named pipe) - Your table schema. (SHOW CREATE TABLE tbl_name) including charset used for connection and table storage. - The character encoding of your file. Are you using UTF-8? - Are you using utf8mb4 charset? Did you set the charset via set_charset() method? - HEX dump of the query string producing the error. (There could be a hidden character there) - HEX dump of the sample data causing the error. - Self contained reproducible example. http://sscce.org/ should help you make such an example. We would love to hear back from you and if possible fix the bug you have reported. Previous Comments: ------------------------------------------------------------------------ [2020-11-16 15:15:30] w2kzx80 at gmail dot com well - yes its reproducible if I found some SQL which give this error - this error repeat each time this SQL is used So i can reproduce it 1000 times if i want but I dont know how to find this SQL - I found one and i know how to check it. But I dont have ideas why exact this SQL statement give me this error.. ------------------------------------------------------------------------ [2020-11-16 11:33:19] nikic@php.net How reproducible is this issue? Is this something you see every time, or more something that happens rarely and randomly? ------------------------------------------------------------------------ [2020-11-16 11:28:35] w2kzx80 at gmail dot com Description: ------------ Hi Im using php 7.4.10 and i cant simply upgrade it to 7.4.12 if im not sure it will resolve problem because its production server and situation is unique and its difficult to find another such situations. So for now while i found it im not changing nothing in server configuration till ill find answer. First of all - this bug happen in some random cases but when it happen in some my part of code - it happen always. Problem is in creating mysql requests using mysqli library. In some sql statements it creates problems like "Packets out of order. Expected 1 received 0". I noticed that it doesnt depend on mysql configuration because i have many same databases with same access and many same tables with same structure and all is same and all works but some sql statements return this error ALSO what is very strange - i change sql request with adding one space and it start working. It mean that there is something basic wrong with networking in php Test script: --------------- //.... im connecting to db and so on and then $la=$db->query('SELECT * FROM voipe_481.labels_auto'); //here i put additional space between FROM and database name - and it works OK $la=$db->query('SELECT * FROM voipe_481.labels_auto'); // here it write Warning and disconnects from server //PHP Warning: Packets out of order. Expected 1 received 0. Packet size=1 Expected result: ---------------- both sql requests must work fine Actual result: -------------- first sql request works fine, second crashes connection to database Interesting is that im checking $db->ping before each request and it is ok but after second request it is false ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=80374&edit=1