Results 1 to 10 of 13

Thread: Lost with DB scheme - tried to solve NO_SUCH_ITEM

Hybrid View

  1. #1
    Join Date
    Jul 2008
    Posts
    27
    Rep Power
    7

    Default Lost with DB scheme - tried to solve NO_SUCH_ITEM

    Hi

    An IMAP Client tries to sync and throws some errors - there should be an message with the id 9095 inside the Draft folder.
    Server side I get:

    com.zimbra.cs.mailbox.MailServiceException$NoSuchI temException: no such item: 9095
    ExceptionId:ImapSSLServer-3972:1370925407688:bc81f6c6df758df0
    Code:mail.NO_SUCH_ITEM ArgitemId, IID, "9095")
    at com.zimbra.cs.mailbox.MailServiceException.NO_SUCH _ITEM(MailServiceException.java:163)
    at com.zimbra.cs.mailbox.MailItem.noSuchItem(MailItem .java:1659)
    at com.zimbra.cs.mailbox.Mailbox.getItemById(Mailbox. java:2697
    ...
    The corresponding mailbox is 45 - I've searched around in the DB for the corresponding entry:

    mysql> use mboxgroup45;
    Database changed
    mysql> SELECT * FROM mail_item where id = 9095;
    Empty set (0.01 sec)
    mysql>
    I also tried to find out which folder id the Draft folder has - I recognized that the type=1 indicates folders:

    mysql> select id, name, flags, tags from mail_item where type=1;
    +------+------------------+---------+------+
    | id | name | flags | tags |
    +------+------------------+---------+------+
    | 1 | USER_ROOT | 0 | 0 |
    | 2 | Inbox | 0 | 0 |
    | 3 | Trash | 0 | 0 |
    | 4 | Junk | 0 | 0 |
    | 5 | Sent | 0 | 0 |
    | 6 | Drafts | 0 | 0 |
    | 7 | Contacts | 0 | 0 |
    | 8 | Tags | 0 | 0 |
    | 9 | Conversations | 0 | 0 |
    | 10 | Calendar | 2097152 | 0 |
    | 11 | ROOT | 0 | 0 |
    | 12 | Notebook | 0 | 0 |
    | 13 | Emailed Contacts | 0 | 0 |
    | 14 | Chats | 0 | 0 |
    | 15 | Tasks | 2097152 | 0 |
    | 16 | Briefcase | 0 | 0 |
    | 1714 | Notes | 524288 | 0 |
    | 1749 | PW | 0 | 0 |
    +------+------------------+---------+------+
    18 rows in set (0.01 sec)
    So id 6 should be the Drafts folder - I tried to find out if the DB shows me any message inside this folder. I was not sure if parent_id or folder_id is the foreign key so I tried both:

    So id 6 should mysql> SELECT * from mail_item WHERE folder_id=6;
    Empty set (0.01 sec)

    mysql> SELECT * from mail_item WHERE parent_id=6;
    Empty set (0.01 sec)

    mysql>
    I also did some queries in the tag tables but I was not able to find the corresponding item id 9095 anywhere.
    Any hint on this?

  2. #2
    Join Date
    Jul 2007
    Location
    Baltimore
    Posts
    1,649
    Rep Power
    11

    Default

    maybe try reindexing? I think the error is consistent with your findings. NO_SUCH_ITEM means it can't find the mail item in the db, as opposed to NO_SUCH_BLOB where hte item exists in the db but not in the message store

  3. #3
    Join Date
    Jul 2008
    Posts
    27
    Rep Power
    7

    Default

    Hi

    Thanks for reply. Reindexing did not help. The Imap Folder still shows one entry and an error when opening or deleting the Mail.
    Additionally a new error occurred during indexing:

    2013-06-12 10:38:16,106 WARN [ReIndex-5] [name=xxx@yyyy.com;mid=45;] index - Unable to generate index data for Message 9095. Item will not be indexed.
    com.zimbra.cs.mailbox.MailServiceException: cannot modify immutable object: 9095
    ExceptionId:ReIndex-5:1371026296106:bc81f6c6df758df0
    Code:mail.IMMUTABLE_OBJECT ArgitemId, IID, "9095")
    at com.zimbra.cs.mailbox.MailServiceException.IMMUTAB LE_OBJECT(MailServiceException.java:426)
    at com.zimbra.cs.mailbox.Mailbox.markItemModified(Mai lbox.java:1338)
    at com.zimbra.cs.mailbox.MailItem.markItemModified(Ma ilItem.java:1754)
    at com.zimbra.cs.mailbox.Message.reanalyze(Message.ja va:1291)
    at com.zimbra.cs.mailbox.Mailbox.reanalyze(Mailbox.ja va:2185)
    at com.zimbra.cs.mailbox.Message.generateIndexData(Me ssage.java:1257)
    at com.zimbra.cs.mailbox.MailboxIndex.indexItemList(M ailboxIndex.java:736)
    at com.zimbra.cs.mailbox.MailboxIndex.indexDeferredIt ems(MailboxIndex.java:373)
    at com.zimbra.cs.mailbox.MailboxIndex.access$600(Mail boxIndex.java:83)
    at com.zimbra.cs.mailbox.MailboxIndex$ReIndexTask.reI ndex(MailboxIndex.java:549)
    at com.zimbra.cs.mailbox.MailboxIndex$ReIndexTask.exe c(MailboxIndex.java:490)
    at com.zimbra.cs.mailbox.MailboxIndex$IndexTask.run(M ailboxIndex.java:1383)
    at java.util.concurrent.Executors$RunnableAdapter.cal l(Executors.java:471)
    at java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:334)
    at java.util.concurrent.FutureTask.run(FutureTask.jav a:166)
    at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:722)

    I am also not sure how many users are affected. So far it only happens in one specific folder. Maybe other users do have the same problem as soon as they try to open a specific folder.
    Any further thoughts?

    BR
    J

  4. #4
    Join Date
    Jul 2008
    Posts
    27
    Rep Power
    7

    Default

    ok. I found out that there is NO content for the Zimbra WebGUI and als zmmailbox tells me the same:

    mbox xxxx@yyyyyy.com> GetAllFolders
    Id View Unread Msg Count Path
    ---------- ---- ---------- ---------- ----------
    1 unkn 0 0 /
    16 docu 0 1 /Briefcase
    10 appo 0 3 /Calendar
    14 mess 0 1 /Chats
    7 cont 0 1 /Contacts
    6 mess 0 0 /Drafts
    13 cont 0 61 /Emailed Contacts
    2 mess 1 2533 /Inbox
    4 mess 0 0 /Junk
    12 docu 0 0 /Notebook
    1714 mess 0 0 /Notes
    1749 mess 0 4 /PW
    5 mess 0 754 /Sent
    15 task 0 0 /Tasks
    3 unkn 0 0 /Trash
    Drafts is really really empty

    So I completly removed the users Email Client inclusive all Settings (cloned the Inbox before) and reinstalled it again and now it works.
    It seems some IMAP clients do have issues when a Zimbra installation was recovered after a crash due to some missing blobs etc.

    BR

  5. #5
    Join Date
    Jul 2008
    Posts
    27
    Rep Power
    7

    Default

    Damn - not solved. After a few minutes of syncing the "Drafts" Folder still shows one corrupt message.

    I'd be happy to try other ideas

  6. #6
    Join Date
    Mar 2006
    Location
    Greenwood, IN
    Posts
    90
    Rep Power
    9

    Default

    Which ZCS version? Can you check the dumpster table in mboxgroup45?

    select * from mail_item_dumpster where id=9095\G
    --
    Jason Bryan
    Zimbra R&D

Similar Threads

  1. New 6.0 NE backup scheme
    By mfvm in forum Administrators
    Replies: 1
    Last Post: 09-13-2010, 05:56 AM
  2. Replies: 4
    Last Post: 05-26-2010, 06:51 AM
  3. What is the logical scheme of INVID ?
    By Michael REMY in forum Developers
    Replies: 0
    Last Post: 04-28-2010, 03:01 AM
  4. Cluster partition scheme
    By freefall in forum Installation
    Replies: 5
    Last Post: 07-25-2007, 01:05 PM
  5. mail.NO_SUCH_ITEM
    By shideg in forum Administrators
    Replies: 4
    Last Post: 03-28-2007, 11:24 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
  •