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>…

Doggie Shed

We’re visiting my parents in Idaho for the weekend so that the kids can go to my grandmother’s house to hunt Easter eggs. It’s a long story that involves who can be in town when and cousins that are travelling to Texas and stuff. Anyway, the kids spent the day playing in the yard with…

acts_as_taggable libraries and the big case problem.

Over the years I’ve had a chance to use the three tagging libraries available for Ruby on Rails: acts-as-taggable-on acts_as_taggable_on_steroids acts_as_taggable I think the original acts as taggable is now defunct. The other libraries are derivatives of that library. In using tags on various sites the problem I always seem to run across is how…