[Sqlrelay-discussion] Multiple sqlr-listener processes and no connections

[Ville S. <vil...@gm...>]

Hi,

I'm using SQL Relay 0.45 on RedHat 6. Sometimes SQL Relay goes into a state
where it starts several sqlr-listener processes, but there are no
sqlr-connection processes. The application that uses SQL Relay hangs. There
may be a problem with RedHat and the network card we are using, which can
cause temporary loss of network connectivity. The only cure that I've found
is to restart SQL Relay.

Today I decided to try SQL Relay 0.46. As I was running tests, our DBAs
shutdown the test Oracle database (I wasn't aware of this). Again, the same
situation happened: Several sqlr-listener processes and no connections.

I'm looking for some insight into how I could configure SQL Relay so it
would automatically recover from the temporary loss of network connectivity
or database availability. Is this possible? Would it help if I set
maxlisteners to 0, listenertimeout to 60, or tweak some other configuration
variable?

Thanks for any advice,
Ville