I recently migrated my Spring Boot application along with Keycloak from MariaDB to PostgreSQL. After migration, I started encountering the following error:
Caused by: org.postgresql.util.PSQLException: ERROR: relation "keycloak.user_entity" does not exist
Position: 51
The table definitely exists, and my application can connect to the database. However, I suspect this issue might be related to how PostgreSQL handles multiple connections or table access, as the error appears when multiple processes try to access Keycloak tables simultaneously.
Steps I’ve Taken:
- Verified that the schema and all Keycloak tables are present in PostgreSQL.
- Confirmed that my application is using the correct database credentials and configurations for PostgreSQL.
- Checked the PostgreSQL logs but found no explicit locking issues.
Thanks for any insights or suggestions!
You need to sign in to view this answers
