xbarel

Members
  • Content Count

    58
  • Joined

  • Last visited

  • Days Won

    1
  • Feedback

    0%

xbarel last won the day on April 16 2019

xbarel had the most liked content!

Community Reputation

3 Neutral

About xbarel

  • Rank
    Heir

Profile Information

  • Current Mood
    Busy
  • Gender
    Male
  • Country
    Greece
  • Location
    Larisa

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Ευχαριστώ το πρόβλημα λύθηκε. Ενεργοποίησα την επιλογή <property name="closeConnectionWatch">true</property> στο αρχείο : /libs/bonecp-0.8.1.RELEASE.jar και ανέφερε λεπτομέρειες για το σφάλμα που βοήθησαν να βρω το script που δεν έκλεινε τα connections που έκανε στην βάση.
  2. Καλησπέρα, # The time before a database connection closes (in milliseconds) # If a query takes longer to execute than the time defined here, the server will throw "Unclosed Connection!" error. # If you get often this error message, try increasing this. # Default: 60000ms ConnectionCloseTime = 120000 Feature αρκετά , μπορώ να πάρω μια αναφορά τι και κάθε πότε πραγματοποιεί σύνδεση με την βάση ?
  3. Καλησπέρα σας, Παρακαλώ την βοήθεια σας με το παρακάτω μήνυμα, ο server σταματάει (L2J H5) και προσπαθώ να βρω τι το προκαλεί : [28/05 02:26:52] BoneCPConnectionFactory: Unable to get a connection! java.sql.SQLException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.jolbox.bonecp.PoolUtil.generateSQLException(PoolUtil.java:192) at com.jolbox.bonecp.DefaultConnectionStrategy.getConnectionInternal(DefaultConnectionStrategy.java:95) at com.jolbox.bonecp.AbstractConnectionStrategy.getConnection(AbstractConnectionStrategy.java:90) at com.jolbox.bonecp.BoneCP.getConnection(BoneCP.java:552) at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:131) at com.l2jserver.commons.database.pool.IConnectionFactory.getConnection(IConnectionFactory.java:60) at com.l2jserver.gameserver.model.variables.PlayerVariables.storeMe(PlayerVariables.java:90) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7160) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeMe(L2PcInstance.java:7174) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.deleteMe(L2PcInstance.java:10806) at com.l2jserver.gameserver.network.L2GameClient$CleanupTask.run(L2GameClient.java:917) at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:89) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.InterruptedException at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(Unknown Source) at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(Unknown Source) at java.util.concurrent.LinkedBlockingQueue.poll(Unknown Source) at com.jolbox.bonecp.DefaultConnectionStrategy.getConnectionInternal(DefaultConnectionStrategy.java:82) ... 17 more
  4. Καλησπέρα , Πως μπορώ να διορθώσω το πρόβλημα που προκαλεί το κόλλημα του gameserver με τα παρακάτω μηνύματα : Ιουλ 21, 2019 8:16:56 ΜΜ com.l2jserver.commons.database.pool.IConnectionFactory getConnection WARNING: HikariCPConnectionFactory: Unable to get a connection! java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30530ms. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:601) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:194) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:144) at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) at com.l2jserver.commons.database.pool.IConnectionFactory.getConnection(IConnectionFactory.java:60) at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateInDb(L2ItemInstance.java:1637) at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1449) at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1428) at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.addItem(ItemContainer.java:335) at com.l2jserver.gameserver.model.itemcontainer.PcInventory.addItem(PcInventory.java:510) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.addItem(L2PcInstance.java:3390) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.addItem(L2PcInstance.java:3314) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.doAutoLoot(L2PcInstance.java:4488) at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.doAutoLoot(L2PcInstance.java:4499) at com.l2jserver.gameserver.model.actor.L2Attackable.doItemDrop(L2Attackable.java:1173) at com.l2jserver.gameserver.model.actor.L2Attackable.doItemDrop(L2Attackable.java:1122) at com.l2jserver.gameserver.model.actor.L2Attackable.calculateRewards(L2Attackable.java:612) at com.l2jserver.gameserver.model.actor.L2Character.doDie(L2Character.java:2458) at com.l2jserver.gameserver.model.actor.L2Npc.doDie(L2Npc.java:1209) at com.l2jserver.gameserver.model.actor.L2Attackable.doDie(L2Attackable.java:339) at com.l2jserver.gameserver.model.actor.instance.L2MonsterInstance.doDie(L2MonsterInstance.java:135) at com.l2jserver.gameserver.model.actor.status.CharStatus.reduceHp(CharStatus.java:181) at com.l2jserver.gameserver.model.actor.status.NpcStatus.reduceHp(NpcStatus.java:59) at com.l2jserver.gameserver.model.actor.status.AttackableStatus.reduceHp(AttackableStatus.java:66) at com.l2jserver.gameserver.model.actor.L2Character.reduceCurrentHp(L2Character.java:6317) at com.l2jserver.gameserver.model.actor.L2Attackable.reduceCurrentHp(L2Attackable.java:313) at com.l2jserver.gameserver.model.actor.L2Attackable.reduceCurrentHp(L2Attackable.java:246) at com.l2jserver.gameserver.model.actor.L2Character.onHitTimer(L2Character.java:4875) at com.l2jserver.gameserver.model.actor.tasks.character.HitTask.run(HitTask.java:60) at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:89) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)