l2jserver / l2j-server-game / issues / #64 - Item loss — Bitbucket

Issue #64 new

DoctorVal created an issue 2017-03-23

From time to time when players send mail with attachments items not deliver and warning appears mail has attachments but itemcontainer is empty

Plus from time to time items are lost and duplicate entry for item appears in console

Comments (2)

Zoey76
- changed component to CORE
- changed version to 2.6.0.0
- 2017-04-21T20:46:28+00:00

ShinichiYao

logs catched

#!
[18 Jun 17:42:42] CREATE:Party, item 268580498:Sealed Vesper Gloves(1), L2PcInstance:PlayerA[268505058], L2MonsterInstance:Maluk Leader(22838)[268578834]
[23 Jun 10:11:27] SETOWNER:SendMail, item 268580498:Sealed Vesper Gloves(1), L2PcInstance:PlayerA[268505058], PlayerB[268502904]
[23 Jun 11:20:02] SETOWNER:Mail, item 268580498:Sealed Vesper Gloves(1), L2PcInstance:PlayerB[268502904]
[23 Jun 22:02:17] CREATE:Buy, item 268580498:Necklace of Valakas(1), L2PcInstance:PlayerC[268483139]
[23 Jun 22:02:25] SETOWNER:Drop, item 268580498:Necklace of Valakas(1), L2PcInstance:PlayerC[268483139]
[23 Jun 22:02:33] SETOWNER:Pickup, item 268580498:Necklace of Valakas(1), L2PcInstance:PlayerD[268543953]

#!
Jun 23, 2017 10:02:17 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1436)
    at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.addItem(ItemContainer.java:328)
    at com.l2jserver.gameserver.model.itemcontainer.PcInventory.addItem(PcInventory.java:509)
    at com.l2jserver.gameserver.network.clientpackets.RequestBuyItem.runImpl(RequestBuyItem.java:265)
    at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:69)
    at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1134)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Jun 23, 2017 10:02:33 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1436)
    at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.addItem(ItemContainer.java:266)
    at com.l2jserver.gameserver.model.itemcontainer.PcInventory.addItem(PcInventory.java:477)
    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.addItem(L2PcInstance.java:3193)
    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.doPickupItem(L2PcInstance.java:4585)
    at com.l2jserver.gameserver.ai.L2PlayerAI.thinkPickUp(L2PlayerAI.java:299)
    at com.l2jserver.gameserver.ai.L2PlayerAI.onEvtThink(L2PlayerAI.java:345)
    at com.l2jserver.gameserver.ai.L2CharacterAI.onEvtArrived(L2CharacterAI.java:763)
    at com.l2jserver.gameserver.ai.AbstractAI.notifyEvent(AbstractAI.java:389)
    at com.l2jserver.gameserver.ai.AbstractAI.notifyEvent(AbstractAI.java:318)
    at com.l2jserver.gameserver.model.actor.L2Character.lambda$updatePosition$1(L2Character.java:4145)
    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:89)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Jun 23, 2017 10:02:36 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1436)
    at com.l2jserver.gameserver.model.itemcontainer.Inventory.setPaperdollItem(Inventory.java:1102)
    at com.l2jserver.gameserver.model.itemcontainer.Inventory.equipItem(Inventory.java:1474)
    at com.l2jserver.gameserver.model.itemcontainer.Inventory.equipItemAndRecord(Inventory.java:1361)
    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.useEquippableItem(L2PcInstance.java:2179)
    at com.l2jserver.gameserver.network.clientpackets.UseItem.runImpl(UseItem.java:324)
    at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:69)
    at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1134)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Jun 23, 2017 10:04:57 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.updateDatabase(ItemContainer.java:619)
    at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:381)
    at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:943)
    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:89)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.runAndReset(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.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Jun 23, 2017 10:05:17 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1436)
    at com.l2jserver.gameserver.model.itemcontainer.Inventory.setPaperdollItem(Inventory.java:1084)
    at com.l2jserver.gameserver.model.itemcontainer.Inventory.unEquipItemInSlot(Inventory.java:1219)
    at handlers.admincommandhandlers.AdminEnchant.setEnchant(AdminEnchant.java:211)
    at handlers.admincommandhandlers.AdminEnchant.useAdminCommand(AdminEnchant.java:148)
    at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:168)
    at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:69)
    at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1134)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Jun 23, 2017 10:05:17 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1436)
    at com.l2jserver.gameserver.model.itemcontainer.Inventory.setPaperdollItem(Inventory.java:1102)
    at com.l2jserver.gameserver.model.itemcontainer.Inventory.equipItem(Inventory.java:1474)
    at handlers.admincommandhandlers.AdminEnchant.setEnchant(AdminEnchant.java:213)
    at handlers.admincommandhandlers.AdminEnchant.useAdminCommand(AdminEnchant.java:148)
    at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:168)
    at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:69)
    at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1134)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Jun 23, 2017 10:19:57 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.updateDatabase(ItemContainer.java:619)
    at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:381)
    at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:943)
    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:89)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.runAndReset(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.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Jun 23, 2017 10:34:57 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.updateDatabase(ItemContainer.java:619)
    at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:381)
    at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:943)
    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:89)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.runAndReset(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.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Jun 23, 2017 10:49:57 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.updateDatabase(ItemContainer.java:619)
    at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:381)
    at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:943)
    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:89)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.runAndReset(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.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Jun 23, 2017 11:04:57 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.updateDatabase(ItemContainer.java:619)
    at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:381)
    at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:943)
    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:89)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.runAndReset(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.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Jun 23, 2017 11:19:57 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.updateDatabase(ItemContainer.java:619)
    at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameClient.java:381)
    at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2GameClient.java:943)
    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:89)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.runAndReset(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.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Jun 23, 2017 11:29:46 PM com.l2jserver.gameserver.model.items.instance.L2ItemInstance insertIntoDb
SEVERE: Could not insert item Necklace of Valakas(6657)[268580498] into DB: Reason: Duplicate entry '268580498' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '268580498' 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:400)
    at com.mysql.jdbc.Util.getInstance(Util.java:383)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
    at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
    at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeUpdate(HikariPreparedStatementProxy.java)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.insertIntoDb(L2ItemInstance.java:1692)
    at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1466)
    at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.deleteMe(ItemContainer.java:599)
    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.cleanup(L2PcInstance.java:11420)
    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.deleteMe(L2PcInstance.java:11093)
    at com.l2jserver.gameserver.network.L2GameClient$CleanupTask.run(L2GameClient.java:916)
    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:89)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

2017-06-27T01:13:22+00:00

Log in to comment

Assignee: Zoey76

Type: bug

Priority: major

Status: new

Component: CORE

Version: 2.6.0.0

Votes: 3

Watchers: 5

Jira: the preferred issue tracker for Bitbucket. Join the team!