Created
November 14, 2016 19:19
-
-
Save abstractj/19eb8e5f25fee3b469110246066ecd08 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
17:14:56,432 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-31) SQL Error: 23505, SQLState: 23505 | |
17:14:56,432 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-31) Unique index or primary key violation: "UK_J3RWUVD56ONTGSUHOGM184WW2-2_INDEX_2 ON PUBLIC.KEYCLOAK_ROLE(NAME, CLIENT_REALM_CONSTRAINT) VALUES ( /* key:118 */ null, 'ldap-demo', null, null, 'ldap-user', null, null, null, null)"; SQL statement: | |
insert into KEYCLOAK_ROLE (CLIENT, CLIENT_REALM_CONSTRAINT, CLIENT_ROLE, DESCRIPTION, NAME, REALM, REALM_ID, SCOPE_PARAM_REQUIRED, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-173] | |
17:14:56,432 INFO [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] (default task-31) HHH000010: On release of batch it still contained JDBC statements | |
17:14:56,434 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-24) SQL Error: 23505, SQLState: 23505 | |
17:14:56,434 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-24) Unique index or primary key violation: "UK_J3RWUVD56ONTGSUHOGM184WW2-2_INDEX_2 ON PUBLIC.KEYCLOAK_ROLE(NAME, CLIENT_REALM_CONSTRAINT) VALUES ( /* key:119 */ null, 'ldap-demo', null, null, 'ldap-user', null, null, null, null)"; SQL statement: | |
insert into KEYCLOAK_ROLE (CLIENT, CLIENT_REALM_CONSTRAINT, CLIENT_ROLE, DESCRIPTION, NAME, REALM, REALM_ID, SCOPE_PARAM_REQUIRED, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-173] | |
17:14:56,434 INFO [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] (default task-24) HHH000010: On release of batch it still contained JDBC statements | |
17:14:56,434 ERROR [io.undertow.request] (default task-31) UT005023: Exception handling request to /auth/admin/realms/ldap-demo/users/65d66a0a-3e10-406f-9998-f72c8ac6bd0d/role-mappings/realm: org.jboss.resteasy.spi.UnhandledException: org.keycloak.models.ModelDuplicateException: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement | |
at org.jboss.resteasy.core.ExceptionHandler.handleApplicationException(ExceptionHandler.java:76) | |
at org.jboss.resteasy.core.ExceptionHandler.handleException(ExceptionHandler.java:212) | |
at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:168) | |
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:411) | |
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202) | |
at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221) | |
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56) | |
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51) | |
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) | |
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) | |
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) | |
at org.keycloak.services.filters.KeycloakSessionServletFilter.doFilter(KeycloakSessionServletFilter.java:90) | |
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) | |
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) | |
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) | |
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) | |
at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78) | |
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) | |
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) | |
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) | |
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) | |
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) | |
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) | |
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) | |
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) | |
at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50) | |
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) | |
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) | |
at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) | |
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) | |
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) | |
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:284) | |
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:263) | |
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81) | |
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:174) | |
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:202) | |
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:793) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) | |
at java.lang.Thread.run(Thread.java:745) | |
Caused by: org.keycloak.models.ModelDuplicateException: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement | |
at org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:57) | |
at org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:51) | |
at com.sun.proxy.$Proxy63.flush(Unknown Source) | |
at org.keycloak.models.jpa.JpaRealmProvider.addRealmRole(JpaRealmProvider.java:199) | |
at org.keycloak.models.jpa.JpaRealmProvider.addRealmRole(JpaRealmProvider.java:187) | |
at org.keycloak.models.cache.infinispan.RealmCacheSession.addRealmRole(RealmCacheSession.java:566) | |
at org.keycloak.models.cache.infinispan.RealmCacheSession.addRealmRole(RealmCacheSession.java:558) | |
at org.keycloak.models.jpa.RealmAdapter.addRole(RealmAdapter.java:932) | |
at org.keycloak.models.cache.infinispan.RealmAdapter.addRole(RealmAdapter.java:815) | |
at org.keycloak.federation.ldap.mappers.membership.role.RoleLDAPFederationMapper$LDAPRoleMappingsUserDelegate.getLDAPRoleMappingsConverted(RoleLDAPFederationMapper.java:406) | |
at org.keycloak.federation.ldap.mappers.membership.role.RoleLDAPFederationMapper$LDAPRoleMappingsUserDelegate.getRealmRoleMappings(RoleLDAPFederationMapper.java:313) | |
at org.keycloak.models.utils.UserModelDelegate.getRealmRoleMappings(UserModelDelegate.java:162) | |
at org.keycloak.federation.ldap.mappers.membership.role.RoleLDAPFederationMapper$LDAPRoleMappingsUserDelegate.getRealmRoleMappings(RoleLDAPFederationMapper.java:325) | |
at org.keycloak.services.resources.admin.RoleMapperResource.getRealmRoleMappings(RoleMapperResource.java:161) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:498) | |
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:139) | |
at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:295) | |
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:249) | |
at org.jboss.resteasy.core.ResourceLocatorInvoker.invokeOnTargetObject(ResourceLocatorInvoker.java:138) | |
at org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:107) | |
at org.jboss.resteasy.core.ResourceLocatorInvoker.invokeOnTargetObject(ResourceLocatorInvoker.java:133) | |
at org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:107) | |
at org.jboss.resteasy.core.ResourceLocatorInvoker.invokeOnTargetObject(ResourceLocatorInvoker.java:133) | |
at org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:107) | |
at org.jboss.resteasy.core.ResourceLocatorInvoker.invokeOnTargetObject(ResourceLocatorInvoker.java:133) | |
at org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:101) | |
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:395) | |
... 37 more | |
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement | |
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692) | |
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602) | |
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608) | |
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1303) | |
at sun.reflect.GeneratedMethodAccessor306.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:498) | |
at org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:49) | |
... 66 more | |
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement | |
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112) | |
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) | |
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) | |
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95) | |
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207) | |
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45) | |
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2886) | |
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3386) | |
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89) | |
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:560) | |
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434) | |
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337) | |
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) | |
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282) | |
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1300) | |
... 70 more | |
Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "UK_J3RWUVD56ONTGSUHOGM184WW2-2_INDEX_2 ON PUBLIC.KEYCLOAK_ROLE(NAME, CLIENT_REALM_CONSTRAINT) VALUES ( /* key:119 */ null, 'ldap-demo', null, null, 'ldap-user', null, null, null, null)"; SQL statement: | |
insert into KEYCLOAK_ROLE (CLIENT, CLIENT_REALM_CONSTRAINT, CLIENT_ROLE, DESCRIPTION, NAME, REALM, REALM_ID, SCOPE_PARAM_REQUIRED, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-173] | |
at org.h2.message.DbException.getJdbcSQLException(DbException.java:331) | |
at org.h2.message.DbException.get(DbException.java:171) | |
at org.h2.message.DbException.get(DbException.java:148) | |
at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:101) | |
at org.h2.index.PageBtree.find(PageBtree.java:121) | |
at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:148) | |
at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:101) | |
at org.h2.index.PageBtreeNode.addRowTry(PageBtreeNode.java:201) | |
at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:95) | |
at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:86) | |
at org.h2.table.RegularTable.addRow(RegularTable.java:125) | |
at org.h2.command.dml.Insert.insertRows(Insert.java:127) | |
at org.h2.command.dml.Insert.update(Insert.java:86) | |
at org.h2.command.CommandContainer.update(CommandContainer.java:79) | |
at org.h2.command.Command.executeUpdate(Command.java:235) | |
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:154) | |
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:140) | |
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537) | |
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204) | |
... 80 more | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment