Problem with JobSanbox lock on (MySQL and/or ORACLE)
Locked
 
|
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) |
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
Administrator
|
Releases 3 were using Minverva. You may try to replace with Apache Geronimo DBCP which is used in releases 4+
Jacques From: "maburger" <[hidden email]> > > 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. > |
|
|
In reply to this post by maburger
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.
|
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
|
Administrator
|
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" <[hidden email]> > > 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. > |
|
|
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);
|
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
|
|
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" <[hidden email]> >>> 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. >>> >> >> > |
|
|
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.
|
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
|
|
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 <[hidden email]> 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" <[hidden email]> > >>>> 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)
|
|
In reply to this post by maburger
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 <[hidden email]>: > > 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. > > |
|
|
Are you using the DBCP or the "old" Minerva pool implementation?
|
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
|
|
I am using the geronimo DBCP i think.
Heidi 2008/7/1, maburger <[hidden email]>: > > 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 <[hidden email]>: > >> > >> 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)
|
|
In reply to this post by maburger
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" <[hidden email]> >>>>> 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)
|
|
In reply to this post by Heidi Dehaes - Olagos
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 <[hidden email]>: >> 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 <[hidden email]>: >>>> 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. >> >> > > > |
|
|
Could you tell me when this change is applied to the 4.0 branch?
|
Re: Problem with JobSanbox lock on (MySQL and/or ORACLE)
|
|
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 <[hidden email]>: >>>> 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 <[hidden email]>: >>>>>> 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)
|
|
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 <[hidden email]>: > 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 <[hidden email]>: > >>>> 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 <[hidden email]>: > >>>>>> 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)
|
|
In reply to this post by BJ Freeman
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)
|
|
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 > > > > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |