ERROR 2006 (HY000): MySQL server has gone away

Question

I'm encountering the Error #2006 when inserting data into a table (ERROR
2006 (HY000): MySQL server has gone away). Each time after the same amount
of rows have been successfully added the mysql client window shows me this
error.

The mysql client then tries to reconnect but with the same error message. I already set max_allowed_packet=16M;  delayed_insert_timeout=10000;= connect_timeout=100000; and continue to get the same error..

Help please.

Answer 1

Based on my experience, this error mostly happens when the client package is more than the max_allowed_packet..

Try increasing max_allowed_packet or reducing the amount of data you are inserting in one operation to validate the root cause.

Answer 2

Yep, this is a clear case of wrongly sized max packet size. Increase it and test, it should work.