https://bugs.kde.org/show_bug.cgi?id=406856
--- Comment #1 from Nick <ndor...@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.
