Mailinglist Archive: opensuse-factory (826 mails)

< Previous Next >
Re: [opensuse-factory] Problems rebuilding Akonadi database
  • From: Axel <axel.braun@xxxxxx>
  • Date: Mon, 23 Oct 2017 22:00:09 +0200
  • Message-id: <7932028.bnqpQzhEA0@t520.axxite.internal>
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@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse-factory+owner@xxxxxxxxxxxx

< Previous Next >
Follow Ups
References