ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Morten Jensen <mor...@citizenme.com>
Subject Re: OFBiz MySQL installation: Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
Date Wed, 26 Aug 2015 13:30:18 GMT
Hi Pierre, thanks for your response, much appreciated. I have raised a bug
as you suggested: https://issues.apache.org/jira/browse/OFBIZ-6582

Thanks.
Morten

On Wed, Aug 26, 2015 at 2:10 PM, Pierre Smits <pierre.smits@gmail.com>
wrote:

> Hi Morten,
>
> Downloading the binary also includes the full source code. It seems you
> may have uncovered a bug. If so, feel free to register a JIRA issue.
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Wed, Aug 26, 2015 at 3:07 PM, Morten Jensen <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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message