IBM Support

IT37037: DB2LOGGR MAY TRAP AND SIGSEGV DUE TO OVERSHOOT BUFFERSIZE MEMORY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • db2loggr may trap and SIGSEGV due to overshoot bufferSize memory
    . Error reported in db2diag.log is as following:
    
    
    2019-10-01-01.08.31.858661+480 E8460A1216           LEVEL:Severe
    PID     : 25100372             TID : 42455          PROC :
    db2sysc 1
    INSTANCE: db2inst2             NODE : 001           DB   :
    sample
    HOSTNAME: host1
    EDUID   : 42455                EDUNAME: db2loggr (SAMPLE) 1
    FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler,
    probe:90
    MESSAGE : ADM14011C  A critical failure has caused the following
    type of error:
              "Trap". The DB2 database manager cannot recover from
    the failure.
              First Occurrence Data Capture (FODC) was invoked in
    the following
              mode: "Automatic". FODC diagnostic information is
    located in the
              following directory:
    
    "/home/db2inst2/sqllib/db2dump/DIAG0001/FODC_Trap_2019-10-01-01.
    08.30
              .745564_25100372_42455_001/".
    DATA #1 : Signal Number Recieved, 4 bytes
    11
    DATA #2 : Siginfo, 64 bytes
    0x0A0000002180EDC0 : 0000 000B 0000 0000 0000 0032 0000 0000
    ...........2....
    0x0A0000002180EDD0 : 0000 0000 0000 0000 0A00 0000 9E45 1000
    .............E..
    0x0A0000002180EDE0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    0x0A0000002180EDF0 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    
    2019-10-01-01.08.31.861629+480 I9677A710            LEVEL: Event
    PID     : 25100372             TID : 42455          PROC :
    db2sysc 1
    INSTANCE: db2inst2             NODE : 001           DB   :
    SAMPLE
    HOSTNAME: host1
    EDUID   : 42455                EDUNAME: db2loggr (SAMPLE) 1
    FUNCTION: DB2 UDB, oper system services,
    sqloPGRPRegisterOneCrash, probe:2159
    MESSAGE : lastCrashCount
    DATA #1 : unsigned integer, 8 bytes
    0
    DATA #2 : String, 10 bytes
    inRecovery
    DATA #3 : Boolean, 1 bytes
    false
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x090000000A1CB8CC sqloPGRPRegisterOneCrash + 0x1D0
      [1] 0x090000000A1CCCCC sqloEDUCodeTrapHandler + 0xD5C
    
    2019-10-01-01.08.33.714568+480 E10388A593           LEVEL:Severe
    PID     : 23593132             TID : 258            PROC :
    db2wdog 1 [db2inst2]
    INSTANCE: db2inst2             NODE : 001
    HOSTNAME: host1
    EDUID   : 258                  EDUNAME: db2wdog 1 [db2inst2]
    FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:20
    MESSAGE : ADM0503C  An unexpected internal processing error has
    occurred. All DB2 processes associated with this instance have
    been
    shutdown. Diagnostic information has been recorded. Contact IBM
    Support for further assistance.
    
    2019-10-01-01.08.33.716426+480 E10982A472           LEVEL: Error
    PID     : 23593132             TID : 258            PROC :
    db2wdog 1 [db2inst2]
    INSTANCE: db2inst2             NODE : 001
    HOSTNAME: host1
    EDUID   : 258                  EDUNAME: db2wdog 1 [db2inst2]
    FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:9064
    DATA #1 : Process ID, 4 bytes
    25100372
    DATA #2 : Hexdump, 8 bytes
    0x0A000000007FDC58 : 0000 0101 0000 000B
    ........
    
    2019-10-01-01.08.33.717275+480 I11455A434           LEVEL: Info
    PID     : 23593132             TID : 258            PROC :
    db2wdog 1 [db2inst2]
    INSTANCE: db2inst2             NODE : 001
    HOSTNAME: host1
    EDUID   : 258                  EDUNAME: db2wdog 1 [db2inst2]
    FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources,
    probe:5568
    DATA #1 : String, 24 bytes
    Process Termination Code
    DATA #2 : Hex integer, 4 bytes
    0x00000101
    
    2019-10-01-01.08.33.718358+480 I11890A1000          LEVEL: Event
    PID     : 23593132             TID : 258            PROC :
    db2wdog 1 [db2inst2]
    INSTANCE: db2inst2             NODE : 001
    HOSTNAME: host1
    EDUID   : 258                  EDUNAME: db2wdog 1 [db2inst2]
    FUNCTION: DB2 UDB, oper system services, sqlossig, probe:10
    MESSAGE : Sending SIGKILL to the following process id
    DATA #1 : signed integer, 4 bytes
    19267702
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x090000000B18C578 sqlossig + 0xA0
      [1] 0x00000001000189EC
    sqleKillAllPidsFromList__FPP13SQLE_PID_LIST@AF65_2 + 0x4C
      [2] 0x000000010000680C sqleCleanupResources__Fi + 0x1CEC
      [3] 0x0000000100007BF8 sqleWatchDog__FUl + 0x1278
      [4] 0x00000001000020E0 DB2main + 0xE40
      [5] 0x090000000B4FCEBC sqloEDUMainEntry__FPcUi + 0x78
      [6] 0x090000000B501D84 sqloEDUEntry + 0x114
      [7] 0x0900000000546E10 _pthread_body + 0xF0
      [8] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT37037

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-05-26

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

    IT30592

  • 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 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 May 2022