Webalizer stats not updating for 1 domain - corrupt mysql?

[froglen]

Can anyone help with this problem?

One particular domain is not getting its webalizer stats updated. The problem has been evident since a server migration 2 months ago. The domlog for the customer site shows hits with today's date so that side of it is okay.

The output suggests that some mysql database tables are bad but I can't work out the database name in order to try and repair it.



# /scripts/fixwebalizer pn102461
removed `/customers/pn102461/tmp/webalizer/webalizer.current'
removed `/customers/pn102461/tmp/webalizer/webalizer.hist'
removed `/customers/pn102461/tmp/webalizer/dns_cache.db'
Log checker loaded ok..
==> cPanel Log Daemon version 22.2
==> Shared RRDTOOL support enabled
==> Starting cpbandwd (bandwidth monitoring for IMAP/POP)
cpbandwd is already running.
Processing pn102461...
Run Logs domain: puntarivieraresort.com BW Limit: 5242880000 Domains: []
Processing exim stats for pn102461....(internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::db do failed: Table 'sends' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1088.
at /usr/local/cpanel/cpanellogd line 1088
eval {...} called at /usr/local/cpanel/cpanellogd line 1085
main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


(internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::db do failed: Table 'smtp' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1089.
at /usr/local/cpanel/cpanellogd line 1089
eval {...} called at /usr/local/cpanel/cpanellogd line 1085
main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


(internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::st execute failed: Table 'smtp' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1096.
at /usr/local/cpanel/cpanellogd line 1096
eval {...} called at /usr/local/cpanel/cpanellogd line 1085
main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


(internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/cpanel/cpanellogd line 1097.
at /usr/local/cpanel/cpanellogd line 1097
eval {...} called at /usr/local/cpanel/cpanellogd line 1085
main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


(internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::db do failed: Table 'smtp' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1100.
at /usr/local/cpanel/cpanellogd line 1100
eval {...} called at /usr/local/cpanel/cpanellogd line 1085
main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


(internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::db do failed: Table 'smtp' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1101.
at /usr/local/cpanel/cpanellogd line 1101
eval {...} called at /usr/local/cpanel/cpanellogd line 1085
main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


(internal warning while parsing ) Wed Sep 12 07:49:40 2007 [27473] warn: DBD::mysql::db do failed: Table 'sends' is marked as crashed and should be repaired at /usr/local/cpanel/cpanellogd line 1103.
at /usr/local/cpanel/cpanellogd line 1103
eval {...} called at /usr/local/cpanel/cpanellogd line 1085
main::geteximstats('pn102461') called at /usr/local/cpanel/cpanellogd line 1631
main::parseeximlog('pn102461', 1073741824) called at /usr/local/cpanel/cpanellogd line 586
main::updatebw('pn102461', '/customers/pn102461', 32474, 'DOMAINNAME.com', 5242880000, 'ARRAY(0x9f78a24)') called at /usr/local/cpanel/cpanellogd line 205


[an error occurred while processing this directive][an error occurred while processing this directive][an error occurred while processing this directive][an error occurred while processing this directive][an error occurred while processing this directive][an error occurred while processing this directive][an error occurred while processing this directive]...Done
WEBLANG english
Archive Status: 0
About to fork for pn102461 [ALL DOMAINS: ,DOMAINNAME.com]
Complete

 

[bubby]

repair the table in exim stats

mysql eximstats
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1972373 to server version: 4.1.22-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show tables;
+---------------------+
| Tables_in_eximstats |
+---------------------+
| sends |
| smtp |
+---------------------+
2 rows in set (0.00 sec)

mysql> repair table sends;
+-----------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------------+--------+----------+----------+
| eximstats.sends | repair | status | OK |
+-----------------+--------+----------+----------+
1 row in set (0.01 sec)

mysql> repair tables smtp;
+----------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------------+--------+----------+----------+
| eximstats.smtp | repair | status | OK |
+----------------+--------+----------+----------+
1 row in set (0.05 sec)