# Performance issue and SQL lite tag reference error **URL:** \ **Category:** Ignition\ **Tags:** ignition83\ **Created:** [January 23, 2026, 6:51am UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503 "2026-01-23T06:51:10Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![arpit\_yadav](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@arpit\_yadav](https://forum.inductiveautomation.com/u/arpit_yadav)\ **Post date:** [January 23, 2026, 6:51am UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/1 "2026-01-23T06:51:10Z")
```python org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (cannot rollback - no transaction is active) at org.sqlite.core.DB.newSQLException(DB.java:1179) at org.sqlite.core.DB.newSQLException(DB.java:1190) at org.sqlite.core.DB.throwex(DB.java:1150) at org.sqlite.core.DB.exec(DB.java:198) at org.sqlite.SQLiteConnection.rollback(SQLiteConnection.java:460) at com.inductiveautomation.ignition.gateway.localdb.sqlite.SingleConnectionDatasource$ProtectedConnection.rollback(SingleConnectionDatasource.java:192) at com.inductiveautomation.ignition.gateway.localdb.DelegatingDataSource$DelegatingConnection.rollback(DelegatingDataSource.java:289) at com.inductiveautomation.ignition.gateway.tags.config.storage.resource.valueStore.db.TableHelper.useConnection$commitLogic(TableHelper.kt:123) at com.inductiveautomation.ignition.gateway.tags.config.storage.resource.valueStore.db.TableHelper.useConnection(TableHelper.kt:133) at com.inductiveautomation.ignition.gateway.tags.reference.TagReferenceTableHelper.insert(TagReferenceTableHelper.kt:40) at com.inductiveautomation.ignition.gateway.tags.reference.DbTagReferenceStore$TagTraceBatch.storeCurrentBatch(DbTagReferenceStore.kt:186) at com.inductiveautomation.ignition.gateway.tags.reference.DbTagReferenceStore$TagTraceBatch.executeAndReturnSize(DbTagReferenceStore.kt:176) at com.inductiveautomation.ignition.gateway.tags.reference.DbTagReferenceStore$TagTraceBatch.execute(DbTagReferenceStore.kt:165) at com.inductiveautomation.ignition.gateway.tags.evaluation.BatchContextImpl$OpController.run(BatchContextImpl.java:237) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) ``` getting this error beside I don't have any SQL lite connection to my gateway. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/2/a2bb4dec4e67fe11190d27ca2b1868d28a17b27a.png) and also getting the performance warning. ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [January 23, 2026, 8:23am UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/2 "2026-01-23T08:23:50Z")
You have tagged this as Ignition81 but that looks like an 8.3 Gateway overview. Please clarify what version you are on? ---
**Author:** ![arpit\_yadav](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@arpit\_yadav](https://forum.inductiveautomation.com/u/arpit_yadav)\ **Post date:** [January 23, 2026, 9:08am UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/3 "2026-01-23T09:08:31Z")
yes it 8.3.2 I didn't see the option for 8.3 ---
**Author:** ![arpit\_yadav](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@arpit\_yadav](https://forum.inductiveautomation.com/u/arpit_yadav)\ **Post date:** [January 23, 2026, 11:20am UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/4 "2026-01-23T11:20:04Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/c/1c9ac4177426da8c2a647d007b733c01f5fd59b5.png) This the error i am getting for the performance of the gateway . ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [January 23, 2026, 11:40am UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/5 "2026-01-23T11:40:23Z")
Can you zoom in on that RAM usage. Your RAM usage should look like a sawtooth pattern. In your Ignition Conf, set the init ram and max ram to the same. In your image, you are using 8.7GB. What are the settings for Max in conf? How much RAM does the server have? Is this installed on bare metal or a VM? ---
**Author:** ![arpit\_yadav](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@arpit\_yadav](https://forum.inductiveautomation.com/u/arpit_yadav)\ **Post date:** [January 23, 2026, 1:05pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/6 "2026-01-23T13:05:07Z")
> [@Matrix\_Engineering](#): > > this installed on bare metal or a VM? Can you zoom in on that RAM usage. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/d/8d46fd6be06851770a2db83577d6049b4cc519aa.png) Your RAM usage should look like a sawtooth pattern. **--No, its is breaking in between not following a continuous sawtooth pattern.** In your Ignition Conf, set the init ram and max ram to the same. **-- Init RAM is 1gb and max RAM is 24GB** In your image, you are using 8.7GB. What are the settings for Max in conf? **-- The max setting in conf is 24GB.** How much RAM does the server have? Is this installed on bare metal or a VM? -- **It is installed in EC2 instance.** ---
**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 23, 2026, 1:41pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/7 "2026-01-23T13:41:12Z")
Ignition v8.3 stopped using SQLite for its internal DB. This suggests you are using SQLite for a regular DB connection, possibly with history? If so, **DO NOT DO THIS**. SQLite is absolutely **NOT** suited to use in production for anything other than configuration content. ---
**Author:** ![arpit\_yadav](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@arpit\_yadav](https://forum.inductiveautomation.com/u/arpit_yadav)\ **Post date:** [January 23, 2026, 1:51pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/8 "2026-01-23T13:51:07Z")
I have to SQLlite db connection and so i upgraded init RAM to max RAM and restarted my gateway but now my gateway is not starting. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/e/9ec8dc8ec2fb6277db0da425f8e1c7f0822a8ecb.png) ---
**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Post date:** [January 23, 2026, 1:55pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/9 "2026-01-23T13:55:28Z")
Do you have enough memory allocated to the machine to support all the activities on that machine? Anything in the wrapper.log file that might indicate an error? ---
**Author:** ![arpit\_yadav](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@arpit\_yadav](https://forum.inductiveautomation.com/u/arpit_yadav)\ **Post date:** [January 23, 2026, 1:55pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/10 "2026-01-23T13:55:54Z")
My wrapper log is [here](https://drive.google.com/file/d/17-YCdBNI1MFHfiza_UQxm4sJ2rkL_fYx/view?usp=sharing) ---
**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 23, 2026, 2:17pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/11 "2026-01-23T14:17:21Z")
> [@arpit\_yadav](#): > > I have to SQLlite db connection Why? Really. SQLite is **single-threaded** and cannot do connection pooling as most Ignition subsystems expect. Use a real database. Use MariaDB or PostgreSQL if you need it to be free. (This is why v8.3 has QuestDB for the internal historian--the prior implementation based on SQLite sucks and cannot be fixed.) ---
**Author:** ![arpit\_yadav](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@arpit\_yadav](https://forum.inductiveautomation.com/u/arpit_yadav)\ **Post date:** [January 23, 2026, 2:23pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/12 "2026-01-23T14:23:36Z")
Sorry, I want to say that i don’t have any sql connection in my gateway. I had shared my wrapper log also for reference. ---
**Author:** ![avaughn](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/avaughn/32/38972_2.png) [@avaughn](https://forum.inductiveautomation.com/u/avaughn)\ **Post date:** [January 23, 2026, 3:02pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/13 "2026-01-23T15:02:11Z")
It looks like there are two SQLite files being referenced in your logs. The first one is used by the Tag Reference Tracker and is located in the `\data\var\ignition\tags\{tag_provider}` directory. I believe yours is coming from the `default` tag provider. The second one is used for Memory Tag Value Persistence and is located in the `\data\config\ignition\tags` directory. I’m not sure what caused them to be corrupted, but can you try removing the files from those directories and then restart the gateway again? You can move them to a temporary folder rather than delete them if any of the data matters and you might want to try to recover some of it. ---
**Author:** ![arpit\_yadav](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@arpit\_yadav](https://forum.inductiveautomation.com/u/arpit_yadav)\ **Post date:** [January 23, 2026, 3:22pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/14 "2026-01-23T15:22:41Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/0/608b744102cc8b98a72ed693ca9c386e7909518b.png) After deleting directory still facing the same issue. ---
**Author:** ![avaughn](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/avaughn/32/38972_2.png) [@avaughn](https://forum.inductiveautomation.com/u/avaughn)\ **Post date:** [January 23, 2026, 3:28pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/15 "2026-01-23T15:28:43Z")
Did you delete both SQLite files? Can you upload a new copy of your logs? ---
**Author:** ![arpit\_yadav](https://avatars.discourse-cdn.com/v4/letter/a/a5b964/32.png) [@arpit\_yadav](https://forum.inductiveautomation.com/u/arpit_yadav)\ **Post date:** [January 23, 2026, 3:32pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/16 "2026-01-23T15:32:15Z")
The new wrapper log file is [here](https://drive.google.com/file/d/1mJTq4C2Pu7JWgd6O9lMcMQfu34g8mVG4/view?usp=sharing) ---
**Author:** ![avaughn](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/avaughn/32/38972_2.png) [@avaughn](https://forum.inductiveautomation.com/u/avaughn)\ **Post date:** [January 23, 2026, 3:42pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/17 "2026-01-23T15:42:08Z")
Looks like there’s still an issue with a Tag Value Persistence file. Possibly with the `MQTT Distributor` provider. Try moving the SQLite file for that provider and restarting again. Edit: Apologies, it’s actually the reference tracker that has a file per provider. The `valueStore.idb` contains values for all providers. ---
**Author:** ![sjohnson](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@sjohnson](https://forum.inductiveautomation.com/u/sjohnson)\ **Post date:** [January 23, 2026, 6:07pm UTC](https://forum.inductiveautomation.com/t/performance-issue-and-sql-lite-tag-reference-error/113503/18 "2026-01-23T18:07:11Z")
This issue can be caused due to full disk space. Ignition 8.3 is heavily reliant on the file system to run and if all disk space is consumed the gateway will not be able to start properly. By default Ignition’s **live** tag values will store to the valueStore.idb which is a SQLite database. If you see a SQLite Error I’d strongly recommend checking your disk space and reaching out to Support.