Hi, I have many inputs using SQL queries running every 15 secs or so in many of my windows in Vision and I often get this error message.
Exception: Error running query:
WHERE RowNo = 13, database=)@20000ms
On: Line 2 Shift 1.Root Container.ST13.floatValue
caused by GatewayException: Connection Error: Cannot get a connection, pool error Timeout waiting for idle object
caused by SQLException: Cannot get a connection, pool error Timeout waiting for idle object
Ignition v8.1.30 (b2023071408)
Java: Azul Systems, Inc. 11.0.18
Any thoughts to make on resolving this issue? Thanks.
This is not an issue with the query but with your gateway getting a connection to your database. It's possible your database is occasionally unreachable which could cause such an error and that could be for a variety of reasons, or your connection pool is full.
You may want to check out your db logs and if there is a dba who is in charge of it - talk to them if there is one.
This sounds pathological. Why is this necessary?
We have data from a legacy monitoring system that stores to SQL DB. So in the short term, we have created many SQL queries of many of our tags and inputs etc.Could that be the cause?
Is it really updating every 15 seconds? If so ok, but you have this same logic on each window? Seems better suited as a gateway tags (if the same for the entire system) or vision client tags (if specific to a single user). Otherwise a user has multiple windows open and now you are unnecessarily bogging down the db doing the same thing.
I have them on other windows but I have other projects inheriting from this one configured so that only the one window is active when others are using Vision client. Looking at the DB status, it's performing about 50-70 queries per secs. Is that too much?