https://bugs.kde.org/show_bug.cgi?id=398407
Paul Eggleton <bluelightn...@bluelightning.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bluelightning@bluelightning | |.org --- Comment #1 from Paul Eggleton <bluelightn...@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 watching all bug changes.