matrix-synapse-auto-compressor.service: Failed

[felixx9]

Describe the bug A long time, "my" auto-compressor was running. Today I checked my server and I found this error:

$ systemctl status matrix-synapse-auto-compressor

● matrix-synapse-auto-compressor.service - Synapse State Auto Compressor
     Loaded: loaded (/etc/systemd/system/matrix-synapse-auto-compressor.service; disabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Sat 2024-07-06 00:00:08 UTC; 20h ago
TriggeredBy: ● matrix-synapse-auto-compressor.timer
    Process: 373527 ExecStartPre=/usr/bin/env sh -c /usr/bin/env docker stop --time=3 matrix-synapse-auto-compressor 2>/dev/null || true (code=exited, status=0/SUCCESS)
    Process: 373556 ExecStartPre=/usr/bin/env sh -c /usr/bin/env docker rm matrix-synapse-auto-compressor 2>/dev/null || true (code=exited, status=0/SUCCESS)
    Process: 373576 ExecStartPre=/usr/bin/env docker create --rm --name=matrix-synapse-auto-compressor --log-driver=none --cap-drop=ALL --read-only --user=998:1001 --network=matrix-postgres --env-file=/matrix/synapse-auto-compressor/env --entrypoint=/bin/sh registry.gitlab.com/etke.cc/rust-synapse-compress-state:v0.>
    Process: 373591 ExecStart=/usr/bin/env docker start --attach matrix-synapse-auto-compressor (code=exited, status=101)
   Main PID: 373591 (code=exited, status=101)
        CPU: 162ms

Jul 06 00:00:00 v2202210159252202628 systemd[1]: Starting Synapse State Auto Compressor...
Jul 06 00:00:00 v2202210159252202628 matrix-synapse-auto-compressor[373576]: 8b496798f69fcf07da9dc39242575f73ab0f909a35c13380b7261b9dc612f14d
Jul 06 00:00:01 v2202210159252202628 matrix-synapse-auto-compressor[373591]: [2024-07-06T00:00:01Z INFO  synapse_auto_compressor] synapse_auto_compressor started
Jul 06 00:00:01 v2202210159252202628 matrix-synapse-auto-compressor[373591]: [2024-07-06T00:00:01Z INFO  synapse_auto_compressor::manager] Running compressor on room !UPsqJAKJwKaqqYkxNZ:cutefunny.art with chunk size 500
Jul 06 00:00:07 v2202210159252202628 matrix-synapse-auto-compressor[373591]: [2024-07-06T00:00:07Z ERROR panic] thread 'main' panicked at 'Missing 1067109': src/lib.rs:668
Jul 06 00:00:08 v2202210159252202628 systemd[1]: matrix-synapse-auto-compressor.service: Main process exited, code=exited, status=101/n/a
Jul 06 00:00:08 v2202210159252202628 systemd[1]: matrix-synapse-auto-compressor.service: Failed with result 'exit-code'.
Jul 06 00:00:08 v2202210159252202628 systemd[1]: Failed to start Synapse State Auto Compressor.

not sure, whther this is a "this-playbook-issue"...

To Reproduce

• Install matrix-synapse-auto-compressor
• run systemctl start matrix-synapse-auto-compressor

[spantaleev]

Sounds like an issue with the tool itself. Consider reporting to its repository.

[felixx9]

yeah thx. found an issue on that. Will try the almost "crazy" workaround: https://github.com/matrix-org/rust-synapse-compress-state/issues/78#issuecomment-1409932869

edit: the mentioned sql script fixes the issue for me.

[Zocker1999NET]

yeah thx. found an issue on that. Will try the almost "crazy" workaround: matrix-org/rust-synapse-compress-state#78 (comment)

That script also worked for me, but I adapted it slightly so that it "just works" on this deployment. But I also needed to adapt the postgres/bin/cli-non-interactive script because it did not worked on my setup (but I suspect that’s probably a "me" issue). See the patches attached.

Patches

```patch diff --git a/compress-fix.sh.old b/compress-fix.sh --- a/compress-fix.sh.old +++ b/compress-fix.sh @@ -15,16 +15,11 @@ set -e -u -o pipefail -export PGHOST=$1 -export PGDATABASE=$2 -export PGUSER=$3 -export PGPASSWORD=$4 - SCRIPT=$(basename $0) echo "[$(date -u '+%Y-%m-%dT%H:%M:%SZ') INFO ${SCRIPT}]" Starting -psql <<_EOF +/matrix/postgres/bin/cli-non-interactive synapse <<_EOF BEGIN; DELETE ``` ```patch diff --git a/matrix/postgres/bin/cli-non-interactive.old b/matrix/postgres/bin/cli-non-interactive --- a/matrix/postgres/bin/cli-non-interactive.old +++ b/matrix/postgres/bin/cli-non-interactive @@ -1,6 +1,7 @@ #!/bin/bash docker run \ + --interactive \ --rm \ --user=987:1002 \ --cap-drop=ALL \ ```

[aine-etke]

fixed: https://github.com/spantaleev/matrix-docker-ansible-deploy/pull/3473