Archive detects that page 9:1504862 is corrupt when ontape
ZhiWei Cui got an ontape assert warning on 11.10.FC2 that page 9:1504860 was corrupt; renaming the table, recreating it and reloading made ontape work, but it recurred. Benjamin Thompson suspected disk corruption or a defect (cited an APAR). David Williams advised dropping the corrupt old table, checking storage errors, and running errpt -a on AIX. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
22:10:12 IBM Informix Dynamic Server Version 11.10.FC2 Software Serial Number AAA#B000000
22:10:12 Assert Warning: Archive detects that page 9:1504860 is corrupt.
22:10:12 Who: Session(405457, informix@XXXX, 1175880, 700000831fd32d8)
Thread(409418, arcbackup1, 700000831f99ef8, 3)
File: rsarcbu.c Line: 3610
22:10:12 Raw hex dump of stack located in /opt/informix/temp/af.433203c4.rawstk
22:10:12 Stack for thread: 409418 arcbackup1
base: 0x07000008389dc000
len: 528384
pc: 0x0000000100063b54
tos: 0x0700000838a5bfd0
state: running
vp: 3
==========================================================
1. I use oncheck -pe datadbs1 ,I can find 9:1504860 used by which table
2. rename table tab1 to tab2;
3. create table tab1;
4. insert into tab1 select * from tab2;
5. ontape is ok
========================================================
This problem often occurs. Why?
------------------------------
ZhiWei Cui
GBASE
------------------------------
#Informix
I don't think you have provided enough information to diagnose the problem. Two possibilities though: 1. actual disk corruption due to failing hardware. 2. Informix defect. Given you are running 11.10.FC2 which is long out of support and I don't remember Informix 11.10 fondly at all, I would suspect a defect. Here is a candidate: https://www.ibm.com/support/pages/apar/IC86953 If it is this defect you may be able to work around it following the suggestion in the link. Ben. ------------------------------ Benjamin Thompson ------------------------------
Hi, After the insert do you drop tab2? You need to drop the corrupt object. Are there any storage errors anywhere in the storage stack? Or machine cpu/memory issues? If not it would be an Informix defect and require an upgrade. Regards, David. ------------------------------ David Williams ------------------------------
insert into tab1 select * from tab2
drop table tab2;ontape is ok.
I'm not very familiar with how to detect operating system logs on AIX
------------------------------
ZhiWei Cui
GBASE
------------------------------
Try starting with errpt -a David. ------------------------------ David Williams ------------------------------