Summary: | Long IMAP downloads cause mysql lock wait timeouts | ||
---|---|---|---|
Product: | [Frameworks and Libraries] Akonadi | Reporter: | Leo Franchi <lfranchi> |
Component: | IMAP resource | Assignee: | Kevin Ottens <ervin> |
Status: | RESOLVED FIXED | ||
Severity: | normal | CC: | kdepim-bugs, vkrause |
Priority: | NOR | ||
Version: | 1.3.50 | ||
Target Milestone: | --- | ||
Platform: | Unlisted Binaries | ||
OS: | Linux | ||
Latest Commit: | Version Fixed In: |
Description
Leo Franchi
2010-07-20 23:57:52 UTC
Just for the record, the suggestions at the end still need to be tested AFAIK: [Monday 19 July 2010] [15:36:38] <lfranchi> krake_: i still have the PimTable timeout issues, but I don't think it's related to your specialcollections fix anymore [Monday 19 July 2010] [15:36:50] <lfranchi> my internet is just super flaky and akonady apparently really doesn't like that [Monday 19 July 2010] [15:37:52] <krake> lfranchi: you could check if some other session shows similar behaviror, i.e. lots of BEGIN commands but no COMMIT or ROLLBACK ending the transactions [Monday 19 July 2010] [15:38:01] <krake> lfranchi: this is how I found the one I fixed [Monday 19 July 2010] [15:40:18] <lfranchi> ok [Monday 19 July 2010] [15:42:59] <krake> lfranchi: of course there could be other things than open transactions which might be causing this. [Monday 19 July 2010] [15:43:46] <krake> another option might be to use lxr.kde.org to check for use and subclassing of Akonadi::TransactionSequence [Monday 19 July 2010] [15:44:15] <lfranchi> it might be related to the slow/hanging internet/imap resource [Monday 19 July 2010] [15:44:21] <lfranchi> apparently it just got faster, problem went away [Monday 19 July 2010] [15:47:40] <volker|office> ah, ItemSync (used internally by the resource) can use a single transaction sequence indeed, and when used in streaming mode it can stay open for quite some time [Monday 19 July 2010] [15:48:45] <volker|office> lfranchi: you could try to change mTransactionMode in kdepimlibs/akonadi/itemsync.cpp from Single to Chunkwise or None, and see if that helps Ah right, my bad. I forgot about it. Testing now. Should this report be marked as fixed now? Suggestions from comment #1 have been implemented some time ago already. |