Bug 242371 - "Add to Address Book" does not work (akonadi MySQL down?)
Summary: "Add to Address Book" does not work (akonadi MySQL down?)
Status: RESOLVED FIXED
Alias: None
Product: kmail
Classification: Applications
Component: addressbook (show other bugs)
Version: 1.13.3
Platform: Gentoo Packages Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-21 16:13 UTC by Christoph Lange
Modified: 2011-05-05 15:29 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In: kdepim 4.6


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Christoph Lange 2010-06-21 16:13:34 UTC
Version:           1.13.3 (using KDE 4.4.4) 
OS:                Linux

Situation: I'm viewing a mail and want to add an address from the mail header to my address book.  I right-click on the address and select "Add to Address Book" from the context menu.  I have one address book called "Default Addressbook".  (I can tell you the exact Akonadi resource setup if needed.)  But in the "Select Address Book", I sometimes do not see any address book.

Here is some possibly relevant log from ~/.xsession-errors:

[akonadiserver] Could not contact query service.
[akonadiserver] QStringList Akonadi::NepomukSearch::search(const QString&) Calling blockingQuery() failed!
[akonadiserver] Could not contact query service.
[akonadiserver] QStringList Akonadi::NepomukSearch::search(const QString&) Calling blockingQuery() failed!
[akonadiserver] Error during executing query "SELECT CollectionTable.id, CollectionTable.remoteId, CollectionTable.name, CollectionTable.parentId, CollectionTable.resourceId, CollectionTable.subscribed, CollectionTable.cachePolicyInherit, CollectionTable.cachePolicyCheckInterval, CollectionTable.cachePolicyCacheTimeout, CollectionTable.cachePolicySyncOnDemand, CollectionTable.cachePolicyLocalParts FROM CollectionTable WHERE ( parentId IS NULL )" :  "MySQL server has gone away QMYSQL: Unable to execute query"
[akonadiserver] Error during selection of records from table "CollectionTable" filtered by "parentId" = QVariant(, ) "MySQL server has gone away QMYSQL: Unable to execute query"


Reproducible: Sometimes

Steps to Reproduce:
No idea how to reproduce it, but it usually occurs after KMail has been running for a long time.



OS: Linux (x86_64) release 2.6.31-thinkpad
Compiler: x86_64-pc-linux-gnu-gcc
Comment 1 Tim Holy 2010-07-12 17:29:46 UTC
I get this too. It wouldn't shock me if this is related to this issue:
http://randomguy3.wordpress.com/2010/06/01/d-bus-threading-issues/

But I don't know how to test that.
Comment 2 Christoph Lange 2010-08-19 22:00:07 UTC
More facts (now from KDE 4.4.5): Sometimes restarting KMail helped.  This time it didn't.  And the log in ~/.xsession-errors is slightly different:

[akonadiserver] Could not contact query service.
[akonadiserver] QStringList Akonadi::NepomukSearch::search(const QString&) Calling blockingQuery() failed!
[akonadiserver] Could not contact query service.
[akonadiserver] QStringList Akonadi::NepomukSearch::search(const QString&) Calling blockingQuery() failed!
[akonadiserver] Error during executing query "SELECT CollectionTable.id, CollectionTable.remoteId, CollectionTable.name, CollectionTable.parentId, CollectionTable.resourceId, CollectionTable.subscribed, CollectionTable.cachePolicyInherit, CollectionTable.cachePolicyCheckInterval, CollectionTable.cachePolicyCacheTimeout, CollectionTable.cachePolicySyncOnDemand, CollectionTable.cachePolicyLocalParts FROM CollectionTable WHERE ( parentId IS NULL )" :  "MySQL server has gone away QMYSQL: Unable to execute query"
[akonadiserver] Error during selection of records from table "CollectionTable" filtered by "parentId" = QVariant(, ) "MySQL server has gone away QMYSQL: Unable to execute query"
Comment 3 Carl Roth 2010-11-11 17:45:19 UTC
I get that too, with both the address book and with the calendar.  The annoying part is that neither kontact nor akonadiconsole complains about this condition.  In akonadiconsole, you can see that the entries that were added, but the don't get persisted to mysql and they don't have 'remote id' fields.

The only recovery method I have found that works is to 1) stop kontact, 2) restart akonadiserver. 3) start kontact.

It makes Akonadi not very useful at the moment.  I find myself running akonadiconsole constantly to monitor the condition where it stops communicating with mysql.
Comment 4 Jonathan Kolberg 2011-05-05 12:18:57 UTC
Couldn’t reproduce this with 4.6 beta5
Comment 5 Christophe Marin 2011-05-05 15:29:55 UTC
Fixed in kdepim 4.6