Hi all,
I'm getting
com.inductiveAutomation.ignition.client.gateway_interface.GatewayException: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Read timed out
caused by GatewayException: Read timed out
caused by SocketTimeoutException: Read timed out
using Ingition v7.9.2 (b2017041315)
Java: Oracle Corp 1.8.1_141
using MySQL Server 2014 on a separate VM
In a client startup script I have system.util.setReadTimeout(600000). My polling base rate is 5000, connection timeout is 10000, read timeout is 600000
The timeout error occurs exactly 1 minute after firing the query. The query is not overly large, pulling about 6 days of 1 hour data for 2 tags, and it occasionally works.
Does anyone have any ideas about why this could be happening, or where I should check next to troubleshoot?
Thanks!
The query is not overly large, pulling about 6 days of 1 hour data for 2 tags, and it occasionally works.
How many rows are in the sqlth_te? How about in the most recent sqlt_data_X_date partition?
What's your aggregation mode, and return size (I'm guessing 1hr interval, but just want to confirm)?
The aggregation mode is average, we’re using startDate, lastDate and then using those to calculate a return size yielding exactly 1 hour data.
The size of the dataset is just one factor. Get a client app and try the query from that same computer. I’m guessing you have one already. If not, search for HeidiSQL, Navicat, DBTools, the free version is all you need for this. Most likely, you’ll get the same response time. If that’s the case, you’ll have to analyze the query in detail and find out why is taking too long. The lack of an index or the order of where clauses can cause huge differences in processing time.