Informix

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
------------------------------

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
------------------------------

Original Message:
Sent: Wed January 05, 2022 10:05 PM
From: ZhiWei Cui
Subject: Archive detects that page 9:1504862 is corrupt when ontape

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
------------------------------

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
------------------------------

Original Message:
Sent: Wed January 05, 2022 10:05 PM
From: ZhiWei Cui
Subject: Archive detects that page 9:1504862 is corrupt when ontape

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
------------------------------

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
------------------------------

Original Message:
Sent: Fri January 07, 2022 10:42 AM
From: David Williams
Subject: Archive detects that page 9:1504862 is corrupt when ontape

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

Original Message:
Sent: Wed January 05, 2022 10:05 PM
From: ZhiWei Cui
Subject: Archive detects that page 9:1504862 is corrupt when ontape

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
------------------------------

Try starting with

errpt -a

David.

------------------------------
David Williams
------------------------------

Original Message:
Sent: Fri January 07, 2022 08:24 PM
From: ZhiWei Cui
Subject: Archive detects that page 9:1504862 is corrupt when ontape

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

Original Message:
Sent: Fri January 07, 2022 10:42 AM
From: David Williams
Subject: Archive detects that page 9:1504862 is corrupt when ontape

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

Original Message:
Sent: Wed January 05, 2022 10:05 PM
From: ZhiWei Cui
Subject: Archive detects that page 9:1504862 is corrupt when ontape

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
------------------------------