Tabledeletetask error

Ignition
1

we are getting a repeating error, looks like it is part of some transaction group table maintenance?
it starts with the warning:
“Slow query “SELECT max(“tower_c_ndx”) FROM Tower_C WHERE “t_stamp”<?” took 36 seconds”
then an error:
“TableDeleteTask 21Sep2019 15:46:41 Error executing table data delete maintenance task.”

the following is part of the error details. Any idea what would be causing this?
Thanks

com.microsoft.sqlserver.jdbc.SQLServerException: Read timed out

at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1355)

at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1532)

at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:3274)

at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:4433)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:386)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)

at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)

at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)

at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.executeUpdate(SRConnectionWrapper.java:955)

at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper.runPrepUpdate(SRConnectionWrapper.java:180)

at com.inductiveautomation.factorysql.maintenance.TableDeleteTask.run(TableDeleteTask.java:133)

at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$SelfSchedulingRunner.run(BasicExecutionEngine.java:483)

at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:565)

at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.base/java.util.concurrent.FutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

2

The table data delete operation is taking longer than the connection’s timeout, preventing it from completing. Incomplete statements are typically rolled back, so no progress is made. You may have to perform the delete manually outside of Ignition (in your DB workspace tool of choice).

Meanwhile, ensure your DB has an appropriate set of indices on table timestamp columns.

3

Is the table delete function part of the transaction group normal operation?

4

It is optional.