Friday night I upgraded to 8.5.0 all seemed to go well except when I sent the notice to all users to say the upgrade was complete one account bounced back to me immediately with;
554 5.0.0 Permanent message delivery failure (in reply to end of DATA command)
In mailbox.log I spied;
com.zimbra.cs.mailbox.MailServiceException: object with that id already exists: 9066
Code:mail.ALREADY_EXISTS Arg:(itemId, IID, "9066")
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '506-9066' for key 'PRIMARY'
Query being executed when exception was thrown:
INSERT INTO mboxgroup6.mail_item(mailbox_id, id, type, parent_id, folder_id, index_id, imap_id, date, size, locator, blob_digest, unread, flags, tag_names, sender, recipients, subject, name, metadata, mod_metadata, change_date, mod_content, uuid) VALUES (506, 9066, 5, null, 2, 0, 9066, 1414218834, 2768, '1', 'rS5iIGzMXNGH52+Osxe04O69kHSoAurB2LHmZEzHBnw=', 1, 0, null, 'Me', 'everyone', 'Maintenance Completed', null, 'd1:f151:Everyone, All forward facing services have now been restored, there will still be some tasks being performed in the background this evening however ...1:s38:ME <user@ourdomain>1:t32:everyone <everyone@ourdomain>1:vi10ee', 21351, 1414218838, 21351, null)
The key point being the error "object with that id already exists: 9066"
I also logged in as this user and attempted to send an email and was met with the same error;
An object with that name already exists.
msg: object with that id already exists: 9066
I have reindexed this users account a number of times and the error persists, I have logged this with support but 2 day's later they still have not responded.
Anyone have suggestions?