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" <[EMAIL PROTECTED]> >>>>> 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 [EMAIL PROTECTED] >>>>>> ERROR >>>>>> org.ofbiz.entity.GenericDelegator - Failure in storeByCondition >>>>>> operation >>>>>> for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: >>>>>> Generic Entity Exception occured in updateByCondition (SQL Exception >>>>>> while >>>>>> executing the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET >>>>>> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= ? AND >>>>>> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND >>>>>> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = ?)) (Io >>>>>> exception: Connection timed out)). Rolling back transaction. >>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception >>>>>> occured in updateByCondition (SQL Exception while executing the >>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, >>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND >>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID >>>>>> IS >>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >>>>>> at java.lang.Thread.run(Thread.java:595) >>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while >>>>>> executing >>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = >>>>>> ?, >>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND >>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID >>>>>> IS >>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out) >>>>>> at >>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >>>>>> at java.lang.Thread.run(Thread.java:595) >>>>>> java.sql.SQLException: Io exception: Connection timed out >>>>>> at >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) >>>>>> at >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) >>>>>> at >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) >>>>>> at >>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988) >>>>>> at >>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) >>>>>> at >>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) >>>>>> at >>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423) >>>>>> at >>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) >>>>>> at >>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >>>>>> at java.lang.Thread.run(Thread.java:595) >>>>>> 2008-06-26 18:34:16,276 [EMAIL PROTECTED] >>>>>> WARN >>>>>> org.ofbiz.entity.transaction.TransactionUtil - >>>>>> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; >>>>>> this stack trace shows where this is happening: >>>>>> java.lang.Exception: Failure in storeByCondition operation for entity >>>>>> [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic >>>>>> Entity >>>>>> Exception occured in updateByCondition (SQL Exception while executing >>>>>> the >>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, >>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND >>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID >>>>>> IS >>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)). Rolling >>>>>> back >>>>>> transaction. >>>>>> at >>>>>> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:282) >>>>>> at >>>>>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:232) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:963) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >>>>>> at java.lang.Thread.run(Thread.java:595) >>>>>> 2008-06-26 18:34:16,277 [EMAIL PROTECTED] >>>>>> ERROR >>>>>> org.ofbiz.service.job.JobManager - Cannot load jobs from datasource. >>>>>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception >>>>>> occured in updateByCondition (SQL Exception while executing the >>>>>> following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, >>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND >>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID >>>>>> IS >>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out)) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >>>>>> at java.lang.Thread.run(Thread.java:595) >>>>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while >>>>>> executing >>>>>> the following:UPDATE BIC_SYSTEM.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = >>>>>> ?, >>>>>> STATUS_ID = ? WHERE ((RUN_TIME <= ? AND START_DATE_TIME IS NULL AND >>>>>> CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID >>>>>> IS >>>>>> NULL OR POOL_ID = ?)) (Io exception: Connection timed out) >>>>>> at >>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >>>>>> at java.lang.Thread.run(Thread.java:595) >>>>>> java.sql.SQLException: Io exception: Connection timed out >>>>>> at >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) >>>>>> at >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) >>>>>> at >>>>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) >>>>>> at >>>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:988) >>>>>> at >>>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) >>>>>> at >>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) >>>>>> at >>>>>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423) >>>>>> at >>>>>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) >>>>>> at >>>>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:342) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:287) >>>>>> at >>>>>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:957) >>>>>> at >>>>>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:932) >>>>>> at org.ofbiz.service.job.JobManager.poll(JobManager.java:154) >>>>>> at org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >>>>>> at java.lang.Thread.run(Thread.java:595) >>>>>> >>>>> -- >>>>> View this message in context: >>>>> http://www.nabble.com/Problem-with-JobSanbox-lock-on-%28MySQL-and-or-ORACLE%29-tp18192378p18194547.html >>>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>>>> >>>> >> >> >
