4:14 a.m.
Hey Vijay,
So the root case is that JGroups can not create its own table. This may
happen due to many things, including:
- Not sufficient permissions to create tables
- `initialize_sql` property is empty, see [1]
- Wrong database credentials or database address
You might be interested in the follow-up article I've written a couple of
weeks ago: https://www.keycloak.org/2019/08/keycloak-jdbc-ping.html
Thanks,
Sebastian
[1] http://jgroups.org/manual/#_jdbc_ping
On Sun, Aug 25, 2019 at 9:56 PM vijay <vijaybaliyan(a)gmail.com> wrote:
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)
_______________________________________________
keycloak-user mailing list
keycloak-user(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user