You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Dean Pullen <de...@semantico.com> on 2012/02/22 11:23:48 UTC
Mysql problems
After restarting my dev machine, where upon Ofbiz was previously
working, I'm now getting these errors for every DB call from ./ant run
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 JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
STATUS_ID = ? WHERE ((RUN_TIME <= '2012-02-22 10:16:46.439' 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 = 'pool'))
(Cannot execute statement: impossible to write to binary log since
BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine
limited to row-based logging. InnoDB is limited to row-logging when
transaction isolation level is READ COMMITTED or READ UNCOMMITTED.)).
Rolling back transaction.
[java]
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:370)
[java]
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:312)
[java]
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1300)
[java]
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1261)
[java] org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
[java] org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
[java] java.lang.Thread.run(Thread.java:680)
Can anyone help me with this please?
Many thanks,
Dean.
Re: Mysql problems
Posted by Dean Pullen <de...@semantico.com>.
Cheers Anne. For some reason, my googling gave me very little!
I've uncommented the bin_log_format row in my.ini, to:
# binary logging format - mixed recommended
binlog_format=mixed
I think mysql didn't pick up my.ini originally and this is why, on a
reboot, it was then failing as it had found the new config.
Thanks.
On 23/02/2012 22:54, Anne wrote:
> Hi Dean
>
> Google suggested this:
>
> http://bugs.mysql.com/bug.php?id=62493
>
> which sounds like it matches your symptoms. So I'd suggest checking for a
> broken mysql config.
>
> Cheers,
> Anne.
>
> On 24 February 2012 04:14, Dean Pullen<de...@semantico.com> wrote:
>
>> Can anyone else help? Completely stuck when trying to start the server...
>>
>> Dean.
>>
>>
>> On 22/02/2012 11:36, Sascha Rodekamp wrote:
>>
>>> Hm ok I had similar issues when there where old corrupted jobs in the
>>> sandbox.
>>>
>>> Am 22.02.2012 um 12:20 schrieb Dean Pullen<de...@semantico.com>
>>>> :
>>> Thanks for the reply, but still seeing the same exceptions.
>>>> [java] [TransactionUtil.**setRollbackOnly] Calling transaction
>>>> setRollbackOnly; this stack trace shows where this is happening:
>>>> [java] Exception: java.lang.Exception
>>>> [java] Message: Failure in storeByCondition operation for entity
>>>> [JobSandbox]: org.ofbiz.entity.**GenericDataSourceException: Generic
>>>> Entity Exception occured in updateByCondition (SQL Exception while
>>>> executing the following:UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>> STATUS_ID = ? WHERE ((RUN_TIME<= '2012-02-22 11:19:04.663' 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 = 'pool')) (Cannot execute
>>>> statement: impossible to write to binary log since BINLOG_FORMAT =
>>>> STATEMENT and at least one table uses a storage engine limited to row-based
>>>> logging. InnoDB is limited to row-logging when transaction isolation level
>>>> is READ COMMITTED or READ UNCOMMITTED.)). Rolling back transaction.
>>>>
>>>>
>>>>
>>>> On 22/02/2012 11:02, Sascha Rodekamp wrote:
>>>>
>>>>> Hey
>>>>> Try to empty the Job_Sandbox table. That should solve the problem.
>>>>>
>>>>> Have a good day
>>>>> Sascha
>>>>>
>>>>> Am 22.02.2012 um 11:23 schrieb Dean Pullen<de...@semantico.com>
>>>>>> :
>>>>> After restarting my dev machine, where upon Ofbiz was previously
>>>>>> working, I'm now getting these errors for every DB call from ./ant run
>>>>>>
>>>>>>
>>>>>> 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 JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>>> STATUS_ID = ? WHERE ((RUN_TIME<= '2012-02-22 10:16:46.439' 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 = 'pool')) (Cannot execute
>>>>>> statement: impossible to write to binary log since BINLOG_FORMAT =
>>>>>> STATEMENT and at least one table uses a storage engine limited to row-based
>>>>>> logging. InnoDB is limited to row-logging when transaction isolation level
>>>>>> is READ COMMITTED or READ UNCOMMITTED.)). Rolling back transaction.
>>>>>> [java] org.ofbiz.entity.transaction.**TransactionUtil.**
>>>>>> setRollbackOnly(**TransactionUtil.java:370)
>>>>>> [java] org.ofbiz.entity.transaction.**TransactionUtil.rollback(**
>>>>>> TransactionUtil.java:312)
>>>>>> [java] org.ofbiz.entity.**GenericDelegator.**storeByCondition(**
>>>>>> GenericDelegator.java:1300)
>>>>>> [java] org.ofbiz.entity.**GenericDelegator.**storeByCondition(**
>>>>>> GenericDelegator.java:1261)
>>>>>> [java] org.ofbiz.service.job.**JobManager.poll(JobManager.**
>>>>>> java:157)
>>>>>> [java] org.ofbiz.service.job.**JobPoller.run(JobPoller.java:**90)
>>>>>> [java] java.lang.Thread.run(Thread.**java:680)
>>>>>>
>>>>>> Can anyone help me with this please?
>>>>>>
>>>>>> Many thanks,
>>>>>>
>>>>>> Dean.
>>>>>>
>
Re: Mysql problems
Posted by Anne <an...@cohsoft.com.au>.
Hi Dean
Google suggested this:
http://bugs.mysql.com/bug.php?id=62493
which sounds like it matches your symptoms. So I'd suggest checking for a
broken mysql config.
Cheers,
Anne.
On 24 February 2012 04:14, Dean Pullen <de...@semantico.com> wrote:
> Can anyone else help? Completely stuck when trying to start the server...
>
> Dean.
>
>
> On 22/02/2012 11:36, Sascha Rodekamp wrote:
>
>> Hm ok I had similar issues when there where old corrupted jobs in the
>> sandbox.
>>
>> Am 22.02.2012 um 12:20 schrieb Dean Pullen<de...@semantico.com>
>> >:
>>
>> Thanks for the reply, but still seeing the same exceptions.
>>>
>>> [java] [TransactionUtil.**setRollbackOnly] Calling transaction
>>> setRollbackOnly; this stack trace shows where this is happening:
>>> [java] Exception: java.lang.Exception
>>> [java] Message: Failure in storeByCondition operation for entity
>>> [JobSandbox]: org.ofbiz.entity.**GenericDataSourceException: Generic
>>> Entity Exception occured in updateByCondition (SQL Exception while
>>> executing the following:UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>> STATUS_ID = ? WHERE ((RUN_TIME<= '2012-02-22 11:19:04.663' 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 = 'pool')) (Cannot execute
>>> statement: impossible to write to binary log since BINLOG_FORMAT =
>>> STATEMENT and at least one table uses a storage engine limited to row-based
>>> logging. InnoDB is limited to row-logging when transaction isolation level
>>> is READ COMMITTED or READ UNCOMMITTED.)). Rolling back transaction.
>>>
>>>
>>>
>>> On 22/02/2012 11:02, Sascha Rodekamp wrote:
>>>
>>>> Hey
>>>> Try to empty the Job_Sandbox table. That should solve the problem.
>>>>
>>>> Have a good day
>>>> Sascha
>>>>
>>>> Am 22.02.2012 um 11:23 schrieb Dean Pullen<de...@semantico.com>
>>>> >:
>>>>
>>>> After restarting my dev machine, where upon Ofbiz was previously
>>>>> working, I'm now getting these errors for every DB call from ./ant run
>>>>>
>>>>>
>>>>> 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 JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
>>>>> STATUS_ID = ? WHERE ((RUN_TIME<= '2012-02-22 10:16:46.439' 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 = 'pool')) (Cannot execute
>>>>> statement: impossible to write to binary log since BINLOG_FORMAT =
>>>>> STATEMENT and at least one table uses a storage engine limited to row-based
>>>>> logging. InnoDB is limited to row-logging when transaction isolation level
>>>>> is READ COMMITTED or READ UNCOMMITTED.)). Rolling back transaction.
>>>>> [java] org.ofbiz.entity.transaction.**TransactionUtil.**
>>>>> setRollbackOnly(**TransactionUtil.java:370)
>>>>> [java] org.ofbiz.entity.transaction.**TransactionUtil.rollback(**
>>>>> TransactionUtil.java:312)
>>>>> [java] org.ofbiz.entity.**GenericDelegator.**storeByCondition(**
>>>>> GenericDelegator.java:1300)
>>>>> [java] org.ofbiz.entity.**GenericDelegator.**storeByCondition(**
>>>>> GenericDelegator.java:1261)
>>>>> [java] org.ofbiz.service.job.**JobManager.poll(JobManager.**
>>>>> java:157)
>>>>> [java] org.ofbiz.service.job.**JobPoller.run(JobPoller.java:**90)
>>>>> [java] java.lang.Thread.run(Thread.**java:680)
>>>>>
>>>>> Can anyone help me with this please?
>>>>>
>>>>> Many thanks,
>>>>>
>>>>> Dean.
>>>>>
>>>>
--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Phone: (03) 9585 6788
Fax: (03) 9585 1086
Web: http://www.cohsoft.com.au/
Email: sales@cohsoft.com.au
Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/
Re: Mysql problems
Posted by Dean Pullen <de...@semantico.com>.
Can anyone else help? Completely stuck when trying to start the server...
Dean.
On 22/02/2012 11:36, Sascha Rodekamp wrote:
> Hm ok I had similar issues when there where old corrupted jobs in the sandbox.
>
> Am 22.02.2012 um 12:20 schrieb Dean Pullen<de...@semantico.com>:
>
>> Thanks for the reply, but still seeing the same exceptions.
>>
>> [java] [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening:
>> [java] Exception: java.lang.Exception
>> [java] Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME<= '2012-02-22 11:19:04.663' 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 = 'pool')) (Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.)). Rolling back transaction.
>>
>>
>>
>> On 22/02/2012 11:02, Sascha Rodekamp wrote:
>>> Hey
>>> Try to empty the Job_Sandbox table. That should solve the problem.
>>>
>>> Have a good day
>>> Sascha
>>>
>>> Am 22.02.2012 um 11:23 schrieb Dean Pullen<de...@semantico.com>:
>>>
>>>> After restarting my dev machine, where upon Ofbiz was previously working, I'm now getting these errors for every DB call from ./ant run
>>>>
>>>>
>>>> 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 JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME<= '2012-02-22 10:16:46.439' 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 = 'pool')) (Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.)). Rolling back transaction.
>>>> [java] org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:370)
>>>> [java] org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:312)
>>>> [java] org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1300)
>>>> [java] org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1261)
>>>> [java] org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
>>>> [java] org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
>>>> [java] java.lang.Thread.run(Thread.java:680)
>>>>
>>>> Can anyone help me with this please?
>>>>
>>>> Many thanks,
>>>>
>>>> Dean.
Re: Mysql problems
Posted by Sascha Rodekamp <sa...@googlemail.com>.
Hm ok I had similar issues when there where old corrupted jobs in the sandbox.
Am 22.02.2012 um 12:20 schrieb Dean Pullen <de...@semantico.com>:
> Thanks for the reply, but still seeing the same exceptions.
>
> [java] [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening:
> [java] Exception: java.lang.Exception
> [java] Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2012-02-22 11:19:04.663' 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 = 'pool')) (Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.)). Rolling back transaction.
>
>
>
> On 22/02/2012 11:02, Sascha Rodekamp wrote:
>> Hey
>> Try to empty the Job_Sandbox table. That should solve the problem.
>>
>> Have a good day
>> Sascha
>>
>> Am 22.02.2012 um 11:23 schrieb Dean Pullen<de...@semantico.com>:
>>
>>> After restarting my dev machine, where upon Ofbiz was previously working, I'm now getting these errors for every DB call from ./ant run
>>>
>>>
>>> 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 JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME<= '2012-02-22 10:16:46.439' 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 = 'pool')) (Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.)). Rolling back transaction.
>>> [java] org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:370)
>>> [java] org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:312)
>>> [java] org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1300)
>>> [java] org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1261)
>>> [java] org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
>>> [java] org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
>>> [java] java.lang.Thread.run(Thread.java:680)
>>>
>>> Can anyone help me with this please?
>>>
>>> Many thanks,
>>>
>>> Dean.
Re: Mysql problems
Posted by Dean Pullen <de...@semantico.com>.
Thanks for the reply, but still seeing the same exceptions.
[java] [TransactionUtil.setRollbackOnly] Calling transaction
setRollbackOnly; this stack trace shows where this is happening:
[java] Exception: java.lang.Exception
[java] Message: Failure in storeByCondition operation for entity
[JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic
Entity Exception occured in updateByCondition (SQL Exception while
executing the following:UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
STATUS_ID = ? WHERE ((RUN_TIME <= '2012-02-22 11:19:04.663' 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 = 'pool'))
(Cannot execute statement: impossible to write to binary log since
BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine
limited to row-based logging. InnoDB is limited to row-logging when
transaction isolation level is READ COMMITTED or READ UNCOMMITTED.)).
Rolling back transaction.
On 22/02/2012 11:02, Sascha Rodekamp wrote:
> Hey
> Try to empty the Job_Sandbox table. That should solve the problem.
>
> Have a good day
> Sascha
>
> Am 22.02.2012 um 11:23 schrieb Dean Pullen<de...@semantico.com>:
>
>> After restarting my dev machine, where upon Ofbiz was previously working, I'm now getting these errors for every DB call from ./ant run
>>
>>
>> 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 JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME<= '2012-02-22 10:16:46.439' 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 = 'pool')) (Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.)). Rolling back transaction.
>> [java] org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:370)
>> [java] org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:312)
>> [java] org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1300)
>> [java] org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1261)
>> [java] org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
>> [java] org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
>> [java] java.lang.Thread.run(Thread.java:680)
>>
>> Can anyone help me with this please?
>>
>> Many thanks,
>>
>> Dean.
Re: Mysql problems
Posted by Sascha Rodekamp <sa...@googlemail.com>.
Hey
Try to empty the Job_Sandbox table. That should solve the problem.
Have a good day
Sascha
Am 22.02.2012 um 11:23 schrieb Dean Pullen <de...@semantico.com>:
> After restarting my dev machine, where upon Ofbiz was previously working, I'm now getting these errors for every DB call from ./ant run
>
>
> 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 JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2012-02-22 10:16:46.439' 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 = 'pool')) (Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.)). Rolling back transaction.
> [java] org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:370)
> [java] org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:312)
> [java] org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1300)
> [java] org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1261)
> [java] org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> [java] org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> [java] java.lang.Thread.run(Thread.java:680)
>
> Can anyone help me with this please?
>
> Many thanks,
>
> Dean.