Page 1 of 1

Strange Error (and DC for ppl)

Posted: Mon Oct 19, 2009 4:11 pm
by RaiDeR
If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 3615:
L2JDP Revision 6705:

Code: Select all

Transformation insert info: java.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.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:562)	at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkoutStatement(GooGooStatementCache.java:168)	at com.mchange.v2.c3p0.impl.NewPooledConnection.checkoutStatement(NewPooledConnection.java:277)	at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:199)	at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.transformInsertInfo(L2PcInstance.java:4933)	at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7482)	at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7487)	at net.sf.l2j.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:300)	at net.sf.l2j.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:727)	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)	at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)	at java.lang.Thread.run(Thread.java:619)Caused by: java.lang.InterruptedException	at java.lang.Object.wait(Native Method)	at java.lang.Object.wait(Object.java:485)	at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:552)	... 17 more 
What is that? All ppl get DC, and pc thinks hardly.

Re: Strange Error (and DC for ppl)

Posted: Mon Oct 19, 2009 5:49 pm
by _DS_
This is overloaded MYSQL.

Re: Strange Error (and DC for ppl)

Posted: Mon Oct 19, 2009 6:24 pm
by RaiDeR
_DS_ wrote:This is overloaded MYSQL.
Thx, how i cant awoid that? increase Max mysql connection?

Re: Strange Error (and DC for ppl)

Posted: Mon Oct 19, 2009 6:38 pm
by _DS_
No, find custom what consume connections (assuming maxconnections in mysql set to reasonable value = number of players).

Or maybe your website create additional load.

Re: Strange Error (and DC for ppl)

Posted: Wed Oct 21, 2009 4:42 pm
by RaiDeR
_DS_ wrote:No, find custom what consume connections (assuming maxconnections in mysql set to reasonable value = number of players).

Or maybe your website create additional load.
Maybe this error because all memory(ram) used? Because i dont find what can overload mysql...