# Lost connection database Sql Server 2014

**URL:** <https://forum.inductiveautomation.com/t/lost-connection-database-sql-server-2014/70208>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [February 23, 2023, 8:19am UTC](https://forum.inductiveautomation.com/t/lost-connection-database-sql-server-2014/70208 "2023-02-23T08:19:27Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![stefano.sforna](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@stefano.sforna](https://forum.inductiveautomation.com/u/stefano.sforna)\
**Post date:** [February 23, 2023, 8:19am UTC](https://forum.inductiveautomation.com/t/lost-connection-database-sql-server-2014/70208/1 "2023-02-23T08:19:28Z")

</div>

Hi,  
all the morning, at 5: 30 o'clock, Gateway of Ignition 8.1.16, lost connection with SQL SERVER 2014 databse.  
In the Wrapper log, I have this error message:

**[05:31:00]: Database connection FAULTED. database=Report, request-origin=127.0.0.1, session-user=admin, session-project=Pavesmac, session-id=002D57F9**  
\*\* java.sql.SQLException: Cannot get a connection, pool error Timeout waiting for idle object\*\*

Why ???  
Then, i restart Gateway and connection it's ok.

Thank you

---

<div class="post-metadata">

**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:** [February 23, 2023, 12:36pm UTC](https://forum.inductiveautomation.com/t/lost-connection-database-sql-server-2014/70208/2 "2023-02-23T12:36:16Z")

</div>

Some operation in your gateway sucked up the entire pool of actual connections and didn't give them back. Someone requesting reports in an infinite loop somewhere, perhaps? (Based on the DB name...)

---

<div class="post-metadata">

**Author:** ![stefano.sforna](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@stefano.sforna](https://forum.inductiveautomation.com/u/stefano.sforna)\
**Post date:** [February 27, 2023, 8:10am UTC](https://forum.inductiveautomation.com/t/lost-connection-database-sql-server-2014/70208/3 "2023-02-27T08:10:45Z")

</div>

For precision, there is this error:

**Exception: Error running query:**  
**SQLQuery(query=SELECT distinct operatore**  
**FROM Report\_Mixer\_2023**  
\*\*where \*\*  
\*\*cast(inizio\_mescolazione as datetime) BETWEEN '2023-02-08T00:00:00' AND '2023-02-27T23:59:00' and cast(fine\_mescolazione as datetime) BETWEEN '2023-02-08T00:00:00' AND '2023-02-27T23:59:00' \*\*

\*\* , database=Report)@5000ms\*\*  
**On: Report.Root Container.ListaOperatori.data**  
\*\* 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\*\*

ListaOperatori is a DropDown List

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [February 27, 2023, 12:35pm UTC](https://forum.inductiveautomation.com/t/lost-connection-database-sql-server-2014/70208/4 "2023-02-27T12:35:59Z")

</div>

Consider turning off the polling.

---

<div class="post-metadata">

**Author:** ![tzbh1234](https://avatars.discourse-cdn.com/v4/letter/t/c67d28/32.png) [@tzbh1234](https://forum.inductiveautomation.com/u/tzbh1234)\
**Post date:** [February 27, 2023, 12:45pm UTC](https://forum.inductiveautomation.com/t/lost-connection-database-sql-server-2014/70208/5 "2023-02-27T12:45:34Z")

</div>

Please check your java version and support ignition version.

---

<div class="post-metadata">

**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:** [February 27, 2023, 1:00pm UTC](https://forum.inductiveautomation.com/t/lost-connection-database-sql-server-2014/70208/6 "2023-02-27T13:00:22Z")

</div>

> [@stefano.sforna](#):
>
> Cannot get a connection, pool error Timeout waiting for idle object

This error shows up on many different things in Ignition when _ **other things** _ are hogging your database connections. You might eventually get "slow query" reports on those other things. But the **precise** details of this particular error are not meaningful in themselves, they are just showing what _ **else** _ is broken by your overloaded database.

Find out what is overloading your database.