best-table-2963
06/26/2024, 12:27 PM/var/lib/rancher/k3s/server/db
, we see below heavy state.db-wal file size.
I read somewhere to truncate the checkpoints (PRAGMA schema.wal_checkpoint(TRUNCATE);
) --> this will shrink the size and sync the state.db to correct state. However, even connecting to state.db is reading .wal and taking infinite time.
Has anyone come accross similar issue? Any suggestions?