Troubleshooting slow query in ignition.gateway.localdb.sqlite.singleConnectionDatasource

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.