[jboss-user] [JCA/JBoss] - Slow DataSouce Failover

jsicotte2 do-not-reply at jboss.com
Mon Nov 13 10:39:06 EST 2006

I am experiencing a slow failover when simulating a network failure. My setup consists of the following: Two servers, each with an instance of JBoss and MySQL running on them. I will refer to the servers as a "primary" and "backup". Both the primary and backup have their DataSources set to point to the MySQL instance running on the primary server. They are HA DataSources, so they also point to the backup server. I simulate a network failure by unplugging the primary from a network hub. Then the following happens:
1) The backup server/node detects the failure.
2) Several minutes go by after the cluster failure, and then our app is deployed.

After playing with Log4j settings and some more testing, I have narrowed the issue down to a set of failures:

2006-10-26 15:50:34,843 INFO [org.hibernate.connection.DatasourceConnectionProvider] Using datasource: java:/DefaultDS
  | 2006-10-26 15:51:06,343 WARN [org.jboss.resource.adapter.jdbc.local.HALocalManagedConnectionFactory] Destroying connection that is not valid 
  | 2006-10-26 15:51:50,484 WARN [org.jboss.resource.adapter.jdbc.local.HALocalManagedConnectionFactory] Destroying connection that is not valid
  | 006-10-26 15:52:28,437 WARN [org.jboss.resource.adapter.jdbc.local.HALocalManagedConnectionFactory] Destroying connection that is not valid
  | 2006-10-26 15:52:49,578 WARN [org.jboss.resource.adapter.jdbc.local.HALocalManagedConnectionFactory]
  |  Failed to create connection for jdbc:mysql://nscluster-3:4589/netsight: Communications link failure
Since the DataSouce connection pool size is set to a minimum of three, it seems that a database connection is not considered dead until all thread pool connections are timed out. The timeouts take a little over two minutes to complete, and if the minimum thread pool size was larger, the failover time would be protracted even more. Is there any way to reduce the duration of the timeouts and/or speed up this process? 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3985475#3985475

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3985475

More information about the jboss-user mailing list