Immich•2y ago

500 error on server update/bios reset

cmos on the server failed so bios was reset, also updated to the latest after getting it back and running/clock synced. Now I am getting 500 errors when loading from app or website

7 Replies

EnderPictureOP•2y ago

[ERROR] hooks.server.ts [handle]: AxiosError: connect ECONNREFUSED 172.19.0.7:3001
    at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16) {
  port: 3001,
  address: '172.19.0.7',
  syscall: 'connect',
  code: 'ECONNREFUSED',
  errno: -111,
  config: {
    transitional: {
      silentJSONParsing: true,
      forcedJSONParsing: true,
      clarifyTimeoutError: false
    },
    adapter: [Function: httpAdapter],
    transformRequest: [ [Function: transformRequest] ],
    transformResponse: [ [Function: transformResponse] ],
    timeout: 0,
    xsrfCookieName: 'XSRF-TOKEN',
    xsrfHeaderName: 'X-XSRF-TOKEN',
    maxContentLength: -1,
    maxBodyLength: -1,
    env: { FormData: [Function] },
    validateStatus: [Function: validateStatus],
    headers: {
      Accept: 'application/json, text/plain, */*',
      Authorization: 'Bearer vpCur26VY2NGCj6PTvJAsBPeOQVPCnlVT5kE3KyF6aQ',
      'User-Agent': 'axios/0.27.2'
    },
    method: 'get',
    url: 'http://immich-server:3001/user/me',
    data: undefined
  },

[ERROR] hooks.server.ts [handle]: AxiosError: connect ECONNREFUSED 172.19.0.7:3001
    at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16) {
  port: 3001,
  address: '172.19.0.7',
  syscall: 'connect',
  code: 'ECONNREFUSED',
  errno: -111,
  config: {
    transitional: {
      silentJSONParsing: true,
      forcedJSONParsing: true,
      clarifyTimeoutError: false
    },
    adapter: [Function: httpAdapter],
    transformRequest: [ [Function: transformRequest] ],
    transformResponse: [ [Function: transformResponse] ],
    timeout: 0,
    xsrfCookieName: 'XSRF-TOKEN',
    xsrfHeaderName: 'X-XSRF-TOKEN',
    maxContentLength: -1,
    maxBodyLength: -1,
    env: { FormData: [Function] },
    validateStatus: [Function: validateStatus],
    headers: {
      Accept: 'application/json, text/plain, */*',
      Authorization: 'Bearer vpCur26VY2NGCj6PTvJAsBPeOQVPCnlVT5kE3KyF6aQ',
      'User-Agent': 'axios/0.27.2'
    },
    method: 'get',
    url: 'http://immich-server:3001/user/me',
    data: undefined
  },

Alex Tran•2y ago

Can you post the server logs? The app cannot start most likely due to some issues with the server Are you also using modified docker-compose file or are they stock/from the release version?

EnderPictureOP•2y ago

stock docker compose

[Nest] 1  - 06/26/2023, 6:37:02 AM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (5)...
QueryFailedError: could not create unique index "UQ_4ed4f8052685ff5b1e7ca1058ba"
    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 ImportAsset1686584273471.up (/usr/src/app/dist/infra/migrations/1686584273471-ImportAsset.js:10: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  - 06/26/2023, 6:37:05 AM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (6)...
QueryFailedError: could not create unique index "UQ_4ed4f8052685ff5b1e7ca1058ba"
    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 ImportAsset1686584273471.up (/usr/src/app/dist/infra/migrations/1686584273471-ImportAsset.js:10: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  - 06/26/2023, 6:37:02 AM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (5)...
QueryFailedError: could not create unique index "UQ_4ed4f8052685ff5b1e7ca1058ba"
    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 ImportAsset1686584273471.up (/usr/src/app/dist/infra/migrations/1686584273471-ImportAsset.js:10: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  - 06/26/2023, 6:37:05 AM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (6)...
QueryFailedError: could not create unique index "UQ_4ed4f8052685ff5b1e7ca1058ba"
    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 ImportAsset1686584273471.up (/usr/src/app/dist/infra/migrations/1686584273471-ImportAsset.js:10: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)

lots of these Unable to connect to the database errors

Alex Tran•2y ago

Can you check this issue? https://github.com/immich-app/immich/issues/2931

GitHub

[BUG] Postgres database failed to start after 1.63.0 update · Issue...

The bug I updated my docker containers this morning to the latest versions and Immich fails to full start (get a 500 error). There are errors in the logs that it cannot connect to the database. So ...

EnderPictureOP•2y ago

thanks, I will try ran

select a."originalPath", count(a.id)
from assets a
group by a."originalPath"
having count(a.id) > 1;

select a."originalPath", count(a.id)
from assets a
group by a."originalPath"
having count(a.id) > 1;

and it is the same FullSizeRender+1.jpg issue but I have tones, what is the ask of step 5?

Here, you can go find those files and pull them aside so we can reupload them after removing them from the database.

I dont think it would be feasible for me to maually find all of them, put it aside, and delete the records 613 instances

Alex Tran•2y ago

If you scroll down a bit more a user provide a query to delete them from the database directly

EnderPictureOP•2y ago

Oh yes thanks, but I should backup the images first so I can reupload it again right?

Gaming

Programming

500 error on server update/bios reset

Did you find this page helpful?