schedule_fu locks mysql up

I've been using schedule_fu for recurring events but I keep getting this Mysql::Error: Lock wait timeout excedded.

Anyone else experienced this problem or do you know what causes a Mysql::Error like this.

I'm using Rails 2 and developing on OS X.

SQL (0.1ms)   BEGIN
SQL (0.1ms)   SAVEPOINT active_record_1
CalendarDate Create (0.0ms)   Mysql::Error: Lock wait timeout exceeded; try restarting transaction: INSERT INTO `calendar_dates` (`month`, `lastweek`, `value`, `monthday`, `monthweek`, `weekday`) VALUES(11, 0, '2010-11-01', 1, 0, 1)
CalendarEventType Create (0.1ms)   INSERT INTO `calendar_event_types` (`name`, `desc`) VALUES('weekdays', 'Weekdays (M-F)')
SQL (0.6ms)   ROLLBACK

Here are my Mysql server variables; not sure if adjusting one of these would fix the problem.

connect_timeout = 10
delayed_insert_timeout = 300
innodb_lock_wait_timeout = 50
innodb_rollback_on_timeout = OFF
interactive_timeout = 28800
net_read_timeout = 30
net_write_timeout = 60
slave_net_timeout = 3600
table_lock_wait_timeout = 50
wait_timeout = 28800

Thanks for your help!

ansaurus

tags:

views:

answers:

schedule_fu locks mysql up

related questions