Results 1 to 5 of 5

Thread: zdesktop error report: mail.ALREADY_EXISTS

Hybrid View

  1. #1
    Join Date
    Jan 2008
    Location
    Berlin, Germany
    Posts
    203
    Rep Power
    7

    Default zdesktop error report: mail.ALREADY_EXISTS

    The Account with this error is on a Zimbra ZCS NEP 6.0.7 Server and in the Zimbra Webclient everything is working fine.

    This message appears every minute or so and I have no Idea what the cause could be. So any help is appreciated. Thanks!

    Code:
    Product name:    Zimbra Desktop
    Product version: 2.0
    Build ID:        10580
    Release type:    GA
    OS Platform:     Mac OS X i386 10.6.4
    Time of event:   2010-11-23 09:02:22
    Error type:      mail.ALREADY_EXISTS
    Item ID:         1073742689
    Error summary:   message sync failed
    
    Failure details - PLEASE REMOVE ANY SENSITIVE INFORMATION
    ----------------------------------------------------------------------------
    
    com.zimbra.cs.mailbox.MailServiceException: object with that id already exists: 1073742690
    ExceptionId:sync-mbox-xxxxxxx@xxxxxxxxx.net:1290499342881:04dd83da82189350
    Code:mail.ALREADY_EXISTS ArgitemId, IID, "1073742690")
            at com.zimbra.cs.mailbox.MailServiceException.ALREADY_EXISTS(MailServiceException.java:391)
            at com.zimbra.cs.db.DbMailItem.create(DbMailItem.java:191)
            at com.zimbra.cs.mailbox.Conversation.create(Conversation.java:239)
            at com.zimbra.cs.mailbox.Mailbox.createConversation(Mailbox.java:4733)
            at com.zimbra.cs.mailbox.ZcsMailbox.setConversationId(ZcsMailbox.java:345)
            at com.zimbra.cs.mailbox.DeltaSync.syncMessage(DeltaSync.java:804)
            at com.zimbra.cs.mailbox.InitialSync.saveMessage(InitialSync.java:1272)
            at com.zimbra.cs.mailbox.InitialSync.syncMessagesAsTgz(InitialSync.java:1027)
            at com.zimbra.cs.mailbox.InitialSync.syncMessages(InitialSync.java:960)
            at com.zimbra.cs.mailbox.InitialSync.syncMessagelikeItems(InitialSync.java:441)
            at com.zimbra.cs.mailbox.DeltaSync.deltaSync(DeltaSync.java:247)
            at com.zimbra.cs.mailbox.DeltaSync.sync(DeltaSync.java:89)
            at com.zimbra.cs.mailbox.DeltaSync.sync(DeltaSync.java:73)
            at com.zimbra.cs.mailbox.MailboxSync.sync(MailboxSync.java:178)
            at com.zimbra.cs.mailbox.ZcsMailbox.sync(ZcsMailbox.java:119)
            at com.zimbra.cs.mailbox.ZcsMailbox.syncOnTimer(ZcsMailbox.java:100)
            at com.zimbra.cs.mailbox.SyncMailbox$1.run(SyncMailbox.java:262)
            at java.util.TimerThread.mainLoop(Timer.java:512)
            at java.util.TimerThread.run(Timer.java:462)
    Caused by: java.sql.SQLException: [SQLITE_CONSTRAINT]  Abort due to constraint violation (column id is not unique)
            at org.sqlite.DB.newSQLException(DB.java:374)
            at org.sqlite.DB.newSQLException(DB.java:378)
            at org.sqlite.DB.execute(DB.java:333)
            at org.sqlite.DB.executeUpdate(DB.java:354)
            at org.sqlite.PrepStmt.executeUpdate(PrepStmt.java:91)
            at com.zimbra.cs.db.DebugPreparedStatement.executeUpdate(DebugPreparedStatement.java:173)
            at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
            at com.zimbra.cs.db.DbMailItem.create(DbMailItem.java:179)
            ... 17 more
    Best regards

    Andreas Wolske

    managedhosting.de GmbH

    Zimbra Cloud Hosting, Consulting & Support
    VMware vCloud Powered Serviceprovider

  2. #2
    Join Date
    Jul 2010
    Posts
    113
    Rep Power
    5

    Default

    If you are willing to dig a bit you might be able to help us track this down. It looks like something in the database is not right.

    You will need sqlite3; which you may already have in /usr/bin on Mac.

    1. $cd ~/Library/Zimbra Desktop/sqlite
    2. $sqlite3 zimbra.db
    3. >select id,comment from mailbox; (note the id which matches your account)
    4. >.exit
    5. $sqlite3 mboxgroup<id from step 3>.db
    6. >select id,subject,type,folder_id,parent_id from mail_item where id in (1073742689, 1073742690)
    7. >pragma integrity_check

    Please post the results from 6 & 7 here.

  3. #3
    Join Date
    Jan 2008
    Location
    Berlin, Germany
    Posts
    203
    Rep Power
    7

    Default

    Quote Originally Posted by jflanigan View Post
    Please post the results from 6 & 7 here.
    I'll check this out asap and keep you posted.
    Thank you very much for your assistance.
    Best regards

    Andreas Wolske

    managedhosting.de GmbH

    Zimbra Cloud Hosting, Consulting & Support
    VMware vCloud Powered Serviceprovider

  4. #4
    Join Date
    Jan 2008
    Location
    Berlin, Germany
    Posts
    203
    Rep Power
    7

    Default

    here's the output:

    Code:
    sqlite> select id,subject,type,folder_id,parent_id from mail_item where id in (1073743743);
    1073743743|zdesktop error report (2010-12-01 09:26:39): mail.ALREADY_EXISTS|5|252|1073743744
    
    sqlite> pragma integrity_check;
    ok
    Best regards

    Andreas Wolske

    managedhosting.de GmbH

    Zimbra Cloud Hosting, Consulting & Support
    VMware vCloud Powered Serviceprovider

  5. #5
    Join Date
    Jul 2010
    Posts
    113
    Rep Power
    5

    Default

    id in (1073743743)
    This doesn't look like the ID from the original post. Did you have another occurrence which listed this ID? If so there should be a second ID in the error report which is also relevant, for example in the OP it was 1073742689 and 1073742690.

Similar Threads

  1. [SOLVED] Installing ZDesktop on terminal server
    By wcmathews in forum Installation Help
    Replies: 9
    Last Post: 10-29-2008, 02:54 PM
  2. Zdesktop with firefox
    By danny.sierra@omtech.net in forum General Questions
    Replies: 3
    Last Post: 02-29-2008, 06:53 AM
  3. [SOLVED] An easy way to start Zdesktop in Linux
    By pbruna in forum Installation Help
    Replies: 0
    Last Post: 02-29-2008, 06:53 AM
  4. zdesktop and reverse proxy
    By pbruna in forum General Questions
    Replies: 8
    Last Post: 09-17-2007, 09:00 PM
  5. ZDesktop Not Working
    By rajan in forum General Questions
    Replies: 1
    Last Post: 05-12-2007, 01:27 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
  •