I've been trying to troubleshoot an issue with the gateway locking up, and it seems to be caused by an issue with a slow query on the localdb. I turned com.inductiveautomation.ignition.gateway.localdb.sqlite.SingleConnectionDatasource to the trace level in the log to try to troubleshoot which queries are bottlenecking the gateway, but all it gives me is a connection id. Is there anyway to see which scripts/triggers these connection ids are linked to so I can see what is responsible for slowing down the gateway? Thanks!
Is there any more useful information when you hit the +
symbol beside the log message?
No not really
Contacting support would be best.
1 Like
What are you using a sqllite database for? A sqllite database should only be used in very minimal applications... and if you are using it for a historian then I'm no surprised that you are having this issue. Go get a real database... Postgresql, mariaDB.