[Kde-pim] an item is many times present in the akonadi database

[Guy Maurel]

On Wednesday, October 01, 2014 09:08:00 AM Kevin Krammer wrote:
> On Thursday, 2014-09-25, 18:43:36, Guy Maurel wrote:
> > Hello !
> > 
> > I found an item which is many times present in the akonadi database.
> > Connecting direct to the database I found it over 3000 times, with
> > differents "datetime":
> > 
> > MariaDB [akonadi]> select id,remoteId,gid,datetime,atime from pimitemtable
> > where remoteId="1394122158.R643.renard:2,S" order by datetime;
> > +-------+----------------------------+------------------------------------
> > -- ------+---------------------+---------------------+
> > 
> > | id    | remoteId                   | gid
> > | datetime            | atime               |
> > 
> > +-------+----------------------------+------------------------------------
> > -- ------+---------------------+---------------------+
> > 
> > | 58233 | 1394122158.R643.renard:2,S |
> > 
> > <20140305185305.30662.50287 at probe.kde.org> | 2014-04-17 15:44:24 |
> > 2014-09-25 18:06:31 |
> > 
> > | 58274 | 1394122158.R643.renard:2,S |
> > 
> > <20140305185305.30662.50287 at probe.kde.org> | 2014-04-18 15:31:27 |
> > 2014-09-25 18:06:31 |
> > 
> > | 58315 | 1394122158.R643.renard:2,S |
> > 
> > <20140305185305.30662.50287 at probe.kde.org> | 2014-04-18 15:31:45 |
> > 2014-09-25 18:06:31 |
> > 
> > Any help?
> > Thanks
> 
> Since the item ID is different these are different items.
> It is of course strange that the maildir  filename is the same, most likely
> copies of the same, e.g. a move not having deleted the original.
> 
> Do these items have different parent collections?
> Which resource is that?
all the items have the same collectionId 394

select * from collectiontable where id=394;
+_id__+_remoteId__________________+_remoteRevision___+_name_____________________+_parentId_+_resourceId
+394_+_Kde_pim_Review_Request_+_1412181883000__+_Kde_pim_Review_Request_+_245______+_3 

Kde_pim_Review_Request is a folder

Having a look over some more items, we can see that the "datetime" are 
different ( I supress some duplicates)
2014-04-17 15:44
2014-04-18 15:31
2014-04-18 16:39
2014-04-19 07:58
2014-04-19 08:15
2014-04-19 17:10
2014-04-19 18:00
2014-04-19 18:01
2014-04-19 18:16
2014-04-20 15:24
2014-04-20 16:01
2014-04-21 17:33
2014-04-21 17:34
2014-04-22 17:33
2014-04-23 14:34
2014-04-23 14:35
2014-04-23 15:43
2014-04-23 16:05
2014-04-23 16:59
2014-04-23 17:22

searching the file, I found two
locate 1394122158.R643.renard:2,S
/home/guy/.local/share/local-mail/.Programmieren.directory/Kde-
pim_Review_Request/cur/1394122158.R643.renard:2,S
/home/guy/.local/share/local-mail/.Programmieren.directory/Kde-
pim_Review_Request/new/1394122158.R643.renard:2,S

the full-time are little different

ls  --full-time /home/guy/.local/share/local-
mail/.Programmieren.directory/Kde-
pim_Review_Request/cur/1394122158.R643.renard\:2\,S 
-rw-r--r-- 1 guy users 5254 2014-03-06 17:09:18.366882018 +0100 
/home/guy/.local/share/local-mail/.Programmieren.directory/Kde-
pim_Review_Request/cur/1394122158.R643.renard:2,S

ls  --full-time /home/guy/.local/share/local-
mail/.Programmieren.directory/Kde-
pim_Review_Request/new/1394122158.R643.renard\:2\,S 
-rw-r--r-- 1 guy users 4657 2014-03-06 17:09:18.853549939 +0100 
/home/guy/.local/share/local-mail/.Programmieren.directory/Kde-
pim_Review_Request/new/1394122158.R643.renard:2,S

Where to look after? what?
Thanks
-- 
Guy Maurel
_______________________________________________
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/