Sanity errors using Archecker in IDS 9.40 UC3
Posted in 2004
Hi,
IDS 9.40 UC3 on RHL 7.3
We have recently upgraded engine from IDS 9.30 UC3 to IDS 9.40 UC3.
Every night we runs all oncheck with -cD, -cI, -cR, -ce, -cc. All
onchecks
are OK. We also run Level 0 archive every night and then run archecker
to
validate the archive. After upgrade to IDS 9.40 UC3, I am getting
following
error in ac_msg.log every night and interestigly archive validation
passed
despite of all there errors:
--------------------------------------------------------------------------
STATUS: starting to scan dbspace 6 created on 03/12/2004 17:57:14.
STATUS: Archive timestamp 0X6DBDBAF0.
ERROR: Parition 0X000014DE has incorrect number of pages ->used 898 <
total 867.
ERROR: Sanity test on parition page failed 6:5342.
ERROR: dbspace 0 is not open for parition 0X000018BF.
ERROR: Sanity test on parition page failed 6:6335.
ERROR: dbspace 0 is not open for parition 0X000047A8.
ERROR: Sanity test on parition page failed 6:18344.
ERROR: Parition 0X000047A9 has incorrect number of pages ->used 114 <
total 83.
ERROR: Sanity test on parition page failed 6:18345.
ERROR: dbspace 0 is not open for parition 0X00004952.
ERROR: Sanity test on parition page failed 6:18770.
ERROR: dbspace 0 is not open for parition 0X00004953.
ERROR: Sanity test on parition page failed 6:18771.
ERROR: dbspace 0 is not open for parition 0X00004954.
ERROR: Sanity test on parition page failed 6:18772.
ERROR: dbspace 0 is not open for parition 0X0006F94E.
ERROR: Sanity test on parition page failed 8:457038.
ERROR: Parition 0X0006F94F has incorrect number of pages ->used 34 <
total 13.
ERROR: Sanity test on parition page failed 8:457039.
ERROR: dbspace 0 is not open for parition 0X000D2B96.
ERROR: Sanity test on parition page failed 14:863126.
ERROR: Parition 0X000D2B97 has incorrect number of pages ->used 1286 <
total 1255.
ERROR: Sanity test on parition page failed 14:863127.
ERROR: dbspace 0 is not open for parition 0X000D2B98.
ERROR: Sanity test on parition page failed 14:863128.
..........
..........
ERROR: Sanity test on parition page failed 14:863172.
..........
..........
..........
TIME: [03/15/2004 04:33:54] Checking Completed.
STATUS: Tables/Fragments validated: 6470
Archive Validation PASSED.
-------------------------------------------------------------------------------
Here is onstat -d
IBM Informix Dynamic Server Version 9.40.UC3 -- On-Line -- Up 5
days 20:40:23 -- 1368004 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
78a777d8 1 0x1001 1 1 N informix
rootdbs
79bedc58 2 0x1 2 1 N informix
plogdbs
79bedda8 3 0x1 3 1 N informix
llogdbs
79bf2018 4 0x2001 4 1 N T informix
tmpndbs
79bf2168 5 0x2001 5 1 N T informix
tmptdbs
79bf22b8 6 0x1 6 16 N informix
maindbs
79bf2408 7 0x8001 22 1 N S informix
sndqdbs
7 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags
pathname
78a77928 1 1 0 256000 197578 PO--
/IFMXDATA/authlive/rootdbs
79b7bb08 2 2 0 256000 5947 PO--
/IFMXDATA/authlive/plogdbs
79b7bc90 3 3 0 512000 69579 PO--
/IFMXDATA/authlive/llogdbs
79b7be18 4 4 0 1024000 1021192 PO--
/IFMXDATA/authlive/tmpndbs
79bec018 5 5 0 1024000 1021045 PO--
/IFMXDATA/authlive/tmptdbs
79bec1a0 6 6 0 1024000 7 PO--
/IFMXDATA/authlive/maindbs01
79bec328 7 6 0 1024000 0 PO--
/IFMXDATA/authlive/maindbs02
79bec4b0 8 6 0 1024000 54 PO--
/IFMXDATA/authlive/maindbs03
79bec638 9 6 0 1024000 219 PO--
/IFMXDATA/authlive/maindbs04
79bec7c0 10 6 0 1024000 108 PO--
/IFMXDATA/authlive/maindbs05
79bec948 11 6 0 1024000 244 PO--
/IFMXDATA/authlive/maindbs06
79becad0 12 6 0 1024000 89 PO--
/IFMXDATA/authlive/maindbs07
79becc58 13 6 0 1024000 333 PO--
/IFMXDATA/authlive/maindbs08
79becde0 14 6 0 1024000 535 PO--
/IFMXDATA/authlive/maindbs09
79bed018 15 6 0 1024000 171 PO--
/IFMXDATA/authlive/maindbs10
79bed1a0 16 6 0 1024000 994814 PO--
/IFMXDATA/authlive/maindbs11
79bed328 17 6 0 1024000 1023997 PO--
/IFMXDATA/authlive/maindbs12
79bed4b0 18 6 0 1024000 1023997 PO--
/IFMXDATA/authlive/maindbs13
79bed638 19 6 0 1024000 1023997 PO--
/IFMXDATA/authlive/maindbs14
79bed7c0 20 6 0 1024000 1023997 PO--
/IFMXDATA/authlive/maindbs15
79bed948 21 6 0 1024000 1023997 PO--
/IFMXDATA/authlive/maindbs16
79bedad0 22 7 0 1048575 979092 979093 POS-
/IFMXDATA/authlive/sndqdbs
Metadata 69429 52508 69429
22 active, 2047 maximum
Expanded chunk capacity mode: disabled
--------------------------------------------------------------------------------
I have a concern now that in the event of any crash would this archive
be
restorable ? I notice some references in IDS 9.40 UC3 release notes
(IBM Informix Bug no. 156531 and 118760) but does not say specifically
about
sanity error issue.
Can some one pl. help ?
TIA
Hari