DB-WAL keeps growing

[martupeppeadmin]

Since I have updated to 2.6 the db-wa file keeps growing and it's not cleared after a sync session.

[theclem54]

This issue has also been identified in a couple of posts at ownCloud Central
https://central.owncloud.org/t/large-sync-db-wal-file-18gb/23085/3
https://central.owncloud.org/t/huge-db-wal-file-size-218gb-most-of-the-times-is-400gb/23902

I have found that if I quit ownCloud client, the db-wal file is removed.

I am using Windows Embedded on the system on which I have personally encountered a full drive issue and on Windows 10 I have also confirmed that quitting ownCloud client removes the file.

Expected behaviour is that the file is cleaned/removed at some regular interval, depending on it's function. If the file is not needed between multiple synchronisations, then it should be removed as soon as a synchronisation is completed.

[jnweiger]

https://www.sqlite.org/wal.html suggests that sqlite checkpointing should be performed periodically. Either automatically ("after 1000 rows" -- which I don't see happening) or manually. PRAGMA schema.wal_checkpoint;

As a rule of thumb, I suggest to merge the WAL at least when it reaches 50% of the size of the DB file.

[NicolasGoeddel]

Any chance that this can be fixed soon? Our wal file grows to a few gigabytes after just a month. I then have to stop the client and start it again which takes over half an hour, where 20 minutes is just the shutdown itself. The other 10 minutes is the discovery of the file system and creating those inotify watchers.

[jnweiger]

Confirmed fixed with testpilotcloud 2.9.0 beta3 on win10

• the wal file never grows beyond 4052KB
• This size was quickly reached by repeatedly sharing and unsharing a gallery with 80 photos with this user.