Results 1 to 5 of 5

Thread: mysql mta table crashes often

  1. #1
    kabal is offline Intermediate Member
    Join Date
    Oct 2008
    Posts
    15
    Rep Power
    6

    Unhappy mysql mta table crashes often

    Hello all,

    I have 3 zimbra 4.5 servers, one running mailbox services and two running mta.
    Regularly, whenever I run this command:
    zmcontrol -s <username>
    I get the follwing error:
    /opt/zimbra/bin/zmmsgtrace sql execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed

    I usually have to run:
    logmysql
    use zimbra_logger
    repair table mta

    This resolves it.
    My issue is, must be a recurring issue? Is there a way of purging old entire in the mta table to prevent it from crashing so often, or can I specify from that it deletes rows older than a particular age?

    Thanx

  2. #2
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Welcome to the forums

    Why do you believe it is the amount/age of data that is causing the problem ? I would be more inclined to believe that either MySQL has crashed, or the server has been restarted (whether manually or crash) while MySQL is still running. Have you checked the server for any other issues ?

  3. #3
    kabal is offline Intermediate Member
    Join Date
    Oct 2008
    Posts
    15
    Rep Power
    6

    Default

    Thanx for the response.

    If the server is shutdown while MySQL is running, would it cause tables to crash?
    Also, my for the last few weeks, my admin console has been so slow to come up.
    I suspect it's related to java because even the advanced version doesn't open.
    Is there any log I can check that can point to why the admin console takes about 10 minutes to come up?

    Thanx in anticipation

  4. #4
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Does this vary if you connect to the console from a different machine ? What happens if you open a browser on the actual server and connect to the admin console ? What is the spec of your server ? How much free memory does it have ? What is the load on the server ?

  5. #5
    kabal is offline Intermediate Member
    Join Date
    Oct 2008
    Posts
    15
    Rep Power
    6

    Default

    It's slow on all my workstations.
    My ldap server has no gui on it.
    I have even tried it on linux workstations, still no luck.
    Even tried different browsers, only IE seems to open it eventually.
    My server has 16GB ram B-)
    And load average is not high, enuff RAM to play with.

    Are there other logs I can check

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Daily mail report always reports "No messages found"
    By McPringle in forum Installation
    Replies: 42
    Last Post: 06-13-2011, 08:57 AM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  3. zimbra daily reports problem - mta table is empty
    By sine in forum Administrators
    Replies: 4
    Last Post: 09-25-2008, 11:32 PM
  4. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  5. Replies: 7
    Last Post: 10-05-2007, 03:14 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
  •