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.