[Rails] Re: ActiveRecord::StatementInvalid: Mysql::Error: Lock wait timeout exceeded

2010-03-17 Thread Frederick Cheung
On Mar 17, 8:39 am, Ram wrote: > Thanks Fred! > > I have a staging server where I could deploy this. But I need to > reproduce the lockdown. Any hacks that I can use for that? > > The tables are all quite small and there are no large db queries that > could be causing this that I know of. Will c

[Rails] Re: ActiveRecord::StatementInvalid: Mysql::Error: Lock wait timeout exceeded

2010-03-17 Thread Ram
Thanks Fred! I have a staging server where I could deploy this. But I need to reproduce the lockdown. Any hacks that I can use for that? The tables are all quite small and there are no large db queries that could be causing this that I know of. Will crawl through the rails logs and see if I can f

[Rails] Re: ActiveRecord::StatementInvalid: Mysql::Error: Lock wait timeout exceeded

2010-03-17 Thread Frederick Cheung
On Mar 17, 6:12 am, Ram wrote: > Hi all, > > Ive been getting this error on one particular query repeatedly for the > past few days. > > ActiveRecord::StatementInvalid: Mysql::Error: Lock wait timeout > exceeded; try restarting transaction: UPDATE `posts` SET `updated_at` > = '2010-03-17 05:35:0