IBM Support

IT06778: CRASH IN SQLEX_FIND_GROUP WHEN CUMULATIVE LENGTH OF GROUP NAMES RETURNED FOR AN USER ID IS GREATER THEN 64K

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • There is a potential for a crash in  sqlex_find_group when
    cumulative length of group names  returned for an user id is
    greater then 64K.
    
    Stack similar to:
    DB2 build information: DB2 v9.7.0.6 special_30249 SQL09076
    timestamp: 2015-01-23-10.14.28.601216
    instance name: db2inst1.000
    EDU name     : db2agent (SAMPLE) 0
    EDU ID       : 232
    Signal #11
    uname: S:Linux R:2.6.18-308.13.1.el5 V:#1 SMP Thu Jul 26
    05:45:09 EDT 2012 M:x86_64 N:hz867c1n7
    process id: 25547
    thread id : 46979170167104 (0x2ABA30BFE940)
    </Header>
    <SignalDetails>
    <Siginfo_t length="128">
    Signal #11 (SIGSEGV): si_addr is 0x0000000000000000, si_code is
    0x00000080 (SI_KERNEL:Send by kernel.)
    </SignalDetails>
    <ResourceLimits>
    Data seg top [sbrk(0)] = 0x0000000002704000
    Cur cpu time limit (seconds)  = 0xFFFFFFFF
    Cur file limit (bytes)  = 0xFFFFFFFF
    Cur data size (bytes)  = 0xFFFFFFFF
    Cur stack size (bytes) = 0x00A00000
    Cur core size (bytes)  = 0x3D090000
    Cur nofiles (descriptors)  = 0x0000FFFE
    Cur memory size (bytes)  = 0xFFFFFFFF
    </ResourceLimits>
    <Registers>
       rax 0x0000000000000000  rbx 0x6f743c3e656d6974
       rcx 0x0000000000006f63  rdx 0x0000000000000024
    
    rbp 0x6d6d6f635f6c6174  rsp 0x00002aba30bf23f8
       rsi 0x00002aba30bf2344  rdi 0x00002aba30bf22c0
    rflags 0x0000000000010202  rip 0x00002aaaabff567f
       r8  0x0000000000000002  r9  0x0000000000000002
       r10 0x00002aaab3b90406  r11 0x000000000041830a
       r12 0x3e656d69745f7469  r13 0x6c61746f742f3c30
       r14 0x0000000000000000  r15 0x5f74696d6d6f635f
    </Registers>
    <POFDisassembly>
     _Z16sqlex_find_groupPc14sqlo_mem_descr + 0x0203
    (/var/ibmdb2/db2inst1/sq
    llib/lib64/libdb2e.so.1)
    
            0x00002AAAABFF567F : C3BD06000020EBE7
    </POFDisassembly>
    <StackTrace>
    
    
    Diag log  entry
    
    
    2015-01-23-10.14.29.098656-300 I953892E519         LEVEL: Severe
    PID     : 25547                TID  : 46979170167104PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-42121              APPID:
    10.184.115.248.36738.1501231514
    AUTHID  : ETLMIGP
    EDUID   : 232                  EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, RAS/PD component,
    pdEDUIsInDB2KernelOperation, probe:180
    MESSAGE : Stack analysis failed due to incomplete  'StackTrace'
    section in trap
              file.
    
    2015-01-23-10.14.29.099039-300 I954412E527         LEVEL: Severe
    PID     : 25547                TID  : 46979170167104PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-42121              APPID:
    10.184.115.248.36738.1501231514
    AUTHID  : ETLMIGP
    EDUID   : 232                  EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, RAS/PD component,
    pdEDUIsInDB2KernelOperation, probe:190
    MESSAGE : Stack analysis failed, which implies stack corruption
    or failed to do
              'stack walk'.
    
    
    ====================================
    

Local fix

  • Reduce the number of groups for the user id
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V9.7 Fix Pack 11                                  *
    ****************************************************************
    

Problem conclusion

  • Upgrade to V9.7 Fix Pack 11
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT06778

  • 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

    2015-01-27

  • Closed date

    2015-10-13

  • Last modified date

    2015-10-13

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

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

    IT06800 IT06801 IT06802

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT06778

Modified date: 13 October 2015