# Tags disappearing after power failure **URL:** \ **Category:** Ignition\ **Created:** [September 6, 2022, 3:33pm UTC](https://forum.inductiveautomation.com/t/tags-disappearing-after-power-failure/63784 "2022-09-06T15:33:42Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![dhiren.naidoo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dhiren.naidoo/32/19485_2.png) [@dhiren.naidoo](https://forum.inductiveautomation.com/u/dhiren.naidoo)\ **Post date:** [September 6, 2022, 3:33pm UTC](https://forum.inductiveautomation.com/t/tags-disappearing-after-power-failure/63784/1 "2022-09-06T15:33:42Z")
Hi Let me start with the obvious. We are begging the customer to install a UPS. In the meantime, we have a gateway on 8.1.19 that seems to lose all its tags (and UDT definitions) after power failures. For those not familiar with the current situation in South Africa, we are getting planned, scheduled blackouts due to unplanned, unscheduled reasons. The only clue I’ve found in the logs is below: ```auto provider 06Sep2022 17:05:02 Error starting tag provider simpleorm.utils.SException$Jdbc: Executing SELECT tagconfig.id, tagconfig.ProviderId, tagconfig.folderId, tagconfig.cfg, tagconfig.rank, tagconfig.name FROM tagconfig WHERE tagconfig.ProviderId = ? ORDER BY tagconfig.id at simpleorm.sessionjdbc.SQueryExecute.executeQuery(SQueryExecute.java:63) at simpleorm.sessionjdbc.SSessionJdbc.queryNoFlush(SSessionJdbc.java:525) at simpleorm.sessionjdbc.SSessionJdbc.query(SSessionJdbc.java:534) at com.inductiveautomation.ignition.gateway.localdb.PersistenceInterfaceImpl.query(PersistenceInterfaceImpl.java:147) at com.inductiveautomation.ignition.gateway.tags.config.storage.internaljson.InternalJsonStorageManager.loadTags(InternalJsonStorageManager.java:341) at com.inductiveautomation.ignition.gateway.tags.TagProviderImpl.loadTagsFromStorage(TagProviderImpl.java:1308) at com.inductiveautomation.ignition.gateway.tags.TagProviderImpl.loadTags(TagProviderImpl.java:1301) at com.inductiveautomation.ignition.gateway.tags.TagProviderImpl.startup(TagProviderImpl.java:356) at com.inductiveautomation.ignition.gateway.tags.model.impl.GatewayTagManagerImpl.instantiateProvider(GatewayTagManagerImpl.java:591) at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(Unknown Source) at java.base/java.util.stream.ReferencePipeline$2$1.accept(Unknown Source) at java.base/java.util.stream.ReferencePipeline$2$1.accept(Unknown Source) at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(Unknown Source) at java.base/java.util.stream.AbstractPipeline.copyInto(Unknown Source) at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source) at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(Unknown Source) at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(Unknown Source) at java.base/java.util.stream.AbstractPipeline.evaluate(Unknown Source) at java.base/java.util.stream.ReferencePipeline.forEach(Unknown Source) at com.inductiveautomation.ignition.gateway.tags.model.impl.GatewayTagManagerImpl.startup(GatewayTagManagerImpl.java:507) at com.inductiveautomation.ignition.gateway.IgnitionGateway.startupInternal(IgnitionGateway.java:1212) at com.inductiveautomation.ignition.gateway.redundancy.RedundancyManagerImpl.startup(RedundancyManagerImpl.java:298) at com.inductiveautomation.ignition.gateway.IgnitionGateway.initRedundancy(IgnitionGateway.java:734) at com.inductiveautomation.ignition.gateway.IgnitionGateway.lambda$initInternal$0(IgnitionGateway.java:668) at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:544) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) 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) Caused by: org.sqlite.SQLiteException: [SQLITE_CORRUPT] The database disk image is malformed (database disk image is malformed) at org.sqlite.core.DB.newSQLException(DB.java:909) at org.sqlite.core.DB.newSQLException(DB.java:921) at org.sqlite.core.DB.execute(DB.java:825) at org.sqlite.jdbc3.JDBC3PreparedStatement.executeQuery(JDBC3PreparedStatement.java:80) at com.inductiveautomation.ignition.gateway.localdb.DelegatingDataSource$DelegatingConnection$DelegatingPreparedStatement.executeQuery(DelegatingDataSource.java:575) at simpleorm.sessionjdbc.SQueryExecute.executeQuery(SQueryExecute.java:61) ... 30 common frames omitted ``` We are restoring the tags and UDT’s from an export file after every power failure, but have not noticed this behaviour on other installations and would like to figure out whether there is something we can do to remedy it. We did fix a similar message by deleting the system logs.idb file, but I’m not sure if there is a similar fix for the tag DB? Restoring a gateway backup does fix the tags, but after the next power failure, the same thing happens. ---
**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:** [September 6, 2022, 3:39pm UTC](https://forum.inductiveautomation.com/t/tags-disappearing-after-power-failure/63784/2 "2022-09-06T15:39:52Z")
> [@dhiren.naidoo](#): > > `The database disk image is malformed (database disk image is malformed)` Seems pretty clear. You will need to get IA support involved. ---
**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 6, 2022, 3:49pm UTC](https://forum.inductiveautomation.com/t/tags-disappearing-after-power-failure/63784/3 "2022-09-06T15:49:36Z")
My guess, from [https://www.sqlite.org/howtocorrupt.html:](https://www.sqlite.org/howtocorrupt.html:) > ## 3.1. Disk drives that do not honor sync requests > > Unfortunately, most consumer-grade mass storage devices lie about syncing. Disk drives will report that content is safely on persistent media as soon as it reaches the track buffer and before actually being written to oxide. This makes the disk drives seem to operate faster (which is vitally important to the manufacturer so that they can show good benchmark numbers in trade magazines). And in fairness, the lie normally causes no harm, as long as there is no power loss or hard reset prior to the track buffer actually being written to oxide. **But if a power loss or hard reset does occur, and if that results in content that was written after a sync reaching oxide while content written before the sync is still in a track buffer, then database corruption can occur.** If this is what's going on then I don't think there's anything we can do... ---
**Author:** ![dhiren.naidoo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dhiren.naidoo/32/19485_2.png) [@dhiren.naidoo](https://forum.inductiveautomation.com/u/dhiren.naidoo)\ **Post date:** [September 6, 2022, 3:51pm UTC](https://forum.inductiveautomation.com/t/tags-disappearing-after-power-failure/63784/4 "2022-09-06T15:51:43Z")
Yep, just making sure it’s not something someone has experienced before. Deleting the system log idb file seemed to stop that error so I was hoping there’s a quick fix for the tag idb file as well. ---
**Author:** ![dhiren.naidoo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dhiren.naidoo/32/19485_2.png) [@dhiren.naidoo](https://forum.inductiveautomation.com/u/dhiren.naidoo)\ **Post date:** [September 6, 2022, 3:54pm UTC](https://forum.inductiveautomation.com/t/tags-disappearing-after-power-failure/63784/5 "2022-09-06T15:54:11Z")
Gateway runs on an SSD. Not the most industrial machine, but it is at least not a mechanical drive. Not that SSD’s don’t have their own power loss issues… EDIT: After reading that extract above more closely, I see it still applies to my situation. Thanks. If the DB is indeed corrupt, does restoring a tag export rebuild that DB? ---
**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:** [September 6, 2022, 4:00pm UTC](https://forum.inductiveautomation.com/t/tags-disappearing-after-power-failure/63784/6 "2022-09-06T16:00:18Z")
The DB in question holds _everything_ gateway configuration (except for your projects). So not just tags, also database connections, device connections, etc. If you’ve got scheduled backups, that’d be a good thing to try. There’s also an `autobackup` folder next to the `config.idb` file in the `$installDirectory/data/db` folder; one of those _might_ not be corrupted, and might have most of your recent work. But, this is _really_ something support is better equipped to guide you through ‘live’. ---
**Author:** ![dhiren.naidoo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dhiren.naidoo/32/19485_2.png) [@dhiren.naidoo](https://forum.inductiveautomation.com/u/dhiren.naidoo)\ **Post date:** [September 6, 2022, 4:02pm UTC](https://forum.inductiveautomation.com/t/tags-disappearing-after-power-failure/63784/7 "2022-09-06T16:02:23Z")
Will contact support right away. Thanks for the help! ---
**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:** [September 6, 2022, 6:48pm UTC](https://forum.inductiveautomation.com/t/tags-disappearing-after-power-failure/63784/8 "2022-09-06T18:48:55Z")
Not sure what voltage your IPC is at, I use these from Puls to keep OnLogic IPC’s online (24V DC in Panel, I use a Traco 24V-\>12V step down): - Mfr. Part No. UB10.241 - Brand [PULS] - Mfr. Part No. UZK12.071 - Brand [PULS]