zmlogger don't work

[cg48]

Hello,
since we have migrate on multiple domain (two domain), there is no log (number og messages , etc ....) on the administrive console !!!

every minutes, we have this error in the log :

[ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/raw_logs' is marked as crashed and should be repaired

how can I repaired this table ?
any idea.
Thanks !

[Klug]

C'est une table mysql, il faut donc utiliser les outils mysql pour la "réparer", myisamchk devrait s'en sortir.
La migration des différents domaines sur le serveur n'a rien à voir avec l'erreur (qui provient plutôt, je pense d'un reboot violent ou plantage mysql du même genre).

It's a mysql table, you should use the mysql tools to fix it : myisamchk should be the correct one.
I think the domains migration has nothing to do with the issue (more likely related to mysql crash or unattended reboot).

[cg48]

Ok thank you
I can't repair the tables, so I do a zmloggerinit according to this post :

Daily mail report always reports "No messages found"


All work fine now. But I have a little problem.... Now in administrative console when I want to go to "Server statistic " I got this message :

Message: Csfe service error
Error code: service.FAILURE
Method: ZmCsfeCommand.invoke
Details:system failure: getting database logger connection

Perhaps due to the zmloggerinit ?

All my process is running :
[zimbra@-----]$ zmcontrol status
Host -------
antispam Running
antivirus Running
ldap Running
logger Running
mailbox Running
mta Running
snmp Running
spell Running

Any idea ?
Thanks !