Hi, Using Ignition 7.9.2, a gateway backup has 118 MB, of which the database backup (.idb) has 114MB. The project_resources table in this database takes 97% of this space. Looking at the largest rows in this table by blob size, they are mostly old/deleted windows, which no longer appear in the de…

Hello Kathy, Our problem comes from this: ... INFO | jvm 1 | 2017/05/02 16:01:16 | E [T.P.Config ] [13:01:16]: Error storing tag values. tag-provider=default INFO | jvm 1 | 2017/05/02 16:01:16 | simpleorm.utils.SException$Jdbc: Opening com.inductiveautomation.ignition.…

Backing up the internal DB takes one minute: Created auto-backup of internal database "config.idb" in 57 seconds

The internal db needs to hold on to some older versions of windows (well, actually all project resources), whether deleted or not, for rollback. These older versions should be getting pruned on a regular basis, but if you think there’s a bug in the pruning the best bet is to contact support and forw…

Yes, please contact support with this.

We ended up modifying the following parameters in gateway.xml: <entry key="localdb.autobackup.delay">120</entry> <entry key="localdb.autobackup.count">5</entry> This reduced the interval to 2 hours.

Inductive Automation Forum

Internal database size

Ignition

ignition79

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled