Hi again,
Ok, I bit the bullet and wiped MariaDB and instead installed MySQL server
("Server version: 5.6.25-0ubuntu0.15.04.1 (Ubuntu)") - also from standard
Ubuntu packaging (apt-get). A very similar issue occurs for some SQL
statements - but in this case the specific OPTION invoked is revealed as
"SQL_SELECT_LIMIT=1" (or default - or whatever).
A quick grep through the enclosed java code the only location I see the
string "SQL_SELECT_LIMIT" is in an array in
framework/entity/src/org/ofbiz/entity/model/ModelEntityChecker.java. But
then I probably don't have full source as I downloaded the "binary"
distribution of OFBiz.
Btw. for reference, I installed the mysql JDBC drivers as per the build
documentation: ./ant download-mySQL-JDBC.
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME DESC
(You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'OPTION
SQL_SELECT_LIMIT=1' at line 1)
runtime/logs/error.log:Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=1'
at line 1
Thanks in advance for your assistance.
Best regards,
Morten Jensen
On Wed, Aug 26, 2015 at 8:42 AM, Morten Jensen <[email protected]>
wrote:
Hi,
I'm an OFBiz newbie but have managed to get through installation of OFBiz
version 13.07.02 with MySQL (MariaDB "Server version:
10.0.20-MariaDB-0ubuntu0.15.04.1 (Ubuntu)"). However, I notice in the
logs
errors for some queries:
Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
I have included an example of the rather extensive logging that follows
at
the bottom of this email. The problems have so far not directly caused
OFBiz to fail at frontend but I do see the errors occuring when I browse
some areas of the app (or even of its own in the background jobs) - for
instance when I enter Accounts Chart in Accounts.
Does anyone know what is causing this problem? (At list in MariaDB) there
doesn't appear to be a system variable 'OPTION' but I'm not entirely
convinced that this error message isn't misleading?
Thanks in advance for your assistance.
Best regards,
Morten
2015-08-26 00:00:23,370 |OFBiz-JobQueue-0
|TransactionUtil |W| [TransactionUtil.begin] active
transaction marked for rollback in place, so no transaction begun; this
stack trace shows when the exception began:
java.lang.Exception: Tx Stack Placeholder
at
org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:743)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:169)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:314)
[ofbiz-service.jar:?]
at
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
[ofbiz-service.jar:?]
at
org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
[ofbiz-service.jar:?]
at
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
[ofbiz-service.jar:?]
at org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz-service.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[?:1.7.0_79]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[?:1.7.0_79]
at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79]
2015-08-26 00:00:23,370 |OFBiz-JobQueue-0
|GenericDelegator |E| Failure in findOne operation for
entity
[OrderHeader]: org.ofbiz.entity.transaction.GenericTransactionException:
The current transaction is marked for rollback, not beginning a new
transaction and aborting current operation; the rollbackOnly was caused
by:
Failure in findByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing
the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME
DESC
(Unknown system variable 'OPTION'). Rolling back
transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION')). Rolling back
transaction.
org.ofbiz.entity.transaction.GenericTransactionException: The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Failure in
findByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing
the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME
DESC
(Unknown system variable 'OPTION'). Rolling back
transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION'))
at
org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:156)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:124)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1500)
[ofbiz-entity-test.jar:?]
at
org.ofbiz.order.order.OrderReadHelper.<init>(OrderReadHelper.java:132)
[ofbiz-order.jar:?]
at
org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocsForOrder(OrderServices.java:5800)
[ofbiz-order.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.7.0_79]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
~[?:1.7.0_79]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.7.0_79]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
at
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
[ofbiz-service.jar:?]
at
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
[ofbiz-service.jar:?]
at
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
[ofbiz-service.jar:?]
at
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
[ofbiz-service.jar:?]
at
org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
[ofbiz-service.jar:?]
at
org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5788)
[ofbiz-order.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.7.0_79]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
~[?:1.7.0_79]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.7.0_79]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
at
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
[ofbiz-service.jar:?]
at
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
[ofbiz-service.jar:?]
at
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
[ofbiz-service.jar:?]
at
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
[ofbiz-service.jar:?]
at
org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
[ofbiz-service.jar:?]
at
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
[ofbiz-service.jar:?]
at org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz-service.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[?:1.7.0_79]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[?:1.7.0_79]
at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79]
Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION')
at
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:391)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
~[ofbiz-order.jar:?]
... 14 more
Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
~[mysql-connector-java-5.1.6.jar:?]
at
com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1463)
~[mysql-connector-java-5.1.6.jar:?]
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1872)
~[mysql-connector-java-5.1.6.jar:?]
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
~[commons-dbcp-1.4.jar:1.4]
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
~[commons-dbcp-1.4.jar:1.4]
at
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:388)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
~[ofbiz-order.jar:?]
... 14 more
2015-08-26 00:00:23,372 |OFBiz-JobQueue-0
|TransactionUtil |I| [TransactionUtil.setRollbackOnly]
transaction rollback only not set, rollback only is already set.
2015-08-26 00:00:23,372 |OFBiz-JobQueue-0
|OrderReadHelper |E| Error finding order with ID
[DEMO10090]:
org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.transaction.GenericTransactionException: The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Failure in
findByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing
the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME
DESC
(Unknown system variable 'OPTION'). Rolling back
transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION')) (The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Failure in
findByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing
the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME
DESC
(Unknown system variable 'OPTION'). Rolling back
transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION')))
org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.transaction.GenericTransactionException: The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Failure in
findByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing
the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME
DESC
(Unknown system variable 'OPTION'). Rolling back
transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION')) (The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Failure in
findByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing
the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME
DESC
(Unknown system variable 'OPTION'). Rolling back
transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION')))
at
org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1534)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.order.order.OrderReadHelper.<init>(OrderReadHelper.java:132)
[ofbiz-order.jar:?]
at
org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocsForOrder(OrderServices.java:5800)
[ofbiz-order.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.7.0_79]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
~[?:1.7.0_79]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.7.0_79]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
at
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
[ofbiz-service.jar:?]
at
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
[ofbiz-service.jar:?]
at
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
[ofbiz-service.jar:?]
at
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
[ofbiz-service.jar:?]
at
org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
[ofbiz-service.jar:?]
at
org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5788)
[ofbiz-order.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.7.0_79]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
~[?:1.7.0_79]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.7.0_79]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
at
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
[ofbiz-service.jar:?]
at
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
[ofbiz-service.jar:?]
at
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
[ofbiz-service.jar:?]
at
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
[ofbiz-service.jar:?]
at
org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
[ofbiz-service.jar:?]
at
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
[ofbiz-service.jar:?]
at org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz-service.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[?:1.7.0_79]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[?:1.7.0_79]
at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79]
Caused by: org.ofbiz.entity.transaction.GenericTransactionException: The
current transaction is marked for rollback, not beginning a new
transaction
and aborting current operation; the rollbackOnly was caused by: Failure
in
findByCondition operation for entity [JobSandbox]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing
the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME
DESC
(Unknown system variable 'OPTION'). Rolling back
transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION'))
at
org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:156)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:124)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1500)
~[ofbiz-entity-test.jar:?]
... 26 more
Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP
FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
START_DATE_TIME DESC (Unknown system variable 'OPTION')
at
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:391)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
~[ofbiz-order.jar:?]
... 14 more
Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
~[mysql-connector-java-5.1.6.jar:?]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
~[mysql-connector-java-5.1.6.jar:?]
at
com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1463)
~[mysql-connector-java-5.1.6.jar:?]
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1872)
~[mysql-connector-java-5.1.6.jar:?]
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
~[commons-dbcp-1.4.jar:1.4]
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
~[commons-dbcp-1.4.jar:1.4]
at
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:388)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
~[ofbiz-entity-test.jar:?]
at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
~[ofbiz-entity-test.jar:?]
at
org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
~[ofbiz-order.jar:?]
... 14 more
2015-08-26 00:00:23,373 |OFBiz-JobQueue-0
|ServiceDispatcher |T| [[Sync service failed...-
total:0.0,since last(Begin):0.0]] - 'default /
createAlsoBoughtProductAssocsForOrder'
2015-08-26 00:00:23,373 |OFBiz-JobQueue-0
|TransactionUtil |I| [TransactionUtil.setRollbackOnly]
transaction rollback only not set, rollback only is already set.
2015-08-26 00:00:23,373 |OFBiz-JobQueue-0
|OrderServices |E| null
