Bug 303922

Summary: Akonadi server requires restart after a few hours of inactivity, otherwise its services don't work anymore.
Product: [Frameworks and Libraries] Akonadi Reporter: Grzegorz Kowal <custos.mentis>
Component: serverAssignee: kdepim bugs <pim-bugs-null>
Status: RESOLVED DUPLICATE    
Severity: normal CC: dvratil
Priority: NOR    
Version First Reported In: 4.8   
Target Milestone: ---   
Platform: Gentoo Packages   
OS: Linux   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:

Description Grzegorz Kowal 2012-07-22 12:17:38 UTC 
I use KDE 4.8.4 from Gentoo.  My akonadi is set up to use an external MYSQL server.  Everything works fine after a fresh login to the kde session. When I leave it for a few hours inactive and then start, for example, kmail2, it shows plenty of errors like 'Unable to list items' or 'Error while trying to get the local inbox folder' and is unable to check emails on my IMAP accounts.

The reason for this problem is nicely described in the following comment:
 https://bugs.kde.org/show_bug.cgi?id=273612#c7

I think that the solution proposed in the referred comment, i.e., adding Options="MYSQL_OPT_RECONNECT=1" by default to QMYSQL section of .config/akonadi/akonadiserverrc could be good enough, since many services in KDE depend on aconadi now.

Reproducible: Always

Steps to Reproduce:
1. Login to KDE Session.
2. Leave it for several hours.
3. Try to use, e.g. KMail.
Actual Results:  
KMail shows plenty of errors like 'Unable to list items' or 'Error while trying to get the local inbox folder' and is unable to check emails on IMAP accounts or list local folders.

Expected Results:  
KMail should work normally.
Comment 1 Daniel Vrátil 2013-08-28 13:47:23 UTC 
This has been fixed in current git and will be available in Akonadi 1.10.3.

The server is sending dummy queries to MySQL to keep the connection alive.

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