Notifications
Clear all
Topic starter
02/09/2025 19:58
Zimbra Release 9.0.0.ZEXTRAS.20221203.UBUNTU18.64 UBUNTU18_64 FOSS edition.
I am applying this patch but the check on the mysql database returns the errors below. I managed to solve the errors on "chat." by deleting the related database, but the last 3 (Table 'mysql.gtid_slave_pos' 'mysql.innodb_index_stats' 'mysql.innodb_table_stats' doesn't exist in engine) I was not able to solve them even with Mysql Crash Recovery
Can you help me?
/opt/zimbra/libexec/zmdbintegrityreport -v
Database errors found. /opt/zimbra/common/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/data/tmp/mysql/mysql.sock -A -C -s -u root --password=XXXXXXXX chat.CHANNELV3 Error : Table 'chat.CHANNELV3' doesn't exist in engine chat.CONVERSATION_OPTIONS Error : Table 'chat.CONVERSATION_OPTIONS' doesn't exist in engine chat.EVENTMESSAGE Error : Table 'chat.EVENTMESSAGE' doesn't exist in engine chat.FIREBASE Error : Table 'chat.FIREBASE' doesn't exist in engine chat.GROUP Error : Table 'chat.GROUP' doesn't exist in engine chat.INSTANT_MEETING Error : Table 'chat.INSTANT_MEETING' doesn't exist in engine chat.MESSAGE Error : Table 'chat.MESSAGE' doesn't exist in engine chat.MESSAGE_READ Error : Table 'chat.MESSAGE_READ' doesn't exist in engine chat.OWNER Error : Table 'chat.OWNER' doesn't exist in engine chat.RELATIONSHIP Error : Table 'chat.RELATIONSHIP' doesn't exist in engine chat.SPACE Error : Table 'chat.SPACE' doesn't exist in engine chat.SUBSCRIPTION Error : Table 'chat.SUBSCRIPTION' doesn't exist in engine chat.USER Error : Table 'chat.USER' doesn't exist in engine chat.USERV3 Error : Table 'chat.USERV3' doesn't exist in engine chat.USER_ROOM_JOIN Error : Table 'chat.USER_ROOM_JOIN' doesn't exist in engine chat.VISIBILITY Error : Table 'chat.VISIBILITY' doesn't exist in engine mysql.gtid_slave_pos
Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine mysql.innodb_index_stats Error : Table 'mysql.innodb_index_stats' doesn't exist in engine mysql.innodb_table_stats Error : Table 'mysql.innodb_table_stats' doesn't exist in engine