# Database periodically disconnects (MSSQL and Ignition 8.1) **URL:** \ **Category:** Ignition\ **Created:** [November 27, 2025, 5:13pm UTC](https://forum.inductiveautomation.com/t/database-periodically-disconnects-mssql-and-ignition-8-1/112488 "2025-11-27T17:13:50Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![yidir](https://avatars.discourse-cdn.com/v4/letter/y/35a633/32.png) [@yidir](https://forum.inductiveautomation.com/u/yidir)\ **Post date:** [November 27, 2025, 5:13pm UTC](https://forum.inductiveautomation.com/t/database-periodically-disconnects-mssql-and-ignition-8-1/112488/1 "2025-11-27T17:13:50Z")
I am getting these faults from the logs where the database faults: **java.sql.SQLException: Cannot get a connection, pool error Timeout waiting for idle object at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:142) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:734) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:300) at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl.getConnectionImpl(DatasourceManagerImpl.java:169) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnection(DatasourceImpl.java:293) at com.inductiveautomation.ignition.gateway.history.sf.sinks.AbstractDatasourceSink.storeToDatasource(AbstractDatasourceSink.java:165) at com.inductiveautomation.ignition.gateway.history.sf.sinks.AbstractDatasourceSink.storeData(AbstractDatasourceSink.java:156) at com.inductiveautomation.ignition.gateway.history.sf.sinks.AggregateSink.storeData(AggregateSink.java:165) at com.inductiveautomation.ignition.gateway.history.forwarders.ForwarderThread.run(ForwarderThread.java:147) Caused by: java.util.NoSuchElementException: Timeout waiting for idle object at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:321) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:428) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:232) at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) ... 8 common frames omitted** Sometimes I see the active connections showing 8/8. I wanna try to catch what’s happening (either from MS SQL or Ignition), if the db is getting slower or I’m actually having a heavier load and more queries. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [November 27, 2025, 5:23pm UTC](https://forum.inductiveautomation.com/t/database-periodically-disconnects-mssql-and-ignition-8-1/112488/2 "2025-11-27T17:23:31Z")
It just means that you are trying to run more simultaneous queries than you've allowed in your connection settings. (The default is eight.) There are many possible reasons: - Slow queries tying up the connections. (Many possible reasons for this, though poor indexing is common.) - Tag history high INSERT traffic. - Tag history high real-time chart traffic. If you legitimately have a busy system, consider increasing the number of allowed connections in the pool. (If your DB is actually overloaded, this won't help--you'll get the same errors, but with the higher number.) ---
**Author:** ![yidir](https://avatars.discourse-cdn.com/v4/letter/y/35a633/32.png) [@yidir](https://forum.inductiveautomation.com/u/yidir)\ **Post date:** [November 27, 2025, 5:47pm UTC](https://forum.inductiveautomation.com/t/database-periodically-disconnects-mssql-and-ignition-8-1/112488/3 "2025-11-27T17:47:08Z")
I think I can rule out #2 and #3 (real-time chart traffic, and tag history INSERT). It’s happened at a time where nobody was looking the live charts. Also, No tag was added to the historian and no changes were made in the History section of the tag editor. How can I track (if possible at all) which queries are running while the database fault happens? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [November 27, 2025, 5:51pm UTC](https://forum.inductiveautomation.com/t/database-periodically-disconnects-mssql-and-ignition-8-1/112488/4 "2025-11-27T17:51:30Z")
There's a diagnostic page that shows running queries for the connection. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [November 27, 2025, 7:23pm UTC](https://forum.inductiveautomation.com/t/database-periodically-disconnects-mssql-and-ignition-8-1/112488/5 "2025-11-27T19:23:18Z")
If you're not doing it already, the recommended practice is that your DB will be running on its own machine and not the same one as the Ignition gateway. ---
**Author:** ![yidir](https://avatars.discourse-cdn.com/v4/letter/y/35a633/32.png) [@yidir](https://forum.inductiveautomation.com/u/yidir)\ **Post date:** [November 27, 2025, 8:20pm UTC](https://forum.inductiveautomation.com/t/database-periodically-disconnects-mssql-and-ignition-8-1/112488/6 "2025-11-27T20:20:11Z")
They’re running on different VMs