Mysql reconnect: mor: Unknown connection error: (2006) MySQL server has gone away.

From Kolmisoft Wiki
Jump to navigationJump to search

This error message appears when connection between MySQL database and MOR application app_mor.so timeouts.

Default timeout is 8h. Timeout happens when in 8h there are no requests to MySQL database.

app_mor.so automatically reconnects to MySQL database so there's no need to take any additional actions.





Another cause for this error could be caused by a query longer than the max_allowed_packet in /etc/my.cnf

Server dropped an incorrect or too large packet. If mysqld gets a packet that is too large or incorrect, it assumes that something has gone wrong with the client and closes the connection. You can increase the maximal packet size limit by increasing the value of max_allowed_packet in my.cnf file. Set max_allowed_packet = 100M then /etc/init.d/mysqld restart.

Retrieved from "https://wiki.kolmisoft.com/index.php?title=Mysql_reconnect:_mor:_Unknown_connection_error:_(2006)_MySQL_server_has_gone_away.&oldid=10045"