Any help is very much appreciated.
MySQL 5.0 and Rails 1.2.6
I have a Deamon process that looks for incoming mail using pop3. It all works smashing, except after a day or so, the process starts throwing this error every time it tries to talk to my database.
Mysql::Error: Lost connection to MySQL server during query: SELECT * FROM incoming_email_messages WHERE (incoming_email_messages.name = 'UID26-1219353451') LIMIT 1
I have 4 rails instances running in a mongrel pack as well as 5 other daemon processes all talking to the same database. They never experience this loss of connectivity. The issue seems to be around my repeated calls to the Ruby pop3 library. I suspect that this is some kind of memory or garbage collection issue, but I don't know for sure. Right now, I have to bounce my thread once a day to snap it out of it. I tried moving the Net::POP3.new call outside the loop and just calling start/finish on the same object but that just make it stop working altogether.
Here is the thread
#!/usr/bin/env ruby
