New search backend issues unrecognized option "contentless_delete" on Debian 12

Wweini · Dec 14, 2024

Following the steps documented in the announcement thread for the new search backend, I run into an error:

Dez 14 10:11:20 server systemd[1]: Starting grommunio-index.service - Fulltext search index regeneration...
Dez 14 10:11:20 server grommunio-index[2645012]: [2024-12-14T10:11:20] /usr/bin/grommunio-index /var/lib/gromox/user/4/3 -e ::1 -o /var/lib/grommunio-w>
Dez 14 10:11:20 server grommunio-index[2645012]: [WARNING] SQLite query failed: 1(unrecognized option: "contentless_delete")
Dez 14 10:11:20 server grommunio-index[2645012]: [FATAL] Failed to initialize index database: unrecognized option: "contentless_delete"
Dez 14 10:11:20 server grommunio-index[2645012]:         ... exited with status 2
Dez 14 10:11:20 server systemd[1]: grommunio-index.service: Main process exited, code=exited, status=1/FAILURE
Dez 14 10:11:20 server systemd[1]: grommunio-index.service: Failed with result 'exit-code'.
Dez 14 10:11:20 server systemd[1]: Failed to start grommunio-index.service - Fulltext search index regeneration.

I´m running an up-to-date Debian 12 with sqlite version 3.40:

root@nas2:/var/lib/grommunio-web/sqlite-index# dpkg -l "sqlite3" | cat
Gewünscht=Unbekannt/Installieren/R=Entfernen/P=Vollständig Löschen/Halten
| Status=Nicht/Installiert/Config/U=Entpackt/halb konFiguriert/
         Halb installiert/Trigger erWartet/Trigger anhängig
|/ Fehler?=(kein)/R=Neuinstallation notwendig (Status, Fehler: GROSS=schlecht)
||/ Name           Version          Architektur  Beschreibung
+++-==============-================-============-===================================
ii  sqlite3        3.40.1-2+deb12u1 amd64        Command line interface for SQLite 3

Currently, I would not recommend to upgrade to gromunio-index 1.0.25 on Debian.
Any help / hint is appreciated. Please let me know if I can provide further logs / debug output.

Ssegro · Dec 14, 2024

sadly, the same error on EL9 after upgrade, remove and try to reindex.

[root@mail ~]# systemctl stop grommunio-index grommunio-index.timer
[root@mail ~]# rm -rf /var/lib/grommunio-web/sqlite-index/*
[root@mail ~]# systemctl start grommunio-index grommunio-index.timer
Job for grommunio-index.service failed because the control process exited with error code.
See "systemctl status grommunio-index.service" and "journalctl -xeu grommunio-index.service" for details.
[root@mail ~]# journalctl -xeu grommunio-index.service
Dec 14 10:21:46 mail grommunio-index[836]: [FATAL] Failed to initialize index database: unrecognized option: "contentless_delete"
Dec 14 10:21:46 mail grommunio-index[836]:         ... exited with status 2
Dec 14 10:21:46 mail grommunio-index[836]: [2024-12-14T10:21:46] /usr/bin/grommunio-index /var/lib/gromox/user/2/1 -e ::1 -o /var>
Dec 14 10:21:46 mail grommunio-index[836]: [WARNING] SQLite query failed: 1(unrecognized option: "contentless_delete")
Dec 14 10:21:46 mail grommunio-index[836]: [FATAL] Failed to initialize index database: unrecognized option: "contentless_delete"
Dec 14 10:21:46 mail grommunio-index[836]:         ... exited with status 2
Dec 14 10:21:46 mail grommunio-index[836]: [2024-12-14T10:21:46] /usr/bin/grommunio-index /var/lib/gromox/user/0/3 -e ::1 -o /var>
Dec 14 10:21:46 mail grommunio-index[836]: [WARNING] SQLite query failed: 1(unrecognized option: "contentless_delete")
Dec 14 10:21:46 mail grommunio-index[836]: [FATAL] Failed to initialize index database: unrecognized option: "contentless_delete"
Dec 14 10:21:46 mail grommunio-index[836]:         ... exited with status 2
Dec 14 10:21:46 mail grommunio-index[836]: [2024-12-14T10:21:46] /usr/bin/grommunio-index /var/lib/gromox/user/3/0 -e ::1 -o /var>
Dec 14 10:21:47 mail grommunio-index[836]: [WARNING] SQLite query failed: 1(unrecognized option: "contentless_delete")
Dec 14 10:21:47 mail grommunio-index[836]: [FATAL] Failed to initialize index database: unrecognized option: "contentless_delete"
Dec 14 10:21:47 mail grommunio-index[836]:         ... exited with status 2
Dec 14 10:21:47 mail systemd[1]: grommunio-index.service: Main process exited, code=exited, status=1/FAILURE

Wweini · Dec 22, 2024

grommunio-index 1.2.1 is now available and it seems to fix the issue.
Please tag this as sloved.

At first sight, I´m even able to receive proper search results with Outook in non-cached mode, at least when searching for emails. But if I search the calendar, I still face the nasty issue that the search result list first gets built up and then disappears at the moment when the search is complete.