I'm building a cloned HPUX 11 & IDS 7.2 machine. I can initialize the database and bring it online with no problems. When I restore from a level-0 archive (using ontape) there is a problem converting the sysmaster database. Everything is fine in quiesent mode, but switching to online mode produces the following log entries:
16:00:38 Quiescent Mode
16:00:38 Checkpoint Completed: duration was 0 seconds. 16:00:46 On-Line Mode
16:00:46 Converting 'sysmaster' database ...
16:00:48 Assert Failed: pthdrpagetaltstat2:bad alter slot
16:00:48 Who: Session(15, informix@l2000, 2183, -1045546988)
Thread(38, sqlexec, c1ac2da0, 1)
16:00:48 Results: Cannot use TBLSpace page for TBLSpace 1049336
16:00:48 Action: Run 'oncheck -pt 1049336'
16:00:48 See Also: /tmp/af.26139f
16:00:48 Process exited with return code 127: /bin/sh /bin/sh -c /usr/local/bin/online-alarm 4 1 "Table failure: 'sysmaster:"informix".arc_file_copy'." "pthdrpagetal
16:00:48 Message 19261 not found.
16:00:48 See '/tmp/buildsmi.2153'.
16:00:49 Process exited with return code 127: /bin/sh /bin/sh -c /usr/local/bin/online-alarm 3 6 "Internal Subsystem failure: 'SMI'" "Message 19261 not found. "
Running oncheck -pt 1049336 returns:
$ oncheck -pt 1049336
TBLspace Report for sysmaster:informix.arc_file
Error opening TBLspace arc_file_copy.
And the /tmp/buildsmi.2153 file reads:
Database selected.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
242: Could not open database table (informix.arc_file_copy).
172: ISAM error: Unexpected internal error
Error in line 1
Near character position 76
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
1 row(s) unloaded.
Data committed.
Database closed.
The unload of sysmaster prior to upgrade failed
Thinking it was a corrupt archive, I've tried several more with the same results. I'm on a tight deadline and have been hungup at this point for 2 days now trying to solve it. HELP!
16:00:38 Quiescent Mode
16:00:38 Checkpoint Completed: duration was 0 seconds. 16:00:46 On-Line Mode
16:00:46 Converting 'sysmaster' database ...
16:00:48 Assert Failed: pthdrpagetaltstat2:bad alter slot
16:00:48 Who: Session(15, informix@l2000, 2183, -1045546988)
Thread(38, sqlexec, c1ac2da0, 1)
16:00:48 Results: Cannot use TBLSpace page for TBLSpace 1049336
16:00:48 Action: Run 'oncheck -pt 1049336'
16:00:48 See Also: /tmp/af.26139f
16:00:48 Process exited with return code 127: /bin/sh /bin/sh -c /usr/local/bin/online-alarm 4 1 "Table failure: 'sysmaster:"informix".arc_file_copy'." "pthdrpagetal
16:00:48 Message 19261 not found.
16:00:48 See '/tmp/buildsmi.2153'.
16:00:49 Process exited with return code 127: /bin/sh /bin/sh -c /usr/local/bin/online-alarm 3 6 "Internal Subsystem failure: 'SMI'" "Message 19261 not found. "
Running oncheck -pt 1049336 returns:
$ oncheck -pt 1049336
TBLspace Report for sysmaster:informix.arc_file
Error opening TBLspace arc_file_copy.
And the /tmp/buildsmi.2153 file reads:
Database selected.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
242: Could not open database table (informix.arc_file_copy).
172: ISAM error: Unexpected internal error
Error in line 1
Near character position 76
0 row(s) unloaded.
0 row(s) unloaded.
0 row(s) unloaded.
1 row(s) unloaded.
Data committed.
Database closed.
The unload of sysmaster prior to upgrade failed
Thinking it was a corrupt archive, I've tried several more with the same results. I'm on a tight deadline and have been hungup at this point for 2 days now trying to solve it. HELP!