ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pierre Smits <pierre.sm...@gmail.com>
Subject Re: OFBiz MySQL installation: Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
Date Thu, 27 Aug 2015 21:37:12 GMT
Thanks for the follow-up, BJ.

And welcome back.

Best regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

On Thu, Aug 27, 2015 at 10:04 PM, BJ Freeman <bjfr33man@yahoo.com.invalid>
wrote:

> though the error is in the sql query, it originated in the driver for the
> db.this is not an error of ofbiz but the db capability to handle the
> query.for instance the error does not happen with PostgreSQL
>
>
>      On Wednesday, August 26, 2015 12:40 PM, Jacques Le Roux <
> jacques.le.roux@les7arts.com> 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 <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