Help Problem With My Server It Crashes Without Reason

[iAlreadyExist]

hello there can u help me please my server crash without reason or someone is trying to hack it i dont know

and i see log it show me this.

WARN  com.mchange.v2.resourcepool.BasicResourcePool@5939d7b1 -- an attempt to checkout a resource was interrupted, and the pool is still live: some other thread must have either interrupted the Thread attempting checkout!
java.lang.InterruptedException
	at java.lang.Object.wait(Native Method)
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1315)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at com.l2jfrozen.util.database.L2DatabaseFactory_c3p0.getConnection(L2DatabaseFactory_c3p0.java:147)
	at com.l2jfrozen.gameserver.network.serverpackets.CharSelectInfo.loadCharacterSelectInfo(CharSelectInfo.java:234)
	at com.l2jfrozen.gameserver.network.serverpackets.CharSelectInfo.<init>(CharSelectInfo.java:69)
	at com.l2jfrozen.gameserver.thread.LoginServerThread.run(LoginServerThread.java:365)
ERROR L2DatabaseFactory: getConnection() failed, trying again
java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:531)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at com.l2jfrozen.util.database.L2DatabaseFactory_c3p0.getConnection(L2DatabaseFactory_c3p0.java:147)
	at com.l2jfrozen.gameserver.network.serverpackets.CharSelectInfo.loadCharacterSelectInfo(CharSelectInfo.java:234)
	at com.l2jfrozen.gameserver.network.serverpackets.CharSelectInfo.<init>(CharSelectInfo.java:69)
	at com.l2jfrozen.gameserver.thread.LoginServerThread.run(LoginServerThread.java:365)
Caused by: java.lang.InterruptedException
	at java.lang.Object.wait(Native Method)
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1315)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	... 5 more
INFO  Disconnecting all players from the Server...
INFO  Saving all players data...

[Tryskell]

I won't edit c3p0 for a custom crap while you got other efficient db poolers running around (boneCP, hikariCP, etc).

 

The point is no one will try and test those poolers because no one knows how to properly test it. See L2JFrozen tried to move to boneCP, it ended by a total revert as they couldn't figure which values to set.

 

Gimme good values for X, XX and XXX and XXXX players and I will commit it without doubt (with a performance test before/after) ;p.

 

I got other things to rework before trying to crash the db due to new system. But up to you to test and share results of your experiments.

 

Regarding PreparedStatement, it's still using close but as I don't rely on an external method, class or even Jar (like that CloseUtil.) I didn't see the use to edit it. Finally some queries still got "crafted" PreparedStatement, I prefered to keep a single writing style over the whole project.

 

-----------

 

Regarding the OP question, the shutdown process has to be reworked. If it's not that, it's one of the queries used by the Shutdown process methods.

Edited May 11, 2015 by Tryskell

[iAlreadyExist]

close this topic please only spam here 0 help

[SweeTs]

Ofc, if you expect reworked code then yeah, it is a spam. Locked.