Unexpected Blobs in...
 
Notifications
Clear all

Unexpected Blobs in zmblobchk - Revisited

1 Posts
1 Users
0 Likes
1,276 Views
(@eduit)
Posts: 1
Topic starter
 

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;
/opt/zimbra/libexec/zmfixperms --verbose --extended

Then as the Zimbra user, I ran an integrity report, which returned with no errors found.

/opt/zimbra/libexec/zmdbintegrityreport -v

I also chose to check the database integrity manually by first stopping Zimbra with

zmcontrol stop

Then the check database with

/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

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

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.

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.

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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.mail_item where id=438G'
************************ 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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438G'
************************ 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.

/opt/zimbra/libexec/zmfixperms --verbose --extended

Then as the Zimbra user, I ran an integrity report, which returned with no errors found.
/opt/zimbra/libexec/zmdbintegrityreport -v

I also chose to check the database integrity manually by first stopping Zimbra with

zmcontrol stop

Then the check database with

/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

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

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.

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.

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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.mail_item where id=438G'
************************ 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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438G'
************************ 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.

/opt/zimbra/libexec/zmdbintegrityreport -v

I also chose to check the database integrity manually by first stopping Zimbra with
zmcontrol stop

Then the check database with

/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

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

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.

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.

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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.mail_item where id=438G'
************************ 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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438G'
************************ 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.

zmcontrol stop

Then the check database with
/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

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

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.

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.

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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.mail_item where id=438G'
************************ 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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438G'
************************ 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.

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

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.

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.

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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.mail_item where id=438G'
************************ 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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438G'
************************ 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.

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

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.

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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.mail_item where id=438G'
************************ 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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438G'
************************ 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.

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

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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.mail_item where id=438G'
************************ 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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438G'
************************ 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.

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

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.mail_item where id=438G'
************************ 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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438G'
************************ 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.

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.
zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.mail_item where id=438G'
************************ 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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438G'
************************ 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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.mail_item where id=438G'
************************ 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.
zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438G'
************************ 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.

zimbra@zim:~/store/0/3/msg/0$ mysql -e 'select * from mboxgroup3.revision where item_id=438G'
************************ 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.

 
Posted : 02/08/2013 21:39