msc5
msc5
PostsComments
IImmich
Created by msc5 on 12/28/2024 in #help-desk-support
How to remigrate or dump "person" table
Well thank you for the help anyways
31 replies
IImmich
Created by msc5 on 12/28/2024 in #help-desk-support
How to remigrate or dump "person" table
I see
31 replies
IImmich
Created by msc5 on 12/28/2024 in #help-desk-support
How to remigrate or dump "person" table
Sorry, one more update. Faces now are working and re-generated, all I have to do is add names back. The immich_postgres services is failing healthcheck though, and here's what happens when I try to run a manual backup: 
> docker exec -t immich_postgres pg_dumpall --clean --if-exists --username=postgres | cat
WARNING:  page verification failed, calculated checksum 16088 but expected 37743
WARNING:  page verification failed, calculated checksum 16088 but expected 37743
pg_dumpall: error: query failed: ERROR:  invalid page in block 0 of relation base/1/1247
pg_dumpall: error: query was: SELECT pg_catalog.set_config('search_path', '', false);
> docker exec -t immich_postgres pg_dumpall --clean --if-exists --username=postgres | cat
WARNING:  page verification failed, calculated checksum 16088 but expected 37743
WARNING:  page verification failed, calculated checksum 16088 but expected 37743
pg_dumpall: error: query failed: ERROR:  invalid page in block 0 of relation base/1/1247
pg_dumpall: error: query was: SELECT pg_catalog.set_config('search_path', '', false);
31 replies
IImmich
Created by msc5 on 12/28/2024 in #help-desk-support
How to remigrate or dump "person" table
immich=# select count(*) from person;
 count
-------
     0
(1 row)

immich=# select count(*) from asset_faces;
 count
-------
   150
(1 row)
immich=# select count(*) from person;
 count
-------
     0
(1 row)

immich=# select count(*) from asset_faces;
 count
-------
   150
(1 row)
31 replies
IImmich
Created by msc5 on 12/28/2024 in #help-desk-support
How to remigrate or dump "person" table
Seems like the table is still empty as well
31 replies
IImmich
Created by msc5 on 12/28/2024 in #help-desk-support
How to remigrate or dump "person" table
Hm, I think that running the "reset" job on face detection results in "No People" being shown on the people page
31 replies
IImmich
Created by msc5 on 12/28/2024 in #help-desk-support
How to remigrate or dump "person" table
I think that's worked. Now I can just re-scan for faces and do that all over again, thanks!
31 replies
IImmich
Created by msc5 on 12/28/2024 in #help-desk-support
How to remigrate or dump "person" table
[Nest] 16  - 12/28/2024, 8:11:15 PM     LOG [Api:EventRepository] Websocket Disconnect: PaIRfDTzJ89uaxtMAAAB
[Nest] 16  - 12/28/2024, 8:11:16 PM     LOG [Api:EventRepository] Websocket Connect:    jW7nWcRVbVyLO-UOAAAD
[Nest] 16  - 12/28/2024, 8:11:21 PM   ERROR [Api:ErrorInterceptor~tjlnfllj] Database error: QueryFailedError: invalid memory alloc request size 18446744057229267712
[Nest] 16  - 12/28/2024, 8:17:51 PM     LOG [Api:EventRepository] Websocket Disconnect: jW7nWcRVbVyLO-UOAAAD
[Nest] 16  - 12/28/2024, 8:17:52 PM     LOG [Api:EventRepository] Websocket Connect:    bdtuGKRLLVZsyVfXAAAF
[Nest] 6  - 12/28/2024, 8:36:16 PM   ERROR [Microservices:JobService] Unable to run job handler (faceDetection/queue-face-detection): QueryFailedError: invalid memory alloc request size 18446744057229267712
[Nest] 6  - 12/28/2024, 8:36:16 PM   ERROR [Microservices:JobService] QueryFailedError: invalid memory alloc request size 18446744057229267712
    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async DeleteQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/DeleteQueryBuilder.js:52:33)
    at async PersonRepository.deleteFaces (/usr/src/app/dist/repositories/person.repository.js:68:9)
    at async PersonService.handleQueueDetectFaces (/usr/src/app/dist/services/person.service.js:194:13)
    at async JobService.onJobStart (/usr/src/app/dist/services/job.service.js:148:28)
    at async EventRepository.onEvent (/usr/src/app/dist/repositories/event.repository.js:134:13)
    at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:394:28)
    at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:581:24)
[Nest] 6  - 12/28/2024, 8:36:16 PM   ERROR [Microservices:JobService] Object:
{
  "force": true
}
[Nest] 16  - 12/28/2024, 8:11:15 PM     LOG [Api:EventRepository] Websocket Disconnect: PaIRfDTzJ89uaxtMAAAB
[Nest] 16  - 12/28/2024, 8:11:16 PM     LOG [Api:EventRepository] Websocket Connect:    jW7nWcRVbVyLO-UOAAAD
[Nest] 16  - 12/28/2024, 8:11:21 PM   ERROR [Api:ErrorInterceptor~tjlnfllj] Database error: QueryFailedError: invalid memory alloc request size 18446744057229267712
[Nest] 16  - 12/28/2024, 8:17:51 PM     LOG [Api:EventRepository] Websocket Disconnect: jW7nWcRVbVyLO-UOAAAD
[Nest] 16  - 12/28/2024, 8:17:52 PM     LOG [Api:EventRepository] Websocket Connect:    bdtuGKRLLVZsyVfXAAAF
[Nest] 6  - 12/28/2024, 8:36:16 PM   ERROR [Microservices:JobService] Unable to run job handler (faceDetection/queue-face-detection): QueryFailedError: invalid memory alloc request size 18446744057229267712
[Nest] 6  - 12/28/2024, 8:36:16 PM   ERROR [Microservices:JobService] QueryFailedError: invalid memory alloc request size 18446744057229267712
    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async DeleteQueryBuilder.execute (/usr/src/app/node_modules/typeorm/query-builder/DeleteQueryBuilder.js:52:33)
    at async PersonRepository.deleteFaces (/usr/src/app/dist/repositories/person.repository.js:68:9)
    at async PersonService.handleQueueDetectFaces (/usr/src/app/dist/services/person.service.js:194:13)
    at async JobService.onJobStart (/usr/src/app/dist/services/job.service.js:148:28)
    at async EventRepository.onEvent (/usr/src/app/dist/repositories/event.repository.js:134:13)
    at async Worker.processJob (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:394:28)
    at async Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/dist/cjs/classes/worker.js:581:24)
[Nest] 6  - 12/28/2024, 8:36:16 PM   ERROR [Microservices:JobService] Object:
{
  "force": true
}
31 replies
IImmich
Created by msc5 on 12/28/2024 in #help-desk-support
How to remigrate or dump "person" table
I believe this fails due to the same error. Here' s the logs:
31 replies
IImmich
Created by msc5 on 12/28/2024 in #help-desk-support
How to remigrate or dump "person" table
When I try to create a backup manually that is
31 replies
IImmich
Created by msc5 on 12/28/2024 in #help-desk-support
How to remigrate or dump "person" table
It doesn’t error out but it only creates a 4Kb file so I’m thinking something else is wrong
31 replies