[Akonadi] [Bug 283334] After suspend to ram KMail does not work, akonadi says "MySQL server has gone away."

Dean Cording dean at cording.id.au
Sun Jun 1 11:41:58 BST 2014


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

Dean Cording <dean at cording.id.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dean at cording.id.au

--- Comment #31 from Dean Cording <dean at cording.id.au> ---
I am getting this error again with Akonadi version 1.12.1 under Kubuntu 14.04
with KDE 4.13.1.  After I resume from suspend to RAM, kmail cannot access any
mail folders and the Akondai server reports:

DATABASE ERROR:
Error code: 2006
DB error:  "MySQL server has gone away"
Error text: "MySQL server has gone away QMYSQL: Unable to execute query"
Query: "SELECT CollectionTable.id, CollectionTable.remoteId,
CollectionTable.remoteRevision, CollectionTable.name, CollectionTable.parentId,
CollectionTable.resourceId, CollectionTable.subscribed,
CollectionTable.cachePolicyInherit, CollectionTable.cachePolicyCheckInterval,
CollectionTable.cachePolicyCacheTimeout,
CollectionTable.cachePolicySyncOnDemand, CollectionTable.cachePolicyLocalParts,
CollectionTable.queryString, CollectionTable.queryAttributes,
CollectionTable.queryCollections, CollectionTable.isVirtual FROM
CollectionTable WHERE ( remoteId = :0 AND resourceId = :1 )"
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_davgroupware_resource_10_12904_hrngU9" now
serving: () 
Lost connection to resource
"org.freedesktop.Akonadi.Resource.akonadi_davgroupware_resource_10" ,
discarding cached interface


Restarting the Akondai server recovers from the problem.

An interesting clue is that if I suspend to RAM and then immediately resume
(within a minute) the error does not occur and everything is OK.

In my ~/.local/share/akonadi/mysql.conf file has:

# wait 365d before dropping the DB connection (default:8h)
wait_timeout=31536000

-- 
You are receiving this mail because:
You are the assignee for the bug.



More information about the Kdepim-bugs mailing list