ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacques Le Roux <jacques.le.r...@les7arts.com>
Subject Re: OFBiz MySQL installation: Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
Date Wed, 26 Aug 2015 19:40:39 GMT
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 <morten@citizenme.com> 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 <morten@citizenme.com>
>> 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
>>>
>>>
>>>
>>>

Mime
View raw message