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
>>>
>>>
>>>
>>>
