[Ruby] Active Record looses connection to mySQL

Daevid Vincent daevid at daevid.com
Fri May 11 18:18:26 PDT 2007


It seems that after some amount of time 
(not really sure the duration, more than an hour, less than a day), 
my service just shits the bed because it looses connection to mySQL.
mySQL mind you is perfectly happy and hasn't done anything wrong,
and all my PHP pages work fantastic. 

If I restart my ruby application, it runs perfect... until AR times out again. 
*sigh*

It's extremely frustrating. 
Anyone know anything about this?  
Is it even a known issue that is to be addressed?
Is there a work-around/patch?


-----Original Message-----
From: Support [mailto:support at symcell.com] 
Sent: None
To: Support
Subject: Service STB

Service has S.T.B. Please restart it A.S.A.P.

An exception has occured: 
Mysql::Error: Lost connection to MySQL server during query: INSERT INTO logs (`created_on`, `body`, `target_id`, `type`, `user_id`)
VALUES('2007-05-09 03:13:27', 'My log message here.', NULL, 'Logout', NULL) (ActiveRecord::StatementInvalid)

Backtrace:
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract_adapter.rb:120:in
`log'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:184:in
`execute'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:194:in
`insert'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1739:in
`create_without_callbacks'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/callbacks.rb:265:in
`create_without_timestamps'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/timestamp.rb:30:in
`create'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1718:in
`create_or_update_without_callbacks'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/callbacks.rb:253:in
`create_or_update'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1392:in
`save_without_validation'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/validations.rb:736:in
`save_without_transactions'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/transactions.rb:126:in
`save'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/database_statements.rb:51:in
`transaction'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/transactions.rb:91:in
`transaction'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/transactions.rb:118:in
`transaction'/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/transactions.rb:126:in 
[snip]



More information about the Ruby mailing list