Connection Breaking to MySQL database

Solution Verified - Updated -

Issue

  • The server.log file contains:
java.net.SocketException: java.net.ConnectException: Connection refused
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
  • A problem occurred on virtualization platform. All the servers went down. When the servers woke up, one of them, containing a mysql instance, delayed a little bit more than normal. That caused an application deployed on JBoss to fail on deployment:
13-04-2015 09:53:21,833 WARN [SqlExceptionHelper][] (EJB default - 3) SQL Error: 0, SQLState: null
13-04-2015 09:53:21,833 ERROR [SqlExceptionHelper][] (EJB default - 3) javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/RivendelMessagesDS
13-04-2015 09:53:21,803 WARN [OnePool][] (EJB default - 1) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection
at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:447)
at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:385)
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:761) [ironjacamar-core-impl-1.0.11.Final-redhat-1.jar:1.0.11.Final-redhat-1]
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343) [ironjacamar-core-impl-1.0.11.Final-redhat-1.jar:1.0.11.Final-redhat-1]
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getTransactionNewConnection(AbstractPool.java:495) [ironjacamar-core-impl-1.0.11.Final-redhat-1.jar:1.0.11.Final-redhat-1]
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:374) [ironjacamar-core-impl-1.0.11.Final-redhat-1.jar:1.0.11.Final-redhat-1]
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329) [ironjacamar-core-impl-1.0.11.Final-redhat-1.jar:1.0.11.Final-redhat-1]
...
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method) [rt.jar:1.6.0_41]
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351) [rt.jar:1.6.0_41]
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213) [rt.jar:1.6.0_41]
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200) [rt.jar:1.6.0_41]
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) [rt.jar:1.6.0_41]
at java.net.Socket.connect(Socket.java:529) [rt.jar:1.6.0_41]
at java.net.Socket.connect(Socket.java:478) [rt.jar:1.6.0_41]
at java.net.Socket.<init>(Socket.java:375) [rt.jar:1.6.0_41]
at java.net.Socket.<init>(Socket.java:218) [rt.jar:1.6.0_41]
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
... 125 more

13-04-2015 09:53:21,854 ERROR [fail][] (MSC service thread 1-1) MSC000001: Failed to start service jboss.deployment.subunit."test.ear"."test.jar".component.MessagesIdGenerator.START: org.jboss.msc.service.StartException in service jboss.deployment.subunit."test.ear"."test.jar".component.MessagesIdGenerator.START: Failed to start service
  • Is there any way which can be forced JBoss EAP to retry the deployment of the application after a few minutes?
  • The problem is not at datasource config. The problem is that app needs the mysql instance to be up to deploy. When there is no connection to the database, the app fails to start, and we would like to know if it's any JBoss configurable option to let the application server to retry the deployment of the failed app.

Environment

  • Fuse Message Broker
    • 5.5
  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 6.x

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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.