Thank you @dasniko @xgp. I very much appreciate your help and guidance.
Turned on trace for:org.jgroups:trace (see below).
There wasn’t anything per se in the logs that caught my eye (in fact nothing specific that it’s connecting to the database - is that in itself an indicator?). Do you see any smoking guns?
2022-07-04 12:21:47,410 INFO [org.keycloak.quarkus.runtime.hostname.DefaultHostnameProvider] (main) Hostname settings: FrontEnd: foobar.com, Strict HTTPS: true, Path: <request>, Strict BackChannel: false, Admin: <request>, Port: -1, Proxied: true
2022-07-04 12:21:50,141 WARN [org.infinispan.CONFIG] (keycloak-cache-init) ISPN000569: Unable to persist Infinispan internal caches as no global state enabled
2022-07-04 12:21:50,184 WARN [org.infinispan.PERSISTENCE] (keycloak-cache-init) ISPN000554: jboss-marshalling is deprecated and planned for removal
2022-07-04 12:21:50,275 INFO [org.infinispan.CONTAINER] (keycloak-cache-init) ISPN000556: Starting user marshaller 'org.infinispan.jboss.marshalling.core.JBossUserMarshaller'
2022-07-04 12:21:50,720 INFO [org.infinispan.CONTAINER] (keycloak-cache-init) ISPN000128: Infinispan version: Infinispan 'Triskaidekaphobia' 13.0.9.Final
2022-07-04 12:21:50,994 INFO [org.infinispan.CLUSTER] (keycloak-cache-init) ISPN000078: Starting JGroups channel `ISPN` with stack `jdbc-ping-tcp`
2022-07-04 12:21:51,180 DEBUG [org.jgroups.stack.Configurator] (keycloak-cache-init) set property TCP.diagnostics_addr to default value /224.0.75.75
2022-07-04 12:21:51,206 DEBUG [org.jgroups.protocols.TCP] (keycloak-cache-init) thread pool min/max/keep-alive: 0/200/60000 use_fork_join=false, internal pool: 0/4/30000 (2 cores available)
2022-07-04 12:21:51,211 DEBUG [org.jgroups.protocols.MPING] (keycloak-cache-init) bind_addr=/10.57.226.121, mcast_addr=/228.6.7.8, mcast_port=46655
2022-07-04 12:21:51,212 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (keycloak-cache-init) null: set max_xmit_req_size from 0 to 511600
2022-07-04 12:21:51,213 TRACE [org.jgroups.protocols.UNICAST3] (keycloak-cache-init) null: set max_xmit_req_size from 0 to 511600
2022-07-04 12:21:51,230 DEBUG [org.jgroups.protocols.MPING] (keycloak-cache-init) receiver thread started
2022-07-04 12:21:51,244 TRACE [org.jgroups.protocols.pbcast.STABLE] (keycloak-cache-init) ip-10-57-226-121-41122: stable task started
2022-07-04 12:21:51,244 DEBUG [org.jgroups.protocols.pbcast.GMS] (keycloak-cache-init) address=ip-10-57-226-121-41122, cluster=ISPN, physical address=10.57.226.121:7800
2022-07-04 12:21:53,253 INFO [org.jgroups.protocols.pbcast.GMS] (keycloak-cache-init) ip-10-57-226-121-41122: no members discovered after 2002 ms: creating cluster as coordinator
2022-07-04 12:21:53,255 DEBUG [org.jgroups.protocols.pbcast.NAKACK2] (keycloak-cache-init)
[ip-10-57-226-121-41122 setDigest()]
existing digest: []
new digest: ip-10-57-226-121-41122: [0 (0)]
resulting digest: ip-10-57-226-121-41122: [0 (0)]
2022-07-04 12:21:53,256 DEBUG [org.jgroups.protocols.pbcast.GMS] (keycloak-cache-init) ip-10-57-226-121-41122: installing view [ip-10-57-226-121-41122|0] (1) [ip-10-57-226-121-41122] (ip-10-57-226-121-41122 joined)
2022-07-04 12:21:53,258 DEBUG [org.jgroups.protocols.pbcast.STABLE] (keycloak-cache-init) resuming message garbage collection
2022-07-04 12:21:53,265 TRACE [org.jgroups.protocols.UFC] (keycloak-cache-init) new membership: [ip-10-57-226-121-41122]
2022-07-04 12:21:53,266 TRACE [org.jgroups.protocols.MFC] (keycloak-cache-init) new membership: [ip-10-57-226-121-41122]
2022-07-04 12:21:53,268 INFO [org.infinispan.CLUSTER] (keycloak-cache-init) ISPN000094: Received new cluster view for channel ISPN: [ip-10-57-226-121-41122|0] (1) [ip-10-57-226-121-41122]
2022-07-04 12:21:53,273 DEBUG [org.jgroups.protocols.pbcast.GMS] (keycloak-cache-init) ip-10-57-226-121-41122: created cluster (first member). My view is [ip-10-57-226-121-41122|0], implis CoordGmsImpl
2022-07-04 12:21:53,274 INFO [org.infinispan.CLUSTER] (keycloak-cache-init) ISPN000079: Channel `ISPN` local address is `ip-10-57-226-121-41122`, physical addresses are `[10.57.226.121:7800]`
2022-07-04 12:21:53,656 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (non-blocking-thread--p2-t1) ip-10-57-226-121-41122 --> [all]: #1
2022-07-04 12:21:53,659 TRACE [org.jgroups.protocols.TCP] (non-blocking-thread--p2-t1) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=2219, headers are NAKACK2: [MSG, seqno=1], TP: [cluster=ISPN]
2022-07-04 12:21:53,671 TRACE [org.jgroups.protocols.MFC] (non-blocking-thread--p2-t1) ip-10-57-226-121-41122 used 2176 credits, 3997824 remaining
2022-07-04 12:21:53,751 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (non-blocking-thread--p2-t4) ip-10-57-226-121-41122 --> [all]: #2
2022-07-04 12:21:53,751 TRACE [org.jgroups.protocols.TCP] (non-blocking-thread--p2-t4) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=2205, headers are NAKACK2: [MSG, seqno=2], TP: [cluster=ISPN]
2022-07-04 12:21:53,752 TRACE [org.jgroups.protocols.MFC] (non-blocking-thread--p2-t4) ip-10-57-226-121-41122 used 2162 credits, 3995662 remaining
2022-07-04 12:21:53,764 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (non-blocking-thread--p2-t3) ip-10-57-226-121-41122 --> [all]: #3
2022-07-04 12:21:53,765 TRACE [org.jgroups.protocols.TCP] (non-blocking-thread--p2-t3) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=2211, headers are NAKACK2: [MSG, seqno=3], TP: [cluster=ISPN]
2022-07-04 12:21:53,765 TRACE [org.jgroups.protocols.MFC] (non-blocking-thread--p2-t3) ip-10-57-226-121-41122 used 2168 credits, 3993494 remaining
2022-07-04 12:21:53,791 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (non-blocking-thread--p2-t2) ip-10-57-226-121-41122 --> [all]: #4
2022-07-04 12:21:53,791 TRACE [org.jgroups.protocols.TCP] (non-blocking-thread--p2-t2) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=1180, headers are NAKACK2: [MSG, seqno=4], TP: [cluster=ISPN]
2022-07-04 12:21:53,793 TRACE [org.jgroups.protocols.MFC] (non-blocking-thread--p2-t2) ip-10-57-226-121-41122 used 1137 credits, 3992357 remaining
2022-07-04 12:21:53,806 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (non-blocking-thread--p2-t1) ip-10-57-226-121-41122 --> [all]: #5
2022-07-04 12:21:53,807 TRACE [org.jgroups.protocols.TCP] (non-blocking-thread--p2-t1) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=1213, headers are NAKACK2: [MSG, seqno=5], TP: [cluster=ISPN]
2022-07-04 12:21:53,807 TRACE [org.jgroups.protocols.MFC] (non-blocking-thread--p2-t1) ip-10-57-226-121-41122 used 1170 credits, 3991187 remaining
2022-07-04 12:21:53,828 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (non-blocking-thread--p2-t4) ip-10-57-226-121-41122 --> [all]: #6
2022-07-04 12:21:53,828 TRACE [org.jgroups.protocols.TCP] (non-blocking-thread--p2-t4) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=2210, headers are NAKACK2: [MSG, seqno=6], TP: [cluster=ISPN]
2022-07-04 12:21:53,828 TRACE [org.jgroups.protocols.MFC] (non-blocking-thread--p2-t4) ip-10-57-226-121-41122 used 2167 credits, 3989020 remaining
2022-07-04 12:21:53,845 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (non-blocking-thread--p2-t3) ip-10-57-226-121-41122 --> [all]: #7
2022-07-04 12:21:53,845 TRACE [org.jgroups.protocols.TCP] (non-blocking-thread--p2-t3) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=2218, headers are NAKACK2: [MSG, seqno=7], TP: [cluster=ISPN]
2022-07-04 12:21:53,845 TRACE [org.jgroups.protocols.MFC] (non-blocking-thread--p2-t3) ip-10-57-226-121-41122 used 2175 credits, 3986845 remaining
2022-07-04 12:21:53,857 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (non-blocking-thread--p2-t2) ip-10-57-226-121-41122 --> [all]: #8
2022-07-04 12:21:53,857 TRACE [org.jgroups.protocols.TCP] (non-blocking-thread--p2-t2) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=1197, headers are NAKACK2: [MSG, seqno=8], TP: [cluster=ISPN]
2022-07-04 12:21:53,857 TRACE [org.jgroups.protocols.MFC] (non-blocking-thread--p2-t2) ip-10-57-226-121-41122 used 1154 credits, 3985691 remaining
2022-07-04 12:21:53,869 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (non-blocking-thread--p2-t1) ip-10-57-226-121-41122 --> [all]: #9
2022-07-04 12:21:53,869 TRACE [org.jgroups.protocols.TCP] (non-blocking-thread--p2-t1) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=2219, headers are NAKACK2: [MSG, seqno=9], TP: [cluster=ISPN]
2022-07-04 12:21:53,869 TRACE [org.jgroups.protocols.MFC] (non-blocking-thread--p2-t1) ip-10-57-226-121-41122 used 2176 credits, 3983515 remaining
2022-07-04 12:21:53,879 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (non-blocking-thread--p2-t4) ip-10-57-226-121-41122 --> [all]: #10
2022-07-04 12:21:53,880 TRACE [org.jgroups.protocols.TCP] (non-blocking-thread--p2-t4) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=2212, headers are NAKACK2: [MSG, seqno=10], TP: [cluster=ISPN]
2022-07-04 12:21:53,880 TRACE [org.jgroups.protocols.MFC] (non-blocking-thread--p2-t4) ip-10-57-226-121-41122 used 2169 credits, 3981346 remaining
2022-07-04 12:21:53,893 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (non-blocking-thread--p2-t3) ip-10-57-226-121-41122 --> [all]: #11
2022-07-04 12:21:53,893 TRACE [org.jgroups.protocols.TCP] (non-blocking-thread--p2-t3) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=2209, headers are NAKACK2: [MSG, seqno=11], TP: [cluster=ISPN]
2022-07-04 12:21:53,893 TRACE [org.jgroups.protocols.MFC] (non-blocking-thread--p2-t3) ip-10-57-226-121-41122 used 2166 credits, 3979180 remaining
2022-07-04 12:21:54,044 INFO [org.keycloak.connections.infinispan.DefaultInfinispanConnectionProviderFactory] (main) Node name: ip-10-57-226-121-41122, Site name: null
2022-07-04 12:21:54,248 TRACE [org.jgroups.protocols.TCP] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=39, headers areNAKACK2: [HIGHEST_SEQNO, seqno=11], TP: [cluster=ISPN]
2022-07-04 12:21:54,337 INFO [io.quarkus] (main) Keycloak 18.0.1 on JVM (powered by Quarkus 2.7.5.Final) started in 11.024s. Listening on: http://0.0.0.0:8080
2022-07-04 12:21:54,337 INFO [io.quarkus] (main) Profile prod activated.
2022-07-04 12:21:54,337 INFO [io.quarkus] (main) Installed features: [agroal, cdi, hibernate-orm, jdbc-h2, jdbc-mariadb, jdbc-mssql, jdbc-mysql, jdbc-oracle, jdbc-postgresql, keycloak, narayana-jta, reactive-routes, resteasy, resteasy-jackson, smallrye-context-propagation, smallrye-health, smallrye-metrics, vault, vertx]
2022-07-04 12:21:56,629 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: updating the local figest with a stable message (coordinator): ip-10-57-226-121-41122: [11 (11)]
2022-07-04 12:21:56,630 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: handling digest from ip-10-57-226-121-41122:
mine: ip-10-57-226-121-41122: [-1]
sender: ip-10-57-226-121-41122: [11]
result: ip-10-57-226-121-41122: [11]
2022-07-04 12:21:56,630 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: sending stability msg ip-10-57-226-121-41122: [11]
2022-07-04 12:21:56,630 TRACE [org.jgroups.protocols.TCP] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=83, headers areSTABLE: [STABILITY] view-id= [ip-10-57-226-121-41122|0], TP: [cluster=ISPN]
2022-07-04 12:21:56,631 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: received stable digest ip-10-57-226-121-41122: [11 (11)]
2022-07-04 12:21:56,631 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: deleting msgs <= 11 from ip-10-57-226-121-41122
2022-07-04 12:22:05,844 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: updating the local figest with a stable message (coordinator): ip-10-57-226-121-41122: [11 (11)]
2022-07-04 12:22:05,845 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: handling digest from ip-10-57-226-121-41122:
mine: ip-10-57-226-121-41122: [-1]
sender: ip-10-57-226-121-41122: [11]
result: ip-10-57-226-121-41122: [11]
2022-07-04 12:22:05,845 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: sending stability msg ip-10-57-226-121-41122: [11]
2022-07-04 12:22:05,847 TRACE [org.jgroups.protocols.TCP] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=83, headers areSTABLE: [STABILITY] view-id= [ip-10-57-226-121-41122|0], TP: [cluster=ISPN]
2022-07-04 12:22:05,847 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: received stable digest ip-10-57-226-121-41122: [11 (11)]
2022-07-04 12:22:05,847 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: deleting msgs <= 11 from ip-10-57-226-121-41122
2022-07-04 12:22:07,137 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: updating the local figest with a stable message (coordinator): ip-10-57-226-121-41122: [11 (11)]
2022-07-04 12:22:07,137 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: handling digest from ip-10-57-226-121-41122:
mine: ip-10-57-226-121-41122: [-1]
sender: ip-10-57-226-121-41122: [11]
result: ip-10-57-226-121-41122: [11]
2022-07-04 12:22:07,137 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: sending stability msg ip-10-57-226-121-41122: [11]
2022-07-04 12:22:07,138 TRACE [org.jgroups.protocols.TCP] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=83, headers areSTABLE: [STABILITY] view-id= [ip-10-57-226-121-41122|0], TP: [cluster=ISPN]
2022-07-04 12:22:07,138 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: received stable digest ip-10-57-226-121-41122: [11 (11)]
2022-07-04 12:22:07,138 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: deleting msgs <= 11 from ip-10-57-226-121-41122
2022-07-04 12:22:07,359 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: updating the local figest with a stable message (coordinator): ip-10-57-226-121-41122: [11 (11)]
2022-07-04 12:22:07,359 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: handling digest from ip-10-57-226-121-41122:
mine: ip-10-57-226-121-41122: [-1]
sender: ip-10-57-226-121-41122: [11]
result: ip-10-57-226-121-41122: [11]
2022-07-04 12:22:07,360 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: sending stability msg ip-10-57-226-121-41122: [11]
2022-07-04 12:22:07,361 TRACE [org.jgroups.protocols.TCP] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: sending msg to null, src=ip-10-57-226-121-41122, size=83, headers areSTABLE: [STABILITY] view-id= [ip-10-57-226-121-41122|0], TP: [cluster=ISPN]
2022-07-04 12:22:07,361 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: received stable digest ip-10-57-226-121-41122: [11 (11)]
2022-07-04 12:22:07,361 TRACE [org.jgroups.protocols.pbcast.NAKACK2] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: deleting msgs <= 11 from ip-10-57-226-121-41122
2022-07-04 12:22:10,845 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: updating the local figest with a stable message (coordinator): ip-10-57-226-121-41122: [11 (11)]
2022-07-04 12:22:10,845 TRACE [org.jgroups.protocols.pbcast.STABLE] (jgroups-6,ip-10-57-226-121-41122) ip-10-57-226-121-41122: handling digest from ip-10-57-226-121-41122:
mine: ip-10-57-226-121-41122: [-1]
sender: ip-10-57-226-121-41122: [11]
result: ip-10-57-226-121-41122: [11]