• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Jj Roberts
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Himai Minh
  • Carey Brown
  • salvin francis

Connection Reset (Very Weird !)

 
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 !
 
Marshal
Posts: 67478
173
Mac Mac OS X IntelliJ IDE jQuery Java
  • 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
Marshal
Posts: 67478
173
Mac Mac OS X IntelliJ IDE jQuery Java
  • 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.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic