Bug 494249

SUMMARY

Akonadi ICal directory resource does not pick up existing files inside a calendar directory when switching database or adding the resource with an existing directory.

STEPS TO REPRODUCE

I believe the following should be enough:

1. Add icaldir resource using an existing directory with valid ical files. 

OBSERVED RESULT

I switched Akonadi from PostgreSQL to SQLite3 by moving the old database out of the way, making sure only SQLite3 backend is installed, deleting akonadiserverrc and starting Akonadi again. Akonadi picked up all the mails from the existing maildir resource. Akonadi picked up all the contacts. However calendar directory resource was not even displayed initially. I opened KOrganizer settings and found the icaldir resource there. After saving the settings there the ical dir resource "Kalenderordner" (calendar folder) was displayed but not activated. I activated it. Calendar was empty. I enabled all logging with

`QT_LOGGING_RULES="*.*=true;qt.*=false" akonadictl restart`

and got:

org.kde.pim.akonadiagentbase: Sending dbus reply for method "" with error 
"Ungültigen Eintrag erhalten"

"Ungültigen Eintrag erhalten" => received invalid entry

Odd is that the method is ""

org.kde.pim.akonadiserver: ItemRetrievalJob for request 295 finished with 
error: "Unable to retrieve item from resource: Ungültigen Eintrag 
erhalten"

a lot of times.

I then removed the icaldir resource and added it again with the same directory. Same result.

Akonadiconsole also showed no entries, but revealed that the resource has 5630 items.

Finally I emptied the directory and re-imported all ical files with

% calendar-2024-10-07> ls -1 | xargs -n1 konsolekalendar --calendar 446 --import

from a backup, into the right calendar resource as displayed by konsolekalendar --list-calendars

Took quite a while but it mostly worked. I saw one error, maybe there are a few others. I intend to review those at some point, but a quick check showed that appointments I expect are where they should be.

On a subsequent run of akonadictl fsck I got:

% akonadictl fsck
 1/19 Looking for collections not belonging to a valid resource...
 2/19 Checking collection tree consistency...
 3/19 Looking for items not belonging to a valid collection...
Found 5630 orphan items.
Moved orphan items to collection 456
[…]

I am not sure whether that was due to me removing the old resource and re-adding it or whether this was due to the database switch. But I am pretty sure that 5630 refers 5630 calendar events. Not sure how I can view this collection 456 as it is not listed in konsolekalendar --list-calendars and I am not sure how to access it in Akonadiconsole.

EXPECTED RESULT

As maildir resource, as contacts resource I expect icaldir resource to pick up valid existing files inside a calendar directory. Remembering that Akonadi is *mostly* just a cache. Ignoring those files could lead to silent data loss issues.

SOFTWARE/OS VERSIONS

Linux/KDE Plasma: Devuan Ceres (based on Debian unstable) with KDEPIM 24.08 packages from experimental
KDE Plasma Version: 6.1.5
KDE Frameworks Version: 6.6.0
Qt Version: 6.7.2

ADDITIONAL INFORMATION

I took the version number from KMail which is 6.2.0. I am not sure how to find the akonadi_icaldir_resource version number specifically.