On Fri, Jun 08, 2012 at 05:17:56PM +0200, Arnaud Gomes wrote: > Since upgrading to liferea 1.8, the database grows ever larger, filling my > home directory after a few days. Currently, at about 4 days uptime: > > gomes@licencieux:~/.liferea_1.8% du -sh * > 4.0K accels > 312K cache > 4.0K cookies.txt > 28K feedlist.opml > 28K feedlist.opml.backup > 4.0K liferea.css > 20M liferea.db > 8.8M liferea.db-shm > 1.2G liferea.db-wal
This is a known bug. Apparently it's caused by the SQL prepared statement cache, which keeps some internal db structures open, which in turn keeps the WAL from being checkpointed back into the DB. Upstream is actively working on a solution. http://old.nabble.com/further-debugging-the-endless-growing-WAL-%28with-results%21%29-to33921177.html -- Rodrigo Gallardo -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
