So I have a grommunio mail server running gromox 2.45 (began with gromox 2.16 or so).
When looking into journalctl, I get multiple errors for midb.sqlite :
mai 23 21:59:57 email gromox-midb[2484]: sqlite3_step(/var/lib/gromox/user/3/B/exmdb/midb.sqlite3) "INSERT INTO messages (message_id, folder_id, mid_string, mod_time, uid, unsent, read, subject, sender, rcpt, size, received) VALUES (4785015, 13, '1744357900.62159.mail.domain.tld', 133888315005156027, 11946, 0, 1, '=?iso-8859-1?Q?R=E9ponse_automatique=A0:_R=E9capitulatifs_HFE_=E0_la_BPS?=', 'user@remote-example.tld', 'user@domain.tld', 17760, 133888315005151449)": UNIQUE constraint failed: messages.mid_string (19)
mai 23 21:59:57 email gromox-midb[2484]: E-2075: sqlite_step not finished
mai 23 21:59:57 email gromox-midb[2484]: sqlite3_step(/var/lib/gromox/user/3/B/exmdb/midb.sqlite3) "INSERT INTO messages (message_id, folder_id, mid_string, mod_time, uid, unsent, read, subject, sender, rcpt, size, received) VALUES (4784986, 13, '1744354102.61644.mail.domain.tld', 133888277023219397, 11945, 0, 1, 'RE: [ABSISERVICES] BACKLOG ABSI - 2025-04-11', 'user@domain.tld', 'some-other@remote-user.tld 120156, 133888277023217865)": UNIQUE constraint failed: messages.mid_string (19)
mai 23 21:59:57 email gromox-midb[2484]: E-2075: sqlite_step not finished
Is there anyway to fix midb database, or rebuild it from scratch perhaps ?
