I am writing in reference to a previous post on this issue, Unexpected Blobs in zmblobchk . In that post, the user chose to delete the message files from the local filesystem store in order to clear the "unexpected blob" warning messages after running zmblobchk. I cannot delete these files in this case and I'm looking for the solution to this problem.

First, as root, I ran fix permissions as;
Code:
/opt/zimbra/libexec/zmfixperms --verbose --extended
Then as the Zimbra user, I ran an integrity report, which returned with no errors found.
Code:
/opt/zimbra/libexec/zmdbintegrityreport -v
I also chose to check the database integrity manually by first stopping Zimbra with
Code:
zmcontrol stop
Then the check database with
Code:
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=XXXXXXXXXXX
The MySQL root password was found with
Code:
zmlocalconfig -s | grep mysql_root_password
This returned no errors.

After running zmblobchk, I have many errors about "unexpected blobs" as well as "file has incorrect revision" messages.

From the output of zmblobchk, I chose to work only with errors associated to my user account. I determined the mailboxID of 3 for my account using
Code:
for i in `zmprov -l gaa`; do echo "$i `zmprov gmi $i`" | grep mailboxId;  done
Here is a snip for zmblobchk to take note of.
Code:
zimbra@zim:~/store/0/3/msg/0$ zmblobchk -m 3 -v start | grep 438-
Mailbox 3, volume 1, /opt/zimbra/store/0/3/msg/0/438-4221.msg: unexpected blob.  File size is 813.
Mailbox 3, volume 1, /opt/zimbra/store/0/3/msg/0/438-32931.msg: unexpected blob.  File size is 3813.
I viewed one of these files that's being reported and determined it to be a document that was created under my Zimbra user account in the Notebook area of the web interface. This particular file is shown as having 3 revisions.

A listing of the store directory displays all three revisions as expected.
Code:
zimbra@zim:~/store/0/3/msg/0$ ls -l 438*
-rw-r----- 1 zimbra zimbra  813 Jan  5  2010 438-4221.msg
-rw-r----- 1 zimbra zimbra 2161 Jul  3  2010 438-18471.msg
-rw-r----- 1 zimbra zimbra 3813 Dec 22  2010 438-32931.msg
There is the original file created on Jan 5 and the most recent version is dated Dec 22. If I were to delete the msg files that are being reported as unexpected blobs after running zmblobchk, I would lose the most recent version. Let's look at the database tables to ensure that there are proper records, one for the original file and two records for each of the revisions.

This query shows the associated record for the original file from Jan 5.
Code:
zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.mail_item where id=438\G'
*************************** 1. row ***************************
  mailbox_id: 3
          id: 438
        type: 14
   parent_id: NULL
   folder_id: 12
    index_id: 438
     imap_id: 438
        date: 1293086682
        size: 3813
   volume_id: 1
 blob_digest: i20hObKIgRXJABIbcvNCTNLqi,I=
      unread: NULL
       flags: 4096
        tags: 0
      sender: NULL
     subject: New Account Template
        name: New Account Template
    metadata: d2:cr14:user@domain.org2:ct24:text/html; charset=utf-81:f141:Hi xxxx- I am writing you to tell you that we have a new school email server.  The new email interface can be reached at the following URL ...2:ua51:ZimbraWebClient - FF3.0 (Win)/6.0.3_GA_1915.DEBIAN51:vi10e3:veri3ee
mod_metadata: 32931
 change_date: 1293086682
 mod_content: 32931
There are also appropriate records for each of the revisions.
Code:
zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438\G'
*************************** 1. row ***************************
  mailbox_id: 3
     item_id: 438
     version: 1
        date: 1262755009
        size: 813
   volume_id: 1
 blob_digest: kIef1MSV2mtoLzXVsXUGiFrn1Y4=
        name: New Account Template
    metadata: d2:cr14:user@domain.org2:ct24:text/html; charset=utf-81:f141:Hi xxxx- I am writing you to tell you that we have a new school email server.  The new email interface can be reached at the following URL ...2:ua49:ZimbraWebClient - IE8 (Win)/6.0.3_GA_1915.DEBIAN51:vi10ee
mod_metadata: 4221
 change_date: 1262755009
 mod_content: 4221
*************************** 2. row ***************************
  mailbox_id: 3
     item_id: 438
     version: 2
        date: 1278217989
        size: 2161
   volume_id: 1
 blob_digest: IMXdUJFy+oxt5LeeZb90Or4mfTs=
        name: New Account Template
    metadata: d2:cr14:user@domain.org2:ct24:text/html; charset=utf-81:f141:Hi xxxx- I am writing you to tell you that we have a new school email server.  The new email interface can be reached at the following URL ...2:ua51:ZimbraWebClient - FF3.0 (Win)/6.0.3_GA_1915.DEBIAN51:vi10e3:veri2ee
mod_metadata: 18471
 change_date: 1278217990
 mod_content: 18471
How can I fix this properly so that I don't delete the most recent copy of the document? Thanks in advance.