Timeout for Dropwizard's health checks?

[Pablo Compagni]

Hi,

I have two sql database connections for which health checks are automatically added by dropwizard. But when the application loses connection to one of them, the /healthcheck endpoint takes indefinitely long to respond, where I would want it to timeout after a few seconds.

I've already set the maxWaitForConnection setting, and I've also experimented with the various checkConnectionOn.. settings, but nothing helped.

The health check correctly fails if the server actively refuses the connection, but it hangs indefinitely if it's not the case, for instance, a network issue.

Is it possible to have sql health checks timeout at a specified time value whatever the problem is?

Thanks, 

Pablo.

[Ryan Kennedy]

Are you referring to the JDBI or Hibernate healthcheck?

https://github.com/dropwizard/dropwizard/blob/master/dropwizard-jdbi/src/main/java/io/dropwizard/jdbi/DBIHealthCheck.java

https://github.com/dropwizard/dropwizard/blob/master/dropwizard-hibernate/src/main/java/io/dropwizard/hibernate/SessionFactoryHealthCheck.java

Ryan

--
You received this message because you are subscribed to the Google Groups "dropwizard-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dropwizard-us...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Pablo Compagni]

Both DBI, 1 Sql Server and 1 MySql, could this be related to the drivers?

[CAB]

I took a crack at it: https://github.com/dropwizard/dropwizard/pull/921

If it gets approved, we can do the same for hibernate.

[Paul Brown]

I've done a once-over and wonder if the pool already provides enough to go on?  See https://github.com/dropwizard/dropwizard/pull/921#discussion_r25901568; note that this suggestion would supplant the old, timeout-less DBIHealthCheck entirely.

—
p...@mult.ifario.us | Multifarious, Inc. | http://mult.ifario.us/