# SQLite quarantined data, possible conversion to PostgreSQL

**URL:** <https://forum.inductiveautomation.com/t/sqlite-quarantined-data-possible-conversion-to-postgresql/66033>\
**Category:** Ignition\
**Created:** [November 2, 2022, 9:19pm UTC](https://forum.inductiveautomation.com/t/sqlite-quarantined-data-possible-conversion-to-postgresql/66033 "2022-11-02T21:19:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrea.orlandini](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@andrea.orlandini](https://forum.inductiveautomation.com/u/andrea.orlandini)\
**Post date:** [November 2, 2022, 9:19pm UTC](https://forum.inductiveautomation.com/t/sqlite-quarantined-data-possible-conversion-to-postgresql/66033/1 "2022-11-02T21:19:26Z")

</div>

Hi all,

in one of my first project I made the wrong decision on choosing SQLite created directly in Ignition gateway. This database is frequently having lot of quarantined data when querying tag history from Gateway scripts or trends.  
I get a lot of time [SQLite busy] Database locked.  
Is it possible to reduce the quarantined data by changing store and forward settings?  
In other plants I use Postgresql which is a lot powerful, is there an easy way to convert from SQLite to Postgresql?

Thanks for your help!

---

<div class="post-metadata">

**Author:** ![Jacob\_Klever](https://avatars.discourse-cdn.com/v4/letter/j/ee7513/32.png) [@Jacob\_Klever](https://forum.inductiveautomation.com/u/Jacob_Klever)\
**Post date:** [November 9, 2022, 9:19pm UTC](https://forum.inductiveautomation.com/t/sqlite-quarantined-data-possible-conversion-to-postgresql/66033/2 "2022-11-09T21:19:34Z")

</div>

Hello Andrea,

What error message are you seeing on your quarantined items?  
Regarding your second question with a quick google search I was able to find several resources that allow for the migration of databases. I would utilize those recourses to have your database converted.

---

<div class="post-metadata">

**Author:** ![andrea.orlandini](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@andrea.orlandini](https://forum.inductiveautomation.com/u/andrea.orlandini)\
**Post date:** [January 23, 2023, 2:38pm UTC](https://forum.inductiveautomation.com/t/sqlite-quarantined-data-possible-conversion-to-postgresql/66033/3 "2023-01-23T14:38:17Z")

</div>

Hi Jacob.  
sorry for late reply.  
Here below the error:

> org.sqlite.SQLiteException: [SQLITE\_BUSY] The database file is locked (database is locked)  
> at org.sqlite.core.DB.newSQLException(DB.java:909)  
> at org.sqlite.core.DB.newSQLException(DB.java:921)  
> at org.sqlite.core.DB.throwex(DB.java:886)  
> at org.sqlite.core.DB.exec(DB.java:155)  
> at org.sqlite.jdbc3.JDBC3Connection.commit(JDBC3Connection.java:174)  
> at org.apache.commons.dbcp2.DelegatingConnection.commit(DelegatingConnection.java:367)  
> at org.apache.commons.dbcp2.DelegatingConnection.commit(DelegatingConnection.java:367)  
> at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper.commit(SRConnectionWrapper.java:347)  
> at com.inductiveautomation.ignition.gateway.history.sf.sinks.AbstractDatasourceSink.storeToDatasource(AbstractDatasourceSink.java:190)  
> 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:180)  
> at com.inductiveautomation.ignition.gateway.history.forwarders.ForwarderThread.run(ForwarderThread.java:147)

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [January 23, 2023, 2:49pm UTC](https://forum.inductiveautomation.com/t/sqlite-quarantined-data-possible-conversion-to-postgresql/66033/4 "2023-01-23T14:49:44Z")

</div>

That log makes perfect sense considering SQL lite only has one thread.