| Summary: | Kmail very slow to load messages from local folder | ||
|---|---|---|---|
| Product: | [Applications] kmail2 | Reporter: | Valentin Rusu <valir> |
| Component: | folders | Assignee: | kdepim bugs <kdepim-bugs> |
| Status: | RESOLVED UNMAINTAINED | ||
| Severity: | normal | CC: | erenoglu, Martin, thomas, yehielb |
| Priority: | NOR | ||
| Version: | Git (master) | ||
| Target Milestone: | --- | ||
| Platform: | Other | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
|
Description
Valentin Rusu
2013-05-23 13:03:07 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. Note: Disabling nepomuk email searching greatly increased the speed. 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. 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 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 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 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 |