Thanks for the follow-up, BJ. And welcome back.
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 Thu, Aug 27, 2015 at 10:04 PM, BJ Freeman <[email protected]> wrote: > though the error is in the sql query, it originated in the driver for the > db.this is not an error of ofbiz but the db capability to handle the > query.for instance the error does not happen with PostgreSQL > > > On Wednesday, August 26, 2015 12:40 PM, Jacques Le Roux < > [email protected]> wrote: > > > Thanks Vyom, > > Fixed with OFBIZ-6582 > > Jacques > > Le 26/08/2015 15:41, Vyom Jain a écrit : > > ./ant download-mySQL-JDBC is downloading mysql-connector-java-5.1.6.jar > > which is not compatible with your MySQL 5.6.25-0ubuntu0.15.04.1 (Ubuntu). > > You should instead - > > 1. Stop OFBiz > > 2. Remove framework/entity/lib/jdbc/mysql-connector-java-5.1.6.jar > > 3. Download latest one (or one version prior) from > > http://dev.mysql.com/downloads/connector/j/ > > 4. Extract the jar file and place it in framework/entity/lib/jdbc/ > > 5. Start OFBiz > > > > Let me know if that helps. > > > > -- > > Vyom > > > > On 26 August 2015 at 18:37, 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 > >>> > >>> > >>> > >>> > > > >
