Connection Reset (Very Weird !)

[jay vas]

Hi Guys :

On startup of my computer, I can connect to my database server locally and also over the network (which has no other traffic other than my application).

However, I cant connect to it twice in a row !? The second time my app tries going to the database I get the Connection Refused exception :

answers ::: jdbc:mysql://155.37.101.106:3306/connjur
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)


The weird thing here is that after this, I cant even connect locally anymore
from the command line - mysql just lets out a beep and dies with the error
"Cant connect to LocalHost".

Is mysql shutting itself down within 1 minute of startup or something ???

Please help !

[Bear Bibeault]

Sounds like you may have a single-connection limit and you're not closing the first connection.

[jay vas]

Thanks for the reply ! Well I can run multiple command line
instances of mysql at once, however...but is there a way to force mysql to close all connections from the command line to test youre idea ? Also, where is the connection limit defined... ?

-jay

[Bear Bibeault]

Are you freeing the connection properly in your app?

[jay vas]

Yeah I was. The problem was actually in MySql - something happened with the innodb tables and the config file. It turns out a simple reconfiguration of using the instance config wizard fixed it.

I think it was a bug in MySql.