Help Request:[Schema Validation Failure]

[christinalegaki]

Environment

Environment:

OS: Windows 11

JDK: 21 (Adoptium)

Docker Desktop (WSL2 engine)

Intention

I’m encountering a persistent SchemaManagementException when running ./gradlew serverRun, which results in an HTTP 503 error.

The Error:

org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [id] in table [feedback_response_comments]; found [int8 (Types#BIGINT)], but expecting [uuid (Types#UUID)]

Steps I’ve already taken to resolve this:

Ran ./gradlew clean serverRun.

Attempted a full database reset using docker compose down -v and manually deleting the postgres-data folder.

Executed ./gradlew liquibaseUpdate (which finished successfully).

Verified that my build.properties has the correct app.encryption.key and app.hmac.key

Resolution Attempt

No response

[samuelfangjw]

The error indicates that you are DB is using the old schema before it was cleaned up. There is no migration path, DB will have to reset and migrations applied again.

[christinalegaki]

I did a reset and I have an error: "Caused by: org.postgresql.util.PSQLException: ERROR: column "giver_type" of relation "feedback_response_comments" already exists" when runing liquibaseUpdate

[samuelfangjw]

Please share output of ./gradlew liquibaseStatus and schema dump of DB.

docker ps
docker exec <container_id> pg_dump -h localhost -p 5432 -U teammates -d teammates --schema-only > schema.sql

[christinalegaki]

I did a reset again before viewing your answer. Now both liquibaseUpdate and serverRun finishes with build successful, but I still see the 503 error.

schema.sql
status.txt

[samuelfangjw]

schema.sql is empty, suggesting that migrations have not been applied yet or the target DB is incorrect. Share the db dump after applying migrations. Please share full error logs as well.

[christinalegaki]

The issue was a port conflict between a local PostgreSQL 18 installation on Windows and the Docker container. Thank you for the help and sorry for the inconvenience.