http://bugzilla.suse.com/show_bug.cgi?id=1003261 http://bugzilla.suse.com/show_bug.cgi?id=1003261#c1 --- Comment #1 from Howard Guo --- Created attachment 696094 --> http://bugzilla.suse.com/attachment.cgi?id=696094&action=edit Archive of entire ~/.local/share/akonadi -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.suse.com/show_bug.cgi?id=1003261 http://bugzilla.suse.com/show_bug.cgi?id=1003261#c3 Luca Beltrame changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |hguo@suse.com Flags| |needinfo?(hguo@suse.com) --- Comment #3 from Luca Beltrame --- Please attach the output of "akonadictl start" on the command line. -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.suse.com/show_bug.cgi?id=1003261 http://bugzilla.suse.com/show_bug.cgi?id=1003261#c5 Luca Beltrame changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lbeltrame@kde.org Flags| |needinfo?(hguo@suse.com) --- Comment #5 from Luca Beltrame --- (In reply to Howard Guo from comment #4)

it says "akonadi is already running".

I'm fairly sure this is a problem I've already seen with occasional memory corruption which breaks Akonadi on runtime, but I still need some confirmation. Please issue "akonadictl restart" and report the output. -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.suse.com/show_bug.cgi?id=1003261 http://bugzilla.suse.com/show_bug.cgi?id=1003261#c7 Luca Beltrame changed: What |Removed |Added ---------------------------------------------------------------------------- Flags| |needinfo?(hguo@suse.com) --- Comment #7 from Luca Beltrame --- (In reply to Howard Guo from comment #6)

There's no output from the command, it has been hanging for over 10 minutes so I don't think it's going to finish doing the work. In the meanwhile a "Starting akonadi" progress bar shows up on desktop and keeps spinning.

Then I'm fairly sure of what's going on. Kill all "akonadi*" processes (all of them), in particular "akonadiserver". Try restarting Akonadi with "akonadictl start". See if you get an error about corrupted memory. -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.suse.com/show_bug.cgi?id=1003261 http://bugzilla.suse.com/show_bug.cgi?id=1003261#c9 --- Comment #9 from Luca Beltrame --- Comment on attachment 696134 --> http://bugzilla.suse.com/attachment.cgi?id=696134 akonadi and kmail startup output

org.kde.akonadi.ETM: GEN true false false log_akonadiserver: Database error: Cannot open database. org.kde.akonadi.ETM: collection: QVector() log_akonadiserver: Last driver error: "QMYSQL: Unable to connect" log_akonadiserver: Last database error: "Can't create a new thread (errno 11 \"Resource temporarily unavailable\"); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug" org.kde.akonadi.ETM:

Is mysqld running? -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.suse.com/show_bug.cgi?id=1003261 http://bugzilla.suse.com/show_bug.cgi?id=1003261#c11 --- Comment #11 from Luca Beltrame --- (In reply to Howard Guo from comment #10)

Neither mysql server nor client is installed

Install "mariadb" and see if it works afterwards. -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.suse.com/show_bug.cgi?id=1003261 http://bugzilla.suse.com/show_bug.cgi?id=1003261#c13 --- Comment #13 from Luca Beltrame --- Ok, I looked at the output again. It looks like mysql crashes or something of the sort during startup. I noticed this from your logs: DATABASE ERROR: Error code: 1062 DB error: "Duplicate entry 'inode/directory' for key 'name'" Error text: "Duplicate entry 'inode/directory' for key 'name' QMYSQL3: Unable to execute statement" Query: "INSERT INTO MimeTypeTable (name) VALUES (:0)"Error during insertion into table "MimeTypeTable" "Duplicate entry 'inode/directory' for key 'name' QMYSQL3: Unable to execute statement"QObject::killTimer: Timers cannot be stopped from another threadDATABASE ERROR: Error code: 1062 DB error: "Duplicate entry '5-inbox' for key 'CollectionTable_parentAndNameIndex'" Error text: "Duplicate entry '5-inbox' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement" Query: "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, enabled, syncPref, displayPref, indexPref, cachePolicyInherit, cachePolicyCheckInterval, cachePolicyCacheTimeout, cachePolicySyncOnDemand, cachePolicyLocalParts, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)"Error during insertion into table "CollectionTable" "Duplicate entry '5-inbox' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"QObject::killTimer: Timers cannot be stopped from another thread I wonder if this is related. Can you check whether a fresh user account works? -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.suse.com/show_bug.cgi?id=1003261 http://bugzilla.suse.com/show_bug.cgi?id=1003261#c15 --- Comment #15 from Luca Beltrame --- I cannot guarantee when/if I'll be able to do this, unfortunately. -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.suse.com/show_bug.cgi?id=1003261 http://bugzilla.suse.com/show_bug.cgi?id=1003261#c17 Fabian Vogt changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |fabian@ritter-vogt.de --- Comment #17 from Fabian Vogt --- I tried to reproduce this three times now and got: - First time, just starting kmail from a new user account results in same behaviour as reported (akonadi runs, unresponsive and unusuable). killall /usr/bin/akondadi_*; akonadictl start; brought it back - Second time, "akonadictl start", then kmail worked fine - Third time, just kmail again worked fine as well. Between the steps I cleared ~/.{cache,local,config,share,kde4}. -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.suse.com/show_bug.cgi?id=1003261 http://bugzilla.suse.com/show_bug.cgi?id=1003261#c20 Antonio Larrosa changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |alarrosa@suse.com --- Comment #20 from Antonio Larrosa --- I did some debugging this morning and found the problem seems to be a wrong insert which duplicates an unique entry in the akonadi database. I reported this upstream at https://bugs.kde.org/show_bug.cgi?id=371570 . -- You are receiving this mail because: You are on the CC list for the bug.