# Over 250 Blocked Threads

**URL:** <https://forum.inductiveautomation.com/t/over-250-blocked-threads/20719>\
**Category:** Ignition\
**Created:** [November 9, 2018, 4:45pm UTC](https://forum.inductiveautomation.com/t/over-250-blocked-threads/20719 "2018-11-09T16:45:06Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![oscar.salcedo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/oscar.salcedo/32/11019_2.png) [@oscar.salcedo](https://forum.inductiveautomation.com/u/oscar.salcedo)\
**Post date:** [November 9, 2018, 4:45pm UTC](https://forum.inductiveautomation.com/t/over-250-blocked-threads/20719/1 "2018-11-09T16:45:06Z")

</div>

Hi,

Our Ignition Gateway is experiencing an abnormal amount of Blocked threads; database access seems to be the most affected by it, causing a few of our Gateway Timer Scripts that perform some sort of DB access to run extremely slow. The database instance is functioning normally otherwise.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4da94ec08be9e99e7b5ac8e22ba09cf5105bd235.png)

I have attached a Thread Dump for your review.

Thanks!  
Oscar.[thread\_dump.txt](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/31b803b5d8d8a6904cf5d71ba352ca9b08fe7acc.txt) (1.3 MB)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [November 9, 2018, 4:51pm UTC](https://forum.inductiveautomation.com/t/over-250-blocked-threads/20719/2 "2018-11-09T16:51:47Z")

</div>

~~It looks like something in the production model is hung up waiting to get a response from your MSSQL database - I would check with Sepasoft support: [https://www.sepasoft.com/support/](https://www.sepasoft.com/support/)~~

~~I’ll also tag @mark.french, in case this is a known issue.~~

You may need to restart the gateway, or at least the connection to your database (try an edit/save on the connection) - there are multiple DB connector threads stuck waiting to receive data (and they don’t have a timeout, so they’re just sitting and waiting indefinitely).

---

<div class="post-metadata">

**Author:** ![mark.french](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mark.french/32/4781_2.png) [@mark.french](https://forum.inductiveautomation.com/u/mark.french)\
**Post date:** [November 9, 2018, 6:35pm UTC](https://forum.inductiveautomation.com/t/over-250-blocked-threads/20719/3 "2018-11-09T18:35:22Z")

</div>

Hi @oscar.salcedo, I’ve passed this info to support to have them take a look at the thread dump. Not sure if it’s related to our module(s), but happy to assist debugging via our support channel.

Thanks for tagging me @paul-griffith!

---

<div class="post-metadata">

**Author:** ![oscar.salcedo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/oscar.salcedo/32/11019_2.png) [@oscar.salcedo](https://forum.inductiveautomation.com/u/oscar.salcedo)\
**Post date:** [November 9, 2018, 6:37pm UTC](https://forum.inductiveautomation.com/t/over-250-blocked-threads/20719/4 "2018-11-09T18:37:00Z")

</div>

Thanks.  
I saved the database connection entries to force a reconnect, but it did not seem to help any.  
We did restart the Gateway after exhausting all possible options. The system seems mostly stable at the time. We have opened a ticket and working with IA support now.

Thanks,

Oscar.

---

<div class="post-metadata">

**Author:** ![Bhargav.gorantlasrid](https://avatars.discourse-cdn.com/v4/letter/b/e68b1a/32.png) [@Bhargav.gorantlasrid](https://forum.inductiveautomation.com/u/Bhargav.gorantlasrid)\
**Post date:** [January 3, 2020, 9:46pm UTC](https://forum.inductiveautomation.com/t/over-250-blocked-threads/20719/5 "2020-01-03T21:46:34Z")

</div>

@oscar.salcedo Were you able to root cause this issue ? I have a similar problem, I have a gateway timer script that reads messages from kafka and runs update queries on the database. The script runs on a dedicated thread. The script and the store and forward thread often go into a state of blocked. I have a ticket with inductive open #111758

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [September 27, 2020, 12:03am UTC](https://forum.inductiveautomation.com/t/over-250-blocked-threads/20719/7 "2020-09-27T00:03:34Z")

</div>

A post was split to a new topic: [Many Blocked Threads](https://forum.inductiveautomation.com/t/many-blocked-threads/39095)
