Error 1160: Got an error writing communication packets

Possible Causes

This error tells us that the connection between the server and client was aborted. The most common cause is that the client hard-aborted the connection, without calling mysql_close(). It could also be a problem with the connection to the server, such as a wrong or lost package.

How to Find Out More

The may have more information about the cause of the error. Setting the MariaDB server option to a value of 4 or above can generate more diagnostic warnings in the error log when there is a problem reading packages:

How to interpret the above:

• 5461 is the connection id that got the warning/error.

• fd: 406 406 is the file descriptor that had a problem.

• state: 2

You can use the perror utility to get a description of system and storage engine errors:

This means the connection was aborted by the application/user.

How to Fix

• Ensure you have a stable internet connection.

• Ensure that your applications calls mysql_close() for all open connections before exiting.

See Also

• Getting a description for an error number.

_{This page is licensed: CC BY-SA / Gnu FDL}