OnLine 7.1 stuck in recovery
It would seem that the recovery process is blocked due to full logical
logs but I can't seem to back them up to either tape or /dev/null. The
"ontape -a" command starts to work then completes with "This tape
contains no log data". The process that filled the logs was accidentally
killed. The only way the affect the status of the engine is to kill the
master daemon. By the way, I'm running on SCO ODT 3.0. Is there another
way to flush the logs? I included some output.
Thanks for any hints.
Edwin Babadaglian
edwinb@panix.com
-----------------------------------------------------------------------
$ onstat -u
RSAM Version 7.10.UC1 -- Fast Recovery -- Up 00:11:02 -- 3936 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwri
80410ba4 ---P--D 0 informix - 0 0 0 6 2
80410f34 ---P--F 0 informix - 0 0 0 0 0
804112c4 ---P--B 3 informix - 0 0 0 0 0
80411654 --RPX-D 4 informix - 0 0 0 44 4
4 active, 25 total
$ onstat -l
RSAM Version 7.10.UC1 -- Fast Recovery -- Up 00:11:21 -- 3936 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 16 0 0 0.00
phybegin physize phypos phyused %used
10003f 500 399 0 0.00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 10 16 1011 10 1 101.1 10.0
Buffer Waiting
Buffer ioproc flags #bcpiers
L-1 80411654 0x1 0
address number flags uniqid begin size used %used
80440e20 1 U-B---- 43 100233 250 250 100.00
80440e3c 2 U-B---- 44 10032d 250 250 100.00
80440e58 3 U-B---L 45 100427 250 250 100.00
80440e74 4 U---C-- 46 100521 250 250 100.00
80440e90 5 U-B---- 41 10061b 250 250 100.00
80440eac 6 U-B---- 42 100715 250 250 100.00