please help with informix online 5.0
Konstantin Bakunov could not start Informix OnLine 5.0 on SCO after tbinit failed with 'Transaction not found' and 'Cannot Rollforward from Checkpoint'. Mister Creosote diagnosed a long transaction and advised restoring without rolling forward logical logs. Art S. Kagel gave two options: restore from archive answering no to log restore, then bring the engine fully online, or have Informix tech support truncate the last log. No outcome reported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi... I have the Informix Online Server 5.0 that works under SCO 3.2.4.2 While shared memory starts initialize with command tbinit the following error occurs: ------------ Informix Online initialized - Shared memory Initiialized Physical Recovery Complete: 16 Pages Restored Transaction not found. Log Record: log=4298, pos=87184, type=51, trans=34 Cannot Rollforward from Checkpoint Informix-Online Stopped. ------------ I don't know how i can do any rollforward when i have not initialized the shared memory... Have anybody the solution of this problem ? Thanks in advance. Konstantin costan@mail.ru
In article <38C8D916.E4AF408E@tts.lipetsk.su>, Konstantin Bakunov <kostya@tts.lipetsk.su> wrote: > Hi... > > I have the Informix Online Server 5.0 that works under SCO 3.2.4.2 > While shared memory starts initialize with command tbinit the > following error occurs: > ------------ > Informix Online initialized - Shared memory Initiialized > Physical Recovery Complete: 16 Pages Restored > Transaction not found. > Log Record: log=4298, pos=87184, type=51, trans=34 > > Cannot Rollforward from Checkpoint > > Informix-Online Stopped. > > ------------ > I don't know how i can do any rollforward when i have not initialized > the shared memory... > Have anybody the solution of this problem ? > > Thanks in advance. > > Konstantin > costan@mail.ru > > You would appear to have encountered a Long Transaction. You will need to do a restore and tell the engine NOT to roll forward any logical logs otherwise you will roll forward the long transaction itself and be back where you are now. Regards Mr Creosote -- "Just a waffer thin mint?" Sent via Deja.com http://www.deja.com/ Before you buy.
> You would appear to have encountered a Long Transaction. You will need > to do a restore and tell the engine NOT to roll forward any logical sorry, but i don't know how to tell engine "NOT to roll forward any logical logs.." ;) could you tell me please how to do it ? And what is "restore" ? Does it restore from logical log ? Excuse me.. i'm a new to informix ;) Konstantin costan@mail.ru
Konstantin Bakunov wrote: > > > You would appear to have encountered a Long Transaction. You will need > > to do a restore and tell the engine NOT to roll forward any logical > > sorry, but i don't know how to tell engine "NOT to roll forward any logical > logs.." ;) > could you tell me please how to do it ? > And what is "restore" ? Does it restore from logical log ? > > Excuse me.. i'm a new to informix ;) What seems to have happened is that either the logical logs filled up or the machine crashed without flushing its log buffers. When the engine tries to start it sweeps the logs and finds a partial transaction record (and update will consist, for example, of a pre and post log record and one of these did not get flushed). There are only two solutions 1) Restore the server from archive and when prompted for logical logs to restore say no. The database will be restored as of the beginning of the archive and you will have to repeat all transactions since manually. (If you do this make sure to bring the engine fully online after the restore before shutting it down or you will have to restore all over again.) 2) Call Informix tech support and they will truncate the current or last complete logical log on disk so that the startup fast recovery can complete successfully. This will only possibly cause the loss of a few transactions. -- Art S. Kagel & Family kagel@erols.com