Frederick Cheung wrote: > change the value of config.active_record.verification_timeout to > something below whatever timeout your mysql timeout is set to.
It was also suggested elsewhere http://stackoverflow.com/questions/131481/preventing-mongrelmysql-errnoepipe-exceptions that I do the following: (full advice is at https://boxpanel.blueboxgrp.com/public/the_vault/index.php/Mongrel_/_MySQL_Timeout ) # Set the verification timeout so that the mongrel connection won't die if left alone (1 week) ActiveRecord::Base.verification_timeout = 604800 # Keep Connection Open Thread.new { loop { ActiveRecord::Base.verify_active_connections!; 1800.times { sleep 2 } } }.priority = -10 and also (in mysql.cnf) # Fix for bug where mongrel doesn't close timed-out connections: Just don't time out connections. wait_timeout= 3456000 Why is that thread calling verify_active_connections! needed if verification_timeout < wait_timeout ? -- Mike Berrow -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
