[Akonadi] [Bug 398407] undeleted email with empty message body causes excessive cpu use

[Paul Eggleton]

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

Paul Eggleton <bluelightning at bluelightning.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |bluelightning at bluelightning
                   |                            |.org

--- Comment #1 from Paul Eggleton <bluelightning at bluelightning.org> ---
Created attachment 116292
  --> https://bugs.kde.org/attachment.cgi?id=116292&action=edit
Script to find maildir messages with empty bodies

I've had this same issue with a local maildir for about a week - high CPU usage
persisting over reboots and akonadi restarts with mysqld and akonadi processes
using up most of the available CPU time.

I had some rules set up to move messages from an IMAP folder to the local
maildir when they get to a certain age, but for some reason some of the moved
messages ended up with an empty body when they arrived in the maildir, and
these messages seemed to be tripping up akonadi (not at the time of moving -
just by being present at the destination). This was visible via akonadiconsole
- I could see the message IDs by enabling the debugger briefly, then I could
use the DB Query tab to find the messages with those ids in the pimitemtable,
and the "rev" field was constantly incrementing. Oddly I could not see those
messages in the "Browser" tab, but at least some of them were visible in KMail.

In order to work around the issue I wrote a script (attached) to find messages
with an empty body in a specific directory (in my case,
~/.local/share/local-mail/inbox/new/ ) and then I moved the listed files out
somewhere else. Shortly thereafter the machine calmed down, though I did have
to finally run akonadictl restart to stop mysqld from using ~90% CPU so
presumably there was still an expensive query running.

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