RH-SSO/MySQL OpenShift deployment and installation failed
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.