DJabberd does not handle "MySQL server has gone away at"

Erik Osterman e at osterman.com
Thu Aug 23 23:51:36 UTC 2007


Anytime our database server gets restarted or when the djabberd server 
has remained idle for an extended period of time (usually when we all go 
home from work), the database connection to MySQL dies.

DBD::mysql::db selectrow_array failed: MySQL server has gone away at 
/usr/src/djabberd/trunk/DJabberd/../DJabberd-Authen-MySQL/lib/DJabberd/Authen/MySQL.pm 
line 131.
ERROR DJabberd.Connection.ClientIn             1605 disconnected 
DJabberd::Connection::ClientIn=ARRAY(0x9e03fbc) because: DBD::mysql::db 
selectrow_array failed: MySQL server has gone away at 
/usr/src/djabberd/trunk/DJabberd/../DJabberd-Authen-MySQL/lib/DJabberd/Authen/MySQL.pm 
line 131.


Aside from removing the timeout limits in the my.cnf (which only 
addresses the latter issue), is there something I can do to prevent this 
from happening?

Best,


Erik



More information about the Djabberd mailing list