https://github.com/famousdraw

IT24765: TIMING ISSUE IN PACKAGE CACHE WORKSPACE MAY CAUSE PANIC

IT24765: TIMING ISSUE IN PACKAGE CACHE WORKSPACE MAY CAUSE PANIC

https://www.ibm.com/mysupport/s/defect/aCI0z0000004vGZ/dt076912?language=fi

  • There is a timing issue where there is a brief moment in time   
    that the state of a sibling entry in package cache workspace can
    be set to a particular state outside of latch control, so the   
    entry might be reused or freed up from the lru lists in the     
    cache by someone else, as a result, panic may happen due to     
    memory corruption.                                              
                                                                    
    The stack can be vary:                                          
                                                                    
    Stack 1:                                                        
     sqle_panic                                                     
     sqloCrashOnCriticalMemoryValidationFailure                     
     SQLO_MEM_POOL::diagnoseMemoryCorruptionAndCrash                
     sqloDiagnoseFreeBlockFailure                                   
     sqlofmblkEx                                                    
     sqlra_sqlW_mem_free_sibling_list                               
     sqlra_sqlW_mem_freespace                                       
     sqlra_sqlW_check_for_cleanup                                   
     sqlra_sqlW_get_dynamic_section_new                             
     sqlra_load_var                                                 
     sqlra_get_var                                                  
     sqlrr_execimmd                                                 
     sqlrr_execimmd                                                 
                                                                    
    Stack 2:                                                        
                                                                    
    PID     : 1704972              TID : 79974          PROC :      
    db2sysc 0                                                       
    INSTANCE: db2inst1             NODE : 000           DB   :      
    SAMPLE                                                          
    APPHDL  : 0-360                APPID:                           
    *LOCAL.db2inst1.180203112927                                    
    AUTHID  : DB2INST1             HOSTNAME: MYHOST                 
    EDUID   : 79974                EDUNAME: db2agent (SAMPLE) 0     
    FUNCTION: DB2 UDB, SQO Latch Tracing,                           
    SQLO_SLATCH_CAS64::getConflictComplex, probe:210                
    MESSAGE :                                                       
    ZRC=0x870F00FD=-2029059843=SQLO_SLATCH_ERROR_HELDS_WITH_SHARED_W
    AITER                                                           
              "A latch with X starvation policy should StarveX latch
    should not be held shared and have a shared waiter."            
    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, 136 bytes                                     
    0xFAB0A00020002EA0:                                             
       held X: 0                                                    
       reserved for X: 0                                            
       shared holders: 11936                                        
       firstSharIndex: 0x200                                        
       firstExclIndex: 0x1D5850                                     
                                                                   
    DATA #6 : LatchMode, PD_TYPE_LATCH_MODE, 8 bytes                
    0x10000 (SQLO_LATCH_MODE_EXCLUSIVE)                             
    DATA #7 : String, 397 bytes                                     
                                                                   
       state         = 0xFAB0A00020002EA0                           
                     =                                              
                           held X: 0                                
                           reserved for X: 0                        
                           shared holders: 11936                    
                           firstSharIndex: 0x200                    
                           firstExclIndex: 0x1D5850                 
                                                                    
       starve X mode = true                                         
       xWaitCount    = 0                                            
       requestCount  = 0                                            
       identity      = NO_IDENTITY (0)                              
                                                                   
    DATA #8 : Pointer, 8 bytes                                      
    0x0a00020002ede448                                              
    DATA #9 : Hexdump, 16 bytes                                     
    0x0A00020002EDE448 : FAB0 A000 2000 2EA0 0A00 0200 02ED E108    
    .... ...........                                                
    CALLSTCK: (Static functions may not be resolved correctly, as   
    they are resolved to the nearest symbol)                        
      [0] 0x090000000DC8088C                                        
    dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
    3T7 + 0x2FC                                                     
      [1] 0x090000000CA0C814                                        
    getConflictComplex__17SQLO_SLATCH_CAS64FCUl + 0xE8C             
      [2] 0x090000000CE80D54 getConflict__17SQLO_SLATCH_CAS64FCUl + 
    0x118                                                           
      [3] 0x090000000B8D9F2C                                        
    sqlra_sqlW_mem_freespace__FP8sqlrr_cbUlPUli + 0x1C4             
      [4] 0x090000000B8A561C                                        
    sqlra_sqlW_check_for_cleanup__FP8sqlrr_cbUlP7OSSTick + 0x264    
      [5] 0x090000000B899D7C                                        
    sqlra_sqlW_get_dynamic_section_new__FP8sqlrr_cbP16sqlra_cached_v
    ar + 0x14B8                                                     
      [6] 0x090000000B89ADF8                                        
    sqlra_load_var__FP8sqlrr_cbP16sqlra_cached_varP14SQLP_LOCK_INFOP
    b + 0xAC                                                        
      [7] 0x090000000B89AA8C sqlra_get_var__FP8sqlrr_cbiT2bPbT5 +   
    0x884                                                           
      [8] 0x090000000C587808                                        
    sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x114            
      [9] 0x090000000C587B10                                        
    sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x41C            
    Show less

  •  

    ****************************************************************

    * USERS AFFECTED:                                              *

    * N/A                                                          *

    ****************************************************************

    * PROBLEM DESCRIPTION:                                         *

    * See Error Description                                        *

    ****************************************************************

    * RECOMMENDATION:                                              *

    * Upgrade to Db2 v10.5 FP10 or later.                          *

    ****************************************************************

     

  • The problem is firstly fixed on Db2 v10.5 FP10.                 

 

Status

Closed

Programming Error - Fix provided (PER)

Subscribe

By subscribing, you receive periodic emails alerting you to the status of the known issue, along with a link to the fix after it becomes available.

Notify me when a known issue for this product changes

Manage my notifications
  • Product

    Db2 Linux, Unix and Windows

    Software version

    10.5

    Document number

    DT076912

    Last modified

    2024年2月26日 GMT+8 14:38

  • APAR Number

    IT24765

    Reported component id

    DB2FORLUW

    Reported component release

    A50

    Status

    Closed

    PTF in error

    NoPE

    HIPER:

    NoHIPER

    Special attention

    NoSpecatt

    -Product Specific

    Submitted date:

    2018年4月17日 GMT+8 11:00

    Closed date:

    2018年7月12日 GMT+8 11:00

    Last modified date:

    2024年2月26日 GMT+8 14:38

     

    ------------------------------------------------------------------------------------------
    如果你觉得文章有用,欢迎打赏

     

posted on 2024-03-25 10:08  红色MINI  阅读(88)  评论(0编辑  收藏  举报

导航