Results 1 to 4 of 4

Thread: Power Outage and Damaged DB

  1. #1
    mlcdigital is offline Intermediate Member
    Join Date
    Nov 2008
    Location
    Maine
    Posts
    16
    Rep Power
    6

    Default 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
    Code:
    Feb 17 12:59:54 zimbraserver postfix/smtp[611]: A486566401C: to=<spam_account@fqdn.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[623]: 0E2EB66401D: to=<spam_account@fqdn.com>, 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))
    So I tried re-indexing the spam account through the admin interface which said it completed without errors.
    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.
    Code:
    zimbraserver:~# telnet localhost 7025
    Trying 127.0.0.1...
    Connected to localhost.
    Escape character is '^]'.
    220 zimbraserver.FQDN.com Zimbra LMTP ready
    LHLO zimbraserver.FQDN.com
    250-zimbraserver.FQDN.com
    250-8BITMIME
    250-ENHANCEDSTATUSCODES
    250-SIZE 
    250 PIPELINING
    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
    DATA
    354 End data with <CR><LF>.<CR><LF>
    From: test@test.com
    To: spam_account@fqdn.com
    Subject: Test
    Test
    .
    554 5.0.0 Permanent message delivery failure
    It looks like the spam mailbox is junk?...
    Should I just delete the account and then run
    Code:
    zmprov mcf zimbraSpamIsSpamAccount spam@fqdn.com
    Or troubleshoot rebuilding/fixing the account?
    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).

  2. #2
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,585
    Rep Power
    57

    Default

    Quote Originally Posted by mlcdigital View Post
    It looks like the spam mailbox is junk?...
    Should I just delete the account and then run
    Code:
    zmprov mcf zimbraSpamIsSpamAccount spam@fqdn.com
    I would suggest that is your best course of action.

    Quote Originally Posted by mlcdigital View Post
    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).
    How many accounts are having problems? Did you do a filesystem check (or repair?) when you got your server back? Are the problems with the accounts intermittent or are they there all the time? For a test, why don't you export one of the problem accounts then import it into a new account and see if the problems still exist?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    mlcdigital is offline Intermediate Member
    Join Date
    Nov 2008
    Location
    Maine
    Posts
    16
    Rep Power
    6

    Default

    As far as the spam account...?
    Do I delete the account through the admin interface, create a new spam account through the admin interface, and then run?
    Code:
    zmprov mcf zimbraSpamIsSpamAccount spam@fqdn.com
    Or do I just delete the spam account then run the above?

    There are only a handfull of accounts which have UI glitches but I'm sure there are a ton which need the index file(s) deleted and re-indexed but I'm to lazzy to do that.
    I have thought about exporting/importing the account data for the UI issues...

  4. #4
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,585
    Rep Power
    57

    Default

    Quote Originally Posted by mlcdigital View Post
    As far as the spam account...?
    Do I delete the account through the admin interface, create a new spam account through the admin interface, and then run?
    Code:
    zmprov mcf zimbraSpamIsSpamAccount spam@fqdn.com
    Or do I just delete the spam account then run the above?
    You must delete and recreate the account first then run the command above, it doesn't create it automatically from that command.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •