Error While Sending Query Packet

MARIADB - Error while sending QUERY packet (not max_allowed_packet)

1 minute after asking it, I've answered my own question. This was the issue:

wait_timeout=10

My previous hosting configuration had =180 which make my poorly written script work. Under the =10 it's just not long enough for the task to complete. I have lengthened it to 180 now but should really add handle for this.

Error while sending QUERY packet. PID=9565

thanks every one . Problem was solved the issue is one of my developer making wrong recursive function that's why more memory allocated

MySQL: Error while sending QUERY packet. PID=2

When you use a pattern like

prepare mysql query a
execute mysql query a
for each row in result set a
    prepare mysql query b
    execute mysql quer b

you must use a separate db connection for mysql query b. Why? query a can still be using its connection as long as you're reading rows from its result set.

---

Related Topics