https://bugs.kde.org/show_bug.cgi?id=406856
Bug ID: 406856 Summary: Found 3734 items without RID.; Item "30024" has RID and is dirty. Product: Akonadi Version: 5.7.3 Platform: openSUSE RPMs OS: Linux Status: REPORTED Severity: normal Priority: NOR Component: libakonadi Assignee: kdepim-bugs@kde.org Reporter: ndor...@gmail.com Target Milestone: --- SUMMARY After switching to IMAP akonadi fsck reports thousands of messages `Item "....." has no RID.` as well as that one item is dirty . Is there any procedure to clean up the akonadi mysql data base to get rid of those messagews ? It seems that akonadi handles the connection to mysql . How a user can access akonadi mysql database and run any solutions KDE team suggets ? STEPS TO REPRODUCE 1. at will wunning akonadictl fsck 2. 3. OBSERVED RESULT Thousand of Item "....." has no RID. messages Found 3734 items without RID. Item "30024" has RID and is dirty. Found 1 dirty items. EXPECTED RESULT No such messages SOFTWARE/OS VERSIONS Linux/KDE Plasma: leap 15.0 (available in About System) KDE Plasma Version: 5.12.8 KDE Frameworks Version: 5.45.0 Qt Version: ? ADDITIONAL INFORMATION [akonadi fsck/vacuum/status output ] 2019/04/23-18:39:42 ; Start /Common_Bin/akonadi_utils.sh akonadictl fsck Looking for resources in the DB not matching a configured resource... Looking for collections not belonging to a valid resource... Checking collection tree consistency... Looking for items not belonging to a valid collection... Looking for item parts not belonging to a valid item... Looking for item flags not belonging to a valid item... Looking for overlapping external parts... Verifying external parts... Found 5906 external files. Found 5906 external parts. Found no unreferenced external files. Checking size treshold changes... Found 0 parts to be moved to external files Found 0 parts to be moved to database Looking for dirty objects... Collection "Search" (id: 1) has no RID. Collection "OpenInvitations" (id: 151) has no RID. Collection "DeclinedInvitations" (id: 152) has no RID. Collection "Import_from_archive" (id: 160) has no RID. Found 4 collections without RID. Item "28761" has no RID. ..... Item "33803" has no RID. Item "33804" has no RID. Item "38264" has no RID. Found 3734 items without RID. Item "30024" has RID and is dirty. Found 1 dirty items. Looking for rid-duplicates not matching the content mime-type of the parent collection Checking Local Folders Checking Notes Checking Personal Calendar Checking Search Checking ndordea@IMAP Checking DeclinedInvitations Checking OpenInvitations Checking Alarm_Templates ..... Migrating parts to new cache hierarchy... Checking search index consistency... Skipping virtual Collection 1 Checking Collection 2 search index... Checking Collection 3 search index... Checking Collection 4 search index... ..... Checking Collection 150 search index... Skipping virtual Collection 151 Skipping virtual Collection 152 Checking Collection 153 search index... .... Checking Collection 255 search index... Flushing collection statistics memory cache... Consistency check done. akonadictl vacuum vacuuming database, that'll take some time and require a lot of temporary disk space... optimizing table SchemaVersionTable... optimizing table ResourceTable... optimizing table CollectionTable... optimizing table MimeTypeTable... optimizing table PimItemTable... optimizing table FlagTable... optimizing table PartTypeTable... optimizing table PartTable... optimizing table CollectionAttributeTable... optimizing table TagTypeTable... optimizing table TagTable... optimizing table TagAttributeTable... optimizing table TagRemoteIdResourceRelationTable... optimizing table RelationTypeTable... optimizing table RelationTable... optimizing table PimItemFlagRelation... optimizing table PimItemTagRelation... optimizing table CollectionMimeTypeRelation... optimizing table CollectionPimItemRelation... vacuum done akonadictl status Akonadi Control: running Akonadi Server: running Akonadi Server Search Support: available (Remote Search) Available Agent Types: akonadi_akonotes_resource, akonadi_archivemail_agent, akonadi_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, akonadi_ews_resource, akonadi_ewsmta_resource, akonadi_facebook_resource, akonadi_followupreminder_agent, akonadi_googlecalendar_resource, akonadi_googlecontacts_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent, akonadi_invitations_agent, akonadi_kalarm_dir_resource, akonadi_kalarm_resource, akonadi_knut_resource, akonadi_kolab_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent, akonadi_mailfilter_agent, akonadi_mbox_resource, akonadi_migration_agent, akonadi_mixedmaildir_resource, akonadi_newmailnotifier_agent, akonadi_notes_agent, akonadi_notes_resource, akonadi_openxchange_resource, akonadi_pop3_resource, akonadi_sendlater_agent, akonadi_tomboynotes_resource, akonadi_vcard_resource, akonadi_vcarddir_resource 2019/04/23-18:40:06 ; /Common_Bin/akonadi_utils.sh ... has completed . -- You are receiving this mail because: You are the assignee for the bug.