<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Hi Ingo -</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">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.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">For now I have switched back to KMail even though Akonadi strikes me as a very brittle part of the system.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">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.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">============</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;"><span style="font-family:Courier 10 Pitch;">org.kde.pim.akonadiserver.search: Executing search "searchUpdate-1631129500"</span></p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">org.kde.pim.akonadiserver.search: Search "searchUpdate-1631129500" done (without remote search)</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">org.kde.pim.akonadiserver.search: Search update for collection "OpenInvitations" ( 50 ) finished: all results: 0 , removed results: 0</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">org.kde.pim.akonadiserver.search: Executing search "searchUpdate-1631129500"</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">org.kde.pim.akonadiserver.search: Search "searchUpdate-1631129500" done (without remote search)</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">org.kde.pim.akonadiserver.search: Search update for collection "DeclinedInvitations" ( 51 ) finished: all results: 0 , removed results: 0</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">org.kde.pim.akonadiserver: "akonadi_maildir_resource_0" NOT Closing idle db connection; we are in transaction</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">org.kde.pim.akonadiserver: "akonadi_maildir_resource_0" NOT Closing idle db connection; we are in transaction</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">org.kde.pim.akonadiserver: ItemRetrievalJob for request 328 finished</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">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"</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">==========</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">When I look at the contents of the directory, I see this:</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">[bgee@main2 ~]$ ll .local/share/akonadi/file_db_data/15</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">total 64</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-rw-r--r-- 1 bgee bgee 7447 May 22 15:33 1115_r0</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-rw-rw-r-- 1 bgee bgee 7540 Sep 7 13:32 38915_r0</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-rw-rw-r-- 1 bgee bgee 29467 Sep 8 14:38 39315_r1</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-rw-r--r-- 1 bgee bgee 5071 May 22 15:34 4415_r0</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-rw-r--r-- 1 bgee bgee 7837 May 22 15:33 715_r0</p>
<br /><br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Regards -</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">========</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Bill Gee</p>
<br /><br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">On Wednesday, September 8, 2021 2:12:46 AM CDT Ingo Klöcker wrote:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> On Dienstag, 7. September 2021 23:35:26 CEST Bill Gee wrote:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Thanks for the tips! I did have to install akonadiconsole, but that</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > took only a minute. Running the two queries ...</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > From the first query I got id=5. I ran the second query like this:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > SELECT * FROM pimitemtable WHERE collectionId=5;</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > And got no results. No rows were returned.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Okay. Then I'm wondering why maildispatcher thinks it needs to retrieve some </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> messages. I need to check where else it gets information about emails to send </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> from.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Thunderbird does not use Akonadi, but it does interact with the IMAP</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > email account. I wonder if Thunderbird cleaned up enough stuff so that</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Akonadi was able to get to a sane state.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> I don't think that Thunderbird accesses KMail's Local Folders. Thunderbird has </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> its own set of local folders.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > In akonadiconsole, I looked in the Browser tab. The IMAP account shows</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > up there with a size of zero. When I expand it, the various email</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > folders appear. Their size is not zero. I spot-checked a couple of</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > them, and the size they show does not match what Thunderbird shows.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > "Local Folders/Sent Mail", for example, shows 3 items, but Thunderbird</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > shows none. I suspect Akonadi is out of sync.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> All folders in Local Folders are stored on your local computer. They are </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> independent of the IMAP account. Also, Thunderbird's local folders have </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> nothing in common with KMail's local folders.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> If the number of messages (Total column in akonadiconsole resp. folder tooltip </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> in KMail) in one of your IMAP folders does not match the number of messages </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> shown by Thunderbird, then KMail/Akonadi may be out of sync with your IMAP </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> account. You can try to re-sync the folder as follows:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Quit KMail (via File->Quit or Ctrl+Q).</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Start akonadiconsole and select the Browser tab.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Select the folder you want to re-sync. </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Right-click on the folder and choose Clear Akonadi Cache.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Quit Akonadi Console.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Stop Akonadi by running "akonadictl stop" in a terminal (e.g. Konsole).</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Wait a few seconds.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Restart Akonadi with "akonadictl start".</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Start KMail and select the folder to trigger a synchronization.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Regards,</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Ingo</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > On 9/7/21 4:08 PM, Ingo Klöcker wrote:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > On Dienstag, 7. September 2021 21:50:39 CEST Bill Gee wrote:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> There are no messages in the outbox. Both KMail and Thunderbird show</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> that.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Okay. I suspected that it wouldn't be that easy.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> The outbox is in "Local Folders", which I think means that it is an MBOX</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> store.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Actually, it's a maildir-like store, i.e. one file per email.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> When I do a directory on it, I get this:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> [bgee@main2 ~]$ ll -Ra .local/share/local-mail/outbox/</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> .local/share/local-mail/outbox/:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> total 20</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> drwxr-xr-x 5 bgee bgee 4096 May 22 13:17 .</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> drwxr-xr-x 12 bgee bgee 4096 May 23 14:00 ..</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> drwxr-xr-x 2 bgee bgee 4096 Sep 2 13:47 cur</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> drwxr-xr-x 2 bgee bgee 4096 Sep 3 05:54 new</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> drwxr-xr-x 2 bgee bgee 4096 Sep 3 05:54 tmp</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> .local/share/local-mail/outbox/cur:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> total 8</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> drwxr-xr-x 2 bgee bgee 4096 Sep 2 13:47 .</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> drwxr-xr-x 5 bgee bgee 4096 May 22 13:17 ..</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> .local/share/local-mail/outbox/new:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> total 8</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> drwxr-xr-x 2 bgee bgee 4096 Sep 3 05:54 .</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> drwxr-xr-x 5 bgee bgee 4096 May 22 13:17 ..</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> .local/share/local-mail/outbox/tmp:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> total 8</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> drwxr-xr-x 2 bgee bgee 4096 Sep 3 05:54 .</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > >> drwxr-xr-x 5 bgee bgee 4096 May 22 13:17 ..</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Okay. On filesystem-level the outbox folder is also empty. Then the ghost</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > messages probably only exist in KMail's/Akonadi's database. Let's check.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Start akonadiconsole. You may have to install it first.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Select the DB Console tab. In the lower part enter</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > select * from collectiontable where name="outbox";</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > and then execute this query by clicking the button on the right.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > In the upper part a table with a single row should be shown. Take note of</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > the number in the first column named "id". That's the ID of the</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > "collection" representing the outbox folder.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Now enter the following query in the lower part (removing the other query)</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > SELECT * FROM pimitemtable WHERE collectionId=<ID>;</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > where you replace <ID> with the ID from the result of the first query.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Execute the query.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Does the query yield a result? If yes, do the IDs (in the first column) of</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > the items in the result match the IDs in the error messages, i.e. 10411,</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > 10412, 10413, 10415, 10416, 10417, 10418, 10420, 10421, 10422, 10423?</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > If yes, then let's try to get rid of those entries in the database. Enter</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > the following query in the lower part</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > DELETE FROM pimitemtable WHERE id=10411;</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Double check that you have entered the correct ID. Then execute the query.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Did this work? If yes, continue with the other IDs from the error</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > messages.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Regards,</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > Ingo</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<br /><br /></body>
</html>