Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 47

Thread: [SOLVED] Server statistics does not working

  1. #21
    sberkman is offline Member
    Join Date
    Apr 2008
    Posts
    11
    Rep Power
    7

    Default

    I have the same issue as everyone else here. Everything in this thread seems fine, and the only thing in the zmstat.out file is the "Warning: Not possible to monitor process stats" error over and over.

    I am missing the same files everyone else is missing.

    logmysql connects with no problem and I have also manually verified the MySQL password. All the tables seem clean.

    I have tried restarting the zmlogger and zmstats services and I just get a new instance of the above warning message. I can't find any other logging related errors.

    Please let me know if I can post any additional output or data.

    Thanks,

    -Scott

  2. #22
    AdamG is offline Member
    Join Date
    Nov 2007
    Location
    Seattle, WA
    Posts
    11
    Rep Power
    7

    Default

    I have a similar issue with the stats not appearing in the Admin Console. I looked in /tmp/logprocess.out and found this error (repeated many times), please advise:
    Code:
    Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed at /opt/zimbra/libexec/zmlogprocess line 1133.

  3. #23
    boblin is offline Senior Member
    Join Date
    Jun 2007
    Location
    Czech Republic, Prague
    Posts
    66
    Rep Power
    8

    Default

    yes, maybe this is related to our problem:

    Code:
    # cat /tmp/logprocess.out
    DBD::mysql::st execute failed: Table './zimbra_logger/raw_logs' is marked as crashed and should be repaired at /opt/zimbra/libexec/zmlogprocess line 1132.
    Can't call method "fetchall_arrayref" on an undefined value at /opt/zimbra/libexec/zmlogprocess line 768.
    Pruning service/server entries older then 2008-04-17 06:50:01
    server maps to server.example.com
    Processing mta entries from 1947272
    Error executing select distinct(postfix_qid) from raw_logs where postfix_qid is not null and app like 'postfix%' and id > '1947272' with
    Table './zimbra_logger/raw_logs' is marked as crashed and should be repaired
    Table './zimbra_logger/raw_logs' is marked as crashed and should be repaired at /opt/zimbra/libexec/zmlogprocess line 1133.

  4. #24
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,581
    Rep Power
    57

    Default

    Have any of you tried the following:

    Code:
    su - zimbra
    /opt/zimbra/libexec/zmlogprocess
    /opt/zimbra/libexec/zmgengraphs
    Are there any errors in /opt/zimbra/logger/db/data/<hostname>.err? You could also try some of the tips in the Troubleshooting Section of the wiki and see if the tables are OK.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #25
    boblin is offline Senior Member
    Join Date
    Jun 2007
    Location
    Czech Republic, Prague
    Posts
    66
    Rep Power
    8

    Default

    Quote Originally Posted by phoenix View Post
    Have any of you tried the following:

    Code:
    su - zimbra
    /opt/zimbra/libexec/zmlogprocess
    /opt/zimbra/libexec/zmgengraphs
    Are there any errors in /opt/zimbra/logger/db/data/<hostname>.err? You could also try some of the tips in the Troubleshooting Section of the wiki and see if the tables are OK.

    Bingo! I found in .err file this:
    Code:
    /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/raw_logs' is marked as crashed and should be repaired

    -> Repairing the tables in the logger database

    Code:
    $ logmysql zimbra_logger
    
    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  | 1 client is using or hasn't closed the table properly |
    | zimbra_logger.raw_logs | check | error    | Record at pos: 11932 is not remove-marked             |
    | zimbra_logger.raw_logs | check | error    | record delete-link-chain corrupted                    |
    | zimbra_logger.raw_logs | check | error    | Corrupt                                               |
    +------------------------+-------+----------+-------------------------------------------------------+
    5 rows in set (0.02 sec)
    
    mysql> repair table raw_logs;
    +------------------------+--------+----------+---------------------------------------------+
    | Table                  | Op     | Msg_type | Msg_text                                    |
    +------------------------+--------+----------+---------------------------------------------+
    | zimbra_logger.raw_logs | repair | info     | Delete link points outside datafile at 4080 |
    | zimbra_logger.raw_logs | repair | warning  | Number of rows changed from 215 to 263      |
    | zimbra_logger.raw_logs | repair | status   | OK                                          |
    +------------------------+--------+----------+---------------------------------------------+
    3 rows in set (0.07 sec)
    
    mysql> check table raw_logs;
    +------------------------+-------+----------+----------+
    | Table                  | Op    | Msg_type | Msg_text |
    +------------------------+-------+----------+----------+
    | zimbra_logger.raw_logs | check | status   | OK       |
    +------------------------+-------+----------+----------+
    1 row in set (0.00 sec)
    But when i run zmlogprocess manualy i get new errors:
    Code:
    $ /opt/zimbra/libexec/zmlogprocess
    Pruning service/server entries older then 2008-04-17 09:24:20
    server maps to server.example.com
    Processing mta entries from 1947272
    Found 16 messages
    DBD::mysql::st execute failed: Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it at /opt/zimbra/libexec/zmlogprocess line 1132.
    Error executing insert into mta (arrive_time, leave_time, host, msgid, sender, recipient, amavis_pid, bytes, from_host, from_IP, to_host, to_IP, qid, status, statusmsg) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) with 2008-03-25 10:55:02 2008-03-25 10:55:03 dog 20080325095457.063445CAE4@server.example.com nagios@ucetnictvi-on-line.cz archive@ucetnictvi-on-line.cz  1110 localhost 127.0.0.1 server.example.com 82.113.47.156]:7025 C014A5C097 sent (250 2.1.5 OK)
    Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it
    Incorrect key file for table './zimbra_logger/mta.MYI'; try to repair it at /opt/zimbra/libexec/zmlogprocess line 1133.

  6. #26
    boblin is offline Senior Member
    Join Date
    Jun 2007
    Location
    Czech Republic, Prague
    Posts
    66
    Rep Power
    8

    Default

    I found other tables also corrupted, so i did recover them.
    Zmlogprocess and zmgengraphs doesn't generate errors now, so i think it helps.

    Now i will wait for graphs

  7. #27
    Priyantha Bleeker is offline Active Member
    Join Date
    Oct 2007
    Posts
    31
    Rep Power
    7

    Default

    Quote Originally Posted by boblin View Post
    I found other tables also corrupted, so i did recover them.
    Zmlogprocess and zmgengraphs doesn't generate errors now, so i think it helps.

    Now i will wait for graphs
    Which tables did you found corrupt ?
    Can you give us/me the commands ?
    Thanks.

  8. #28
    boblin is offline Senior Member
    Join Date
    Jun 2007
    Location
    Czech Republic, Prague
    Posts
    66
    Rep Power
    8

    Default

    from wiki:

    Code:
    $ logmysql zimbra_logger
    
    mysql> show tables;
    +-------------------------+
    | Tables_in_zimbra_logger |
    +-------------------------+
    | amavis                  |
    | amavis_aggregate        |
    | config                  |
    | disk_aggregate          |
    | disk_status             |
    | mta                     |
    | mta_aggregate           |
    | processing_history      |
    | raw_logs                |
    | service_status          |
    +-------------------------+
    So i check all the tables, one by one like in my previous post, and repair corrupted table.

  9. #29
    Priyantha Bleeker is offline Active Member
    Join Date
    Oct 2007
    Posts
    31
    Rep Power
    7

    Default

    Quote Originally Posted by boblin View Post
    from wiki:

    Code:
    $ logmysql zimbra_logger
    
    mysql> show tables;
    +-------------------------+
    | Tables_in_zimbra_logger |
    +-------------------------+
    | amavis                  |
    | amavis_aggregate        |
    | config                  |
    | disk_aggregate          |
    | disk_status             |
    | mta                     |
    | mta_aggregate           |
    | processing_history      |
    | raw_logs                |
    | service_status          |
    +-------------------------+
    So i check all the tables, one by one like in my previous post, and repair corrupted table.
    Ah great Thanks, I will do the same then

  10. #30
    boblin is offline Senior Member
    Join Date
    Jun 2007
    Location
    Czech Republic, Prague
    Posts
    66
    Rep Power
    8

    Default

    Stats are working again!

    Thank you!
    Attached Images Attached Images

Page 3 of 5 FirstFirst 12345 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. server statistics for disk usage
    By melody in forum Administrators
    Replies: 2
    Last Post: 03-27-2008, 06:28 AM
  2. XMPP server to server not working
    By Spliff in forum Administrators
    Replies: 3
    Last Post: 01-31-2008, 10:48 AM
  3. [Network Edition Trial] OS X Installation
    By dmg in forum Installation
    Replies: 4
    Last Post: 02-07-2007, 05:25 PM
  4. Intallation on FC5
    By rsharpe in forum Installation
    Replies: 24
    Last Post: 06-13-2006, 05:15 AM
  5. Send mail to test server, not working
    By eXtremeSG in forum Administrators
    Replies: 10
    Last Post: 02-16-2006, 08:40 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
  •