All pastes #972207 Raw Edit

Bug whose delete items

public text v1 · immutable
·published 2008-04-05 07:53 UTC
rendered paste body
Could not insert item 268878124 into DB: Reason: Duplicate entry '268878124' for key 1
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268878124' for key 1
        at sun.reflect.GeneratedConstructorAccessor64.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        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:1016)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at net.sf.l2j.gameserver.model.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1166)
        at net.sf.l2j.gameserver.model.L2ItemInstance.updateDatabase(L2ItemInstance.java:947)
        at net.sf.l2j.gameserver.model.ItemContainer.updateDatabase(ItemContainer.java:545)
        at net.sf.l2j.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:334)
        at net.sf.l2j.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:682)
        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:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)


Could not insert item 268878124 into DB: Reason: Duplicate entry '268878124' for key 1
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268878124' for key 1
        at sun.reflect.GeneratedConstructorAccessor64.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        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:1016)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at net.sf.l2j.gameserver.model.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1166)
        at net.sf.l2j.gameserver.model.L2ItemInstance.updateDatabase(L2ItemInstance.java:947)
        at net.sf.l2j.gameserver.model.L2ItemInstance.updateDatabase(L2ItemInstance.java:911)
        at net.sf.l2j.gameserver.model.ItemContainer.addItem(ItemContainer.java:229)
        at net.sf.l2j.gameserver.model.PcInventory.addItem(PcInventory.java:326)
        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.addItem(L2PcInstance.java:2862)
        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.doAutoLoot(L2PcInstance.java:3930)
        at net.sf.l2j.gameserver.model.L2Attackable.doItemDrop(L2Attackable.java:1357)
        at net.sf.l2j.gameserver.model.L2Attackable.doItemDrop(L2Attackable.java:1277)
        at net.sf.l2j.gameserver.model.L2Attackable.calculateRewards(L2Attackable.java:516)
        at net.sf.l2j.gameserver.model.L2Character.doDie(L2Character.java:1757)
        at net.sf.l2j.gameserver.model.actor.instance.L2NpcInstance.doDie(L2NpcInstance.java:2149)
        at net.sf.l2j.gameserver.model.L2Attackable.doDie(L2Attackable.java:443)
        at net.sf.l2j.gameserver.model.actor.instance.L2MonsterInstance.doDie(L2MonsterInstance.java:199)
        at net.sf.l2j.gameserver.model.actor.status.CharStatus.reduceHp(CharStatus.java:229)
        at net.sf.l2j.gameserver.model.actor.status.NpcStatus.reduceHp(NpcStatus.java:45)
        at net.sf.l2j.gameserver.model.L2Character.reduceCurrentHp(L2Character.java:6521)
        at net.sf.l2j.gameserver.model.L2Attackable.reduceCurrentHp(L2Attackable.java:417)
        at net.sf.l2j.gameserver.model.L2Attackable.reduceCurrentHp(L2Attackable.java:361)
        at net.sf.l2j.gameserver.model.L2Character.onHitTimer(L2Character.java:5143)
        at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.onHitTimer(L2PcInstance.java:3821)
        at net.sf.l2j.gameserver.model.L2Character$HitTask.run(L2Character.java:2136)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:207)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)