Brett, Can you please explain what you mean by archiving the current JobSandbox first? Do you mean somehow removing the current pending jobs, applying you patch and the copying them back again?
Thanks, On Wed, Jul 13, 2011 at 12:08 PM, Brett Palmer <[email protected]> wrote: > Josh, > > I've also seen this problem if the JobSandbox table has too many rows to > process. I ran into a similar problem when I tried to run 10,000 Async > batch processes. The time it took for the JobPoller to process all the > records was too long and the transaction would time out. > > I had a patch to change the transaction timeout for the JobPoller > specifically as it wasn't available in ofbiz at the time, but I don't think > I ever submitted it. I could look for this patch if anyone is interested > but it may already be implemented in the framework. > > I would try archiving jobs from the JobSandbox first. > > > Brett > > On Wed, Jul 13, 2011 at 12:48 PM, Josh Jacobson > <[email protected]>wrote: > >> Hello Everyone, >> >> I have an ofbiz instance in production where none of the jobs are >> being performed. I have about 160K jobs in pending status, but they >> are never being schedule. >> I can see the following in the log: >> >> 2011-07-13 13:32:01,959 (org.ofbiz.service.job.JobPoller@2599930b) [ >> JobManager.java:201:ERROR] ---- exception report >> ---------------------------------------------------------- Transaction >> error trying to commit when polling and updating the JobSandbox: >> org.ofbiz.entity.transaction.GenericTransactionException: Roll back >> error (with no rollbackOnly cause found), could not commit >> transaction, was rolled back instead: >> javax.transaction.RollbackException: Transaction timeout (Transaction >> timeout) Exception: >> org.ofbiz.entity.transaction.GenericTransactionException Message: Roll >> back error (with no rollbackOnly cause found), could not commit >> transaction, was rolled back instead: >> javax.transaction.RollbackException: Transaction timeout (Transaction >> timeout) ---- cause >> --------------------------------------------------------------------- >> Exception: javax.transaction.RollbackException Message: Transaction >> timeout ---- stack trace >> --------------------------------------------------------------- >> javax.transaction.RollbackException: Transaction timeout >> >> org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:269) >> >> org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:245) >> >> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:259) >> >> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:245) >> org.ofbiz.service.job.JobManager.poll(JobManager.java:197) >> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) >> java.lang.Thread.run(Thread.java:619) >> >> -------------------------------------------------------------------------------- >> >> I believe that the JobManager is not being able to handle all those >> jobs to schedule them, so nothing is being scheduled, which of course >> make the job list longer. >> >> Can anyone think of how to make the jobs run? >> >> All help much appreciated, >> >> -- >> Josh. >> >
