Hi Pierre, thanks for your response, much appreciated. I have raised a bug as you suggested: https://issues.apache.org/jira/browse/OFBIZ-6582
Thanks. Morten On Wed, Aug 26, 2015 at 2:10 PM, Pierre Smits <[email protected]> wrote: > Hi Morten, > > Downloading the binary also includes the full source code. It seems you > may have uncovered a bug. If so, feel free to register a JIRA issue. > > Best regards, > > Pierre Smits > > *ORRTIZ.COM <http://www.orrtiz.com>* > Services & Solutions for Cloud- > Based Manufacturing, Professional > Services and Retail & Trade > http://www.orrtiz.com > > On Wed, Aug 26, 2015 at 3:07 PM, Morten Jensen <[email protected]> > wrote: > >> 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 >> > >> > >> > >> > >> > >
