Connection Errors

am 21.02.2005 16:59:14 von Melissa Dougherty

------=_NextPart_000_0003_01C51804.61B6E880
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0004_01C51804.61B6E880"

------=_NextPart_001_0004_01C51804.61B6E880
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Has anyone seen this connection error before... we are seeing a lot of =
aborted connections.

Caused by: java.sql.SQLException: Data source rejected establishment of =
connection, message from server: "Host 'frink.gsfc.nasa.gov' is blocked =
because of many connection errors. Unblock with 'mysqladmin =
flush-hosts'"

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:649)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:1786)

at com.mysql.jdbc.Connection.(Connection.java:450)

at =
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDr iver.java:411=
)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at org.apache.torque.adapter.DB.getConnection(DB.java:145)

at =
org.apache.torque.pool.ConnectionPool.getNewConnection(Conne ctionPool.jav=
a:444)

at =
org.apache.torque.pool.ConnectionPool.getConnection(Connecti onPool.java:2=
79)

at org.apache.torque.Torque.getConnection(Torque.java:751)

Melissa A Dougherty
------=_NextPart_001_0004_01C51804.61B6E880
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

charset=3Diso-8859-1">

Has anyone seen this connection error before... we are =
seeing a=20
lot of aborted connections.

Caused by: java.sql.SQLException: Data source rejected =
establishment=20
of connection, message from server: "Host 'frink.gsfc.nasa.gov' is =
blocked=20
because of many connection errors. Unblock with 'mysqladmin=20
flush-hosts'"

at =
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:649)

at=20
com.mysql.jdbc.Connection.createNewIO(Connection.java:1786)

at=20
com.mysql.jdbc.Connection.<init>(Connection.java:450)

at=20
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDr iver.java:411=
)

at=20
java.sql.DriverManager.getConnection(DriverManager.java:512)

at=20
java.sql.DriverManager.getConnection(DriverManager.java:171)

at=20
org.apache.torque.adapter.DB.getConnection(DB.java:145)

at=20
org.apache.torque.pool.ConnectionPool.getNewConnection(Conne ctionPool.jav=
a:444)

at=20
org.apache.torque.pool.ConnectionPool.getConnection(Connecti onPool.java:2=
79)

at=20
org.apache.torque.Torque.getConnection(Torque.java:751)

Melissa A =
Dougherty

------=_NextPart_001_0004_01C51804.61B6E880--

------=_NextPart_000_0003_01C51804.61B6E880
Content-Type: text/plain; charset=us-ascii

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
------=_NextPart_000_0003_01C51804.61B6E880--

Re: Connection Errors

am 21.02.2005 17:18:02 von Daniel da Veiga

I started Java development not long ago, and shortly after I trying to
integrate it with MySQL I got that error, I corrected it first by
changing the value of max_connect_errors at the config file, but then
I noticed that the problem was my app, every faulty start caused a
connection error, so, I corrected some statements and added the .close
needed to close the recordset, the statement and the connection, and
the error was gone.

Check your code for errors and your MySQL config for too low values
for the max_connect_errors variable.

Best regards,

On Mon, 21 Feb 2005 10:59:14 -0500, Melissa Dougherty
wrote:
>
>
>
> Has anyone seen this connection error before... we are seeing a lot of
> aborted connections.
>
>
>
>
> Caused by: java.sql.SQLException: Data source rejected establishment of
> connection, message from server: "Host 'frink.gsfc.nasa.gov' is blocked
> because of many connection errors. Unblock with 'mysqladmin flush-hosts'"
>
>
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:649)
>
>
> at com.mysql.jdbc.Connection.createNewIO(Connection.java:1786)
>
>
> at com.mysql.jdbc.Connection.(Connection.java:450)
>
>
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDr iver.java:411)
>
>
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
>
>
> at java.sql.DriverManager.getConnection(DriverManager.java:171)
>
>
> at org.apache.torque.adapter.DB.getConnection(DB.java:145)
>
>
> at
> org.apache.torque.pool.ConnectionPool.getNewConnection(Conne ctionPool.java:444)
>
>
> at
> org.apache.torque.pool.ConnectionPool.getConnection(Connecti onPool.java:279)
>
>
> at org.apache.torque.Torque.getConnection(Torque.java:751)
>
>
> Melissa A Dougherty
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>

--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org