suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT30592 Status: Closed

DB2LOGGR MAY TRAP AND SIGSEGV DUE TO OVERSHOOT BUFFERSIZE MEMORY

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem 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   : CXL1
HOSTNAME: cxl3csdp02
EDUID   : 42455                EDUNAME: db2loggr (CXL1) 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   : CXL1
HOSTNAME: cxl3csdp02
EDUID   : 42455                EDUNAME: db2loggr (CXL1) 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: cxl3csdp02
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: cxl3csdp02
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: cxl3csdp02
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: cxl3csdp02
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
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 10.FP11                                       *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.10.2019
25.02.2020
25.02.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)