Page 1 of 1
Error message "Error: SQL Query("VACUUM") : database or disk is full"
Posted: Monday 29 January 2018 10:32
by 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...
Re: Error message "Error: SQL Query("VACUUM") : database or disk is full"
Posted: Monday 29 January 2018 14:16
by 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
Re: Error message "Error: SQL Query("VACUUM") : database or disk is full"
Posted: Monday 29 January 2018 14:33
by 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
Re: Error message "Error: SQL Query("VACUUM") : database or disk is full"
Posted: Monday 29 January 2018 14:49
by 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.
Re: Error message "Error: SQL Query("VACUUM") : database or disk is full"
Posted: Sunday 13 October 2019 20:55
by Harald777
elythomaslumber wrote: ↑Monday 29 January 2018 14:33
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