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<[email protected]>:
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.
