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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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.
