Results 1 to 5 of 5

Thread: [SOLVED] One Mailbox crash

  1. #1
    idiotech is offline Member
    Join Date
    Jul 2007
    Posts
    12
    Rep Power
    8

    Default [SOLVED] One Mailbox crash

    Hello,

    I have this morning a big problem with one MailBox on Zimbra 5.0.6 OSS on Debian 4.

    When i try to login on ONE account, i cant and i have a arror in the mailbox.log :
    Code:
    com.zimbra.cs.mailbox.MailServiceException: object with that name already exists: Warnings
    ExceptionId:btpool0-14:1215590566359:f07ba3d5512c88aa
    Code:mail.ALREADY_EXISTS
    	at com.zimbra.cs.mailbox.MailServiceException.ALREADY_EXISTS(MailServiceException.java:364)
    	at com.zimbra.cs.mailbox.Folder.addChild(Folder.java:891)
    	at com.zimbra.cs.mailbox.Mailbox.loadFoldersAndTags(Mailbox.java:1493)
    	at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mailbox.java:1190)
    	at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mailbox.java:1138)
    	at com.zimbra.cs.mailbox.Mailbox.getItemList(Mailbox.java:2306)
    	at com.zimbra.cs.mailbox.Mailbox.getItemList(Mailbox.java:2295)
    	at com.zimbra.cs.mailbox.Mailbox.getItemList(Mailbox.java:2291)
    	at com.zimbra.cs.mailbox.Mailbox.getTagList(Mailbox.java:2696)
    	at com.zimbra.cs.session.SoapSession.putRefresh(SoapSession.java:682)
    	at com.zimbra.soap.SoapEngine.generateResponseHeader(SoapEngine.java:486)
    	at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:301)
    	at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:159)
    	at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:266)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    	at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:189)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
    	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
    	at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81)
    	at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:132)
    	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
    	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
    	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
    	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
    	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:716)
    	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.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(HandlerWrapper.java:139)
    	at org.mortbay.jetty.handler.rewrite.RewriteHandler.handle(RewriteHandler.java:350)
    	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
    	at org.mortbay.jetty.Server.handle(Server.java:313)
    	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
    	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:844)
    	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644)
    	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
    	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
    	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
    	at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
    if i try to access from the command line, i have the same error :
    Code:
     zmmailbox -z -m myuser@domain.com
    ERROR: mail.ALREADY_EXISTS (object with that name already exists: Warnings)
    I think i have problem in my DB,
    Can i migrate all the mailbox to a new one?

  2. #2
    mmorse's Avatar
    mmorse is offline Moderator
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    21

    Default

    That appears to be 2 folders named Warnings.

    1) Get the user ID of the account in question.
    su - zimbra
    zmprov ga <account>@domain.com zimbraId

    1) Login to mysql on the zimbra host
    mysql

    2) Change to zimbra database
    use zimbra;

    3) Find the group ID for the account
    select group_id from mailbox where account_id="<zimbraId>";

    4) Change to the mboxgroup<group_id> database;
    use mboxgroup<group_id>;

    4) Find the duplicate entries
    select * from mail_item where name="Warnings";

    Post us the output from that - or if you know what you're doing you might proceed to:

    5) Change one of the duplicate folder names
    update mail_item set name="<new name>", subject="<new name>" where id=<id number>;

  3. #3
    idiotech is offline Member
    Join Date
    Jul 2007
    Posts
    12
    Rep Power
    8

    Default

    Thank you very much.

    it was exactly the problem.
    I have 3 messages with the same subject

    So i change 2 on 3. And now the account re-work.

    Thanks a lot.

  4. #4
    gjpyne Guest

    Default Refine the update to avoid unintended DB changes...

    Quote Originally Posted by mmorse View Post
    That appears to be 2 folders named Warnings.


    Post us the output from that - or if you know what you're doing you might proceed to:

    5) Change one of the duplicate folder names
    update mail_item set name="<new name>", subject="<new name>" where id=<id number>;
    ...
    I would recommend that you
    select * mail_item where id=<id number>;
    choose the offending mail item... and refine your selection to show only the item you want to change..

    I did this by adding the mailbox_id... in my case this resulted in a single row
    select * mail_item where id=<id number> and mailbox_id=<mailbox id>;

    This resulted in a single row..
    Then it was safe to update..

    update mail_item set name="new folder name", subject="new folder name" where id=<id number> and mailbox_id=<mailbox id>;

  5. #5
    marc@ion.lu is offline Member
    Join Date
    Dec 2008
    Posts
    13
    Rep Power
    6

    Default Source of the problem?

    I encountered a similar today with 2 mailboxes:
    object with that id already exists

    I just deleted the entries with the erroneous ID to get it working again.

    Weird fact:
    - both mailboxes were in the same domain (@customer.tld)
    - both mailboxes were in different mailbox groups
    - none of the other 500 mailboxes where "damaged"
    - this customer is using the Outlook connector (not the only one though)

    As the customer lost 12 hours worth of emails, I'd like to find the source of the issue.

    Thanks in advance,

    Best regards,

    Marc M.
    Last edited by marc@ion.lu; 08-19-2009 at 07:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 210
    Last Post: 01-17-2012, 01:19 AM
  2. server dropped connection
    By ferra in forum Installation
    Replies: 20
    Last Post: 10-06-2008, 04:32 PM
  3. can't you help me
    By iwan siahaan in forum Administrators
    Replies: 6
    Last Post: 12-17-2007, 06:53 PM
  4. Replies: 11
    Last Post: 06-22-2007, 01:32 PM
  5. zmtlsctl give LDAP error
    By sourcehound in forum Administrators
    Replies: 5
    Last Post: 03-11-2007, 03:48 PM

Posting Permissions

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