ACSLS - Corrupted Database Index Caused Mount/Dismount Failures (Doc ID 1014664.1)

Last updated on JULY 17, 2017

Applies to:

Sun StorageTek Auto Cartridge Sys Lib SW (ACSLS) - Version: 7.0 and later   [Release: 7.0 and later ]
All Platforms
***Checked for relevance on 03-Apr-2012***

Symptoms

1.  Database failure errors during dismount operations

2.  Database error messages in acsss_event.log during dismount:
     2005-12-15 09:37:45 DISMOUNT[0]:
     719 N cl_vol_upda.c 2 731
     cl_vol_update:
     EXEC SQL update where volume is VG6209, retries = 11
     [DI_S_TIMEOUT]:

     2005-12-15 09:37:45 DISMOUNT[0]:
     1 E mt_resv_dm.c 1 773
     mt_resv_dm: cl_vol_update() unexpected status = STATUS_DATABASE_ERROR

    2005-12-15 09:37:45 ACSSA[0]:
    1423 N sa_demux.c 1 278
    Data base failure.

    ....

    2005-12-15 10:59:59 DISMOUNT[0]:
    725 N cl_vol_writ.c 1 361
    cl_vol_write:
    EXEC SQL Lock timeout on update volumetable * where volid = :TG3729
    [DI_S_TIMEOUT]:

    2005-12-15 10:59:59 ACSSA[0]:
    1423 N sa_demux.c 1 278
    Data base failure.

    2005-12-15 10:59:59 DISMOUNT[0]:
    1 E mt_action_dm.c 1 336
    dm_lh_moved: mt_upda_dm() unexpected status = STATUS_DATABASE_ERROR


3.  volumetable "scratch_idx" error in lib6_online.log:
     09:37:45 See Also: /tmp/af.4137f51
     09:37:45 Assert Failed: Rowid 0x890d not found for delete in partnum 100051, key 4
     09:37:45 Informix Dynamic Server Version 7.31.UC7
     09:37:45 Who: Session(24, acsss@g0drs15, 4345, 172495048)
     Thread(44, sqlexec, a45bb28, 1)
     File: rsnode.c Line: 2236
     09:37:45 Results: Delete failed
     09:37:45 Action: Run 'oncheck -cI lib6:"acsss".volumetable#scratch_idx'
     09:37:45 Process exited with return code 1: /bin/sh /bin/sh -c /export/home/informix/IDS7.3  
     /etc/log_full.sh 4 2 "Index failure: 'lib6:"acsss".volumetable#scratch_idx
     volumetable drive_idx error logged in lib6_online.log

    10:59:50 See Also: /tmp/af.413929c
    10:59:50 Process exited with return code 1: /bin/sh /bin/sh -c /export/home/informix/IDS7.3
    /etc/log_full.sh 4 2 "Index failure: 'lib6:"acsss".volumetable#drive_idx'.
    10:59:52 Assert Failed: Rowid 0x18212 not found for delete in partnum 100051, key 3
    10:59:52 Informix Dynamic Server Version 7.31.UC7
    10:59:52 Who: Session(23, acsss@g0drs15, 3142, 172494692)
    Thread(43, sqlexec, a45b63c, 1)
    File: rsnode.c Line: 2236
    10:59:52 Results: Delete failed
    10:59:52 Action: Run 'oncheck -cI lib6:"acsss".volumetable#drive_idx'

Changes

No known change

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms