My instance of Uptime Kuma is showing (in System Info) 2.89Gb used, presumably logs.
cleared all statisticsand
shrunk databasein Settings/ Monitor History.
But 24 hours later, it is still showing 2.89Gb used.
Issue is that my automated backups seem to stall when doing the backup for Uptime Kuma, which then affects other apps in the backup queue.
I have set history to 15 days to prevent it growing large again.
But how do I clear the logs which seem to be retained even after clearing statistics and shrinking database ?
@timconsidine For me, 'clear all statistics' does 0 out the database. Did you check the sizes in
But checking now it shows a bunch
root@4b5f68b4-04a6-43f6-b636-77ee08f43d90:/app/data/data# ls -alhtr *.bak* -rw-r--r-- 1 cloudron cloudron 372M Mar 24 23:01 kuma.db.bak20220324230123 -rw-r--r-- 1 cloudron cloudron 32K Mar 24 23:01 kuma.db-shm.bak20220324230123 -rw-r--r-- 1 cloudron cloudron 389M Mar 24 23:01 kuma.db-wal.bak20220324230123 -rw-r--r-- 1 cloudron cloudron 370M Apr 12 22:01 kuma.db.bak20220412220130 -rw-r--r-- 1 cloudron cloudron 32K Apr 12 22:01 kuma.db-shm.bak20220412220130 -rw-r--r-- 1 cloudron cloudron 389M Apr 12 22:01 kuma.db-wal.bak20220412220130 -rw-r--r-- 1 cloudron cloudron 433M Apr 24 22:02 kuma.db.bak20220424220236 -rw-r--r-- 1 cloudron cloudron 32K Apr 24 22:02 kuma.db-shm.bak20220424220236 -rw-r--r-- 1 cloudron cloudron 389M Apr 24 22:02 kuma.db-wal.bak20220424220236 -rw-r--r-- 1 cloudron cloudron 17M Jun 22 22:02 kuma.db.bak20220622220236 -rw-r--r-- 1 cloudron cloudron 32K Jun 22 22:02 kuma.db-shm.bak20220622220236 -rw-r--r-- 1 cloudron cloudron 400M Jun 22 22:02 kuma.db-wal.bak20220622220236
I didn't know about these.
That confirms Cloudron's System Info reported size.
Presumably OK to delete these ?
Any idea why they are not auto-deleted ?
Deleted strange 'orphan
Away for a couple days (so time for stats to reset)
UptimeKuma now showing as 3.89Gb usage (it's not)
Backup taking forever and blocking overall backup process.
Suggestions for what to check / fix ?
@timconsidine Was the database ever 0 size? I think there is some upstream bug that clearing database does not clear the database. It seems they enable WAL/Journaling in the sqlite database and maybe that persists (I don't know sqlite well enough to know a workaround).
@girish not sure about 0 size ever, but I don't think so.
Anyway, after deleting some new .bak files from /app/data/data, Cloudron System Info now reporting a more reasonable 455Mb size for the deployed app.
Will try and keep an eye on it.
May export, uninstall, reinstall, import.
Although I think I did that once before.
Clearing all stats and shrinking database gives a 1.5Mb size.