How can I determine what database caused this issue?
The first step would be looking at the full error message.
Not just the full error, but also the query and table definition.
Edit: sorry, misread the question
Presumably if they don't know the database, then they also don't know the query or table definition?
1 Like
Yes, you're totally right. I misread the question.
Sorry, I should have said the data table that is in question.
If you can share the full error message, generally it will give the stack trace and that may give us some clue as to where to look for the query that resulted in this error. That would then indicate which data table produced the error. The error message might even include the exact query as this is a syntax error.
2 Likes
INFO |
jvm 1 | 2025/08/08 14:47:32 | E [s.M.TableDeleteTask ] [14:47:32.520]: Error executing table data delete maintenance task.INFO | jvm 1 | 2025/08/08 14:47:32 | java.sql.SQLSyntaxErrorException: Unknown column 't_stamp' in 'where clause'INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1031)INFO |
jvm 1 | 2025/08/08 14:47:32 | at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)INFO |
jvm 1 | 2025/08/08 14:47:32 | at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.executeUpdate(SRConnectionWrapper.java:981)INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper.runPrepUpdate(SRConnectionWrapper.java:181)INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.inductiveautomation.factorysql.maintenance.TableDeleteTask.run(TableDeleteTask.java:134)INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$SelfSchedulingRunner.run(BasicExecutionEngine.java:504)INFO |
jvm 1 | 2025/08/08 14:47:32 | at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:593)INFO |
jvm 1 | 2025/08/08 14:47:32 | at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)INFO |
jvm 1 | 2025/08/08 14:47:32 | at java.base/java.util.concurrent.FutureTask.run(Unknown Source)INFO |
jvm 1 | 2025/08/08 14:47:32 | at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)INFO |
jvm 1 | 2025/08/08 14:47:32 | at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)INFO |
jvm 1 | 2025/08/08 14:47:32 | at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)INFO |
jvm 1 | 2025/08/08 14:47:32 | at java.base/java.lang.Thread.run(Unknown Source)
The error is being generated by a Transaction Group trying to delete records in it’s maintained table. So not caused by anything that you specifically wrote.
What drew your attention to this particular error? Or did you just happen to notice it in the wrapper log?
That I agree with. Now, how can I find the particular transaction group that caused the failure?