RH-SSO/MySQL OpenShift deployment and installation failed

Solution Unverified - Updated -

Issue

RH-SSO/MySQL OpenShift might fail during deployment installation.

3:43:52,126 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0006: Undertow HTTPS listener https listening on XX.YYZZ.TT:8443
13:43:54,835 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (MSC service thread 1-1) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection                                                                                                                                                                                                                                      
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.                                                                                                                                                                 
Caused by: java.net.NoRouteToHostException: No route to host (Host unreachable)                                                                                                                                                              
13:43:54,838 FATAL [com.arjuna.ats.arjuna] (MSC service thread 1-1) ARJUNA012260: Received exception for com.arjuna.ats.internal.arjuna.objectstore.jdbc.accessors.DataSourceJDBCAccess:ossso1dp78pJBossTSTxTable: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/KeycloakDSObjectStore                                                                                                                   
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/KeycloakDSObjectStore                                                                                                     
Caused by: javax.resource.ResourceException: IJ031084: Unable to create connection                                                                                                                                                           
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.                                                                                                                                                                 
Caused by: java.net.NoRouteToHostException: No route to host (Host unreachable)                                                                                                                                                              
13:43:54,840 WARN  [com.arjuna.ats.common] (MSC service thread 1-1) ARJUNA048006: cannot create new instance of com.arjuna.ats.internal.arjuna.objectstore.jdbc.JDBCStore: java.lang.reflect.InvocationTargetException
Caused by: com.arjuna.ats.arjuna.exceptions.ObjectStoreException: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/KeycloakDSObjectStore                       
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/KeycloakDSObjectStore                                                                              
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/KeycloakDSObjectStore                                                                                                     
Caused by: javax.resource.ResourceException: IJ031084: Unable to create connection                                                                                                                                                           
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.                                                                                                                                                                 
Caused by: java.net.NoRouteToHostException: No route to host (Host unreachable)        

Environment

  • Red Hat Single Sign-On (RH-SSO)
    • 7.3
  • Red Hat OpenShift
    • 3.11
  • MySql

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In