[SOLVED] another problem when i try to trace a message

[kline]

zmmsgtrace -s user@cora.com -r officee@ddsds.com
i got this

/opt/zimbra/bin/zmmsgtrace sql execute failed: Table './zimbra_logger/mta' is marked as crashed and should be repaired

[veronica]

Refer to Repair Logger Data Corruption - Zimbra :: Wiki

[kline]

check table mta;

i got this

+-------------------+-------+----------+--------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------+-------+----------+--------------------------------------------------------+
| zimbra_logger.mta | check | warning | Table is marked as crashed and last repair failed |
| zimbra_logger.mta | check | warning | 1 client is using or hasn't closed the table properly |
| zimbra_logger.mta | check | warning | Size of indexfile is: 426592256 Should be: 1024 |
| zimbra_logger.mta | check | error | Record-count is not ok; is 13828273 Should be: 0 |
| zimbra_logger.mta | check | warning | Found 13121168 deleted space. Should be 0 |
| zimbra_logger.mta | check | warning | Found 40447 deleted blocks Should be: 0 |
| zimbra_logger.mta | check | warning | Found 13868865 parts Should be: 0 parts |
| zimbra_logger.mta | check | error | Corrupt |
+-------------------+-------+----------+--------------------------------------------------------+
8 rows in set (2 min 34.26 sec)

then i do

repair table mta;

but it seems that nothing happens


how long ca take a repair mta table?

[veronica]

depends on how many entries you have in table. Wait for sometime for it to finish.

[bartounet]

I don't see this command "zmmsgtrace" on my ZCS 6.0.5 ...

[veronica]

Its deprecated in 6.0 version onwards

[snowboarder04]

Originally Posted by veronica

Its deprecated in 6.0 version onwards

Not depreciated - removed completely