Object with that ID already exists: Difference between revisions

Line 3: Line 3:


======Description======
======Description======
This issue rarely occurs when checkpoint (MySQL DB) value not updating. When this issue occurred, /opt/zimbra/log/mailbox.log will be logged with similar lines.
This issue rarely occurs when checkpoint (MySQL DB) value not updating. When this issue occurred, <code>/opt/zimbra/log/mailbox.log</code> will be logged with similar lines.


:<pre>[LmtpServer-xxx] [name=affected.user@example.com;mid=xxx;ip=xxx.xxx.xxx.xxx;] lmtp - rejecting message from=sender@example.com,to=affected.user@example.com&#10;com.zimbra.cs.mailbox.MailServiceException: object with that id already exists: 159560&#10;ExceptionId:LmtpServer-xxx:1645554762772:c850cab6de85e27d&#10;Code:mail.ALREADY_EXISTS Arg:(itemId, IID, "159560")&#10;. &#10;. &#10;Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=20) Duplicate entry '2447-159560' for key 'PRIMARY'&#10;</pre>
:<pre>[LmtpServer-xxx] [name=affected.user@example.com;mid=xxx;ip=xxx.xxx.xxx.xxx;] lmtp - rejecting message from=sender@example.com,to=affected.user@example.com&#10;com.zimbra.cs.mailbox.MailServiceException: object with that id already exists: 159560&#10;ExceptionId:LmtpServer-xxx:1645554762772:c850cab6de85e27d&#10;Code:mail.ALREADY_EXISTS Arg:(itemId, IID, "159560")&#10;. &#10;. &#10;Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=20) Duplicate entry '2447-159560' for key 'PRIMARY'&#10;</pre>

Revision as of 08:41, 6 August 2022

Problem

LMTP rejecting messages with the exception "object with that id already exists".

Description

This issue rarely occurs when checkpoint (MySQL DB) value not updating. When this issue occurred, /opt/zimbra/log/mailbox.log will be logged with similar lines.

[LmtpServer-xxx] [name=affected.user@example.com;mid=xxx;ip=xxx.xxx.xxx.xxx;] lmtp - rejecting message from=sender@example.com,to=affected.user@example.com
com.zimbra.cs.mailbox.MailServiceException: object with that id already exists: 159560
ExceptionId:LmtpServer-xxx:1645554762772:c850cab6de85e27d
Code:mail.ALREADY_EXISTS Arg:(itemId, IID, "159560")
. 
. 
Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=20) Duplicate entry '2447-159560' for key 'PRIMARY'
Jump to: navigation, search