Problem recovering Informix 4.1
Posted in 1996
Topics: Logging & Checkpoints
I am developing client/server applications with Delphi 1.02 in the
client side and Informix 4.1 in the server side, on a Sun Sparc 20 running
SunOS. Two days ago, the Informix server went down, and after several
unsuccessful attempts to recover it, all I got was the following message
stored in the log, once for each time the recover was tried. The messages
and the values were identical all times.
> Thu Oct 3 11:41:23 1996
>
> 11:41:23 INFORMIX-OnLine Initialized -- Shared Memory Initialized
> 11:41:23 Physical Recovery Started
> 11:41:23 Checkpoint Completed
> 11:41:23 Physical Recovery Complete: 0 Pages Restored
> 11:41:23 Checkpoint Completed
> 11:41:23 ERROR: logundo(29) iserrno 100 us 0x401b44 pid 0
> tx 0x40335c loguniq 68 logpos 0x15f0c0
> 11:41:23 INFORMIX-OnLine Must ABORT
> Log Error 'rollback() - logundo() FAILED'
> us 0x401b44 pid 0 us_flags 0x121> tx 0x40335c tx_flags 0x82403 tx_loguniq 68 tx_logpos 0x15f0c0
> 11:41:23 -- Online Aborting -- us=401b44, pid=3945, uid=203
It seems that the quick recovery procedure can't do a certain step
properly. I looked the Administrator's Guide, but it doesn't help me too
much. It says that Initialisation should be tryed again and, if it
doesn't work, data should be recovered from a backup copy that,
unfortunatelly, I don't happen to have.
The question is: Does anybody of you know of any mean to get the
Informix server running, without lose of data if possible, or with the
least lose if not.
Any help given would be very helpful. Please e-mail me, as I don't
always track this group.
Thank you
Xesus M. Lopez
xesus@udc.es