Strange Error (and DC for ppl)

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
RaiDeR
Posts: 50
Joined: Sat Sep 05, 2009 8:42 am

Strange Error (and DC for ppl)

Post 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.
_DS_
L2j Veteran
L2j Veteran
Posts: 3437
Joined: Wed Apr 30, 2008 8:53 am
Location: Russia

Re: Strange Error (and DC for ppl)

Post by _DS_ »

This is overloaded MYSQL.
Commiter of the shit
public static final int PI = 3.1415926535897932384626433832795;
RaiDeR
Posts: 50
Joined: Sat Sep 05, 2009 8:42 am

Re: Strange Error (and DC for ppl)

Post by RaiDeR »

_DS_ wrote:This is overloaded MYSQL.
Thx, how i cant awoid that? increase Max mysql connection?
_DS_
L2j Veteran
L2j Veteran
Posts: 3437
Joined: Wed Apr 30, 2008 8:53 am
Location: Russia

Re: Strange Error (and DC for ppl)

Post 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.
Commiter of the shit
public static final int PI = 3.1415926535897932384626433832795;
RaiDeR
Posts: 50
Joined: Sat Sep 05, 2009 8:42 am

Re: Strange Error (and DC for ppl)

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