for two days now I'm seeing occasional
"Mysql::Error: MySQL server has gone away:"
errors in my rails production logs.
The errors don't seem to be related to specific types of SQL queries (I saw them on INSERTs into the sessions table but also on small and large SELECTs on other tables of my app) but just seem to occur randomly.
I know there is another thread in the forums about that error but there the reason was related to large text fields or sendmail issues that shouldn't be the cause in my case (some of the affected queries don't contain text fields and mailing issues were also not affected).
I switched from FCGI to single-instance mongrel hosting a few days ago, could this cause timeouts towards the mysql server?
2 days ago I also set up this cronjob:
cd /home/username/appname ; /usr/local/bin/ruby ./script/runner 'CGI::Session::ActiveRecordStore::Session.destroy_all(["updated_at < ?", 1.day.ago ])' -e production
(username and appname changed)
could this have an effect on the issue?
Or does any of you habe other ideas what might be the reason for the errors?
I'd be really happy for any clues or help :-)!!!
Nils
