Error could not delete skill: An SQLException was provoked..

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
User avatar
xone
Posts: 122
Joined: Thu Nov 05, 2009 5:04 am

Error could not delete skill: An SQLException was provoked..

Post by xone »

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:4211
L2JDP Revision Number:7423
Got you folks another one 8)

Code: Select all

Error could not delete skill: 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.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 com.l2jserver.gameserver.model.actor.instance.L2PcInstance.removeSkill(L2PcInstance.java:8153)        at com.l2jserver.gameserver.model.L2Augmentation.removeBonus(L2Augmentation.java:162)        at com.l2jserver.gameserver.model.itemcontainer.Inventory$ItemSkillsListener.notifyUnequiped(Inventory.java:290)        at com.l2jserver.gameserver.model.itemcontainer.Inventory.setPaperdollItem(Inventory.java:1079)        at com.l2jserver.gameserver.model.itemcontainer.Inventory.unEquipItemInBodySlot(Inventory.java:1290)        at com.l2jserver.gameserver.model.itemcontainer.Inventory.unEquipItemInBodySlotAndRecord(Inventory.java:1183)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.disarmWeapons(L2PcInstance.java:6693)        at com.l2jserver.gameserver.skills.effects.EffectDisarm.onStart(EffectDisarm.java:54)        at com.l2jserver.gameserver.model.L2Effect.setInUse(L2Effect.java:319)        at com.l2jserver.gameserver.model.CharEffectList.addEffectFromQueue(CharEffectList.java:815)        at com.l2jserver.gameserver.model.CharEffectList.queueRunner(CharEffectList.java:574)        at com.l2jserver.gameserver.model.CharEffectList.queueEffect(CharEffectList.java:544)        at com.l2jserver.gameserver.model.actor.L2Character.addEffect(L2Character.java:2722)        at com.l2jserver.gameserver.model.L2Effect.startEffectTask(L2Effect.java:383)        at com.l2jserver.gameserver.model.L2Effect.scheduleEffect(L2Effect.java:512)        at com.l2jserver.gameserver.model.L2Skill.getEffects(L2Skill.java:2415)        at handlers.skillhandlers.Disablers.useSkill(Disablers.java:185)        at com.l2jserver.gameserver.model.actor.L2Character.callSkill(L2Character.java:6547)        at com.l2jserver.gameserver.model.actor.L2Character.onMagicHitTimer(L2Character.java:6142)        at com.l2jserver.gameserver.model.actor.L2Character$MagicUseTask.run(L2Character.java:2581)        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)        at java.util.concurrent.FutureTask.run(Unknown Source)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(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 java.lang.Object.wait(Object.java:485)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:552)        ... 31 more
and some others :O

Code: Select all

Unclosed connection! Trace: com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeEffect(L2PcInstance.java:7951)java.lang.RuntimeException        at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:223)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeEffect(L2PcInstance.java:7951)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7788)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7799)        at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:311)        at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:736)        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) Unclosed connection! Trace: com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeEffect(L2PcInstance.java:7951)java.lang.RuntimeException        at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:223)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeEffect(L2PcInstance.java:7951)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7788)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.setActiveClass(L2PcInstance.java:10889)        at com.l2jserver.gameserver.model.actor.instance.L2VillageMasterInstance.onBypassFeedback(L2VillageMasterInstance.java:438)        at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:146)        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:92)        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) Could not update item 268684518 in DB: Reason: 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.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 com.l2jserver.gameserver.model.L2ItemInstance.updateInDb(L2ItemInstance.java:1514)        at com.l2jserver.gameserver.model.L2ItemInstance.updateDatabase(L2ItemInstance.java:1342)        at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.updateDatabase(ItemContainer.java:607)        at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:314)        at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:736)        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 java.lang.Object.wait(Object.java:485)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:552)        ... 17 more 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 com.l2jserver.gameserver.model.actor.instance.L2PcInstance.transformInsertInfo(L2PcInstance.java:5146)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7789)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7799)        at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:311)        at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:736)        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 java.lang.Object.wait(Object.java:485)        at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:552)        ... 17 more EnterWorld failed! activeChar returned 'null'.Duplicate character!? Closing both characters (Aforismenos)Could not store char effect data:com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268669934-1035-4-0' for key 'PRIMARY'        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.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeEffect(L2PcInstance.java:8017)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7788)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7799)        at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:311)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.logout(L2PcInstance.java:1447)        at com.l2jserver.gameserver.LoginServerThread$1.run(LoginServerThread.java:490)        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)        at java.util.concurrent.FutureTask.run(Unknown Source)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(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) FourSepulchersManager: Entry time: Mon May 24 01:55:47 EEST 2010Could not store char effect data:com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268555979-264-1-0' for key 'PRIMARY'        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.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeEffect(L2PcInstance.java:8017)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7788)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2PcInstance.java:7799)        at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:311)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.logout(L2PcInstance.java:1447)        at com.l2jserver.gameserver.LoginServerThread$1.run(LoginServerThread.java:490)        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)        at java.util.concurrent.FutureTask.run(Unknown Source)        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(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)  
Post Reply