Packets out of order
Opened this issue · 0 comments
Getting a repeatable error on calling a stored proc:
Warning: Packets out of order. Expected 15 received 1. Packet size=7 in /home/xxx/api.php on line 128
Warning: mysqli_next_result(): MySQL server has gone away in /home/xxxx/api.php on line 128
Warning: mysqli_next_result(): Error reading result set's header in /home/xxxx/api.php on line 128
I can repeatedly call the same stored proc without issue in a remote dbForge MySQL session so I know the proc is fully functional. The stored proc is creating a statement that is then executed - I think likely related.
Even though I have DEALLOCATE PREPARE stmt; the error is occurring when I make the same call again with the same resulting stmt call. If that call is different, I don't get the error.
Looks like this is the issue, although this references PDO - can you help with a fix?