We see a fair amount of these "ResultWriter - Error executing historical tag read" errors in the logs for our back end (Tag gateway) and front end (Vision gateway) servers. I have not been able to track down the cause.
I have attached some screen shots of some recent errors logged. Each log item references a different query ID, of which I haven't figured any way to search and track those ID's. Are they stored somewhere and should I be able to find them?
I'm also a bit puzzled that I see these in the back end Gateway, as it does not have the Vision connection that our operators connect to via the front end gateway. The back end should only be writing to the database with history, no?
Thanks for any assistance and insight!
Click the plus icon to expand the details. We should be able to find out more information from there.
I can't really tell what else might be going on without more detail.
Hello, Brandon. Thanks for replying. And, sorry for the delay in getting follow up info that you requested. Below is what I copied after expanding the log item:
com.inductiveautomation.ignition.common.StreamingDataset$StreamingException: java.util.concurrent.TimeoutException: Timeout waiting for other side to read dataset row.
at com.inductiveautomation.ignition.common.StreamingDataset.write(StreamingDataset.java:331)
at com.inductiveautomation.ignition.common.StreamingDataset.write(StreamingDataset.java:315)
at com.inductiveautomation.ignition.gateway.sqltags.history.query.HistoryWriter.commitRows(HistoryWriter.java:384)
at com.inductiveautomation.ignition.gateway.sqltags.history.query.HistoryWriter.readData(HistoryWriter.java:327)
at com.inductiveautomation.ignition.gateway.sqltags.history.query.HistoryWriter.execute(HistoryWriter.java:232)
at com.inductiveautomation.ignition.gateway.sqltags.history.TagHistoryManagerImpl.queryHistory(TagHistoryManagerImpl.java:572)
at com.inductiveautomation.ignition.gateway.sqltags.history.distributed.TagHistoryServiceImpl.lambda$queryTagHistory$1(TagHistoryServiceImpl.java:115)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.util.concurrent.TimeoutException: Timeout waiting for other side to read dataset row.
... 8 common frames omitted
