ImmichI
Immich•8mo ago•
9 replies
OR3X

Failed to activate VectorChord extension

Encountered an issue after upgrading to V1.133.0 - immich_server container continuously restarts. I checked logs with:
docker log immich_server

and got the following error from the log:
Failed to activate VectorChord extension.
    Please ensure the Postgres instance has VectorChord installed.

    If the Postgres instance already has VectorChord installed, Immich may not have the necessary permissions to activate it.
    In this case, please run 'CREATE EXTENSION IF NOT EXISTS vchord CASCADE' manually as a superuser.
    See https://immich.app/docs/guides/database-queries for how to query the database.

Following the information from the error I used the following command to enter the DB
 docker exec -it immich_postgres psql --dbname=<DB_DATABASE_NAME> --username=<DB_USERNAME>

and then ran
docker exec -it immich_postgres psql --dbname=<DB_DATABASE_NAME> --username=<DB_USERNAME>

which gave no output. I then exited the DB and stopped and started the container with the same results.
Was this page helpful?