Page 2 of 2 FirstFirst 12
Results 11 to 11 of 11

Thread: mysql crash (stack trace) - corrupt backup

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

    Default

    6.) mail.NO_SUCH_BLOB

    Following message also occured several times and it seems it prevents some clients from IMAP sync (eg. Thunderbird and KMail)

    com.zimbra.cs.mailbox.MailServiceException: No such blob: mailbox=54, item=926, change=208873
    ExceptionId:ImapSSLServer-3687: ......................
    Code:mail.NO_SUCH_BLOB ArgitemId, IID, "926") Argver, NUM, "208873")
    In general: this message is the opposite of the unexpected blob message from above - there is a DB entry but no msg file any more.

    So let's check the mailbox with the ID 54:

    su - zimbra
    mysql
    use mboxgroup54;

    show tables;
    +-----------------------+
    | Tables_in_mboxgroup54 |
    +-----------------------+
    | appointment |
    | appointment_dumpster |
    | data_source_item |
    | imap_folder |
    | imap_message |
    | mail_item |
    | mail_item_dumpster |
    | open_conversation |
    | pop3_message |
    | revision |
    | revision_dumpster |
    | tag |
    | tagged_item |
    | tombstone |
    +-----------------------+
    14 rows in set (0.00 sec)



    select id,type,parent_id,folder_id,index_id,imap_id,mod_c ontent from mail_item where id=926;
    +-----+------+-----------+-----------+----------+---------+-------------+
    | id | type | parent_id | folder_id | index_id | imap_id | mod_content |
    +-----+------+-----------+-----------+----------+---------+-------------+
    | 926 | 5 | NULL | 2 | 926 | 926 | 208873 |
    +-----+------+-----------+-----------+----------+---------+-------------+
    it seems the "change" part from the error message above (208873) is the mod_content field - at least this is my interpretation.
    So I started to search for a corresponding msg file inside the store. It seems the name is created from the id and mod_content field.

    I checked this with other (still valid and existing) messages. This DB entry:

    select id,type,parent_id,folder_id,index_id,imap_id,mod_c ontent,locator from mail_item where id=1049;
    +------+------+-----------+-----------+----------+---------+-------------+---------+
    | id | type | parent_id | folder_id | index_id | imap_id | mod_content | locator |
    +------+------+-----------+-----------+----------+---------+-------------+---------+
    | 1049 | 5 | NULL | 2 | 1049 | 1049 | 242782 | 1 |
    +------+------+-----------+-----------+----------+---------+-------------+---------+
    1 row in set (0.00 sec)
    also had a corresponding file

    store/0/54/msg/0/1049-242782.msg
    So the message with the ID 926 and the mod_content 208873 that caused the error from above should have a corresponding file 926-208873.msg in the mailboxgroup directory.

    zimbra@its2004:~/store/0/54$ pwd
    /opt/zimbra/store/0/54
    zimbra@its2004:~/store/0/54$ find . -name "926-208873.msg"
    zimbra@its2004:~/store/0/54$
    Nope ... and I was also not able to detect the msg somewhere in my (destroyed) backup.
    So I had no chance to restore the missing msg file - the only thing I could do was to "repair" the DB by removing the orphaned entry:

    mysql> delete from mail_item WHERE id=926;
    Query OK, 1 row affected (0.00 sec)
    ATTENTION: YOU SHOULD KNOW WHAT YOU ARE DOING HERE!!!!

    I think (but I don't know) it might be a good idea to re-index after botching around in the DB directly.

    zmprov rim user@domain.com start
    Sadly the user lost it's mail but at least the error message in the log never showed up again.
    Last edited by juergenmw; 06-10-2013 at 04:47 AM.

Similar Threads

  1. Replies: 13
    Last Post: 03-25-2010, 07:37 AM
  2. Disable hidden stack trace on failed login
    By rhouston in forum Administrators
    Replies: 0
    Last Post: 03-12-2010, 03:15 PM
  3. HTC Magic sync ==> stack trace
    By perbu in forum Zimbra Mobile
    Replies: 12
    Last Post: 08-12-2009, 03:34 AM
  4. [SOLVED] Crash disk and mboxgroup corrupt
    By elibre in forum Administrators
    Replies: 2
    Last Post: 04-12-2009, 02:42 AM
  5. MySQL DB corrupt
    By Urs in forum Installation
    Replies: 3
    Last Post: 11-03-2008, 05:43 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
  •