Time Logger Message
5:56:06 PM SQLTags.TagProviders.Provider[Halliburton_ddp].TagStore Error upgrading external provider schema. Will attempt again the next time that the provider starts.
com.mysql.jdbc.exceptions.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
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3178)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1408)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.executeQuery(SRConnectionWrapper.java:808)
at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper.runScalarPrepQuery(SRConnectionWrapper.java:193)
at com.inductiveautomation.ignition.gateway.sqltags.providers.datasource.tagstore.DBTagStore.checkVersion(DBTagStore.java:2991)
at com.inductiveautomation.ignition.gateway.sqltags.providers.datasource.tagstore.DBTagStore.runTableVerification(DBTagStore.java:2939)
at com.inductiveautomation.ignition.gateway.sqltags.providers.datasource.tagstore.DBTagStore.configPoll(DBTagStore.java:436)
at com.inductiveautomation.ignition.gateway.sqltags.providers.datasource.tagstore.DBTagStore$PollRunner.run(DBTagStore.java:3732)
at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:573)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
I saw similar issue (viewtopic.php?f=72&t=9976&p=35013&hilit=com.mysql.jdbc.SQLError.createSQLException#p35013) I reloaded jar (mysql-connector-java-5.1.24-bin.jar) file and restarted gateway a few times, still getting this same error.
Thanks in advance with any tips.