PostgreSQL database failure after v1.106 upgrade attempt #3082

New issue

Closed

opened 2026-02-20 02:03:57 -05:00 by deekerman · 0 comments

deekerman commented 2026-02-20 02:03:57 -05:00

Owner

Copy link

Originally created by @iamtherobin on GitHub (Jun 12, 2024).

The bug

I tried to upgrade from v1.105.1 to v1.106.2 by following modifying the yaml file accordingly and pulling the new images. The result was restarting immich server container. Then I tried reverting back to v1.105.1 but now I am getting a postgres container error. I cannot get either v1.105.1 or newer to load anymore.

I am currently trying to load v1.106.3 and postgres keeps restarting at "PostgreSQL Database directory appears to contain a database". Both postgres and server container repeat the error shown in the docker log.

I also attached the postgres logs from the database log folder. The postgres start from where I attempted the v1.106 update upto the point where it just keeps repeating.

The OS that Immich Server is running on

Arch, kernel 6.8.9

Version of Immich Server

v1.106.3

Version of Immich Mobile App

latest

Platform with the issue

• 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:
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
      - /etc/localtime:/etc/localtime:ro
    env_file:
      - .env
    ports:
      - 2283:3001
    depends_on:
      - redis
      - database
    restart: unless-stopped
    networks:
      - immich

  immich-machine-learning:
    container_name: immich-machinelearning
    # 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
    networks:
      - immich

  redis:
    container_name: immich-redis
    image: docker.io/redis:6.2-alpine@sha256:d6c2911ac51b289db208767581a5d154544f2b2fe4914ea5056443f62dc6e900
    healthcheck:
      test: redis-cli ping || exit 1
    restart: always
    networks:
      - immich

  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:
      - ${DB_DATA_LOCATION}:/var/lib/postgresql/data
    healthcheck:
      test: pg_isready --dbname='${DB_DATABASE_NAME}' || 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
    networks:
      - immich
      
volumes:
  model-cache:

networks:
  immich:
    name: immich
    enable_ipv6: true
    ipam:
      config:
        - subnet: fd12:3456:7890:3::/64
          gateway: fd12:3456:7890:3::1

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=/hdd-storage/immich/library
# The location where your database files are stored
DB_DATA_LOCATION=/hdd-storage/immich/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=America/Toronto

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

# Connection secret for postgres. You should change it to a random password
DB_PASSWORD=postgres

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

Reproduction steps

1.
2.
3.
...

Relevant log output

[robin@lab immich]$ sudo docker compose -f docker-compose-immich.yaml pull
[+] Pulling 4/4
 ✔ immich-machine-learning Pulled                                                                                                                                                                                                1.3s
 ✔ database Pulled                                                                                                                                                                                                               2.3s
 ✔ redis Pulled                                                                                                                                                                                                                  1.0s
 ✔ immich-server Pulled                                                                                                                                                                                                          1.3s
[robin@lab immich]$ sudo docker compose -f docker-compose-immich.yaml up
[+] Running 5/5
 ✔ Network immich                    Created                                                                                                                                                                                     0.1s
 ✔ Container immich-machinelearning  Created                                                                                                                                                                                     0.0s
 ✔ Container immich-postgres         Created                                                                                                                                                                                     0.0s
 ✔ Container immich-redis            Created                                                                                                                                                                                     0.0s
 ✔ Container immich-server           Created                                                                                                                                                                                     0.1s
Attaching to immich-machinelearning, immich-postgres, immich-redis, immich-server
immich-redis            | 1:C 12 Jun 2024 22:48:45.409 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
immich-redis            | 1:C 12 Jun 2024 22:48:45.409 # Redis version=6.2.14, bits=64, commit=00000000, modified=0, pid=1, just started
immich-redis            | 1:C 12 Jun 2024 22:48:45.409 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
immich-redis            | 1:M 12 Jun 2024 22:48:45.409 * monotonic clock: POSIX clock_gettime
immich-redis            | 1:M 12 Jun 2024 22:48:45.409 * Running mode=standalone, port=6379.
immich-redis            | 1:M 12 Jun 2024 22:48:45.409 # Server initialized
immich-redis            | 1:M 12 Jun 2024 22:48:45.409 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
immich-redis            | 1:M 12 Jun 2024 22:48:45.410 * Ready to accept connections
immich-postgres         |
immich-postgres         | PostgreSQL Database directory appears to contain a database; Skipping initialization
immich-postgres         |
immich-postgres         | 2024-06-12 22:48:45.458 UTC [1] LOG:  redirecting log output to logging collector process
immich-postgres         | 2024-06-12 22:48:45.458 UTC [1] HINT:  Future log output will appear in directory "log".
immich-server           | Detected CPU Cores: 12
immich-machinelearning  | [06/12/24 18:48:45] INFO     Starting gunicorn 22.0.0
immich-machinelearning  | [06/12/24 18:48:45] INFO     Listening at: http://[::]:3003 (9)
immich-machinelearning  | [06/12/24 18:48:45] INFO     Using worker: app.config.CustomUvicornWorker
immich-machinelearning  | [06/12/24 18:48:45] INFO     Booting worker with pid: 10
immich-server           | Starting api worker
immich-server           | Starting microservices worker
immich-postgres exited with code 0
immich-postgres         |
immich-postgres         | PostgreSQL Database directory appears to contain a database; Skipping initialization
immich-postgres         |
immich-postgres         | 2024-06-12 22:48:47.269 UTC [1] LOG:  redirecting log output to logging collector process
immich-postgres         | 2024-06-12 22:48:47.269 UTC [1] HINT:  Future log output will appear in directory "log".
immich-machinelearning  | [06/12/24 18:48:48] INFO     Started server process [10]
immich-machinelearning  | [06/12/24 18:48:48] INFO     Waiting for application startup.
immich-machinelearning  | [06/12/24 18:48:48] INFO     Created in-memory cache with unloading after 300s
immich-machinelearning  |                              of inactivity.
immich-machinelearning  | [06/12/24 18:48:48] INFO     Initialized request thread pool with 12 threads.
immich-machinelearning  | [06/12/24 18:48:48] INFO     Application startup complete.
immich-postgres exited with code 0
immich-postgres         |
immich-postgres         | PostgreSQL Database directory appears to contain a database; Skipping initialization
immich-postgres         |
immich-postgres         | 2024-06-12 22:48:49.106 UTC [1] LOG:  redirecting log output to logging collector process
immich-postgres         | 2024-06-12 22:48:49.106 UTC [1] HINT:  Future log output will appear in directory "log".
immich-postgres exited with code 1
immich-postgres         |
immich-postgres         | PostgreSQL Database directory appears to contain a database; Skipping initialization
immich-postgres         |
immich-postgres         | 2024-06-12 22:48:51.070 UTC [1] LOG:  redirecting log output to logging collector process
immich-postgres         | 2024-06-12 22:48:51.070 UTC [1] HINT:  Future log output will appear in directory "log".
immich-postgres         |
immich-postgres         | PostgreSQL Database directory appears to contain a database; Skipping initialization
immich-postgres         |
immich-postgres         | 2024-06-12 22:48:53.351 UTC [1] LOG:  redirecting log output to logging collector process
immich-postgres         | 2024-06-12 22:48:53.351 UTC [1] HINT:  Future log output will appear in directory "log".
immich-postgres         |
immich-postgres         | PostgreSQL Database directory appears to contain a database; Skipping initialization
immich-postgres         |
immich-postgres         | 2024-06-12 22:48:56.547 UTC [1] LOG:  redirecting log output to logging collector process
immich-postgres         | 2024-06-12 22:48:56.547 UTC [1] HINT:  Future log output will appear in directory "log".
immich-postgres         |
immich-postgres         | PostgreSQL Database directory appears to contain a database; Skipping initialization
immich-postgres         |
immich-postgres         | 2024-06-12 22:49:01.277 UTC [1] LOG:  redirecting log output to logging collector process
immich-postgres         | 2024-06-12 22:49:01.277 UTC [1] HINT:  Future log output will appear in directory "log".
immich-postgres         |
immich-postgres         | PostgreSQL Database directory appears to contain a database; Skipping initialization
immich-postgres         |
immich-postgres         | 2024-06-12 22:49:09.180 UTC [1] LOG:  redirecting log output to logging collector process
immich-postgres         | 2024-06-12 22:49:09.180 UTC [1] HINT:  Future log output will appear in directory "log".
immich-postgres         |
immich-postgres         | PostgreSQL Database directory appears to contain a database; Skipping initialization
immich-postgres         |
immich-postgres         | 2024-06-12 22:49:23.432 UTC [1] LOG:  redirecting log output to logging collector process
immich-postgres         | 2024-06-12 22:49:23.432 UTC [1] HINT:  Future log output will appear in directory "log".
immich-postgres         |
immich-postgres         | PostgreSQL Database directory appears to contain a database; Skipping initialization
immich-postgres         |
immich-postgres         | 2024-06-12 22:49:50.490 UTC [1] LOG:  redirecting log output to logging collector process
immich-postgres         | 2024-06-12 22:49:50.490 UTC [1] HINT:  Future log output will appear in directory "log".
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [NestFactory] Starting Nest application...
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] BullModule dependencies initialized +0ms
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] OpenTelemetryModule dependencies initialized +0ms
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] TypeOrmModule dependencies initialized +0ms
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] OpenTelemetryCoreModule dependencies initialized +0ms
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] ConfigHostModule dependencies initialized +0ms
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] DiscoveryModule dependencies initialized +0ms
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] ClsModule dependencies initialized +0ms
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] ConfigModule dependencies initialized +0ms
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] EventEmitterModule dependencies initialized +0ms
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] ScheduleModule dependencies initialized +0ms
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] BullModule dependencies initialized +0ms
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM     LOG [InstanceLoader] BullModule dependencies initialized +1ms
immich-server           | [Nest] 7  - 06/12/2024, 6:50:12 PM     LOG [NestFactory] Starting Nest application...
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...
immich-server           | error: the database system is starting up
immich-server           |     at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
immich-server           |     at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
immich-server           |     at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
immich-server           |     at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
immich-server           |     at Socket.emit (node:events:519:28)
immich-server           |     at addChunk (node:internal/streams/readable:559:12)
immich-server           |     at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
immich-server           |     at Readable.push (node:internal/streams/readable:390:5)
immich-server           |     at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (2)...
immich-server           | error: the database system is starting up
immich-server           |     at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
immich-server           |     at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
immich-server           |     at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
immich-server           |     at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
immich-server           |     at Socket.emit (node:events:519:28)
immich-server           |     at addChunk (node:internal/streams/readable:559:12)
immich-server           |     at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
immich-server           |     at Readable.push (node:internal/streams/readable:390:5)
immich-server           |     at TCP.onStreamRead (node:internal/stream_base_commons:191:23)
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (3)...
immich-server           | Error: getaddrinfo ENOTFOUND database
immich-server           |     at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26)
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (4)...
immich-server           | Error: getaddrinfo ENOTFOUND database
immich-server           |     at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26)
immich-server           | [Nest] 7  - 06/12/2024, 6:50:12 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (5)...
immich-server           | Error: getaddrinfo ENOTFOUND database
immich-server           |     at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26)
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (6)...
immich-server           | Error: getaddrinfo ENOTFOUND database
immich-server           |     at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26)
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (7)...
immich-server           | Error: getaddrinfo ENOTFOUND database
immich-server           |     at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26)
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (8)...
immich-server           | Error: getaddrinfo ENOTFOUND database
immich-server           |     at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26)
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (9)...
immich-server           | Error: getaddrinfo ENOTFOUND database
immich-server           |     at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26)
immich-server           | [Nest] 17  - 06/12/2024, 6:50:12 PM   ERROR [ExceptionHandler] getaddrinfo ENOTFOUND database
immich-server           | Error: getaddrinfo ENOTFOUND database
immich-server           |     at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26)
immich-server           | microservices worker exited with code 1
immich-server exited with code 0
immich-server           | Detected CPU Cores: 12
immich-server           | Starting api worker
immich-server           | Starting microservices worker
immich-postgres         |
immich-postgres         | PostgreSQL Database directory appears to contain a database; Skipping initialization
immich-postgres         |
immich-postgres         | 2024-06-12 22:50:43.168 UTC [1] LOG:  redirecting log output to logging collector process
immich-postgres         | 2024-06-12 22:50:43.168 UTC [1] HINT:  Future log output will appear in directory "log".
^CGracefully stopping... (press Ctrl+C again to force)
[+] Stopping 4/4
 ✔ Container immich-machinelearning  Stopped                                                                                                                                                                                     0.3s
 ✔ Container immich-server           Stopped                                                                                                                                                                                     0.4s
 ✔ Container immich-postgres         Stopped                                                                                                                                                                                     0.0s
 ✔ Container immich-redis            Stopped                                                                                                                                                                                     0.3s
canceled

Additional information

2024-06-12 02:57:29.817 UTC [1] LOG:  received fast shutdown request
2024-06-12 02:57:29.828 UTC [1] LOG:  aborting any active transactions
2024-06-12 02:57:29.828 UTC [1723] FATAL:  terminating connection due to administrator command
2024-06-12 02:57:29.828 UTC [55] FATAL:  terminating connection due to administrator command
2024-06-12 02:57:29.828 UTC [54] FATAL:  terminating connection due to administrator command
2024-06-12 02:57:29.830 UTC [1] LOG:  background worker "logical replication launcher" (PID 35) exited with exit code 1
2024-06-12 02:57:29.834 UTC [30] LOG:  shutting down
2024-06-12 02:57:29.994 UTC [1] LOG:  database system is shut down

2024-06-12 03:18:48.160 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 03:18:48.160 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 03:18:48.160 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 03:18:48.164 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 03:18:48.186 UTC [27] LOG:  database system was shut down at 2024-06-12 02:57:29 UTC
[2024-06-12T03:18:48Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T03:18:48Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T03:18:48Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
2024-06-12 03:18:48.251 UTC [1] LOG:  database system is ready to accept connections
[2024-06-12T03:18:48Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
2024-06-12 03:19:18.185 UTC [54] FATAL:  role "root" does not exist
2024-06-12 03:24:18.460 UTC [69] FATAL:  role "root" does not exist
2024-06-12 03:29:18.565 UTC [84] FATAL:  role "root" does not exist
2024-06-12 03:34:18.669 UTC [99] FATAL:  role "root" does not exist
2024-06-12 03:39:18.785 UTC [114] FATAL:  role "root" does not exist
2024-06-12 03:44:18.882 UTC [129] FATAL:  role "root" does not exist
2024-06-12 03:49:18.992 UTC [144] FATAL:  role "root" does not exist
2024-06-12 03:54:19.106 UTC [159] FATAL:  role "root" does not exist
2024-06-12 03:59:19.212 UTC [174] FATAL:  role "root" does not exist
2024-06-12 04:04:19.324 UTC [189] FATAL:  role "root" does not exist
2024-06-12 04:09:19.462 UTC [204] FATAL:  role "root" does not exist
2024-06-12 04:14:19.559 UTC [219] FATAL:  role "root" does not exist
2024-06-12 04:19:19.664 UTC [234] FATAL:  role "root" does not exist
2024-06-12 04:24:19.772 UTC [249] FATAL:  role "root" does not exist
2024-06-12 04:29:19.892 UTC [264] FATAL:  role "root" does not exist
2024-06-12 04:34:20.009 UTC [279] FATAL:  role "root" does not exist
2024-06-12 04:39:20.126 UTC [294] FATAL:  role "root" does not exist
2024-06-12 04:44:20.239 UTC [309] FATAL:  role "root" does not exist
2024-06-12 04:49:20.338 UTC [324] FATAL:  role "root" does not exist
2024-06-12 04:54:20.455 UTC [339] FATAL:  role "root" does not exist
2024-06-12 04:59:20.555 UTC [354] FATAL:  role "root" does not exist
2024-06-12 05:04:20.679 UTC [369] FATAL:  role "root" does not exist
2024-06-12 05:09:20.792 UTC [384] FATAL:  role "root" does not exist
2024-06-12 05:14:20.902 UTC [399] FATAL:  role "root" does not exist
2024-06-12 05:19:21.009 UTC [414] FATAL:  role "root" does not exist
2024-06-12 05:24:21.113 UTC [429] FATAL:  role "root" does not exist
2024-06-12 05:29:21.205 UTC [444] FATAL:  role "root" does not exist
2024-06-12 05:34:21.322 UTC [459] FATAL:  role "root" does not exist
2024-06-12 05:39:21.432 UTC [474] FATAL:  role "root" does not exist
2024-06-12 05:44:21.538 UTC [489] FATAL:  role "root" does not exist
2024-06-12 05:49:21.645 UTC [504] FATAL:  role "root" does not exist
2024-06-12 05:54:21.758 UTC [519] FATAL:  role "root" does not exist
2024-06-12 05:59:21.860 UTC [534] FATAL:  role "root" does not exist
2024-06-12 06:04:21.955 UTC [549] FATAL:  role "root" does not exist
2024-06-12 06:09:22.065 UTC [564] FATAL:  role "root" does not exist
2024-06-12 06:14:22.198 UTC [579] FATAL:  role "root" does not exist
2024-06-12 06:19:22.302 UTC [594] FATAL:  role "root" does not exist
2024-06-12 06:24:22.405 UTC [609] FATAL:  role "root" does not exist
2024-06-12 06:29:22.486 UTC [624] FATAL:  role "root" does not exist
2024-06-12 06:34:22.588 UTC [639] FATAL:  role "root" does not exist
2024-06-12 06:39:22.708 UTC [654] FATAL:  role "root" does not exist
2024-06-12 06:44:22.845 UTC [669] FATAL:  role "root" does not exist
2024-06-12 06:49:22.958 UTC [684] FATAL:  role "root" does not exist
2024-06-12 06:54:23.064 UTC [699] FATAL:  role "root" does not exist
2024-06-12 06:59:23.169 UTC [714] FATAL:  role "root" does not exist
2024-06-12 07:04:23.281 UTC [729] FATAL:  role "root" does not exist
2024-06-12 07:09:23.414 UTC [744] FATAL:  role "root" does not exist
2024-06-12 07:14:23.528 UTC [759] FATAL:  role "root" does not exist
2024-06-12 07:19:23.641 UTC [774] FATAL:  role "root" does not exist
2024-06-12 07:24:23.748 UTC [789] FATAL:  role "root" does not exist
2024-06-12 07:29:23.851 UTC [804] FATAL:  role "root" does not exist
2024-06-12 07:34:23.966 UTC [819] FATAL:  role "root" does not exist
2024-06-12 07:39:24.071 UTC [834] FATAL:  role "root" does not exist
2024-06-12 07:44:24.165 UTC [849] FATAL:  role "root" does not exist
2024-06-12 07:49:24.264 UTC [864] FATAL:  role "root" does not exist
2024-06-12 07:54:24.371 UTC [879] FATAL:  role "root" does not exist
2024-06-12 07:59:24.473 UTC [894] FATAL:  role "root" does not exist
2024-06-12 08:04:24.589 UTC [909] FATAL:  role "root" does not exist
2024-06-12 08:09:24.666 UTC [924] FATAL:  role "root" does not exist
2024-06-12 08:14:24.771 UTC [939] FATAL:  role "root" does not exist
2024-06-12 08:19:24.864 UTC [954] FATAL:  role "root" does not exist
2024-06-12 08:24:24.967 UTC [969] FATAL:  role "root" does not exist
2024-06-12 08:29:25.087 UTC [984] FATAL:  role "root" does not exist
2024-06-12 08:34:25.204 UTC [999] FATAL:  role "root" does not exist
2024-06-12 08:39:25.297 UTC [1014] FATAL:  role "root" does not exist
2024-06-12 08:44:25.411 UTC [1029] FATAL:  role "root" does not exist
2024-06-12 08:49:25.514 UTC [1044] FATAL:  role "root" does not exist
2024-06-12 08:54:25.627 UTC [1059] FATAL:  role "root" does not exist
2024-06-12 08:59:25.724 UTC [1074] FATAL:  role "root" does not exist
2024-06-12 09:04:25.834 UTC [1089] FATAL:  role "root" does not exist
2024-06-12 09:09:25.954 UTC [1104] FATAL:  role "root" does not exist
2024-06-12 09:14:26.067 UTC [1119] FATAL:  role "root" does not exist
2024-06-12 09:19:26.170 UTC [1134] FATAL:  role "root" does not exist
2024-06-12 09:24:26.293 UTC [1149] FATAL:  role "root" does not exist
2024-06-12 09:29:26.404 UTC [1164] FATAL:  role "root" does not exist
2024-06-12 09:34:26.524 UTC [1179] FATAL:  role "root" does not exist
2024-06-12 09:39:26.643 UTC [1194] FATAL:  role "root" does not exist
2024-06-12 09:44:26.750 UTC [1209] FATAL:  role "root" does not exist
2024-06-12 09:49:26.884 UTC [1224] FATAL:  role "root" does not exist
2024-06-12 09:54:26.996 UTC [1239] FATAL:  role "root" does not exist
2024-06-12 09:59:27.120 UTC [1254] FATAL:  role "root" does not exist
2024-06-12 10:04:27.213 UTC [1269] FATAL:  role "root" does not exist
2024-06-12 10:09:27.310 UTC [1284] FATAL:  role "root" does not exist
2024-06-12 10:14:27.428 UTC [1299] FATAL:  role "root" does not exist
2024-06-12 10:19:27.554 UTC [1314] FATAL:  role "root" does not exist
2024-06-12 10:24:27.664 UTC [1329] FATAL:  role "root" does not exist
2024-06-12 10:29:27.773 UTC [1344] FATAL:  role "root" does not exist
2024-06-12 10:34:27.878 UTC [1359] FATAL:  role "root" does not exist
2024-06-12 10:39:27.987 UTC [1374] FATAL:  role "root" does not exist
2024-06-12 10:44:28.104 UTC [1389] FATAL:  role "root" does not exist
2024-06-12 10:49:28.213 UTC [1404] FATAL:  role "root" does not exist
2024-06-12 10:54:28.353 UTC [1419] FATAL:  role "root" does not exist
2024-06-12 10:59:28.477 UTC [1434] FATAL:  role "root" does not exist
2024-06-12 11:04:28.586 UTC [1449] FATAL:  role "root" does not exist
2024-06-12 11:09:28.707 UTC [1464] FATAL:  role "root" does not exist
2024-06-12 11:14:28.833 UTC [1479] FATAL:  role "root" does not exist
2024-06-12 11:19:28.930 UTC [1494] FATAL:  role "root" does not exist
2024-06-12 11:24:29.057 UTC [1509] FATAL:  role "root" does not exist
2024-06-12 11:29:29.163 UTC [1524] FATAL:  role "root" does not exist
2024-06-12 11:34:29.293 UTC [1539] FATAL:  role "root" does not exist
2024-06-12 11:39:29.393 UTC [1554] FATAL:  role "root" does not exist
2024-06-12 11:44:29.496 UTC [1569] FATAL:  role "root" does not exist
2024-06-12 11:49:29.623 UTC [1584] FATAL:  role "root" does not exist
2024-06-12 11:54:29.753 UTC [1599] FATAL:  role "root" does not exist
2024-06-12 11:59:29.860 UTC [1614] FATAL:  role "root" does not exist
2024-06-12 12:04:29.974 UTC [1629] FATAL:  role "root" does not exist
2024-06-12 12:09:30.086 UTC [1644] FATAL:  role "root" does not exist
2024-06-12 12:14:30.200 UTC [1659] FATAL:  role "root" does not exist
2024-06-12 12:19:30.313 UTC [1674] FATAL:  role "root" does not exist
2024-06-12 12:24:30.426 UTC [1689] FATAL:  role "root" does not exist
2024-06-12 12:29:30.540 UTC [1704] FATAL:  role "root" does not exist
2024-06-12 12:34:30.649 UTC [1719] FATAL:  role "root" does not exist
2024-06-12 12:39:30.746 UTC [1734] FATAL:  role "root" does not exist
2024-06-12 12:44:30.849 UTC [1749] FATAL:  role "root" does not exist
2024-06-12 12:49:30.953 UTC [1764] FATAL:  role "root" does not exist
2024-06-12 12:54:31.079 UTC [1779] FATAL:  role "root" does not exist
2024-06-12 12:59:31.155 UTC [1794] FATAL:  role "root" does not exist
2024-06-12 13:04:31.269 UTC [1809] FATAL:  role "root" does not exist
2024-06-12 13:09:31.406 UTC [1824] FATAL:  role "root" does not exist
2024-06-12 13:14:31.546 UTC [1839] FATAL:  role "root" does not exist
2024-06-12 13:19:31.659 UTC [1854] FATAL:  role "root" does not exist
2024-06-12 13:24:31.769 UTC [1869] FATAL:  role "root" does not exist
2024-06-12 13:29:31.876 UTC [1884] FATAL:  role "root" does not exist
2024-06-12 13:34:31.953 UTC [1899] FATAL:  role "root" does not exist
2024-06-12 13:39:32.075 UTC [1914] FATAL:  role "root" does not exist
2024-06-12 13:44:32.172 UTC [1929] FATAL:  role "root" does not exist
2024-06-12 13:49:32.282 UTC [1944] FATAL:  role "root" does not exist
2024-06-12 13:54:32.389 UTC [1959] FATAL:  role "root" does not exist
2024-06-12 13:59:32.512 UTC [1974] FATAL:  role "root" does not exist
2024-06-12 14:04:32.619 UTC [1989] FATAL:  role "root" does not exist
2024-06-12 14:09:32.732 UTC [2004] FATAL:  role "root" does not exist
2024-06-12 14:14:32.829 UTC [2019] FATAL:  role "root" does not exist
2024-06-12 14:19:32.932 UTC [2034] FATAL:  role "root" does not exist
2024-06-12 14:24:33.035 UTC [2049] FATAL:  role "root" does not exist
2024-06-12 14:29:33.155 UTC [2064] FATAL:  role "root" does not exist
2024-06-12 14:34:33.273 UTC [2079] FATAL:  role "root" does not exist
2024-06-12 14:39:33.378 UTC [2094] FATAL:  role "root" does not exist
2024-06-12 14:44:33.485 UTC [2109] FATAL:  role "root" does not exist
2024-06-12 14:49:33.592 UTC [2124] FATAL:  role "root" does not exist
2024-06-12 14:54:00.649 UTC [1] LOG:  received fast shutdown request
2024-06-12 14:54:00.661 UTC [1] LOG:  aborting any active transactions
2024-06-12 14:54:00.662 UTC [1] LOG:  background worker "logical replication launcher" (PID 39) exited with exit code 1
2024-06-12 14:54:00.663 UTC [29] LOG:  shutting down
2024-06-12 14:54:00.700 UTC [1] LOG:  database system is shut down

2024-06-12 14:59:01.921 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 14:59:01.921 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 14:59:01.921 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 14:59:01.925 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 14:59:01.955 UTC [28] LOG:  database system was shut down at 2024-06-12 14:54:00 UTC
[2024-06-12T14:59:01Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T14:59:01Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T14:59:01Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
2024-06-12 14:59:02.004 UTC [1] LOG:  database system is ready to accept connections
[2024-06-12T14:59:02Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
2024-06-12 14:59:31.929 UTC [55] FATAL:  role "root" does not exist
2024-06-12 15:01:48.433 UTC [1] LOG:  received fast shutdown request
2024-06-12 15:01:48.447 UTC [1] LOG:  aborting any active transactions
2024-06-12 15:01:48.449 UTC [1] LOG:  background worker "logical replication launcher" (PID 35) exited with exit code 1
2024-06-12 15:01:48.449 UTC [30] LOG:  shutting down
2024-06-12 15:01:48.518 UTC [1] LOG:  database system is shut down

2024-06-12 15:01:49.502 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 15:01:49.502 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 15:01:49.502 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 15:01:49.506 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 15:01:49.512 UTC [27] LOG:  database system was shut down at 2024-06-12 15:01:48 UTC
[2024-06-12T15:01:49Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T15:01:49Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T15:01:49Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
[2024-06-12T15:01:49Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
2024-06-12 15:01:49.523 UTC [1] LOG:  database system is ready to accept connections
2024-06-12 15:02:19.499 UTC [54] FATAL:  role "root" does not exist
2024-06-12 15:07:19.616 UTC [69] FATAL:  role "root" does not exist
2024-06-12 15:12:19.725 UTC [94] FATAL:  role "root" does not exist
2024-06-12 15:17:19.832 UTC [113] FATAL:  role "root" does not exist
2024-06-12 15:22:19.929 UTC [133] FATAL:  role "root" does not exist
2024-06-12 15:27:20.032 UTC [148] FATAL:  role "root" does not exist
2024-06-12 15:32:20.145 UTC [163] FATAL:  role "root" does not exist
2024-06-12 15:37:20.251 UTC [178] FATAL:  role "root" does not exist
2024-06-12 15:42:20.362 UTC [193] FATAL:  role "root" does not exist
2024-06-12 15:47:20.468 UTC [208] FATAL:  role "root" does not exist
2024-06-12 15:52:20.589 UTC [223] FATAL:  role "root" does not exist
2024-06-12 15:57:20.698 UTC [238] FATAL:  role "root" does not exist
2024-06-12 16:02:20.774 UTC [253] FATAL:  role "root" does not exist
2024-06-12 16:07:20.892 UTC [268] FATAL:  role "root" does not exist
2024-06-12 16:12:20.995 UTC [283] FATAL:  role "root" does not exist
2024-06-12 16:17:21.108 UTC [298] FATAL:  role "root" does not exist
2024-06-12 16:22:21.231 UTC [313] FATAL:  role "root" does not exist
2024-06-12 16:27:21.337 UTC [328] FATAL:  role "root" does not exist
2024-06-12 16:32:21.451 UTC [343] FATAL:  role "root" does not exist
2024-06-12 16:37:21.526 UTC [358] FATAL:  role "root" does not exist
2024-06-12 16:42:21.638 UTC [373] FATAL:  role "root" does not exist
2024-06-12 16:47:21.751 UTC [388] FATAL:  role "root" does not exist
2024-06-12 16:52:21.878 UTC [403] FATAL:  role "root" does not exist
2024-06-12 16:57:21.998 UTC [418] FATAL:  role "root" does not exist
2024-06-12 17:02:22.114 UTC [433] FATAL:  role "root" does not exist
2024-06-12 17:07:22.211 UTC [448] FATAL:  role "root" does not exist
2024-06-12 17:12:22.331 UTC [463] FATAL:  role "root" does not exist
2024-06-12 17:17:22.434 UTC [478] FATAL:  role "root" does not exist
2024-06-12 17:22:22.531 UTC [493] FATAL:  role "root" does not exist
2024-06-12 17:27:22.657 UTC [508] FATAL:  role "root" does not exist
2024-06-12 17:32:22.754 UTC [523] FATAL:  role "root" does not exist
2024-06-12 17:37:22.858 UTC [538] FATAL:  role "root" does not exist
2024-06-12 17:42:22.961 UTC [553] FATAL:  role "root" does not exist
2024-06-12 17:47:23.074 UTC [568] FATAL:  role "root" does not exist
2024-06-12 17:52:23.190 UTC [583] FATAL:  role "root" does not exist
2024-06-12 17:57:23.321 UTC [598] FATAL:  role "root" does not exist
2024-06-12 18:02:23.441 UTC [613] FATAL:  role "root" does not exist
2024-06-12 18:07:23.540 UTC [628] FATAL:  role "root" does not exist
2024-06-12 18:12:23.661 UTC [643] FATAL:  role "root" does not exist
2024-06-12 18:17:23.790 UTC [658] FATAL:  role "root" does not exist
2024-06-12 18:22:23.884 UTC [673] FATAL:  role "root" does not exist
2024-06-12 18:27:24.015 UTC [688] FATAL:  role "root" does not exist
2024-06-12 18:32:24.114 UTC [703] FATAL:  role "root" does not exist
2024-06-12 18:37:24.217 UTC [718] FATAL:  role "root" does not exist
2024-06-12 18:42:24.320 UTC [733] FATAL:  role "root" does not exist
2024-06-12 18:47:24.427 UTC [748] FATAL:  role "root" does not exist
2024-06-12 18:52:24.520 UTC [763] FATAL:  role "root" does not exist
2024-06-12 18:57:24.624 UTC [778] FATAL:  role "root" does not exist
2024-06-12 19:02:24.747 UTC [793] FATAL:  role "root" does not exist
2024-06-12 19:07:24.854 UTC [808] FATAL:  role "root" does not exist
2024-06-12 19:12:24.946 UTC [823] FATAL:  role "root" does not exist
2024-06-12 19:17:25.060 UTC [838] FATAL:  role "root" does not exist
2024-06-12 19:22:25.167 UTC [853] FATAL:  role "root" does not exist
2024-06-12 19:27:25.290 UTC [868] FATAL:  role "root" does not exist
2024-06-12 19:32:25.394 UTC [883] FATAL:  role "root" does not exist
2024-06-12 19:37:25.493 UTC [898] FATAL:  role "root" does not exist
2024-06-12 19:42:25.614 UTC [913] FATAL:  role "root" does not exist
2024-06-12 19:47:25.706 UTC [928] FATAL:  role "root" does not exist
2024-06-12 19:52:25.804 UTC [943] FATAL:  role "root" does not exist
2024-06-12 19:57:25.920 UTC [958] FATAL:  role "root" does not exist
2024-06-12 20:02:26.040 UTC [973] FATAL:  role "root" does not exist
2024-06-12 20:07:26.150 UTC [988] FATAL:  role "root" does not exist
2024-06-12 20:12:26.270 UTC [1003] FATAL:  role "root" does not exist
2024-06-12 20:17:26.380 UTC [1018] FATAL:  role "root" does not exist
2024-06-12 20:20:03.454 UTC [1] LOG:  could not open file "postmaster.pid": No such file or directory
2024-06-12 20:20:03.454 UTC [1] LOG:  performing immediate shutdown because data directory lock file is invalid
2024-06-12 20:20:03.454 UTC [1] LOG:  received immediate shutdown request
2024-06-12 20:20:03.454 UTC [1] LOG:  could not open file "postmaster.pid": No such file or directory
2024-06-12 20:20:03.461 UTC [1] LOG:  database system is shut down

2024-06-12 20:18:06.659 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 20:18:06.659 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 20:18:06.659 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 20:18:06.663 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 20:18:06.669 UTC [28] LOG:  database system was interrupted; last known up at 2024-06-12 20:16:54 UTC
[2024-06-12T20:18:06Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T20:18:06Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T20:18:06Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
[2024-06-12T20:18:06Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
2024-06-12 20:18:06.696 UTC [28] LOG:  database system was not properly shut down; automatic recovery in progress
2024-06-12 20:18:06.702 UTC [28] LOG:  redo starts at 0/2F2AB9B8
2024-06-12 20:18:06.702 UTC [28] LOG:  invalid record length at 0/2F2ABFF8: wanted 24, got 0
2024-06-12 20:18:06.702 UTC [28] LOG:  redo done at 0/2F2ABFD0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-06-12 20:18:06.741 UTC [1] LOG:  database system is ready to accept connections
2024-06-12 20:18:36.667 UTC [55] FATAL:  role "root" does not exist
2024-06-12 20:19:55.108 UTC [1] LOG:  received fast shutdown request
2024-06-12 20:19:55.119 UTC [1] LOG:  aborting any active transactions
2024-06-12 20:19:55.121 UTC [1] LOG:  background worker "logical replication launcher" (PID 47) exited with exit code 1
2024-06-12 20:19:55.121 UTC [42] LOG:  shutting down
2024-06-12 20:19:55.144 UTC [1] LOG:  database system is shut down

2024-06-12 20:20:04.028 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 20:20:04.028 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 20:20:04.028 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 20:20:04.033 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 20:20:04.038 UTC [27] LOG:  database system was shut down at 2024-06-12 20:19:55 UTC
2024-06-12 20:20:04.039 UTC [27] LOG:  incorrect resource manager data checksum in record at 0/2F2AC0C0
2024-06-12 20:20:04.039 UTC [27] LOG:  invalid primary checkpoint record
2024-06-12 20:20:04.039 UTC [27] PANIC:  could not locate a valid checkpoint record
[2024-06-12T20:20:04Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T20:20:04Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T20:20:04Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
[2024-06-12T20:20:04Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
2024-06-12 20:20:04.705 UTC [41] FATAL:  the database system is starting up
2024-06-12 20:20:05.129 UTC [1] LOG:  startup process (PID 27) was terminated by signal 6: Aborted
2024-06-12 20:20:05.129 UTC [1] LOG:  aborting startup due to startup process failure
2024-06-12 20:20:05.130 UTC [1] LOG:  database system is shut down

2024-06-12 20:20:05.773 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 20:20:05.773 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 20:20:05.773 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 20:20:05.776 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 20:20:05.782 UTC [27] LOG:  database system was shut down at 2024-06-12 20:19:55 UTC
2024-06-12 20:20:05.783 UTC [27] LOG:  incorrect resource manager data checksum in record at 0/2F2AC0C0
2024-06-12 20:20:05.783 UTC [27] LOG:  invalid primary checkpoint record
2024-06-12 20:20:05.783 UTC [27] PANIC:  could not locate a valid checkpoint record
[2024-06-12T20:20:05Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T20:20:05Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T20:20:05Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
[2024-06-12T20:20:05Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
2024-06-12 20:20:06.053 UTC [41] FATAL:  the database system is starting up
2024-06-12 20:20:06.219 UTC [42] FATAL:  the database system is starting up
2024-06-12 20:20:06.302 UTC [43] FATAL:  the database system is starting up
2024-06-12 20:20:06.917 UTC [1] LOG:  startup process (PID 27) was terminated by signal 6: Aborted
2024-06-12 20:20:06.917 UTC [1] LOG:  aborting startup due to startup process failure
2024-06-12 20:20:06.919 UTC [1] LOG:  database system is shut down

2024-06-12 20:20:07.449 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 20:20:07.449 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 20:20:07.449 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 20:20:07.453 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 20:20:07.459 UTC [28] LOG:  database system was shut down at 2024-06-12 20:19:55 UTC
2024-06-12 20:20:07.459 UTC [28] LOG:  incorrect resource manager data checksum in record at 0/2F2AC0C0
2024-06-12 20:20:07.459 UTC [28] LOG:  invalid primary checkpoint record
2024-06-12 20:20:07.459 UTC [28] PANIC:  could not locate a valid checkpoint record
[2024-06-12T20:20:07Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T20:20:07Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T20:20:07Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
[2024-06-12T20:20:07Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
2024-06-12 20:20:07.806 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 20:20:07.807 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 20:20:07.807 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 20:20:07.810 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 20:20:07.816 UTC [27] LOG:  database system was shut down at 2024-06-12 20:19:55 UTC
2024-06-12 20:20:07.816 UTC [27] LOG:  incorrect resource manager data checksum in record at 0/2F2AC0C0
2024-06-12 20:20:07.816 UTC [27] LOG:  invalid primary checkpoint record
2024-06-12 20:20:07.816 UTC [27] PANIC:  could not locate a valid checkpoint record
[2024-06-12T20:20:07Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T20:20:07Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T20:20:07Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
[2024-06-12T20:20:07Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
2024-06-12 20:20:08.611 UTC [1] LOG:  startup process (PID 28) was terminated by signal 6: Aborted
2024-06-12 20:20:08.611 UTC [1] LOG:  aborting startup due to startup process failure
2024-06-12 20:20:08.613 UTC [1] LOG:  database system is shut down
2024-06-12 20:20:08.966 UTC [41] FATAL:  the database system is starting up
2024-06-12 20:20:08.981 UTC [42] FATAL:  the database system is starting up
2024-06-12 20:20:09.014 UTC [1] LOG:  startup process (PID 27) was terminated by signal 6: Aborted
2024-06-12 20:20:09.014 UTC [1] LOG:  aborting startup due to startup process failure
2024-06-12 20:20:09.015 UTC [1] LOG:  database system is shut down

2024-06-12 20:20:09.588 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 20:20:09.659 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 20:20:09.659 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 20:20:09.662 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 20:20:09.725 UTC [27] LOG:  database system was shut down at 2024-06-12 20:19:55 UTC
2024-06-12 20:20:09.725 UTC [27] LOG:  incorrect resource manager data checksum in record at 0/2F2AC0C0
2024-06-12 20:20:09.725 UTC [27] LOG:  invalid primary checkpoint record
2024-06-12 20:20:09.725 UTC [27] PANIC:  could not locate a valid checkpoint record
[2024-06-12T20:20:09Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T20:20:09Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T20:20:09Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
[2024-06-12T20:20:09Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
2024-06-12 20:20:10.871 UTC [1] LOG:  startup process (PID 27) was terminated by signal 6: Aborted
2024-06-12 20:20:10.871 UTC [1] LOG:  aborting startup due to startup process failure
2024-06-12 20:20:10.873 UTC [1] LOG:  database system is shut down

2024-06-12 20:20:10.342 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 20:20:10.405 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 20:20:10.405 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 20:20:10.410 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 20:20:10.451 UTC [28] LOG:  database system was shut down at 2024-06-12 20:19:55 UTC
2024-06-12 20:20:10.452 UTC [28] LOG:  incorrect resource manager data checksum in record at 0/2F2AC0C0
2024-06-12 20:20:10.452 UTC [28] LOG:  invalid primary checkpoint record
2024-06-12 20:20:10.452 UTC [28] PANIC:  could not locate a valid checkpoint record
[2024-06-12T20:20:10Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T20:20:10Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T20:20:10Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
[2024-06-12T20:20:10Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
2024-06-12 20:20:10.580 UTC [42] FATAL:  the database system is starting up
2024-06-12 20:20:10.740 UTC [43] FATAL:  the database system is starting up
2024-06-12 20:20:11.063 UTC [44] FATAL:  the database system is starting up
2024-06-12 20:20:11.303 UTC [45] FATAL:  the database system is starting up
2024-06-12 20:20:11.602 UTC [1] LOG:  startup process (PID 28) was terminated by signal 6: Aborted
2024-06-12 20:20:11.602 UTC [1] LOG:  aborting startup due to startup process failure
2024-06-12 20:20:11.603 UTC [1] LOG:  database system is shut down

2024-06-12 20:20:11.939 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 20:20:11.939 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 20:20:11.939 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 20:20:11.943 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 20:20:11.949 UTC [28] LOG:  database system was shut down at 2024-06-12 20:19:55 UTC
2024-06-12 20:20:11.949 UTC [28] LOG:  incorrect resource manager data checksum in record at 0/2F2AC0C0
2024-06-12 20:20:11.949 UTC [28] LOG:  invalid primary checkpoint record
2024-06-12 20:20:11.949 UTC [28] PANIC:  could not locate a valid checkpoint record
[2024-06-12T20:20:11Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T20:20:11Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T20:20:11Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
[2024-06-12T20:20:11Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
2024-06-12 20:20:13.013 UTC [1] LOG:  startup process (PID 28) was terminated by signal 6: Aborted
2024-06-12 20:20:13.013 UTC [1] LOG:  aborting startup due to startup process failure
2024-06-12 20:20:13.014 UTC [1] LOG:  database system is shut down

2024-06-12 20:20:13.752 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 20:20:13.805 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 20:20:13.805 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 20:20:13.811 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 20:20:13.868 UTC [27] LOG:  database system was shut down at 2024-06-12 20:19:55 UTC
2024-06-12 20:20:13.869 UTC [27] LOG:  incorrect resource manager data checksum in record at 0/2F2AC0C0
2024-06-12 20:20:13.869 UTC [27] LOG:  invalid primary checkpoint record
2024-06-12 20:20:13.869 UTC [27] PANIC:  could not locate a valid checkpoint record
[2024-06-12T20:20:13Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T20:20:13Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T20:20:13Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
[2024-06-12T20:20:13Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
2024-06-12 20:20:15.026 UTC [1] LOG:  startup process (PID 27) was terminated by signal 6: Aborted
2024-06-12 20:20:15.026 UTC [1] LOG:  aborting startup due to startup process failure
2024-06-12 20:20:15.027 UTC [1] LOG:  database system is shut down

2024-06-12 20:20:14.008 UTC [1] LOG:  starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-12 20:20:14.009 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-12 20:20:14.009 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-12 20:20:14.012 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-12 20:20:14.018 UTC [28] LOG:  database system was shut down at 2024-06-12 20:19:55 UTC
2024-06-12 20:20:14.018 UTC [28] LOG:  incorrect resource manager data checksum in record at 0/2F2AC0C0
2024-06-12 20:20:14.018 UTC [28] LOG:  invalid primary checkpoint record
2024-06-12 20:20:14.018 UTC [28] PANIC:  could not locate a valid checkpoint record
[2024-06-12T20:20:14Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331".
[2024-06-12T20:20:14Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2024-06-12T20:20:14Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702".
[2024-06-12T20:20:14Z INFO  service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260".
2024-06-12 20:20:15.149 UTC [1] LOG:  startup process (PID 28) was terminated by signal 6: Aborted
2024-06-12 20:20:15.149 UTC [1] LOG:  aborting startup due to startup process failure
2024-06-12 20:20:15.150 UTC [1] LOG:  database system is shut down

Originally created by @iamtherobin on GitHub (Jun 12, 2024). ### The bug I tried to upgrade from v1.105.1 to v1.106.2 by following modifying the yaml file accordingly and pulling the new images. The result was restarting immich server container. Then I tried reverting back to v1.105.1 but now I am getting a postgres container error. I cannot get either v1.105.1 or newer to load anymore. I am currently trying to load v1.106.3 and postgres keeps restarting at "PostgreSQL Database directory appears to contain a database". Both postgres and server container repeat the error shown in the docker log. I also attached the postgres logs from the database log folder. The postgres start from where I attempted the v1.106 update upto the point where it just keeps repeating. ### The OS that Immich Server is running on Arch, kernel 6.8.9 ### Version of Immich Server v1.106.3 ### Version of Immich Mobile App latest ### Platform with the issue - [X] Server - [ ] Web - [ ] Mobile ### Your docker-compose.yml content ```YAML # # 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: - ${UPLOAD_LOCATION}:/usr/src/app/upload - /etc/localtime:/etc/localtime:ro env_file: - .env ports: - 2283:3001 depends_on: - redis - database restart: unless-stopped networks: - immich immich-machine-learning: container_name: immich-machinelearning # 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 networks: - immich redis: container_name: immich-redis image: docker.io/redis:6.2-alpine@sha256:d6c2911ac51b289db208767581a5d154544f2b2fe4914ea5056443f62dc6e900 healthcheck: test: redis-cli ping || exit 1 restart: always networks: - immich 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: - ${DB_DATA_LOCATION}:/var/lib/postgresql/data healthcheck: test: pg_isready --dbname='${DB_DATABASE_NAME}' || 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 networks: - immich volumes: model-cache: networks: immich: name: immich enable_ipv6: true ipam: config: - subnet: fd12:3456:7890:3::/64 gateway: fd12:3456:7890:3::1 ``` ### Your .env content ```Shell # 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=/hdd-storage/immich/library # The location where your database files are stored DB_DATA_LOCATION=/hdd-storage/immich/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=America/Toronto # The Immich version to use. You can pin this to a specific version like "v1.71.0" #IMMICH_VERSION=v1.105.1 IMMICH_VERSION=release # Connection secret for postgres. You should change it to a random password DB_PASSWORD=postgres # The values below this line do not need to be changed ################################################################################### DB_USERNAME=postgres DB_DATABASE_NAME=immich ``` ### Reproduction steps ```bash 1. 2. 3. ... ``` ### Relevant log output ```shell [robin@lab immich]$ sudo docker compose -f docker-compose-immich.yaml pull [+] Pulling 4/4 ✔ immich-machine-learning Pulled 1.3s ✔ database Pulled 2.3s ✔ redis Pulled 1.0s ✔ immich-server Pulled 1.3s [robin@lab immich]$ sudo docker compose -f docker-compose-immich.yaml up [+] Running 5/5 ✔ Network immich Created 0.1s ✔ Container immich-machinelearning Created 0.0s ✔ Container immich-postgres Created 0.0s ✔ Container immich-redis Created 0.0s ✔ Container immich-server Created 0.1s Attaching to immich-machinelearning, immich-postgres, immich-redis, immich-server immich-redis | 1:C 12 Jun 2024 22:48:45.409 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo immich-redis | 1:C 12 Jun 2024 22:48:45.409 # Redis version=6.2.14, bits=64, commit=00000000, modified=0, pid=1, just started immich-redis | 1:C 12 Jun 2024 22:48:45.409 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf immich-redis | 1:M 12 Jun 2024 22:48:45.409 * monotonic clock: POSIX clock_gettime immich-redis | 1:M 12 Jun 2024 22:48:45.409 * Running mode=standalone, port=6379. immich-redis | 1:M 12 Jun 2024 22:48:45.409 # Server initialized immich-redis | 1:M 12 Jun 2024 22:48:45.409 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect. immich-redis | 1:M 12 Jun 2024 22:48:45.410 * Ready to accept connections immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2024-06-12 22:48:45.458 UTC [1] LOG: redirecting log output to logging collector process immich-postgres | 2024-06-12 22:48:45.458 UTC [1] HINT: Future log output will appear in directory "log". immich-server | Detected CPU Cores: 12 immich-machinelearning | [06/12/24 18:48:45] INFO Starting gunicorn 22.0.0 immich-machinelearning | [06/12/24 18:48:45] INFO Listening at: http://[::]:3003 (9) immich-machinelearning | [06/12/24 18:48:45] INFO Using worker: app.config.CustomUvicornWorker immich-machinelearning | [06/12/24 18:48:45] INFO Booting worker with pid: 10 immich-server | Starting api worker immich-server | Starting microservices worker immich-postgres exited with code 0 immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2024-06-12 22:48:47.269 UTC [1] LOG: redirecting log output to logging collector process immich-postgres | 2024-06-12 22:48:47.269 UTC [1] HINT: Future log output will appear in directory "log". immich-machinelearning | [06/12/24 18:48:48] INFO Started server process [10] immich-machinelearning | [06/12/24 18:48:48] INFO Waiting for application startup. immich-machinelearning | [06/12/24 18:48:48] INFO Created in-memory cache with unloading after 300s immich-machinelearning | of inactivity. immich-machinelearning | [06/12/24 18:48:48] INFO Initialized request thread pool with 12 threads. immich-machinelearning | [06/12/24 18:48:48] INFO Application startup complete. immich-postgres exited with code 0 immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2024-06-12 22:48:49.106 UTC [1] LOG: redirecting log output to logging collector process immich-postgres | 2024-06-12 22:48:49.106 UTC [1] HINT: Future log output will appear in directory "log". immich-postgres exited with code 1 immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2024-06-12 22:48:51.070 UTC [1] LOG: redirecting log output to logging collector process immich-postgres | 2024-06-12 22:48:51.070 UTC [1] HINT: Future log output will appear in directory "log". immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2024-06-12 22:48:53.351 UTC [1] LOG: redirecting log output to logging collector process immich-postgres | 2024-06-12 22:48:53.351 UTC [1] HINT: Future log output will appear in directory "log". immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2024-06-12 22:48:56.547 UTC [1] LOG: redirecting log output to logging collector process immich-postgres | 2024-06-12 22:48:56.547 UTC [1] HINT: Future log output will appear in directory "log". immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2024-06-12 22:49:01.277 UTC [1] LOG: redirecting log output to logging collector process immich-postgres | 2024-06-12 22:49:01.277 UTC [1] HINT: Future log output will appear in directory "log". immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2024-06-12 22:49:09.180 UTC [1] LOG: redirecting log output to logging collector process immich-postgres | 2024-06-12 22:49:09.180 UTC [1] HINT: Future log output will appear in directory "log". immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2024-06-12 22:49:23.432 UTC [1] LOG: redirecting log output to logging collector process immich-postgres | 2024-06-12 22:49:23.432 UTC [1] HINT: Future log output will appear in directory "log". immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2024-06-12 22:49:50.490 UTC [1] LOG: redirecting log output to logging collector process immich-postgres | 2024-06-12 22:49:50.490 UTC [1] HINT: Future log output will appear in directory "log". immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [NestFactory] Starting Nest application... immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] BullModule dependencies initialized +0ms immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] OpenTelemetryModule dependencies initialized +0ms immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] TypeOrmModule dependencies initialized +0ms immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] OpenTelemetryCoreModule dependencies initialized +0ms immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] ConfigHostModule dependencies initialized +0ms immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] DiscoveryModule dependencies initialized +0ms immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] ClsModule dependencies initialized +0ms immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] ConfigModule dependencies initialized +0ms immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] EventEmitterModule dependencies initialized +0ms immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] ScheduleModule dependencies initialized +0ms immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] BullModule dependencies initialized +0ms immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM LOG [InstanceLoader] BullModule dependencies initialized +1ms immich-server | [Nest] 7 - 06/12/2024, 6:50:12 PM LOG [NestFactory] Starting Nest application... immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)... immich-server | error: the database system is starting up immich-server | at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98) immich-server | at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29) immich-server | at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38) immich-server | at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42) immich-server | at Socket.emit (node:events:519:28) immich-server | at addChunk (node:internal/streams/readable:559:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:510:3) immich-server | at Readable.push (node:internal/streams/readable:390:5) immich-server | at TCP.onStreamRead (node:internal/stream_base_commons:191:23) immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (2)... immich-server | error: the database system is starting up immich-server | at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98) immich-server | at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29) immich-server | at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38) immich-server | at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42) immich-server | at Socket.emit (node:events:519:28) immich-server | at addChunk (node:internal/streams/readable:559:12) immich-server | at readableAddChunkPushByteMode (node:internal/streams/readable:510:3) immich-server | at Readable.push (node:internal/streams/readable:390:5) immich-server | at TCP.onStreamRead (node:internal/stream_base_commons:191:23) immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (3)... immich-server | Error: getaddrinfo ENOTFOUND database immich-server | at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26) immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (4)... immich-server | Error: getaddrinfo ENOTFOUND database immich-server | at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26) immich-server | [Nest] 7 - 06/12/2024, 6:50:12 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)... immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (5)... immich-server | Error: getaddrinfo ENOTFOUND database immich-server | at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26) immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (6)... immich-server | Error: getaddrinfo ENOTFOUND database immich-server | at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26) immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (7)... immich-server | Error: getaddrinfo ENOTFOUND database immich-server | at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26) immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (8)... immich-server | Error: getaddrinfo ENOTFOUND database immich-server | at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26) immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (9)... immich-server | Error: getaddrinfo ENOTFOUND database immich-server | at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26) immich-server | [Nest] 17 - 06/12/2024, 6:50:12 PM ERROR [ExceptionHandler] getaddrinfo ENOTFOUND database immich-server | Error: getaddrinfo ENOTFOUND database immich-server | at GetAddrInfoReqWrap.onlookupall [as oncomplete] (node:dns:120:26) immich-server | microservices worker exited with code 1 immich-server exited with code 0 immich-server | Detected CPU Cores: 12 immich-server | Starting api worker immich-server | Starting microservices worker immich-postgres | immich-postgres | PostgreSQL Database directory appears to contain a database; Skipping initialization immich-postgres | immich-postgres | 2024-06-12 22:50:43.168 UTC [1] LOG: redirecting log output to logging collector process immich-postgres | 2024-06-12 22:50:43.168 UTC [1] HINT: Future log output will appear in directory "log". ^CGracefully stopping... (press Ctrl+C again to force) [+] Stopping 4/4 ✔ Container immich-machinelearning Stopped 0.3s ✔ Container immich-server Stopped 0.4s ✔ Container immich-postgres Stopped 0.0s ✔ Container immich-redis Stopped 0.3s canceled ``` ### Additional information ``` 2024-06-12 02:57:29.817 UTC [1] LOG: received fast shutdown request 2024-06-12 02:57:29.828 UTC [1] LOG: aborting any active transactions 2024-06-12 02:57:29.828 UTC [1723] FATAL: terminating connection due to administrator command 2024-06-12 02:57:29.828 UTC [55] FATAL: terminating connection due to administrator command 2024-06-12 02:57:29.828 UTC [54] FATAL: terminating connection due to administrator command 2024-06-12 02:57:29.830 UTC [1] LOG: background worker "logical replication launcher" (PID 35) exited with exit code 1 2024-06-12 02:57:29.834 UTC [30] LOG: shutting down 2024-06-12 02:57:29.994 UTC [1] LOG: database system is shut down 2024-06-12 03:18:48.160 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 03:18:48.160 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 03:18:48.160 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 03:18:48.164 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 03:18:48.186 UTC [27] LOG: database system was shut down at 2024-06-12 02:57:29 UTC [2024-06-12T03:18:48Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T03:18:48Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T03:18:48Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". 2024-06-12 03:18:48.251 UTC [1] LOG: database system is ready to accept connections [2024-06-12T03:18:48Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". 2024-06-12 03:19:18.185 UTC [54] FATAL: role "root" does not exist 2024-06-12 03:24:18.460 UTC [69] FATAL: role "root" does not exist 2024-06-12 03:29:18.565 UTC [84] FATAL: role "root" does not exist 2024-06-12 03:34:18.669 UTC [99] FATAL: role "root" does not exist 2024-06-12 03:39:18.785 UTC [114] FATAL: role "root" does not exist 2024-06-12 03:44:18.882 UTC [129] FATAL: role "root" does not exist 2024-06-12 03:49:18.992 UTC [144] FATAL: role "root" does not exist 2024-06-12 03:54:19.106 UTC [159] FATAL: role "root" does not exist 2024-06-12 03:59:19.212 UTC [174] FATAL: role "root" does not exist 2024-06-12 04:04:19.324 UTC [189] FATAL: role "root" does not exist 2024-06-12 04:09:19.462 UTC [204] FATAL: role "root" does not exist 2024-06-12 04:14:19.559 UTC [219] FATAL: role "root" does not exist 2024-06-12 04:19:19.664 UTC [234] FATAL: role "root" does not exist 2024-06-12 04:24:19.772 UTC [249] FATAL: role "root" does not exist 2024-06-12 04:29:19.892 UTC [264] FATAL: role "root" does not exist 2024-06-12 04:34:20.009 UTC [279] FATAL: role "root" does not exist 2024-06-12 04:39:20.126 UTC [294] FATAL: role "root" does not exist 2024-06-12 04:44:20.239 UTC [309] FATAL: role "root" does not exist 2024-06-12 04:49:20.338 UTC [324] FATAL: role "root" does not exist 2024-06-12 04:54:20.455 UTC [339] FATAL: role "root" does not exist 2024-06-12 04:59:20.555 UTC [354] FATAL: role "root" does not exist 2024-06-12 05:04:20.679 UTC [369] FATAL: role "root" does not exist 2024-06-12 05:09:20.792 UTC [384] FATAL: role "root" does not exist 2024-06-12 05:14:20.902 UTC [399] FATAL: role "root" does not exist 2024-06-12 05:19:21.009 UTC [414] FATAL: role "root" does not exist 2024-06-12 05:24:21.113 UTC [429] FATAL: role "root" does not exist 2024-06-12 05:29:21.205 UTC [444] FATAL: role "root" does not exist 2024-06-12 05:34:21.322 UTC [459] FATAL: role "root" does not exist 2024-06-12 05:39:21.432 UTC [474] FATAL: role "root" does not exist 2024-06-12 05:44:21.538 UTC [489] FATAL: role "root" does not exist 2024-06-12 05:49:21.645 UTC [504] FATAL: role "root" does not exist 2024-06-12 05:54:21.758 UTC [519] FATAL: role "root" does not exist 2024-06-12 05:59:21.860 UTC [534] FATAL: role "root" does not exist 2024-06-12 06:04:21.955 UTC [549] FATAL: role "root" does not exist 2024-06-12 06:09:22.065 UTC [564] FATAL: role "root" does not exist 2024-06-12 06:14:22.198 UTC [579] FATAL: role "root" does not exist 2024-06-12 06:19:22.302 UTC [594] FATAL: role "root" does not exist 2024-06-12 06:24:22.405 UTC [609] FATAL: role "root" does not exist 2024-06-12 06:29:22.486 UTC [624] FATAL: role "root" does not exist 2024-06-12 06:34:22.588 UTC [639] FATAL: role "root" does not exist 2024-06-12 06:39:22.708 UTC [654] FATAL: role "root" does not exist 2024-06-12 06:44:22.845 UTC [669] FATAL: role "root" does not exist 2024-06-12 06:49:22.958 UTC [684] FATAL: role "root" does not exist 2024-06-12 06:54:23.064 UTC [699] FATAL: role "root" does not exist 2024-06-12 06:59:23.169 UTC [714] FATAL: role "root" does not exist 2024-06-12 07:04:23.281 UTC [729] FATAL: role "root" does not exist 2024-06-12 07:09:23.414 UTC [744] FATAL: role "root" does not exist 2024-06-12 07:14:23.528 UTC [759] FATAL: role "root" does not exist 2024-06-12 07:19:23.641 UTC [774] FATAL: role "root" does not exist 2024-06-12 07:24:23.748 UTC [789] FATAL: role "root" does not exist 2024-06-12 07:29:23.851 UTC [804] FATAL: role "root" does not exist 2024-06-12 07:34:23.966 UTC [819] FATAL: role "root" does not exist 2024-06-12 07:39:24.071 UTC [834] FATAL: role "root" does not exist 2024-06-12 07:44:24.165 UTC [849] FATAL: role "root" does not exist 2024-06-12 07:49:24.264 UTC [864] FATAL: role "root" does not exist 2024-06-12 07:54:24.371 UTC [879] FATAL: role "root" does not exist 2024-06-12 07:59:24.473 UTC [894] FATAL: role "root" does not exist 2024-06-12 08:04:24.589 UTC [909] FATAL: role "root" does not exist 2024-06-12 08:09:24.666 UTC [924] FATAL: role "root" does not exist 2024-06-12 08:14:24.771 UTC [939] FATAL: role "root" does not exist 2024-06-12 08:19:24.864 UTC [954] FATAL: role "root" does not exist 2024-06-12 08:24:24.967 UTC [969] FATAL: role "root" does not exist 2024-06-12 08:29:25.087 UTC [984] FATAL: role "root" does not exist 2024-06-12 08:34:25.204 UTC [999] FATAL: role "root" does not exist 2024-06-12 08:39:25.297 UTC [1014] FATAL: role "root" does not exist 2024-06-12 08:44:25.411 UTC [1029] FATAL: role "root" does not exist 2024-06-12 08:49:25.514 UTC [1044] FATAL: role "root" does not exist 2024-06-12 08:54:25.627 UTC [1059] FATAL: role "root" does not exist 2024-06-12 08:59:25.724 UTC [1074] FATAL: role "root" does not exist 2024-06-12 09:04:25.834 UTC [1089] FATAL: role "root" does not exist 2024-06-12 09:09:25.954 UTC [1104] FATAL: role "root" does not exist 2024-06-12 09:14:26.067 UTC [1119] FATAL: role "root" does not exist 2024-06-12 09:19:26.170 UTC [1134] FATAL: role "root" does not exist 2024-06-12 09:24:26.293 UTC [1149] FATAL: role "root" does not exist 2024-06-12 09:29:26.404 UTC [1164] FATAL: role "root" does not exist 2024-06-12 09:34:26.524 UTC [1179] FATAL: role "root" does not exist 2024-06-12 09:39:26.643 UTC [1194] FATAL: role "root" does not exist 2024-06-12 09:44:26.750 UTC [1209] FATAL: role "root" does not exist 2024-06-12 09:49:26.884 UTC [1224] FATAL: role "root" does not exist 2024-06-12 09:54:26.996 UTC [1239] FATAL: role "root" does not exist 2024-06-12 09:59:27.120 UTC [1254] FATAL: role "root" does not exist 2024-06-12 10:04:27.213 UTC [1269] FATAL: role "root" does not exist 2024-06-12 10:09:27.310 UTC [1284] FATAL: role "root" does not exist 2024-06-12 10:14:27.428 UTC [1299] FATAL: role "root" does not exist 2024-06-12 10:19:27.554 UTC [1314] FATAL: role "root" does not exist 2024-06-12 10:24:27.664 UTC [1329] FATAL: role "root" does not exist 2024-06-12 10:29:27.773 UTC [1344] FATAL: role "root" does not exist 2024-06-12 10:34:27.878 UTC [1359] FATAL: role "root" does not exist 2024-06-12 10:39:27.987 UTC [1374] FATAL: role "root" does not exist 2024-06-12 10:44:28.104 UTC [1389] FATAL: role "root" does not exist 2024-06-12 10:49:28.213 UTC [1404] FATAL: role "root" does not exist 2024-06-12 10:54:28.353 UTC [1419] FATAL: role "root" does not exist 2024-06-12 10:59:28.477 UTC [1434] FATAL: role "root" does not exist 2024-06-12 11:04:28.586 UTC [1449] FATAL: role "root" does not exist 2024-06-12 11:09:28.707 UTC [1464] FATAL: role "root" does not exist 2024-06-12 11:14:28.833 UTC [1479] FATAL: role "root" does not exist 2024-06-12 11:19:28.930 UTC [1494] FATAL: role "root" does not exist 2024-06-12 11:24:29.057 UTC [1509] FATAL: role "root" does not exist 2024-06-12 11:29:29.163 UTC [1524] FATAL: role "root" does not exist 2024-06-12 11:34:29.293 UTC [1539] FATAL: role "root" does not exist 2024-06-12 11:39:29.393 UTC [1554] FATAL: role "root" does not exist 2024-06-12 11:44:29.496 UTC [1569] FATAL: role "root" does not exist 2024-06-12 11:49:29.623 UTC [1584] FATAL: role "root" does not exist 2024-06-12 11:54:29.753 UTC [1599] FATAL: role "root" does not exist 2024-06-12 11:59:29.860 UTC [1614] FATAL: role "root" does not exist 2024-06-12 12:04:29.974 UTC [1629] FATAL: role "root" does not exist 2024-06-12 12:09:30.086 UTC [1644] FATAL: role "root" does not exist 2024-06-12 12:14:30.200 UTC [1659] FATAL: role "root" does not exist 2024-06-12 12:19:30.313 UTC [1674] FATAL: role "root" does not exist 2024-06-12 12:24:30.426 UTC [1689] FATAL: role "root" does not exist 2024-06-12 12:29:30.540 UTC [1704] FATAL: role "root" does not exist 2024-06-12 12:34:30.649 UTC [1719] FATAL: role "root" does not exist 2024-06-12 12:39:30.746 UTC [1734] FATAL: role "root" does not exist 2024-06-12 12:44:30.849 UTC [1749] FATAL: role "root" does not exist 2024-06-12 12:49:30.953 UTC [1764] FATAL: role "root" does not exist 2024-06-12 12:54:31.079 UTC [1779] FATAL: role "root" does not exist 2024-06-12 12:59:31.155 UTC [1794] FATAL: role "root" does not exist 2024-06-12 13:04:31.269 UTC [1809] FATAL: role "root" does not exist 2024-06-12 13:09:31.406 UTC [1824] FATAL: role "root" does not exist 2024-06-12 13:14:31.546 UTC [1839] FATAL: role "root" does not exist 2024-06-12 13:19:31.659 UTC [1854] FATAL: role "root" does not exist 2024-06-12 13:24:31.769 UTC [1869] FATAL: role "root" does not exist 2024-06-12 13:29:31.876 UTC [1884] FATAL: role "root" does not exist 2024-06-12 13:34:31.953 UTC [1899] FATAL: role "root" does not exist 2024-06-12 13:39:32.075 UTC [1914] FATAL: role "root" does not exist 2024-06-12 13:44:32.172 UTC [1929] FATAL: role "root" does not exist 2024-06-12 13:49:32.282 UTC [1944] FATAL: role "root" does not exist 2024-06-12 13:54:32.389 UTC [1959] FATAL: role "root" does not exist 2024-06-12 13:59:32.512 UTC [1974] FATAL: role "root" does not exist 2024-06-12 14:04:32.619 UTC [1989] FATAL: role "root" does not exist 2024-06-12 14:09:32.732 UTC [2004] FATAL: role "root" does not exist 2024-06-12 14:14:32.829 UTC [2019] FATAL: role "root" does not exist 2024-06-12 14:19:32.932 UTC [2034] FATAL: role "root" does not exist 2024-06-12 14:24:33.035 UTC [2049] FATAL: role "root" does not exist 2024-06-12 14:29:33.155 UTC [2064] FATAL: role "root" does not exist 2024-06-12 14:34:33.273 UTC [2079] FATAL: role "root" does not exist 2024-06-12 14:39:33.378 UTC [2094] FATAL: role "root" does not exist 2024-06-12 14:44:33.485 UTC [2109] FATAL: role "root" does not exist 2024-06-12 14:49:33.592 UTC [2124] FATAL: role "root" does not exist 2024-06-12 14:54:00.649 UTC [1] LOG: received fast shutdown request 2024-06-12 14:54:00.661 UTC [1] LOG: aborting any active transactions 2024-06-12 14:54:00.662 UTC [1] LOG: background worker "logical replication launcher" (PID 39) exited with exit code 1 2024-06-12 14:54:00.663 UTC [29] LOG: shutting down 2024-06-12 14:54:00.700 UTC [1] LOG: database system is shut down 2024-06-12 14:59:01.921 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 14:59:01.921 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 14:59:01.921 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 14:59:01.925 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 14:59:01.955 UTC [28] LOG: database system was shut down at 2024-06-12 14:54:00 UTC [2024-06-12T14:59:01Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T14:59:01Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T14:59:01Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". 2024-06-12 14:59:02.004 UTC [1] LOG: database system is ready to accept connections [2024-06-12T14:59:02Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". 2024-06-12 14:59:31.929 UTC [55] FATAL: role "root" does not exist 2024-06-12 15:01:48.433 UTC [1] LOG: received fast shutdown request 2024-06-12 15:01:48.447 UTC [1] LOG: aborting any active transactions 2024-06-12 15:01:48.449 UTC [1] LOG: background worker "logical replication launcher" (PID 35) exited with exit code 1 2024-06-12 15:01:48.449 UTC [30] LOG: shutting down 2024-06-12 15:01:48.518 UTC [1] LOG: database system is shut down 2024-06-12 15:01:49.502 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 15:01:49.502 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 15:01:49.502 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 15:01:49.506 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 15:01:49.512 UTC [27] LOG: database system was shut down at 2024-06-12 15:01:48 UTC [2024-06-12T15:01:49Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T15:01:49Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T15:01:49Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". [2024-06-12T15:01:49Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". 2024-06-12 15:01:49.523 UTC [1] LOG: database system is ready to accept connections 2024-06-12 15:02:19.499 UTC [54] FATAL: role "root" does not exist 2024-06-12 15:07:19.616 UTC [69] FATAL: role "root" does not exist 2024-06-12 15:12:19.725 UTC [94] FATAL: role "root" does not exist 2024-06-12 15:17:19.832 UTC [113] FATAL: role "root" does not exist 2024-06-12 15:22:19.929 UTC [133] FATAL: role "root" does not exist 2024-06-12 15:27:20.032 UTC [148] FATAL: role "root" does not exist 2024-06-12 15:32:20.145 UTC [163] FATAL: role "root" does not exist 2024-06-12 15:37:20.251 UTC [178] FATAL: role "root" does not exist 2024-06-12 15:42:20.362 UTC [193] FATAL: role "root" does not exist 2024-06-12 15:47:20.468 UTC [208] FATAL: role "root" does not exist 2024-06-12 15:52:20.589 UTC [223] FATAL: role "root" does not exist 2024-06-12 15:57:20.698 UTC [238] FATAL: role "root" does not exist 2024-06-12 16:02:20.774 UTC [253] FATAL: role "root" does not exist 2024-06-12 16:07:20.892 UTC [268] FATAL: role "root" does not exist 2024-06-12 16:12:20.995 UTC [283] FATAL: role "root" does not exist 2024-06-12 16:17:21.108 UTC [298] FATAL: role "root" does not exist 2024-06-12 16:22:21.231 UTC [313] FATAL: role "root" does not exist 2024-06-12 16:27:21.337 UTC [328] FATAL: role "root" does not exist 2024-06-12 16:32:21.451 UTC [343] FATAL: role "root" does not exist 2024-06-12 16:37:21.526 UTC [358] FATAL: role "root" does not exist 2024-06-12 16:42:21.638 UTC [373] FATAL: role "root" does not exist 2024-06-12 16:47:21.751 UTC [388] FATAL: role "root" does not exist 2024-06-12 16:52:21.878 UTC [403] FATAL: role "root" does not exist 2024-06-12 16:57:21.998 UTC [418] FATAL: role "root" does not exist 2024-06-12 17:02:22.114 UTC [433] FATAL: role "root" does not exist 2024-06-12 17:07:22.211 UTC [448] FATAL: role "root" does not exist 2024-06-12 17:12:22.331 UTC [463] FATAL: role "root" does not exist 2024-06-12 17:17:22.434 UTC [478] FATAL: role "root" does not exist 2024-06-12 17:22:22.531 UTC [493] FATAL: role "root" does not exist 2024-06-12 17:27:22.657 UTC [508] FATAL: role "root" does not exist 2024-06-12 17:32:22.754 UTC [523] FATAL: role "root" does not exist 2024-06-12 17:37:22.858 UTC [538] FATAL: role "root" does not exist 2024-06-12 17:42:22.961 UTC [553] FATAL: role "root" does not exist 2024-06-12 17:47:23.074 UTC [568] FATAL: role "root" does not exist 2024-06-12 17:52:23.190 UTC [583] FATAL: role "root" does not exist 2024-06-12 17:57:23.321 UTC [598] FATAL: role "root" does not exist 2024-06-12 18:02:23.441 UTC [613] FATAL: role "root" does not exist 2024-06-12 18:07:23.540 UTC [628] FATAL: role "root" does not exist 2024-06-12 18:12:23.661 UTC [643] FATAL: role "root" does not exist 2024-06-12 18:17:23.790 UTC [658] FATAL: role "root" does not exist 2024-06-12 18:22:23.884 UTC [673] FATAL: role "root" does not exist 2024-06-12 18:27:24.015 UTC [688] FATAL: role "root" does not exist 2024-06-12 18:32:24.114 UTC [703] FATAL: role "root" does not exist 2024-06-12 18:37:24.217 UTC [718] FATAL: role "root" does not exist 2024-06-12 18:42:24.320 UTC [733] FATAL: role "root" does not exist 2024-06-12 18:47:24.427 UTC [748] FATAL: role "root" does not exist 2024-06-12 18:52:24.520 UTC [763] FATAL: role "root" does not exist 2024-06-12 18:57:24.624 UTC [778] FATAL: role "root" does not exist 2024-06-12 19:02:24.747 UTC [793] FATAL: role "root" does not exist 2024-06-12 19:07:24.854 UTC [808] FATAL: role "root" does not exist 2024-06-12 19:12:24.946 UTC [823] FATAL: role "root" does not exist 2024-06-12 19:17:25.060 UTC [838] FATAL: role "root" does not exist 2024-06-12 19:22:25.167 UTC [853] FATAL: role "root" does not exist 2024-06-12 19:27:25.290 UTC [868] FATAL: role "root" does not exist 2024-06-12 19:32:25.394 UTC [883] FATAL: role "root" does not exist 2024-06-12 19:37:25.493 UTC [898] FATAL: role "root" does not exist 2024-06-12 19:42:25.614 UTC [913] FATAL: role "root" does not exist 2024-06-12 19:47:25.706 UTC [928] FATAL: role "root" does not exist 2024-06-12 19:52:25.804 UTC [943] FATAL: role "root" does not exist 2024-06-12 19:57:25.920 UTC [958] FATAL: role "root" does not exist 2024-06-12 20:02:26.040 UTC [973] FATAL: role "root" does not exist 2024-06-12 20:07:26.150 UTC [988] FATAL: role "root" does not exist 2024-06-12 20:12:26.270 UTC [1003] FATAL: role "root" does not exist 2024-06-12 20:17:26.380 UTC [1018] FATAL: role "root" does not exist 2024-06-12 20:20:03.454 UTC [1] LOG: could not open file "postmaster.pid": No such file or directory 2024-06-12 20:20:03.454 UTC [1] LOG: performing immediate shutdown because data directory lock file is invalid 2024-06-12 20:20:03.454 UTC [1] LOG: received immediate shutdown request 2024-06-12 20:20:03.454 UTC [1] LOG: could not open file "postmaster.pid": No such file or directory 2024-06-12 20:20:03.461 UTC [1] LOG: database system is shut down 2024-06-12 20:18:06.659 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 20:18:06.659 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 20:18:06.659 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 20:18:06.663 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 20:18:06.669 UTC [28] LOG: database system was interrupted; last known up at 2024-06-12 20:16:54 UTC [2024-06-12T20:18:06Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T20:18:06Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T20:18:06Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". [2024-06-12T20:18:06Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". 2024-06-12 20:18:06.696 UTC [28] LOG: database system was not properly shut down; automatic recovery in progress 2024-06-12 20:18:06.702 UTC [28] LOG: redo starts at 0/2F2AB9B8 2024-06-12 20:18:06.702 UTC [28] LOG: invalid record length at 0/2F2ABFF8: wanted 24, got 0 2024-06-12 20:18:06.702 UTC [28] LOG: redo done at 0/2F2ABFD0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-06-12 20:18:06.741 UTC [1] LOG: database system is ready to accept connections 2024-06-12 20:18:36.667 UTC [55] FATAL: role "root" does not exist 2024-06-12 20:19:55.108 UTC [1] LOG: received fast shutdown request 2024-06-12 20:19:55.119 UTC [1] LOG: aborting any active transactions 2024-06-12 20:19:55.121 UTC [1] LOG: background worker "logical replication launcher" (PID 47) exited with exit code 1 2024-06-12 20:19:55.121 UTC [42] LOG: shutting down 2024-06-12 20:19:55.144 UTC [1] LOG: database system is shut down 2024-06-12 20:20:04.028 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 20:20:04.028 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 20:20:04.028 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 20:20:04.033 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 20:20:04.038 UTC [27] LOG: database system was shut down at 2024-06-12 20:19:55 UTC 2024-06-12 20:20:04.039 UTC [27] LOG: incorrect resource manager data checksum in record at 0/2F2AC0C0 2024-06-12 20:20:04.039 UTC [27] LOG: invalid primary checkpoint record 2024-06-12 20:20:04.039 UTC [27] PANIC: could not locate a valid checkpoint record [2024-06-12T20:20:04Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T20:20:04Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T20:20:04Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". [2024-06-12T20:20:04Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". 2024-06-12 20:20:04.705 UTC [41] FATAL: the database system is starting up 2024-06-12 20:20:05.129 UTC [1] LOG: startup process (PID 27) was terminated by signal 6: Aborted 2024-06-12 20:20:05.129 UTC [1] LOG: aborting startup due to startup process failure 2024-06-12 20:20:05.130 UTC [1] LOG: database system is shut down 2024-06-12 20:20:05.773 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 20:20:05.773 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 20:20:05.773 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 20:20:05.776 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 20:20:05.782 UTC [27] LOG: database system was shut down at 2024-06-12 20:19:55 UTC 2024-06-12 20:20:05.783 UTC [27] LOG: incorrect resource manager data checksum in record at 0/2F2AC0C0 2024-06-12 20:20:05.783 UTC [27] LOG: invalid primary checkpoint record 2024-06-12 20:20:05.783 UTC [27] PANIC: could not locate a valid checkpoint record [2024-06-12T20:20:05Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T20:20:05Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T20:20:05Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". [2024-06-12T20:20:05Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". 2024-06-12 20:20:06.053 UTC [41] FATAL: the database system is starting up 2024-06-12 20:20:06.219 UTC [42] FATAL: the database system is starting up 2024-06-12 20:20:06.302 UTC [43] FATAL: the database system is starting up 2024-06-12 20:20:06.917 UTC [1] LOG: startup process (PID 27) was terminated by signal 6: Aborted 2024-06-12 20:20:06.917 UTC [1] LOG: aborting startup due to startup process failure 2024-06-12 20:20:06.919 UTC [1] LOG: database system is shut down 2024-06-12 20:20:07.449 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 20:20:07.449 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 20:20:07.449 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 20:20:07.453 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 20:20:07.459 UTC [28] LOG: database system was shut down at 2024-06-12 20:19:55 UTC 2024-06-12 20:20:07.459 UTC [28] LOG: incorrect resource manager data checksum in record at 0/2F2AC0C0 2024-06-12 20:20:07.459 UTC [28] LOG: invalid primary checkpoint record 2024-06-12 20:20:07.459 UTC [28] PANIC: could not locate a valid checkpoint record [2024-06-12T20:20:07Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T20:20:07Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T20:20:07Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". [2024-06-12T20:20:07Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". 2024-06-12 20:20:07.806 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 20:20:07.807 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 20:20:07.807 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 20:20:07.810 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 20:20:07.816 UTC [27] LOG: database system was shut down at 2024-06-12 20:19:55 UTC 2024-06-12 20:20:07.816 UTC [27] LOG: incorrect resource manager data checksum in record at 0/2F2AC0C0 2024-06-12 20:20:07.816 UTC [27] LOG: invalid primary checkpoint record 2024-06-12 20:20:07.816 UTC [27] PANIC: could not locate a valid checkpoint record [2024-06-12T20:20:07Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T20:20:07Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T20:20:07Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". [2024-06-12T20:20:07Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". 2024-06-12 20:20:08.611 UTC [1] LOG: startup process (PID 28) was terminated by signal 6: Aborted 2024-06-12 20:20:08.611 UTC [1] LOG: aborting startup due to startup process failure 2024-06-12 20:20:08.613 UTC [1] LOG: database system is shut down 2024-06-12 20:20:08.966 UTC [41] FATAL: the database system is starting up 2024-06-12 20:20:08.981 UTC [42] FATAL: the database system is starting up 2024-06-12 20:20:09.014 UTC [1] LOG: startup process (PID 27) was terminated by signal 6: Aborted 2024-06-12 20:20:09.014 UTC [1] LOG: aborting startup due to startup process failure 2024-06-12 20:20:09.015 UTC [1] LOG: database system is shut down 2024-06-12 20:20:09.588 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 20:20:09.659 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 20:20:09.659 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 20:20:09.662 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 20:20:09.725 UTC [27] LOG: database system was shut down at 2024-06-12 20:19:55 UTC 2024-06-12 20:20:09.725 UTC [27] LOG: incorrect resource manager data checksum in record at 0/2F2AC0C0 2024-06-12 20:20:09.725 UTC [27] LOG: invalid primary checkpoint record 2024-06-12 20:20:09.725 UTC [27] PANIC: could not locate a valid checkpoint record [2024-06-12T20:20:09Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T20:20:09Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T20:20:09Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". [2024-06-12T20:20:09Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". 2024-06-12 20:20:10.871 UTC [1] LOG: startup process (PID 27) was terminated by signal 6: Aborted 2024-06-12 20:20:10.871 UTC [1] LOG: aborting startup due to startup process failure 2024-06-12 20:20:10.873 UTC [1] LOG: database system is shut down 2024-06-12 20:20:10.342 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 20:20:10.405 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 20:20:10.405 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 20:20:10.410 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 20:20:10.451 UTC [28] LOG: database system was shut down at 2024-06-12 20:19:55 UTC 2024-06-12 20:20:10.452 UTC [28] LOG: incorrect resource manager data checksum in record at 0/2F2AC0C0 2024-06-12 20:20:10.452 UTC [28] LOG: invalid primary checkpoint record 2024-06-12 20:20:10.452 UTC [28] PANIC: could not locate a valid checkpoint record [2024-06-12T20:20:10Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T20:20:10Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T20:20:10Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". [2024-06-12T20:20:10Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". 2024-06-12 20:20:10.580 UTC [42] FATAL: the database system is starting up 2024-06-12 20:20:10.740 UTC [43] FATAL: the database system is starting up 2024-06-12 20:20:11.063 UTC [44] FATAL: the database system is starting up 2024-06-12 20:20:11.303 UTC [45] FATAL: the database system is starting up 2024-06-12 20:20:11.602 UTC [1] LOG: startup process (PID 28) was terminated by signal 6: Aborted 2024-06-12 20:20:11.602 UTC [1] LOG: aborting startup due to startup process failure 2024-06-12 20:20:11.603 UTC [1] LOG: database system is shut down 2024-06-12 20:20:11.939 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 20:20:11.939 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 20:20:11.939 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 20:20:11.943 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 20:20:11.949 UTC [28] LOG: database system was shut down at 2024-06-12 20:19:55 UTC 2024-06-12 20:20:11.949 UTC [28] LOG: incorrect resource manager data checksum in record at 0/2F2AC0C0 2024-06-12 20:20:11.949 UTC [28] LOG: invalid primary checkpoint record 2024-06-12 20:20:11.949 UTC [28] PANIC: could not locate a valid checkpoint record [2024-06-12T20:20:11Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T20:20:11Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T20:20:11Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". [2024-06-12T20:20:11Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". 2024-06-12 20:20:13.013 UTC [1] LOG: startup process (PID 28) was terminated by signal 6: Aborted 2024-06-12 20:20:13.013 UTC [1] LOG: aborting startup due to startup process failure 2024-06-12 20:20:13.014 UTC [1] LOG: database system is shut down 2024-06-12 20:20:13.752 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 20:20:13.805 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 20:20:13.805 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 20:20:13.811 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 20:20:13.868 UTC [27] LOG: database system was shut down at 2024-06-12 20:19:55 UTC 2024-06-12 20:20:13.869 UTC [27] LOG: incorrect resource manager data checksum in record at 0/2F2AC0C0 2024-06-12 20:20:13.869 UTC [27] LOG: invalid primary checkpoint record 2024-06-12 20:20:13.869 UTC [27] PANIC: could not locate a valid checkpoint record [2024-06-12T20:20:13Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T20:20:13Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T20:20:13Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". [2024-06-12T20:20:13Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". 2024-06-12 20:20:15.026 UTC [1] LOG: startup process (PID 27) was terminated by signal 6: Aborted 2024-06-12 20:20:15.026 UTC [1] LOG: aborting startup due to startup process failure 2024-06-12 20:20:15.027 UTC [1] LOG: database system is shut down 2024-06-12 20:20:14.008 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-06-12 20:20:14.009 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-06-12 20:20:14.009 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-06-12 20:20:14.012 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-06-12 20:20:14.018 UTC [28] LOG: database system was shut down at 2024-06-12 20:19:55 UTC 2024-06-12 20:20:14.018 UTC [28] LOG: incorrect resource manager data checksum in record at 0/2F2AC0C0 2024-06-12 20:20:14.018 UTC [28] LOG: invalid primary checkpoint record 2024-06-12 20:20:14.018 UTC [28] PANIC: could not locate a valid checkpoint record [2024-06-12T20:20:14Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331". [2024-06-12T20:20:14Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332". [2024-06-12T20:20:14Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/33fe4794-2866-4f9b-ac35-abc1e98e3702". [2024-06-12T20:20:14Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17331/segments/bcdf2e1b-94dc-4397-9bff-bbf85e446260". 2024-06-12 20:20:15.149 UTC [1] LOG: startup process (PID 28) was terminated by signal 6: Aborted 2024-06-12 20:20:15.149 UTC [1] LOG: aborting startup due to startup process failure 2024-06-12 20:20:15.150 UTC [1] LOG: database system is shut down ```

deekerman closed this issue 2026-02-20 02:03:57 -05:00

deekerman referenced this issue 2026-02-20 02:18:22 -05:00

iOS Immich app uploading makes phone extremely hot #3900

deekerman referenced this issue 2026-02-20 02:18:22 -05:00

iOS Immich app uploading makes phone extremely hot #3900

Sign in to join this conversation.

No Branch/Tag specified

Branches Tags

main

renovate/typescript-projects

release/next

renovate/github-actions

chore/translations

push-nwxlpmyzkyrl

push-wzwotsylzylq

push-zpwsovysllvn

push-zunuwtznrlpm

renovate/opentofu-1.x

renovate/node

push-rsywxvptwxuv

renovate/prom-prometheus

renovate/docker.io-valkey-valkey-9

push-suusrsrnmzrp

push-xyozownmuwqp

csp-policy

uhthomas/fix-mobile-video-state

uhthomas/fix-mobile-hero-height

feat/use-native-clients

uhthomas/chore-mobile-simplify-scroll

feat/mobile-edit-3-mobile-sync-handling

feat/panorama-tiles

refactor/zod-migration

fix/maintenance-reload

refactor/restores-file-interceptor

uhthomas/fix-mobile-inconsistent-asset-detials-background

postgres-socketio

claude/auto-screenshot-web-changes-Y7efI

visual-review/pr-26535

push-lvyturrtwkrq

feat/notification

feat/library-offline-stats

feat/checksum-algorithm-indicator

feat/library-offline-count

uhthomas/feat-mobile-search-results

fix/bring-back-globalkeys

fix/map-webgl-error

feat/mobile-ocr

feat/custom-date-range

fix/mobile-video-aspect-ratio

fix/ml-ocr-batch-size

fix/timeline-rtl

feat/integrity-checks-izzy

uhthomas/fix-mobile-search-results

renovate/flutter

uhthomas/feat-sort-smart-search

renovate/github-cqlabs-homebrew-dcm-1.x

feat/video-player

feat/mobile-editing

refactor/remove-replace-with-upload

uhthomas/chore-mobile-maplibre

uhthomas/mobile-fix-asset-details-album-pop

feat/crawl-wrapper

feat/open-in-browser

push-skvzqoozqkpl

feat/edit-filters

fix/locale-settings-desc

feat/pg-queue

refactor/asset-upload

renovate/connectivity_plus-7.x

better-project-structure

uhthomas/mobile-feat-asset-viewer-details

fix/ml-rocm-build

fix/25803

feat/asset-file-apis

midzelis/wip

feature/bottom-buttons-order

sqlite_thumbs

fix-keep-correct-ios-shared-album-asset

fix-memory-generation-and-display

push-vpxwmwwxwnvw

fix-migration-width-height

revert/prettier-translations

shared-deep-link-handler

feat/thumbnail-native-clients

feat/platform-clients

fix/foreground-cloud-sync

filter-by-person

feat/csp

refactor/sidebar

fix/disable-editing

fix/view-timeline-deeplink

image-zoom-on-slow-connection

fix/merged-edited-assets

open-api-fix

feat/create-job-with-dto

use-toast-primary

feat/vitest-4

feat/ios-fastlane-match

match-signing

fix-update-time-update-timeline

feat/modal-routes

feature/mobile-view-asset-owner

feat/system-settings

feature/show-activity-count

better-info-in-asset-viewer

fix/all-people-count

feat/location-favorites

feature/rearrange-buttons-2

fix/download-storage-template

feat/kb-shortcuts-mobile

fix/people-count

push-qolzzzzxrvvn

chore/originals-in-asset-files

feat/asset-size-columns

ben/tree-a11y

new-search-filter-ui

refactor/expectSelectedReadonly

refactor/mobile-grdb

push-qvuktpxmkknu

feat/mobile-native-local-sync

refactor/timeline_ops

fix/scrubber_end

feat/version.txt

feat/context-menus

feat/server-chunked-uploads

refactor/virtualsegment

refactor/rename_daymonth_groups

fix/restrict-android-bg-worker

feat/android-periodic-worker

fix-remote-sync-clean-up

refactor/timeline_move_ops

fix/timeline_split_selectable

feat/keyboard_actions_help_modal

feat/static_frontend

feat/notification-warnign-android

feat/plugins2

feat/plugins

test/create-workflow-token-action

fix/docs-force

debug/search-result-similarity

debug/cf-chunked-uploads

feat/eslint_rule

feat/search-filter-album/web

refactor/timeline_photostream

refactor/timelineasset_asset

feat/session-permissions

feat/timeline_photostream_assetnav

feat/timeline_minor_optimize

feat/timeline_perf_nocomp

feat/timeline_search_results_actions

feat/timeline_search_results_page

fix/timeline_padding

fix/timeline_search_reactivity_warnings

feat/timeline_scrollbar

feat/timeline_stream_withviewer

fix/timeline_back_forth_nav

refactor/timeline_photostream_component

fix/generated-files-checks

fix/locate-button-local

chore/base-image-mimalloc

refactor/timeline_assetlayout

refactor/timeline_selectable

refactor/timeline_aware_actions

refactor/timeline_monthsegment

feat/remove-old-pages

chore/deps-gradle

tmp_photostream

tmp/lcms

feat/mobile-dynamic-thumbnails

fix/mobile-finer-thumbnail-concurrency

refactor/timeline1

refactor/extract_photostream

refactor/rename_load_api

refactor/timeline2

refactor/timeline3

feat/multi-select-asset-viewer

feat-no-thumbhash-cache

refactor/asset_grid

feat/faster-access-checks

fix/18991

fix/19543

chore/temp-remove

fix/21419

feat/mobile-hdr-images

chore/update-mise-lockfile

feat/mise-server-checks

feat/mise-ci

feat/windows-2025

feat/dev_cli

refactor/mobile-migrate-clients

fix/map-theme

fix/require-checkbox

chore/use_swc

feat/efficient-thumbnail-decoding

refactor/mobile-thumbhash

refactor/mobile-thumbhash-new

feat/beta-background-upload

fix/beta-timeline-memories-setting

fix/failed-uploads-not-removed

feat/mobile-shared-album

feat/groups

drift-map-page

drift-auth-user-sync

fix/disable-memory

feat/add-to-album-action

edit-date-time-action

drift-people-page

sqlite-remove-isIn

chore/required-reviewers

refact/asset-manager

fix/folder-sort

pnpm

feat/widget-multiple-server-urls

chore/medium-tests-dbname

fix/web-no-iterator-find

fix/map-pan-interruption

track-livephotos

timeline_events

chore/oxlint-migration

feat/maintenance-worker

feat/dav

chore/demo-snapshot

refactor/server-side-dedupe

feat/integrity-checks

dev/recognition-eval

lighter_buckets_test

perf/postgres-queue

postgres-queue

focus_rings

refactor/web-stores-1

refactor/add-to-taken

feat/sort-places

vet

tmp/demo-snapshot-preview

fix/server-migration-file-extension

fix/asset-update-race-condition

rknn-toolkit-lite2

refactor/mobile-split-up-search-page

feature/Add-rocm-support-for-machine-learning

feat/rocm

chore/async-hash-file

feat/shared-link-view-count

feat/rotation

feat/graphql

feat/job-ids

feat/ignore-library-permission-error

feat/docker-compose-builder

feat/kysely-typeorm

mobile/onboarding

no-video-player

fix/server-qsv-output-format

chore/server-geodata-tweaks

mobile/native-video-player-no-hero

feat/xxhash

fix/docs-concurrency

feat/local-tileserver

refactor/exif-orientation

original-path-infix

refactor/mobile/login-form-1

feat/server-editor-endpoints

fix/server-qsv-vbr

fix-mobile-db-problems

feat/ml-armnn-conversion

feat/mobile/backup-with-album-info

feat/fast-initial-sync-1

chore/handle-output_dims

feat/unassign-faces

feat/shortcuts-on-asset-grid

feat/capacitor-mobile-app-poc

feat/server-nvenc-hw-decoding

fix/mobile-fetch-non-archive

web/automation-ui

feat/mobile-server-endpoint-save-dropdown

object-storage

feat/memories-animations

dev/metrics

ml/tflite

feat/ml-export-cli

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.5.1

v2.5.0

v2.4.1

v2.4.0

v2.3.1

v2.3.0

v2.2.3

v2.2.2

v2.2.1

v2.2.0

v2.1.0

v2.0.1

v2.0.0

v1.144.1

v1.144.0

v1.143.1

v1.143.0

v1.142.1

v1.142.0

v1.141.1

v1.141.0

v1.140.1

v1.140.0

v1.139.4

v1.139.3

v1.139.2

v1.139.1

v1.139.0

v1.138.1

v1.138.0

v1.137.3

v1.137.2

v1.137.1

v1.137.0

v1.136.0

v1.135.3

v1.135.2

v1.135.1

v1.135.0

v1.134.0

v1.133.1

v1.133.0

v1.132.3

v1.132.2

v1.132.1

v1.132.0

v1.131.3

v1.131.2

v1.131.1

v1.131.0

v1.130.3

v1.130.2

v1.130.1

v1.130.0

v1.129.0

v1.128.0

v1.127.0

v1.126.1

v1.126.0

v1.125.7

v1.125.6

v1.125.5

v1.125.4

v1.125.3

v1.125.2

v1.125.1

v1.125.0

v1.124.2

v1.124.1

v1.124.0

v1.123.0

v1.122.3

v1.122.2

v1.122.1

v1.122.0

v1.121.0

v1.120.2

v1.120.1

v1.120.0

v1.119.1

v1.119.0

v1.118.2

v1.118.1

v1.118.0

v1.117.0

v1.116.2

v1.116.1

v1.116.0

v1.115.0

v1.114.0

v1.113.1

v1.113.0

v1.112.1

v1.112.0

v1.111.0

v1.110.0

v1.109.2

v1.109.1

v1.109.0

v1.108.0

v1.107.2

v1.107.1

v1.107.0

v1.106.4

v1.106.3

v1.106.2

v1.106.1

v1.106.0

v1.105.1

v1.105.0

v1.104.0

v1.103.1

v1.103.0

v1.102.3

v1.102.2

v1.102.1

v1.102.0

v1.101.0

v1.100.0

v1.99.0

v1.98.2

v1.98.1

v1.98.0

v1.97.0

v1.96.0

v1.95.1

v1.95.0

v1.94.1

v1.94.0

v1.93.3

v1.93.2

v1.93.1

v1.93.0

v1.92.1

v1.92.0

v1.91.4

v1.91.3

v1.91.2

v1.91.1

v1.91.0

v1.90.2

v1.90.1

v1.90.0

v1.89.0

v1.88.2

v1.88.1

v1.88.0

v1.87.0

v1.86.0

v1.85.0

v1.84.0

v1.83.0

v1.82.1

v1.82.0

v1.81.1

v1.81.0

v1.80.0

v1.79.1

v1.79.0

v1.78.1

v1.78.0

v1.77.0

v1.76.1

v1.76.0

v1.75.2

v1.75.1

v1.75.0

v1.74.0

v1.73.0

v1.72.2

v1.72.1

v1.72.0

v1.71.0

v1.70.0

v1.69.0

v1.68.0

v1.67.2

v1.67.1

v1.67.0

v1.66.1

v1.66.0

v1.65.0

v1.64.0

v1.63.2

v1.63.1

v1.63.0

v1.62.1

v1.62.0

v1.61.0

v1.60.0

v1.59.1

v1.59.0

v1.58.0

v1.57.1

v1.57.0

v1.56.2

v1.56.1

v1.56.0

v1.55.1

v1.55.0

v1.54.1

v1.54.0

v1.53.0

v1.52.1

v1.52.0

v1.51.2

v1.51.1

v1.51.0

v1.50.1

v1.50.0

v1.49.0

v1.48.1

v1.48.0

v1.47.3

v1.47.2

v1.47.1

v1.47.0

v1.46.1

v1.46.0

v1.45.0

v1.44.0

v1.43.1

v1.43.0

v1.42.0_65-dev

v1.41.1_64-dev

v1.41.0_64-dev

v1.40.1_63-dev

v1.40.0_63-dev

v1.39.0_61-dev

v1.38.2_60-dev

v1.38.1_60-dev

v1.38.0_60-dev

v1.37.0_58-dev

v1.36.2_56-dev

v1.36.1_55-dev

v1.36.0_55-dev

v1.35.0_54-dev

v1.34.0_53-dev

v1.33.1_52-dev

v1.33.0_52-dev

v1.32.1_51-dev

v1.32.0_50-dev

v1.31.1_49-dev

v1.31.0_49-dev

v1.30.2_48-dev

v1.30.0_46-dev

v1.29.6_45-dev

v1.29.6_44-dev

v1.29.5_44-dev

v1.29.4_44-dev

v1.29.3_43-dev

v1.29.2_43-dev

v1.29.1_43-dev

v1.29.0_42-dev

v1.28.4_41-dev

v1.28.4_42-dev

v1.28.3_41-dev

v1.28.2_40-dev

v1.28.1_39-dev

v1.28.0_38-dev

v1.27.0_37-dev

v1.26.0_36-dev

v1.25.0_35-dev

v1.24.0_34-dev

v1.23.0_33-dev

v1.22.0_32-dev

v1.21.1_31-dev

v1.21.0_31-dev

v1.20.3_30-dev

v1.20.2_30-dev

v1.20.1_30-dev

v1.20.0_30-dev

v1.19.1_29-dev

v1.19.0_29-dev

v1.18.0_27-dev

v1.17.0_25-dev

v1.16.0_23-dev

v1.15.1_21-dev

v1.15.0_21-dev

v1.14.0_21-dev

v1.13.0_20-dev

v1.12.0_18-dev

v1.11.0_17-dev

v1.10.0_15-dev

v1.9.1_14-dev

v1.9.0_13-dev

v1.8.0_12-dev

v1.7.0_11-dev

v1.6.0_10-dev

v1.5.1+9-dev

v1.5.0+8-dev

v1.4.0+7-dev

v1.4.0+6-dev

v1.4.0-dev

v1.3.0-dev

v1.3.1-dev

v0.6-dev

v0.5-dev

v0.4-dev

v0.3-dev

v0.2-dev

first-android-release

Labels

Clear labels   

accessibility

  

changelog:enhancement

  

changelog:security

  

changelog:skip

  

changelog:translation

  

cli

  

date-time

  

dependencies

  

documentation

  

external-library

  

format

  

good first issue

  

mobile-beta

  

mobile-beta

  

mobile-beta

  

needs-answer

  

nice to have

  

sharing

  

tech-debt

  

📱mobile

  

🖥️web

  

🗄️server

  

🧠machine-learning

No labels

accessibility

changelog:enhancement

changelog:security

changelog:skip

changelog:translation

cli

date-time

dependencies

documentation

external-library

format

good first issue

mobile-beta

mobile-beta

mobile-beta

needs-answer

nice to have

sharing

tech-debt

📱mobile

🖥️web

🗄️server

🧠machine-learning

Milestone

Clear milestone

No items

No milestone

Projects

Clear projects

No items

No project

Assignees

Clear assignees

No assignees

1 participant

Notifications

Subscribe

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/immich#3082

No description provided.