[SOLVED][Help] Mysql

This is not a Support area! Discuss about the Server here. Non-Server related discussion goes in Off-Topic Discussion.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Mage
Posts: 277
Joined: Fri Apr 17, 2009 2:29 pm

[SOLVED][Help] Mysql

Post by Mage »

Hello,

My Server running with 100 Players Online.

Tonight The GameServer Crash with this error (also the forum that host the same machine).

This is the error, i think that Mysql go in Crash:

Code: Select all

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 [numThreadsAwaitingCheckoutDefaultUser] ]Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1119)	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2257)	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:784)	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:354)	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:119)	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAutomaticTestTable(C3P0PooledConnectionPoolManager.java:772)	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:696)	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:257)	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:271)	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)	at com.l2jserver.L2DatabaseFactory.<init>(L2DatabaseFactory.java:96)	at com.l2jserver.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:207)	at com.l2jserver.gameserver.GameServer.main(GameServer.java:501)Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1119)	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2178)	... 20 moreCaused by: java.net.ConnectException: Connection refused	at java.net.PlainSocketImpl.socketConnect(Native Method)	at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)	at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)	at java.net.Socket.connect(Socket.java:529)	at java.net.Socket.connect(Socket.java:478)	at java.net.Socket.<init>(Socket.java:375)	at java.net.Socket.<init>(Socket.java:218)	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)	... 21 more
Do anyone know this error?

Thank y,

Mage :)
Forum rules: Please do not use or alter the official L2J Avatars/Signatures/Names for your personal use.
Mage
Posts: 277
Joined: Fri Apr 17, 2009 2:29 pm

Re: [SOLVED][Help] Mysql

Post by Mage »

Solved.

The problem was of Permission of Account Mysql.


Mage :)
Forum rules: Please do not use or alter the official L2J Avatars/Signatures/Names for your personal use.
User avatar
badboy29
Posts: 417
Joined: Fri Apr 24, 2009 5:34 am
Location: Brazil

Re: [SOLVED][Help] Mysql

Post by badboy29 »

You tested Mysql/Java settings on another topic i posted ?
Aka UnHoly
Post Reply