Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Statistics Graph Generation Failing

  1. #1
    3RiversTechAdmin's Avatar
    3RiversTechAdmin is offline Special Member
    Join Date
    Oct 2006
    Posts
    100
    Rep Power
    8

    Default Statistics Graph Generation Failing

    Hey Everyone,

    I have upgraded from 5.0.2 to 5.0.6 and most everything went splendid; however, now the graphs are not updating in the admin console.

    I ran: sh -x /opt/zimbra/libexec/zmgengraphs
    which produced:
    + use strict
    /opt/zimbra/libexec/zmgengraphs: line 19: use: command not found
    + use lib /opt/zimbra/zimbramon/lib
    /opt/zimbra/libexec/zmgengraphs: line 20: use: command not found
    + use Zimbra::Util::Common
    /opt/zimbra/libexec/zmgengraphs: line 21: use: command not found
    + '$'
    /opt/zimbra/libexec/zmgengraphs: line 22: $: command not found
    + =1
    /opt/zimbra/libexec/zmgengraphs: line 22: =1: command not found
    /opt/zimbra/libexec/zmgengraphs: line 24: syntax error near unexpected token `0'
    /opt/zimbra/libexec/zmgengraphs: line 24: `exit(0) unless (-f '/opt/zimbra/conf/localconfig.xml');'
    OS: Ubuntu 6.06 LTS Server - Linux 2.6.15-51-server #1 SMP GNU/Linux

    Zm: Version 5.0.6_GA_2313.UBUNTU6.FOSS

    Hardware:

    Pentium 4 3800 MHz
    4 GB DDRII 533
    [x2 - RAID 1] 250 GB SATA
    Gigabit Ethernet

    Hey ideas would be great! Thanks.

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

    Default

    Did you try running it as the Zimbra user?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    3RiversTechAdmin's Avatar
    3RiversTechAdmin is offline Special Member
    Join Date
    Oct 2006
    Posts
    100
    Rep Power
    8

    Default

    Yes, that output was generated running as the zimbra user

    sudo su zimbra
    sh -x /opt/zimbra/libexec/zmgengraphs

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

    Default

    Try running 'su - zimbra' then the command as:
    Code:
    /opt/zimbra/libexec/zmgengraphs
    Does that generate the output?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    3RiversTechAdmin's Avatar
    3RiversTechAdmin is offline Special Member
    Join Date
    Oct 2006
    Posts
    100
    Rep Power
    8

    Default

    The command executed but failed to update the graphs within the administrator interface. It presented the following output

    Generating hour graph for mta on myhost.mydomain.com
    Generating hour graph for mta on myhost.mydomain.com
    Generating day graph for mta on myhost.mydomain.com
    Generating day graph for mta on myhost.mydomain.com
    Generating month graph for mta on myhost.mydomain.com
    Generating month graph for mta on myhost.mydomain.com
    Generating year graph for mta on myhost.mydomain.com
    Generating year graph for mta on myhost.mydomain.com
    Generating hour graph for mta on localhost
    Generating hour graph for mta on localhost
    Generating day graph for mta on localhost
    Generating day graph for mta on localhost
    Generating month graph for mta on localhost
    Generating month graph for mta on localhost
    Generating year graph for mta on localhost
    Generating year graph for mta on localhost
    Generating hour graph for mta on ALL
    Generating hour graph for mta on ALL
    Generating day graph for mta on ALL
    Generating day graph for mta on ALL
    Generating month graph for mta on ALL
    Generating month graph for mta on ALL
    Generating year graph for mta on ALL
    Generating year graph for mta on ALL
    Generating hour graph for amavis on myhost.mydomain.com
    Generating day graph for amavis on myhost.mydomain.com
    Generating month graph for amavis on myhost.mydomain.com
    Generating year graph for amavis on myhost.mydomain.com
    Generating hour graph for amavis on localhost
    Generating day graph for amavis on localhost
    Generating month graph for amavis on localhost
    Generating year graph for amavis on localhost
    Generating hour graph for amavis on ALL
    Generating day graph for amavis on ALL
    Generating month graph for amavis on ALL
    Generating year graph for amavis on ALL
    DBD::mysql::st execute failed: Table './zimbra_logger/disk_aggregate' is marked as crashed and should be repaired at /opt/zimbra/libexec/zmgengraphs line 342.
    Error executing select distinct(host) from disk_aggregate with
    Table './zimbra_logger/disk_aggregate' is marked as crashed and should be repaired
    Table './zimbra_logger/disk_aggregate' is marked as crashed and should be repaired at /opt/zimbra/libexec/zmgengraphs line 343.

    Can't call method "fetchall_arrayref" on an undefined value at /opt/zimbra/libexec/zmgengraphs line 406.

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

    Default

    Logger - Zimbra :: Wiki

    Please update your profile with your Zimbra version & release details: zmcontrol -v
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  7. #7
    3RiversTechAdmin's Avatar
    3RiversTechAdmin is offline Special Member
    Join Date
    Oct 2006
    Posts
    100
    Rep Power
    8

    Default

    I have update my profile, I did post my info at the start of this thread?...

    I attempted to follow the directions on the wiki which worked for a couple of the databases, however they did not for the one casuing the trouble, here is the dialog:

    mysql> REPAIR TABLE `disk_aggregate`;
    +------------------------------+--------+----------+------------------------------------------------------------------------------------+
    | Table | Op | Msg_type | Msg_text |
    +------------------------------+--------+----------+------------------------------------------------------------------------------------+
    | zimbra_logger.disk_aggregate | repair | Error | Table './zimbra_logger/disk_aggregate' is marked as crashed and should be repaired |
    | zimbra_logger.disk_aggregate | repair | Error | Table 'disk_aggregate' is marked as crashed and should be repaired |
    | zimbra_logger.disk_aggregate | repair | status | Table is already up to date |
    +------------------------------+--------+----------+------------------------------------------------------------------------------------+
    3 rows in set (0.01 sec)

    mysql> CHECK TABLE `disk_aggregate`;
    +------------------------------+-------+----------+------------------------------------------------------------------------------+
    | Table | Op | Msg_type | Msg_text |
    +------------------------------+-------+----------+------------------------------------------------------------------------------+
    | zimbra_logger.disk_aggregate | check | error | Table upgrade required. Please do "REPAIR TABLE `disk_aggregate`" to fix it! |
    +------------------------------+-------+----------+------------------------------------------------------------------------------+
    1 row in set (0.00 sec)
    Any ideas ?

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

    Default

    Quote Originally Posted by 3RiversTechAdmin View Post
    Any ideas ?
    Yes, repair the tables. Follow the instructions for repairing corrupt tables in the link I've already given you.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  9. #9
    3RiversTechAdmin's Avatar
    3RiversTechAdmin is offline Special Member
    Join Date
    Oct 2006
    Posts
    100
    Rep Power
    8

    Default

    I'm confused, perhaps we are not understanding one another, I tried to follow those directions and as I posted above while the repair command works for the other tables, after running it on the disk_aggregate table, mysql still reports it needs to be repaired.

    [QUOTE]
    mysql> REPAIR TABLE `disk_aggregate`;
    | zimbra_logger.disk_aggregate | repair | Error | Table './zimbra_logger/disk_aggregate' is marked as crashed and should be repaired |
    | zimbra_logger.disk_aggregate | repair | Error | Table 'disk_aggregate' is marked as crashed and should be repaired |
    | zimbra_logger.disk_aggregate | repair | status | Table is already up to date |
    ...
    mysql> CHECK TABLE `disk_aggregate`;
    ....
    Please do "REPAIR TABLE `disk_aggregate`" to fix it! |
    Last edited by 3RiversTechAdmin; 06-09-2008 at 09:31 AM. Reason: typo

  10. #10
    iain is offline Loyal Member
    Join Date
    Feb 2006
    Location
    Manchester, UK
    Posts
    88
    Rep Power
    9

    Default

    Hi 3Rivers,

    Check out this wiki page:
    Repair Logger Data Corruption - Zimbra :: Wiki

    It gives an extra step to try if the standard repair table doesn't work.

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Stats problems!!
    By mmike in forum Administrators
    Replies: 7
    Last Post: 03-25-2008, 09:33 PM
  2. Error in my /tmp/gengraphs.out file
    By Xao in forum Installation
    Replies: 9
    Last Post: 01-04-2008, 09:32 PM
  3. centos 5 zimbra 4.5.6 no statistics
    By rutman286 in forum Installation
    Replies: 9
    Last Post: 08-14-2007, 09:30 AM
  4. Stats don't update
    By Doug_M in forum Administrators
    Replies: 33
    Last Post: 05-05-2007, 08:17 PM
  5. Possible bug in disk statistics page generation
    By gentoo_matt in forum Developers
    Replies: 4
    Last Post: 05-08-2006, 02:41 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
  •