Statistics Graph Generation Failing

[3RiversTechAdmin]

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.

[phoenix]

Did you try running it as the Zimbra user?

[3RiversTechAdmin]

Yes, that output was generated running as the zimbra user

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

[phoenix]

Try running 'su - zimbra' then the command as:

/opt/zimbra/libexec/zmgengraphs

Does that generate the output?

[3RiversTechAdmin]

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.

[phoenix]

Logger - Zimbra :: Wiki

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

[3RiversTechAdmin]

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 ?

[phoenix]

Originally Posted by 3RiversTechAdmin

Any ideas ?

Yes, repair the tables. Follow the instructions for repairing corrupt tables in the link I've already given you.

[3RiversTechAdmin]

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! |

[iain]

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.