DB2 - Problem description
Problem IT36046 | Status: Closed |
PANIC MAY OCCUR IN HADR TAKEOVER | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
On Db2 V11.1 modpack4 fixpack 5, a user may experience FODC Panic during HADR Takeover. 2019-12-26-20.20.24.454257-300 I160876693E1965 LEVEL: Severe PID : 23806 TID : 140277369005824 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-17 APPID: *LOCAL.DB2.191226132031 HOSTNAME: test111 EDUID : 111 EDUNAME: db2redom (SAMPLE) 0 FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10 DATA #1 : sqle_panic: Panic/sleep = 0x0, flags = 0x0 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007FA8C62149CD pdLogPrintf + 0x8D [1] 0x00007FA8C9E5CE8D _Z10sqle_panici + 0x52D [2] 0x00007FA8CC62245D _Z19sqlra_sqlcache_termP7sqlr_db + 0x24D [3] 0x00007FA8C5ED4C9A _Z18hdrCleanupDbCachesP16sqeLocalDatabase + 0xFA [4] 0x00007FA8C9FA0D52 _ZN16sqeLocalDatabase33HdrCleanupCacheInReplayOnlyWindowEP8sqeAg ent + 0x6F2 [5] 0x00007FA8C9F9FE88 _ZN16sqeLocalDatabase22HdrEndReplayOnlyWindowEP8sqeAgent + 0x68 [6] 0x00007FA8CBFDFF12 _Z29sqlpRemoveEntryFromTransTableP8sqeAgentP9SQLP_DBCBRK9SQLP_LS N8P11SQLP_TENTRY + 0x302 [7] 0x00007FA8CBFCC803 _Z15sqlprProcDPSrecP10SQLPR_PRCBjP20SQLPR_PR_QUEUE_ENTRY + 0x433 [8] 0x00007FA8CBFF13C5 _Z18sqlprProcDpsQEntryP10SQLPR_PRCBb + 0x3B5 [9] 0x00007FA8CC023ED4 _Z24sqlpshrLogMergeIterationP8sqeAgentP17SQLPSHR_MASTER_CBmPmS3_ S3_ + 0x14B4 [10] 0x00007FA8CC01F4C8 _Z15sqlpshrScanNextPvP8sqeAgentmPP16SQLPR_LOGREC_DISPm + 0xD88 [11] 0x00007FA8CBFCAF5C _Z15sqlpPRecReadLogP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb + 0x621C [12] 0x00007FA8CBF92F36 _Z20sqlpParallelRecoveryP8sqeAgentP5sqlca + 0xCA6 [13] 0x00007FA8C9E4C4DC _Z26sqleSubCoordProcessRequestP8sqeAgent + 0x17C [14] 0x00007FA8C9E6934E _ZN8sqeAgent6RunEDUEv + 0x5AE [15] 0x00007FA8CD79A4BE _ZN9sqzEDUObj9EDUDriverEv + 0x1BE [16] 0x00007FA8CBCBB7BA sqloEDUEntry + 0x57A [17] 0x00007FA8D38A3EA5 /lib64/libpthread.so.0 + 0x7EA5 [18] 0x00007FA8C32CC8CD clone + 0x6D Stack #1 Signal #6 Timestamp 1577409624.498646000 0 ossDumpStackTraceInternal 1 ossDumpStackTraceV98 2 OSSTrapFile::dumpEx 3 sqlo_trce 4 sqloEDUCodeTrapHandler 5 __sigsuspend 6 gsignal 7 abort 8 sqloExitEDU 9 sqle_panic 10 sqlra_sqlcache_term 11 hdrCleanupDbCaches 12 sqeLocalDatabase::HdrCleanupCacheInReplayOnlyWindow 13 sqeLocalDatabase::HdrEndReplayOnlyWindow 14 sqlpRemoveEntryFromTransTable 15 sqlprProcDPSrec 16 sqlprProcDpsQEntry 17 sqlpshrLogMergeIteration 18 sqlpshrScanNext 19 sqlpPRecReadLog 20 sqlpParallelRecovery 21 sqleSubCoordProcessRequest 22 sqeAgent::RunEDU 23 sqzEDUObj::EDUDriver 24 sqloEDUEntry 25 pthread_detach 26 clone | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Local Fix: | |
NA | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5.6 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.02.2021 09.06.2021 09.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |