Page 1 of 1

[4578/7916]Server Crashing problem

Posted: Fri Apr 29, 2011 12:17 pm
by Anderuimm
If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 4578:
L2JDP Revision 7916:

Good morning, L2JServer. Fist, sorry I'm using the Google Translator. I'm having trouble with some server crashings. Below is the last error log at the time of the last crash.

Code: Select all

Apr 28, 2011 9:07:38 PM com.l2jserver.L2DatabaseFactory$ConnectionCloser runWARNING: Unclosed connection! Trace: sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)java.lang.RuntimeException    at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:227)    at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)    at java.lang.reflect.Method.invoke(Unknown Source)    at org.python.core.PyReflectedFunction.__call__(Unknown Source)    at org.python.core.PyMethod.__call__(Unknown Source)    at org.python.core.PyObject.__call__(Unknown Source)    at org.python.core.PyInstance.invoke(Unknown Source)    at org.python.pycode.serializable._pyx1303995631443.viewAllSchemeBuffs$21(__init__.py:434)    at org.python.pycode.serializable._pyx1303995631443.call_function(__init__.py)    at org.python.core.PyTableCode.call(Unknown Source)    at org.python.core.PyTableCode.call(Unknown Source)    at org.python.core.PyFunction.__call__(Unknown Source)    at org.python.pycode.serializable._pyx1303995631443.onAdvEvent$14(__init__.py:768)    at org.python.pycode.serializable._pyx1303995631443.call_function(__init__.py)    at org.python.core.PyTableCode.call(Unknown Source)    at org.python.core.PyTableCode.call(Unknown Source)    at org.python.core.PyTableCode.call(Unknown Source)    at org.python.core.PyFunction.__call__(Unknown Source)    at org.python.core.PyMethod.__call__(Unknown Source)    at org.python.core.PyObject.__call__(Unknown Source)    at org.python.core.PyObject._jcallexc(Unknown Source)    at org.python.core.PyObject._jcall(Unknown Source)    at org.python.proxies.main$Quest$424.onAdvEvent(Unknown Source)    at com.l2jserver.gameserver.model.quest.Quest.notifyEvent(Quest.java:448)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.processQuestEvent(L2PcInstance.java:1763)    at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:212)    at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)    at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1001)    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)    at java.lang.Thread.run(Unknown Source)Apr 28, 2011 9:07:38 PM com.mchange.v2.resourcepool.BasicResourcePool prelimCheckoutResourceWARNING: com.mchange.v2.resourcepool.BasicResourcePool@215f7107 -- an attempt to checkout a resource was interrupted, and the pool is still live: some other thread must have either interrupted the Thread attempting checkout!java.lang.InterruptedException    at java.lang.Object.wait(Native Method)    at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1402)    at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:594)    at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:514)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:681)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:608)    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)    at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:225)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeCharBase(L2PcInstance.java:7621)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7591)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7604)    at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:360)    at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:831)    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:86)    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)    at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)    at java.util.concurrent.FutureTask.runAndReset(Unknown Source)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)    at java.lang.Thread.run(Unknown Source)Apr 28, 2011 9:07:38 PM com.l2jserver.L2DatabaseFactory getConnectionWARNING: L2DatabaseFactory: getConnection() failed, trying again An SQLException was provoked by the following failure: java.lang.InterruptedExceptionjava.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:617)    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)    at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:225)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeCharBase(L2PcInstance.java:7621)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7591)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7604)    at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:360)    at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:831)    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:86)    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)    at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)    at java.util.concurrent.FutureTask.runAndReset(Unknown Source)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(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.lang.Object.wait(Native Method)    at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1402)    at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:594)    at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:514)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:681)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:608)    ... 17 more 
Someone told me that these errors of Unclosed Connection are caused by Rina4's buffer, but would not cause a crash. I'll be updating the server to revision 4599(SV)/7961(DP) today to try to solve the problem, but if the problem is not with the revision, I wonder how I can solve it.
My dedicated server has 8GB of RAM, with 2 Gameservers Gameserver running online with 80-100 players each. It is programmed to use 'Xmx2048' on startGameServer.bat. Their processor is a Q9300 Core2Quad and, according to performance graphics, it is not even reaching the 50% processor usage. With this configuration I guess the problem is not lack of hardware resources.

Other thing: how can I program the Events (Race, Rabbits and Elpyes) to run automatically?

Re: [4578/7916]Server Crashing problem

Posted: Thu May 12, 2011 5:34 am
by andr3iu7z
Yes, its from rin4a buffer "__init__.py:434" if you go this line you probabbly see something like .getConnection()
you should put it in a try and in finally to put con.close().
Also if its the default rin4a are about ~10 Unclosed Connection.

PS: if is from this buffer the server should stuck and you dont get any disconnect, just stuck in game.