[SOLVED] Zimbra 7 nach Upgrade: Database Integrity check report

[matthias.ue]

Hi,
wir haben letzte Woche von Zimbra 6 auf 7 aktualisiert. Nun haben wir heute morgen eine Mail vom Server bekommen mit folgendem Inhalt:

Database errors found.
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=****************************
mboxgroup1.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup1.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup1.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup1.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup1.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup10.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup10.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup10.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup10.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup10.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup11.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup11.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup11.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup11.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup11.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup12.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup12.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup12.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup12.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup12.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup13.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup13.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup13.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup13.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup13.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup14.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup14.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup14.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup14.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup14.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup15.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup15.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup15.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup15.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup15.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup16.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup16.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup16.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup16.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup16.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup17.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup17.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup17.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup17.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup17.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup18.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup18.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup18.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup18.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup18.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup19.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup19.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup19.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup19.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup19.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup2.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup2.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup2.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup2.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup2.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup20.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup20.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup20.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup20.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup20.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup21.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup21.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup21.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup21.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup21.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup22.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup22.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup22.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup22.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup22.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup23.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup23.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup23.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup23.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup23.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup24.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup24.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup24.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup24.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup24.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup25.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup25.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup25.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup25.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup25.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup26.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup26.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup26.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup26.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup26.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup27.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup27.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup27.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup27.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup27.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup28.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup28.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup28.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup28.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup28.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup29.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup29.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup29.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup29.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup29.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup3.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup3.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup3.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup3.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup3.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup30.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup30.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup30.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup30.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup30.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup4.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup4.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup4.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup4.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup4.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup5.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup5.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup5.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup5.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup5.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup6.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup6.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup6.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup6.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup6.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup7.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup7.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!

Das geht noch ein Stück so weiter, ich kürze es mal ab wegen der Zeichenbeschränkung hier im Forum.
Ich habe hier im Forum schon ein wenig geschaut und auch einen Beitrag gefunden:

[SOLVED] Database Integrity check report

Die dort benutzten Befehle funktionieren aber nicht. Dort kommt beim Versuch folgende Fehlermeldung:

zimbra.volume
note : The storage engine for the table doesn't support repair

Der Betreiber unseres Servers vermutet das es InnoDB Tabellen sind.

Ich hoffe mir kann jemand helfen.

Vielen Dank

MfG
Matthias

[phoenix]

Please read the Release Notes on what you need to do after an upgrade to ZCS 7 or search the forums for the error message.

[FritzBrause]

Guten Morgen,

das Upgrade auf 7.x ändert die MySQL Version auf 5.1. Entsprechend der Release Notes ist nach dem Upgrade das entsprechende MySQL Konvertierungsscript aufzurufen, um die Datenbanktabellen anzupassen:

"MySQL table upgrade is required after upgrading to ZCS 7.0. MySQL table upgrades are not automatically run during the upgrade to 7.0 based on time that it takes this process to run. There are no known performance impacts of running in production without doing this MySQL table upgrade. Customers can avoid these errors in the zmdbintegrityreport output by executing /opt/zimbra/libexec/scripts/migrate20100913-Mysql51.pl"

P.S. Es wäre hilfreich, das Nutzerprofil entsprechend zu vervollständigen: "zmcontrol -v", damit man auch fundiert antworten kann.

[matthias.ue]

Ich habe die Arbeiten jetzt von unserem Hoster ausführen lassen.
Hier das Ergebnis:

Update-DB-Script zeigt am Ende:
Adding zimbra.mobile_devices to be optimized
..Tue Apr 12 08:51:33 2011: DB: ALTER TABLE zimbra.mailbox ENGINE=InnoDB;: Lock wait timeout exceeded; try restarting transaction

Tue Apr 12 08:51:36 2011: DB: ALTER TABLE zimbra.volume ENGINE=InnoDB;: Lock wait timeout exceeded; try restarting transaction

Altered 31 mailbox groups in 119 seconds

und das Testscript dann:
Database errors found.
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=xxxxxxxxxxxxxxxxxxxxxxxxxxxx
mysql.general_log
Error : You can't use locks with log tables.
mysql.slow_log
Error : You can't use locks with log tables.

Sieht ja schon mal besser aus als Vorher
Ich würde sagen ich lasse das jetzt erst mal so. Der Server läuft und keine Beschwerden bis jetzt

Vielen Dank

MfG
matthias

[FritzBrause]

... die beiden Meldungen kann man ignorieren. Siehe: http://www.zimbra.com/forums/install...s-ose-7-a.html

[juliocs]

Reparar o erro abaixo:

Realizar o upgrade das tabelas:
error: Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!

Servidor atual
mysql.server start
source ~/bin/zmshutil ; zmsetvars

/opt/zimbra/mysql/bin/mysqldump --user=root --password=$mysql_root_password --socket=$mysql_socket --all-databases --single-transaction --flush-logs > /opt/zimbra/backup/dump-atual.sql

Copiar o dump realizado para o servidor backup
scp /opt/zimbra/backup/dump-atual.sql 192.168.254.253:/opt/zimbra/backup/

Realizar o backup da pasta db
cd /opt/zimbra
cp -a db db.back

Parar o serviço do zimbra
su zimbra -c “zmcontrol stop”

Remover a pasta zimbra e todas as mboxgroup
rm -rf /opt/zimbra/db/data/zimbra
rm -rf /opt/zimbra/db/data/ mboxgroup*
Iniciar o banco mysql
mysql.server start

Importar o backup
mysql < /opt/zimbra/backup/dump-backup.sql

Servidor Backup

Instalar a mesma versão do zimbra em outro servidor.
Restaurar o backup no novo servidor.
mysql < /opt/zimbra/backup/dump-atual.sql

Fazer o dump do banco.

/opt/zimbra/mysql/bin/mysqldump --user=root --password=$mysql_root_password --socket=$mysql_socket --all-databases --single-transaction --flush-logs > /opt/zimbra/backup/dump-backup.sql

Copiar o dump realizado do servidor de backup para o servidor atual.
scp /opt/zimbra/backup/dump-backup.sql 172.16.0.2:/opt/zimbra/backup/

Copiar a pasta zimbra do outro servidor.
scp -r /opt/zimbra/db/data/zimbra 172.16.0.2:/opt/zimbra/db/data/
scp -r /opt/zimbra/db/data/mboxgroup1 172.16.0.2:/opt/zimbra/db/data/

Servidor atual

Iniciar o zimbra
su zimbra -c “zmcontrol start”

Listar um mailbox

mysql -e 'SHOW tables FROM mboxgroup3'
mysql -e "check table mboxgroup100.mail_item"
mysql -e "check table zimbra.mailbox"

CHECAR A INTEGRIDADE
/opt/zimbra/libexec/zmdbintegrityreport -v