increment! and Mysql::Error: Lock

On a site I’m working on I started noticed a lot of production errors like this: ActiveRecord::StatementInvalid: Mysql::Error: Lock wait timeout exceeded; try restarting transaction: UPDATE users SET counter = 2, updated_at = ‘2010-08-05 20:54:26’ WHERE id = 1234 I traced the error back to a call in the user model: update_attribute(:start_time, DateTime.now) increment!(:counter) </pre>…