[web2py] Re: Database deadlocks with new scheduler

2012-02-29 Thread David Phillips
Thanks for the advice, Massimo. Yes, I am calling db.scheduler_task.insert() inside a controller. On the theory that it could do harm, I put a db.commit() immediately after the insert and that helped, some. Now I'm getting the scheduler exception in my worker process about a third as often, and

[web2py] Re: Database deadlocks with new scheduler

2012-02-27 Thread Massimo Di Pierro
Do you do this in a controller? db.scheduler_task.insert(...) if not. Make sure you db.commit() immediately after. Would is solve the problem? On Feb 27, 9:14 pm, David Phillips wrote: > I am experiencing database deadlocks in a worker processes that is > being scheduled by web2py's new schedul