[Kde-pim] multiple remoteIds in pimitemtable ?

[Martin Koller]

On Sunday 20 October 2013 18:04:08 Martin Koller wrote:
> Hi,
> 
> I'm continuing my akonadi quest ...
> 
And now I see something which I asked in the mail thread "pimitemtable with null remoteId ?" a few days ago:

I find the mail I'm replying to TWO TIMES in my KDE-PIM maildir folder. Checking akonadi tables:

mysql> select id,pimitemid,name from parttable where data like "%multiple remoteIds%";
+--------+-----------+--------------+
| id     | pimitemid | name         |
+--------+-----------+--------------+
| 298236 |    129385 | PLD:ENVELOPE |
| 298244 |    129386 | PLD:HEAD     |
| 298245 |    129386 | PLD:ENVELOPE |
| 298248 |    129387 | PLD:HEAD     |
| 298249 |    129387 | PLD:ENVELOPE |
+--------+-----------+--------------+
5 rows in set (0.33 sec)


mysql> select * from pimitemtable where id=129386 or id=129387;
+--------+-----+-------------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+------+
| id     | rev | remoteId                            | remoteRevision | collectionId | mimeTypeId | datetime            | atime               | dirty | size |
+--------+-----+-------------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+------+
| 129386 |   2 | NULL                                | NULL           |          228 |          2 | 2013-10-20 16:45:29 | 2013-10-20 19:02:25 |     1 | 9145 |
| 129387 |   4 | 1382285930.R533.linux-d4d3.site:2,S | NULL           |          228 |          2 | 2013-10-20 16:45:26 | 2013-10-20 19:02:24 |     0 | 9095 |
+--------+-----+-------------------------------------+----------------+--------------+------------+---------------------+---------------------+-------+------+
2 rows in set (0.00 sec)

Why does this mail exist TWICE in pimitemtable and why does it still have a NULL remoteId ?

Kevin said that an entry has a NULL remoteId until it is given the correct one (when it's stored on disk).
So now I do have the mail on disk and it has got a remoteId. Then why are there still 2 records ?
Shouldn't the first one simply be updated with the remoteId instead of the creation of a second record ?
Interesting here is also that the datetime field of the NULL remoteId is YOUNGER than the one with the correct remoteId.

When is the datetime field updated ?
When is atime updated ?

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