[keycloak-user] Domain Clustered Mode

[Marc Tempelmeier]

Also we get this errors on docker-compose startup from the postgres nodes:

postgresql-node2_1  | ERROR:  relation "public.databasechangeloglock" does not exist at character 22
postgresql-node2_1  | STATEMENT:  select count(*) from public.databasechangeloglock
postgresql-node1_1  | ERROR:  portal "pgpool_error_portal" does not exist
postgresql-node1_1  | ERROR:  relation "public.databasechangelog" does not exist at character 22
postgresql-node1_1  | STATEMENT:  select count(*) from public.databasechangelog
postgresql-node1_1  | ERROR:  relation "public.databasechangelog" does not exist at character 22
postgresql-node1_1  | STATEMENT:  select count(*) from public.databasechangelog

Seems really to be  liquibase connected issue

-----Ursprüngliche Nachricht-----
Von: keycloak-user-bounces at lists.jboss.org [mailto:keycloak-user-bounces at lists.jboss.org] Im Auftrag von Marc Tempelmeier
Gesendet: Tuesday, July 11, 2017 10:15 AM
An: keycloak-user at lists.jboss.org
Betreff: Re: [keycloak-user] Domain Clustered Mode

Hi again,

We fixed the bearer error, it was different time settings in the cluster...

But the liquibase errors remains, it seems we have exactly this problem:

https://stackoverflow.com/questions/26235744/liquibase-case-insensitivity-in-postgresql. As far as I see it all table names are upper case in the liquibase change files.

Any idea?

-----Ursprüngliche Nachricht-----
Von: Marc Tempelmeier 
Gesendet: Monday, July 10, 2017 9:28 AM
An: keycloak-user at lists.jboss.org
Betreff: Domain Clustered Mode

Hi,

Is there anyone here who has this working with 1 Master and 2-3 Slaves on Version 3.2.0? 

I frequently get 2 errors:

Error 1 (results in unregistering the slave):

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


Error 2 (results in immediate logout, sometimes after 1 sec or later):

10:08:22,066 ERROR [org.jboss.resteasy.resteasy_jaxrs.i18n] (default task-18) RESTEASY002005: Failed executing GET /admin/realms: org.jboss.resteasy.spi.UnauthorizedException: Bearer

If anyone has a working config, it would be really great to share :)

Best regards

Marc Tempelmeier

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