RH-SSO/MySQL OpenShift deployment and installation failed

Solution Verified - Updated -

Issue

RH-SSO/MySQL OpenShift is failing during deployment installation, when trying to connect to mysql database.

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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content