Page 1 of 1

SSH tunnel not re-connecting

Posted: Mon 27 Apr 2009 18:57
by awx
I am using the latest build and I am having a problem with the ssh tunnel. If the tunnel is dropped it will not re-connect. I tested this by going to the MySQL server and killed the SSH connection, then ran a query it failed. I even tried to clear the connection pool for that one connection and for all connections. I can't get it to re-establish a connection until I restarted the app.

Thanks for the help,
Jeff

Posted: Tue 28 Apr 2009 09:58
by Shalex
Jeff, if you opened connection from your application, killed it from the server side, connection is considered as valid until the next interoperation with the database. It is not reopened automatically if the session is lost. In this case you should close this connection from the application side and reopen it before running a query.

Connection pool checks if connection is valid. There are no invalid connections in pool.