Bug 320170 - Kmail very slow to load messages from local folder
Summary: Kmail very slow to load messages from local folder
Status: RESOLVED UNMAINTAINED
Alias: None
Product: kmail2
Classification: Applications
Component: folders (show other bugs)
Version: Git (master)
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-05-23 13:03 UTC by Valentin Rusu
Modified: 2015-09-09 21:05 UTC (History)
4 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Valentin Rusu 2013-05-23 13:03:07 UTC
I just compiled (kdesrc-build) all my KDE 4.

After restarting, I now want to go answer some mails. I move some of them from my IMAP server to the local folder I use for storing my KDE-related mails.

I then clicked such a message to answer to it. KMail displayed 'Retrieving folder contents\nPlease wait....' And it's excessive long at this task (more than 3 minutes).

Using akonadi console, I stopped then restarted the server. The contents of the mail shown at the very moment when I clicked stop, then kmail window got shaded during the server stop. After restarting it, messages contents display was correctly working.

In ~/.local/share/akonadi/akonadiserver.error I found these:

ItemRetrieverException :  Unable to retrieve item from resource: Did not receive a reply. Possible causes include: the remote application did not send a reply, the message bus security policy blocked the reply, the reply timeout expired, or the network connection was broken. 

Also this:

"Cannot connect to agent instance with identifier 'akonadi_maildir_resource_6', error message: 'Could not get owner of name 'org.freedesktop.Akonadi.Resource.akonadi_maildir_resource_6': no such name'" 
ItemRetrieverException :  Unable to contact resource 



Reproducible: Always
Comment 1 Emre 2013-06-09 18:12:02 UTC
I can confirm this. I have a mailbox with 10+ thousand mails inside. It took some time to open the mailbox when the account is first setup, but when this is done, I got stuck into this bug. 

When I select a message (ie 10 meg message) to display contents, the preview pane stays displaying "Retrieving Folder Contents... Please wait". if you wait for like 1-4 minutes, the message displays and consequent displays of this message is now fast. 

Note that this is an IMAP (Dovecot) server installed locally. It's super fast in Thunderbird. So no idea why it takes minutes to open a message.

I filed the sale same report on bug #277770.
Comment 2 Emre 2013-06-09 20:14:55 UTC
Note: Disabling nepomuk email searching greatly increased the speed.
Comment 3 Dj YB 2013-06-10 20:55:36 UTC
I have a similar problem with kde 4.10.3
sometimes it get stuck with "Retrieving folder contents" message for several minutes before displaying the message.
by the way, I have tried to manually open the mbox file of a new message that was stuck in kmail, and the file opened without a problem... so, no problem accessing the file.
Comment 4 Valentin Rusu 2013-06-17 19:42:08 UTC
Meanwhile I setup a fresh new home folder, withour any settings. The old home folder was renamed, then I opened a fresh-new KDE session. I configured my accounts and folders but the problem still reproduces. How can I help to sort this annoying thing out?

For the moment, here is a workaround, using konsole:
akonadictl stop # this instantly unlocks message retrieval and it show it, then kmail gets disabled
akonadictl start # to resume kmail
Comment 5 Valentin Rusu 2013-07-07 17:52:39 UTC
The problem just returned, without any aparent explanation (I did not touched my system configuration, nor recompiled KDE). Here is the output I can see in konsole after issuing "akonadictl start" and trying to navigate my folders under kontact:


Error during executing query "UPDATE PimItemTable, CollectionPimItemRelation SET atime = :0 WHERE ( CollectionPimItemRelation.Collection_id = :1 AND ( CollectionPimItemRelation.PimItem_id = PimItemTable.id ) )" :  "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement"                                                                                                                          
Unable to update item access time                                                                                                              
Error during executing query "UPDATE PimItemTable SET atime = :0 WHERE ( collectionId = :1 )" :  "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement"                                                                                                
Unable to update item access time                                                                                                              
Error during executing query "UPDATE PimItemTable, CollectionPimItemRelation SET atime = :0 WHERE ( CollectionPimItemRelation.Collection_id = :1 AND ( CollectionPimItemRelation.PimItem_id = PimItemTable.id ) )" :  "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement"                                                                                                                          
Unable to update item access time
Comment 6 Thomas Arend 2014-09-08 20:29:48 UTC
Maybe this bug report is the best guess for this error.

Km,ail2 4.14 waits endlessly to retrieve the content of a folder. I remember that this was a bug before. I could not find the bug report.  It seems that the bug is back again after the update from today / yesterday it is back again. 

Linux openSuSE 13.1 rpms
Comment 7 Martin Steigerwald 2015-09-09 21:05:28 UTC
Valentin, thank you for your report. It is about a version of KMail which uses Nepomuk and is unmaintained. Thus closing. If you still see performance issues please open new reports. But please follow the following guide lines to avoid unnecessary work for the developers:

- Ideally test with KDEPIM and Akonadi 15.08. It contains some performance
improvements like the binary protocol.

- Otherwise at least use KDEPIM 4.14.10 and newest Akonadi 1.13 you can get as
it already contains some performance improvements.

- If you can wait, please retest with KDEPIM and Akonadi 15.12 once they become
available for you. Akonadi 15.12 will contain *massive* performance
improvements implemented by Dan due to new database indexes, optimized queries
and leveled file_db directory. All of these are in master already, so if you
dare use kdesrc-build to compile KF5, kdepim and kdepim-runtime. I am using
this currently and it basically moves the bottleneck to KMail (slow threading
for example). It is a *huge* improvement.

Thank you and greetings from KDE Randa Meetings,
Martin