IBM Support

IC65541: 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(suchas disk full when the sort spills to a temp        *
    * tablespace, orotherlegitimate others) might segfault and     *
    * bring down theinstance.You will likely see some kind of      *
    * legitimate sort relatederror,like                            *
    * so:2010-01-01-19.45.03.278076+480 I45881212A2803             *
    * LEVEL:SeverePID    : 471692              TID  : 14788        *
    * PROC :db2sysc30INSTANCE: db2inst1              NODE : 030    *
    *     DB  :SAMPLEAPPHDL  : 0-4287                              *
    * APPID:132.228.87.19.40456.09122910292AUTHID  : DB2INST1EDUID *
    *  : 14788                EDUNAME: db2agntp (SAMPLE)           *
    * 30FUNCTION: DB2 UDB, sort/list services, sqlsusda,           *
    * probe:50MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk *
    * full."DIA8312C Disk was full.DATA #1 : String, 14 bytesSRT   *
    * file errorDATA #2 : Hexdump, 296 bytes0x0700000010605310 :   *
    * 0000 0003 0000 0004 0700 0001 1DBC CC800x0700000010605320 :  *
    * 0000 00AA 0000 0000 0700 0000 104F 7A200x0700000010605330 :  *
    * 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__FP8
    * 0x460.sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo_fdprpro_clone_1685 *
    * +0x3C</StackTrace><StackTrace>stmmStopSortListMonitorOnFailure
    * +0x44sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo +                   *
    * 0x44sqlrisr2__FP8sqlrr_cb + 0xFCsqlischf__FP7SQLI_CBUsUi +   *
    * 0x184sqliFirstTreeSearch__FP7SQLI_CBP11SQLI_SFGLOB +         *
    * 0x4Csqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP1
    * + 0x38sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID@glueC17 +        *
    * 0x70sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQL
    * - 0x4C8sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA  *
    * + 0x30sqlrihsjn__FP8sqlrr_cb +                               *
    * 0xCsqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA +    *
    * 0x3Csqlrihsjn__FP8sqlrr_cb +                                 *
    * 0xCsqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA +    *
    * 0x3Csqlrihsjn__FP8sqlrr_cb +                                 *
    * 0xCsqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm -             *
    * 0x814sqlrr_dss_router__FP8sqlrr_cb +                         *
    * 0x464sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T +     *
    * 0xF68sqleSubRequestRouter__FP8sqeAgentPUiT2 +                *
    * 0x7E8sqleProcessSubRequest__FP8sqeAgent +                    *
    * 0x120RunEDU__8sqeAgentFv + 0x300EDUDriver__9sqzEDUObjFv +    *
    * 0x94sqloEDUEntry + 0x57C</StackTrace>                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to version 9.5 fix pack 6 or later.                   *
    ****************************************************************
    

Problem conclusion

  • This problem is first fixed in version 9.5 fix pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC65541

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-01-12

  • Closed date

    2010-05-25

  • Last modified date

    2010-05-25

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

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

    IC68205 IC68206

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 May 2010