Clearing logs/data for Uptime Kuma

[fbartels]

Hi @timconsidine,
I'm not exactly sure, where you see these 3gb. Is that in Cloudron or in the monitor history of Kuma itself?

[girish]

@fbartels I think Settings -> Monitor History.

I have a database size of 360MB with 180 day retention with ~30 monitors.

[girish]

@timconsidine For me, 'clear all statistics' does 0 out the database. Did you check the sizes in /app/data/data/* ?

[timconsidine]

@fbartels said in Clearing logs/data for Uptime Kuma:

Hi @timconsidine,
I'm not exactly sure, where you see these 3gb. Is that in Cloudron or in the monitor history of Kuma itself?

In Cloudron's System Info

[timconsidine]

@girish said in Clearing logs/data for Uptime Kuma:

@timconsidine For me, 'clear all statistics' does 0 out the database. Did you check the sizes in /app/data/data/* ?

Err no
But checking now it shows a bunch *bak* files :

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 ?

[girish]

@timconsidine maybe it creates these automatically across updates. Seems safe to delete.

[timconsidine]

@girish thank you !

[timconsidine]

@timconsidine Hmmmm
Deleted strange 'orphan *.bak* files
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 ?

[girish]

@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).

[timconsidine]

@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.