Error:
sqlite3_exec(/var/lib/gromox/user/4/0/exmdb/exchange.sqlite3) "INSERT INTO messages (message_id, parent_fid, parent_attid, is_associated, change_number, message_size) VALUES (205584, 13, NULL, 0, 140737488417410, 87586)": UNIQUE constraint failed: messages.message_id
What we try so far without success:
cd /var/lib/gromox/user/4/0/exmdb/
sqlite3 exchange.sqlite3 .recover >recover.sql
mv exchange.sqlite3 exchange.sqlite3.old
sqlite3 exchange.sqlite3 <recover.sql
chmod u=rw,g=rw exchange.sqlite3
chown grommunio:gromox exchange.sqlite3
systemctl restart gromox-http
The output is:
grommunio:/var/lib/gromox/user/4/0/exmdb # sqlite3 exchange.sqlite3 .recover >recover1.sql
grommunio:/var/lib/gromox/user/4/0/exmdb # mv exchange.sqlite3 exchange2.sqlite3.old
grommunio:/var/lib/gromox/user/4/0/exmdb # sqlite3 exchange.sqlite3 <recover2.sql
Parse error near line 8: object name reserved for internal use: sqlite_sequence
grommunio:/var/lib/gromox/user/4/0/exmdb # chmod u=rw,g=rw exchange.sqlite3
grommunio:/var/lib/gromox/user/4/0/exmdb # chown grommunio:gromox exchange.sqlite3
grommunio:/var/lib/gromox/user/4/0/exmdb # systemctl restart gromox-http
Installed Version
rpm -qa |grep -E "(grommunio|gromox|mapi|libHX32|libexmdbpp|libfmt|libgumbo1|libpff1|libtinyxml|libvmime)" | sort
grommunio-admin-api-1.11.25.8935796-lp153.24.1.noarch
grommunio-admin-common-6.cb985db-lp153.11.1.noarch
grommunio-admin-web-2.8.0.3.57a15dd-lp153.10.1.noarch
grommunio-antispam-3.6-lp153.1.1.x86_64
grommunio-archive-1.3.13.g137.d1b0df1b-lp153.3.5.x86_64
grommunio-chat-7.8.0-lp153.2.1.x86_64
grommunio-common-15.94f06a1-lp153.15.1.x86_64
grommunio-cui-1.0.250.0365021-lp153.19.1.noarch
grommunio-dav-1.3.11.2b59b5d-lp153.4.1.noarch
grommunio-error-pages-1.0.9.224b089-lp153.13.1.noarch
grommunio-files-25.0.10-lp153.1.1.noarch
grommunio-imapsync-2.229-lp153.6.1.noarch
grommunio-index-0.1.36.4ebe9ad-lp153.14.1.x86_64
grommunio-office-7.0.0-lp153.5.2.x86_64
grommunio-office-fonts-7.0.0-lp153.5.2.noarch
grommunio-release-2022.05.2-lp153.3.1.x86_64
grommunio-setup-1.0.97.e20960a-lp153.21.1.noarch
grommunio-sync-2.0.23.897fb38-lp153.27.1.noarch
grommunio-web-3.2.72.dddd229-lp153.6.1.noarch
gromox-2.10.256.4feb515-lp153.15.1.x86_64
gromox-debuginfo-2.10.256.4feb515-lp153.15.1.x86_64
gromox-debugsource-2.10.256.4feb515-lp153.15.1.x86_64
grub2-theme-grommunio-1-lp153.11.5.noarch
jitsi-meet-branding-grommunio-2.0.6726-lp153.7.1.noarch
libHX32-4.14-lp153.1.1.x86_64
libexmdbpp0-1.10.4.b7a36f2-lp153.17.1.x86_64
libfmt7-7.1.3-bp153.1.17.x86_64
libfmt8-8.1.1-lp153.5.4.x86_64
libgumbo1-0.10.1-lp153.1.3.x86_64
libpff1-20230325-lp153.1.2.x86_64
libtinyxml2-9-9.0.0-lp153.3.3.x86_64
libvmime-suse5-0.9.2.175-lp153.18.1.x86_64
mapi-header-php-1.1.17.18b40f9-lp153.10.1.noarch
patterns-grommunio-1-lp153.9.1.x86_64
plymouth-theme-grommunio-1-lp153.11.5.noarch
system-user-grommunio-3-lp153.10.2.noarch
system-user-gromox-2-lp153.13.2.noarch
systemd-presets-branding-grommunio-2022.12-lp153.1.2.noarch
