problem with zmdailyreport

[Achim.Theobald]

What say me this errors?
Since upgrade form 4.0.3 to 4.0.4

Output from command /opt/zimbra/libexec/zmdailyreport | /opt/zimbra/postfix/sbin/sendmail efserver@sc-kempf.lokal ..

DBD::mysql::st execute failed: Can't open file: 'mta.MYI' (errno: 145) at /opt/zimbra/libexec/zmdailyreport line 511.
/opt/zimbra/libexec/zmdailyreport sql execute failed: Can't open file: 'mta.MYI' (errno: 145)
DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /opt/zimbra/libexec/zmdailyreport line 515.
DBD::mysql::st execute failed: Can't open file: 'mta.MYI' (errno: 145) at /opt/zimbra/libexec/zmdailyreport line 511.
/opt/zimbra/libexec/zmdailyreport sql execute failed: Can't open file: 'mta.MYI' (errno: 145)
DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /opt/zimbra/libexec/zmdailyreport line 515.
DBD::mysql::st execute failed: Can't open file: 'mta.MYI' (errno: 145) at /opt/zimbra/libexec/zmdailyreport line 511.
/opt/zimbra/libexec/zmdailyreport sql execute failed: Can't open file: 'mta.MYI' (errno: 145)
DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /opt/zimbra/libexec/zmdailyreport line 515.
DBD::mysql::st execute failed: Can't open file: 'mta.MYI' (errno: 145) at /opt/zimbra/libexec/zmdailyreport line 511.
/opt/zimbra/libexec/zmdailyreport sql execute failed: Can't open file: 'mta.MYI' (errno: 145)
DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /opt/zimbra/libexec/zmdailyreport line 515.

[jholder]

This is a stupid question, but is the logger running?

[Achim.Theobald]

Originally Posted by wannabetenor

This is a stupid question, but is the logger running?

Yes, but it look like some errors in the logger SQL files. The only solution i have found was:

host: su - zimbra
host:~ zimbra$ ps -auxw | grep my.logger | grep -v grep | awk '{print $2}' | xargs kill
host:~ zimbra$ rm -rf logger/db
host:~ zimbra$ libexec/zmloggerinit

Cu