OR3X Posts - Answer Overflow

OR3X

•Created by OR3X on 5/22/2025 in #help-desk-support

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

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.

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>

 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>

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.

10 replies

Gaming

Programming