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: No Feedback
Type: Bug
Package: MySQLi related
Operating System: CentOs
PHP Version: 7.4.12
Block user comment: N
Private report: N
New Comment:
Thanks for reporting this. But unfortunately, we still do not know how to reproduce it on our
machines. It might something specific to your environment but there could be thousands of different
configurations we haven't tried.
If you tell us how to reproduce this issue ourselves, please reopen the bug report on https://github.com/php/php-src/issues Please check
if it is still happening with PHP 8.2 first.
Previous Comments:
------------------------------------------------------------------------
[2021-08-09 13:41:00] cmb@php.net
Okay, so apparently your comment was a "typo". Anyhow, this bug
report doesn't appear to be actionable, unless you can provide
further information.
------------------------------------------------------------------------
[2021-08-09 13:24:25] w2kzx80 at gmail dot com
How can i know if it is bug of MariaDB or php?
I didnt develop nor php nor mysql - i just reported which is issue - i guess its something with
bytes in compression algorythm between php and mariadb but how can i know if it is php bug or
mariadb bug? Most looks like php because i used console mysql utility with same request and didnt
receive any error but I dont know how all this works - i think developers of php language must know
isnt it?..
------------------------------------------------------------------------
[2021-08-09 11:02:20] cmb@php.net
> But i cant wait till it will be fixed in mysql server so...
So is this a bug in MariaDB? Is there a related bug report?
------------------------------------------------------------------------
[2021-07-19 13:47:26] w2kzx80 at gmail dot com
Thats my "solution" in php - but OF COURSE - it is bad solution. But i cant wait till it
will be fixed in mysql server so... maybe it will be useful for somebody
$res = $db->query($query);
if (!$res) $res=$db->query(preg_replace('/^([ ]*[^ ]+) (.+)$/uis','$1
$2',$query));
Thats it... It adds one additional space between first word of request and next part
Like
"SELECT * FROM table" -> "SELECT * FROM table"
Unfortunately i cant detect some logical indications that some query will not be successful. Only
this method with retry...
------------------------------------------------------------------------
[2021-07-19 07:30:32] info at 4ws-netdesign dot de
We discover the same problem:
Ubuntu 18.04 - PHP 7.4.3 FPM/FastCGI
MySQL: 8.0.25-0ubuntu0.20.04.1 - (Ubuntu)
Yes it's reproducible: if you have a query producing this error you can repeat as often you
want: the warning appears.
We have simple queries produding this error. By adding useless whitespaces in the query you can fix
this query - but the problem still exists at other places.
Increasing max_allowed_packet to 2G in my.cnf fixes the problem partially but it still occurs on
some places.
Scripts worked fine with PHP 7.2 before. And it's really simple queries like
SELECT * FROM tablename
producing this error (small tables => 0-10 entries)
------------------------------------------------------------------------
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=80374
--
Edit this bug report at https://bugs.php.net/bug.php?id=80374&edit=1