ImmichI
Immich•3y ago•
3 replies
Tommy

QueryFailedError

I'm setting up Immich in my Nomad cluster, so I'm translating the docker-compose setup, but this error is throwing me off.
Both the microservices and server containers throw this:
[Nest] 1  - 07/04/2023, 6:14:57 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (7)...
QueryFailedError: function uuid_generate_v4() does not exist
    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async CreateUserTable1645130759468.up (/usr/src/app/dist/infra/migrations/1645130759468-CreateUserTable.js:6:9)
    at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
    at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:260:35)
    at async DataSource.initialize (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:148:17)

I'm running postgres:14.8-alpine for my database container, it's shared by several services.
Any idea why the uuid_generate_v4 wouldn't be found, or is this error a red herring?
Was this page helpful?