Error

[Gavin Mabie]

Hi

 

Why would I get this error.  I get it every time I start ofbiz - and this
without event logging on or opening ofbiz in a browser.  I am running 09.04.

 

 

 (org.ofbiz.service.job.JobPoller@3fb6772a) [ 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(TransactionIm
pl.java:269)
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(Transa
ctionManagerImpl.java:245)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:209
)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:195
) org.ofbiz.service.job.JobManager.poll(JobManager.java:197)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Unknown Source)
----------------------------------------------------------------------------
----

 

Thanks

 

[BJ Freeman]

based on
Exception: javax.transaction.RollbackException Message: Transaction timeout

would say the Database is not responding in time
not enough info to see what may be causing it.


=========================
BJ Freeman  <http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


Gavin Mabie sent the following on 9/12/2010 6:44 AM:
> Exception: javax.transaction.RollbackException Message: Transaction timeout

[pankaj savita]

Hi Gavin,

  These are scheduled jobs running by internal quartz job store of ofbiz. In
'org.ofbiz.service.job.JobPoller' class there is run() method
  which calls poll() method of 'org.ofbiz.service.job.JobManager' class. In
JobManager poll() method there in an update query fired on JOB_SANDBOX
  entity with current date time, since no record present in the entity of
current date time causes this error while committing the Transaction.

  I found a workaround for this problem, you can comment the entire code
inside of run() method of 'JobPoller' class, so that it
  will not call 'JobManager' poll() method. Now create a build of ofbiz
using ant run-install & use ofbiz.jar created with modified code.
  You will not see this Error. But it's a workaround. Can anyone provide a
fix for this into the trunk.

>
--
Thanks & Regards,
Pankaj Savita
Mob: [phone]
Mail to: [hidden email]


On Sun, Sep 12, 2010 at 7:14 PM, Gavin Mabie <[hidden email]>wrote:

> Hi
>
>
>
> Why would I get this error.  I get it every time I start ofbiz - and this
> without event logging on or opening ofbiz in a browser.  I am running
> 09.04.
>
>
>
>
>
>  (org.ofbiz.service.job.JobPoller@3fb6772a) [ 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(TransactionIm
> pl.java:269)
>
> org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(Transa
> ctionManagerImpl.java:245)
>
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:209
> )
>
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:195
> ) org.ofbiz.service.job.JobManager.poll(JobManager.java:197)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Unknown Source)
>
> ----------------------------------------------------------------------------
> ----
>
>
>
> Thanks
>
>
>
>

[faloameme]

Error occurs when JobSandbox is empty edit JobManager.java poll() method

// check for jobs before updating any
List<GenericValue> jobEnt = delegator.findByAnd("JobSandbox", updateFields, order);
if (jobEnt.size() > 0) {
        // first update the jobs w/ this instance running information
        delegator.storeByCondition("JobSandbox", updateFields, mainCondition);
                       
};
        // now query all the 'queued' jobs for this instance
        jobEnt = delegator.findByAnd("JobSandbox", updateFields, order);