Details
-
Bug
-
Resolution: Done
-
Major
-
RH-SSO-7.2.3.GA
-
None
-
3
-
Workaround Exists
-
-
-
Keycloak Sprint 11, Keycloak Sprint 12, Keycloak Sprint 13
Description
Trying to modify an existing execution in an authentication flow gives a database constraint error only on Oracle database. It doesn't occur on the h2 database.
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DBALLO00.CONSTRAINT_AUTH_CFG_PK) violated
The issue appears to be that different SQL is run depending on database and Oracle will do both an update and insert. Attaching log with full error and with show SQL enabled.