[Kde-pim] Akonadi keeps re-downloading gigabytes of mail, and other problems

[Sandro Knauß]

Hi,

I also had this problem, that akonadi was dowloading my Sent folder over and 
over again the last days. I fixed it with the deletion of dangling items (items 
that only exist in akonadi). For me there were two items without a remoteId, 
that triggered the resync everytime. The creation of the dangling items 
happend, when my laptop crashed hard with a kernel panic, and left akonadi no 
time to save anything...

Okay here how to search for dangling items:

akonadiconsole -> Db Console

enter at the lower part the SQL statement and hit button on the right to 
execute:
Select * from PimItemTable Where remoteId is NULL or dirty = 1;

If this list is not empty after a complete sync (Sync all folders), than it is 
very likely that these items are the reason for the resync.

remoteId NULL means a new item was created in akonadi and not yet synced to 
remote

dirty=1 tells akoandi that this item was changed by akonadi and is not yet 
synced to remote.

But let's look together to your list of dangling items...

Regards,

sandro

--
Am Samstag, 30. April 2016, 14:58:25 CEST schrieb T.C.Berner:
> Hi
> 
> Nope, that is not what I see. -- and its not a rare issue, it's the norm
> here.
> kdepim-kf5 is unusable for me.
> 
> 
> As mentioned before in IRC, folders with < 1000 mails work fine (by that I
> mean, that the
> message list at least loads the message entries. If the message text gets
> displayed is
> another coin-toss).
> 
> Folders with >= 1000 mails seem to have reproducible issues, and get
> constantly
> refetched. The issue is, that the last few messages seem to be missing all
> the
>  time (a folder with 2847 has only 2800, one with 5582 only 5500).
> 
> What I see is
> ===
> [...]
> akonadicore_log: Received:  100 In total:  5400  Wanted:  5582
> akonadicore_log: Received:  100 In total:  5500  Wanted:  5582
> akonadicore_log: Received:  82 In total:  5582  Wanted:  5582
> akonadicore_log: Invalid command, the world is going to end!
> akonadicore_log: connectToServer
> "/tmp/akonadi-Tobias.MkG1rh/akonadiserver.socket"
> akonadicore_log: "Cannot connect to the Akonadi service."
> Shutting down "akonadi_imap_resource_9" ...
> Database "akonadi" opened using driver "QPSQL"
> Invalid command: no such handler for Transaction
> akonadicore_log: Connected to "Akonadi" , using protocol version 53
> akonadicore_log: Server says: "Not Really IMAP server"
> [...]
> ===
> 
> [Note, this happens with any db-backend, be it MYSQL or SQLITE, so it is not
> related to QPSQL].
> 
> 
> 
> Any ideas on how to fix/debug this are welcome.
> 
> 
> mfg Tobias

_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/