Bug 367846

Summary: KMail2 and akonadiconsole continuously lose connection to akonadi server - happens every 30 secs to 2 minutes.
Product: [Frameworks and Libraries] Akonadi Reporter: Rodney Baker <rodney.baker>
Component: serverAssignee: kdepim bugs <kdepim-bugs>
Status: RESOLVED DUPLICATE    
Severity: grave CC: cfeck, dvratil, frank.mehnert, fresh.road1272, heikkivalisuo, host71, iivanich, rodney.baker, sknauss, till2.schaefer, tprotopopescu
Priority: NOR    
Version: 5.2.0   
Target Milestone: ---   
Platform: Other   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Attachments: Requested gdb 'thread apply all bt' dump

Description Rodney Baker 2016-08-26 11:16:23 UTC
After updating to kmail2 v5.2.3 and the latest version of akonadi in openSuSE Tumbleweed, kmail and akonadiconsold continuously lose connection to the akonadi server for 10-45 seconds at a time. This appears to happen at intervals of anywhere from 10-60 seconds. 

Running akonadiconsole from the command line reveals the following output; 

0:35:15 bakerr@mako:~> akonadiconsole
org.kde.akonadi.ETM: GEN true true true
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: GEN true false true
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: GEN true false true
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: GEN true false true
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: Subtree:  254 QSet(254)
org.kde.akonadi.ETM: Subtree:  114 QSet(114)
org.kde.akonadi.ETM: Subtree:  263 QSet(263)
org.kde.akonadi.ETM: Fetch job took  5752 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 3
org.kde.akonadi.ETM: first fetched collection: "Google Calendar"
org.kde.akonadi.ETM: Subtree:  103 QSet(103)
org.kde.akonadi.ETM: Subtree:  142 QSet(142)
org.kde.akonadi.ETM: Subtree:  262 QSet(262)
org.kde.akonadi.ETM: Subtree:  254 QSet(254)
org.kde.akonadi.ETM: Subtree:  87 QSet(145, 87, 102, 89, 88, 90, 93, 92, 95, 94, 97, 96, 99, 98, 101, 100)
org.kde.akonadi.ETM: Subtree:  105 QSet(105)
org.kde.akonadi.ETM: Subtree:  104 QSet(104, 149, 151, 150)
org.kde.akonadi.ETM: Subtree:  148 QSet(148)
org.kde.akonadi.ETM: Subtree:  106 QSet(107, 106, 109, 108, 113, 110, 112)
org.kde.akonadi.ETM: Subtree:  1 QSet(1, 139)
org.kde.akonadi.ETM: Subtree:  168 QSet(236, 239, 238, 225, 224, 227, 226, 229, 228, 231, 230, 249, 248, 241, 240, 243, 242, 245, 244, 247, 246, 169, 168, 171, 170, 173, 172, 175, 174, 185, 184, 187, 186, 189, 188, 191, 190, 177, 176, 179, 178, 181, 180, 183, 182, 201, 200, 203, 202, 205, 204, 207, 206, 193, 192, 195, 194, 197, 196, 199, 198, 217, 216, 219, 218, 221, 220, 223, 222, 209, 208, 211, 210, 213, 212, 215, 214, 233, 235, 234, 237)
org.kde.akonadi.ETM: Subtree:  114 QSet(114)
org.kde.akonadi.ETM: Subtree:  250 QSet(251, 250, 253, 252)
org.kde.akonadi.ETM: Subtree:  263 QSet(263)
org.kde.akonadi.ETM: Fetch job took  5759 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 122
org.kde.akonadi.ETM: first fetched collection: "Search"
org.kde.akonadi.ETM: Subtree:  254 QSet(254)
org.kde.akonadi.ETM: Subtree:  114 QSet(114)
org.kde.akonadi.ETM: Fetch job took  5758 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 2
org.kde.akonadi.ETM: first fetched collection: "Google Calendar"
org.kde.akonadi.ETM: Subtree:  103 QSet(103)
org.kde.akonadi.ETM: Subtree:  142 QSet(142)
org.kde.akonadi.ETM: Subtree:  262 QSet(262)
org.kde.akonadi.ETM: Subtree:  105 QSet(105)
org.kde.akonadi.ETM: Fetch job took  5759 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 4
org.kde.akonadi.ETM: first fetched collection: "Notes"
akonadicore_log: Socket error occurred: "QLocalSocket: Remote closed"
akonadicore_log: Socket error occurred: "QLocalSocket: Remote closed"
akonadicore_log: Socket error occurred: "QLocalSocket: Remote closed"
akonadicore_log: Socket error occurred: "QLocalSocket: Remote closed"
akonadicore_log: Socket error occurred: "QLocalSocket: Remote closed"
akonadicore_log: Socket error occurred: "QLocalSocket: Remote closed"
akonadicore_log: Socket error occurred: "QLocalSocket: Remote closed"
akonadicore_log: Socket error occurred: "QLocalSocket: Remote closed"
akonadicore_log: Socket error occurred: "QLocalSocket: Remote closed"
akonadicore_log: Socket error occurred: "QLocalSocket: Remote closed"
akonadicore_log: Socket error occurred: "QLocalSocket: Remote closed"
org.kde.akonadi.ETM: GEN true true true
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: GEN true false true
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: GEN true false true
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: GEN true false true
org.kde.akonadi.ETM: collection: QVector()
org.kde.akonadi.ETM: Subtree:  254 QSet(254)
org.kde.akonadi.ETM: Subtree:  114 QSet(114)
org.kde.akonadi.ETM: Subtree:  263 QSet(263)
org.kde.akonadi.ETM: Fetch job took  1861 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 3
org.kde.akonadi.ETM: first fetched collection: "Google Calendar"
org.kde.akonadi.ETM: Subtree:  103 QSet(103)
org.kde.akonadi.ETM: Subtree:  142 QSet(142)
org.kde.akonadi.ETM: Subtree:  262 QSet(262)
org.kde.akonadi.ETM: Subtree:  254 QSet(254)
org.kde.akonadi.ETM: Subtree:  87 QSet(145, 87, 102, 89, 88, 90, 93, 92, 95, 94, 97, 96, 99, 98, 101, 100)
org.kde.akonadi.ETM: Subtree:  105 QSet(105)
org.kde.akonadi.ETM: Subtree:  104 QSet(104, 149, 151, 150)
org.kde.akonadi.ETM: Subtree:  148 QSet(148)
org.kde.akonadi.ETM: Subtree:  106 QSet(107, 106, 109, 108, 113, 110, 112)
org.kde.akonadi.ETM: Subtree:  1 QSet(1, 139)
org.kde.akonadi.ETM: Subtree:  168 QSet(236, 239, 238, 225, 224, 227, 226, 229, 228, 231, 230, 249, 248, 241, 240, 243, 242, 245, 244, 247, 246, 169, 168, 171, 170, 173, 172, 175, 174, 185, 184, 187, 186, 189, 188, 191, 190, 177, 176, 179, 178, 181, 180, 183, 182, 201, 200, 203, 202, 205, 204, 207, 206, 193, 192, 195, 194, 197, 196, 199, 198, 217, 216, 219, 218, 221, 220, 223, 222, 209, 208, 211, 210, 213, 212, 215, 214, 233, 235, 234, 237)
org.kde.akonadi.ETM: Subtree:  114 QSet(114)
org.kde.akonadi.ETM: Subtree:  250 QSet(251, 250, 253, 252)
org.kde.akonadi.ETM: Subtree:  263 QSet(263)
org.kde.akonadi.ETM: Fetch job took  1866 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 122
org.kde.akonadi.ETM: first fetched collection: "Search"
org.kde.akonadi.ETM: Subtree:  254 QSet(254)
org.kde.akonadi.ETM: Subtree:  114 QSet(114)
org.kde.akonadi.ETM: Fetch job took  1867 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 2
org.kde.akonadi.ETM: first fetched collection: "Google Calendar"
org.kde.akonadi.ETM: Subtree:  103 QSet(103)
org.kde.akonadi.ETM: Subtree:  142 QSet(142)
org.kde.akonadi.ETM: Subtree:  262 QSet(262)
org.kde.akonadi.ETM: Subtree:  105 QSet(105)
org.kde.akonadi.ETM: Fetch job took  1870 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 4
org.kde.akonadi.ETM: first fetched collection: "Notes"

The dropouts seem to coincide with the akonadicore_log socket errors. 

Akonadidb is running on mysql. Using IMAP with dovecot (on a server on the same network) and gmail (remotely). 

Reproducible: Always

Steps to Reproduce:
1. Open kmail
2. Wait - kmail reports "The akonadi personal information management service is not running...."
3. Sometimes the connection is re-established, but sometimes it requires a forced restart by clicking the "start" button. 

Actual Results:  
Kmail (and akonadiconsole) lose connection to the akonadi server.

Expected Results:  
The connection should be stable.
Comment 1 Frits Spieker 2016-08-30 09:04:21 UTC
I am "glad" I am not the only one. Have exactly the same error.
Comment 2 heikkivalisuo 2016-09-02 07:47:53 UTC
some examples:

Pass a valid window to KWallet::Wallet::openWallet().
false
false
false
[
0: akonadiserver() [0x581146]
1: akonadiserver() [0x581462]
2: /lib64/libc.so.6(+0x349f0) [0x7f6544ae69f0]
3: [0x7f6514032130]
]

log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicontrol: ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"

----------------------------

org.kde.akonadi.ETM: Fetch job took  31 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 8
org.kde.akonadi.ETM: first fetched collection: "Search"
log_akonadicore: The item sync is being rolled-back.
log_akonadicore: The item sync is being rolled-back.
log_imapresource: "Connection to server lost."
log_akonadicore: The item sync is being rolled-back.
log_imapresource: "Connection to server lost."
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicontrol: ProcessControl: Application "akonadiserver" stopped unexpectedly ( "Process crashed" )
log_akonadicontrol: Application 'akonadiserver' crashed! 1 restarts left.

-----------------------------

org.kde.akonadi.ETM: Fetch job took  81 msec
org.kde.akonadi.ETM: was collection fetch job: collections: 8
org.kde.akonadi.ETM: first fetched collection: "Search"
[
0: akonadiserver() [0x581146]
1: akonadiserver() [0x581462]
2: /lib64/libc.so.6(+0x349f0) [0x7f03c72c89f0]
]

log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
log_akonadicontrol: ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
log_akonadicore: Socket error occurred: "QLocalSocket: Remote closed"

--------------------------------------
Comment 3 heikkivalisuo 2016-09-02 07:54:38 UTC
This was left out from the beginning of my previous comment

org.kde.kgapi: 
log_akonadiplugin_indexer: invalid query  "{\n    \"limit\": -1,\n    \"negated\": false,\n    \"rel\": 0,\n    \"subTerms\": [\n        {\n            \"cond\": 0,\n            \"key\": \"name\",\n            \"negated\": false,\n            \"value\": \"NN <NN@gmail.com>\"\n        }\n    ]\n}\n"
log_akonadiplugin_indexer: invalid query  "{\n    \"limit\": -1,\n    \"negated\": false,\n    \"rel\": 0,\n    \"subTerms\": [\n        {\n            \"cond\": 0,\n            \"key\": \"name\",\n            \"negated\": false,\n            \"value\": \"NN <NN@gmail.com>\"\n        }\n    ]\n}\n"
Pass a valid window to KWallet::Wallet::openWallet().
false
false
false
Comment 4 Rodney Baker 2016-09-03 09:29:42 UTC
This now seems to be resolved for me after deleting all imap accounts in KMail, then dropping and recreating the akonadi database, then recreating the imap accounts. Since doing that I've not seen KMail2 lose connection to the akonadi server.

I will continue to monitor and if it remains stable I will mark this as resolved.
Comment 5 Frits Spieker 2016-09-04 06:13:21 UTC
Not to be blunt, but deleting all imap accounts, dropping and recreating the akonadi database and recreating of all imap accounts is not what I would call resolved. It is a messy workaround and a very messy one at that. What about users that also still have pop3 email boxes? What about the less technical inclined? 
It's a messy workaround which hides a messy bug which is in need of a proper fix.
Comment 6 Rodney Baker 2016-09-05 09:23:58 UTC
 (In reply to Frits Spieker from comment #5)
> Not to be blunt, but deleting all imap accounts, dropping and recreating the
> akonadi database and recreating of all imap accounts is not what I would
> call resolved. It is a messy workaround and a very messy one at that. What
> about users that also still have pop3 email boxes? What about the less
> technical inclined? 
> It's a messy workaround which hides a messy bug which is in need of a proper
> fix.

In my case it is a resolution because it was most likely caused by an upgrade from 4.14.x to 5.23.x. There are documented incompatibilities between KDE4 and KF5 versions of KDE PIM that I was not aware of when I upgraded. This was the likely cause of the instability. There is a recommended upgrade procedure which I'd not followed because I was not aware of it. Deleting/recreating the akonadi database has solved the problem in my case. YMMV. I'm happy to leave this open for the devs to review - the cause of your issue may be different.
Comment 7 Holger 2016-09-05 19:15:57 UTC
Same problem here. 
Today I found this forum entry: 
https://forums.opensuse.org/showthread.php/519603-Problem-with-KMail-and-Akonadi

Installing the packages from the given repos  (I am running openSUSE Tumbleweed) solved the issue for me temporarily. But official bug fix would be appreciated.
Comment 8 tprotopopescu 2016-10-04 08:56:45 UTC
(In reply to Holger from comment #7)
> Same problem here. 
> Today I found this forum entry: 
> https://forums.opensuse.org/showthread.php/519603-Problem-with-KMail-and-
> Akonadi
> 
> Installing the packages from the given repos  (I am running openSUSE
> Tumbleweed) solved the issue for me temporarily. But official bug fix would
> be appreciated.

Unfortunately, this workaround does not seem to work for everyone, so an official fix is still needed.
Comment 9 Daniel Vrátil 2016-10-05 07:53:01 UTC
Could someone please try to get a backtrace of the crash? You can attach GDB to the running akonadiserver process:

create a file called "akonadi.dbg" with following content:

c
set pagination off
t a a bt
q

Then attach GDB to the running Akonadi server process:

gdb -p $(pidof akonadiserver) -x akonadi.dbg

Once the server crashes, GDB will print out the backtrace of the crash and quit. Copy the backtrace and paste it here, then we can figure out what's crashing and how to fix it :-) Thanks
Comment 10 Frank Mehnert 2016-10-05 15:18:26 UTC
Created attachment 101435 [details]
Requested gdb 'thread apply all bt' dump

Thread 8 was crashing.
Comment 11 Frank Mehnert 2016-10-05 15:24:37 UTC
Please let me know if you need more information. I suffer from this bug since 2 days. I'm not 100% sure but this might have started after I tried to change the local subscription settings of my IMAP accounts.
Comment 12 Frank Mehnert 2016-10-05 18:32:44 UTC
I wonder if this has something to do with emailContacts:

xapian-check emailContacts
Cross-checking document lengths between the postlist and termlist tables would use more than 1GB of memory, so skipping that check
docdata:
blocksize=8K items=11 firstunused=1 revision=1 levels=0 root=0
B-tree checked okay
docdata table structure checked OK

termlist:
blocksize=8K items=11 firstunused=1 revision=1 levels=0 root=0
B-tree checked okay
xapian-check: Unknown exception

The "unknown exception" does not happen if I check the other DBs in the search_db directory (calendars, collections, contacts, email or notes). Even if I reboot the box, remove emailContacts from a non-X session (akonadi not running), then login with KDE, emailContacts is regenerated (very small at the beginning). When I start kmail2 and fetch the e-mails a few times, emailContacts gets some more content and the xapian-check run fails again with "Unknown exception".

Using xapian 1.4.0-2 on Debian/Sid.
Comment 13 Frank Mehnert 2016-10-06 12:05:39 UTC
I'm getting desperate and I would like to work around this problem by recreating the akonadi DB. In the above comments I see

''This now seems to be resolved for me after deleting all imap accounts in KMail, then dropping and recreating the akonadi database, then recreating the imap accounts. Since doing that I've not seen KMail2 lose connection to the akonadi server.''

Could someone explain these steps a little bit more in detail? I don't want to lose mails...
Comment 14 Sandro Knauß 2016-10-07 12:41:06 UTC
Sounds like a duplicate of #363741
Comment 15 Till Schäfer 2016-10-07 13:29:08 UTC

*** This bug has been marked as a duplicate of bug 363741 ***