On 22 February 2010 23:22, Pratik Bhatt <[email protected]> wrote: > Hello Everyone, > > I just wanted to check, if there was any way to disable or defer the > deletion of entries from the ode_jobs table, maybe through a configuration > setting. > > From what I understand, the deletion of records is more of housekeeping, and > not something that needs to happen immediately. I am enquiring about it > because, the delete queries are causing a lot of deadlocks anytime we run a > large number of threads in parallel. > > Thanks for the help in advance.
There is no way to configure such behaviour. If you really want to do this, you can modify scheduler-simple/src/main/java/org/apache/ode/scheduler/simple/JdbcDelegate.java. But could you provide your configuration? Is it Derby embedded database? If so, it's known problem and we are working on migrating to H2 database to resolve this (http://issues.apache.org/jira/browse/ODE-666). You can switch to MySQL or Oracle as well. This should help. Regards, -- Rafał Rusin http://rrusin.blogspot.com http://www.touk.pl http://top.touk.pl
