Results 1 to 3 of 3

Thread: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it

  1. #1
    Join Date
    Nov 2007
    Posts
    41
    Rep Power
    8

    Default Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it

    [zimbra@mail ~]$ tail /opt/zimbra/log/logger_mysql_error.log
    081023 7:01:33 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it
    081023 7:01:33 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it
    081023 7:01:33 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it
    081023 7:01:33 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it
    081023 7:10:06 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it
    081023 7:10:06 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it
    081023 7:10:06 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it
    081023 7:10:06 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it
    081023 7:10:06 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it
    081023 7:10:06 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it

    So - this install has been cursed for over a year. I've yet to get the logger working properly. I started at 4.5.6 and have now upgraded all teh way to 5.0.10. Repair table has been run numerous times on this table with no luck. I've followed the wiki and at least 10 other posts compaining about the logger.

    Every check i've run across is now working OK - except for this error i receive. Does the error above indicate something specific? (perhaps i should delete from x on all tables? do i need to keep data in certain tables?)

    Also - i need to repair the zimbra_logger tables such as raw_logs from time to time as they turn corrupt every week or so.

    -----

    If we can't do a specific fix is there a way to basically reinstall the entire logging piece? If not, perhaps one should be added due to teh number of difficulties users encounter.

  2. #2
    Join Date
    Nov 2007
    Posts
    41
    Rep Power
    8

    Default

    Typical! As soon as i post it starts working....

    I'm still seeing this error, however. Should i alltempt to clean out the tables to bring the key restraints back in line - or just leave it?

  3. #3
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    Code:
    su - zimbra
    logmysql
    use zimbra_logger;
    check table mta;
    repair table mta;
    check table mta;
    if this is happening all the time you need to check all your logfiles for any error messages. Does dmesg or /var/log/messages show anything at all ?

Similar Threads

  1. bayes db..
    By osiris in forum Administrators
    Replies: 9
    Last Post: 06-15-2011, 12:14 PM
  2. speed up the net
    By mcesari in forum Administrators
    Replies: 10
    Last Post: 04-25-2008, 12:24 PM
  3. centos 5 zimbra 4.5.6 no statistics
    By rutman286 in forum Installation
    Replies: 9
    Last Post: 08-14-2007, 10:30 AM
  4. Traslation SVN tree status
    By meikka in forum I18N/L10N - Translations
    Replies: 7
    Last Post: 02-13-2007, 11:13 AM
  5. M3 problem with shares
    By titangears in forum Users
    Replies: 4
    Last Post: 01-12-2006, 01:01 PM

Posting Permissions

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