Hi everyone,<div><br></div><div>I have been trying to solve this problem for quite some time now and I really don't have any further clue to investigate.</div><div><br></div><div>I am running a mongrel_cluster 1.0.5-2 (mongrel verison : 1.1.5-5) on a ubuntu box with apache2 2.2.12-1ubuntu2.1</div>
<div><br></div><div>I have 4 different apps on the same box and each app has two mongrel instances.</div><div><br></div><div>After a short period of time ( < 2 hours ) some of the 8 mongrel instances just stop responding.</div>
<div><br></div><div>I read the mongrel FAQ and tried to set ActiveRecord::Base.verification_timeout = 14400 (the mysql parameter is set to the default 28800) in myapp/config/environments/production.rb</div><div><br></div>
<div>The problem kept happening.</div><div><br></div><div>I decided to lower that number, making it 60.</div><div>No more success.</div><div><br></div><div>I installed gdb and the ruby macros to make sure i was in the mysql driver while hanging and sure enough, here is the top of the BT from GDB :</div>
<div><br></div><div><div>/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:264:in `active?'", </div><div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:136:in `verify!'", </div>
<div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:256:in `checkout_and_verify'", </div><div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:252:in `checkout_existing_connection'", </div>
<div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:186:in `checkout'", </div><div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `loop'", </div>
<div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `checkout'", </div><div>"/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'", </div>
<div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in `checkout'", </div><div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in `connection'", </div>
<div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in `retrieve_connection'", </div><div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:121:in `retrieve_connection'", </div>
<div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:113:in `connection'", </div><div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:2934:in `quoted_table_name'", </div>
<div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1626:in `construct_finder_sql'", </div><div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1490:in `find_every'", </div>
<div>"/var/lib/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:589:in `find'", </div></div><div><br></div><div>I figured that since I was running a packaged version of mongrel_cluster (not the gem installed one), I should use the package version of mysql driver for ruby.</div>
<div>So i did</div><div>gem uninstall mysql</div><div><br></div><div>and installed :</div><div>apt-get install libmysql-ruby1.8</div><div><br></div><div>I then restarted the mongrels and sure enough after 1h25 one of them was hanging in the mysql_adapter.rb, showing the same backtrace as before.</div>
<div><br></div><div>I really am out of clue here and any advice / help would be much appreciated.</div><div><br></div><div>I have to note that I am far from being an ROR guru and maybe the solution to my problem is simpler than what I have been looking for, but I just don't know where to look anymore.</div>
<div><br></div><div>Thanks for any advice / answer</div><div><br></div><div>Damien</div><div><br></div><div><br></div>