Keycloak version 10.0.1
We have been using keycloak in a test environment for a while now with no issues. Recently some OS updates were applied to the server (Ubuntu 16.04) and a reboot was performed and since then we cannot get keycloak to start. As far as we can tell none of the OS updates should have touched anything related to keycloak.
When trying to start keycloak we get this error related to the H2 databse:
Caused by: org.h2.jdbc.JdbcSQLException: Constraint “FK_5HG65LYBEVAVKQFKI3KPONH9V” already exists; SQL statement:
ALTER TABLE PUBLIC.REALM_REQUIRED_CREDENTIAL ADD CONSTRAINT PUBLIC.FK_5HG65LYBEVAVKQFKI3KPONH9V FOREIGN KEY(REALM_ID) REFERENCES PUBLIC.REALM(ID) NOCHECK [90045-197]
I attempted to connect to the H2 database using the web UI for H2 and I get the same error. Unfortunately I know little about Keycloak but need to get this up and running again. Can anyone help with this?