IBM Support

IC68205: A SORT THAT ENCOUNTERS AN ERROR MIGHT ALSO SEGFAULT IN STMMSTOPSORTLISTMONITORONFAILURE()

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A operation require SORT services that encounters an error (such
    as disk full when the sort spills to a temp tablespace, or other
    legitimate others) might segfault and bring down the instance.
    
    You will likely see some kind of legitimate sort related error,
    like so:
    
    2010-01-01-19.45.03.278076+480 I45881212A2803     LEVEL: Severe
    PID     : 471692               TID  : 14788       PROC : db2sysc
    30
    INSTANCE: db2inst1              NODE : 030         DB   : SAMPLE
    APPHDL  : 0-4287               APPID:
    132.228.87.19.40456.09122910292
    AUTHID  : DB2INST1
    EDUID   : 14788                EDUNAME: db2agntp (SAMPLE) 30
    FUNCTION: DB2 UDB, sort/list services, sqlsusda, probe:50
    MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
              DIA8312C Disk was full.
    DATA #1 : String, 14 bytes
    SRT file error
    DATA #2 : Hexdump, 296 bytes
    0x0700000010605310 : 0000 0003 0000 0004 0700 0001 1DBC CC80
    0x0700000010605320 : 0000 00AA 0000 0000 0700 0000 104F 7A20
    0x0700000010605330 : 0001 0005 2F64 6232 6461 7461 2F64 6232
    <...skipped...>
    
    The stack trace will show stmmStopSortListMonitorOnFailure()
    near the top of the stack:
    
    
    <StackTrace>
    @102@3@stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SLDE
    Si
    + 0x460
    .sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo_fdprpro_clone_1685 + 0x3C
    </StackTrace>
    
    <StackTrace>
    stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SLDE
    sqlsinsr__FP8sqeAgentPcPUcP12sqlri_vectorPP10SQLD_VALUE + 0x44
    sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo + 0x44
    sqlrisr2__FP8sqlrr_cb + 0xFC
    sqlischf__FP7SQLI_CBUsUi + 0x184
    sqliFirstTreeSearch__FP7SQLI_CBP11SQLI_SFGLOB + 0x4C
    sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQLI_
    sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID + 0x38
    sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID@glueC17 + 0x70
    sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT
    sqlritaSimplePerm__FP8sqlrr_cb - 0x4C8
    sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x30
    sqlrihsjn__FP8sqlrr_cb + 0xC
    sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C
    sqlrihsjn__FP8sqlrr_cb + 0xC
    sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C
    sqlrihsjn__FP8sqlrr_cb + 0xC
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x814
    sqlrr_dss_router__FP8sqlrr_cb + 0x464
    sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF68
    sqleSubRequestRouter__FP8sqeAgentPUiT2 + 0x7E8
    sqleProcessSubRequest__FP8sqeAgent + 0x120
    RunEDU__8sqeAgentFv + 0x300
    EDUDriver__9sqzEDUObjFv + 0x94
    sqloEDUEntry + 0x57C
    </StackTrace>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All.                                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * A operation require SORT services that encounters an error   *
    * (such as disk full when the sort spills to a temp            *
    * tablespace, or other legitimate others) might segfault and   *
    * bring down the instance.                                     *
    *                                                              *
    * You will likely see some kind of legitimate sort related     *
    * error, like so:                                              *
    *                                                              *
    * 2010-01-01-19.45.03.278076+480 I45881212A2803    LEVEL:      *
    * Severe                                                       *
    * PID     : 471692              TID  : 14788      PROC :       *
    * db2sysc 30                                                   *
    * INSTANCE: db2inst1            NODE : 030        DB   :       *
    * SAMPLE                                                       *
    * APPHDL  : 0-4287              APPID:                         *
    * 132.228.87.19.40456.09122910292                              *
    * AUTHID  : DB2INST1                                           *
    * EDUID   : 14788               EDUNAME: db2agntp (SAMPLE) 30  *
    * FUNCTION: DB2 UDB, sort/list services, sqlsusda, probe:50    *
    * MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."  *
    *           DIA8312C Disk was full.                            *
    * DATA #1 : String, 14 bytes                                   *
    * SRT file error                                               *
    * DATA #2 : Hexdump, 296 bytes                                 *
    * 0x0700000010605310 : 0000 0003 0000 0004 0700 0001 1DBC CC80 *
    * 0x0700000010605320 : 0000 00AA 0000 0000 0700 0000 104F 7A20 *
    * 0x0700000010605330 : 0001 0005 2F64 6232 6461 7461 2F64 6232 *
    * <...skipped...>                                              *
    *                                                              *
    * The stack trace will show stmmStopSortListMonitorOnFailure() *
    * near the top of the stack:                                   *
    *                                                              *
    *                                                              *
    * <StackTrace>                                                 *
    * @102@3@stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SL
    * + 0x460                                                      *
    * .sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo_fdprpro_clone_1685 +    *
    * 0x3C                                                         *
    * </StackTrace>                                                *
    *                                                              *
    * <StackTrace>                                                 *
    * stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SLDE    *
    * sqlsinsr__FP8sqeAgentPcPUcP12sqlri_vectorPP10SQLD_VALUE +    *
    * 0x44                                                         *
    * sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo + 0x44                   *
    * sqlrisr2__FP8sqlrr_cb + 0xFC                                 *
    * sqlischf__FP7SQLI_CBUsUi + 0x184                             *
    * sqliFirstTreeSearch__FP7SQLI_CBP11SQLI_SFGLOB + 0x4C         *
    * sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQL
    * sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID + 0x38                 *
    * sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID@glueC17 + 0x70         *
    * sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RI
    * sqlritaSimplePerm__FP8sqlrr_cb - 0x4C8                       *
    * sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x30  *
    * sqlrihsjn__FP8sqlrr_cb + 0xC                                 *
    * sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C  *
    * sqlrihsjn__FP8sqlrr_cb + 0xC                                 *
    * sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C  *
    * sqlrihsjn__FP8sqlrr_cb + 0xC                                 *
    * sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x814          *
    * sqlrr_dss_router__FP8sqlrr_cb + 0x464                        *
    * sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF68    *
    * sqleSubRequestRouter__FP8sqeAgentPUiT2 + 0x7E8               *
    * sqleProcessSubRequest__FP8sqeAgent + 0x120                   *
    * RunEDU__8sqeAgentFv + 0x300                                  *
    * EDUDriver__9sqzEDUObjFv + 0x94                               *
    * sqloEDUEntry + 0x57C                                         *
    * </StackTrace>                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v97fp3 or later.                                  *
    ****************************************************************
    

Problem conclusion

  • This problem is first fixed in version 9.7 fixpack 3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68205

  • 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

    2010-04-27

  • Closed date

    2010-09-24

  • Last modified date

    2010-09-24

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

    IC65541

  • 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

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC68205

Modified date: 24 September 2010