Database malformed? Topic is solved

[JuanUil]

Hi there,

since a few days I find the following in my log.

2019-11-12 15:00:00.947 Status: Starting automatic database backup procedure...
2019-11-12 15:00:01.363 Error: SQL Query("VACUUM") : database disk image is malformed
2019-11-12 15:00:04.693 Status: Ending automatic database backup procedure...

everything is working well so anybody any idea how to fix this?

Thnx in advance

Jan

[JuanUil]

allways when I post a problem the new posts are refreshed and my post is gone

[jvdz]

Are you using a RAMDrive for TMP and could it be this is not large enough anymore to hold a copy of your domoticz.db for the vacuum operation?
Check available space with: df -k
And the size of your domoticz.db with : ls -l /home/pi/domoticz

EDIT: actually I guess your DB is really having issue and needs to be checked. Will search for the post on that made earlier and post back.
EDIT2: check out this thread: https://www.domoticz.com/forum/viewtopi ... ed#p202504

Jos

[JuanUil]

Hi Jos,

Thnx for your reply.
no I have no ramdrive.
I will check the supposed procdure with sqlite, thnx!!

jan

[JuanUil]

Thnx Jos,

everything is normal again!!

Jan