[keycloak-user] Getting error while doing HA in docker

Sun Aug 25 15:52:08 EDT 2019

Hi,

I am getting the below error message while setting up two containers in
single host. Followed this document to setup -
https://www.keycloak.org/2019/04/keycloak-cluster-setup.html

19:37:43,485 ERROR [org.jgroups.protocols.JDBC_PING]
(thread-9,ejb,568064445f53) JGRP000138: Error reading JDBC_PING table:
org.postgresql.util.PSQLException: ERROR: relation "jgroupsping" does not
exist
  Position: 47
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
        at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
        at
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
        at
org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106)
        at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504)
        at org.jgroups.protocols.JDBC_PING.readAll(JDBC_PING.java:225)
        at org.jgroups.protocols.JDBC_PING.readAll(JDBC_PING.java:197)
        at org.jgroups.protocols.FILE_PING.findMembers(FILE_PING.java:124)
        at
org.jgroups.protocols.Discovery.invokeFindMembers(Discovery.java:214)
        at org.jgroups.protocols.Discovery.findMembers(Discovery.java:239)
        at org.jgroups.protocols.Discovery.down(Discovery.java:386)
        at org.jgroups.protocols.FILE_PING.down(FILE_PING.java:119)
        at org.jgroups.protocols.MERGE3$InfoSender.run(MERGE3.java:408)
        at org.jgroups.util.TimeScheduler3$Task.run(TimeScheduler3.java:324)
        at
org.jgroups.util.TimeScheduler3$RecurringTask.run(TimeScheduler3.java:358)
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at
org.jboss.as.clustering.jgroups.ClassLoaderThreadFactory.lambda$newThread$0(ClassLoaderThreadFactory.java:52)
        at java.lang.Thread.run(Thread.java:748)

19:37:43,487 ERROR [org.jgroups.protocols.JDBC_PING]
(thread-9,ejb,568064445f53) JGRP000145: Error updating JDBC_PING table:
org.postgresql.util.PSQLException: ERROR: relation "jgroupsping" does not
exist
  Position: 13
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
        at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
        at
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
        at
org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:120)
        at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)
        at org.jgroups.protocols.JDBC_PING.delete(JDBC_PING.java:339)
        at org.jgroups.protocols.JDBC_PING.writeToDB(JDBC_PING.java:142)
        at org.jgroups.protocols.JDBC_PING.write(JDBC_PING.java:125)
        at org.jgroups.protocols.FILE_PING.findMembers(FILE_PING.java:128)
        at
org.jgroups.protocols.Discovery.invokeFindMembers(Discovery.java:214)
        at org.jgroups.protocols.Discovery.findMembers(Discovery.java:239)
        at org.jgroups.protocols.Discovery.down(Discovery.java:386)
        at org.jgroups.protocols.FILE_PING.down(FILE_PING.java:119)
        at org.jgroups.protocols.MERGE3$InfoSender.run(MERGE3.java:408)
        at org.jgroups.util.TimeScheduler3$Task.run(TimeScheduler3.java:324)
        at
org.jgroups.util.TimeScheduler3$RecurringTask.run(TimeScheduler3.java:358)
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at
org.jboss.as.clustering.jgroups.ClassLoaderThreadFactory.lambda$newThread$0(ClassLoaderThreadFactory.java:52)
        at java.lang.Thread.run(Thread.java:748)

19:38:21,918 ERROR [org.jgroups.protocols.JDBC_PING]
(thread-10,ejb,568064445f53) JGRP000138: Error reading JDBC_PING table:
org.postgresql.util.PSQLException: ERROR: relation "jgroupsping" does not
exist
  Position: 47
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
        at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
        at
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
        at
org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106)
        at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504)
        at org.jgroups.protocols.JDBC_PING.readAll(JDBC_PING.java:225)
        at org.jgroups.protocols.JDBC_PING.readAll(JDBC_PING.java:197)
        at org.jgroups.protocols.FILE_PING.findMembers(FILE_PING.java:124)
        at
org.jgroups.protocols.Discovery.invokeFindMembers(Discovery.java:214)
        at org.jgroups.protocols.Discovery.findMembers(Discovery.java:239)
        at org.jgroups.protocols.Discovery.down(Discovery.java:386)
        at org.jgroups.protocols.FILE_PING.down(FILE_PING.java:119)
        at org.jgroups.protocols.MERGE3$InfoSender.run(MERGE3.java:408)
        at org.jgroups.util.TimeScheduler3$Task.run(TimeScheduler3.java:324)
        at
org.jgroups.util.TimeScheduler3$RecurringTask.run(TimeScheduler3.java:358)
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at
org.jboss.as.clustering.jgroups.ClassLoaderThreadFactory.lambda$newThread$0(ClassLoaderThreadFactory.java:52)
        at java.lang.Thread.run(Thread.java:748)

19:38:21,922 ERROR [org.jgroups.protocols.JDBC_PING]
(thread-10,ejb,568064445f53) JGRP000145: Error updating JDBC_PING table:
org.postgresql.util.PSQLException: ERROR: relation "jgroupsping" does not
exist
  Position: 13
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
        at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
        at
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
        at
org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:120)
        at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)
        at org.jgroups.protocols.JDBC_PING.delete(JDBC_PING.java:339)
        at org.jgroups.protocols.JDBC_PING.writeToDB(JDBC_PING.java:142)
        at org.jgroups.protocols.JDBC_PING.write(JDBC_PING.java:125)
        at org.jgroups.protocols.FILE_PING.findMembers(FILE_PING.java:128)
        at
org.jgroups.protocols.Discovery.invokeFindMembers(Discovery.java:214)
        at org.jgroups.protocols.Discovery.findMembers(Discovery.java:239)
        at org.jgroups.protocols.Discovery.down(Discovery.java:386)