URGENT: assertion failure during logical recovery
Posted in 1999
Has anyone seen this before?
The physical recovery succeeds but the logical recovery (log 146 and log 147
only) fails ?
If I can't roll log 147 forward my users lose a days work - a disaster !
Geoff Poole
Oxford GlycoSciences
geoffrey.poole@ogs.co.uk
onbar -r -w -p -t '1999-03-12 15:56:00' - worked
onbar -r -l -t '1999-03-12 15:56:00' - failed
INFORMIX-Universal Server Version 9.14.UC2
UNIX Solaris 2.5.1
02:19:13 Recovery Mode
02:19:14 Physical Restore of rootdbs, logdbs, ... started.
03:47:56 Physical Restore of rootdbs, logdbs, ... Completed.
03:47:56 Checkpoint Completed: duration was 0 seconds.
03:47:56 Physical Restore of rootdbs, logdbs, ... started.
03:57:35 Physical Restore of rootdbs, logdbs, Completed.
03:57:35 Checkpoint Completed: duration was 0 seconds.
03:57:37 Logical Recovery Started.
03:57:37 Checkpoint Completed: duration was 0 seconds.
03:57:37 Start Logical Recovery - Start Log 146, End Log ?
03:57:37 Starting Log Position - 146 0x746e018
04:10:09 Physical Recovery Started.
04:10:09 Physical Recovery Complete: 0 Pages Restored.
04:10:09 Logical Recovery Started.
04:10:13 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
04:10:13 Cannot change to Quiescent Mode.
04:10:37 PIT reached - logid: 146, logpos: 0x746f060
04:12:01 Error: where am i?
04:12:01 Assert Failed: Cannot Rollforward from Checkpoint.
04:12:01 INFORMIX-Universal Server Version 9.14.UC2
04:12:01 Who: Session(79, informix@pluto, 7818, 0)
Thread(40, ontape, 0, 4)
File: rslgr.c Line: 1099
onbar log :-
1999-03-13 03:58:54 7818 2289 Begin restore logical log 146.
1999-03-13 04:10:38 7818 2289 Completed restore logical log 146.
1999-03-13 04:11:14 7818 2289 Begin restore logical log 147.
1999-03-13 04:11:14 7818 2289 A system error occurred. Aborting XBSA
session.
1999-03-13 04:11:14 7818 2289 Completed restore logical log 147.
1999-03-13 04:11:50 7818 2289 Begin restore logical log 148.
1999-03-13 04:11:50 7818 2289 A system error occurred. Aborting XBSA
session.
1999-03-13 04:11:50 7818 2289 Completed restore logical log 148.
1999-03-13 04:11:53 7818 2289 Begin restore logical log 149.
1999-03-13 04:11:55 7818 2289 Completed restore logical log 149.
1999-03-13 08:33:18 7818 2289 ERROR: Unable to commit the restore:
buc_fe.c : Archive API processing failed at line 867 for msgtype.
1999-03-13 08:33:18 7818 2289 ERROR: Unable to commit the restore: Archive
API error: not yet open.