# Cannot get a connection

**URL:** <https://forum.inductiveautomation.com/t/cannot-get-a-connection/11250>\
**Category:** Ignition\
**Created:** [February 22, 2016, 9:31pm UTC](https://forum.inductiveautomation.com/t/cannot-get-a-connection/11250 "2016-02-22T21:31:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![boster281](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@boster281](https://forum.inductiveautomation.com/u/boster281)\
**Post date:** [February 22, 2016, 9:31pm UTC](https://forum.inductiveautomation.com/t/cannot-get-a-connection/11250/1 "2016-02-22T21:31:55Z")

</div>

I have been having an issue where every few weeks I will get error codes like the picture, where my database connection drops out every few minutes.

Everything looks good except my store and forward ( 2nd picture)

But after a day to a week it will just start working. I have not followed closely enough to say with 100% confidence but tends to self repair over the weekends. IT says that they do nothing during this time with the server.

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [February 22, 2016, 10:50pm UTC](https://forum.inductiveautomation.com/t/cannot-get-a-connection/11250/2 "2016-02-22T22:50:01Z")

</div>

You could try increasing the max active pool connections.

This is a setting in the "advanced properties’ Edit Database Connection configuration in the Ignition Gateway.

The default value is 8 which is not very high.

You also check your slow query log to see if some slow queries are tying up your database connections.

---

<div class="post-metadata">

**Author:** ![boster281](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@boster281](https://forum.inductiveautomation.com/u/boster281)\
**Post date:** [February 23, 2016, 1:30pm UTC](https://forum.inductiveautomation.com/t/cannot-get-a-connection/11250/3 "2016-02-23T13:30:49Z")

</div>

What is a good number to set the pool connections to? And what is the down side to having it set to high?

Also where can I view the slow query log? Is that the live values in the database connections?