immich Issue when I upload a picture, or re run Smart search.

The bug

When Immich start smart search (when I upload a picture or I force smart search to work), I get message error in the log. Also, face recognition seems to doesn't work anymore.

`

The OS that Immich Server is running on

Debian bookworm on PI5

Version of Immich Server

v1.126.1

Version of Immich Mobile App

1.126.1 Build.184

Platform with the issue

[x] Server
[ ] Web
[ ] Mobile

Your docker-compose.yml content

#
# WARNING: Make sure to use the docker-compose.yml of the current release:
#
# https://github.com/immich-app/immich/releases/latest/download/docker-compose.yml
#
# The compose file on main may not be compatible with the latest release.
#

name: immich

services:
  immich-server:
    container_name: immich_server
    image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
    # extends:
    #   file: hwaccel.transcoding.yml
    #   service: cpu # set to one of [nvenc, quicksync, rkmpp, vaapi, vaapi-wsl] for accelerated transcoding
    volumes:
      # Do not edit the next line. If you want to change the media storage location on your system, edit the value of UPLOAD_LOCATION in the .env file
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
      - /etc/localtime:/etc/localtime:ro
    env_file:
      - .env
    ports:
      - 2283:2283
    depends_on:
      - redis
      - database
    restart: always
    healthcheck:
      disable: false

  immich-machine-learning:
    container_name: immich_machine_learning
    # For hardware acceleration, add one of -[armnn, cuda, openvino] to the image tag.
    # Example tag: ${IMMICH_VERSION:-release}-cuda
    image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}
    # extends: # uncomment this section for hardware acceleration - see https://immich.app/docs/features/ml-hardware-acceleration
    #   file: hwaccel.ml.yml
    #   service: cpu # set to one of [armnn, cuda, openvino, openvino-wsl] for accelerated inference - use the `-wsl` version for WSL2 where applicable
    volumes:
      - model-cache:/cache
    env_file:
      - .env
    restart: always
    healthcheck:
      disable: false

  redis:
    container_name: immich_redis
    image: docker.io/redis:6.2-alpine@sha256:2d1463258f2764328496376f5d965f20c6a67f66ea2b06dc42af351f75248792
    healthcheck:
      test: redis-cli ping || exit 1
    restart: always

  database:
    container_name: immich_postgres
    image: docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0
    environment:
      POSTGRES_PASSWORD: ${DB_PASSWORD}
      POSTGRES_USER: ${DB_USERNAME}
      POSTGRES_DB: ${DB_DATABASE_NAME}
      POSTGRES_INITDB_ARGS: '--data-checksums'
    volumes:
      # Do not edit the next line. If you want to change the database storage location on your system, edit the value of DB_DATA_LOCATION in the .env file
      - ${DB_DATA_LOCATION}:/var/lib/postgresql/data
    healthcheck:
      test: pg_isready --dbname='${DB_DATABASE_NAME}' --username='${DB_USERNAME}' || exit 1; Chksum="$$(psql --dbname='${DB_DATABASE_NAME}' --username='${DB_USERNAME}' --tuples-only --no-align --command='SELECT COALESCE(SUM(checksum_failures), 0) FROM pg_stat_database')"; echo "checksum failure count is $$Chksum"; [ "$$Chksum" = '0' ] || exit 1
      interval: 5m
      start_interval: 30s
      start_period: 5m
    command: ["postgres", "-c", "shared_preload_libraries=vectors.so", "-c", 'search_path="$$user", public, vectors', "-c", "logging_collector=on", "-c", "max_wal_size=2GB", "-c", "shared_buffers=512MB", "-c", "wal_compression=on"]
    restart: always

volumes:
  model-cache:

Your .env content

# You can find documentation for all the supported env variables at https://immich.app/docs/install/environment-variables

# The location where your uploaded files are stored
UPLOAD_LOCATION=/srv/dev-disk-by-uuid-ad367a2e-4c8a-4c56-90ba-27ca2aae78bb/ImmichLibrary
# The location where your database files are stored
DB_DATA_LOCATION=/srv/dev-disk-by-uuid-ad367a2e-4c8a-4c56-90ba-27ca2aae78bb/postgres

# To set a timezone, uncomment the next line and change Etc/UTC to a TZ identifier from this list: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones#List
# TZ=Etc/UTC

# The Immich version to use. You can pin this to a specific version like "v1.71.0"
IMMICH_VERSION=release

# Connection secret for postgres. You should change it to a random password
# Please use only the characters `A-Za-z0-9`, without special characters or spaces
DB_PASSWORD=SECRETPASS

# The values below this line do not need to be changed
###################################################################################
DB_USERNAME=xavier
DB_DATABASE_NAME=immich

Reproduction steps

UPload a picture

...

Relevant log output

`Query failed : {
  durationMs: 1.283739984035492,
  error: PostgresError: pgvecto.rs: Bad literal.
  INFORMATION: hint = Bad number.
      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:524: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) {
    severity_local: 'ERROR',
    severity: 'ERROR',
    code: 'XX000',
    where: "unnamed portal parameter $2 = '...'",
    file: 'error.rs',
    line: '7'
  },
  sql: 'insert into "smart_search" ("assetId", "embedding") values ($1::uuid, $2) on conflict ("assetId") do update set "embedding" = $3',
  params: [
    '0ad80e7b-d065-46fa-a532-14d178847af5',
    '[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]',
    '[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]'
  ]
}
[Nest] 7  - 02/17/2025, 4:50:02 PM   ERROR [Microservices:JobService] Unable to run job handler (smartSearch/smart-search): PostgresError: pgvecto.rs: Bad literal.
INFORMATION: hint = Bad number.
[Nest] 7  - 02/17/2025, 4:50:02 PM   ERROR [Microservices:JobService] PostgresError: pgvecto.rs: Bad literal.
INFORMATION: hint = Bad number.
    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:524: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)
[Nest] 7  - 02/17/2025, 4:50:02 PM   ERROR [Microservices:JobService] Object(1) {
  id: '0ad80e7b-d065-46fa-a532-14d178847af5'
}

Additional information

No response

Feb 17 '25 17:02 Reivax47

Are you using remote machine learning? Also validate all your ML containers are on the lastest version.

Feb 17 '25 17:02 schuhbacca

Are you using remote machine learning? Also validate all your ML containers are on the lastest version.

Hi ! I'am not using remote machine learning (At least, I'haven't done any setup in that way). I've update all the container before posting this message.

Feb 17 '25 17:02 Reivax47

Are you using the default models?

Feb 17 '25 17:02 alextran1502

Yes, I am. I've reset this set-up in case of...

Le lun. 17 févr. 2025 à 18:30, Alex @.***> a écrit :

Are you using the default models?

— Reply to this email directly, view it on GitHub https://github.com/immich-app/immich/issues/16163#issuecomment-2663731323, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALKT5RDAOKML75BPWKGUOA32QIMB3AVCNFSM6AAAAABXJ2ISU2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMNRTG4ZTCMZSGM . You are receiving this because you authored the thread.Message ID: @.***> [image: alextran1502]alextran1502 left a comment (immich-app/immich#16163) https://github.com/immich-app/immich/issues/16163#issuecomment-2663731323

Are you using the default models?

— Reply to this email directly, view it on GitHub https://github.com/immich-app/immich/issues/16163#issuecomment-2663731323, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALKT5RDAOKML75BPWKGUOA32QIMB3AVCNFSM6AAAAABXJ2ISU2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMNRTG4ZTCMZSGM . You are receiving this because you authored the thread.Message ID: @.***>

Feb 17 '25 17:02 Reivax47

Can you post the full logs from all your containers?

Feb 17 '25 17:02 bo0tzz

The multiple 'null' value in the sql query are very strange. Any idea where that could come from ?

Feb 17 '25 17:02 Reivax47

It means the machine-learning might not work properly on your system for some reasons, so the information that the database expected in the query is not there

Feb 17 '25 17:02 alextran1502

Do you mind spin up a new instance with a stock setup and try again?

Feb 17 '25 17:02 alextran1502

Can you post the full logs from all your containers?

Redis container : 1:M 17 Feb 2025 13:23:42.050 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 13:23:42.050 * Background saving started by pid 64098 64098:C 17 Feb 2025 13:23:42.144 * DB saved on disk 64098:C 17 Feb 2025 13:23:42.144 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 13:23:42.151 * Background saving terminated with success 1:M 17 Feb 2025 13:28:43.045 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 13:28:43.045 * Background saving started by pid 64176 64176:C 17 Feb 2025 13:28:43.185 * DB saved on disk 64176:C 17 Feb 2025 13:28:43.185 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 13:28:43.246 * Background saving terminated with success 1:M 17 Feb 2025 13:33:44.060 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 13:33:44.061 * Background saving started by pid 64247 64247:C 17 Feb 2025 13:33:44.154 * DB saved on disk 64247:C 17 Feb 2025 13:33:44.154 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 13:33:44.161 * Background saving terminated with success 1:M 17 Feb 2025 13:38:45.063 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 13:38:45.063 * Background saving started by pid 64318 64318:C 17 Feb 2025 13:38:45.157 * DB saved on disk 64318:C 17 Feb 2025 13:38:45.157 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 13:38:45.164 * Background saving terminated with success 1:M 17 Feb 2025 13:43:46.070 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 13:43:46.070 * Background saving started by pid 64389 64389:C 17 Feb 2025 13:43:46.164 * DB saved on disk 64389:C 17 Feb 2025 13:43:46.164 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 13:43:46.171 * Background saving terminated with success 1:M 17 Feb 2025 13:48:47.081 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 13:48:47.082 * Background saving started by pid 64460 64460:C 17 Feb 2025 13:48:47.174 * DB saved on disk 64460:C 17 Feb 2025 13:48:47.174 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 13:48:47.182 * Background saving terminated with success 1:M 17 Feb 2025 13:53:48.002 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 13:53:48.002 * Background saving started by pid 64531 64531:C 17 Feb 2025 13:53:48.132 * DB saved on disk 64531:C 17 Feb 2025 13:53:48.132 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 13:53:48.203 * Background saving terminated with success 1:M 17 Feb 2025 13:58:49.095 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 13:58:49.095 * Background saving started by pid 64602 64602:C 17 Feb 2025 13:58:49.190 * DB saved on disk 64602:C 17 Feb 2025 13:58:49.190 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 13:58:49.195 * Background saving terminated with success 1:M 17 Feb 2025 14:03:50.028 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:03:50.029 * Background saving started by pid 64673 64673:C 17 Feb 2025 14:03:50.124 * DB saved on disk 64673:C 17 Feb 2025 14:03:50.124 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:03:50.129 * Background saving terminated with success 1:M 17 Feb 2025 14:08:51.040 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:08:51.041 * Background saving started by pid 64744 64744:C 17 Feb 2025 14:08:51.136 * DB saved on disk 64744:C 17 Feb 2025 14:08:51.136 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:08:51.141 * Background saving terminated with success 1:M 17 Feb 2025 14:13:52.042 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:13:52.042 * Background saving started by pid 64815 64815:C 17 Feb 2025 14:13:52.185 * DB saved on disk 64815:C 17 Feb 2025 14:13:52.185 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:13:52.243 * Background saving terminated with success 1:M 17 Feb 2025 14:18:53.045 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:18:53.046 * Background saving started by pid 64886 64886:C 17 Feb 2025 14:18:53.141 * DB saved on disk 64886:C 17 Feb 2025 14:18:53.141 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:18:53.146 * Background saving terminated with success 1:M 17 Feb 2025 14:23:54.040 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:23:54.040 * Background saving started by pid 64957 64957:C 17 Feb 2025 14:23:54.135 * DB saved on disk 64957:C 17 Feb 2025 14:23:54.135 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:23:54.141 * Background saving terminated with success 1:M 17 Feb 2025 14:28:55.049 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:28:55.050 * Background saving started by pid 65028 65028:C 17 Feb 2025 14:28:55.141 * DB saved on disk 65028:C 17 Feb 2025 14:28:55.141 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:28:55.150 * Background saving terminated with success 1:M 17 Feb 2025 14:33:56.072 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:33:56.073 * Background saving started by pid 65100 65100:C 17 Feb 2025 14:33:56.168 * DB saved on disk 65100:C 17 Feb 2025 14:33:56.168 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:33:56.173 * Background saving terminated with success 1:M 17 Feb 2025 14:38:57.066 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:38:57.067 * Background saving started by pid 65172 65172:C 17 Feb 2025 14:38:57.202 * DB saved on disk 65172:C 17 Feb 2025 14:38:57.202 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:38:57.268 * Background saving terminated with success 1:M 17 Feb 2025 14:43:58.080 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:43:58.081 * Background saving started by pid 65243 65243:C 17 Feb 2025 14:43:58.175 * DB saved on disk 65243:C 17 Feb 2025 14:43:58.176 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:43:58.181 * Background saving terminated with success 1:M 17 Feb 2025 14:48:59.094 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:48:59.095 * Background saving started by pid 65314 65314:C 17 Feb 2025 14:48:59.186 * DB saved on disk 65314:C 17 Feb 2025 14:48:59.186 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:48:59.195 * Background saving terminated with success 1:M 17 Feb 2025 14:54:00.002 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:54:00.002 * Background saving started by pid 65385 65385:C 17 Feb 2025 14:54:00.096 * DB saved on disk 65385:C 17 Feb 2025 14:54:00.096 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:54:00.103 * Background saving terminated with success 1:M 17 Feb 2025 14:59:01.013 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 14:59:01.013 * Background saving started by pid 65456 65456:C 17 Feb 2025 14:59:01.107 * DB saved on disk 65456:C 17 Feb 2025 14:59:01.107 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 14:59:01.114 * Background saving terminated with success 1:M 17 Feb 2025 15:04:02.032 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:04:02.032 * Background saving started by pid 65527 65527:C 17 Feb 2025 15:04:02.151 * DB saved on disk 65527:C 17 Feb 2025 15:04:02.151 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:04:02.233 * Background saving terminated with success 1:M 17 Feb 2025 15:09:03.034 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:09:03.034 * Background saving started by pid 65598 65598:C 17 Feb 2025 15:09:03.128 * DB saved on disk 65598:C 17 Feb 2025 15:09:03.128 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:09:03.135 * Background saving terminated with success 1:M 17 Feb 2025 15:14:04.033 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:14:04.033 * Background saving started by pid 65669 65669:C 17 Feb 2025 15:14:04.127 * DB saved on disk 65669:C 17 Feb 2025 15:14:04.127 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:14:04.133 * Background saving terminated with success 1:M 17 Feb 2025 15:19:05.054 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:19:05.054 * Background saving started by pid 65740 65740:C 17 Feb 2025 15:19:05.148 * DB saved on disk 65740:C 17 Feb 2025 15:19:05.148 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:19:05.155 * Background saving terminated with success 1:M 17 Feb 2025 15:24:06.062 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:24:06.063 * Background saving started by pid 65811 65811:C 17 Feb 2025 15:24:06.208 * DB saved on disk 65811:C 17 Feb 2025 15:24:06.208 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:24:06.264 * Background saving terminated with success 1:M 17 Feb 2025 15:29:07.057 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:29:07.058 * Background saving started by pid 65882 65882:C 17 Feb 2025 15:29:07.149 * DB saved on disk 65882:C 17 Feb 2025 15:29:07.150 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:29:07.158 * Background saving terminated with success 1:M 17 Feb 2025 15:34:08.057 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:34:08.057 * Background saving started by pid 65953 65953:C 17 Feb 2025 15:34:08.152 * DB saved on disk 65953:C 17 Feb 2025 15:34:08.152 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:34:08.158 * Background saving terminated with success 1:M 17 Feb 2025 15:39:09.070 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:39:09.070 * Background saving started by pid 66024 66024:C 17 Feb 2025 15:39:09.164 * DB saved on disk 66024:C 17 Feb 2025 15:39:09.164 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:39:09.171 * Background saving terminated with success 1:M 17 Feb 2025 15:44:10.076 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:44:10.076 * Background saving started by pid 66095 66095:C 17 Feb 2025 15:44:10.168 * DB saved on disk 66095:C 17 Feb 2025 15:44:10.169 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:44:10.176 * Background saving terminated with success 1:M 17 Feb 2025 15:49:11.005 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:49:11.005 * Background saving started by pid 66166 66166:C 17 Feb 2025 15:49:11.136 * DB saved on disk 66166:C 17 Feb 2025 15:49:11.136 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:49:11.206 * Background saving terminated with success 1:M 17 Feb 2025 15:54:12.009 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:54:12.010 * Background saving started by pid 66238 66238:C 17 Feb 2025 15:54:12.103 * DB saved on disk 66238:C 17 Feb 2025 15:54:12.103 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:54:12.110 * Background saving terminated with success 1:M 17 Feb 2025 15:59:13.031 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 15:59:13.032 * Background saving started by pid 66309 66309:C 17 Feb 2025 15:59:13.125 * DB saved on disk 66309:C 17 Feb 2025 15:59:13.125 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 15:59:13.132 * Background saving terminated with success 1:M 17 Feb 2025 16:02:48.463 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:02:48.464 * Background saving started by pid 66359 66359:C 17 Feb 2025 16:02:48.570 * DB saved on disk 66359:C 17 Feb 2025 16:02:48.571 * RDB: 4 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:02:48.666 * Background saving terminated with success 1:M 17 Feb 2025 16:03:49.039 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:03:49.040 * Background saving started by pid 66374 66374:C 17 Feb 2025 16:03:49.215 * DB saved on disk 66374:C 17 Feb 2025 16:03:49.215 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:03:49.242 * Background saving terminated with success 1:M 17 Feb 2025 16:04:50.021 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:04:50.021 * Background saving started by pid 66389 66389:C 17 Feb 2025 16:04:50.115 * DB saved on disk 66389:C 17 Feb 2025 16:04:50.115 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:04:50.121 * Background saving terminated with success 1:M 17 Feb 2025 16:09:51.080 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 16:09:51.080 * Background saving started by pid 66460 66460:C 17 Feb 2025 16:09:51.180 * DB saved on disk 66460:C 17 Feb 2025 16:09:51.180 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:09:51.181 * Background saving terminated with success 1:M 17 Feb 2025 16:12:13.491 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:12:13.491 * Background saving started by pid 66496 66496:C 17 Feb 2025 16:12:13.653 * DB saved on disk 66496:C 17 Feb 2025 16:12:13.653 * RDB: 4 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:12:13.693 * Background saving terminated with success 1:M 17 Feb 2025 16:13:14.063 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:13:14.064 * Background saving started by pid 66511 66511:C 17 Feb 2025 16:13:14.159 * DB saved on disk 66511:C 17 Feb 2025 16:13:14.159 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:13:14.165 * Background saving terminated with success 1:M 17 Feb 2025 16:14:15.005 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:14:15.006 * Background saving started by pid 66526 66526:C 17 Feb 2025 16:14:15.164 * DB saved on disk 66526:C 17 Feb 2025 16:14:15.165 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:14:15.207 * Background saving terminated with success 1:M 17 Feb 2025 16:15:16.077 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:15:16.078 * Background saving started by pid 66541 66541:C 17 Feb 2025 16:15:16.172 * DB saved on disk 66541:C 17 Feb 2025 16:15:16.173 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:15:16.178 * Background saving terminated with success 1:M 17 Feb 2025 16:20:17.054 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 16:20:17.054 * Background saving started by pid 66612 66612:C 17 Feb 2025 16:20:17.154 * DB saved on disk 66612:C 17 Feb 2025 16:20:17.154 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:20:17.155 * Background saving terminated with success 1:M 17 Feb 2025 16:22:31.725 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:22:31.725 * Background saving started by pid 66641 66641:C 17 Feb 2025 16:22:31.849 * DB saved on disk 66641:C 17 Feb 2025 16:22:31.849 * RDB: 4 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:22:31.941 * Background saving terminated with success 1:M 17 Feb 2025 16:23:32.021 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:23:32.021 * Background saving started by pid 66656 66656:C 17 Feb 2025 16:23:32.215 * DB saved on disk 66656:C 17 Feb 2025 16:23:32.215 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:23:32.222 * Background saving terminated with success 1:M 17 Feb 2025 16:28:33.060 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 16:28:33.060 * Background saving started by pid 66728 66728:C 17 Feb 2025 16:28:33.177 * DB saved on disk 66728:C 17 Feb 2025 16:28:33.177 * RDB: 1 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:28:33.261 * Background saving terminated with success 1:M 17 Feb 2025 16:31:27.690 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:31:27.690 * Background saving started by pid 66771 66771:C 17 Feb 2025 16:31:27.804 * DB saved on disk 66771:C 17 Feb 2025 16:31:27.804 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:31:27.894 * Background saving terminated with success 1:M 17 Feb 2025 16:32:28.062 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:32:28.064 * Background saving started by pid 66786 66786:C 17 Feb 2025 16:32:28.393 * DB saved on disk 66786:C 17 Feb 2025 16:32:28.393 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:32:28.470 * Background saving terminated with success 1:M 17 Feb 2025 16:33:29.021 * 10000 changes in 60 seconds. Saving... 1:M 17 Feb 2025 16:33:29.022 * Background saving started by pid 66801 66801:C 17 Feb 2025 16:33:29.553 * DB saved on disk 66801:C 17 Feb 2025 16:33:29.553 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:33:29.625 * Background saving terminated with success 1:M 17 Feb 2025 16:38:30.077 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 16:38:30.077 * Background saving started by pid 66870 66870:C 17 Feb 2025 16:38:30.572 * DB saved on disk 66870:C 17 Feb 2025 16:38:30.572 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:38:30.581 * Background saving terminated with success 1:M 17 Feb 2025 16:43:31.058 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 16:43:31.059 * Background saving started by pid 66941 66941:C 17 Feb 2025 16:43:31.479 * DB saved on disk 66941:C 17 Feb 2025 16:43:31.479 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:43:31.562 * Background saving terminated with success 1:M 17 Feb 2025 16:48:32.070 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 16:48:32.071 * Background saving started by pid 67010 67010:C 17 Feb 2025 16:48:32.508 * DB saved on disk 67010:C 17 Feb 2025 16:48:32.509 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:48:32.573 * Background saving terminated with success 1:M 17 Feb 2025 16:53:33.037 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 16:53:33.037 * Background saving started by pid 67080 67080:C 17 Feb 2025 16:53:33.409 * DB saved on disk 67080:C 17 Feb 2025 16:53:33.410 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:53:33.438 * Background saving terminated with success 1:M 17 Feb 2025 16:58:34.092 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 16:58:34.093 * Background saving started by pid 67151 67151:C 17 Feb 2025 16:58:34.494 * DB saved on disk 67151:C 17 Feb 2025 16:58:34.495 * RDB: 3 MB of memory used by copy-on-write 1:M 17 Feb 2025 16:58:34.594 * Background saving terminated with success 1:M 17 Feb 2025 17:03:35.013 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 17:03:35.014 * Background saving started by pid 67222 67222:C 17 Feb 2025 17:03:35.431 * DB saved on disk 67222:C 17 Feb 2025 17:03:35.431 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 17:03:35.515 * Background saving terminated with success 1:M 17 Feb 2025 17:08:36.067 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 17:08:36.069 * Background saving started by pid 67293 67293:C 17 Feb 2025 17:08:36.426 * DB saved on disk 67293:C 17 Feb 2025 17:08:36.427 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 17:08:36.470 * Background saving terminated with success 1:M 17 Feb 2025 17:13:37.050 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 17:13:37.050 * Background saving started by pid 67363 67363:C 17 Feb 2025 17:13:37.463 * DB saved on disk 67363:C 17 Feb 2025 17:13:37.466 * RDB: 3 MB of memory used by copy-on-write 1:M 17 Feb 2025 17:13:37.552 * Background saving terminated with success 1:M 17 Feb 2025 17:18:38.051 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 17:18:38.052 * Background saving started by pid 67433 67433:C 17 Feb 2025 17:18:38.376 * DB saved on disk 67433:C 17 Feb 2025 17:18:38.377 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 17:18:38.454 * Background saving terminated with success 1:M 17 Feb 2025 17:23:39.046 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 17:23:39.047 * Background saving started by pid 67503 67503:C 17 Feb 2025 17:23:39.407 * DB saved on disk 67503:C 17 Feb 2025 17:23:39.408 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 17:23:39.456 * Background saving terminated with success 1:M 17 Feb 2025 17:28:40.050 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 17:28:40.050 * Background saving started by pid 67574 67574:C 17 Feb 2025 17:28:40.395 * DB saved on disk 67574:C 17 Feb 2025 17:28:40.395 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 17:28:40.453 * Background saving terminated with success 1:M 17 Feb 2025 17:33:41.049 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 17:33:41.051 * Background saving started by pid 67646 67646:C 17 Feb 2025 17:33:41.425 * DB saved on disk 67646:C 17 Feb 2025 17:33:41.426 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 17:33:41.452 * Background saving terminated with success 1:M 17 Feb 2025 17:38:42.088 * 100 changes in 300 seconds. Saving... 1:M 17 Feb 2025 17:38:42.088 * Background saving started by pid 67717 67717:C 17 Feb 2025 17:38:42.472 * DB saved on disk 67717:C 17 Feb 2025 17:38:42.473 * RDB: 2 MB of memory used by copy-on-write 1:M 17 Feb 2025 17:38:42.491 * Background saving terminated with success

Postgres : `xavier@pinas:~/immich-app $ docker logs immich_postgres The files belonging to this database system will be owned by user "postgres". This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english".

Data page checksums are enabled.

fixing permissions on existing directory /var/lib/postgresql/data ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok initdb: warning: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. syncing data to disk ... ok

Success. You can now start the database server using:

pg_ctl -D /var/lib/postgresql/data -l logfile start

waiting for server to start....2024-10-06 15:47:19.493 UTC [48] LOG: redirecting log output to logging collector process 2024-10-06 15:47:19.493 UTC [48] HINT: Future log output will appear in directory "log". done server started CREATE DATABASE

/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

waiting for server to shut down.... done server stopped

PostgreSQL init process complete; ready for start up.

2024-10-06 15:47:20.452 UTC [1] LOG: redirecting log output to logging collector process 2024-10-06 15:47:20.452 UTC [1] HINT: Future log output will appear in directory "log".