Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection Reset (Very Weird !)

 
jay vas
Ranch Hand
Posts: 407
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Author and ninkuma
Marshal
Pie
Posts: 65225
95
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sounds like you may have a single-connection limit and you're not closing the first connection.
 
jay vas
Ranch Hand
Posts: 407
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Author and ninkuma
Marshal
Pie
Posts: 65225
95
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you freeing the connection properly in your app?
 
jay vas
Ranch Hand
Posts: 407
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic