Yas
IImmich
•Created by Yas on 1/9/2025 in #help-desk-support
PG_Toast error
Any idea why I am receiving this error?
[Nest] 7 - 01/10/2025, 1:13:54 AM WARN [Microservices:MetadataService] Asset 4b30b2f0-9bb4-4337-b234-f6522d159c02 has no time zone information
[Nest] 7 - 01/10/2025, 1:13:58 AM ERROR [Microservices:JobService] Unable to run job handler (sidecar/sidecar-sync): Error: timeout exceeded when trying to connect
[Nest] 7 - 01/10/2025, 1:13:58 AM ERROR [Microservices:JobService] Error: timeout exceeded when trying to connect
at Timeout._onTimeout (/usr/src/app/node_modules/pg-pool/index.js:205:27)
at listOnTimeout (node:internal/timers:594:17)
at process.processTimers (node:internal/timers:529:7)
[Nest] 7 - 01/10/2025, 1:13:58 AM ERROR [Microservices:JobService] Object:
{
"id": "f16efd46-66b4-487e-ab51-a00e6f59bcc0"
}
[Nest] 7 - 01/10/2025, 1:13:59 AM WARN [Microservices:MetadataService] Asset 102fa9f2-f3aa-45b5-916f-627a492261cb has no time zone information
[Nest] 7 - 01/10/2025, 1:14:00 AM WARN [Microservices:MetadataService] Asset bae050e4-6d3e-4074-8e82-7a9b33d9af55 has no time zone information
[Nest] 7 - 01/10/2025, 1:14:00 AM WARN [Microservices:MetadataService] Asset f5ae8e07-731d-4fd3-930c-dd3092d10e5e has no time zone information
[Nest] 7 - 01/10/2025, 1:14:01 AM WARN [Microservices:MetadataService] Asset 3315fea7-3cb4-40e4-91b7-fcd941c456e2 has no time zone information
[Nest] 7 - 01/10/2025, 1:14:05 AM WARN [Microservices:MetadataService] Asset d6d95453-7544-44e7-a2b9-2d30f6b44555 has no time zone information
[Nest] 7 - 01/10/2025, 1:14:10 AM WARN [Microservices:MetadataService] Asset 8052ca94-1898-49d8-a4e4-6bad26cbbf86 has no time zone information
[Nest] 7 - 01/10/2025, 1:14:11 AM WARN [Microservices:MetadataService] Asset f9505c33-1a77-487f-977c-d14554571752 has no time zone information
[Nest] 7 - 01/10/2025, 1:14:14 AM ERROR [Microservices:JobService] Unable to run job handler (sidecar/sidecar-sync): Error: Connection terminated due to connection timeout
[Nest] 7 - 01/10/2025, 1:14:14 AM ERROR [Microservices:JobService] Error: Connection terminated due to connection timeout
at Connection.<anonymous> (/usr/src/app/node_modules/pg/lib/client.js:131:73)
at Object.onceWrapper (node:events:638:28)
at Connection.emit (node:events:524:28)
at Socket.<anonymous> (/usr/src/app/node_modules/pg/lib/connection.js:62:12)
at Socket.emit (node:events:524:28)
at TCP.<anonymous> (node:net:350:12)
[Nest] 7 - 01/10/2025, 1:14:14 AM ERROR [Microservices:JobService] Object:
{
"id": "6452ece5-19a9-4d84-8434-486b8351385a"
}
[Nest] 7 - 01/10/2025, 1:14:19 AM WARN [Microservices:MetadataService] Asset cf3756b7-8b3b-4c0c-be15-66096bebacb6 has no time zone information
[Nest] 7 - 01/10/2025, 1:14:21 AM ERROR [Microservices:JobService] Unable to run job handler (sidecar/sidecar-sync): Error: Connection terminated due to connection timeout
[Nest] 7 - 01/10/2025, 1:14:21 AM ERROR [Microservices:JobService] Error: Connection terminated due to connection timeout
at Connection.<anonymous> (/usr/src/app/node_modules/pg/lib/client.js:131:73)
at Object.onceWrapper (node:events:638:28)
at Connection.emit (node:events:524:28)
at Socket.<anonymous> (/usr/src/app/node_modules/pg/lib/connection.js:62:12)
at Socket.emit (node:events:524:28)
at TCP.<anonymous> (node:net:350:12)
[Nest] 7 - 01/10/2025, 1:14:21 AM ERROR [Microservices:JobService] Object:
{
"id": "9dec3477-40c9-4d4d-892e-d072d2c06072"
}
23 replies
IImmich
•Created by Yas on 1/9/2025 in #help-desk-support
PG_Toast error
issue fixed, thanks a lot @bo0tzz
23 replies
IImmich
•Created by Yas on 1/9/2025 in #help-desk-support
PG_Toast error
need to figureout where is the db_data_location - found it, thanks will update if the issue persists
23 replies
IImmich
•Created by Yas on 1/9/2025 in #help-desk-support
PG_Toast error
Sorry for the noob question, but can you point out in the guide where I can see how to clear the database properly before restoring a backup?
23 replies
IImmich
•Created by Yas on 1/9/2025 in #help-desk-support
PG_Toast error
I am not sure what to do now as I already uploaded 1.4TB of my files, photos, videos to my immich server
23 replies
IImmich
•Created by Yas on 1/9/2025 in #help-desk-support
PG_Toast error
Yes, I did it like 4x already
23 replies
IImmich
•Created by Yas on 1/9/2025 in #help-desk-support
PG_Toast error
Power went out earlier, when I turned on my server the uploaded files are not loading - so I tried restoring a backup but still receiving the same error
[Nest] 16 - 01/09/2025, 4:56:37 PM ERROR [Api:ErrorInterceptor~74564fkl] Database error: QueryFailedError: missing chunk number 0 for toast value 93227 in pg_toast_2619
[Nest] 16 - 01/09/2025, 4:56:37 PM ERROR [Api:ErrorInterceptor~2dmf3bgh] Database error: QueryFailedError: missing chunk number 0 for toast value 93227 in pg_toast_2619
[Nest] 16 - 01/09/2025, 4:56:37 PM ERROR [Api:ErrorInterceptor~3p3l8aan] Database error: QueryFailedError: missing chunk number 0 for toast value 93227 in pg_toast_2619
[Nest] 16 - 01/09/2025, 4:56:37 PM ERROR [Api:ErrorInterceptor~yvxzrmv5] Database error: QueryFailedError: missing chunk number 0 for toast value 93227 in pg_toast_2619
23 replies
