Power Outage and Damaged DB
About 3-4 weeks ago our Zimbra server shutdown uncleanly.
When I tried starting it back up MySQL, mailbox, and other Zimbra services wouldn't start.
I dug and dug for solutions to fix the issues.
I ended up dumping/rebuilding/repairing the DB and got the server up and running.
Then I noticed logger wasn't updating properly so I ended up repairing the logger DB.
People have complained about strange issues from the unread messages number showing up without any unread messages, no search results when trying to find an email, to the UI mailbox header missing the checkbox/flag/priority/tag fields. I know re-indexing or removing the index and re-indexing can clean most of these up (the UI not looking correct is a strange one).
The problem I'm most worried about right now is the spam mailbox.
I keep getting these errors
So I tried re-indexing the spam account through the admin interface which said it completed without errors.
Feb 17 12:59:54 zimbraserver postfix/smtp: A486566401C: to=<email@example.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.46, delays=0.04/0/0.01/0.41, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 0E2EB66401D)
Feb 17 12:59:54 zimbraserver postfix/lmtp: 0E2EB66401D: to=<firstname.lastname@example.org>, relay=zimbraserver.fqdn[ip.add.re.ss]:7025, delay=0.12, delays=0.06/0/0.01/0.05, dsn=5.0.0, status=bounced (host zimbraserver.fqdn[ip.add.re.ss] said: 554 5.0.0 Permanent message delivery failure (in reply to end of DATA command))
I also tried viewing the accounts email through the admin interface which just sits on loading.
I checked the MySQL mbox tables which all came back OK.
I then tried telnetting.
It looks like the spam mailbox is junk?...
zimbraserver:~# telnet localhost 7025
Connected to localhost.
Escape character is '^]'.
220 zimbraserver.FQDN.com Zimbra LMTP ready
MAIL FROM: <TEST@TEST.COM> size=200
250 2.0.0 Sender OK
RCPT TO: <SPAM_ACCOUNT@FQDN.COM>
250 2.1.5 Recipient OK
354 End data with <CR><LF>.<CR><LF>
554 5.0.0 Permanent message delivery failure
Should I just delete the account and then run
Or troubleshoot rebuilding/fixing the account?
zmprov mcf zimbraSpamIsSpamAccount email@example.com
If I can get assistance in rebuilding/fixing the account it might help me fix the user accounts that aren't displaying correctly (missing the checkbox, flag, priority, tag fields).