https://bugs.kde.org/show_bug.cgi?id=451620
Bug ID: 451620
Summary: akonadictl; sqlite: Error moving orphan items to
collection 242 : Expression tree is too large (maximum
depth 1000)
Product: Akonadi
Version: 5.18.3
Platform: Gentoo Packages
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: general
Assignee: kdepim-b...@kde.org
Reporter: bugs.kde....@e3q.eu
Target Milestone: ---
SUMMARY
I use akonadi with the sqlite backend. Running akonadictl results in an error
that seems to result from akonadi giving sqlite a query that is too long:
---
$ akonadictl fsck
[…]
Checking collection tree consistency...
Looking for items not belonging to a valid collection...
Found 110689 orphan items.
Error moving orphan items to collection 242 : Expression tree is too large
(maximum depth 1000) Kon statement niet uitvoeren
[…]
---
("Kon statement niet uitvoeren" means "Could not execute statement")
STEPS TO REPRODUCE
1. run akonadictl fsck again
OBSERVED RESULT
Error moving orphan items to collection 242 : Expression tree is too large
(maximum depth 1000) Kon statement niet uitvoeren
EXPECTED RESULT
orphans are cleaned up
SOFTWARE/OS VERSIONS
KDE Plasma Version: 5.23.5
KDE Frameworks Version: 5.90.0
Qt Version: 5.15.2 (with https://community.kde.org/Qt5PatchCollection)
ADDITIONAL INFORMATION
I think this is sqlite-specific, given some search results on the web
--
You are receiving this mail because:
You are watching all bug changes.
