I
Immich•2y ago
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)
[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?
3 Replies
bo0tzz
bo0tzz•2y ago
Make sure the uuid-ossp extension exists on the database you have for immich
bo0tzz
bo0tzz•2y ago
This thread might be relevant: https://github.com/immich-app/immich/issues/675#issuecomment-1242950976
GitHub
[Feature]: Using External Postgres/Redis · Issue #675 · immich-app/...
Feature detail I have a common postgres/redis server running for nextcloud, home assistant, lychee etc (not installed as a docker but as a system repo app). Is it possible for immich to use an exte...
Tommy
TommyOP•2y ago
Thanks, that was it

Did you find this page helpful?