IBM Support

IZ59779: In a mixed XA/non-XA env,a transactional request may panic when DDL requests/failed XA requests were executed inside XA env.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • There is a DB2 logic issue which causes a double free pointer
    action when transactional request is issued. This will happen if
    DDL requests were executed and a failed XA requests
    were issued inside XA environment.
    
    The entries in the db2diag.log should look like this:
    
    2009-08-28-05.53.56.783147-420 I56829172A1910     LEVEL: Severe
    PID     : 28080                TID  : 1           PROC :
    db2agent (VBUILDDB) 0
    INSTANCE: db2vbprd             NODE : 000         DB   :
    VBUILDDB
    APPHDL  : 0-814                APPID: /1149826.4195.00060013001A
    AUTHID  : V859640
    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
    0x0000000319718920
    DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes
    0x0000000319718908 : FAB0 0000 0031 9710 3E69 CAD5 00EB 78DB
    .....1..>i....x.
    0x0000000319718918 : FAB0 0000 0031 9710
    .....1..
    DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes
    0x0000000319718920 : 0000 0000 0000 0000 0000 0000 0000 0005
    ................
    0x0000000319718930 : 000A 0008 5052 4956 5F55 5345 5253 0000
    ....PRIV_USERS..
    0x0000000319718940 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    CALLSTCK:
      [0] 0xFFFFFFFF7BFB409C
    __1cbJsqloMemSearchForChunkSubgroupHeader6FkLkb_pnRSqloChunkSubg
    roup__ + 0x1C4
      [1] 0xFFFFFFFF7BFB4D74 sqlofmblkEx + 0x664
      [2] 0xFFFFFFFF7CD2BA40
    __1cYsqlrr_end_tran_after_DPS6FpnIsqlrr_cb_ii_i_ + 0x4E0
      [3] 0xFFFFFFFF7CD2C6AC
    __1cMsqlrrcom_dps6FpnIsqlrr_cb_iipnNsqlxaCallInfo__i_ + 0x714
      [4] 0xFFFFFFFF7CD2D0D4 __1cIsqlrrcom6FpnIsqlrr_cb_ii_i_ +
    0x46C
      [5] 0xFFFFFFFF7CD0F5E0
    __1cMsqlrr_commit6FpnOdb2UCinterface__i_ + 0xC0
      [6] 0xFFFFFFFF7BF42674
    __1cSsqljsSyncCommitted6FpnOdb2UCinterface__i_ + 0x354
      [7] 0xFFFFFFFF7BF3F75C
    __1cRsqljs_ddm_syncctl6FpnOdb2UCinterface_pnOsqljsDDMObject__i
    + 0x2A4
      [8] 0xFFFFFFFF7BF26084
    __1cVsqljsParseRdbAccessed6FpnNsqljsDrdaAsCb_pnOsqljsDDMObject_p
    nOdb2UCinterface__i_ + 0x2E4
      [9] 0xFFFFFFFF7BF26E00
    __1cKsqljsParse6FpnNsqljsDrdaAsCb_pnOdb2UCinterface__i_ + 0x488
    

Local fix

  • Either take out the DDL operation out of XA environment or not
    issue failed XA requests.
    

Problem summary

  • There is a DB2 logic issue which causes a double free pointer
    action when transactional request is issued. This will happen if
    DDL requests were executed and a failed XA requests
    were issued inside XA environment.
    
    The entries in the db2diag.log should look like this:
    
    2009-08-28-05.53.56.783147-420 I56829172A1910     LEVEL: Severe
    PID     : 28080                TID  : 1           PROC :
    db2agent (VBUILDDB) 0
    INSTANCE: db2vbprd             NODE : 000         DB   :
    VBUILDDB
    APPHDL  : 0-814                APPID: /XXXXXXX.4195.00060013001A
    AUTHID  : V859640
    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
    0x0000000319718920
    DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes
    0x0000000319718908 : FAB0 0000 0031 9710 3E69 CAD5 00EB 78DB
    .....1..>i....x.
    0x0000000319718918 : FAB0 0000 0031 9710
    .....1..
    DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes
    0x0000000319718920 : 0000 0000 0000 0000 0000 0000 0000 0005
    ................
    0x0000000319718930 : 000A 0008 5052 4956 5F55 5345 5253 0000
    ....PRIV_USERS..
    0x0000000319718940 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    CALLSTCK:
    
      [0] 0xFFFFFFFF7BFB409C
    __1cbJsqloMemSearchForChunkSubgroupHeader6FkLkb_pnRSqloChunkSubg
    roup__ + 0x1C4
      [1] 0xFFFFFFFF7BFB4D74 sqlofmblkEx + 0x664
      [2] 0xFFFFFFFF7CD2BA40
    __1cYsqlrr_end_tran_after_DPS6FpnIsqlrr_cb_ii_i_ + 0x4E0
      [3] 0xFFFFFFFF7CD2C6AC
    __1cMsqlrrcom_dps6FpnIsqlrr_cb_iipnNsqlxaCallInfo__i_ + 0x714
      [4] 0xFFFFFFFF7CD2D0D4 __1cIsqlrrcom6FpnIsqlrr_cb_ii_i_ +
    0x46C
      [5] 0xFFFFFFFF7CD0F5E0
    __1cMsqlrr_commit6FpnOdb2UCinterface__i_ + 0xC0
      [6] 0xFFFFFFFF7BF42674
    __1cSsqljsSyncCommitted6FpnOdb2UCinterface__i_ + 0x354
      [7] 0xFFFFFFFF7BF3F75C
    __1cRsqljs_ddm_syncctl6FpnOdb2UCinterface_pnOsqljsDDMObject__i
    + 0x2A4
      [8] 0xFFFFFFFF7BF26084
    __1cVsqljsParseRdbAccessed6FpnNsqljsDrdaAsCb_pnOsqljsDDMObject_p
    nOdb2UCinterface__i_ + 0x2E4
      [9] 0xFFFFFFFF7BF26E00
    __1cKsqljsParse6FpnNsqljsDrdaAsCb_pnOdb2UCinterface__i_ + 0x488
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 9.
    

Temporary fix

  • Either take out the DDL operation out of XA environment or not
    issue failed XA requests.
    

Comments

APAR Information

  • APAR number

    IZ59779

  • Reported component name

    DB2 UDB ESE SOL

  • Reported component ID

    5765F4102

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-01

  • Closed date

    2010-04-16

  • Last modified date

    2010-04-16

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

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

    IZ60111 IC62923 IZ60266 IC63054

Fix information

  • Fixed component name

    DB2 UDB ESE SOL

  • Fixed component ID

    5765F4102

Applicable component levels

  • R910 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910"}]

Document Information

Modified date:
04 October 2021