Duplicate entry '349767' for key 'PRIMARY'

[GoogleCodeExporter]

Core revision:
r231

Bug description:
Console.log error

Please copy/paste errors below:
[WARN] 2011-03-31 17:14:15 - com.aionemu.commons.database.DB:321 - Failed to 
execute IU query 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Duplicate entry '349767' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Duplicate entry '349767' for key 'PRIMARY'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)

Original issue reported on code.google.com by crazy_xp...@live.com on 31 Mar 2011 at 9:18

[GoogleCodeExporter]

I have same warn.
[WARN 2011-03-31 11:01:26] com.aionemu.commons.database.DB:321 - Failed to 
execute IU query 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Duplicate entry '91434-0-0' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Duplicate entry '91434-0-0' for key 'PRIMARY'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    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:409)
    at com.mysql.jdbc.Util.getInstance(Util.java:384)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
    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:2568)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at mysql5.MySQL5ItemStoneListDAO$1.handleInsertUpdate(MySQL5ItemStoneListDAO.java from JavaSourceFromFile:187)
    at com.aionemu.commons.database.DB.insertUpdate(DB.java:314)
    at com.aionemu.commons.database.DB.insertUpdate(DB.java:293)
    at mysql5.MySQL5ItemStoneListDAO.addItemStone(MySQL5ItemStoneListDAO.java from JavaSourceFromFile:180)
    at mysql5.MySQL5ItemStoneListDAO.storeManaStone(MySQL5ItemStoneListDAO.java from JavaSourceFromFile:113)
    at mysql5.MySQL5ItemStoneListDAO.save(MySQL5ItemStoneListDAO.java from JavaSourceFromFile:93)
    at gameserver.model.gameobjects.player.Player$ItemUpdateTask.run(Player.java:1280)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:54)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:39)
    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:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
    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:662)

Original comment by apsorder...@gmail.com on 31 Mar 2011 at 10:15

[GoogleCodeExporter]

Did you use commands at all to slot the Items originally, or manually add 
slotted Item stones into the Database?

Original comment by ZeroSign...@gmail.com on 1 Apr 2011 at 4:59

• Changed state: Started

[GoogleCodeExporter]

I did nothing just see warn

Original comment by apsorder...@gmail.com on 1 Apr 2011 at 7:33

[GoogleCodeExporter]

I cant replicate this issue so we need reproducible steps that has caused this 
issue. I have added and removed Manastones several times and found nothing.

Only thing I can think of is add this and see if it works.

Original comment by ZeroSign...@gmail.com on 1 Apr 2011 at 11:01

Attachments:

• Enchant_Manastone_Dup_Error_Fix_1.patch

[GoogleCodeExporter]

Apply patch, test and report results.

Original comment by ZeroSign...@gmail.com on 5 Apr 2011 at 2:09

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Fixed Committed Revision 244.

Original comment by ZeroSign...@gmail.com on 6 Apr 2011 at 3:53

• Changed state: Fixed