Bug 242371

Summary:	"Add to Address Book" does not work (akonadi MySQL down?)
Product:	[Applications] kmail	Reporter:	Christoph Lange <langec>
Component:	addressbook	Assignee:	kdepim bugs <kdepim-bugs>
Status:	RESOLVED FIXED
Severity:	normal	CC:	holy, j_kolberg11, roth
Priority:	NOR
Version:	1.13.3
Target Milestone:	---
Platform:	Gentoo Packages
OS:	Linux
Latest Commit:		Version Fixed In:	kdepim 4.6

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