IBM Support

IC77934: SEG-V IN SQLRA_HASH_DEL_STMT OR SQLRA_CACHE_DEL_VAR FUNCTIONS DURING PACKAGE CACHE EVICTION

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A trap and instance shutdown can be seen with the following
    signature in the db2diag.log
    
    
    
    2011-07-13-16.00.12.337415-240 I16730848A1839     LEVEL: Severe
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:10
    MESSAGE : Possible memory corruption detected.
    DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
    0x820F0002
    DATA #2 : Corrupt block address, PD_TYPE_CORRUPT_BLK_PTR, 8
    bytes
    0x00000000000000e0
    DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes
    Object not dumped: Address: 0x00000000000000C8 Size: 24 Reason:
    Possible offset from NULL pointer
    DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes
    Object not dumped: Address: 0x00000000000000E0 Size: 48 Reason:
    Possible offset from NULL pointer
    CALLSTCK:
      [0] 0x0900000010D1F8D4 pdLog + 0x88
      [1] 0x0900000011245E90
    @78@sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb + 0xF0
      [2] 0x0900000011245CD0
    sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb@glue6CF + 0x78
      [3] 0x0900000010C283A0 sqlofmblkEx + 0x4D4
      [4] 0x0900000010F8C944
    sqlra_hash_del_stmt__FP13SQLO_MEM_POOLP17sqlra_anchor_stmtP17sql
    ra_cached_stmtPi
    + 0x74
      [5] 0x0900000010F8C7D0
    sqlra_cache_del_empty_stmt__FP8sqlrr_cbP17sqlra_anchor_stmtP17sq
    lra_cached_stmtPi
    + 0x28
      [6] 0x09000000109C7348
    sqlra_cache_del_empty_stmt__FP8sqlrr_cbP17sqlra_anchor_stmtP17sq
    lra_cached_stmtPi@glue111B
    + 0x70
      [7] 0x0900000011D3E478
    sqlra_cache_del_var__FP8sqlrr_cbP16sqlra_cached_variP23sqlra_cac
    hed_dependency
    + 0x208
      [8] 0x09000000137FD804
    sqlra_csm_drop_var__FP8sqlrr_cbPP16sqlra_cached_variP23sqlra_cac
    hed_dependencyPi
    + 0x428
      [9] 0x0900000013803D44
    sqlra_csm_flush_vars_anchor__FP8sqlrr_cbP17sqlra_anchor_stmt +
    0x25C
    
    other segmentation faults in sqlra_ code may also result,
    including ones with
    
    sqlra_cache_del_var
    
    in the stack
    

Local fix

  • increasing package cache size (pckcachesz) may decrease
    likelihood of hitting this problem.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All server types                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * seg-v in sqlra_hash_del_stmt or sqlra_cache_del_var          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7 FP5 or subsequent fix pack.               *
    ****************************************************************
    

Problem conclusion

  • Problem fixed in DB2 Version 9.7 Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77934

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-04

  • Closed date

    2012-02-27

  • Last modified date

    2012-09-20

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC77940

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77934

Modified date: 20 September 2012