Missing Stats Message Count / Message Volume

[rernst]

I have been battling this problem for a long time. I had it resolved after deleting the db data folder and then reinstalling - or so I think - but really, something is seriously not working there.

I have spent weeks looking into this without much success except a lucky hit once.

[rernst]

Finally got it to work again yesterday by running zmlogprocess and zmgengraphs manually. The reason it was failing was that the processes did not have permissions to update the /tmp files specified for output. (>)

However, after midnight or so this stopped working again.

This is Opensuse and I changed the various files shown in other posts to cause the syslog restart to work properly.

Maybe it is related to that, not sure.

[rernst]

Infuriating. After midnight the statistics show up again. I have no idea why. Some cron job, no doubt.

[multicast]

Any help here would be great...

[swuste]

Did you look at:

Repair Logger Data Corruption - Zimbra :: Wiki

In my setup I got the following error in /tmp/logprocess.out:

Table './zimbra_logger/raw_logs' is marked as crashed and should be repaired

The wiki solution seems to work for me :-)

[multicast]

I gave the article a shot and this is the output after running the commands:

mysql> REPAIR TABLE raw_logs;
+------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------------------+--------+----------+----------+
| zimbra_logger.raw_logs | repair | status | OK |
+------------------------+--------+----------+----------+
1 row in set (24.27 sec)

mysql> REPAIR TABLE raw_logs USE_FRM;
+------------------------+--------+----------+------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------------+--------+----------+------------------------------------------+
| zimbra_logger.raw_logs | repair | warning | Number of rows changed from 0 to 1795910 |
| zimbra_logger.raw_logs | repair | status | OK |
+------------------------+--------+----------+------------------------------------------+
2 rows in set (23.90 sec)