[4578/7916]Server Crashing problem

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Anderuimm
Posts: 32
Joined: Mon Jul 06, 2009 7:08 pm

[4578/7916]Server Crashing problem

Post 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?
andr3iu7z
Posts: 114
Joined: Sun Jan 10, 2010 2:25 pm

Re: [4578/7916]Server Crashing problem

Post 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.
Post Reply