[Kde-pim] trying to understand akonadi

Martin Koller kollix at aon.at
Wed Oct 16 18:47:00 BST 2013


Hi,

I have a problem with kmail (4.11.2) where my mbox resource (which is filled from an external program)
often shows a mail with subject/sender/date:Unknown.

Currently I have such a mail and I try to find out what's going on in akonadi.
This mbox file has a few other mails (e.g. grep ^Date: finds 4 lines), but only 1 is shown
(I assume the others are already marked/stored internally by the mbox resource as deleted, which is fine).
The one shown is the "unknown" problem.

In akonadi I find:

select * from pimitemtable where collectionId=413;
+--------+-----+----------------------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
| id     | rev | remoteId                                     | remoteRevision | collectionId | mimeTypeId | datetime            | atime               | dirty | size  |
+--------+-----+----------------------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
| 128101 |   0 | 413::file:///home/koller/airsync.mbox::41642 | NULL           |          413 |          2 | 2013-10-16 17:40:23 | 2013-10-16 17:40:23 |     0 | 13585 |
+--------+-----+----------------------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+-------+
1 row in set (0.00 sec)

so yes, this is the mail I should see. (I checked the mentioned mbox file and starting at byte 41642 I find a new mail)

select * from parttable where pimItemId=128101;
+--------+-----------+--------------+-----------------------------------------------+----------+---------+----------+
| id     | pimItemId | name         | data                                          | datasize | version | external |
+--------+-----------+--------------+-----------------------------------------------+----------+---------+----------+
| 293642 |    128101 | PLD:ENVELOPE | (NIL NIL NIL NIL NIL NIL NIL NIL NIL NIL NIL) |       45 |       1 |        0 |
| 293641 |    128101 | PLD:HEAD     | 
                                             |        1 |       1 |        0 |
+--------+-----------+--------------+-----------------------------------------------+----------+---------+----------+
2 rows in set (0.00 sec)

I have no idea what this columns shall contain, but checking some other entries shows that the
PLD:ENVELOPE record should contain something useful in the data field (Date, subject, etc.).
So this situation would explain why I see "unknown" as the data holds "NIL ..."

Any idea why this can happen ?
Who fills that fiels and when ?

-- 
Best regards/Schöne Grüße

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



More information about the kde-pim mailing list