Ok well recently my server has been expierencing a problem I have no idea what it is called and no idea how to fix. I will post the code bellow. I know it is something to do with too many people connecting but have no idea how to fix?
INFO : An exception occurred while acquiring a poolable resource. Will retry. ja
va.sql.SQLException: Data source rejected establishment of connection, message
from server: "Too many connections"
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:991)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:266)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:135)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe
sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource
Pool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourc
ePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicRe
sourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre
adPoolAsynchronousRunner.java:547)
If you are good at fixing this kind of stuff plz help
My server has been loosing votes on Hopzone because of this error.
What happens when this error shows up is its repeated and repeated making it so no one can connect to the gameserver. so my server is listed as down and no one can vote plz help me!!! ???
Hi, i will be GM and i help him so mysql needs to be edited also.
But what should be values in gameserver.bat
[code]REM Default parameters for a basic server.
java -version:1.7 -Djava.util.logging.manager=com.l2jserver.util.L2LogManager -Xms1024m -Xmx1024m -cp ./../libs/*;l2jserver.jar com.l2jserver.gameserver.GameServer
REM
REM If you have a big server and lots of memory, you could experiment for example with
REM java -server -Xmx1536m -Xms1024m -Xmn512m -XX:PermSize=256m [/code]
Hello dear friends, im selling ready to go vanganth downgraded to c4 retail with many fixes with script and geodata latest. Already running valkyrie X1 if you like to test. www.esl2.org. send me private message if you interesting. 200€ without source and 300 with source.
Ok i get it i must edit
How about gameserver.bat and login server.bat
I just wanna be sure im not missing something
Yes sir i know, last time we got 500 ppl but we were with 4 gb ram and we got issue. So i wanna make sure everything is cool
What should actually worry you if you expect a high amount of players (by high talking about 1k+ real players, is if your project's code can handle such load (this is a typical issue by using good/bad base projects).
About launch configs study your current one and then google your "java" related questions so you can get accurate information through stackoverflow and other forums that actually have answers for almost everything you're going to need.
Server.proprierts
# Maximum database connections.
MaximumDbConnections = 1000
# Define how many players are allowed to play simultaneously on your server.
MaximumOnlineUsers = 1000
# =================================================================
# Threadpool
# =================================================================
# Determines the amount of scheduled thread pools. If set to -1, the server will decide the amount depending on the available processors.
ScheduledThreadPoolCount = -1
# Specifies how many threads will be in a single scheduled pool.
ThreadsPerScheduledThreadPool = 750
# Determines the amount of instant thread pools. If set to -1, the server will decide the amount depending on the available processors.
InstantThreadPoolCount = -1
# Specifies how many threads will be in a single instant pool.
ThreadsPerInstantThreadPool = 8
LoguinServer
# Maximum database connections.
MaximumDbConnections = 1000
Can you make your question clearer now?
Question
Th3On3
Ok well recently my server has been expierencing a problem I have no idea what it is called and no idea how to fix. I will post the code bellow. I know it is something to do with too many people connecting but have no idea how to fix?
If you are good at fixing this kind of stuff plz help
My server has been loosing votes on Hopzone because of this error.
What happens when this error shows up is its repeated and repeated making it so no one can connect to the gameserver. so my server is listed as down and no one can vote plz help me!!! ???
Link to comment
Share on other sites
8 answers to this question
Recommended Posts