[opensuse-factory] Problems rebuilding Akonadi database
Good evening, as for whatever reason the search database is messed up again (seems like akonadi cant deal with frequent suspend/hibernate/wake-up activities), I decided to go for a rebuild, this time using a postgres backend. After I deleted ~/.local/share/akonadi and started akonadi again, from what I saw so far - great. CPU temperatures much lower than under mysql. But, after some time: org.kde.pim.kimap: Connection to server lost 3 --> No idea - is this IMAP resource 3? Pass a valid window to KWallet::Wallet::openWallet(). org.kde.pim.kimap: Connection to server lost 3 org.kde.pim.kimap: Connection to server lost 3 Pass a valid window to KWallet::Wallet::openWallet(). org.kde.pim.kimap: Connection to server lost 3 org.kde.pim.kimap: Connection to server lost 3 Pass a valid window to KWallet::Wallet::openWallet(). org.kde.pim.kimap: Connection to server lost 3 What does the '3' indicate? IMAP resource 3? Now starting KMail: org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "23505" org.kde.pim.akonadiserver: DB error: "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505)" org.kde.pim.akonadiserver: Error text: "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505) QPSQL: Es konnte keine Abfrage erzeugt werden" org.kde.pim.akonadiserver: 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) RETURNING id" org.kde.pim.akonadiserver: Error during insertion into table "CollectionTable" "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505) QPSQL: Es konnte keine Abfrage erzeugt werden" org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "23505" org.kde.pim.akonadiserver: DB error: "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505)" org.kde.pim.akonadiserver: Error text: "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505) QPSQL: Es konnte keine Abfrage erzeugt werden" org.kde.pim.akonadiserver: 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) RETURNING id" org.kde.pim.akonadiserver: Error during insertion into table "CollectionTable" "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505) QPSQL: Es konnte keine Abfrage erzeugt werden" ...and KMail crashed with this. The error message it was showing: Im E-Mail-Programm ist ein schwerwiegender Fehler aufgetreten. Das Programm wird beendet. Die Fehlermeldung lautet: Could not create collection drafts, resourceId: 16 (Sorry for the german message....) But there is no such resource (16) in ~/.config/akonadi/ .... KMail crashed, but akonadi seems to run. It is issuing always the same messages, as it looks for the same elements: org.kde.pim.akonadiserver: processing retrieval request for item (77740) parts: ("RFC822") of resource: "akonadi_maildir_resource_0" org.kde.pim.akonadiserver: ItemRetrievalJob finished for request 0x7f6102c658d0 , error: "" org.kde.pim.akonadiserver: posting retrieval request for items (77739) there are 0 queues and 0 items in mine org.kde.pim.akonadiserver: ItemRetrievalJob Akonadi::Server::ItemRetrievalJob(0x5562b06d97e0) started for request 0x7f6102c7cfe0 org.kde.pim.akonadiserver: processing retrieval request for item (77739) parts: ("RFC822") of resource: "akonadi_maildir_resource_0" org.kde.pim.akonadiserver: ItemRetrievalJob finished for request 0x7f6102c7cfe0 , error: "" org.kde.pim.akonadiserver: posting retrieval request for items (77740) there are 0 queues and 0 items in mine org.kde.pim.akonadiserver: ItemRetrievalJob Akonadi::Server::ItemRetrievalJob(0x7f6102c7de60) started for request 0x7f6102c7acf0 org.kde.pim.akonadiserver: processing retrieval request for item (77740) parts: ("RFC822") of resource: "akonadi_maildir_resource_0" org.kde.pim.akonadiserver: ItemRetrievalJob finished for request 0x7f6102c7acf0 , error: "" org.kde.pim.akonadiserver: posting retrieval request for items (77739) there are 0 queues and 0 items in mine org.kde.pim.akonadiserver: ItemRetrievalJob Akonadi::Server::ItemRetrievalJob(0x7f6102c7ae60) started for request 0x7f6102c7e1f0 org.kde.pim.akonadiserver: processing retrieval request for item (77739) parts: ("RFC822") of resource: "akonadi_maildir_resource_0" org.kde.pim.akonadiserver: ItemRetrievalJob finished for request 0x7f6102c7e1f0 , error: "" org.kde.pim.akonadiserver: posting retrieval request for items (77740) there are 0 queues and 0 items in mine org.kde.pim.akonadiserver: ItemRetrievalJob Akonadi::Server::ItemRetrievalJob(0x7f6102c7e070) started for request 0x7f6102c7d3c0 Looks like this is an infinite loop, as I let it running during the night, but the messages did not change... I have created https://bugs.kde.org/show_bug.cgi?id=385532 for this, lets see.... Axel -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Hi, unfortunately no changes to the situation with KMail (and not even a reaction to the bug report). It still crashes with the error message: Could not create collection drafts, resourceId: 16 How can I find out what resourceId: 16 is? Thanks Axel Am Montag, 9. Oktober 2017, 20:47:47 CEST schrieb Axel Braun:
Good evening,
as for whatever reason the search database is messed up again (seems like akonadi cant deal with frequent suspend/hibernate/wake-up activities), I decided to go for a rebuild, this time using a postgres backend.
After I deleted ~/.local/share/akonadi and started akonadi again, from what I saw so far - great. CPU temperatures much lower than under mysql.
But, after some time:
org.kde.pim.kimap: Connection to server lost 3 --> No idea - is this IMAP resource 3? Pass a valid window to KWallet::Wallet::openWallet(). org.kde.pim.kimap: Connection to server lost 3 org.kde.pim.kimap: Connection to server lost 3 Pass a valid window to KWallet::Wallet::openWallet(). org.kde.pim.kimap: Connection to server lost 3 org.kde.pim.kimap: Connection to server lost 3 Pass a valid window to KWallet::Wallet::openWallet(). org.kde.pim.kimap: Connection to server lost 3
What does the '3' indicate? IMAP resource 3?
Now starting KMail:
org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "23505" org.kde.pim.akonadiserver: DB error: "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505)" org.kde.pim.akonadiserver: Error text: "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505) QPSQL: Es konnte keine Abfrage erzeugt werden" org.kde.pim.akonadiserver: 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) RETURNING id" org.kde.pim.akonadiserver: Error during insertion into table "CollectionTable" "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505) QPSQL: Es konnte keine Abfrage erzeugt werden" org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "23505" org.kde.pim.akonadiserver: DB error: "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505)" org.kde.pim.akonadiserver: Error text: "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505) QPSQL: Es konnte keine Abfrage erzeugt werden" org.kde.pim.akonadiserver: 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) RETURNING id" org.kde.pim.akonadiserver: Error during insertion into table "CollectionTable" "ERROR: duplicate key value violates unique constraint \"collectiontable_parentandnameindex\"\nDETAIL: Key (parentid, name)=(7, drafts) already exists.\n(23505) QPSQL: Es konnte keine Abfrage erzeugt werden"
...and KMail crashed with this. The error message it was showing:
Im E-Mail-Programm ist ein schwerwiegender Fehler aufgetreten. Das Programm wird beendet. Die Fehlermeldung lautet: Could not create collection drafts, resourceId: 16
(Sorry for the german message....)
But there is no such resource (16) in ~/.config/akonadi/ ....
KMail crashed, but akonadi seems to run. It is issuing always the same messages, as it looks for the same elements:
org.kde.pim.akonadiserver: processing retrieval request for item (77740) parts: ("RFC822") of resource: "akonadi_maildir_resource_0" org.kde.pim.akonadiserver: ItemRetrievalJob finished for request 0x7f6102c658d0 , error: "" org.kde.pim.akonadiserver: posting retrieval request for items (77739) there are 0 queues and 0 items in mine org.kde.pim.akonadiserver: ItemRetrievalJob Akonadi::Server::ItemRetrievalJob(0x5562b06d97e0) started for request 0x7f6102c7cfe0 org.kde.pim.akonadiserver: processing retrieval request for item (77739) parts: ("RFC822") of resource: "akonadi_maildir_resource_0" org.kde.pim.akonadiserver: ItemRetrievalJob finished for request 0x7f6102c7cfe0 , error: "" org.kde.pim.akonadiserver: posting retrieval request for items (77740) there are 0 queues and 0 items in mine org.kde.pim.akonadiserver: ItemRetrievalJob Akonadi::Server::ItemRetrievalJob(0x7f6102c7de60) started for request 0x7f6102c7acf0 org.kde.pim.akonadiserver: processing retrieval request for item (77740) parts: ("RFC822") of resource: "akonadi_maildir_resource_0" org.kde.pim.akonadiserver: ItemRetrievalJob finished for request 0x7f6102c7acf0 , error: "" org.kde.pim.akonadiserver: posting retrieval request for items (77739) there are 0 queues and 0 items in mine org.kde.pim.akonadiserver: ItemRetrievalJob Akonadi::Server::ItemRetrievalJob(0x7f6102c7ae60) started for request 0x7f6102c7e1f0 org.kde.pim.akonadiserver: processing retrieval request for item (77739) parts: ("RFC822") of resource: "akonadi_maildir_resource_0" org.kde.pim.akonadiserver: ItemRetrievalJob finished for request 0x7f6102c7e1f0 , error: "" org.kde.pim.akonadiserver: posting retrieval request for items (77740) there are 0 queues and 0 items in mine org.kde.pim.akonadiserver: ItemRetrievalJob Akonadi::Server::ItemRetrievalJob(0x7f6102c7e070) started for request 0x7f6102c7d3c0
Looks like this is an infinite loop, as I let it running during the night, but the messages did not change...
I have created https://bugs.kde.org/show_bug.cgi?id=385532 for this, lets see.... Axel
-- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Hello, Am Montag, 23. Oktober 2017, 22:00:09 CEST schrieb Axel:
unfortunately no changes to the situation with KMail (and not even a reaction to the bug report). It still crashes with the error message:
Could not create collection drafts, resourceId: 16
How can I find out what resourceId: 16 is?
Did you try akonadiconsole? It's quite helpful to do and see things "under the hood" you can't do in KMail - but please take the warning at startup serious and don't change anything unless you are 100% sure what you are doing. I'd _guess_ the resourceId refers to the account - see the "Agents" tab in akonadiconsole. Most of the agents have an "Identifier" of "akonadi_<whatever>_resource_<number>", and that number is what you should look for. If this doesn't help, try asking in the #akonadi IRC channel - the typical response time there is much better than in the bugreports ;-) Regards, Christian Boltz -- LGTM? There is a special place in hell for regular expressions. [ewindisch on https://github.com/docker/docker/pull/19069] -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
Am Mon, 23 Oct 2017 22:28:11 +0200 schrieb Christian Boltz <opensuse@cboltz.de>:
Hello,
Am Montag, 23. Oktober 2017, 22:00:09 CEST schrieb Axel:
unfortunately no changes to the situation with KMail (and not even a reaction to the bug report). It still crashes with the error message:
Could not create collection drafts, resourceId: 16
How can I find out what resourceId: 16 is?
Did you try akonadiconsole? It's quite helpful to do and see things "under the hood" you can't do in KMail - but please take the warning at startup serious and don't change anything unless you are 100% sure what you are doing.
Yes, I had a look at akonadiconsole, but it does not give me a resource with ID 16 either. In total I see 25 Agents for all kind of purposes (including IMAP and POP3 Resources). But they are not numbered
I'd _guess_ the resourceId refers to the account - see the "Agents" tab in akonadiconsole. Most of the agents have an "Identifier" of "akonadi_<whatever>_resource_<number>", and that number is what you should look for.
Thought so as well, but - see above.
If this doesn't help, try asking in the #akonadi IRC channel - the typical response time there is much better than in the bugreports ;-)
Thanks Christian! Axel -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org
participants (4)
-
Axel -
Axel Braun
-
Christian Boltz -
Dr. Axel Braun