Informix

 View Only
  • 1.  Archive detects that page 9:1504862 is corrupt when ontape

    Posted Wed January 05, 2022 10:05 PM
    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
    ------------------------------


  • 2.  RE: Archive detects that page 9:1504862 is corrupt when ontape

    Posted Fri January 07, 2022 07:26 AM
    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
    ------------------------------



  • 3.  RE: Archive detects that page 9:1504862 is corrupt when ontape

    Posted Fri January 07, 2022 10:43 AM


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



  • 4.  RE: Archive detects that page 9:1504862 is corrupt when ontape

    Posted Fri January 07, 2022 08:25 PM
    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
    ------------------------------



  • 5.  RE: Archive detects that page 9:1504862 is corrupt when ontape

    Posted Sun January 09, 2022 04:32 AM

    Try starting with

    errpt -a

    David.

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