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 <dean.pullen@xxxxxxxxxxxxx>:

> 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<dean.pullen@xxxxxxxxxxxxx>:
>>
>>> 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.