Duplicate/confused unique key index

[rev.derek]

I'm getting this reponse when trying to delete certain trashed material and I get corresponding duplicate ID errors from time to time with ordinary email. I had a business recovering from defective LDAP when I introduced another physical server in the same network - my fault and this is the legacy.

I guess the issue is in the key index in mysql - how do I correct it?

Here is one of the error reports (all essentially the same).

Product name: Zimbra Desktop
Product version: 1.0.3
Build ID: 1691
Release type: R
OS Platform: Linux i386 2.6.31-18-generic
Time of event: 2010-01-15 11:36:25
Error type: service.FAILURE
Item ID: 7070
Error summary: delete item failed

Failure details - PLEASE REMOVE ANY SENSITIVE INFORMATION
----------------------------------------------------------------------------

com.zimbra.common.service.ServiceException: system failure: deleting contents for conversation 7070
ExceptionId:btpool0-5:1263508585612:5704fa62caec89cf
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbMailItem.deleteContents(DbMailI tem.java:1408)
at com.zimbra.cs.db.DbMailItem.delete(DbMailItem.java :1345)
at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:2448)
at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:2372)
at com.zimbra.cs.mailbox.Mailbox.delete(Mailbox.java: 5752)
at com.zimbra.cs.mailbox.OfflineMailbox.delete(Offlin eMailbox.java:242)
at com.zimbra.cs.service.mail.ItemActionHelper.execut eLocal(ItemActionHelper.java:351)
at com.zimbra.cs.service.mail.ItemActionHelper.schedu le(ItemActionHelper.java:313)
at com.zimbra.cs.service.mail.ItemActionHelper.HARD_D ELETE(ItemActionHelper.java:97)
at com.zimbra.cs.service.mail.ItemAction.handleCommon (ItemAction.java:138)
at com.zimbra.cs.service.mail.ConvAction.handle(ConvA ction.java:43)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:429)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:286)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:160)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:275)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:362)
at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:716)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebA ppContext.java:406)
at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:211)
at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.handler.RewriteHandler.handle(Re writeHandler.java:176)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:442)
Caused by: java.sql.SQLException: DELETE on table 'MAIL_ITEM' caused a violation of foreign key constraint 'FK_MAIL_ITEM_PARENT_ID' for key (20,7069). The statement has been rolled back.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.get SQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeS tatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
at com.zimbra.cs.db.DbMailItem.deleteContents(DbMailI tem.java:1406)
... 36 more
Caused by: ERROR 23503: DELETE on table 'MAIL_ITEM' caused a violation of foreign key constraint 'FK_MAIL_ITEM_PARENT_ID' for key (20,7069). The statement has been rolled back.
at org.apache.derby.iapi.error.StandardException.newE xception(Unknown Source)
at org.apache.derby.impl.sql.execute.ReferencedKeyRIC hecker.doCheck(Unknown Source)
at org.apache.derby.impl.sql.execute.RISetChecker.doP KCheck(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteResultSet. runFkChecker(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteCascadeRes ultSet.runFkChecker(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteCascadeRes ultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement .execute(Unknown Source)
... 41 more