i have error at login server look TELL ME PLZ

[steelpadeu]

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 . . .

[Stewie]

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'  ;