Skip to content

Packets out of order #9

@ratsey

Description

@ratsey

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?

https://stackoverflow.com/questions/19389809/packets-out-of-order-error-when-calling-mysql-stored-proc/30275001

Metadata

Metadata

Assignees

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions