Results 1 to 3 of 3

Thread: MYSQL database error

Hybrid View

  1. #1
    Join Date
    Oct 2006
    Posts
    100
    Rep Power
    9

    Unhappy MYSQL database error

    A few weeks after my upgrade from 4.5 to 5.0.2 I have started getting the follow message e-mailed to me. Should I do as it says?

    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=XXXXXXXXX.
    mysql.help_category
    error : Table upgrade required. Please do "REPAIR TABLE `help_category`" to fix it!
    mysql.help_keyword
    error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" to fix it!
    mysql.help_topic
    error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to fix it!
    zimbra.config
    error : Table upgrade required. Please do "REPAIR TABLE `config`" to fix it!
    zimbra.mailbox_metadata
    error : Table upgrade required. Please do "REPAIR TABLE `mailbox_metadata`" to fix it!
    zimbra.out_of_office
    error : Table upgrade required. Please do "REPAIR TABLE `out_of_office`" to fix it!
    zimbra.service_status
    error : Table upgrade required. Please do "REPAIR TABLE `service_status`" to fix it!
    zimbra.table_maintenance
    error : Table upgrade required. Please do "REPAIR TABLE `table_maintenance`" to fix it!
    zimbra.volume
    error : Table upgrade required. Please do "REPAIR TABLE `volume`" to fix it!

  2. #2
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    I thought we had this fixed. Go ahead and try it. If it fails, then it's safe to ignore it. It'll likely be fixed in 5.0.3

  3. #3
    Join Date
    Mar 2007
    Location
    Small village in the center of Italy
    Posts
    350
    Rep Power
    8

    Default

    John
    this is a Centos 4 and zcs NE 5.0.13
    i received the analogue email:
    Code:
    
    
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=xxxxxxxxxx
    mysql.columns_priv
    error    : Table upgrade required. Please do "REPAIR TABLE `columns_priv`" to fix it!
    mysql.db
    error    : Table upgrade required. Please do "REPAIR TABLE `db`" to fix it!
    mysql.func
    error    : Table upgrade required. Please do "REPAIR TABLE `func`" to fix it!
    mysql.help_relation
    error    : Table upgrade required. Please do "REPAIR TABLE `help_relation`" to fix it!
    mysql.host
    error    : Table upgrade required. Please do "REPAIR TABLE `host`" to fix it!
    mysql.tables_priv
    error    : Table upgrade required. Please do "REPAIR TABLE `tables_priv`" to fix it!
    mysql.time_zone
    error    : Table upgrade required. Please do "REPAIR TABLE `time_zone`" to fix it!
    mysql.time_zone_leap_second
    error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_leap_second`" to fix it!
    mysql.time_zone_name
    error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" to fix it!
    mysql.time_zone_transition
    error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_transition`" to fix it!
    mysql.time_zone_transition_type
    error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_transition_type`" to fix it!
    zimbra.current_volumes
    error    : Table upgrade required. Please do "REPAIR TABLE `current_volumes`" to fix it!
    
    
    thus it has not been fixed, maybe.
    Should i ignore it or issue what is requested to do?
    thnx
    m.

Similar Threads

  1. Replies: 23
    Last Post: 01-24-2013, 03:44 PM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  3. [SOLVED] Debian Etch 32 / 64: MTA not working
    By xflip in forum Installation
    Replies: 2
    Last Post: 01-18-2008, 04:58 AM
  4. M3 problem with shares
    By titangears in forum Users
    Replies: 4
    Last Post: 01-12-2006, 01:01 PM
  5. Building native libraries on MacOS X
    By ajmas in forum Developers
    Replies: 3
    Last Post: 10-15-2005, 12:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •