Database Migration Error with v1.136.0
I'm encountering a database migration error when upgrading to Immich v1.136.0. The server container continually restart due to a failed migration.
Error Details:
The migration "1752267649968-StandardizeNames" fails with:
PostgresError: relation "session" already exists sql: 'ALTER TABLE "sessions" RENAME TO "session"'
My Environment:
- Immich version: 1.136.0
- Deployment method: Docker Compose
- Database: PostgreSQL (
Steps I've Already Tried:
1. Examined both tables:
-
-
2. Backed up and dropped the
3. Restarted containers, but the migration still fails with the same error
My docker-compose configuration:
```yaml
services:
immich-server:
container_name: immich_server
image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
environment:
DB_HOSTNAME: immich_postgres
DB_PASSWORD: ${IMMICH_DB_PASSWORD}
DB_USERNAME: postgres
DB_DATABASE_NAME: immich
postgres: postgres
immich: immich
REDIS_HOSTNAME: immich_redis
volumes:
- ${IMMICH_UPLOAD_LOCATION}:/usr/src/app/upload
- /etc/localtime:/etc/localtime:ro
depends_on:
- immich-redis
- immich-database
restart: always
immich-database:
container_name: immich_postgres
image: ghcr.io/immich-app/postgres:14-vectorchord0.3.0-pgvectors0.2.0
environment:
DB_HOSTNAME: immich_postgres
POSTGRES_PASSWORD: ${IMMICH_DB_PASSWORD}
POSTGRES_USER: postgres
POSTGRES_DB: immich
POSTGRES_INITDB_ARGS: '--data-checksums'
DB_STORAGE_TYPE: 'HDD'
volumes:
- ${CONFIG_ROOT:-.}/immich/postgresql:/var/lib/postgresql/data
restart: always
profiles:
- immich
Error Details:
The migration "1752267649968-StandardizeNames" fails with:
PostgresError: relation "session" already exists sql: 'ALTER TABLE "sessions" RENAME TO "session"'
My Environment:
- Immich version: 1.136.0
- Deployment method: Docker Compose
- Database: PostgreSQL (
Steps I've Already Tried:
1. Examined both tables:
-
sessions-
session2. Backed up and dropped the
session3. Restarted containers, but the migration still fails with the same error
My docker-compose configuration:
```yaml
services:
immich-server:
container_name: immich_server
image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
environment:
DB_HOSTNAME: immich_postgres
DB_PASSWORD: ${IMMICH_DB_PASSWORD}
DB_USERNAME: postgres
DB_DATABASE_NAME: immich
postgres: postgres
immich: immich
REDIS_HOSTNAME: immich_redis
volumes:
- ${IMMICH_UPLOAD_LOCATION}:/usr/src/app/upload
- /etc/localtime:/etc/localtime:ro
depends_on:
- immich-redis
- immich-database
restart: always
immich-database:
container_name: immich_postgres
image: ghcr.io/immich-app/postgres:14-vectorchord0.3.0-pgvectors0.2.0
environment:
DB_HOSTNAME: immich_postgres
POSTGRES_PASSWORD: ${IMMICH_DB_PASSWORD}
POSTGRES_USER: postgres
POSTGRES_DB: immich
POSTGRES_INITDB_ARGS: '--data-checksums'
DB_STORAGE_TYPE: 'HDD'
volumes:
- ${CONFIG_ROOT:-.}/immich/postgresql:/var/lib/postgresql/data
restart: always
profiles:
- immich
