running problem in ofbiz12.04

[qj]

Hi ,
    I'm a programer and studying ofbiz now. I have set up ofbize12.04 and run it, but some errors occurred. I think there are more than one error in here , please help me to fix them.Thanks very much. I attached the log info in bellow:


2014-03-09 21:08:13,500 (OFBiz-config-1) [       DatabaseUtil.java:159:ERROR] Unable to establish a connection with the database for helperName [localmysqlolap]... Error was: java.sql.SQLException: Unable to acquire a new connection from the pool
2014-03-09 21:08:13,500 (OFBiz-config-1) [       DatabaseUtil.java:986:ERROR] Unable to establish a connection with the database, no additional information available.
2014-03-09 21:08:13,500 (OFBiz-config-1) [       DatabaseUtil.java:197:ERROR] Could not get table name information from the database, aborting.
2014-03-09 21:08:25,118 (OFBiz-config-1) [       DatabaseUtil.java:159:ERROR] Unable to establish a connection with the database for helperName [localmysqltenant]... Error was: java.sql.SQLException: Unable to acquire a new connection from the pool
 ****************  I'm sure the ofbize can connect my local database succssfully and  database  is ok ****************

2014-03-09 21:13:59,789 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------

2014-03-09 21:16:33,684 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------

2014-03-09 21:19:03,093 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------

2014-03-09 21:21:21,094 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------

2014-03-09 21:23:41,203 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------

2014-03-09 21:25:49,780 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------

2014-03-09 21:27:57,056 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------

2014-03-09 21:30:10,021 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------

2014-03-09 21:32:23,945 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------

2014-03-09 21:34:40,001 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------

2014-03-09 21:36:51,391 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------

2014-03-09 21:39:02,440 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:724)
--------------------------------------------------------------------------------
 ****************  I don't know why and when occured these errors****************




     

[Jacques Le Roux]

What is you entityengine.xml setting? (attachments don't get through here)

Jacques

Le 09/03/2014 17:04, qj a écrit :

> Hi ,
>     I'm a programer and studying ofbiz now. I have set up ofbize12.04 and run it, but some errors occurred. I think there are more than one error in here , please help me to fix them.Thanks very much. I attached the log info in bellow:
>
>
> 2014-03-09 21:08:13,500 (OFBiz-config-1) [       DatabaseUtil.java:159:ERROR] Unable to establish a connection with the database for helperName [localmysqlolap]... Error was: java.sql.SQLException: Unable to acquire a new connection from the pool
> 2014-03-09 21:08:13,500 (OFBiz-config-1) [       DatabaseUtil.java:986:ERROR] Unable to establish a connection with the database, no additional information available.
> 2014-03-09 21:08:13,500 (OFBiz-config-1) [       DatabaseUtil.java:197:ERROR] Could not get table name information from the database, aborting.
> 2014-03-09 21:08:25,118 (OFBiz-config-1) [       DatabaseUtil.java:159:ERROR] Unable to establish a connection with the database for helperName [localmysqltenant]... Error was: java.sql.SQLException: Unable to acquire a new connection from the pool
>  ****************  I'm sure the ofbize can connect my local database succssfully and  database  is ok ****************
>
> 2014-03-09 21:13:59,789 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>
> 2014-03-09 21:16:33,684 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>
> 2014-03-09 21:19:03,093 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>
> 2014-03-09 21:21:21,094 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>
> 2014-03-09 21:23:41,203 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>
> 2014-03-09 21:25:49,780 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>
> 2014-03-09 21:27:57,056 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>
> 2014-03-09 21:30:10,021 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>
> 2014-03-09 21:32:23,945 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>
> 2014-03-09 21:34:40,001 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>
> 2014-03-09 21:36:51,391 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>
> 2014-03-09 21:39:02,440 (org.ofbiz.service.job.JobPoller@d78ab8) [         JobManager.java:200: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:267)
> org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:253)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:196)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Thread.java:724)
> --------------------------------------------------------------------------------
>  ****************  I don't know why and when occured these errors****************
>
>
>
>
>      

[TheCreativeStory]

I have a similar issue that was posted here. My Issue is coming from a Solr Indexing that runs for 7 hours and then hits a wall with this error. I have 150k products in my database and many categories.

What is the default time out for jobs in OFBIZ?

My thought is that its this:  " protected static final int DEFAULT_TIMEOUT = 600;" which is in
package org.apache.geronimo.transaction.manager; " but this is a total guess

---- exception report ----------------------------------------------------------
Could not commit transaction: 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.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:425)