Uploaded image for project: 'Keycloak'
  1. Keycloak
  2. KEYCLOAK-13628

keycloak fails to start with cockroach db (which essentailly is postgres) from client point of view

    Details

    • Type: Feature Request
    • Status: Triage (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Core, Database
    • Labels:
      None
    • Docs QE Status:
      NEW
    • QE Status:
      NEW

      Description

      keycloak does not start with cockroachdb database, which essentially is a postgres database.

      the error which i see is

      36:34,412 INFO [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-1) ISPN000128: Infinispan version: Infinispan 'Infinity Minus ONE +2' 9.4.16.Final
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 62) WFLYCLINF0002: Started realms cache from keycloak container
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 61) WFLYCLINF0002: Started users cache from keycloak container
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 66) WFLYCLINF0002: Started authenticationSessions cache from keycloak container
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 57) WFLYCLINF0002: Started offlineClientSessions cache from keycloak container
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 58) WFLYCLINF0002: Started actionTokens cache from keycloak container
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 60) WFLYCLINF0002: Started loginFailures cache from keycloak container
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 59) WFLYCLINF0002: Started offlineSessions cache from keycloak container
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 67) WFLYCLINF0002: Started sessions cache from keycloak container
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 56) WFLYCLINF0002: Started clientSessions cache from keycloak container
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 63) WFLYCLINF0002: Started keys cache from keycloak container
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 64) WFLYCLINF0002: Started authorization cache from keycloak container
      15:36:34,648 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 65) WFLYCLINF0002: Started work cache from keycloak container
      15:36:34,714 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 68) WFLYCLINF0002: Started client-mappings cache from ejb container
      15:36:34,766 WARN [org.jboss.as.server.deployment] (MSC service thread 1-3) WFLYSRV0273: Excluded subsystem webservices via jboss-deployment-structure.xml does not exist.
      15:36:35,218 INFO [org.keycloak.services] (ServerService Thread Pool – 64) KC-SERVICES0001: Loading config from standalone.xml or domain.xml
      15:36:35,450 INFO [org.keycloak.url.DefaultHostnameProviderFactory] (ServerService Thread Pool – 64) Frontend: <request>, Admin: <frontend>, Backend: <request>
      15:36:35,724 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 64) WFLYCLINF0002: Started realmRevisions cache from keycloak container
      15:36:35,727 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 64) WFLYCLINF0002: Started userRevisions cache from keycloak container
      15:36:35,734 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool – 64) WFLYCLINF0002: Started authorizationRevisions cache from keycloak container
      15:36:35,736 INFO [org.keycloak.connections.infinispan.DefaultInfinispanConnectionProviderFactory] (ServerService Thread Pool – 64) Node name: abc-g4fslq2, Site name: null
      15:36:37,796 INFO [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool – 64) Initializing database schema. Using changelog META-INF/jpa-changelog-master.xml
      15:36:38,134 ERROR [org.keycloak.connections.jpa.updater.liquibase.conn.DefaultLiquibaseConnectionProvider] (ServerService Thread Pool – 64) Change Set META-INF/jpa-changelog-1.0.0.Final.xml::1.0.0.Final-KEYCLOAK-5461::sthorger@redhat.com failed. Error: ERROR: multiple primary keys for table "realm_social_config" are not allowed [Failed SQL: ALTER TABLE public.REALM_SOCIAL_CONFIG ADD CONSTRAINT CONSTRAINT_1 PRIMARY KEY (REALM_ID, NAME)]
      15:36:38,139 FATAL [org.keycloak.services] (ServerService Thread Pool – 64) java.lang.RuntimeException: Failed to update database
      15:36:38,142 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool – 64) RESTEASY002225: Deploying javax.ws.rs.core.Application: class org.keycloak.services.resources.KeycloakApplication
      15:36:38,143 INFO [org.jboss.resteasy.resteasy_jaxrs.i18n] (ServerService Thread Pool – 64) RESTEASY002205: Adding provider class org.keycloak.services.error.KeycloakErrorHandler from Application class org.keycloak.services.resources.KeycloakApplication
      15:36:38,143 INFO [org.jboss.as.server] (Thread-2) WFLYSRV0220: Server shutdown has been requested via an OS signal

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                kkcmadhu Madhu KKC
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: