Re: Logical Recovery Failure 7.24/HPUX10.20

Colin Taberman wrote: > > Engine Initialization Problem > > HPUX 10.20 > IDS 7.24.UC4X3 > > I am experiencing a problem during logical recovery stage of engine > initializisation, see online log snip-it below. > Has anyone any ideas how I can resolve this issue without going to > backups. I have used 'tbzero' (an Informix support tool) previously on > earlier versions. Does anyone have this code as a last ditch attempt - > or it's equivalent for my version. > > 18:39:02 Logical Recovery Started. > 18:39:06 Assert Failed: Rollback error 0 > 18:39:06 Who: Session(7, informix@bruro19, 0, -931936504) > Thread(15, fast_rec, c8719558, 1) > 18:39:06 Results: Log record (CKPOINT) in log 1769, offset 0x3b2018> was not ro > lled back > 18:39:06 Action: Use 'onlog' to view the transaction and repair > manually. > 18:39:06 See Also: /var/opt/informix/1/dump/af.fa4b9, shmem.fa4b9.0, > /opt/info > rmix/7.24.UC4/bin/core > 18:39:08 Error writing '/var/opt/informix/1/dump/shmem.fa4b9.0' errno => 28 > 18:39:09 The Master Daemon Died> > I you have any suggestions or 'tbzero' please forward to > ctaberma@gcc.dhl.com. Your suspicions are correct. There is a partial checkpoint recorded in the log. The checkpoint complete record was apparently lost when the engine or the machine crashed. You will have to call tech support so that they can zero out the problematic log record. Sorry no one is likely to give you tbzero as it is supposed to be for support only. Art S. Kagel