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 IT18162 Status: Closed

DB2LOGGR TRAPPED WITH SIGSEGV ON SQLPGSWITCHFROMREDOTOUNDO

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
db2loggr trapped with sigsegv and the following entries in
db2diag.log:

2016-11-05-21.59.23.435076-300 I5044E398           LEVEL:
Warning
PID     : 18910                TID  : 46914305255744PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
EDUID   : 88                   EDUNAME: db2hadrs (SAMPLE) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrSDoTakeover, probe:47001
MESSAGE : Info: Standby has initiated a takeover.

2016-11-05-21.59.24.712560-300 I5443E400           LEVEL:
Warning
PID     : 18910                TID  : 46914305255744PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
EDUID   : 88                   EDUNAME: db2hadrs (SAMPLE) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrSDoTakeover, probe:47042
MESSAGE : Info: Standby switching roles to primary.

2016-11-05-21.59.24.715694-300 I5844E429           LEVEL: Info
PID     : 18910                TID  : 46912879192384PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
EDUID   : 29                   EDUNAME: db2loggr (SAMPLE) 0
FUNCTION: DB2 UDB, recovery manager, sqlpgSwitchFromRedoToUndo,
probe:842
DATA #1 : 
TailIndex 0  firstLso 26575520001  nextLso 26578272270
logGapSize 0

2016-11-05-21.59.24.715888-300 I6274E409           LEVEL: Info
PID     : 18910                TID  : 46912879192384PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
EDUID   : 29                   EDUNAME: db2loggr (SAMPLE) 0
FUNCTION: DB2 UDB, recovery manager, sqlpgSwitchFromRedoToUndo,
probe:1800
DATA #1 : 
Create Last Log, FileCount is 1, TailIndex is 0

2016-11-05-21.59.25.004842-300 I6684E429           LEVEL:
Warning
PID     : 18910                TID  : 46912879192384PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
EDUID   : 29                   EDUNAME: db2loggr (SAMPLE) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdEDUIsInDB2KernelOperation, probe:600
DATA #1 : String, 30 bytes
_Z25sqlpgSwitchFromRedoToUndo
DATA #2 : String, 4 bytes
sqlp

2016-11-05-21.59.25.005346-300 I7114E487           LEVEL: Severe
PID     : 18910                TID  : 46912879192384PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
EDUID   : 29                   EDUNAME: db2loggr (SAMPLE) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdResilienceIsSafeToSustain, probe:800
DATA #1 : String, 37 bytes
Trap Sustainability Criteria Checking
DATA #2 : Hex integer, 8 bytes
0x200000000000884C
DATA #3 : Boolean, 1 bytes
false

In the trap file following stack can be found

Stack #1             Signal #11        Timestamp
2016-11-05-21.59.24.796742
0        ossDumpStackTraceEx
1        OSSTrapFile::dumpEx
2        sqlo_trce
3        sqloEDUCodeTrapHandler
4        __pthread_mutex_cond_lock
5        sqlpgSwitchFromRedoToUndo
6        sqlpgasn
7        sqloEDUEntry
8        pthread_create@@GLIBC_2.2.5
9        clone
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* This is currently a limitation                               *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
30.11.2016
08.05.2017
08.05.2017
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)