Fail Consistency Check (help)
Posted in 1993
Topics: High Availability & Replication, Storage & Space Management
I need to know if there's something I can do to manage
the error in Consistency Check that frequently appears in
the online.log file (INFORMIX OnLine 5.0).
I'd appreciate very much if you can explain this situation
to me; I'm sending you the following information (I tried to
make it very concise)
* output in online.log
* some actions I performed
* output of tbstat
* output of tbcheck
Thanks in advance.
Maximo Maldonado
e-mail: mmaldona@mtecv2.mty.itesm.mx
ITESM-Campus Monterrey
Mexico
===> OUTPUT IN ONLINE.LOG FILE
18:32:09 -- Fail Consistency Check -- pthdrpage:ptwrite:bad bfget -- Nodump fo
r pid 25122, uid 236. Already took 4.
18:32:10 I/O bad request chunk 0, pagenum 0, pagecnt 1
18:32:10 tblspace header error:
18:32:10 3067c398: 00000000 00000000 00000000 00000000 ........
.......
18:32:10 3067c3a8: 00430000 01000047 00000000 00000000 .C.....G
.......
===> SOME ACTIONS
1. I related the first number after the message
"tblspace header error:" (3067c398)
with the address of one tblspace in "tbstat -t" output
(I'm surprised of the value -1 in nrows column)
2. I ran tbcheck utility on the related tblnum of the
tblspace address.
(why the value DATA in column "type"?)
3. Why the error in the log file?
===> OUTPUT OF tbstat -t UTILITY
Tblspaces
n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns
47 3067c398 41 1 1000047 0 8 2 0 -1 1
===> OUTPUT OF tbcheck UTILITY
informix> tbcheck -pp 0x01000047 1
addr stamp nslots flag type frptr frcnt next prev
10f938 51041844 255 1 DATA 1044 2028 0 0
slot ptr len flg