IBM Support

LI73364: DB2 SERVER TRAPS DUE TO SEGV IN SQLNLS_UNPADDEDCHARLEN().

 

APAR status

  • Closed as program error.

Error description

  • DB2 server traps due to SEGV in sqlnls_UnpaddedCharLen() when
    executing a query containing substr() call against unicode
    database with UCA collating sequence.

    The following is the stack when hitting SEGV:

    --Frame--- ------Function + Offset------
    0xBFF8DBBC sqlnls_UnpaddedCharLen + 0x0108
    (/home/db2inst1/sqllib/lib32/libdb2g11n.so.1)
    0xBFF8DD2C
    _Z21sqlsBinSortUCAPrepareP20sqle_agent_privatecbP8SQLRXNLSjPhS3
    PjP19SQLS_BSORT_UCA_INFOP17SQLS_BSORT_UCA_CBjP18SQLS_BSORT_KEYIN
    FOitiPt + 0x00ce
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)
    0xBFF8DE48 address: 0x01E4C381 ; dladdress: 0x0042F000 ; offset
    in lib: 0x01A1D381 ;
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)
    0xBFF8DF54 address: 0x01E4A271 ; dladdress: 0x0042F000 ; offset
    in lib: 0x01A1B271 ;
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)
    0xBFF8E04C
    _Z22bsortGetNextPartialKeyP20sqle_agent_privatecbPjS1_P10SQLS_SL
    DESP10SQLS_SORTSP8SQLRXNLSiPi + 0x02bb
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)
    0xBFF8E1B0
    _Z14sqlsBinarySortP20sqle_agent_privatecbP10SQLS_SLDESP10SQLS_SO
    RTSP8SQLRXNLSPP13bsortDupStackPjSA_SA_iiP16bsortCntSrtStackPiSD
    _SD_SD_ + 0x0267
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)
    0xBFF8F2B8
    _Z11sqlsBinSortP20sqle_agent_privatecbP10SQLS_SLDESP10SQLS_SORTS
    + 0x062b
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)
    0xBFF8F2D4
    _Z14sqlsUseBinSortP20sqle_agent_privatecbP10SQLS_SLDESP10SQLS_SO
    RTSi + 0x0030
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)
    0xBFF8F330
    _Z22sqlsBinSortIncrementalP20sqle_agent_privatecbP10SQLS_SLDESP1
    0SQLS_SORTSi + 0x019f
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)
    0xBFF8F428
    _Z8sqlsopenP20sqle_agent_privatecbiiP10SQLD_DPREDiPP8SQLD_CCBPcP
    hP12sqlri_vectorPP10SQLD_VALUE + 0x0182
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)
    0xBFF8F490 _Z9sqlrsopenP8sqlrr_cbP9sqlri_taoiiP10sqlri_iudo +
    0x01dc
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)
    0xBFF8F4D8 _Z8sqlrisrtP8sqlrr_cb + 0x0210
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)
    0xBFF8F50C _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x00af
    (/home/db2inst1/sqllib/lib32/libdb2e.so.1)

Local fix

  • Turn off DB2_BINSORT to avoid the trap:

    db2stop
    db2set DB2_BINSORT=NO
    db2start

Problem summary

  • DB2 SERVER TRAPS DUE TO SEGV IN SQLNLS_UNPADDEDCHARLEN().

Problem conclusion

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

Temporary fix

  • Turn off DB2_BINSORT to avoid the trap:

    db2stop
    db2set DB2_BINSORT=NO
    db2start

Comments

APAR Information

  • APAR number

    LI73364

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-04-23

  • Closed date

    2008-10-23

  • Last modified date

    2008-10-23

  • 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 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R910 PSY

       UP

Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 910

Reference #: LI73364

Modified date: 23 October 2008