Hello,
I just tried to use scheduler.py with MySQL instead of SQLite and ran
into this error:
NotSupportedError: (1235, "This version of MySQL doesn't yet support
'LIMIT & IN/ALL/ANY/SOME subquery'")
The MySQL server version is 5.0.77. Searching on the web, it seems
this limitation is common. Is there a way to work around the issue?
The offending SQL looks like this:
UPDATE task_scheduled SET
status='running',assigned_worker_name='crabby#237cf3f0-89e7-4db5-
b514-56db27a700d5',last_run_time='2011-08-13 09:33:01' WHERE
(task_scheduled.id IN (SELECT task_scheduled.id FROM task_scheduled
WHERE (((((task_scheduled.enabled = 'T') AND (task_scheduled.status =
'queued')) AND (task_scheduled.group_name IN ('command','main'))) AND
(task_scheduled.next_run_time < '2011-08-13 09:33:01')) AND
(((task_scheduled.assigned_worker_name = '') OR
(task_scheduled.assigned_worker_name IS NULL)) OR
(task_scheduled.assigned_worker_name = 'crabby#237cf3f0-89e7-4db5-
b514-56db27a700d5'))) ORDER BY task_scheduled.next_run_time LIMIT 1
OFFSET 0));
I'm pretty sure this is coming from the massively complex query in
assign_next_task.
Thanks,
G
