Bug 234430 - Addressbook looses contacts after certain time
Summary: Addressbook looses contacts after certain time
Status: RESOLVED FIXED
Alias: None
Product: kaddressbook
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: unspecified Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-15 13:03 UTC by karaluh
Modified: 2010-04-20 10:45 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description karaluh 2010-04-15 13:03:42 UTC
Version:           4.4.2 (using 4.4.2 (KDE 4.4.2), Kubuntu packages)
Compiler:          cc
OS:                Linux (i686) release 2.6.32-20-generic

After some time Addresbook looses contact information. All the contact are on the list, you can filter them but selecting one doesn't display anything, the last selected contact information are displayed instead. Double clicking on some contact opens edit dialog box, but all the fields are empty. Restarting kontact fixes the issue until it occures again.
Comment 1 Tobias Koenig 2010-04-16 17:15:42 UTC
Hej,

do you see any error messages on the console?
Or can you try to start 'akonadiconsole' together with kaddressbook and let it run the
same time as kaddressbook, and as soon as kaddressbook stops to work check whether akonadiconsole
shows the same behavior? I suspect it might be some timeout in the connection to MySQL daemon or
something like that...

Ciao,
Tobias
Comment 2 karaluh 2010-04-20 08:19:25 UTC
(In reply to comment #1)
> do you see any error messages on the console?

Unfortunately, no.

> Or can you try to start 'akonadiconsole' together with kaddressbook and let it
> run the
> same time as kaddressbook, and as soon as kaddressbook stops to work check
> whether akonadiconsole
> shows the same behavior? I suspect it might be some timeout in the connection
> to MySQL daemon or
> something like that...

Below is the debug information from Akonadi Console - BTW timestamps would be realy appreciated here :) It's when I try to display a contact in kaddressbook.

0x99e1f68 21 SEARCH "prefix nco:<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#>SELECT ?r WHERE { ?r a nco:PersonContact }" FULLPAYLOAD EXTERNALPAYLOAD (UID REMOTEID COLLECTIONID FLAGS SIZE DATETIME) 
0x99e1f68 21 OK SEARCH completed 
0x99e1f68 22 SEARCH "prefix nco:<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#>SELECT ?r WHERE { ?r a nco:PersonContact }" FULLPAYLOAD EXTERNALPAYLOAD (UID REMOTEID COLLECTIONID FLAGS SIZE DATETIME) 
0x99e1f68 22 OK SEARCH completed 
0x99e1f68 23 UID FETCH 85 FULLPAYLOAD EXTERNALPAYLOAD (UID REMOTEID COLLECTIONID FLAGS SIZE DATETIME) 
0x99e1f68 23 NO Unable to list items 

And this is what I get when I try to display collectionattributetable in DB Browser:
6 OK Completed 
7 FETCH 1:* FULLPAYLOAD ANCESTORS INF EXTERNALPAYLOAD (UID REMOTEID COLLECTIONID FLAGS SIZE DATETIME) 
7 NO Unable to list items 
8 SELECT SILENT 4 
8 OK Completed 
9 FETCH 1:* FULLPAYLOAD ANCESTORS INF EXTERNALPAYLOAD (UID REMOTEID COLLECTIONID FLAGS SIZE DATETIME) 
9 NO Unable to list items 

So I guess it doesn't work either.
Comment 3 karaluh 2010-04-20 08:26:40 UTC
I forgot to mention, that restarting akonadiconsole fixes it. kaddressbook is used as a kontact component.
Comment 4 Tobias Koenig 2010-04-20 10:45:18 UTC
Hej,

this issue has been fixed upstream already in SVN revision 1094139 by increasing the timeout of the mysqld connection.
You can adapt that on your local system by adding the following line to your
 $HOME/.local/share/akonadi/mysql.conf

wait_timeout = 1296000

and restarting Akonadi.
This will allow Akonadi to be idle 15 days before the connection to mysqld gets dropped.