Hi Kevin,

On Wednesday 16 October 2013 09:17:32 Kevin Krammer wrote:
> Am Dienstag, 2013-10-15, 22:40:39 schrieb Martin Koller:
> > Hi,
> > =

> > I found in my akonadi database a lot (511) entries in pimitemtable which
> > have null values in the column remoteId. I see that most entries do hav=
e a
> > valid remoteId (which in my case are filenames of the mails in the mail=
dir
> > tree) so I wonder: is it valid to have null entries in remoteId (for
> > collections which otherwise do have the filenames there, most of them a=
re
> > the folders for mailing lists) ?
> =

> Yes, that is valid.
> Entries without remote ID are those that have been created but have not y=
et =

> been persisted by the owning resource.
> =

> Example: you create a new folder in KMail. It creates the respective Akon=
adi =

> Collection. The collection is now in Akonadi, but does not have a remote =
ID =

> just yet.
> The owning resource (maildir, IMAP, etc), gets notified about the new =

> collection. It creates the collection on its backend. It retrieves the =

> respective remote ID and modifies the entry in Akonadi accordingly.

ok, thanks for the explanation.
However, in this case, I have a _lot_ such entries which are also rather ol=
d.
The oldest ones are from July, but I find a few for every month up till tod=
ay.
I have the feeling that something is not working correctly here.

It seems that all of these mails are in collections which are targets of a =
filter
(mailing list mails), so I have the feeling that there is still a bug in th=
e filtering
code (and also I still do have duplicate mails in these folders, which some=
times disappear,
when clicking on them...)

> > Interesting is also that ALL of these have the dirty value =3D=3D 1
> =

> Right, because they currently are not "saved" yet, e.g. like a document i=
n a =

> text editor that you have started to work on but have not saved. It is al=
so =

> missing its "remote ID" (filename) until you actually save it.

which would mean - in case of an email downloaded from my POP account -
that the mail has been downloaded but not yet stored on disk ?

I have no imap account, just a POP account.

So how is the process here ? When is the mail stored on disk (in my maildir=
) and
when is the akonadi entry made ?
When does filtering kick in ?
 =

> > I checked manually the Date: header of some mails (in a folder where th=
ere
> > are just a few mails but null entries in the DB) and it seems there are=
 no
> > matching mails on disk for the entries in the database. Should I be wor=
ried
> > ? Can they harm ? Can I clean the DB from these ?
> =

> The unsaved payloads (mails) should be in Akonadi's file item location or=
, if =

> small enough, in a table in the DB.

Is that (openSuse 12.3) ~/.local/share/akonadi/file_db_data ?
In that dir I have 2810 files (all named something like 261372_r0), but onl=
y 513
entries in pimitemtable with null remoteId.
and yes, the (all?) contain mails. But again - I have files from about 22.J=
uli
until today. When shall they be moved into the maildir and deleted from her=
e ?

> If you don't need them anymore you can of course delete them, this is you=
r =

> data after all :)

I'm more interested in finding out WHY they are not in my maildir.

> =

> > Is there somewhere documentation about the purpose of the tables (which
> > seems to be not so hard to guess) and the columns of the database table=
s ?
> =

> Maybe in the file the Database schema is generated from.
> Some XML file IIRC.

yup, I found that already, but the comments in there are sparse ...

-- =

Best regards/Sch=F6ne Gr=FC=DFe

Martin
A: Because it breaks the logical sequence of discussion
Q: Why is top posting bad?

()  ascii ribbon campaign - against html e-mail =

/\  www.asciiribbon.org   - against proprietary attachments

Geschenkideen, Accessoires, Seifen, Kulinarisches: www.bibibest.at

>> Visit http://mail.kde.org/mailman/listinfo/kde-devel#unsub to unsubscrib=
e <<