Jump to content
  • 0

'To many connections'


Th3On3
 Share

Question

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!!! ???

Link to comment
Share on other sites

8 answers to this question

Recommended Posts

  • 0

you better run an other server pack because L2JEmu have many unstable sides. I was running it and i had a lot of problems... Maybe you can try with L2JOneo?

 

Or if you want to stay with L2JEmu you have to delete diskw (first backup the DB from there) and install MySQL if you chose this one tell me i will tell you how to do it :P

Link to comment
Share on other sites

  • 0

Ok i will find a differnet way.... i think

So what exactly do you think the problem is? is it that my my MySql is not configured properly to support so many people logging on to my server?

Link to comment
Share on other sites

  • 0

Ok i will find a differnet way.... i think

So what exactly do you think the problem is? is it that my my MySql is not configured properly to support so many people logging on to my server?

 

exactly ... the diskw dont have a stable mysql and the other thing is that its the most undefenced thing ever because you cant configure your own password on the MySQL :P in most cases it dont have password or the password is "root"

 

So the other way is to download MySQL 6 from http://dev.mysql.com/get/Downloads/MySQL-6.0/mysql-6.0.2-alpha-win32.zip/from/pick#mirrors Install it and configure it properly and then copy the DB from the old mysql (l2jdb) to the data folder of the new MySQL

 

Im 99% sure that this will work :P

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share



  • Posts

    • 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?
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock