SQLite WAL files periodic truncate

[mnaiman]

SQLite WAL files periodic truncate

[mnaiman]

BTW: restart of container (app) does the same job with truncating WAL, but I dont want to restart regularly security solution.

[NickM-27]

It should be handled automatically https://www.sqlite.org/compile.html#default_wal_autocheckpoint

[mnaiman]

Maybe it should be handled, but it is obviously not handled :)
5 hours ago I truncated my WAL from 14GB to 0, now it is back 0,5GB.
I have 12 cameras with continuous recording, this is why its generate to db those 3mil records.

[NickM-27]

Will have to check what the default peewee config is

[mnaiman]

After reading docs - maybe data is moved from wal to db file, but wal itself is not truncated.
https://www.sqlite.org/c3ref/wal_checkpoint_v2.html
Yes questions is what is default checkpoint action.

[NickM-27]

The WAL isn't truncated but it is instead written over so it still shouldn't increase in size past a few MB. Based on section 6 it seems that the issue here is that Frigate has many concurrent readers and writers thus the auto checkpoint will not be run in certain circumstances (like users with many cameras)