[Akonadi] [Bug 406856] Found 3734 items without RID.; Item "30024" has RID and is dirty.

[Nick]

https://bugs.kde.org/show_bug.cgi?id=406856

--- Comment #1 from Nick <ndordea at gmail.com> ---
I did a little bit of work with akonadi database and realized that all items
with remoteId null are in pimitemtable with references to parttable and
pimitemflagrelation ,
I got to akonadi database via sokket then issued the commands :

select "akonadi database status of NULL RemoteId  before clean up ";
 select count(*) from akonadi.pimitemtable where remoteId is NULL ;
 select count(*) from akonadi.parttable where pimItemId in ( select id from
pimitemtable where remoteId is null ) ;
 select count(*) from akonadi.pimitemflagrelation where PimItem_id  in ( select
id from pimitemtable where remoteId is null ) ;

 --  
 delete from akonadi.pimitemflagrelation where PimItem_id  in ( select id from
pimitemtable where remoteId is null ) ;
 delete from akonadi.parttable where pimItemId in ( select id from pimitemtable
where remoteId is null ) ;
 delete from akonadi.pimitemtable where remoteId is NULL ;
 --
 select "akonadi database status of NULL RemoteId  after clean up ";
 select count(*) from akonadi.pimitemtable where remoteId is NULL ;
 select count(*) from akonadi.parttable where pimItemId in ( select id from
pimitemtable where remoteId is null ) ;
 select count(*) from akonadi.pimitemflagrelation where PimItem_id  in ( select
id from pimitemtable where remoteId is null ) ;

After that the akonadictl fsck appears clean .

-- 
You are receiving this mail because:
You are the assignee for the bug.