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) |