Re: KMail and Akonadi throwing thousands of errors

Hi Ingo -

I ran through this process to re-synchronize Akonadi with the IMAP server.  It seems to have worked.  The folder counts now match between Thunderbird and KMaIL, and I no longer see the steady stream of messages coming from Akonadi.

For now I have switched back to KMail even though Akonadi strikes me as a very brittle part of the system.

I do see a different message coming from Akonadi.  Is this anything to be concerned about?  It seems to be complaining about a missing file.  These messages show up abot every five minutes or so.

============
org.kde.pim.akonadiserver.search: Executing search "searchUpdate-1631129500"
org.kde.pim.akonadiserver.search: Search  "searchUpdate-1631129500" done (without remote search)
org.kde.pim.akonadiserver.search: Search update for collection "OpenInvitations" ( 50 ) finished: all results:  0 , removed results: 0
org.kde.pim.akonadiserver.search: Executing search "searchUpdate-1631129500"
org.kde.pim.akonadiserver.search: Search  "searchUpdate-1631129500" done (without remote search)
org.kde.pim.akonadiserver.search: Search update for collection "DeclinedInvitations" ( 51 ) finished: all results:  0 , removed results: 0
org.kde.pim.akonadiserver: "akonadi_maildir_resource_0" NOT Closing idle db connection; we are in transaction
org.kde.pim.akonadiserver: "akonadi_maildir_resource_0" NOT Closing idle db connection; we are in transaction
org.kde.pim.akonadiserver: ItemRetrievalJob for request 328 finished
org.kde.pim.akonadicore: Failed to open external payload: "/home/bgee/.local/share/akonadi/file_db_data/15/39315_r0" "No such file or directory"
==========

When I look at the contents of the directory, I see this:

[bgee@main2 ~]$ ll .local/share/akonadi/file_db_data/15
total 64
-rw-r--r-- 1 bgee bgee  7447 May 22 15:33 1115_r0
-rw-rw-r-- 1 bgee bgee  7540 Sep  7 13:32 38915_r0
-rw-rw-r-- 1 bgee bgee 29467 Sep  8 14:38 39315_r1
-rw-r--r-- 1 bgee bgee  5071 May 22 15:34 4415_r0
-rw-r--r-- 1 bgee bgee  7837 May 22 15:33 715_r0


Regards -
========
Bill Gee


On Wednesday, September 8, 2021 2:12:46 AM CDT Ingo Klöcker wrote:
> On Dienstag, 7. September 2021 23:35:26 CEST Bill Gee wrote:
> > Thanks for the tips!  I did have to install akonadiconsole, but that
> > took only a minute.  Running the two queries ...
> > 
> >  From the first query I got id=5.  I ran the second query like this:
> > 
> > 	SELECT * FROM pimitemtable WHERE collectionId=5;
> > 
> > And got no results.  No rows were returned.
> 
> Okay. Then I'm wondering why maildispatcher thinks it needs to retrieve some 
> messages. I need to check where else it gets information about emails to send 
> from.
> 
> > Thunderbird does not use Akonadi, but it does interact with the IMAP
> > email account.  I wonder if Thunderbird cleaned up enough stuff so that
> > Akonadi was able to get to a sane state.
> 
> I don't think that Thunderbird accesses KMail's Local Folders. Thunderbird has 
> its own set of local folders.
> 
> > In akonadiconsole, I looked in the Browser tab.  The IMAP account shows
> > up there with a size of zero.  When I expand it, the various email
> > folders appear.  Their size is not zero.  I spot-checked a couple of
> > them, and the size they show does not match what Thunderbird shows.
> > "Local Folders/Sent Mail", for example, shows 3 items, but Thunderbird
> > shows none.  I suspect Akonadi is out of sync.
> 
> All folders in Local Folders are stored on your local computer. They are 
> independent of the IMAP account. Also, Thunderbird's local folders have 
> nothing in common with KMail's local folders.
> 
> If the number of messages (Total column in akonadiconsole resp. folder tooltip 
> in KMail) in one of your IMAP folders does not match the number of messages 
> shown by Thunderbird, then KMail/Akonadi may be out of sync with your IMAP 
> account. You can try to re-sync the folder as follows:
> 
> Quit KMail (via File->Quit or Ctrl+Q).
> Start akonadiconsole and select the Browser tab.
> Select the folder you want to re-sync. 
> Right-click on the folder and choose Clear Akonadi Cache.
> Quit Akonadi Console.
> Stop Akonadi by running "akonadictl stop" in a terminal (e.g. Konsole).
> Wait a few seconds.
> Restart Akonadi with "akonadictl start".
> Start KMail and select the folder to trigger a synchronization.
> 
> Regards,
> Ingo
> 
> > On 9/7/21 4:08 PM, Ingo Klöcker wrote:
> > > On Dienstag, 7. September 2021 21:50:39 CEST Bill Gee wrote:
> > >> There are no messages in the outbox.  Both KMail and Thunderbird show
> > >> that.
> > > 
> > > Okay. I suspected that it wouldn't be that easy.
> > > 
> > >> The outbox is in "Local Folders", which I think means that it is an MBOX
> > >> store.
> > > 
> > > Actually, it's a maildir-like store, i.e. one file per email.
> > > 
> > >> When I do a directory on it, I get this:
> > >> 
> > >> [bgee@main2 ~]$ ll -Ra .local/share/local-mail/outbox/
> > >> .local/share/local-mail/outbox/:
> > >> total 20
> > >> drwxr-xr-x  5 bgee bgee 4096 May 22 13:17 .
> > >> drwxr-xr-x 12 bgee bgee 4096 May 23 14:00 ..
> > >> drwxr-xr-x  2 bgee bgee 4096 Sep  2 13:47 cur
> > >> drwxr-xr-x  2 bgee bgee 4096 Sep  3 05:54 new
> > >> drwxr-xr-x  2 bgee bgee 4096 Sep  3 05:54 tmp
> > >> 
> > >> .local/share/local-mail/outbox/cur:
> > >> total 8
> > >> drwxr-xr-x 2 bgee bgee 4096 Sep  2 13:47 .
> > >> drwxr-xr-x 5 bgee bgee 4096 May 22 13:17 ..
> > >> 
> > >> .local/share/local-mail/outbox/new:
> > >> total 8
> > >> drwxr-xr-x 2 bgee bgee 4096 Sep  3 05:54 .
> > >> drwxr-xr-x 5 bgee bgee 4096 May 22 13:17 ..
> > >> 
> > >> .local/share/local-mail/outbox/tmp:
> > >> total 8
> > >> drwxr-xr-x 2 bgee bgee 4096 Sep  3 05:54 .
> > >> drwxr-xr-x 5 bgee bgee 4096 May 22 13:17 ..
> > > 
> > > Okay. On filesystem-level the outbox folder is also empty. Then the ghost
> > > messages probably only exist in KMail's/Akonadi's database. Let's check.
> > > 
> > > Start akonadiconsole. You may have to install it first.
> > > 
> > > Select the DB Console tab. In the lower part enter
> > > select * from collectiontable where name="outbox";
> > > and then execute this query by clicking the button on the right.
> > > 
> > > In the upper part a table with a single row should be shown. Take note of
> > > the number in the first column named "id". That's the ID of the
> > > "collection" representing the outbox folder.
> > > 
> > > Now enter the following query in the lower part (removing the other query)
> > > SELECT * FROM pimitemtable WHERE collectionId=<ID>;
> > > where you replace <ID> with the ID from the result of the first query.
> > > Execute the query.
> > > 
> > > Does the query yield a result? If yes, do the IDs (in the first column) of
> > > the items in the result match the IDs in the error messages, i.e. 10411,
> > > 10412, 10413, 10415, 10416, 10417, 10418, 10420, 10421, 10422, 10423?
> > > 
> > > If yes, then let's try to get rid of those entries in the database. Enter
> > > the following query in the lower part
> > > DELETE FROM pimitemtable WHERE id=10411;
> > > Double check that you have entered the correct ID. Then execute the query.
> > > Did this work? If yes, continue with the other IDs from the error
> > > messages.
> > > 
> > > Regards,
> > > Ingo
> 
>