[SOLVED] One Mailbox crash

[idiotech]

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 :

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 :

 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?

[mmorse]

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>;

[idiotech]

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.

[gjpyne]

Originally Posted by mmorse

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>;

[marc@ion.lu]

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.