Problems rebuilding Akonadi database

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Problems rebuilding Akonadi database

Axel Braun-2
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: [hidden email]
To contact the owner, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Problems rebuilding Akonadi database

Axel Braun-2
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: [hidden email]
To contact the owner, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Problems rebuilding Akonadi database

Christian Boltz-5
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: [hidden email]
To contact the owner, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Problems rebuilding Akonadi database

Axel Braun-2
Am Mon, 23 Oct 2017 22:28:11 +0200
schrieb Christian Boltz <[hidden email]>:

> 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: [hidden email]
To contact the owner, e-mail: [hidden email]