I have searched the existing issues, both open and closed, to make sure this is not a duplicate report.

• Yes

The bug

This happens when I try to use the beta timeline. The migration screen claimed it succeeded.

SqliteException(1): while executing, index idx_local_asset_checksum already exists, SQL logic error (code 1)
Causing statement: CREATE INDEX idx_local_asset_checksum ON local_asset_entity (checksum), parameters:

The OS that Immich Server is running on

Arch

Version of Immich Server

v1.137.3

Version of Immich Mobile App

v1.137.0 build 212

Platform with the issue

• Server
• Web
• Mobile

Your docker-compose.yml content

Bare metal; please tell me which dependency version infos are needed.

Your .env content

DB_HOSTNAME=localhost
DB_USERNAME=postgres
DB_PASSWORD=redacted
DB_DATABASE_NAME=immich

REDIS_HOSTNAME=localhost

IMMICH_MEDIA_LOCATION=/var/lib/immich/upload

IMMICH_MACHINE_LEARNING_ENABLED=true

# DISABLE_REVERSE_GEOCODING=false
# REVERSE_GEOCODING_PRECISION=3

IMMICH_MACHINE_LEARNING_URL=http://127.0.0.1:3003

MACHINE_LEARNING_CACHE_FOLDER=/var/lib/immich/.cache

Reproduction steps

1. Have installation
2. Try to switch to beta timeline on mobile
3. Go to the Photos or Library tab

Relevant log output

I couldn't find anything in the journalctl -efu

Additional information

I don't use the docker container because 1. having it running interferes with my Waydroid internet connection; I've tried the relevant troubleshooting steps 2. inertia 3. I maintain the very unofficial immich-server AUR package which is how I run immich