topic Re: File "storage-sync-v2.sqlite-wal" keep growing with no limit in Discussions

File "storage-sync-v2.sqlite-wal" keep growing with no limit

tanny — Fri, 27 Jan 2023 02:28:46 GMT

storage-sync-v2.sqlite-wal keeps growing since Firefox was installed. And .sqlite file is never updated.

I thought that wal is a temporary journal file and sometimes commited to .sqlite, so the .sqlite file should be update and the wal file would have zero content.

Why is Firefox skipping commits?

This makes Firefox boot very slowly.

Re: File "storage-sync-v2.sqlite-wal" keep growing with no limit

ivyevelyalbert — Sun, 29 Jan 2023 16:49:14 GMT

The WAL file can be seen to grow to 100 MB around the 8 s mark before the database starts increasing to 100 MB after SQLite's automatic checkpoint occurs. When the same data is written with a commit after each row (1 MB of data), automatic checkpointing is allowed to run without any restriction.

Re: File "storage-sync-v2.sqlite-wal" keep growing with no limit

jscher2000 — Sat, 28 Jan 2023 18:20:59 GMT

@tanny wrote:
storage-sync-v2.sqlite-wal keeps growing since Firefox was installed. And .sqlite file is never updated.
I thought that wal is a temporary journal file and sometimes commited to .sqlite, so the .sqlite file should be update and the wal file would have zero content.

Whoa, yes, my storage-sync-v2.sqlite-wal file is 31 megabytes. That seems a bit extreme.

When I view the file in Notepad++ (a text editor), it is full of host names of sites I've visited. At first glance, it looks like over 480 copies of my exceptions list from the NoScript extension.

I do think my updates to my exceptions list are being stored, but it's annoying that the -wal file is not cleaned up. I filed a new bug report: https://bugzilla.mozilla.org/show_bug.cgi?id=1813330