Troubleshooting Phoenix Docker Postgres Migration Errors
Hello. I am having issue spinning up phoenix with docker postgres db. I keep getting the below error. ` ⚠️⚠️ Phoenix failed to migrate the database to the latest version. ⚠️⚠️ phoenix-1 | phoenix-1 | The database may be in a dirty state. To resolve this, the Alembic CLI can be used phoenix-1 | from the `src/phoenix/db` directory inside the Phoenix project root. From here, phoenix-1 | revert any partial migrations and run `alembic stamp` to reset the migration state, phoenix-1 | then try starting Phoenix again. ` Below is the docker compose file to reproduce the error. ```yaml # docker-compose.yml services: phoenix: image: arizephoenix/phoenix:latest # Must be greater than 4.0 version to work depends_on: - db ports: - 6006:6006 # PHOENIX_PORT - 4317:4317 # PHOENIX_GRPC_PORT - 9090:9090 # [Optional] PROMETHEUS PORT IF ENABLED environment: - PHOENIX_SQL_DATABASE_URL=postgresql://phoenix:postgres@db:5434/postgres db: image: postgres restart: always environment: - POSTGRES_USER=phoenix - POSTGRES_PASSWORD=postgres - POSTGRES_DB=postgres ports: - 5434 volumes: - database_data:/var/lib/postgresql/data volumes: database_data: driver: local
