Return-Path: X-Original-To: apmail-ofbiz-user-archive@www.apache.org Delivered-To: apmail-ofbiz-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A684118656 for ; Wed, 26 Aug 2015 19:40:56 +0000 (UTC) Received: (qmail 85032 invoked by uid 500); 26 Aug 2015 19:40:56 -0000 Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org Received: (qmail 85003 invoked by uid 500); 26 Aug 2015 19:40:56 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 84992 invoked by uid 99); 26 Aug 2015 19:40:55 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Aug 2015 19:40:55 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 72234C0BD8 for ; Wed, 26 Aug 2015 19:40:55 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.001 X-Spam-Level: * X-Spam-Status: No, score=1.001 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id nVfU6wLaNOG2 for ; Wed, 26 Aug 2015 19:40:44 +0000 (UTC) Received: from smtp24.services.sfr.fr (smtp24.services.sfr.fr [93.17.128.83]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id 1C1F3212C5 for ; Wed, 26 Aug 2015 19:40:44 +0000 (UTC) Received: from filter.sfr.fr (localhost [77.130.230.148]) by msfrf2418.sfr.fr (SMTP Server) with ESMTP id 0FEF17000126 for ; Wed, 26 Aug 2015 21:40:37 +0200 (CEST) Authentication-Results: sfrmc.priv.atos.fr; dkim=none (no signature); dkim-adsp=permerror (cannot check policy: Unable to verify) header.from= jacques.le.roux@les7arts.com Received: from [192.168.1.72] (148.230.130.77.rev.sfr.net [77.130.230.148]) by msfrf2418.sfr.fr (SMTP Server) with ESMTP id 3C4DB700011E for ; Wed, 26 Aug 2015 21:40:36 +0200 (CEST) X-SFR-UUID: 20150826194036247.3C4DB700011E@msfrf2418.sfr.fr Subject: Re: OFBiz MySQL installation: Caused by: java.sql.SQLException: Unknown system variable 'OPTION' To: user@ofbiz.apache.org References: From: Jacques Le Roux Organization: Les Arts Informatiques Message-ID: <55DE1637.1010908@les7arts.com> Date: Wed, 26 Aug 2015 21:40:39 +0200 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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 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 >> 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.(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.(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 >>> >>> >>> >>>