Sporadically getting error Mysql::Error: Lost connection

rubyonrails-talk
1

Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS FROM groups_rights

there's a gem to workaround this problem: google 'mysql_retry_lost_connection'.

hiro

2

It could be something else that I was experiencing also. Does your program make concurrent threads? If it does, make sure you create a semaphore because there is a know bug in webrick that leads to Mysql Lost connection. http://wiki.rubyonrails.org/rails/pages/HowTosWorkerThreads

3

I put a debug in the mysql_adapter and indeed the ruby version of mysql is being used.

I just need to figure out why - it has something to do with the RubyWorks Production Stack installation. I did not use this on my RHEL 3 machine - so, that explains why its working OK there.

Thanks for all your help so far!