Jump to content
MaxCheaters Official Group on Discord
-> Place your ad text here <-
We're Rebuilding – Join Our Staff Team
  • 0

'To many connections'

Th3On3

Asked by Th3On3,

 Share

Question

Th3On3 Newbie

Th3On3

Posted
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
GoDofAdeN Newbie

GoDofAdeN

Posted
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
Th3On3 Newbie

Th3On3

Posted
  • Author
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
jaff Newbie

jaff

Posted
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
jaff Newbie

jaff

Posted
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
Th3On3 Newbie

Th3On3

Posted
  • Author
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
jaff Newbie

jaff

Posted
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.
 Share
Go to question listing


  • Posts

    • EUSOUOMESTREDOSMAGOS
      The character stops walking when using a mana potion.

      By EUSOUOMESTREDOSMAGOS · Posted

      The character stops walking when using a mana potion. any can help me?   IemData item_begin    etcitem    728    [mana_potion]    item_type=etcitem    slot_bit_type={none}    armor_type=none    etcitem_type=potion    recipe_id=0    blessed=0    weight=180    default_action=action_skill_reduce    consume_type=consume_type_stackable    initial_count=1    maximum_count=20    soulshot_count=0    spiritshot_count=0    reduced_soulshot={}    reduced_spiritshot={}    reduced_mp_consume={}    immediate_effect=1    price=0    default_price=2000    item_skill=[s_mana_potion]    critical_attack_skill=[none]    attack_skill=[none]    magic_skill=[none]    item_skill_enchanted_four=[none]    material_type=liquid    crystal_type=none    crystal_count=0    is_trade=1    is_drop=1    is_destruct=1    physical_damage=0    random_damage=0    weapon_type=none    can_penetrate=0    critical=0    hit_modify=0    avoid_modify=0    dual_fhit_rate=0    shield_defense=0    shield_defense_rate=0    attack_range=0    damage_range={}    attack_speed=0    reuse_delay=10000    mp_consume=0    magical_damage=0    durability=0    damaged=0    physical_defense=0    magical_defense=0    mp_bonus=0    category={}    enchanted=0    html=[item_default.htm]    equip_pet={@ALL_PET}    magic_weapon=0    enchant_enable=0    can_equip_sex=-1    can_equip_race={}    can_equip_change_class=-1    can_equip_class={}    can_equip_agit=-1    can_equip_castle=-1    can_equip_castle_num={}    can_equip_clan_leader=-1    can_equip_clan_level=-1    can_equip_hero=-1    can_equip_nobless=-1    can_equip_chaotic=-1    item_end   SkillData   skill_begin    skill_name=[s_mana_potion]    skill_id=50004    level=1    operate_type=A2    magic_level=1    effect={{t_mp;57;3}}    is_magic=0    mp_consume2=0    cast_range=-1    effective_range=-1    skill_hit_time=0    skill_cool_time=0    skill_hit_cancel_time=0    reuse_delay=0    activate_rate=-1    lv_bonus_rate=0    basic_property=none    abnormal_time=15    abnormal_lv=1    abnormal_type=mp_recovery    attribute=attr_none    effect_point=0    target_type=self    affect_scope=single    affect_limit={0;0}    next_action=none    debuff=0    ride_state={@ride_none}    skill_end  
    • Anto1988
      WTS/WTB L2REBORN / E-Global x Lu4 TOP PRICE

      By Anto1988 · Posted

      scammer
    • Asocks
      PREMIUM RESIDENTIAL AND MOBILE PROXY | GET 3 GBS FOR FREE

      By Asocks · Posted

      To get a promo code, reply in this thread!
    • L2Valkyria007
      [L2J] L2Valkyria

      By L2Valkyria007 · Posted

      Valkyria is online!
    • WhiTeAnGeL*
      [L2J] L2Elixir

      By WhiTeAnGeL* · Posted

      Very good server! 

  • 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