Re: help help help help help help help help help
Posted in 1994
WE had a similar problem a while ago, I don't remember all of the details but I know that Informix wouldn't start after a hardware crash. One of the Informix tech support person logged on to our system and he managed to start the online engine. I think there is an undocumented way of starting the engine without going through "Logical recovery phase". If you do manage to start the server please post on the net how you did it. Thanks. ------- Yogen ICon Inc. yogen@iconnet.com (212)972-4266 ron@bilpin.co.uk wrote: : Our machine crashed without warning. The reason for the crash : has not been determined as it automatically rebooted itself. : PROBLEM : ------- : The machine rebooted and following appropriate file system : checks came up fine, however, Informix will refuse to go : into Quiescent mode. The shared memory seems to initialise : o.k but when the engine attempts recovery mode, the "tbinit" : process dies and dumps core. The "tbmonitor" program : reports the following error :- ** WARNING: Daemon Died ** : Further details follow :- : ENVIRONMENT INFO: : ----------------- : Machine = i80486 : OS = SCO Unix 3.2v4.1 : INFORMIX VERSIONS : ----------------- : INFORMIX EMBEDDED SQL for C Version 4.10.UG1 : Copyright (C) 1984-1991 Informix Software, Inc. : INFORMIX-4GL Interactive Debugger Version 4.10.UE2 : Copyright (C) 1984-1991 Informix Software, Inc. : INFORMIX-4GL Development System Version 4.10.UE2 : Copyright (C) 1984-1991 Informix Software, Inc. : INFORMIX-SQL Version 4.10.UE2 : Copyright (C) 1984-1991 Informix Software, Inc. : INFORMIX-OnLine Version 4.10.UG1 : Copyright (C) 1986-1991 Informix Software, Inc. : INFORMIX-STAR Version 4.10.UD2 : Copyright (C) 1988-1991 Informix Software, Inc. : INFORMIX LOG FILE : ----------------- : 18:57:11 Logical Log 1186 Complete : 18:58:09 Checkpoint Completed : 19:03:29 Checkpoint Completed : 19:14:09 Checkpoint Completed : 19:19:28 Checkpoint Completed : 19:24:49 Checkpoint Completed : 19:30:08 Checkpoint Completed : 19:41:20 Process Aborted Abnormally: pid=26767 user=217 us=80401ddc flags=1 : 19:46:09 Checkpoint Completed : 19:51:28 Checkpoint Completed : Thu Jan 6 20:44:47 1994 : 20:44:47 INFORMIX-OnLine Initialized -- Shared Memory Initialized : 20:44:47 Physical Recovery Started : 20:44:47 Checkpoint Completed : 20:44:47 Physical Recovery Complete: 0 Pages Restored : 20:44:49 Dropping temporary partition 10000cd, recovering 8 pages. : 20:44:49 INFORMIX-OnLine Must ABORT : Log Error 'logsetup() - Overwrite log' : us 0x804019cc pid 366 us_flags 0x301 : tx 0x804026cc tx_flags 0x200003 tx_loguniq 0 tx_logpos 0x0 : 20:44:49 -- Online Aborting -- us=804019cc, pid=366, uid=201 : Questions: : 1. Is there any way of getting Informix-Online running again using : the normal startup procedures ? : 2. If the normal startup procedures cannot be used are there any : tools or "back-door" procedures we could use ?. : 3. If not, is there a way of at least getting to the databases and : dumping out the data so that it can be loaded into a fresh : installation ? : Any help will be greatly appreciated, : ron