Error message "Error: SQL Query("VACUUM") : database or disk is full" Topic is solved

[elythomaslumber]

Changed to the 3.8153 on a RPi 1 from 1.18. The log tells me every hour an error message:

2018-01-29 09:00:10.250 Error: SQL Query("VACUUM") : database or disk is full

I cannot believe, that the SD card (8GB Image on 16GB SD) is full. I have attached a screenshot.
Is it correct, that the active data-base and the backup data-base have different owners? Could that be the problem?
I have used the old data base from my 1.18 release when changed to 3.8153.

What is the correct owner for both data-base files?


I think I found some solutions here: http://www.domoticz.com/forum/viewtopic ... ll#p152234
Hope I fixed it... on observation...

[jvdz]

I am sure this has been asked before and think it could very well have to do with the fact that your TMP/TEMP is located on a smaller (ramdisk) which is too small. Could that be the issue also for you?

Jos

[elythomaslumber]

Hi Jos,

yes, found a post and edited my original post:

I think I found some solutions here: http://www.domoticz.com/forum/viewtopic ... ll#p152234
Hope I fixed it... on observation...

After now about 2h observation time I think the solution was successful. I removed tons of old log-files but I think the reserved space for the TMP file was too small. I expanded from1 to 5MB.
No new fault messages but:

2018-01-29 14:00:02.615 Starting automatic database backup procedure...
2018-01-29 14:00:09.576 Ending automatic database backup procedure...


Cheers

Hartmut

[EddyG]

You could beter expand the tmpfs to 64 Mb or something like that.
Mine is 128 Mb and a few others like /var/log also.
The tmpfs is a kind of dynamic, it does not use the 64 Mb until it is really needed.
This way you easy avoid problems in the future.

[Harald777]

Hi Jos,

yes, found a post and edited my original post:

I think I found some solutions here: viewtopic ... ll#p152234
Hope I fixed it... on observation...

After now about 2h observation time I think the solution was successful. I removed tons of old log-files but I think the reserved space for the TMP file was too small. I expanded from1 to 5MB.
No new fault messages but:

2018-01-29 14:00:02.615 Starting automatic database backup procedure...
2018-01-29 14:00:09.576 Ending automatic database backup procedure...


Cheers

Hartmut

Having the same issue, what was your solution.
The link does not work anymore.

Greetings Harald