sqlite_busy ... write txn held by unknown

MichaelH · 2024-09-02T05:05:42+00:00

Hi, i get this error or info message in the log gromox-http. During this a login into the Web IF is not possible. [2024-09-01 16:04:28.834381]: system: HTTP...

WalterH

dougi weil der Push auf das Mobiledevice ja auch rein lesend möglich sein sollte?

No, push writes the state information into the data base.

Which version is your gromox package: rpm -qa gromox ?

dougi

gromox-2.41.12.9a6a0a6-lp156.6.1.x86_64

WalterH

dougi gromox-2.41.12.

current supportet version.

Try a
zypper ref; zypper dup
to make sure you have all current packages installed.

dougi

Repository 'debug-update' ist aktuell.
Repository 'Update repository of openSUSE Backports' ist aktuell.
Repository 'Update repository with updates from SUSE Linux Enterprise 15' ist aktuell.
Repository 'update' ist aktuell.
Repository 'base' ist aktuell.
Repository 'debug' ist aktuell.
Repository 'grommunio' ist aktuell.
Alle Repositorys wurden aktualisiert.
Repository-Daten werden geladen...
Installierte Pakete werden gelesen...
Warnung: Sie sind im Begriff, eine Distributionsaktualisierung mit allen aktivierten Repositorys durchzuführen. Vergewissern Sie sich, dass diese Repositorys kompatibel sind, bevor Sie fortfahren. Weitere Informationen zu diesem Kommando finden Sie unter 'man zypper'.
Distributions-Aktualisierungen werden verarbeitet...
Keine auszuführenden Aktionen.

WalterH

Any 3. party software like Virus Scanner or any other software installed on this system?

dougi

Nein, alles Standard.

dougi

Nachdem nun auch die serverseitige Suche wieder nicht mehr funktioniert - das ging nach dem letzten Update bis vorletzte Woche überragend gut - habe ich folgende Befehle ausgeführt:

localhost:~ # rm -rf /var/lib/grommunio-web/sqlite-index/*
localhost:~ # systemctl restart grommunio-index.service

Darauf fand ich diese Meldungen im Log:
Feb 21 11:14:32 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393260: exmdb call failed: Dispatch error
Feb 21 11:15:33 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393265: exmdb call failed: Dispatch error
Feb 21 11:16:33 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393272: exmdb call failed: Dispatch error
Feb 21 11:17:34 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393291: exmdb call failed: Dispatch error
Feb 21 11:19:46 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393332: exmdb call failed: Dispatch error
Feb 21 11:20:46 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393345: exmdb call failed: Dispatch error
Feb 21 11:22:46 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393347: exmdb call failed: Dispatch error
Feb 21 11:23:46 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393350: exmdb call failed: Dispatch error
Feb 21 11:24:47 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393362: exmdb call failed: Dispatch error
Feb 21 11:25:47 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393375: exmdb call failed: Dispatch error
Feb 21 11:29:07 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393480: exmdb call failed: Dispatch error
Feb 21 11:30:07 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393497: exmdb call failed: Dispatch error
Feb 21 11:31:08 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393538: exmdb call failed: Dispatch error
Feb 21 11:32:17 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393557: exmdb call failed: Dispatch error
Feb 21 11:33:17 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393577: exmdb call failed: Dispatch error
Feb 21 11:34:17 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393596: exmdb call failed: Dispatch error
Feb 21 11:35:17 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393609: exmdb call failed: Dispatch error
Feb 21 11:36:18 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393632: exmdb call failed: Dispatch error
Feb 21 11:37:18 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393654: exmdb call failed: Dispatch error
Feb 21 11:38:18 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393657: exmdb call failed: Dispatch error
Feb 21 11:39:18 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393679: exmdb call failed: Dispatch error
Feb 21 11:40:18 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393698: exmdb call failed: Dispatch error
Feb 21 11:41:19 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393718: exmdb call failed: Dispatch error
Feb 21 11:42:19 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393724: exmdb call failed: Dispatch error
Feb 21 11:43:28 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393780: exmdb call failed: Dispatch error
Feb 21 11:44:38 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393850: exmdb call failed: Dispatch error
Feb 21 11:45:38 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393882: exmdb call failed: Dispatch error
Feb 21 11:46:48 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393932: exmdb call failed: Dispatch error
Feb 21 11:48:48 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393949: exmdb call failed: Dispatch error
Feb 21 11:49:48 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/393969: exmdb call failed: Dispatch error
Feb 21 11:50:57 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394010: exmdb call failed: Dispatch error
Feb 21 11:51:58 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394053: exmdb call failed: Dispatch error
Feb 21 11:52:58 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394066: exmdb call failed: Dispatch error
Feb 21 11:53:59 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394111: exmdb call failed: Dispatch error
Feb 21 11:54:59 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394125: exmdb call failed: Dispatch error
Feb 21 11:56:07 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394161: exmdb call failed: Dispatch error
Feb 21 11:57:08 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394184: exmdb call failed: Dispatch error
Feb 21 11:58:08 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394223: exmdb call failed: Dispatch error
Feb 21 12:01:09 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394232: exmdb call failed: Dispatch error
Feb 21 12:02:09 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394260: exmdb call failed: Dispatch error
Feb 21 12:03:09 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394273: exmdb call failed: Dispatch error
Feb 21 12:04:09 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394283: exmdb call failed: Dispatch error
Feb 21 12:05:18 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394319: exmdb call failed: Dispatch error
Feb 21 12:06:18 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394333: exmdb call failed: Dispatch error
Feb 21 12:07:19 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394338: exmdb call failed: Dispatch error
Feb 21 12:08:19 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394394: exmdb call failed: Dispatch error
Feb 21 12:09:20 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394429: exmdb call failed: Dispatch error
Feb 21 12:10:20 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394447: exmdb call failed: Dispatch error
Feb 21 12:11:20 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394453: exmdb call failed: Dispatch error
Feb 21 12:12:20 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394490: exmdb call failed: Dispatch error
Feb 21 12:13:21 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394506: exmdb call failed: Dispatch error
Feb 21 12:14:21 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394522: exmdb call failed: Dispatch error
Feb 21 12:15:21 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394573: exmdb call failed: Dispatch error
Feb 21 12:16:21 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394593: exmdb call failed: Dispatch error
Feb 21 12:17:30 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394651: exmdb call failed: Dispatch error
Feb 21 12:18:30 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394663: exmdb call failed: Dispatch error
Feb 21 12:20:31 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394674: exmdb call failed: Dispatch error
Feb 21 12:21:31 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394724: exmdb call failed: Dispatch error
Feb 21 12:22:32 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394749: exmdb call failed: Dispatch error
Feb 21 12:23:32 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394770: exmdb call failed: Dispatch error
Feb 21 12:25:40 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394814: exmdb call failed: Dispatch error
Feb 21 12:26:40 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394817: exmdb call failed: Dispatch error
Feb 21 12:27:40 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394819: exmdb call failed: Dispatch error
Feb 21 12:28:48 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394868: exmdb call failed: Dispatch error
Feb 21 12:29:49 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394923: exmdb call failed: Dispatch error
Feb 21 12:30:49 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394938: exmdb call failed: Dispatch error
Feb 21 12:31:50 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394946: exmdb call failed: Dispatch error
Feb 21 12:32:50 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394949: exmdb call failed: Dispatch error
Feb 21 12:33:50 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394951: exmdb call failed: Dispatch error
Feb 21 12:34:50 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/394971: exmdb call failed: Dispatch error
Feb 21 12:35:59 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395038: exmdb call failed: Dispatch error
Feb 21 12:36:59 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395045: exmdb call failed: Dispatch error
Feb 21 12:37:59 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395052: exmdb call failed: Dispatch error
Feb 21 12:39:59 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395055: exmdb call failed: Dispatch error
Feb 21 12:41:59 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395093: exmdb call failed: Dispatch error
Feb 21 12:43:00 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395104: exmdb call failed: Dispatch error
Feb 21 12:44:00 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395128: exmdb call failed: Dispatch error
Feb 21 12:45:00 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395133: exmdb call failed: Dispatch error
Feb 21 12:46:00 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395163: exmdb call failed: Dispatch error
Feb 21 12:47:00 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395173: exmdb call failed: Dispatch error
Feb 21 12:48:01 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395207: exmdb call failed: Dispatch error
Feb 21 12:49:01 localhost grommunio-index[16073]: [ERROR] Failed to insert message 10/395215: exmdb call failed: Dispatch error
Feb 21 12:51:02 localhost grommunio-index[2033]: [FATAL] exmdb call failed: Dispatch error

Zeitgleich war die Postfachanbindung komplett blockiert. Erst ein Neustart von grommunio-index.service hat die Blockierung wieder aufgelöst.

Also irgendwas läuft noch nicht so rund wie es sollte :/

WalterH

Ist das ein Debian? Wenn ja, sqlite3 vom grommunio Repository installieren, die ist neuer als von Debian.

dougi

Frage beantwortet, es existiert bereits ein Ticket von @crpb

https://github.com/grommunio/grommunio-index/issues/9

crpb

@midas kennt die auch ^_^

oftc/2025/01/24.#grommunio.log:23:34 < cb> en haufen [ERROR] Failed to insert message 19/525681: exmdb call failed: Dispatch error
oftc/2025/01/25.#grommunio.log:00:14 < midasi> [ERROR] Failed to insert message 25/1966273: exmdb call failed: Dispatch error
oftc/2025/01/28.#grommunio.log:09:27 < midasi> den dispatch error https://github.com/grommunio/grommunio-index/issues/9 hatte ich allerdings auch noch mit grom 2.38 und index 1.0

« Previous Page