KMail and Akonadi throwing thousands of errors

[John White]

On Wednesday, September 8, 2021 12:12:46 AM PDT 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
> 
Fascinating discussion.  I wonder, Ingo, if something like this re-sync 
procedure might help me with my Pop-3 problem (Kmail fairly regularly shows 
messages read weeks ago as unread).

John