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.
