[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