Results 1 to 5 of 5

Thread: db crash recovery?

  1. #1
    tiger2000 is offline Elite Member
    Join Date
    May 2008
    Location
    Taiwan
    Posts
    296
    Rep Power
    7

    Default db crash recovery?

    Dear all,

    one 5.0.13 ZCS system encounters a power failure reboot, after that, the ZCS will always do "db crash recovery" when services start up, something like this in mailbox.log:

    Code:
    2010-07-14 16:11:26,237 INFO  [main] [] RedoPlayer - Deferring crash recovery to after startup: txn 1274070006.40888 [IndexItem] ver=1.23, tstamp=1274072796408, mailbox=35278, id=4257385, type=5
    
    2010-07-14 16:11:26,237 INFO  [main] [] RedoPlayer - Deferring crash recovery to after startup: txn 1274070006.40889 [IndexItem] ver=1.23, tstamp=1274072796408, mailbox=35278, id=4257397, type=5
    
    2010-07-14 16:11:26,237 INFO  [main] [] RedoPlayer - Deferring crash recovery to after startup: txn 1274070006.40890 [IndexItem] ver=1.23, tstamp=1274072796408, mailbox=35278, id=4257378, type=5
    How can i do a complete DB recovery so that it will not start it again when every reboot??

    and the more serious problem is that the system now is suffering poor performance, the obvious messages in mailbox.log are something like:

    Code:
    2010-07-14 17:02:56,909 WARN  [Pop3Server-39] [name=xxxx@yyy.zzz;ip=209.85.216.6;] dbconn - Connection pool is 75% utilized (100 connections out of a maximum of 100 in use).  Turn on debug logging for zimbra.dbconn to see stack traces of connections not returned to the pool.

    From the OS "top" utility, it looks to me the ZCS is performaing some heavy disk I/O activities, which caused iowait% pretty high.

    any advice on this?

    Thanks.

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

    Default

    I'd suggest the first thing you do is make a complete backup of your /opt/zimbra directory then do a (non-destructive) file system check on your HDs on this server. When you've done that and if it's all OK try some of the tips here to determine where the problem is and some fixes for it.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    tiger2000 is offline Elite Member
    Join Date
    May 2008
    Location
    Taiwan
    Posts
    296
    Rep Power
    7

    Default

    thanks for the reply.

    i've followed that wiki article to dump/repopulate data back to ZCS, however, it still gives me the same log message when ZCS starts up:

    INFO [main] [] RedoPlayer - Deferring crash recovery to after startup: txn xxxxxxx

    i also notice that the system is still doing some "PostStartupCrashRecovery" action, something like :

    2010-07-15 19:00:32,371 INFO [PostStartupCrashRecovery] [] RedoLogManager - REDOING: txn 1274070006.1134440 [IndexItem] ver=1.23, tstamp=1274251119993, mailbox=25871, id=3980, type=5

    any idea what it means? and what should we do for now?

    any info will be highly appreciated.

  4. #4
    tiger2000 is offline Elite Member
    Join Date
    May 2008
    Location
    Taiwan
    Posts
    296
    Rep Power
    7

    Default

    i'm wondering if my understanding is correct? could someone please help ?

    when ZCS's starting, it's saying the RedoPlayer will defer crash recovery after startup (it also gives a mailbox number: 27213 and id number: 5622).

    Code:
    2010-07-15 22:02:16,183 INFO  [main] [] RedoPlayer - Deferring crash recovery to after startup: txn 1274070006.3911497 [IndexItem] ver=1.23, tstamp=1275449079206, mailbox=27213, id=5622, type=5
    so that we can see there's lots of redoing message like this:

    Code:
    2010-07-16 11:16:57,285 INFO  [PostStartupCrashRecovery] [] RedoLogManager - REDOING: txn 1274070006.3991602 [IndexItem] ver=1.23, tstamp=1275483082460, mailbox=22413, id=6220, type=5
    after RedoLogManager completes all jobs, it will stop to pop up these kind of message. and ZCS will be back to normal.

    Is this correct?

    TIA

  5. #5
    tiger2000 is offline Elite Member
    Join Date
    May 2008
    Location
    Taiwan
    Posts
    296
    Rep Power
    7

    Default

    just an update that those messages (RedoLogManager - REDOING) were gone after ~ 2 days recovery. it looks like the system has finished the whole recovery , however, we didn't restart ZCS service after then, thus, we're not sure if it's still same in next restart.

    Thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 23
    Last Post: 01-24-2013, 03:44 PM
  2. [SOLVED] Moving Zimbra to a new server
    By krolen in forum Administrators
    Replies: 109
    Last Post: 02-05-2009, 11:38 AM
  3. [SOLVED] Crash recovery
    By MrBryce2000 in forum Installation
    Replies: 1
    Last Post: 09-06-2008, 03:02 PM
  4. Replies: 7
    Last Post: 02-27-2008, 05:17 PM
  5. FC3 ZCS 3.1 Crash Recovery - Help!
    By stillSpirit in forum Administrators
    Replies: 0
    Last Post: 09-23-2006, 07:53 AM

Posting Permissions

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