• SolvedFixed
  • "An unexpected error has occurred" Grommunio Web Search

Joerg
On a new install with the same iso (also migrated from Kopano) i also get search index errors in http log like:

sqlite3_exec(/var/lib/gromox/user/6/5/exmdb/exchange.sqlite3) "INSERT INTO search_result VALUES (868, 196872)": UNIQUE constraint failed: search_result.folder_id, search_result.message_id (19)

and on zcore log:
exmdb_client_do_rpc(/var/lib/gromox/user/6/5): Dispatch error/Request rejected/DB error (check gromox-http log)

rg
Christian

    After installing and before importing the first user, did you reboot the system?
    If not, reboot now and try again.

    If the problem still exists, check for errors in http logs with: tail /var/log/nginx/*.log -f

      externa1
      I have no errors in the zcore log.
      Do you also "only" have problems with the search, or is something else not working?

        WalterH
        After the installation, before importing the first user, I did not reboot the system. However, I deleted the imported user in the meantime, created it again and then rebooted and imported it again.
        Now I have just rebooted the system again. -> The error persists.
        Here is the output of 'tail /var/log/nginx/*.log -f'
        _==> /var/log/nginx/error.log <==
        2024/01/06 20:29:10 [emerg] 11886#11886: "vhost_traffic_status_filter_by_host" directive is duplicate in /usr/share/grommunio-common/nginx/traffic_status_params.conf:1
        2024/01/07 09:32:37 [emerg] 27854#27854: "vhost_traffic_status_filter_by_host" directive is duplicate in /usr/share/grommunio-common/nginx/traffic_status_params.conf:1
        2024/01/12 00:00:06 [notice] 14976#14976: signal process started

        ==> /var/log/nginx/nginx-access.log <==
        192.168.10.232 - - [12/Jan/2024:08:27:06 +0100] "GET /web/client/resources/fonts/roboto-400-greek.woff2 HTTP/2.0" 304 0 "https://webmail.xxxxx-xxxxx.ch/web/client/resources/css/grommunio.css?version=3.6.11.46554f3e-lp155.13.2" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:08:27:06 +0100] "GET /web/client/resources/fonts/roboto-400-cyrillic.woff2 HTTP/2.0" 304 0 "https://webmail.xxxxx-xxxxx.ch/web/client/resources/css/grommunio.css?version=3.6.11.46554f3e-lp155.13.2" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:08:27:07 +0100] "GET /web/client/resources/fonts/roboto-400-vietnamese.woff2 HTTP/2.0" 304 0 "https://webmail.xxxxx-xxxxx.ch/web/client/resources/css/grommunio.css?version=3.6.11.46554f3e-lp155.13.2" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.252 - - [12/Jan/2024:09:23:33 +0100] "GET / HTTP/1.1" 301 162 "-" "Go-http-client/1.1"
        192.168.10.252 - - [12/Jan/2024:14:17:59 +0100] "GET /web/client/resources/fonts/roboto-400-latin.woff2 HTTP/1.1" 200 15744 "https://webmail.xxxxx-xxxxx.ch/web/client/resources/css/grommunio.css?version=3.6.11.46554f3e-lp155.13.2" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:121.0) Gecko/20100101 Firefox/121.0"
        192.168.10.232 - - [12/Jan/2024:15:33:54 +0100] "GET / HTTP/1.1" 301 169 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:33:58 +0100] "GET / HTTP/2.0" 301 162 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:07 +0100] "GET /web/client/resources/fonts/roboto-400-latin.woff2 HTTP/2.0" 200 15744 "https://192.168.10.238/web/client/resources/css/grommunio.css?version=3.6.11.46554f3e-lp155.13.2" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:08 +0100] "GET /web/client/resources/fonts/roboto-700-latin.woff2 HTTP/2.0" 200 15860 "https://192.168.10.238/web/client/resources/css/grommunio.css?version=3.6.11.46554f3e-lp155.13.2" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:08 +0100] "GET /web/client/resources/fonts/roboto-400-italic-latin.woff2 HTTP/2.0" 200 17368 "https://192.168.10.238/web/client/resources/css/grommunio.css?version=3.6.11.46554f3e-lp155.13.2" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"

        ==> /var/log/nginx/nginx-admin-access.log <==
        192.168.10.232 - - [12/Jan/2024:15:34:28 +0100] "GET /static/media/grommunio_logo_default.d767b4c136a6516bb8b1a8d1788710c7.svg HTTP/1.1" 304 0 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:29 +0100] "POST /api/v1/login HTTP/1.1" 200 842 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:29 +0100] "GET /api/v1/profile HTTP/1.1" 200 512 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:29 +0100] "GET /api/v1/domains?domainType=0&sort=domainname,asc HTTP/1.1" 200 252 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:29 +0100] "GET /static/media/grommunio_logo_light.78682100f2afaef070c9e51af9608dbb.svg HTTP/1.1" 304 0 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:29 +0100] "GET /api/v1/system/license HTTP/1.1" 200 140 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:29 +0100] "GET /static/js/8119.10303601.chunk.js HTTP/1.1" 304 0 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:30 +0100] "GET /api/v1/system/logs?sort=name,asc HTTP/1.1" 200 195 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:33 +0100] "GET /api/v1/system/logs/Gromox%20event?n=20 HTTP/1.1" 200 1249 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:34:37 +0100] "GET /api/v1/system/logs/Gromox%20http?n=20 HTTP/1.1" 200 2704 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"

        ==> /var/log/nginx/nginx-admin-error.log <==

        ==> /var/log/nginx/nginx-autodiscover-access.log <==

        ==> /var/log/nginx/nginx-autodiscover-error.log <==

        ==> /var/log/nginx/nginx-dav-access.log <==

        ==> /var/log/nginx/nginx-dav-error.log <==

        ==> /var/log/nginx/nginx-error.log <==
        2024/01/07 10:38:30 [error] 12197#12197: *520 open() "/usr/share/grommunio-web/fingerprint.js.map" failed (2: No such file or directory), client: 192.168.10.252, server: _, request: "GET /web/fingerprint.js.map HTTP/1.1", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/07 10:38:30 [error] 12197#12197: *524 open() "/usr/share/grommunio-web/plugins/files/php/files.js.map" failed (2: No such file or directory), client: 192.168.10.252, server: _, request: "GET /web/plugins/files/php/files.js.map HTTP/1.1", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/07 10:38:30 [error] 12197#12197: *524 open() "/usr/share/grommunio-web/resize.js.map" failed (2: No such file or directory), client: 192.168.10.252, server: _, request: "GET /web/resize.js.map HTTP/1.1", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/07 14:46:30 [error] 12197#12197: *19672 open() "/usr/share/grommunio-web/fingerprint.js.map" failed (2: No such file or directory), client: 192.168.10.252, server: _, request: "GET /web/fingerprint.js.map HTTP/1.1", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/07 14:46:30 [error] 12197#12197: *19676 open() "/usr/share/grommunio-web/plugins/files/php/files.js.map" failed (2: No such file or directory), client: 192.168.10.252, server: _, request: "GET /web/plugins/files/php/files.js.map HTTP/1.1", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/07 14:46:30 [error] 12197#12197: *19677 open() "/usr/share/grommunio-web/resize.js.map" failed (2: No such file or directory), client: 192.168.10.252, server: _, request: "GET /web/resize.js.map HTTP/1.1", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/07 14:48:29 [error] 12197#12197: *19857 open() "/usr/share/grommunio-web/fingerprint.js.map" failed (2: No such file or directory), client: 192.168.10.252, server: _, request: "GET /web/fingerprint.js.map HTTP/1.1", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/07 14:48:29 [error] 12197#12197: *19840 open() "/usr/share/grommunio-web/plugins/files/php/files.js.map" failed (2: No such file or directory), client: 192.168.10.252, server: _, request: "GET /web/plugins/files/php/files.js.map HTTP/1.1", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/07 14:48:29 [error] 12197#12197: *19840 open() "/usr/share/grommunio-web/resize.js.map" failed (2: No such file or directory), client: 192.168.10.252, server: _, request: "GET /web/resize.js.map HTTP/1.1", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/11 10:36:29 [error] 1946#1946: *5 open() "/usr//html/favicon.ico" failed (2: No such file or directory), client: 192.168.10.232, server: _, request: "GET /favicon.ico HTTP/2.0", host: "webmail.xxxxx-xxxxx.ch"

        ==> /var/log/nginx/nginx-ews-access.log <==

        ==> /var/log/nginx/nginx-ews-error.log <==

        ==> /var/log/nginx/nginx-mapi-access.log <==

        ==> /var/log/nginx/nginx-mapi-error.log <==

        ==> /var/log/nginx/nginx-oab-access.log <==

        ==> /var/log/nginx/nginx-oab-error.log <==

        ==> /var/log/nginx/nginx-rpc-access.log <==

        ==> /var/log/nginx/nginx-rpc-error.log <==

        ==> /var/log/nginx/nginx-sync-access.log <==
        192.168.10.252 - joerg@xxxxx-xxxxx.ch [12/Jan/2024:08:26:13 +0100] "POST /Microsoft-Server-ActiveSync?Cmd=Ping&User=joerg%40xxxxx-xxxxx.ch&DeviceId=androidc1868746843&DeviceType=Android HTTP/1.1" 200 13 "-" "Android-Mail/2023.11.26.586591930.Release"
        192.168.10.252 - joerg@xxxxx-xxxxx.ch [12/Jan/2024:08:30:31 +0100] "POST /Microsoft-Server-ActiveSync?Cmd=Ping&User=joerg%40xxxxx-xxxxx.ch&DeviceId=androidc1868746843&DeviceType=Android HTTP/1.1" 200 13 "-" "Android-Mail/2023.11.26.586591930.Release"
        192.168.10.252 - joerg@xxxxx-xxxxx.ch [12/Jan/2024:08:41:18 +0100] "POST /Microsoft-Server-ActiveSync?Cmd=Ping&User=joerg%40xxxxx-xxxxx.ch&DeviceId=androidc1868746843&DeviceType=Android HTTP/1.1" 200 13 "-" "Android-Mail/2023.11.26.586591930.Release"
        192.168.10.252 - joerg@xxxxx-xxxxx.ch [12/Jan/2024:08:47:39 +0100] "POST /Microsoft-Server-ActiveSync?Cmd=Ping&User=joerg%40xxxxx-xxxxx.ch&DeviceId=androidc1868746843&DeviceType=Android HTTP/1.1" 200 13 "-" "Android-Mail/2023.11.26.586591930.Release"
        192.168.10.252 - joerg@xxxxx-xxxxx.ch [12/Jan/2024:08:51:59 +0100] "POST /Microsoft-Server-ActiveSync?Cmd=Ping&User=joerg%40xxxxx-xxxxx.ch&DeviceId=androidc1868746843&DeviceType=Android HTTP/1.1" 200 13 "-" "Android-Mail/2023.11.26.586591930.Release"
        192.168.10.252 - joerg@xxxxx-xxxxx.ch [12/Jan/2024:08:58:54 +0100] "POST /Microsoft-Server-ActiveSync?Cmd=Ping&User=joerg%40xxxxx-xxxxx.ch&DeviceId=androidc1868746843&DeviceType=Android HTTP/1.1" 200 13 "-" "Android-Mail/2023.11.26.586591930.Release"
        192.168.10.252 - joerg@xxxxx-xxxxx.ch [12/Jan/2024:09:00:02 +0100] "POST /Microsoft-Server-ActiveSync?Cmd=Ping&User=joerg%40xxxxx-xxxxx.ch&DeviceId=androidc1868746843&DeviceType=Android HTTP/1.1" 200 13 "-" "Android-Mail/2023.11.26.586591930.Release"
        192.168.10.252 - joerg@xxxxx-xxxxx.ch [12/Jan/2024:09:00:53 +0100] "POST /Microsoft-Server-ActiveSync?Cmd=Ping&User=joerg%40xxxxx-xxxxx.ch&DeviceId=androidc1868746843&DeviceType=Android HTTP/1.1" 200 13 "-" "Android-Mail/2023.11.26.586591930.Release"
        192.168.10.252 - joerg@xxxxx-xxxxx.ch [12/Jan/2024:09:13:55 +0100] "POST /Microsoft-Server-ActiveSync?Cmd=Ping&User=joerg%40xxxxx-xxxxx.ch&DeviceId=androidc1868746843&DeviceType=Android HTTP/1.1" 200 13 "-" "Android-Mail/2023.11.26.586591930.Release"
        192.168.10.252 - joerg@xxxxx-xxxxx.ch [12/Jan/2024:09:35:15 +0100] "POST /Microsoft-Server-ActiveSync?Cmd=Ping&User=joerg%40xxxxx-xxxxx.ch&DeviceId=androidc1868746843&DeviceType=Android HTTP/1.1" 499 0 "-" "Android-Mail/2023.11.26.586591930.Release"

        ==> /var/log/nginx/nginx-sync-error.log <==

        ==> /var/log/nginx/nginx-web-access.log <==
        192.168.10.232 - - [12/Jan/2024:15:35:58 +0100] "POST /web/grommunio.php?subsystem=webapp_1705041446739 HTTP/2.0" 200 72 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:36:08 +0100] "POST /web/grommunio.php?subsystem=webapp_1705070033419 HTTP/2.0" 200 70 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.252 - - [12/Jan/2024:15:36:14 +0100] "POST /web/grommunio.php?subsystem=webapp_1705065464120 HTTP/1.1" 200 82 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:121.0) Gecko/20100101 Firefox/121.0"
        192.168.10.232 - - [12/Jan/2024:15:36:28 +0100] "POST /web/grommunio.php?subsystem=webapp_1705041446739 HTTP/2.0" 200 72 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:36:38 +0100] "POST /web/grommunio.php?subsystem=webapp_1705070033419 HTTP/2.0" 200 70 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.252 - - [12/Jan/2024:15:36:44 +0100] "POST /web/grommunio.php?subsystem=webapp_1705065464120 HTTP/1.1" 200 82 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:121.0) Gecko/20100101 Firefox/121.0"
        192.168.10.232 - - [12/Jan/2024:15:36:59 +0100] "POST /web/grommunio.php?subsystem=webapp_1705041446739 HTTP/2.0" 200 72 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.232 - - [12/Jan/2024:15:37:08 +0100] "POST /web/grommunio.php?subsystem=webapp_1705070033419 HTTP/2.0" 200 70 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
        192.168.10.252 - - [12/Jan/2024:15:37:14 +0100] "POST /web/grommunio.php?subsystem=webapp_1705065464120 HTTP/1.1" 200 82 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:121.0) Gecko/20100101 Firefox/121.0"
        192.168.10.232 - - [12/Jan/2024:15:37:29 +0100] "POST /web/grommunio.php?subsystem=webapp_1705041446739 HTTP/2.0" 200 72 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"

        ==> /var/log/nginx/nginx-web-error.log <==
        #4 /usr/share/grommunio-web/server/includes/core/class.mapisession.php(517): MAPISession->getDisabledFeatures()
        #5 /usr/share/grommunio-web/index.php(184): MAPISession->isWebappDisableAsFeature()
        #6 {main}
        thrown in /usr/share/grommunio-web/server/includes/core/class.mapisession.php on line 606" while reading response header from upstream, client: 192.168.10.232, server: _, request: "GET /web/ HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm/php-grommunio-web-fpm.sock:", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/11 15:13:57 [error] 2215#2215: *2 FastCGI sent in stderr: "PHP message: Problem while getting a user from the addressbook. Error 2147942487 : An invalid parameter was passed to a function or remote procedure call" while reading response header from upstream, client: 192.168.10.232, server: _, request: "POST /web/grommunio.php?subsystem=webapp_1704980983983 HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm/php-grommunio-web-fpm.sock:", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/11 15:14:50 [error] 2215#2215: *2 FastCGI sent in stderr: "PHP message: Problem while getting a user from the addressbook. Error 2147942487 : An invalid parameter was passed to a function or remote procedure call" while reading response header from upstream, client: 192.168.10.232, server: _, request: "POST /web/grommunio.php?subsystem=webapp_1704980983983 HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm/php-grommunio-web-fpm.sock:", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/11 15:16:18 [error] 2215#2215: *2 FastCGI sent in stderr: "PHP message: Problem while getting a user from the addressbook. Error 2147942487 : An invalid parameter was passed to a function or remote procedure call" while reading response header from upstream, client: 192.168.10.232, server: _, request: "POST /web/grommunio.php?subsystem=webapp_1704980983983 HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm/php-grommunio-web-fpm.sock:", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/11 15:16:27 [error] 2215#2215: *2 FastCGI sent in stderr: "PHP message: Problem while getting a user from the addressbook. Error 2147942487 : An invalid parameter was passed to a function or remote procedure call" while reading response header from upstream, client: 192.168.10.232, server: _, request: "POST /web/grommunio.php?subsystem=webapp_1704980983983 HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm/php-grommunio-web-fpm.sock:", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/11 15:16:57 [error] 2215#2215: *2 FastCGI sent in stderr: "PHP message: Problem while getting a user from the addressbook. Error 2147942487 : An invalid parameter was passed to a function or remote procedure call" while reading response header from upstream, client: 192.168.10.232, server: _, request: "POST /web/grommunio.php?subsystem=webapp_1704980983983 HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm/php-grommunio-web-fpm.sock:", host: "webmail.xxxxx-xxxxx.ch"
        2024/01/11 15:27:34 [error] 2215#2215: *2 FastCGI sent in stderr: "PHP message: Problem while getting a user from the addressbook. Error 2147942487 : An invalid parameter was passed to a function or remote procedure call" while reading response header from upstream, client: 192.168.10.232, server: _, request: "POST /web/grommunio.php?subsystem=webapp_1704980983983 HTTP/2.0", upstream: "fastcgi://unix:/run/php-fpm/php-grommunio-web-fpm.sock:", host: "webmail.xxxxx-xxxxx.ch"

        ==> /var/log/nginx/nginx-web-access.log <==
        192.168.10.232 - - [12/Jan/2024:15:37:38 +0100] "POST /web/grommunio.php?subsystem=webapp_1705070033419 HTTP/2.0" 200 70 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"_

        Joerg

        Joerg Do you also "only" have problems with the search, or is something else not working?

        Everything else works as expected

        I cannot find any current errors in the nginx logs. But the Chrome debug console says:

        grommunio-debug.js:1456`` Uncaught TypeError: Cannot read properties of null (reading 'sendRecords')
        at Object.onException (grommunio-debug.js:1456:26)
        at h.Event.fire (ext-base-all.js?version=3.6.11.46554f3e-lp155.13.2:41:3699)
        at Function.fireEvent (ext-base-all.js?version=3.6.11.46554f3e-lp155.13.2:41:687)
        at constructor.processResponse (grommunio-debug.js:9752:23)
        at constructor.receive (grommunio-debug.js:9619:8)
        at constructor.stateChange (grommunio-debug.js:9271:19)
        at XMLHttpRequest.<anonymous> (ext-base-all.js?version=3.6.11.46554f3e-lp155.13.2:21:8903)

        Try to update the system with grommunio-update update, this may help.

          WalterH ry to update the system with grommunio-update update, this may help.

          Hello Walter
          I did the update and restarted the server:

          
          localhost:~ # grommunio-update update
                                                 _                       __     __
            ___ ________  __ _  __ _  __ _____  (_)__  ______ _____  ___/ /__ _/ /____
           / _ \/ __/ _ \/  ' \/  ' \/ // / _ \/ / _ \/___/ // / _ \/ _  / _ \/ __/ -_)
           \_, /_/  \___/_/_/_/_/_/_/\_,_/_//_/_/\___/    \_,_/ .__/\_,_/\_,_/\__/\__/
          /___/                                              /_/
          
          ## This system	: localhost
          ## Uptime	: 3 days  0:23
          ## Load		: Last Minute: 0.17, Last 5 Minutes: 0.09, Last 15 Minutes: 0.09
          ## IP Address	: 192.168.10.238
          ## Executed	: /usr/sbin/grommunio-update update
          ## Start	: Tue 2024-01-16 10:43:20 CET
          ## Operation	: Update
          
          Starting Update (zypper ref && zypper up -y)
          Repository 'base' is up to date.
          Repository 'debug' is up to date.
          Repository 'debug-update' is up to date.
          Retrieving repository 'grommunio' metadata [.....done]
          Building repository 'grommunio' cache [...done]
          Retrieving repository 'repo-backports-update' metadata [.............done]
          Building repository 'repo-backports-update' cache [....done]
          Retrieving repository 'repo-sle-update' metadata [..........................done]
          Building repository 'repo-sle-update' cache [....done]
          Repository 'update' is up to date.
          All repositories have been refreshed.
          Loading repository data...
          Reading installed packages...
          
          The following 4 packages are going to be upgraded:
            efibootmgr gromox gromox-debuginfo gromox-debugsource
          
          4 packages to upgrade.
          Overall download size: 20.4 MiB. Already cached: 0 B. After the operation, additional 19.3 KiB will be used.
          Continue? [y/n/v/...? shows all options] (y): y
          Retrieving: gromox-2.21.23.g17c2047-lp155.14.1.x86_64 (grommunio) (1/4),   2.1 MiB    
          Retrieving: gromox-2.21.23.g17c2047-lp155.14.1.x86_64.rpm [...done (1.7 MiB/s)]
          Retrieving: gromox-debugsource-2.21.23.g17c2047-lp155.14.1.x86_64 (grommunio) (2/4),   1.0 MiB    
          Retrieving: gromox-debugsource-2.21.23.g17c2047-lp155.14.1.x86_64.rpm [.done]
          Retrieving: gromox-debuginfo-2.21.23.g17c2047-lp155.14.1.x86_64 (grommunio) (3/4),  17.2 MiB    
          Retrieving: gromox-debuginfo-2.21.23.g17c2047-lp155.14.1.x86_64.rpm [...done (10.1 MiB/s)]
          Retrieving: efibootmgr-17-150400.3.2.2.x86_64 (repo-sle-update) (4/4),  44.9 KiB    
          Retrieving: efibootmgr-17-150400.3.2.2.x86_64.rpm [...done (282.8 KiB/s)]
          
          Checking for file conflicts: [............done]
          (1/4) Installing: gromox-2.21.23.g17c2047-lp155.14.1.x86_64 [...........done]
          (2/4) Installing: gromox-debugsource-2.21.23.g17c2047-lp155.14.1.x86_64 [..........done]
          (3/4) Installing: gromox-debuginfo-2.21.23.g17c2047-lp155.14.1.x86_64 [...............................done]
          (4/4) Installing: efibootmgr-17-150400.3.2.2.x86_64 [..done]
           
          
          Update completed successfully.
          Updating postfix configuration with new maps if exist
          Running post-update/upgrade checksdbop: Current database schema: gx-131
          
          Checking for pending service restart or reboot
          
          ## End Update	: Tue 2024-01-16 10:43:56 CET

          Unfortunately, the result is still the same.

          You ma try a repair for this mailbox:

          /usr/libexec/gromox/cgkrepair [-n] -e [user]@domain

          -e [user]@domain Operate on the given private/user store or public/domain mailbox.
          -n Perform a dry run.

            WalterH You ma try a repair for this mailbox:

            /usr/libexec/gromox/cgkrepair [-n] -e [user]@domain

            Unfortunately, it didn't help either. The error remains.

            
            localhost:~ # /usr/libexec/gromox/cgkrepair -e joerg@xxxxx-xxxxx.ch
            Hierarchy discovery: 87 folders
            2h (ok)
            3h (ok)
            4h (ok)
            5h (ok)
            1fah (ok)
            215h (ok)
            6h (ok)
            7h (ok)
            8h (ok)
            9h (ok)
            ah (ok)
            bh (ok)
            ch (ok)
            dh (ok)
            eh (ok)
            fh (ok)
            10h (ok)
            11h (ok)
            12h (ok)
            13h (ok)
            14h (ok)
            15h (ok)
            16h (ok)
            17h (ok)
            19h (ok)
            1ah (ok)
            1bh (ok)
            1ch (ok)
            1dh (ok)
            1d0001h (ok)
            1d2711h (ok)
            1d4e21h (ok)
            1d7531h (ok)
            1d9c41h (ok)
            1dc351h (ok)
            1dea61h (ok)
            1e1171h (ok)
            1e3881h (ok)
            1e5f91h (ok)
            1e86a1h (ok)
            1eadb1h (ok)
            1ed4c1h (ok)
            1efbd1h (ok)
            1f22e1h (ok)
            1f49f1h (ok)
            1f7101h (ok)
            1f9811h (ok)
            1fbf21h (ok)
            1fe631h (ok)
            200d41h (ok)
            203451h (ok)
            205b61h (ok)
            208271h (ok)
            20a981h (ok)
            20d091h (ok)
            20f7a1h (ok)
            211eb1h (ok)
            2145c1h (ok)
            216cd1h (ok)
            2193e1h (ok)
            21baf1h (ok)
            21e201h (ok)
            220911h (ok)
            223021h (ok)
            225731h (ok)
            227e41h (ok)
            22a551h (ok)
            22cc61h (ok)
            22f371h (ok)
            231a81h (ok)
            234191h (ok)
            2368a1h (ok)
            238fb1h (ok)
            23b6c1h (ok)
            23ddd1h (ok)
            2404e1h (ok)
            242bf1h (ok)
            245301h (ok)
            247a11h (ok)
            18h (ok)
            101h (ok)
            102h (ok)
            24a121h (ok)
            24c831h (ok)
            24ef41h (ok)
            251651h (ok)
            253d61h (ok)

            WalterH You may try the SQLite Recovery described here: https://docs.grommunio.com/kb/sqlite.html for this database.

            I get a parse error on recover:

            localhost:~ # sqlite3 /var/lib/gromox/user/2/1/exmdb/exchange.sqlite3
            SQLite version 3.44.2 2023-11-24 11:41:44
            Enter ".help" for usage hints.
            sqlite> pragma integrity_check;
            ok
            sqlite> 
            
            localhost:~ # cd /var/lib/gromox/user/2/1/exmdb/
            localhost:/var/lib/gromox/user/2/1/exmdb # sqlite3 exchange.sqlite3 ".recover" | sqlite3 new.db
            Parse error near line 8: object name reserved for internal use: sqlite_sequence
            localhost:/var/lib/gromox/user/2/1/exmdb # chmod u=rw,g=rw new.db 
            localhost:/var/lib/gromox/user/2/1/exmdb # chown grommunio:gromox new.db 
            localhost:/var/lib/gromox/user/2/1/exmdb # mv exchange.sqlite3 old.db
            localhost:/var/lib/gromox/user/2/1/exmdb # mv new.db exchange.sqlite3
            localhost:/var/lib/gromox/user/2/1/exmdb # systemctl restart gromox-http
            localhost:/var/lib/gromox/user/2/1/exmdb # 

            When I create a new user and do a search in the completely empty account, I also get the error in the web search: "An unexpected error has occurred"

            Solved:
            The complete reinstall brought the solution.
            Deleting all settings and re-parameterizing using "grommunio setup wizzard" was not enough.

            Joerg changed the title to Solved: "An unexpected error has occurred" Grommunio Web Search .

            I have the same problem, but a reinstall is no solution.

            greets
            Michael

              MichaelH I have the same problem, but a reinstall is no solution.

              Yes, unfortunately I've had to find that out again now. After migrating several accounts to the new system with grommunio on Friday, I realized that the search in the web interface doesn't work for the other mail accounts :-(
              The system is currently running productively (only for my family) but I am considering migrating back to Kopano...
              Actually, I hope that a solution can be found in the next few days. Strangely enough, the search on my own account still works after the reinstallation.

              Joerg changed the title to Reopened: "An unexpected error has occurred" Grommunio Web Search .

              Same problem here. And it's "only" the web-search, the search with smartphones works without an error (iPhone with Exchange-mailbox). So it seems, the error is in the website-part and not in database. @Joerg: can you confirm this?

              I hope too that a sloution can be found, although the search on smartphone is a short-term alternative.

                Angua And it's "only" the web-search, the search with smartphones works without an error (iPhone with Exchange-mailbox)

                Yes, I can confirm that. (Anroid 14 "Vanilla" with standard mail client)

                © 2020-2024 grommunio GmbH. All rights reserved. | https://grommunio.com | Data Protection | Legal notice