[help]Gameserver error and Full lag

[DareStrike]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 5281:
L2JDP Revision 8790:

Hello then throws these error in the game server server lag incredibly.
the fix

this error 2
this error 3

Code: Select all

 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@53ffa244 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (0). Last acquisition attempt exception: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection,  message from server: "Too many connections"    at sun.reflect.GeneratedConstructorAccessor97.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)    at com.mysql.jdbc.Util.getInstance(Util.java:386)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1128)    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2336)    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)    at sun.reflect.GeneratedConstructorAccessor25.newInstance(Unknown Source)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:152)    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1074)    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1061)    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1796)    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:620)

new

Code: Select all

 java.lang.NullPointerException    at com.l2jserver.gameserver.model.actor.instance.L2PetInstance.restoreEffects(L2PetInstance.java:1104)    at com.l2jserver.gameserver.model.actor.L2Summon.onSpawn(L2Summon.java:122)    at com.l2jserver.gameserver.model.L2Object.spawnMe(L2Object.java:537)    at com.l2jserver.gameserver.datatables.CharSummonTable.restorePet(CharSummonTable.java:315)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.onActionRequest(L2PcInstance.java:11621)    at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:72)    at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1104)    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)    at java.lang.Thread.run(Thread.java:722) 

[MELERIX]

message from server: "Too many connections"

possibly is a custom npc buffer that is leaving unclosed mysql connections...

[lucan]

Maybe increasing the Max connections in MySQL config?

[MELERIX]

yep, but if connections are not closed, it will continue eating more connections, until max connections value, and will throw same error again.

[DareStrike]

ie what can I do to fix it

yep, but if connections are not closed, it will continue eating more connections, until max connections value, and will throw same error again.

[DareStrike]

what I make from mysql

Maybe increasing the Max connections in MySQL config?

this my pc


Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz, 8 cores
24GB
CentOS Linux

Code: Select all

 # ---------------------------------------------------------------------------# Thread Configuration# ---------------------------------------------------------------------------# Extreme caution should be here, set to defaults if you do not know what you are doing.# These could possibly hurt your servers performance or improve it depending on your server's configuration, size, and other factors.# Default: 10ThreadPoolSizeEffects = 50# Default: 13ThreadPoolSizeGeneral = 65# Default: 2UrgentPacketThreadCoreSize = 10# Default: 4GeneralPacketThreadCoreSize = 20# Default: 4GeneralThreadCoreSize = 20# Default: 6AiMaxThread = 20 

gameserverloop

Code: Select all

 java -server -Djava.util.logging.manager=com.l2jserver.util.L2LogManager -Xms2048m -Xmx5000m -Xmn512m -Xss128k -XX:ParallelGCThreads=6 -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:SurvivorRatio=8 -XX:TargetSurvivorRatio=90 -XX:MaxTenuringThreshold=31 -XX:+AggressiveOpts -cp ./../libs/*:l2jserver.jar com.l2jserver.gameserver.GameServer > log/stdout.log 2>&1 

[MELERIX]

ie what can I do to fix it

learn about how to use "search button" may be ?

search.php?keywords=Too+many+connections

search.php?keywords=unclosed+connections