Jump to content
  • 0

i have error at login server look TELL ME PLZ


steelpadeu

Question

looooook THIS ERROR AND TELL ME WHAT TO DO PLZ

 

 

 

 

 

 

 

 

 

loading login config

MLog clients using java 1.4+ standard logging.

Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]

Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans

.IntrospectionException: java.lang.reflect.InvocationTargetException [numThreads

AwaitingCheckoutDefaultUser] ]

FATAL: Failed initializing database. Reason: Communications link failure due to

underlying exception:

 

** BEGIN NESTED EXCEPTION **

 

java.net.ConnectException

MESSAGE: Connection refused: connect

 

STACKTRACE:

 

java.net.ConnectException: Connection refused: connect

        at java.net.DualStackPlainSocketImpl.connect0(Native Method)

        at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)

        at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)

        at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)

        at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

        at java.net.PlainSocketImpl.connect(Unknown Source)

        at java.net.SocksSocketImpl.connect(Unknown Source)

        at java.net.Socket.connect(Unknown Source)

        at java.net.Socket.connect(Unknown Source)

        at java.net.Socket.<init>(Unknown Source)

        at java.net.Socket.<init>(Unknown Source)

        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja

va:256)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)

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

        at com.mysql.jdbc.Connection.<init>(Connection.java:1553)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:285)

        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag

erDataSource.java:119)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti

on(WrapperConnectionPoolDataSource.java:143)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti

on(WrapperConnectionPoolDataSource.java:132)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu

tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled

ConnectionPool(C3P0PooledConnectionPoolManager.java:696)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:257)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:271)

        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A

bstractPoolBackedDataSource.java:128)

        at com.it.br.L2DatabaseFactory.<init>(L2DatabaseFactory.java:95)

        at com.it.br.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:160)

        at com.it.br.loginserver.L2LoginServer.<init>(L2LoginServer.java:111)

        at com.it.br.loginserver.L2LoginServer.main(L2LoginServer.java:57)

 

 

** END NESTED EXCEPTION **

 

 

 

Last packet sent to the server was 1 ms ago.

 

Server terminated abnormaly

 

 

server terminated

 

Press any key to continue . . .

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

When a new transaction open, it try to use old connection which is expired in connection pool in that case this exception occur. There are multiple way be which your connection can killed by firewall, Third party security server etc. If one thread acquire connection and sleep for more than 8 HR (default connection timeout period for MySQL) then this exception occur if that thread woke up after 8 Hr and try to do transaction with database.

 

There are two way for solution.

  • Reduce wait time period in connection pool and reclaim old connection in code. (In connection pool)
  • Reduce wait time period in Mysql. So that connection from MySQL will reclaim soon.

 

Steps in order to do above mentioned.

 

[*]Stop MySQL db server and application server.

[*]Mysql settings: This should be done in "my.ini" file under mysql folder.

 

wait_timeout =1200 (i.e 20 min – Keep same time of your firewall OR any other third party software)

 

You can set it DB level by above query. set  wait_timeout =1200;

 

View settings by above query Show variables like 'wait_timeout'  ;

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...