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