You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by maburger <ma...@bertelsmann.de> on 2008/06/30 12:05:07 UTC
Problem with JobSanbox lock on (MySQL and/or ORACLE)
Hi *,
we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an error
within the JobManager.poll method. It seems like a DB lock is set on the
JOB_SANBOX table, so the JobManager is not abled to execute the store
operation. Has anyone ever had a similar problem or is this a known bug?
We are using the last 3.x OFBiz release.
Thanks for every reply!
Here's the Stacktrace (The corresponding MySQL error is a "lock wait timeout
exceeded"):
2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
org.ofbiz.entity.GenericDelegator - Failure in storeByCondition operation
for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
Generic Entity Exception occured in updateByCondition (SQL Exception while
executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID
= ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
transaction.
org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
occured in updateByCondition (SQL Exception while executing the
following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
at
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
at java.lang.Thread.run(Thread.java:595)
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
at
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
at java.lang.Thread.run(Thread.java:595)
java.sql.SQLException: Io exception: Connection timed out
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
at
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
at java.lang.Thread.run(Thread.java:595)
2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] WARN
org.ofbiz.entity.transaction.TransactionUtil -
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
stack trace shows where this is happening:
java.lang.Exception: Failure in storeByCondition operation for entity
[JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity
Exception occured in updateByCondition (SQL Exception while executing the
following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
transaction.
at
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
at
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
at java.lang.Thread.run(Thread.java:595)
2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
occured in updateByCondition (SQL Exception while executing the
following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
at
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
at java.lang.Thread.run(Thread.java:595)
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
at
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
at java.lang.Thread.run(Thread.java:595)
java.sql.SQLException: Io exception: Connection timed out
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
at
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
at
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
at
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
at java.lang.Thread.run(Thread.java:595)
--
View this message in context: http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18192378.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by Heidi Dehaes <in...@gmail.com>.
Ok i use release 4 branch ofbiz (not the trunk version);
So i probably use only Geronimo.
but i don't know details about this transaction tool and connection pools, etc.
Heidi
2008/7/1, BJ Freeman <bj...@free-man.net>:
> DBCPConnectionFactory was added rev 586666
> .
> only bug fixes happen in the 4.0 branch.
> BDCP is not considered a bug fix.
>
> Note: if you do a search of DBCPConnectionFactory
> in the commits mailing list you will find the commits.
>
> maburger sent the following on 7/1/2008 3:00 AM:
> > Could you tell me when this change is applied to the 4.0 branch?
> >
> >
> > BJ Freeman wrote:
> >> DBCP is a change that happened in the Trunk version.
> >>
> >>
> >> Heidi Dehaes sent the following on 7/1/2008 2:29 AM:
> >>> I am using the geronimo DBCP i think.
> >>>
> >>> Heidi
> >>>
> >>> 2008/7/1, maburger <ma...@bertelsmann.de>:
> >>>> Are you using the DBCP or the "old" Minerva pool implementation?
> >>>>
> >>>>
> >>>> Heidi Dehaes wrote:
> >>>>> Yes, I have it also from time to time with version 4.x from OFBIZ.
> >>>>> But i have no details at the moment.
> >>>>> In every case when this happens i have to restart the java application.
> >>>>>
> >>>>> Heidi
> >>>>> http://www.olagos.eu
> >>>>>
> >>>>>
> >>>>> 2008/6/30, maburger <ma...@bertelsmann.de>:
> >>>>>> Hi *,
> >>>>>>
> >>>>>> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
> >>>>>> error
> >>>>>> within the JobManager.poll method. It seems like a DB lock is set on
> >>>>>> the
> >>>>>> JOB_SANBOX table, so the JobManager is not abled to execute the store
> >>>>>> operation. Has anyone ever had a similar problem or is this a known
> >>>>>> bug?
> >>>>>>
> >>>>>> We are using the last 3.x OFBiz release.
> >>>>>>
> >>>>>> Thanks for every reply!
> >>>>>>
> >>>>>> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
> >>>>>> timeout
> >>>>>> exceeded"):
> >>>>>>
> >>>>>>
> >>>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
> >>>>>> ERROR
> >>>>>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition
> >>>>>> operation
> >>>>>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
> >>>>>> Generic Entity Exception occured in updateByCondition (SQL Exception
> >>>>>> while
> >>>>>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
> >>>>>> RUN_BY_INSTANCE_ID
> >>>>>> = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL
> >>>>>> AND
> >>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
> >>>>>> IS
> >>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling
> >>>>>> back
> >>>>>> transaction.
> >>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> >>>>>> occured in updateByCondition (SQL Exception while executing the
> >>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> >>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
> >>>>>> IS
> >>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> >>>>>> executing
> >>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
> >>>>>> ?,
> >>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
> >>>>>> IS
> >>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> >>>>>> at
> >>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>>> java.sql.SQLException: Io exception: Connection timed out
> >>>>>> at
> >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> >>>>>> at
> >>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> >>>>>> at
> >>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
> >>>>>> WARN
> >>>>>> org.ofbiz.entity.transaction.TransactionUtil -
> >>>>>> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
> >>>>>> this
> >>>>>> stack trace shows where this is happening:
> >>>>>> java.lang.Exception: Failure in storeByCondition operation for entity
> >>>>>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic
> >>>>>> Entity
> >>>>>> Exception occured in updateByCondition (SQL Exception while executing
> >>>>>> the
> >>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> >>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
> >>>>>> IS
> >>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling
> >>>>>> back
> >>>>>> transaction.
> >>>>>> at
> >>>>>> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
> >>>>>> at
> >>>>>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>>> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787]
> >>>>>> ERROR
> >>>>>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
> >>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> >>>>>> occured in updateByCondition (SQL Exception while executing the
> >>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> >>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
> >>>>>> IS
> >>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> >>>>>> executing
> >>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
> >>>>>> ?,
> >>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
> >>>>>> IS
> >>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> >>>>>> at
> >>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>>> java.sql.SQLException: Io exception: Connection timed out
> >>>>>> at
> >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> >>>>>> at
> >>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> >>>>>> at
> >>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> >>>>>> at
> >>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >>>>>> at
> >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>>> at
> >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>>> --
> >>>>>> View this message in context:
> >>>>>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18192378.html
> >>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>>>>>
> >>>>>>
> >>>> --
> >>>> View this message in context:
> >>>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18212363.html
> >>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>>>
> >>>>
> >>>
> >>>
> >>
> >>
> >
>
>
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by BJ Freeman <bj...@free-man.net>.
DBCPConnectionFactory was added rev 586666
.
only bug fixes happen in the 4.0 branch.
BDCP is not considered a bug fix.
Note: if you do a search of DBCPConnectionFactory
in the commits mailing list you will find the commits.
maburger sent the following on 7/1/2008 3:00 AM:
> Could you tell me when this change is applied to the 4.0 branch?
>
>
> BJ Freeman wrote:
>> DBCP is a change that happened in the Trunk version.
>>
>>
>> Heidi Dehaes sent the following on 7/1/2008 2:29 AM:
>>> I am using the geronimo DBCP i think.
>>>
>>> Heidi
>>>
>>> 2008/7/1, maburger <ma...@bertelsmann.de>:
>>>> Are you using the DBCP or the "old" Minerva pool implementation?
>>>>
>>>>
>>>> Heidi Dehaes wrote:
>>>>> Yes, I have it also from time to time with version 4.x from OFBIZ.
>>>>> But i have no details at the moment.
>>>>> In every case when this happens i have to restart the java application.
>>>>>
>>>>> Heidi
>>>>> http://www.olagos.eu
>>>>>
>>>>>
>>>>> 2008/6/30, maburger <ma...@bertelsmann.de>:
>>>>>> Hi *,
>>>>>>
>>>>>> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
>>>>>> error
>>>>>> within the JobManager.poll method. It seems like a DB lock is set on
>>>>>> the
>>>>>> JOB_SANBOX table, so the JobManager is not abled to execute the store
>>>>>> operation. Has anyone ever had a similar problem or is this a known
>>>>>> bug?
>>>>>>
>>>>>> We are using the last 3.x OFBiz release.
>>>>>>
>>>>>> Thanks for every reply!
>>>>>>
>>>>>> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
>>>>>> timeout
>>>>>> exceeded"):
>>>>>>
>>>>>>
>>>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>>> ERROR
>>>>>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition
>>>>>> operation
>>>>>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
>>>>>> Generic Entity Exception occured in updateByCondition (SQL Exception
>>>>>> while
>>>>>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
>>>>>> RUN_BY_INSTANCE_ID
>>>>>> = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL
>>>>>> AND
>>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>>> IS
>>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling
>>>>>> back
>>>>>> transaction.
>>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>>>> occured in updateByCondition (SQL Exception while executing the
>>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>>> IS
>>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>>>> executing
>>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
>>>>>> ?,
>>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>>> IS
>>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>>>> at
>>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> java.sql.SQLException: Io exception: Connection timed out
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>>>> at
>>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>>>> at
>>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>>>> at
>>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>>>> at
>>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>>>> at
>>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>>>> at
>>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>>> WARN
>>>>>> org.ofbiz.entity.transaction.TransactionUtil -
>>>>>> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
>>>>>> this
>>>>>> stack trace shows where this is happening:
>>>>>> java.lang.Exception: Failure in storeByCondition operation for entity
>>>>>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic
>>>>>> Entity
>>>>>> Exception occured in updateByCondition (SQL Exception while executing
>>>>>> the
>>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>>> IS
>>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling
>>>>>> back
>>>>>> transaction.
>>>>>> at
>>>>>> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
>>>>>> at
>>>>>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>>> ERROR
>>>>>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
>>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>>>> occured in updateByCondition (SQL Exception while executing the
>>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>>> IS
>>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>>>> executing
>>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
>>>>>> ?,
>>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>>> IS
>>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>>>> at
>>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> java.sql.SQLException: Io exception: Connection timed out
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>>>> at
>>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>>>> at
>>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>>>> at
>>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>>>> at
>>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>>>> at
>>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>>>> at
>>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> --
>>>>>> View this message in context:
>>>>>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18192378.html
>>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>>
>>>>>>
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18212363.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>>
>>>
>>>
>>
>>
>
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by maburger <ma...@bertelsmann.de>.
Could you tell me when this change is applied to the 4.0 branch?
BJ Freeman wrote:
>
> DBCP is a change that happened in the Trunk version.
>
>
> Heidi Dehaes sent the following on 7/1/2008 2:29 AM:
>> I am using the geronimo DBCP i think.
>>
>> Heidi
>>
>> 2008/7/1, maburger <ma...@bertelsmann.de>:
>>> Are you using the DBCP or the "old" Minerva pool implementation?
>>>
>>>
>>> Heidi Dehaes wrote:
>>>> Yes, I have it also from time to time with version 4.x from OFBIZ.
>>>> But i have no details at the moment.
>>>> In every case when this happens i have to restart the java application.
>>>>
>>>> Heidi
>>>> http://www.olagos.eu
>>>>
>>>>
>>>> 2008/6/30, maburger <ma...@bertelsmann.de>:
>>>>> Hi *,
>>>>>
>>>>> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
>>>>> error
>>>>> within the JobManager.poll method. It seems like a DB lock is set on
>>>>> the
>>>>> JOB_SANBOX table, so the JobManager is not abled to execute the store
>>>>> operation. Has anyone ever had a similar problem or is this a known
>>>>> bug?
>>>>>
>>>>> We are using the last 3.x OFBiz release.
>>>>>
>>>>> Thanks for every reply!
>>>>>
>>>>> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
>>>>> timeout
>>>>> exceeded"):
>>>>>
>>>>>
>>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>> ERROR
>>>>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition
>>>>> operation
>>>>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
>>>>> Generic Entity Exception occured in updateByCondition (SQL Exception
>>>>> while
>>>>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
>>>>> RUN_BY_INSTANCE_ID
>>>>> = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL
>>>>> AND
>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>> IS
>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling
>>>>> back
>>>>> transaction.
>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>>> occured in updateByCondition (SQL Exception while executing the
>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>> IS
>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>>> executing
>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
>>>>> ?,
>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>> IS
>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>>> at
>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> java.sql.SQLException: Io exception: Connection timed out
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>>> at
>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>>> at
>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>>> at
>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>>> at
>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>>> at
>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>>> at
>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>> WARN
>>>>> org.ofbiz.entity.transaction.TransactionUtil -
>>>>> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
>>>>> this
>>>>> stack trace shows where this is happening:
>>>>> java.lang.Exception: Failure in storeByCondition operation for entity
>>>>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic
>>>>> Entity
>>>>> Exception occured in updateByCondition (SQL Exception while executing
>>>>> the
>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>> IS
>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling
>>>>> back
>>>>> transaction.
>>>>> at
>>>>> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
>>>>> at
>>>>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>> ERROR
>>>>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>>> occured in updateByCondition (SQL Exception while executing the
>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>> IS
>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>>> executing
>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
>>>>> ?,
>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>> IS
>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>>> at
>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> java.sql.SQLException: Io exception: Connection timed out
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>>> at
>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>>> at
>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>>> at
>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>>> at
>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>>> at
>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>>> at
>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> --
>>>>> View this message in context:
>>>>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18192378.html
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>>
>>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18212363.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>>
>>
>>
>
>
>
--
View this message in context: http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18212984.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by BJ Freeman <bj...@free-man.net>.
DBCP is a change that happened in the Trunk version.
Heidi Dehaes sent the following on 7/1/2008 2:29 AM:
> I am using the geronimo DBCP i think.
>
> Heidi
>
> 2008/7/1, maburger <ma...@bertelsmann.de>:
>> Are you using the DBCP or the "old" Minerva pool implementation?
>>
>>
>> Heidi Dehaes wrote:
>>> Yes, I have it also from time to time with version 4.x from OFBIZ.
>>> But i have no details at the moment.
>>> In every case when this happens i have to restart the java application.
>>>
>>> Heidi
>>> http://www.olagos.eu
>>>
>>>
>>> 2008/6/30, maburger <ma...@bertelsmann.de>:
>>>> Hi *,
>>>>
>>>> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
>>>> error
>>>> within the JobManager.poll method. It seems like a DB lock is set on the
>>>> JOB_SANBOX table, so the JobManager is not abled to execute the store
>>>> operation. Has anyone ever had a similar problem or is this a known bug?
>>>>
>>>> We are using the last 3.x OFBiz release.
>>>>
>>>> Thanks for every reply!
>>>>
>>>> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
>>>> timeout
>>>> exceeded"):
>>>>
>>>>
>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
>>>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition operation
>>>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
>>>> Generic Entity Exception occured in updateByCondition (SQL Exception
>>>> while
>>>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
>>>> RUN_BY_INSTANCE_ID
>>>> = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
>>>> transaction.
>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>> occured in updateByCondition (SQL Exception while executing the
>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>> executing
>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>> at
>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> java.sql.SQLException: Io exception: Connection timed out
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>> at
>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>> at
>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>> at
>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>> at
>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>> at
>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>> at
>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] WARN
>>>> org.ofbiz.entity.transaction.TransactionUtil -
>>>> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
>>>> this
>>>> stack trace shows where this is happening:
>>>> java.lang.Exception: Failure in storeByCondition operation for entity
>>>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity
>>>> Exception occured in updateByCondition (SQL Exception while executing the
>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
>>>> transaction.
>>>> at
>>>> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
>>>> at
>>>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
>>>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>> occured in updateByCondition (SQL Exception while executing the
>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>> executing
>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>> at
>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> java.sql.SQLException: Io exception: Connection timed out
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>> at
>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>> at
>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>> at
>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>> at
>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>> at
>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>> at
>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18192378.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>>
>>>
>> --
>> View this message in context: http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18212363.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>
>
>
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by Heidi Dehaes <in...@gmail.com>.
I am using the geronimo DBCP i think.
Heidi
2008/7/1, maburger <ma...@bertelsmann.de>:
>
> Are you using the DBCP or the "old" Minerva pool implementation?
>
>
> Heidi Dehaes wrote:
> >
> > Yes, I have it also from time to time with version 4.x from OFBIZ.
> > But i have no details at the moment.
> > In every case when this happens i have to restart the java application.
> >
> > Heidi
> > http://www.olagos.eu
> >
> >
> > 2008/6/30, maburger <ma...@bertelsmann.de>:
> >>
> >> Hi *,
> >>
> >> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
> >> error
> >> within the JobManager.poll method. It seems like a DB lock is set on the
> >> JOB_SANBOX table, so the JobManager is not abled to execute the store
> >> operation. Has anyone ever had a similar problem or is this a known bug?
> >>
> >> We are using the last 3.x OFBiz release.
> >>
> >> Thanks for every reply!
> >>
> >> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
> >> timeout
> >> exceeded"):
> >>
> >>
> >> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
> >> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition operation
> >> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
> >> Generic Entity Exception occured in updateByCondition (SQL Exception
> >> while
> >> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
> >> RUN_BY_INSTANCE_ID
> >> = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> >> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
> >> transaction.
> >> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> >> occured in updateByCondition (SQL Exception while executing the
> >> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> >> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> >> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> >> at
> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> >> at
> >> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >> at java.lang.Thread.run(Thread.java:595)
> >> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> >> executing
> >> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> >> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> >> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> >> at
> >> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> >> at
> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >> at
> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >> at
> >> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >> at java.lang.Thread.run(Thread.java:595)
> >> java.sql.SQLException: Io exception: Connection timed out
> >> at
> >> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> >> at
> >> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> >> at
> >> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> >> at
> >> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> >> at
> >> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> >> at
> >> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> >> at
> >> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> >> at
> >> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> >> at
> >> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> >> at
> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >> at
> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >> at
> >> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >> at java.lang.Thread.run(Thread.java:595)
> >> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] WARN
> >> org.ofbiz.entity.transaction.TransactionUtil -
> >> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
> >> this
> >> stack trace shows where this is happening:
> >> java.lang.Exception: Failure in storeByCondition operation for entity
> >> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity
> >> Exception occured in updateByCondition (SQL Exception while executing the
> >> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> >> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> >> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
> >> transaction.
> >> at
> >> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
> >> at
> >> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >> at java.lang.Thread.run(Thread.java:595)
> >> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
> >> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
> >> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> >> occured in updateByCondition (SQL Exception while executing the
> >> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> >> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> >> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> >> at
> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> >> at
> >> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >> at java.lang.Thread.run(Thread.java:595)
> >> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> >> executing
> >> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> >> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> >> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> >> at
> >> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> >> at
> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >> at
> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >> at
> >> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >> at java.lang.Thread.run(Thread.java:595)
> >> java.sql.SQLException: Io exception: Connection timed out
> >> at
> >> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> >> at
> >> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> >> at
> >> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> >> at
> >> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> >> at
> >> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> >> at
> >> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> >> at
> >> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> >> at
> >> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> >> at
> >> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> >> at
> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >> at
> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >> at
> >> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >> at
> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >> at java.lang.Thread.run(Thread.java:595)
> >> --
> >> View this message in context:
> >> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18192378.html
> >> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>
> >>
> >
> >
>
> --
> View this message in context: http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18212363.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by maburger <ma...@bertelsmann.de>.
Are you using the DBCP or the "old" Minerva pool implementation?
Heidi Dehaes wrote:
>
> Yes, I have it also from time to time with version 4.x from OFBIZ.
> But i have no details at the moment.
> In every case when this happens i have to restart the java application.
>
> Heidi
> http://www.olagos.eu
>
>
> 2008/6/30, maburger <ma...@bertelsmann.de>:
>>
>> Hi *,
>>
>> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
>> error
>> within the JobManager.poll method. It seems like a DB lock is set on the
>> JOB_SANBOX table, so the JobManager is not abled to execute the store
>> operation. Has anyone ever had a similar problem or is this a known bug?
>>
>> We are using the last 3.x OFBiz release.
>>
>> Thanks for every reply!
>>
>> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
>> timeout
>> exceeded"):
>>
>>
>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition operation
>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
>> Generic Entity Exception occured in updateByCondition (SQL Exception
>> while
>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
>> RUN_BY_INSTANCE_ID
>> = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
>> transaction.
>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>> occured in updateByCondition (SQL Exception while executing the
>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>> executing
>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>> at
>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> java.sql.SQLException: Io exception: Connection timed out
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>> at
>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>> at
>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>> at
>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>> at
>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] WARN
>> org.ofbiz.entity.transaction.TransactionUtil -
>> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
>> this
>> stack trace shows where this is happening:
>> java.lang.Exception: Failure in storeByCondition operation for entity
>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity
>> Exception occured in updateByCondition (SQL Exception while executing the
>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
>> transaction.
>> at
>> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
>> at
>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>> occured in updateByCondition (SQL Exception while executing the
>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>> executing
>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>> at
>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> java.sql.SQLException: Io exception: Connection timed out
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>> at
>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>> at
>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>> at
>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>> at
>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> --
>> View this message in context:
>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18192378.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18212363.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by Heidi Dehaes <in...@gmail.com>.
Yes, I have it also from time to time with version 4.x from OFBIZ.
But i have no details at the moment.
In every case when this happens i have to restart the java application.
Heidi
http://www.olagos.eu
2008/6/30, maburger <ma...@bertelsmann.de>:
>
> Hi *,
>
> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an error
> within the JobManager.poll method. It seems like a DB lock is set on the
> JOB_SANBOX table, so the JobManager is not abled to execute the store
> operation. Has anyone ever had a similar problem or is this a known bug?
>
> We are using the last 3.x OFBiz release.
>
> Thanks for every reply!
>
> Here's the Stacktrace (The corresponding MySQL error is a "lock wait timeout
> exceeded"):
>
>
> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition operation
> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
> Generic Entity Exception occured in updateByCondition (SQL Exception while
> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID
> = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
> transaction.
> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> occured in updateByCondition (SQL Exception while executing the
> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> java.sql.SQLException: Io exception: Connection timed out
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> at
> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] WARN
> org.ofbiz.entity.transaction.TransactionUtil -
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> java.lang.Exception: Failure in storeByCondition operation for entity
> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity
> Exception occured in updateByCondition (SQL Exception while executing the
> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
> transaction.
> at
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
> at
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> occured in updateByCondition (SQL Exception while executing the
> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> java.sql.SQLException: Io exception: Connection timed out
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> at
> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> --
> View this message in context: http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18192378.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by BJ Freeman <bj...@free-man.net>.
what you said.
:)
David E Jones sent the following on 7/1/2008 9:33 AM:
>
> On Jul 1, 2008, at 3:43 AM, BJ Freeman wrote:
>
>> Problem is that the mailing list only supports the current svn.
>
> This really isn't true. People can ask whatever questions they would
> like on the mailing list, and hopefully there is someone with relevant
> experience who can answer their question.
>
> It is true that when asking a question about an older version, or even
> the release4.0 branch, that the audience or number of people that you
> will reach who are using it is smaller. In other words, there aren't as
> many people so there is less of a chance that someone with relevant
> experience will be able to answer your question.
>
> The mailing list is just a means of communication for people using
> OFBiz. It's not a support organization or anything of the sort, so it
> wouldn't even mean anything to say that the "mailing list" only supports
> the latest code.
>
> -David
>
>
>
>
>
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by David E Jones <jo...@hotwaxmedia.com>.
On Jul 1, 2008, at 3:43 AM, BJ Freeman wrote:
> Problem is that the mailing list only supports the current svn.
This really isn't true. People can ask whatever questions they would
like on the mailing list, and hopefully there is someone with relevant
experience who can answer their question.
It is true that when asking a question about an older version, or even
the release4.0 branch, that the audience or number of people that you
will reach who are using it is smaller. In other words, there aren't
as many people so there is less of a chance that someone with relevant
experience will be able to answer your question.
The mailing list is just a means of communication for people using
OFBiz. It's not a support organization or anything of the sort, so it
wouldn't even mean anything to say that the "mailing list" only
supports the latest code.
-David
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by BJ Freeman <bj...@free-man.net>.
Problem is that the mailing list only supports the current svn.
both the release 4.0 and the trunk have changes that may fix your
problem. I do remember a discussion a while ago, about this. You can
search the mailing lists for oracle.
Having up-graded from 3.0 to 4.0 and trunk, especially if you have a
large DB or custom software, is not a job i relish.
maburger sent the following on 6/30/2008 10:38 PM:
> I read this atricle to, but this isn't our problem. I think the Minerva
> connection pool causes this problem when the gc thread is activated to check
> for idle connections. So we have to find a way to configure the pool to work
> correct or to switch to another pool implementation without refectoring half
> of the 3.x framework.
>
>
> BJ Freeman wrote:
>> if did a google search for
>> ofbiz oracle
>> here is one link
>> http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle
>>
>> maburger sent the following on 6/30/2008 6:37 AM:
>>> This problem is not os depending. Were running on both Windows and Linux.
>>> The
>>> MySQL Versions also differ from 4.x to 5.x (ORACLE 10g) but the error is
>>> the
>>> same.
>>>
>>> I forgot to post one important change we made to the framework. There is
>>> a
>>> known problem within the interaction to the MySQL Database server, which
>>> closes idle connections after a defined timeout (e.g. after 8 hours). If
>>> this happens, the connection pool does not notice this with the result
>>> that
>>> it returns an invalid connection. In this situation, the system status is
>>> not very stable and it has happend that some (productive) jobs have been
>>> cancelled and not been rescheduled.
>>>
>>> So what we have done is a modification to the
>>> MinervaConnectionFactory.getConnection method where we enabled the gc
>>> thread
>>> (for idle connections) for a new XAPoolDataSource.
>>>
>>> //enable gc with default values
>>> pds.setGCEnabled(true);
>>> pds.setIdleTimeoutEnabled(true);
>>>
>>>
>>>
>>> jacques.le.roux wrote:
>>>> Are you runnig on Windows ? I remember having read that sometimes
>>>> Windows
>>>> does not free some files handles and such errors may
>>>> occur.
>>>> Which version of MySQL and ORACLE are you using ?
>>>>
>>>> Jacques
>>>>
>>>> From: "maburger" <ma...@bertelsmann.de>
>>>>> Is this a known bug within the Minerva Pool? I don't think it is
>>>>> possible
>>>>> to
>>>>> switch the pool by configuration as it could be done in the 4+ version?
>>>>> We
>>>>> are not kind to rewrite our current system because we want to migrate
>>>>> to
>>>>> OFBiz 4+ in the next months, but we need a fix for this problem to
>>>>> bridge
>>>>> over this period.
>>>>>
>>>>>
>>>>> maburger wrote:
>>>>>> Hi *,
>>>>>>
>>>>>> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
>>>>>> error within the JobManager.poll method. It seems like a DB lock is
>>>>>> set
>>>>>> on
>>>>>> the JOB_SANBOX table, so the JobManager is not abled to execute the
>>>>>> store
>>>>>> operation. Has anyone ever had a similar problem or is this a known
>>>>>> bug?
>>>>>>
>>>>>> We are using the last 3.x OFBiz release.
>>>>>>
>>>>>> Thanks for every reply!
>>>>>>
>>>>>> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
>>>>>> timeout exceeded"):
>>>>>>
>>>>>>
>>>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>>> ERROR
>>>>>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition
>>>>>> operation
>>>>>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
>>>>>> Generic Entity Exception occured in updateByCondition (SQL Exception
>>>>>> while
>>>>>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
>>>>>> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND
>>>>>> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND
>>>>>> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io
>>>>>> exception: Connection timed out)). Rolling back transaction.
>>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>>>> occured in updateByCondition (SQL Exception while executing the
>>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>>> IS
>>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>>>> executing
>>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
>>>>>> ?,
>>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>>> IS
>>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>>>> at
>>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> java.sql.SQLException: Io exception: Connection timed out
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>>>> at
>>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>>>> at
>>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>>>> at
>>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>>>> at
>>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>>>> at
>>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>>>> at
>>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>>> WARN
>>>>>> org.ofbiz.entity.transaction.TransactionUtil -
>>>>>> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
>>>>>> this stack trace shows where this is happening:
>>>>>> java.lang.Exception: Failure in storeByCondition operation for entity
>>>>>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic
>>>>>> Entity
>>>>>> Exception occured in updateByCondition (SQL Exception while executing
>>>>>> the
>>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>>> IS
>>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling
>>>>>> back
>>>>>> transaction.
>>>>>> at
>>>>>> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
>>>>>> at
>>>>>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>>> ERROR
>>>>>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
>>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>>>> occured in updateByCondition (SQL Exception while executing the
>>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>>> IS
>>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>>>> executing
>>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
>>>>>> ?,
>>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>>> IS
>>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>>>> at
>>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>> java.sql.SQLException: Io exception: Connection timed out
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>>>> at
>>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>>>> at
>>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>>>> at
>>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>>>> at
>>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>>>> at
>>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>>>> at
>>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>>>> at
>>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>>> at
>>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>>> at
>>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>>
>>>>> --
>>>>> View this message in context:
>>>>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18194547.html
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>
>>
>>
>
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
It will be good if you will migrate to the newer version i.e Ofbiz 4.0.
--
Ashish
On Tue, Jul 1, 2008 at 1:38 AM, maburger <ma...@bertelsmann.de>
wrote:
>
> I read this atricle to, but this isn't our problem. I think the Minerva
> connection pool causes this problem when the gc thread is activated to
> check
> for idle connections. So we have to find a way to configure the pool to
> work
> correct or to switch to another pool implementation without refectoring
> half
> of the 3.x framework.
>
>
> BJ Freeman wrote:
> >
> > if did a google search for
> > ofbiz oracle
> > here is one link
> > http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle<http://docs.ofbiz.org/display/%7Ejacopoc/OFBiz+and+Oracle>
> >
> > maburger sent the following on 6/30/2008 6:37 AM:
> >> This problem is not os depending. Were running on both Windows and
> Linux.
> >> The
> >> MySQL Versions also differ from 4.x to 5.x (ORACLE 10g) but the error is
> >> the
> >> same.
> >>
> >> I forgot to post one important change we made to the framework. There is
> >> a
> >> known problem within the interaction to the MySQL Database server, which
> >> closes idle connections after a defined timeout (e.g. after 8 hours). If
> >> this happens, the connection pool does not notice this with the result
> >> that
> >> it returns an invalid connection. In this situation, the system status
> is
> >> not very stable and it has happend that some (productive) jobs have been
> >> cancelled and not been rescheduled.
> >>
> >> So what we have done is a modification to the
> >> MinervaConnectionFactory.getConnection method where we enabled the gc
> >> thread
> >> (for idle connections) for a new XAPoolDataSource.
> >>
> >> //enable gc with default values
> >> pds.setGCEnabled(true);
> >> pds.setIdleTimeoutEnabled(true);
> >>
> >>
> >>
> >> jacques.le.roux wrote:
> >>> Are you runnig on Windows ? I remember having read that sometimes
> >>> Windows
> >>> does not free some files handles and such errors may
> >>> occur.
> >>> Which version of MySQL and ORACLE are you using ?
> >>>
> >>> Jacques
> >>>
> >>> From: "maburger" <ma...@bertelsmann.de>
> >>>> Is this a known bug within the Minerva Pool? I don't think it is
> >>>> possible
> >>>> to
> >>>> switch the pool by configuration as it could be done in the 4+
> version?
> >>>> We
> >>>> are not kind to rewrite our current system because we want to migrate
> >>>> to
> >>>> OFBiz 4+ in the next months, but we need a fix for this problem to
> >>>> bridge
> >>>> over this period.
> >>>>
> >>>>
> >>>> maburger wrote:
> >>>>> Hi *,
> >>>>>
> >>>>> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
> >>>>> error within the JobManager.poll method. It seems like a DB lock is
> >>>>> set
> >>>>> on
> >>>>> the JOB_SANBOX table, so the JobManager is not abled to execute the
> >>>>> store
> >>>>> operation. Has anyone ever had a similar problem or is this a known
> >>>>> bug?
> >>>>>
> >>>>> We are using the last 3.x OFBiz release.
> >>>>>
> >>>>> Thanks for every reply!
> >>>>>
> >>>>> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
> >>>>> timeout exceeded"):
> >>>>>
> >>>>>
> >>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
> >>>>> ERROR
> >>>>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition
> >>>>> operation
> >>>>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
> >>>>> Generic Entity Exception occured in updateByCondition (SQL Exception
> >>>>> while
> >>>>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
> >>>>> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND
> >>>>> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND
> >>>>> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io
> >>>>> exception: Connection timed out)). Rolling back transaction.
> >>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> >>>>> occured in updateByCondition (SQL Exception while executing the
> >>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> >>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
> >>>>> IS
> >>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> >>>>> executing
> >>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
> >>>>> ?,
> >>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
> >>>>> IS
> >>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> >>>>> at
> >>>>>
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>> java.sql.SQLException: Io exception: Connection timed out
> >>>>> at
> >>>>>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> >>>>> at
> >>>>>
> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> >>>>> at
> >>>>>
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
> >>>>> WARN
> >>>>> org.ofbiz.entity.transaction.TransactionUtil -
> >>>>> [TransactionUtil.setRollbackOnly] Calling transaction
> setRollbackOnly;
> >>>>> this stack trace shows where this is happening:
> >>>>> java.lang.Exception: Failure in storeByCondition operation for entity
> >>>>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic
> >>>>> Entity
> >>>>> Exception occured in updateByCondition (SQL Exception while executing
> >>>>> the
> >>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> >>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
> >>>>> IS
> >>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling
> >>>>> back
> >>>>> transaction.
> >>>>> at
> >>>>>
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
> >>>>> at
> >>>>>
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787]
> >>>>> ERROR
> >>>>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
> >>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> >>>>> occured in updateByCondition (SQL Exception while executing the
> >>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> >>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
> >>>>> IS
> >>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> >>>>> executing
> >>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
> >>>>> ?,
> >>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> >>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
> >>>>> IS
> >>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> >>>>> at
> >>>>>
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>> java.sql.SQLException: Io exception: Connection timed out
> >>>>> at
> >>>>>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> >>>>> at
> >>>>>
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> >>>>> at
> >>>>>
> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> >>>>> at
> >>>>>
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> >>>>> at
> >>>>>
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> >>>>> at
> >>>>>
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> >>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> >>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> >>>>> at java.lang.Thread.run(Thread.java:595)
> >>>>>
> >>>> --
> >>>> View this message in context:
> >>>>
> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18194547.html
> >>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>>>
> >>>
> >>>
> >>
> >
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18209596.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by maburger <ma...@bertelsmann.de>.
I read this atricle to, but this isn't our problem. I think the Minerva
connection pool causes this problem when the gc thread is activated to check
for idle connections. So we have to find a way to configure the pool to work
correct or to switch to another pool implementation without refectoring half
of the 3.x framework.
BJ Freeman wrote:
>
> if did a google search for
> ofbiz oracle
> here is one link
> http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle
>
> maburger sent the following on 6/30/2008 6:37 AM:
>> This problem is not os depending. Were running on both Windows and Linux.
>> The
>> MySQL Versions also differ from 4.x to 5.x (ORACLE 10g) but the error is
>> the
>> same.
>>
>> I forgot to post one important change we made to the framework. There is
>> a
>> known problem within the interaction to the MySQL Database server, which
>> closes idle connections after a defined timeout (e.g. after 8 hours). If
>> this happens, the connection pool does not notice this with the result
>> that
>> it returns an invalid connection. In this situation, the system status is
>> not very stable and it has happend that some (productive) jobs have been
>> cancelled and not been rescheduled.
>>
>> So what we have done is a modification to the
>> MinervaConnectionFactory.getConnection method where we enabled the gc
>> thread
>> (for idle connections) for a new XAPoolDataSource.
>>
>> //enable gc with default values
>> pds.setGCEnabled(true);
>> pds.setIdleTimeoutEnabled(true);
>>
>>
>>
>> jacques.le.roux wrote:
>>> Are you runnig on Windows ? I remember having read that sometimes
>>> Windows
>>> does not free some files handles and such errors may
>>> occur.
>>> Which version of MySQL and ORACLE are you using ?
>>>
>>> Jacques
>>>
>>> From: "maburger" <ma...@bertelsmann.de>
>>>> Is this a known bug within the Minerva Pool? I don't think it is
>>>> possible
>>>> to
>>>> switch the pool by configuration as it could be done in the 4+ version?
>>>> We
>>>> are not kind to rewrite our current system because we want to migrate
>>>> to
>>>> OFBiz 4+ in the next months, but we need a fix for this problem to
>>>> bridge
>>>> over this period.
>>>>
>>>>
>>>> maburger wrote:
>>>>> Hi *,
>>>>>
>>>>> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
>>>>> error within the JobManager.poll method. It seems like a DB lock is
>>>>> set
>>>>> on
>>>>> the JOB_SANBOX table, so the JobManager is not abled to execute the
>>>>> store
>>>>> operation. Has anyone ever had a similar problem or is this a known
>>>>> bug?
>>>>>
>>>>> We are using the last 3.x OFBiz release.
>>>>>
>>>>> Thanks for every reply!
>>>>>
>>>>> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
>>>>> timeout exceeded"):
>>>>>
>>>>>
>>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>> ERROR
>>>>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition
>>>>> operation
>>>>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
>>>>> Generic Entity Exception occured in updateByCondition (SQL Exception
>>>>> while
>>>>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
>>>>> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND
>>>>> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND
>>>>> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io
>>>>> exception: Connection timed out)). Rolling back transaction.
>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>>> occured in updateByCondition (SQL Exception while executing the
>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>> IS
>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>>> executing
>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
>>>>> ?,
>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>> IS
>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>>> at
>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> java.sql.SQLException: Io exception: Connection timed out
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>>> at
>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>>> at
>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>>> at
>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>>> at
>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>>> at
>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>>> at
>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>> WARN
>>>>> org.ofbiz.entity.transaction.TransactionUtil -
>>>>> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
>>>>> this stack trace shows where this is happening:
>>>>> java.lang.Exception: Failure in storeByCondition operation for entity
>>>>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic
>>>>> Entity
>>>>> Exception occured in updateByCondition (SQL Exception while executing
>>>>> the
>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>> IS
>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling
>>>>> back
>>>>> transaction.
>>>>> at
>>>>> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
>>>>> at
>>>>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787]
>>>>> ERROR
>>>>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>>> occured in updateByCondition (SQL Exception while executing the
>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>> IS
>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>>> executing
>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID =
>>>>> ?,
>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID
>>>>> IS
>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>>> at
>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> java.sql.SQLException: Io exception: Connection timed out
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>>> at
>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>>> at
>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>>> at
>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>>> at
>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>>> at
>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>>> at
>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>>> at
>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>>> at
>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>>> at
>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>>
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18194547.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>
>>>
>>
>
>
>
--
View this message in context: http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18209596.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by BJ Freeman <bj...@free-man.net>.
if did a google search for
ofbiz oracle
here is one link
http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle
maburger sent the following on 6/30/2008 6:37 AM:
> This problem is not os depending. Were running on both Windows and Linux. The
> MySQL Versions also differ from 4.x to 5.x (ORACLE 10g) but the error is the
> same.
>
> I forgot to post one important change we made to the framework. There is a
> known problem within the interaction to the MySQL Database server, which
> closes idle connections after a defined timeout (e.g. after 8 hours). If
> this happens, the connection pool does not notice this with the result that
> it returns an invalid connection. In this situation, the system status is
> not very stable and it has happend that some (productive) jobs have been
> cancelled and not been rescheduled.
>
> So what we have done is a modification to the
> MinervaConnectionFactory.getConnection method where we enabled the gc thread
> (for idle connections) for a new XAPoolDataSource.
>
> //enable gc with default values
> pds.setGCEnabled(true);
> pds.setIdleTimeoutEnabled(true);
>
>
>
> jacques.le.roux wrote:
>> Are you runnig on Windows ? I remember having read that sometimes Windows
>> does not free some files handles and such errors may
>> occur.
>> Which version of MySQL and ORACLE are you using ?
>>
>> Jacques
>>
>> From: "maburger" <ma...@bertelsmann.de>
>>> Is this a known bug within the Minerva Pool? I don't think it is possible
>>> to
>>> switch the pool by configuration as it could be done in the 4+ version?
>>> We
>>> are not kind to rewrite our current system because we want to migrate to
>>> OFBiz 4+ in the next months, but we need a fix for this problem to bridge
>>> over this period.
>>>
>>>
>>> maburger wrote:
>>>> Hi *,
>>>>
>>>> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
>>>> error within the JobManager.poll method. It seems like a DB lock is set
>>>> on
>>>> the JOB_SANBOX table, so the JobManager is not abled to execute the
>>>> store
>>>> operation. Has anyone ever had a similar problem or is this a known bug?
>>>>
>>>> We are using the last 3.x OFBiz release.
>>>>
>>>> Thanks for every reply!
>>>>
>>>> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
>>>> timeout exceeded"):
>>>>
>>>>
>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
>>>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition
>>>> operation
>>>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
>>>> Generic Entity Exception occured in updateByCondition (SQL Exception
>>>> while
>>>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
>>>> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND
>>>> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND
>>>> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io
>>>> exception: Connection timed out)). Rolling back transaction.
>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>> occured in updateByCondition (SQL Exception while executing the
>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>> executing
>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>> at
>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> java.sql.SQLException: Io exception: Connection timed out
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>> at
>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>> at
>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>> at
>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>> at
>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>> at
>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>> at
>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] WARN
>>>> org.ofbiz.entity.transaction.TransactionUtil -
>>>> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
>>>> this stack trace shows where this is happening:
>>>> java.lang.Exception: Failure in storeByCondition operation for entity
>>>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic
>>>> Entity
>>>> Exception occured in updateByCondition (SQL Exception while executing
>>>> the
>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling
>>>> back
>>>> transaction.
>>>> at
>>>> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
>>>> at
>>>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
>>>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>>> occured in updateByCondition (SQL Exception while executing the
>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>>> executing
>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>>> at
>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>> java.sql.SQLException: Io exception: Connection timed out
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>> at
>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>>> at
>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>>> at
>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>>> at
>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>>> at
>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>>> at
>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>>> at
>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>>> at
>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>>> at
>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>>> at java.lang.Thread.run(Thread.java:595)
>>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18194547.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by maburger <ma...@bertelsmann.de>.
This problem is not os depending. Were running on both Windows and Linux. The
MySQL Versions also differ from 4.x to 5.x (ORACLE 10g) but the error is the
same.
I forgot to post one important change we made to the framework. There is a
known problem within the interaction to the MySQL Database server, which
closes idle connections after a defined timeout (e.g. after 8 hours). If
this happens, the connection pool does not notice this with the result that
it returns an invalid connection. In this situation, the system status is
not very stable and it has happend that some (productive) jobs have been
cancelled and not been rescheduled.
So what we have done is a modification to the
MinervaConnectionFactory.getConnection method where we enabled the gc thread
(for idle connections) for a new XAPoolDataSource.
//enable gc with default values
pds.setGCEnabled(true);
pds.setIdleTimeoutEnabled(true);
jacques.le.roux wrote:
>
> Are you runnig on Windows ? I remember having read that sometimes Windows
> does not free some files handles and such errors may
> occur.
> Which version of MySQL and ORACLE are you using ?
>
> Jacques
>
> From: "maburger" <ma...@bertelsmann.de>
>>
>> Is this a known bug within the Minerva Pool? I don't think it is possible
>> to
>> switch the pool by configuration as it could be done in the 4+ version?
>> We
>> are not kind to rewrite our current system because we want to migrate to
>> OFBiz 4+ in the next months, but we need a fix for this problem to bridge
>> over this period.
>>
>>
>> maburger wrote:
>>>
>>> Hi *,
>>>
>>> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
>>> error within the JobManager.poll method. It seems like a DB lock is set
>>> on
>>> the JOB_SANBOX table, so the JobManager is not abled to execute the
>>> store
>>> operation. Has anyone ever had a similar problem or is this a known bug?
>>>
>>> We are using the last 3.x OFBiz release.
>>>
>>> Thanks for every reply!
>>>
>>> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
>>> timeout exceeded"):
>>>
>>>
>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
>>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition
>>> operation
>>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
>>> Generic Entity Exception occured in updateByCondition (SQL Exception
>>> while
>>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
>>> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND
>>> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND
>>> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io
>>> exception: Connection timed out)). Rolling back transaction.
>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>> occured in updateByCondition (SQL Exception while executing the
>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>> at
>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>> at
>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>> at java.lang.Thread.run(Thread.java:595)
>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>> executing
>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>> at
>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>> at
>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>> at
>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>> at
>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>> at java.lang.Thread.run(Thread.java:595)
>>> java.sql.SQLException: Io exception: Connection timed out
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>> at
>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>> at
>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>> at
>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>> at
>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>> at
>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>> at
>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>> at
>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>> at
>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>> at
>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>> at java.lang.Thread.run(Thread.java:595)
>>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] WARN
>>> org.ofbiz.entity.transaction.TransactionUtil -
>>> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
>>> this stack trace shows where this is happening:
>>> java.lang.Exception: Failure in storeByCondition operation for entity
>>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic
>>> Entity
>>> Exception occured in updateByCondition (SQL Exception while executing
>>> the
>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling
>>> back
>>> transaction.
>>> at
>>> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
>>> at
>>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>> at java.lang.Thread.run(Thread.java:595)
>>> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
>>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>>> occured in updateByCondition (SQL Exception while executing the
>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>>> at
>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>>> at
>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>> at java.lang.Thread.run(Thread.java:595)
>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
>>> executing
>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>>> at
>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>>> at
>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>> at
>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>> at
>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>> at java.lang.Thread.run(Thread.java:595)
>>> java.sql.SQLException: Io exception: Connection timed out
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>> at
>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>>> at
>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>>> at
>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>>> at
>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>>> at
>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>>> at
>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>>> at
>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>>> at
>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>>> at
>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>>> at
>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>>> at java.lang.Thread.run(Thread.java:595)
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18194547.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
>
--
View this message in context: http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18195888.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by Jacques Le Roux <ja...@les7arts.com>.
Are you runnig on Windows ? I remember having read that sometimes Windows does not free some files handles and such errors may
occur.
Which version of MySQL and ORACLE are you using ?
Jacques
From: "maburger" <ma...@bertelsmann.de>
>
> Is this a known bug within the Minerva Pool? I don't think it is possible to
> switch the pool by configuration as it could be done in the 4+ version? We
> are not kind to rewrite our current system because we want to migrate to
> OFBiz 4+ in the next months, but we need a fix for this problem to bridge
> over this period.
>
>
> maburger wrote:
>>
>> Hi *,
>>
>> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
>> error within the JobManager.poll method. It seems like a DB lock is set on
>> the JOB_SANBOX table, so the JobManager is not abled to execute the store
>> operation. Has anyone ever had a similar problem or is this a known bug?
>>
>> We are using the last 3.x OFBiz release.
>>
>> Thanks for every reply!
>>
>> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
>> timeout exceeded"):
>>
>>
>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition operation
>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
>> Generic Entity Exception occured in updateByCondition (SQL Exception while
>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
>> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND
>> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND
>> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io
>> exception: Connection timed out)). Rolling back transaction.
>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>> occured in updateByCondition (SQL Exception while executing the
>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>> at
>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> java.sql.SQLException: Io exception: Connection timed out
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>> at
>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>> at
>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>> at
>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>> at
>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] WARN
>> org.ofbiz.entity.transaction.TransactionUtil -
>> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
>> this stack trace shows where this is happening:
>> java.lang.Exception: Failure in storeByCondition operation for entity
>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity
>> Exception occured in updateByCondition (SQL Exception while executing the
>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
>> transaction.
>> at
>> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
>> at
>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
>> occured in updateByCondition (SQL Exception while executing the
>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
>> at
>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>> java.sql.SQLException: Io exception: Connection timed out
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>> at
>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
>> at
>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
>> at
>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
>> at
>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
>> at
>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
>> at
>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
>> at
>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
>> at
>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
>> at java.lang.Thread.run(Thread.java:595)
>>
>
> --
> View this message in context:
> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18194547.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by maburger <ma...@bertelsmann.de>.
Is this a known bug within the Minerva Pool? I don't think it is possible to
switch the pool by configuration as it could be done in the 4+ version? We
are not kind to rewrite our current system because we want to migrate to
OFBiz 4+ in the next months, but we need a fix for this problem to bridge
over this period.
maburger wrote:
>
> Hi *,
>
> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an
> error within the JobManager.poll method. It seems like a DB lock is set on
> the JOB_SANBOX table, so the JobManager is not abled to execute the store
> operation. Has anyone ever had a similar problem or is this a known bug?
>
> We are using the last 3.x OFBiz release.
>
> Thanks for every reply!
>
> Here's the Stacktrace (The corresponding MySQL error is a "lock wait
> timeout exceeded"):
>
>
> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition operation
> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
> Generic Entity Exception occured in updateByCondition (SQL Exception while
> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET
> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND
> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND
> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io
> exception: Connection timed out)). Rolling back transaction.
> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> occured in updateByCondition (SQL Exception while executing the
> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> at
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> java.sql.SQLException: Io exception: Connection timed out
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> at
> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> at
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] WARN
> org.ofbiz.entity.transaction.TransactionUtil -
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
> this stack trace shows where this is happening:
> java.lang.Exception: Failure in storeByCondition operation for entity
> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity
> Exception occured in updateByCondition (SQL Exception while executing the
> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
> transaction.
> at
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
> at
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> occured in updateByCondition (SQL Exception while executing the
> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> at
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> java.sql.SQLException: Io exception: Connection timed out
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> at
> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> at
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
>
--
View this message in context: http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18194547.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Posted by Jacques Le Roux <ja...@les7arts.com>.
Releases 3 were using Minverva. You may try to replace with Apache Geronimo DBCP which is used in releases 4+
Jacques
From: "maburger" <ma...@bertelsmann.de>
>
> Hi *,
>
> we're running OFBiz on MySQL and/or ORACLE. Sometimes were getting an error
> within the JobManager.poll method. It seems like a DB lock is set on the
> JOB_SANBOX table, so the JobManager is not abled to execute the store
> operation. Has anyone ever had a similar problem or is this a known bug?
>
> We are using the last 3.x OFBiz release.
>
> Thanks for every reply!
>
> Here's the Stacktrace (The corresponding MySQL error is a "lock wait timeout
> exceeded"):
>
>
> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition operation
> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException:
> Generic Entity Exception occured in updateByCondition (SQL Exception while
> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID
> = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
> transaction.
> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> occured in updateByCondition (SQL Exception while executing the
> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> java.sql.SQLException: Io exception: Connection timed out
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> at
> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> 2008-06-26 18:34:16,276 [org.ofbiz.service.job.JobPoller@7444f787] WARN
> org.ofbiz.entity.transaction.TransactionUtil -
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> java.lang.Exception: Failure in storeByCondition operation for entity
> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity
> Exception occured in updateByCondition (SQL Exception while executing the
> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling back
> transaction.
> at
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282)
> at
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> 2008-06-26 18:34:16,277 [org.ofbiz.service.job.JobPoller@7444f787] ERROR
> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource.
> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception
> occured in updateByCondition (SQL Exception while executing the
> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out))
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND
> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS
> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)
> at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> java.sql.SQLException: Io exception: Connection timed out
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> at
> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342)
> at
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287)
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957)
> at
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932)
> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154)
> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82)
> at java.lang.Thread.run(Thread.java:595)
> --
> View this message in context:
> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18192378.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>