Edit report at https://bugs.php.net/bug.php?id=80374&edit=1
ID: 80374
Updated by: nikic@php.net
Reported by: w2kzx80 at gmail dot com
Summary: Mysqli warning Packets out of order. Expected 1
received 0
Status: Open
Type: Bug
Package: MySQLi related
Operating System: CentOs
PHP Version: 7.4.12
Block user comment: N
Private report: N
New Comment:
How reproducible is this issue? Is this something you see every time, or more something that happens
rarely and randomly?
Previous Comments:
------------------------------------------------------------------------
[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