IBM Support

IT32897: POSSIBLE TRAP (SEGV) OR MEMORY ERROR IN SQLVFREELOBMEM() IF QUERYING A TABLE FUNCTION RETURNING A ROWTYPE WITH A CLOB IN IT

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The condition is that the CLOB in the row returned by the
    pipelined table function contains alternatively
    NULL and non NULL CLOB data. This can lead to either a SEGV
    (Trap) or to some memory 'corrupted block header'
    failures.
    
    Typical top of the stack would be:
    
    0x090000000AE6C128 sqloCrashOnCriticalMemoryValidationFailure +
    0x48
    0x090000000AED7070
    diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCcCb +
    0x4F0
    0x090000000AE6DF58
    IPRA.$sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb + 0x758
    0x090000000AE6C69C sqlofmblkEx + 0x11C
    0x090000000D449B24 sqlvFreeLobMem__FP9sqllf_cso@AF14_5 + 0x24
    0x090000000D44A688
    sqlriRowDescCopy__FP8sqlrr_cbP18sqlriRowDescriptorT2 + 0x208
    0x090000000D447840 sqlvSqlPLCopyRow__FP8sqlrr_cbP10sqlz_valueT2
    + 0x40
    0x090000000F634E64 copyData__3PVMFP10sqlz_valueT1Ulb + 0x3E4
    0x090000000F62A39C copyVariable__3PVMFUiT1 + 0xDC
    0x090000000F627E48 run__3PVMFv + 0x1348
    0x090000000F61375C pvm_entry + 0x45C
    0x090000000AE32A8C sqloInvokeFnArgs + 0x5D6C
    0x090000000E7E0558
    IPRA.$sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorInt
    fb + 0x2AF8
    0x090000000E7D62A8 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x2008
    0x0900000011E24E44 sqlri_tfftc__FP8sqlrr_cbP9sqlri_tao + 0x324
    0x090000000DAF42BC sqlriFetch__FP8sqlrr_cbP9sqlri_taol + 0x21C
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Rowstore                                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 V11.1.4.6 or higher                           *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 V11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32897

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-05-18

  • Closed date

    2021-03-26

  • Last modified date

    2021-03-26

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
27 March 2021