Results 1 to 6 of 6

Thread: Duplicate items in sent items

  1. #1
    floor is offline Member
    Join Date
    Mar 2010
    Posts
    12
    Rep Power
    5

    Default Duplicate items in sent items

    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?
    Attached Images Attached Images

  2. #2
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    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.

  3. #3
    floor is offline Member
    Join Date
    Mar 2010
    Posts
    12
    Rep Power
    5

    Default

    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.

  4. #4
    floor is offline Member
    Join Date
    Mar 2010
    Posts
    12
    Rep Power
    5

    Default

    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?

  5. #5
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    This may help
    Code:
    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
    Code:
    su - zimbra
    zmmailbox -z -m user@domain.com dm <message_ID>
    Just remember to take a backup of the account first!

  6. #6
    floor is offline Member
    Join Date
    Mar 2010
    Posts
    12
    Rep Power
    5

    Default

    Quote Originally Posted by uxbod View Post
    This may help
    Code:
    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
    Code:
    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)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Why is Zimbra so buggy?
    By edwin.arneson in forum Users
    Replies: 50
    Last Post: 11-14-2011, 09:38 AM
  2. Connector finds folders and items however does not import them
    By berkeb in forum Zimbra Connector for Outlook
    Replies: 3
    Last Post: 03-11-2010, 06:44 AM
  3. ZCS Backup Report: FAIL, (No such file or directory)
    By RJones in forum Administrators
    Replies: 16
    Last Post: 03-08-2010, 02:40 AM
  4. Syncing Sent Items to Mobile
    By tonkski in forum Zimbra Mobile
    Replies: 0
    Last Post: 12-07-2009, 11:00 AM
  5. Zimbra, IMAP, and Entourage / No sent items on server
    By stevegarriques in forum Installation
    Replies: 0
    Last Post: 05-19-2009, 08:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •