Duplicate items in sent items

[floor]

Good morning gentlemen,

We're using Zimbra version 6.0.4_GA_2038.UBUNTU6_64.NETWORK 14 dec 2009, and a user reported a problem about duplicate emails in his sent items when he was cleaning up his mailbox.

He is not using the Zimbra connector for Outlook, he only logs on to Zimbra using the web client. If you take a look at the attached image, you can see that there are about 90.000 emails in his sent items, and you can see a lot of duplicate emails.

How is this possible, and how do I prevent this from happening?

[uxbod]

Welcome to the forums

They all appear to be from November 2009 did you have a problem with the server around that time ? You could try re-indexing the mailbox.

[floor]

We didn't have any problems with the server around that time, or any problems with the server at all.

I can see that these duplicates stopped around december 2009, and I cant really see where they started, scrolling through 90000 emails takes too long. Anyway, I tried re-indexing the mailbox, but the progresbar immediately goes to 100%, and it says "0 messages re-indexed, 0 messages waiting, 0 messages failed". Is this supposed to happen? I never re-indexed a mailbox before.

[floor]

Hmm, re-indexing the mailbox didn't really solve the problem, the sent items mailbox went from 90500 items to 89000 items. Are there any other ways to solve this? Can I run a script that deletes all duplicates, or all emails between two specified dates?

[uxbod]

This may help

su - zimbra
zmmailbox -z -m user@domain.com search -l 1000000 "in:/Sent (after:03/23/10) (before:03/26/10)" | awk '{ if (NR>4) { print $2; } }'

Just change the date range to what you require. That will create a list of message ID's. Once you have that for each of those you can execute

su - zimbra
zmmailbox -z -m user@domain.com dm <message_ID>

Just remember to take a backup of the account first!

[floor]

Originally Posted by uxbod

This may help

su - zimbra
zmmailbox -z -m user@domain.com search -l 1000000 "in:/Sent (after:03/23/10) (before:03/26/10)" | awk '{ if (NR>4) { print $2; } }'

Just change the date range to what you require. That will create a list of message ID's. Once you have that for each of those you can execute

su - zimbra
zmmailbox -z -m user@domain.com dm <message_ID>

Just remember to take a backup of the account first!

Thank you very much! I get a very long list of message ID's, with about 990 items. It kinda looks like this:

-142312
142279
-142275
142240
-142236
-142233
142200
-142196
-142193
142162
-142158
142122
-142115
142083
-142079

When I copy one of these message ID's to the zmmailbox command to delete these messages, the total number of items in the send item box decreases with one. I would expect this number to decrease much faster, but it only deletes one message. Is this supposed to happen?

Another thing I noticed is that I can only delete messages with a - in front of the message ID. When I delete one without a dash in front of the message ID, I get this:

zimbra@mail:/home/username$ zmmailbox -z -m user@domain.com dm 142162
ERROR: mail.NO_SUCH_MSG (no such message: 142162)