[Akonadi] [Bug 395131] Akonadi consumes all memory

[Karthik Periagaram]

https://bugs.kde.org/show_bug.cgi?id=395131

--- Comment #4 from Karthik Periagaram <karthik.periagaram at gmail.com> ---
I have a final update and possible fix for this. The latest release (18.04)
continued to have this memory ballooning issue. I ran akonadictl fsck, which
reported a mysql error when checking one of the folders in one of my mail
accounts. It was unable to find a field in some query. I'm sorry I didn't note
down this query and the error.

My kmail setup is probably more than three years old at this point and in the
meantime, akonadi has had several updates. It's possible that the schema for
the database changed in that time and wasn't cleanly updated from one version
to the next. So, I suggest using the fsck operation as an indicator for
checking if this would work. Onwards to the fix.

I wanted to rebuild the internal database. Remove ~/.local/share/akonadi and
all its contents. I did this from a virtual console rather than from within a
plasma session, but I suppose you could do this with akonadi stopped, too.
After deleting this directory, login/open kmail. All the accounts and their
folders should go blank. I had to authenticate my main mail account again (if
you see a dialog that doesn't close, and you use gmail, it might be the
authentication page from google. Drag and make the dialog window bigger to see
it.). Now, all the mail gets re-downloaded and akonadi has been zippy as all
hell. The behavior is stable across multiple reboots and I'm satisfied the
issue is fixed.

Note that if you have any changes that haven't synced with the imap server, you
may lose them. Sync before doing this.

If OP (Dan) can confirm this works, this bug can be closed. If any dev wants to
reproduce this, maybe start with an old version of akonadi and jump directly to
a new release. fsck should fail and you should have a ballooning memory usage
with each mail check.

Thanks!

-- 
You are receiving this mail because:
You are the assignee for the bug.