IT32155: DB2 INSTANCE MIGHT PANIC WHILE RUNNING QUERIES INVOLVING A SORT OPERATOR

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When running a query involving one or more SORT operators, the
  instance may trap with the following entry and stack in
  db2diag.log:
  
  2020-01-29-11.12.03.452674-300 E522463E3232          LEVEL:
  Severe (OS)
  PID     : 4129                 TID : 47244791244544  PROC :
  db2sysc 0
  INSTANCE: XXXXXXXX             NODE : 000            DB   : XXXX
  APPHDL  : 0-37515              APPID:
  X.X.X.X.47484.200129155118
  AUTHID  : XXXXXXXX             HOSTNAME: XXXXXXXX
  EDUID   : 13248                EDUNAME: db2agnts (XXXX) 0
  FUNCTION: DB2 UDB, SQO Latch Tracing,
  SQLO_SLATCH_CAS64::getConflictComplex, probe:210
  MESSAGE :
  ZRC=0x870F00FB=-2029059845=SQLO_SLATCH_ERROR_HELDX_WITH_SHARED_H
  OLDERS
            "shared latch found with both exclusive and shared
  holders.  Latch likely corrupt."
  CALLED  : OS, -, unspecified_system_function
  DATA #1 : String, 13 bytes
  invalid latch
  DATA #2 : File name, 16 bytes
  sqloLatchCAS64.C
  DATA #3 : Source file line number, 8 bytes
  592
  DATA #4 : Codepath, 8 bytes
  0
  DATA #5 : String, 131 bytes
  0x00002AD2F8A90030: {
     held X: 1
     reserved for X: 0
     shared holders: 48
     firstSharIndex: 0xD2F8A
     firstExclIndex: 0x15
  }
  DATA #6 : LatchMode, PD_TYPE_LATCH_MODE, 8 bytes
  0x10000 (SQLO_LATCH_MODE_EXCLUSIVE)
  DATA #7 : String, 395 bytes
  {
     state         = 0x00002AD2F8A90030
                   = {
                         held X: 1
                         reserved for X: 0
                         shared holders: 48
                         firstSharIndex: 0xD2F8A
                         firstExclIndex: 0x15
                     }
     starve X mode = true
     xWaitCount    = 52928
     requestCount  = 0
     identity      = unknown (3506)
  }
  DATA #8 : Pointer, 8 bytes
  0x00002ae17c740000
  DATA #9 : Hexdump, 16 bytes
  0x00002AE17C740000 : 3000 A9F8 D22A 0000 B20D C0CE 0000 0000
  0....*..........
  CALLSTCK: (Static functions may not be resolved correctly, as
  they are resolved to the nearest symbol)
    [0] 0x00002AAAB127954D
  _ZNK17SQLO_SLATCH_CAS6420dumpDiagInfoAndPanicEPKcjmmlmiS1_mi +
  0x2AD
    [1] 0x00002AAAB22EB65D
  _ZN17SQLO_SLATCH_CAS6418getConflictComplexEm + 0x8ED
    [2] 0x00002AAAAC37C31B
  /var/ibmdb2/nypit348/sqllib/lib64/libdb2e.so.1 + 0x129031B
    [3] 0x00002AAAAC37CC26 _Z13sqlbUnfixPageP11SQLB_FIX_CB + 0x636
    [4] 0x00002AAAAF839A32
  _Z13sqlsUnfixPageP10SQLS_SLDESP14SQLD_FILE_INFOm + 0xB2
    [5] 0x00002AAAAF83D994 _Z8sqlsfshpP8sqeAgentP10SQLS_SLDES +
  0xF44
    [6] 0x00002AAAAF829D53 _Z7sqlsendP8sqeAgentP10SQLS_SLDESi +
  0x53
    [7] 0x00002AAAAF82450C _Z8sqlsclosP8sqeAgentPP8SQLD_CCBPc +
  0x11C
    [8] 0x00002AAAAF668206 _Z9sqlrsclosP8sqlrr_cbP9sqlri_tao +
  0x386
    [9] 0x00002AAAB2341274 _Z8sqlricloP8sqlrr_cbP9sqlri_taoi +
  0x554
    [10] 0x00002AAAB234930A _Z7sqlritaP8sqlrr_cb + 0x28A
    [11] 0x00002AAAB2342246
  _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x196
    [12] 0x00002AAAAF479AC3 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x173
    [13] 0x00002AAAAF478B41
  _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x591
    [14] 0x00002AAAAE26E77D
  /var/ibmdb2/nypit348/sqllib/lib64/libdb2e.so.1 + 0x318277D
    [15] 0x00002AAAAE26D22C _Z21sqleProcessSubRequestP8sqeAgent +
  0x2EC
    [16] 0x00002AAAAE288B72 _ZN8sqeAgent6RunEDUEv + 0x4C2
    [17] 0x00002AAAAFAC3A47 _ZN9sqzEDUObj9EDUDriverEv + 0xF7
    [18] 0x00002AAAAF26F4E3 sqloEDUEntry + 0x303
    [19] 0x00002AAAAAED6AA1 /lib64/libpthread.so.0 + 0x7AA1
    [20] 0x00002AAAB8183C4D clone + 0x6D
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to db2_v111m4fp6 or later                            *
  ****************************************************************
  

Problem conclusion

• Upgrade to db2_v111m4fp6 or later
  

Temporary fix

Comments

APAR Information

• 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

• RB10 PSN

     UP