# Error with internal database auto-backup

**URL:** <https://forum.inductiveautomation.com/t/error-with-internal-database-auto-backup/51200>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [September 21, 2021, 4:42pm UTC](https://forum.inductiveautomation.com/t/error-with-internal-database-auto-backup/51200 "2021-09-21T16:42:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![bpreston](https://avatars.discourse-cdn.com/v4/letter/b/4af34b/32.png) [@bpreston](https://forum.inductiveautomation.com/u/bpreston)\
**Post date:** [September 21, 2021, 4:42pm UTC](https://forum.inductiveautomation.com/t/error-with-internal-database-auto-backup/51200/1 "2021-09-21T16:42:47Z")

</div>

Looking through logs recently I noticed I’ve had an error around the time the internal database tries to back up. It looks like its happened 4 times in the last 2 days. Has anyone seen this before?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/7/67a06348afbbffd9d0c1fafc4f2a0c010ee9ffe2.png)

---

<div class="post-metadata">

**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\
**Post date:** [September 21, 2021, 4:50pm UTC](https://forum.inductiveautomation.com/t/error-with-internal-database-auto-backup/51200/2 "2021-09-21T16:50:04Z")

</div>

We ran into this last week! First, you can turn off your internal database auto-backup to see if that helps:

> [@Turn off auto backup of config.idb](https://forum.inductiveautomation.com/t/turn-off-auto-backup-of-config-idb/47610):
>
> Can someone please tell me how we turn this off? We to a full gateway backup and so we don’t need this done automatically several times a day.

Do you have normal backups turned on?

Also, how large is your config.idb file?

We had auto-backup turned off already but were still getting the `internalJson` and `SingleConnectionDatasource` errors frequently. Our error was that the `config.idb` file was far too large (it was 1.5 GB). We ended up having to export our projects and re-import them on top of themselves to clear out unnecessary stuff from the internal database and the size dropped to ~200 MB and haven't had any issues since.

---

<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:** [September 21, 2021, 4:57pm UTC](https://forum.inductiveautomation.com/t/error-with-internal-database-auto-backup/51200/3 "2021-09-21T16:57:30Z")

</div>

If the internal DB backup takes longer than 30 seconds, anything else that is trying to use the internal DB at that point will choke. If you can’t squish your backup any smaller, consider moving to beefier hardware, especially with solid state storage.

---

<div class="post-metadata">

**Author:** ![bpreston](https://avatars.discourse-cdn.com/v4/letter/b/4af34b/32.png) [@bpreston](https://forum.inductiveautomation.com/u/bpreston)\
**Post date:** [September 21, 2021, 5:04pm UTC](https://forum.inductiveautomation.com/t/error-with-internal-database-auto-backup/51200/4 "2021-09-21T17:04:47Z")

</div>

I’ll have to talk to my customer to give that a try but I don’t think our config.idb is to out of line. Its sitting at 436MB right now. The part that seems real odd to me is it didn’t start giving that error until days after the last change was made to the system. Looking at the logs, it started throwing it Monday but the last change would of been Wednesday or Thursday.

@pturmel I’ll have to look into what their using for storage, I haven’t had any issues in the past with it so I haven’t asked the questions but may need to now.

---

<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:** [September 21, 2021, 5:10pm UTC](https://forum.inductiveautomation.com/t/error-with-internal-database-auto-backup/51200/5 "2021-09-21T17:10:13Z")

</div>

Well, your log shows the backup taking 35 seconds. _Something_ needs to be done to bring that down.
