Re: Fast Recovery Forever !!

"SH Lim" <sweehock@hotmail.com> wrote in article <5oo5ek$kdo@cssun.mathcs.emory.edu>... > Guys and Gals, > Could you help me out here. I need some good solid explanation that > can convice management (non-techies) with high expectations about > Informix. > The Online Server 7.13 configured with care and which has been > runnning for weeks suddenly went into Fast-Recovery mode automatically. > We waited for checkpoints, etc to be completed but it was unable to go > Online for the next 30 minutes. > Finally, a decision to re-initialize it was done and work continued > as usual. > The only explanation that was available at that time and since then, > was that a deadlock probably happened on one of our most referenced > table. > Would there be any other explanations for this ?? > Thanks in advance. > Cheers, > SH. > > > --------------------------------------------------------- > Get Your *Web-Based* Free Email at http://www.hotmail.com > --------------------------------------------------------- > I have experienced this once. That time the cause was one chunk went down (disk crashed) while doing a checkpoint. The database ended up in a mess as we had logs with a half done checkpoint and was unable to recover upto the previous checkpoint.