Re: Checkpoint Record not Found in Logical Log. Any sugestions.

Saulius Raudys wrote: > > This is online.log of Informix OL on Windows NT: > > -Tue Jun 16 15:11:38 1998 > > -15:11:38 Message Server service started successfully. > -15:11:38 DR: DRAUTO is 0 (Off) > -15:11:39 INFORMIX-OnLine Initialized -- Shared Memory Initialized. > -15:11:39 Physical Recovery Started. > -15:11:39 Physical Recovery Complete: 0 Pages Restored. > -15:11:39 Logical Recovery Started. > -15:11:39 Checkpoint Record not Found in Logical Log. > -15:11:41 Cannot Rollforward from Checkpoint. > -15:11:41 INFORMIX-OnLine Stopped. > > Sombody may explain, how could accure this situation: 'Checkpoint Record = > not Found in Logical Log'. > As i uderstand, at least one checkpoint allways presents in logical log = > (by rules of Informix OL management of logical log). Normally correct. However, your machine apparently crashed or was powered down without shutting down the Informix engine. Because of this, and the cooincidence that a checkpoint started record was written to disk, the logical log buffer containing the checkpoint complete record had not yet been written to disk and was lost or the crash happened during the checkpoint. The fast restore code expects to see a checkpoint complete record for each checkpoint begun record and so it is confused. Call tech support and they can zero out the checkpoint begun records and the engine will then come up. Art S. Kagel