# Database state is in idle

**URL:** <https://forum.inductiveautomation.com/t/database-state-is-in-idle/84206>\
**Category:** Ignition\
**Created:** [January 12, 2024, 4:51pm UTC](https://forum.inductiveautomation.com/t/database-state-is-in-idle/84206 "2024-01-12T16:51:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alex\_Evans](https://avatars.discourse-cdn.com/v4/letter/a/f14d63/32.png) [@Alex\_Evans](https://forum.inductiveautomation.com/u/Alex_Evans)\
**Post date:** [January 12, 2024, 4:51pm UTC](https://forum.inductiveautomation.com/t/database-state-is-in-idle/84206/1 "2024-01-12T16:51:54Z")

</div>

Hi,

I have just checked the database connection to see that the database state says its in idle and the data is just accumulating in the data cache and I am getting some data quarantined but I don't know why? any help appreciated.

 ![Screenshot 2024-01-12 164539](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/5/45be1ff1e392542f6d8c622c277daa2e228edebb.png)  
 ![Screenshot 2024-01-12 164612](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/f/9fbe762ace4ce26edaabc80e45d54d5ae3ddd070.png)

---

<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:** [January 12, 2024, 6:38pm UTC](https://forum.inductiveautomation.com/t/database-state-is-in-idle/84206/2 "2024-01-12T18:38:23Z")

</div>

Start by getting rid of SQLite. It is not suitable for production history storage (it is optimized for super-simple configuration storage, and is single threaded).

If you need something free, use PostgreSQL or MariaDB.