[l2gold]

Почему то кода трейд юзаешь, или в обычном гм шопе покупаешь, или подбор итема с земли - таких ошибок не возникает !

а с почтой возникают, потом народ в игре жалуется что через почту итемы пропадают, послал вещи и с концами ....


[08:31:56] ERROR Error while saving mail!
java.sql.BatchUpdateException: Duplicate entry '268856293' for key 'item_id'
at com.mysql.jdbc.PreparedStatement.executeBatchSeria lly(PreparedStatement.java:2035)
at com.mysql.jdbc.PreparedStatement.executeBatch(Prep aredStatement.java:1458)
at org.apache.commons.dbcp.DelegatingStatement.execut eBatch(DelegatingStatement.java:297)
at org.apache.commons.dbcp.DelegatingStatement.execut eBatch(DelegatingStatement.java:297)
at l2s.gameserver.dao.MailDAO.save0(MailDAO.java:144)
at l2s.gameserver.dao.MailDAO.save(MailDAO.java:476)
at l2s.gameserver.model.mail.Mail.save(Mail.java:285)
at l2s.gameserver.taskmanager.actionrunner.tasks.Dele teExpiredMailTask.doTask(DeleteExpiredMailTask.jav a:41)
at l2s.gameserver.taskmanager.actionrunner.tasks.Auto maticTask.runImpl0(AutomaticTask.java:28)
at l2s.gameserver.taskmanager.actionrunner.ActionWrap per.runImpl(ActionWrapper.java:47)
at l2s.commons.threading.RunnableImpl.run(RunnableImp l.java:21)
at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityCons traintViolationException: Duplicate entry '268856293' for key 'item_id'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1039)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4098)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4030)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2677)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2134)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2434)
at com.mysql.jdbc.PreparedStatement.executeBatchSeria lly(PreparedStatement.java:1987)
... 18 more







[10:11:56] ERROR Error while saving mail!
java.sql.BatchUpdateException: Duplicate entry '269001620' for key 'item_id'
at com.mysql.jdbc.PreparedStatement.executeBatchSeria lly(PreparedStatement.java:2035)
at com.mysql.jdbc.PreparedStatement.executeBatch(Prep aredStatement.java:1458)
at org.apache.commons.dbcp.DelegatingStatement.execut eBatch(DelegatingStatement.java:297)
at org.apache.commons.dbcp.DelegatingStatement.execut eBatch(DelegatingStatement.java:297)
at l2s.gameserver.dao.MailDAO.save0(MailDAO.java:144)
at l2s.gameserver.dao.MailDAO.save(MailDAO.java:476)
at l2s.gameserver.model.mail.Mail.save(Mail.java:285)
at l2s.gameserver.taskmanager.actionrunner.tasks.Dele teExpiredMailTask.doTask(DeleteExpiredMailTask.jav a:41)
at l2s.gameserver.taskmanager.actionrunner.tasks.Auto maticTask.runImpl0(AutomaticTask.java:28)
at l2s.gameserver.taskmanager.actionrunner.ActionWrap per.runImpl(ActionWrapper.java:47)
at l2s.commons.threading.RunnableImpl.run(RunnableImp l.java:21)
at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityCons traintViolationException: Duplicate entry '269001620' for key 'item_id'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1039)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4098)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4030)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2677)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2134)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2434)
at com.mysql.jdbc.PreparedStatement.executeBatchSeria lly(PreparedStatement.java:1987)
... 18 more



[11:34:23] ERROR Error while saving mail!
java.sql.BatchUpdateException: Duplicate entry '269111655' for key 'item_id'
at com.mysql.jdbc.PreparedStatement.executeBatchSeria lly(PreparedStatement.java:2035)
at com.mysql.jdbc.PreparedStatement.executeBatch(Prep aredStatement.java:1458)
at org.apache.commons.dbcp.DelegatingStatement.execut eBatch(DelegatingStatement.java:297)
at org.apache.commons.dbcp.DelegatingStatement.execut eBatch(DelegatingStatement.java:297)
at l2s.gameserver.dao.MailDAO.save0(MailDAO.java:144)
at l2s.gameserver.dao.MailDAO.save(MailDAO.java:476)
at l2s.gameserver.model.mail.Mail.save(Mail.java:285)
at l2s.gameserver.network.l2.c2s.RequestExSendPost.ru nImpl(RequestExSendPost.java:306)
at l2s.gameserver.network.l2.c2s.L2GameClientPacket.r un(L2GameClientPacket.java:50)
at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MM OExecutableQueue.java:38)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityCons traintViolationException: Duplicate entry '269111655' for key 'item_id'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1039)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4098)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4030)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2677)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2134)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2434)
at com.mysql.jdbc.PreparedStatement.executeBatchSeria lly(PreparedStatement.java:1987)
... 12 more
[11:35:12] ERROR Error while saving mail!
java.sql.BatchUpdateException: Duplicate entry '269102772' for key 'item_id'
at com.mysql.jdbc.PreparedStatement.executeBatchSeria lly(PreparedStatement.java:2035)
at com.mysql.jdbc.PreparedStatement.executeBatch(Prep aredStatement.java:1458)
at org.apache.commons.dbcp.DelegatingStatement.execut eBatch(DelegatingStatement.java:297)
at org.apache.commons.dbcp.DelegatingStatement.execut eBatch(DelegatingStatement.java:297)
at l2s.gameserver.dao.MailDAO.save0(MailDAO.java:144)
at l2s.gameserver.dao.MailDAO.save(MailDAO.java:476)
at l2s.gameserver.model.mail.Mail.save(Mail.java:285)
at l2s.gameserver.network.l2.c2s.RequestExSendPost.ru nImpl(RequestExSendPost.java:306)
at l2s.gameserver.network.l2.c2s.L2GameClientPacket.r un(L2GameClientPacket.java:50)
at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MM OExecutableQueue.java:38)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityCons traintViolationException: Duplicate entry '269102772' for key 'item_id'
at sun.reflect.GeneratedConstructorAccessor224.newIns tance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1039)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4098)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4030)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2677)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2134)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2434)
at com.mysql.jdbc.PreparedStatement.executeBatchSeria lly(PreparedStatement.java:1987)
... 12 more

[iqman]

Передано на рассмотрение.

[iqman]

Исправлен мини дюп.