© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
ImmichI
Immich•8mo ago•
3 replies
Ldz

PostgresError: column assets.isVisible does not exist

Tried to restore a backup I had after I accidently deleted my cluster.

gunzip --stdout "/mnt/ssd/immich/data/backups/immich-db-backup-1751853600088.sql.gz" | sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" | k exec -ti immich-postgresql-0 -- psql --dbname=immich --username=immich
gunzip --stdout "/mnt/ssd/immich/data/backups/immich-db-backup-1751853600088.sql.gz" | sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" | k exec -ti immich-postgresql-0 -- psql --dbname=immich --username=immich


started the server and getting this :

sql: `with "assets" as (select date_trunc($1, "localDateTime" at time zone 'UTC') at time zone 'UTC' as "timeBucket" from "assets" left join "asset_stack" on "asset_stack"."id" = "assets"."stackId" and "asset_stack"."primaryAssetId" = "assets"."id" where "assets"."deletedAt" is null and "assets"."isVisible" = $2 and "assets"."fileCreatedAt" is not null and "assets"."fileModifiedAt" is not null and "assets"."localDateTime" is not null and ("assets"."stackId" is null or "asset_stack" is not null) and "assets"."ownerId" = any($3::uuid[]) and "assets"."isArchived" = $4) select "timeBucket", count(*) as "count" from "assets" group by "timeBucket" order by "timeBucket" desc`,
  params: [ 'MONTH', true, '{514ba18c-fe2f-487a-ad54-4a701506b5ad}', false ]
}
[Nest] 17  - 07/09/2025, 5:47:00 PM   ERROR [Api:ErrorInterceptor~k7r992zj] Unknown error: PostgresError: column assets.isVisible does not exist
PostgresError: column assets.isVisible does not exist
    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:788:26)
    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:474:6)
    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)
sql: `with "assets" as (select date_trunc($1, "localDateTime" at time zone 'UTC') at time zone 'UTC' as "timeBucket" from "assets" left join "asset_stack" on "asset_stack"."id" = "assets"."stackId" and "asset_stack"."primaryAssetId" = "assets"."id" where "assets"."deletedAt" is null and "assets"."isVisible" = $2 and "assets"."fileCreatedAt" is not null and "assets"."fileModifiedAt" is not null and "assets"."localDateTime" is not null and ("assets"."stackId" is null or "asset_stack" is not null) and "assets"."ownerId" = any($3::uuid[]) and "assets"."isArchived" = $4) select "timeBucket", count(*) as "count" from "assets" group by "timeBucket" order by "timeBucket" desc`,
  params: [ 'MONTH', true, '{514ba18c-fe2f-487a-ad54-4a701506b5ad}', false ]
}
[Nest] 17  - 07/09/2025, 5:47:00 PM   ERROR [Api:ErrorInterceptor~k7r992zj] Unknown error: PostgresError: column assets.isVisible does not exist
PostgresError: column assets.isVisible does not exist
    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:788:26)
    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:474:6)
    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)
ImmichJoin
A place to hang out, get support, discuss Immich, get announcements about releases and anything else going on.
36,590Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

postgreserror isVisible
ImmichIImmich / help-desk-support
7mo ago
PostgresError: operator does not exists
ImmichIImmich / help-desk-support
10mo ago
Postgres column does not exist after restore.
ImmichIImmich / help-desk-support
6mo ago
HTTP 500 Error After Container Restart – Missing isVisible Column in assets Table
ImmichIImmich / help-desk-support
7mo ago