Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: status not updating properly

  1. #11
    lithorus is offline Loyal Member
    Join Date
    Jul 2008
    Location
    openhagen
    Posts
    79
    Rep Power
    7

    Default

    We were having the excact same issue but found out that the cron daemon wasn't running. Backups were not done either

  2. #12
    hodd is offline Active Member
    Join Date
    Jun 2008
    Posts
    45
    Rep Power
    7

    Default

    I did some reading on Logger - Zimbra :: Wiki
    And took the advice of checking the mysql tables.

    Here's the output:
    Code:
    mysql> check table raw_logs;
    +------------------------+-------+----------+-------------------------------------------------------------------------------+
    | Table                  | Op    | Msg_type | Msg_text                                                                      |
    +------------------------+-------+----------+-------------------------------------------------------------------------------+
    | zimbra_logger.raw_logs | check | warning  | Table is marked as crashed                                                    |
    | zimbra_logger.raw_logs | check | warning  | 3 clients are using or haven't closed the table properly                      |
    | zimbra_logger.raw_logs | check | error    | Can't read key from filepos: 3407872                                          |
    | zimbra_logger.raw_logs | check | Error    | Incorrect key file for table './zimbra_logger/raw_logs.MYI'; try to repair it |
    | zimbra_logger.raw_logs | check | error    | Corrupt                                                                       |
    +------------------------+-------+----------+-------------------------------------------------------------------------------+
    5 rows in set (0.36 sec)

    I then did a

    Code:
    repair table raw_logs;
    And it's been running that for almost 30 minutes now...was that a bad idea?
    OS : Ubuntu 6.02 LTS
    ZCS : zcs-NETWORK-6.0.8_GA_2661.UBUNTU6

  3. #13
    hodd is offline Active Member
    Join Date
    Jun 2008
    Posts
    45
    Rep Power
    7

    Default

    So after 2 hours I got this

    Code:
    mysql> repair table raw_logs;
    
    +------------------------+--------+----------+--------------------------------------------------+
    | Table                  | Op     | Msg_type | Msg_text                                         |
    +------------------------+--------+----------+--------------------------------------------------+
    | zimbra_logger.raw_logs | repair | warning  | Number of rows changed from 21425438 to 18347072 |
    | zimbra_logger.raw_logs | repair | status   | OK                                               |
    +------------------------+--------+----------+--------------------------------------------------+
    2 rows in set (1 hour 58 min 54.17 sec)
    OS : Ubuntu 6.02 LTS
    ZCS : zcs-NETWORK-6.0.8_GA_2661.UBUNTU6

  4. #14
    hodd is offline Active Member
    Join Date
    Jun 2008
    Posts
    45
    Rep Power
    7

    Default

    I thought maybe upgrading from 5.0.13 to 5.0.15 might fix up my issues, but from the output below it looks like I have a deeper problem. Has anyone else experienced the logger errors I'm having and the association to no stats being displayed?

    Code:
    Do you want to verify logger database integrity? [Y]
    Verifying integrity of logger database.  This may take a while.
    mysqld is alive
    Generating report
    Logger Database errors found.
    /opt/zimbra/logger/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.logger.cnf -S /opt/zimbra/logger/db/mysql.sock -A -C -s -u root --password=.***omited** --auto-repair
    zimbra_logger.mta
     warning  : 2 clients are using or haven't closed the table properly
     zimbra_logger.processing_history
     warning  : 3 clients are using or haven't closed the table properly
     zimbra_logger.service_status
     warning  : 6 clients are using or haven't closed the table properly
    OS : Ubuntu 6.02 LTS
    ZCS : zcs-NETWORK-6.0.8_GA_2661.UBUNTU6

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

    Default

    Code:
    su - zimbra
    logmysql
    use zimbra_logger;
    repair table mta;
    repair table processing_history;
    repair table service_status;
    exit

  6. #16
    hodd is offline Active Member
    Join Date
    Jun 2008
    Posts
    45
    Rep Power
    7

    Default

    uxbod thanks for the quick reply, I performed those commands on the database, and restarted the services. I still however do not see any stats on the Mesage Count, Message Volume, or AS/AV tabs. I've read else where that it does take some time for them to refresh.
    OS : Ubuntu 6.02 LTS
    ZCS : zcs-NETWORK-6.0.8_GA_2661.UBUNTU6

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

    Default

    Yep it can take 24 hours.

  8. #18
    lithorus is offline Loyal Member
    Join Date
    Jul 2008
    Location
    openhagen
    Posts
    79
    Rep Power
    7

    Default

    Quote Originally Posted by hodd View Post
    uxbod thanks for the quick reply, I performed those commands on the database, and restarted the services. I still however do not see any stats on the Mesage Count, Message Volume, or AS/AV tabs. I've read else where that it does take some time for them to refresh.
    Did you check if cron was running on the server? As said earlier we had the same issue when cron didn't run on the server. All stats are basically updated through a cron script.

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] mysql.server not running
    By king0770 in forum Administrators
    Replies: 23
    Last Post: 07-25-2009, 03:07 PM
  2. Error after installation
    By robsontuxlinux in forum Installation
    Replies: 13
    Last Post: 09-11-2008, 09:48 PM
  3. zmmailboxdctl is stopped frequently..
    By tamilnandhu in forum Installation
    Replies: 13
    Last Post: 04-12-2008, 08:59 AM
  4. postfix build error while building Zimbra source
    By anuradha_mihsra in forum Developers
    Replies: 6
    Last Post: 07-19-2007, 10:22 AM
  5. Trouble sending mail from Outlook
    By czaveri in forum Users
    Replies: 15
    Last Post: 07-24-2006, 11:01 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
  •