Sanity errors using Archecker in IDS 9.40 UC3
Posted in 2004
Topics: Installation, Setup & Upgrades, Storage & Space Management, Server Administration, Versions, Editions & End-of-Life
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
Related threads
- IDS 10 table-level restore
- DBPATH & INFORMIXSERVER - HELP
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape