[Bug 245265] Long IMAP downloads cause mysql lock wait timeouts

[Volker Krause]

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





--- Comment #1 from Volker Krause <vkrause kde org>  2010-07-21 10:02:15 ---
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

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.