Zeitgeist activity.sqlite-wal getting huge

I was looking at backup task running on my desk and saw that it's spending a lot of time on ~/.local/share/zeitgeist directory. I checked and it had 4.6GB:

du -sh ~/.local/share/zeitgeist/*
118M    activity.sqlite
44M     activity.sqlite.bck
32K     activity.sqlite-shm
4,4G    activity.sqlite-wal
311M    fts.index

WTF? Fortunately I found here that I could easily delete some of this:

zeitgeist-daemon --quit

Now check that it's not running:

ps axu | grep zeitgeist-daemon
timor     9105  0.0  0.0  10756  2140 pts/5    S+   19:01   0:00 grep --color=auto zeitgeist-daemon

Nothing there so we may start deleting:

cd ~/.local/share/zeitgeist
rm -r fts.index
rm activity.sqlite-wal
rm activity.sqlite-shm

Start zeitgeist-daemon again:

zeitgeist-daemon --replace&

Now check files sizes again:

du -sh ~/.local/share/zeitgeist/*
118M    activity.sqlite
44M     activity.sqlite.bck
32K     activity.sqlite-shm
4,0K    activity.sqlite-wal
640K    fts.index

Much better 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *