Bug #80374 [NEW]: Mysqli warning Packets out of order. Expected 1 received 0

From: Date: Mon, 16 Nov 2020 11:28:35 +0000
Subject: Bug #80374 [NEW]: Mysqli warning Packets out of order. Expected 1 received 0
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-230377@lists.php.net to get a copy of this message 
From:             w2kzx80 at gmail dot com
Operating system: CentOs
PHP version:      7.4.12
Package:          MySQLi related
Bug Type:         Bug
Bug description:Mysqli warning Packets out of order. Expected 1 received 0

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 bug report at https://bugs.php.net/bug.php?id=80374&edit=1
-- 
Fix committed:                    https://bugs.php.net/fix.php?id=80374&r=fixed
Fixed in release:                 https://bugs.php.net/fix.php?id=80374&r=alreadyfixed
Need backtrace:                   https://bugs.php.net/fix.php?id=80374&r=needtrace
Need Reproduce Script:            https://bugs.php.net/fix.php?id=80374&r=needscript
Try newer version:                https://bugs.php.net/fix.php?id=80374&r=oldversion
Not developer issue:              https://bugs.php.net/fix.php?id=80374&r=support
Expected behavior:                https://bugs.php.net/fix.php?id=80374&r=notwrong
Not enough info:                  https://bugs.php.net/fix.php?id=80374&r=notenoughinfo
Submitted twice:                  https://bugs.php.net/fix.php?id=80374&r=submittedtwice
register_globals:                 https://bugs.php.net/fix.php?id=80374&r=globals
PHP version support discontinued: https://bugs.php.net/fix.php?id=80374&r=phptooold
Daylight Savings:                 https://bugs.php.net/fix.php?id=80374&r=dst
IIS Stability:                    https://bugs.php.net/fix.php?id=80374&r=isapi
Install GNU Sed:                  https://bugs.php.net/fix.php?id=80374&r=gnused
Floating point limitations:       https://bugs.php.net/fix.php?id=80374&r=float
No Zend Extensions:               https://bugs.php.net/fix.php?id=80374&r=nozend
MySQL Configuration Error:        https://bugs.php.net/fix.php?id=80374&r=mysqlcfg

Thread (13 messages)

« previous php.bugs (#230377) next »