[Akonadi] [Bug 451620] New: akonadictl; sqlite: Error moving orphan items to collection 242 : Expression tree is too large (maximum depth 1000)

[Erik Quaeghebeur]

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-bugs at kde.org
          Reporter: bugs.kde.org at 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 the assignee for the bug.