Jump to content
  • 0

'To many connections'


Question

Posted

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

8 answers to this question

Recommended Posts

  • 0
Posted

1st : check What JAVA you have istalled.

2nd : check in Server Proprieties How many are the max connection to the DB.

 

3rd : what pack you are using...

  • 0
Posted

ok thx for responding

 

1. I have sun java update 13

 

2. For Gameserver =500

    For Loginserver = 5000

 

3. I am using L2J-EMU

 

  • 0
Posted

Maybe try to reconfigure MySQL service? :P Because as i know L2JEmu dose not have diskw. I think you missed something in the configuration...

  • 0
Posted

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

  • 0
Posted

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?

  • 0
Posted

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

Guest
This topic is now closed to further replies.


  • Posts

    • My official facebook profile!: https://www.facebook.com/spectrumL2 Specifications: Revamped L2JACIS revision FROM the core Private project!!! Revision that has been receiving corrections for over 3 years!!! Events already installed in the revision: TVT CTF KTB PARTY FARM SPOIL EVENT CRAZY RATES TOURNAMENT TIME ZONE (INSTANCE) All working correctly!!! SIEGE ESSENTIAL FEATURES: Walls fix Gates fix Flags fix 100% functional: OLYMPIADS: Implemented settings Hero receives enchanted Weapons with equal status PvP Weapons Optional /true/false Hero can acquire all Hero Weapons Optional true/false OTHER IMPLEMENTATIONS: Teleport fixed (directly to Giran) Teleport effect classic Vip skins vip collor name Pack NPCs with effect already configured BOSES already configured Mobs already configured CLASS BALANCE SPECIAL SYSTEM We have a SPECIAL system developed for Class Balance with only 1 digit in XML %tage of configurable debuffs Player limitation system in BOSES or PvP zones BS blocking system in FLEG zones or events Among others dozens of improvements made in the review... price: 390 USD !  OBS: WE CAN CHANGE THE BANNER AND NAME OF THE SERVICE TO THE ONE OF YOUR PREFERENCE BUT THE SETTINGS MUST BE KEPT ANY CHANGES REQUIRE ADDITION        
    • Server is Online – 1,000+ Active Players! We’re excited to announce the addition of a Europe Proxy to improve connectivity for our EU players! Clans can now benefit from VIP Access to help you catch up faster. 🎯 If you're a clan leader with at least 9 active members, join our Discord and open a ticket to claim your VIP rewards!  
    • The Telegram team is rolling out a new batch of Stars-only gifts you’ll be able to mint as NFTs. Don’t miss your chance to join the next Telegram trend and earn from it! Buy Telegram Stars cheap and KYC-free 1 Star from $0.0149 (min. 50 Stars, bulk discounts available) Promo code STARS5 — 5 % off Pay any way you like: bank cards · crypto · other popular methods How to purchase: ➡Online Store — Click ➡ Telegram bot — Click Other services: ➡ SMM panel — Click Regular buyers get extra discounts and promo codes. Support: ➡ Telegram: https://t.me/solomon_bog ➡ Telegram channel: https://t.me/accsforyou_shop ➡ Discord: https://discord.gg/y9AStFFsrh ➡ WhatsApp: https://wa.me/79051904467 ➡ Email: solomonbog@socnet.store Use these contacts to discuss wholesale orders, partnerships (current list: https://socnet.bgng.io/partners) or to become a supplier. SocNet — your shop for digital goods and premium subscriptions
  • 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