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

[Nick]

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 at kde.org
          Reporter: ndordea at 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 at 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.