[keycloak-user] liquibase.exception.DatabaseException

[Marc Tempelmeier]

Hi,

It´s difficult to provide a whole step guide, because it´s a domain controlled cluster with master and 3 slaves.
It happens 4 out of 5 starts and as I see it only on the first slave. I wait for every slave boots and then start the next.
The first slave produces the unregister message, but the master does not recognize this unregister in its logs.

I use Keycloak 3.1.0 with postgres cluster over pgpool.

Best regards

Marc

Von: Bruno Oliveira [mailto:bruno at abstractj.org]
Gesendet: Thursday, June 15, 2017 1:21 PM
An: Marc Tempelmeier <marc.tempelmeier at flane.de>; keycloak-user at lists.jboss.org
Betreff: Re: [keycloak-user] liquibase.exception.DatabaseException


What would be the steps to reproduce and version of the KC server?

On Thu, Jun 15, 2017, 4:09 AM Marc Tempelmeier <marc.tempelmeier at flane.de<mailto:marc.tempelmeier at flane.de>> wrote:
Hi,

Is this a bug?

[Server:slave1] 14:12:02,873 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "keycloak-server.war")]) - failure description: {"WFLYCTL0080: Failed services" => {"jboss.undertow.deployment.default-server.default-host./auth" => "org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./auth: java.lang.RuntimeException: RESTEASY003325: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
[Server:slave1]     Caused by: java.lang.RuntimeException: RESTEASY003325: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
[Server:slave1]     Caused by: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from public.databasechangeloglock: ERROR: relation \"public.databasechangeloglock\" does not exist
[Server:slave1]   Position: 22
[Server:slave1]     Caused by: liquibase.exception.DatabaseException: Error executing SQL select count(*) from public.databasechangeloglock: ERROR: relation \"public.databasechangeloglock\" does not exist
[Server:slave1]   Position: 22
[Server:slave1]     Caused by: org.postgresql.util.PSQLException: ERROR: relation \"public.databasechangeloglock\" does not exist
[Server:slave1]   Position: 22"}}

Database looks good though, after the error the slave crashed and unregistered.

BR

Marc
_______________________________________________
keycloak-user mailing list
keycloak-user at lists.jboss.org<mailto:keycloak-user at lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/keycloak-user