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

[T.C.Berner]

Hi

Thanks; I ran "select * from PimItemTable where remoteid is null or dirty =
true;" but it did return an empty list.

mfg Tobias

2016-04-30 17:11 GMT+02:00 Sandro Knauß <sknauss at kde.org>:

> 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/