Bug 472694

Summary: 'Failed to query database for item' error message when updating ical resource
Product: [Frameworks and Libraries] Akonadi Reporter: Tamás Pesti <ptamas2002>
Component: ICal file resourceAssignee: kdepim bugs <kdepim-bugs>
Status: REPORTED ---    
Severity: normal CC: carl
Priority: NOR    
Version: 5.24.0   
Target Milestone: ---   
Platform: Arch Linux   
OS: Linux   
Latest Commit: Version Fixed In:
Attachments: Zip file containing the attachments (2 ics files and 2 log files)

Description Tamás Pesti 2023-07-27 11:14:20 UTC
Created attachment 160562 [details]
Zip file containing the attachments (2 ics files and 2 log files)

SUMMARY
***
Akonadi gives me 'AgentBase(akonadi_ical_resource_17): Failed to query database for item' error message in the debugger's information view when I try to upgrade an iCal Calendar File resource.
***

STEPS TO REPRODUCE
1. Create an ics file and fill it with the content of 'akonadi-ical-debug-working.ics' attachment
2. Open Akonadi Console and create a new agent:
    - Type: iCal Calendar File
    - File Name: <path of the created file>
    - Display Name: Debug
    - Tick 'Read only'
    - Untick 'File monitoring'
3. The debugger shows no error (output is in 'log-messages-first.txt')
4. Replace ics file with the content of 'akonadi-ical-debug-failing.ics' attachment
5. Restart the agent in the Akonadi Console
6. Debugger shows error 'Failed to query database for item' (output is in 'log-messages-fail.txt')

OBSERVED RESULT
The resource did not upgrade it's content (the last ical node was not added).

EXPECTED RESULT
Akonadi Console should upgrade the calendar resource's entire database with the new data read from the ics file.

SOFTWARE/OS VERSIONS
KDE Plasma Version: 5.27.6
KDE Frameworks Version: 5.108.0
Qt Version: 5.15.10
Comment 1 Tamás Pesti 2023-08-29 10:01:24 UTC
Still an issue:
Akonadi Console version: 5.24.0 (23.08.0)
KDE Plasma version: 5.27.7
KDE Framework version: 5.109.0
Qt version: 5.15.10