DB2 - Problem description
Problem IT41265 | Status: Closed |
HADR PRIMARY MIGHT CAUSE A TRAP WHEN PROCESS IS SLOW AND PEER WAIT LIMIT REACHED | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Hadr primary might cause a trap when process is slow and peer wait limit reached. This problem only occurs when DB2_HADR_PEER_WAIT_LIMIT is configured. The following is a sample stack of the trap: -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007FAB035C3036 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0356 (/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00007FAB035C2C7B ossDumpStackTraceV98 + 0x002b (/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00007FAB035BEA27 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00d7 (/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00007FAB0AE7ECB9 sqlo_trce + 0x03e9 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FAB0AFF2AE1 sqloEDUCodeTrapHandler + 0x03d1 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FAB12C535D0 address: 0x00007FAB12C535D0 ; dladdress: 0x00007FAB12C44000 ; offset in lib: 0x000000000000F5D0 ; (/lib64/libpthread.so.0) 0x00007FAB0517D03F _ZN6hdrEdu17hdrEduAcceptEventEP8HDR_DBCBP14HDR_EVENT_TYPEPP11HDR _HDR_MSGPP8HDR_RQST + 0x073f (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FAB05187E7E _ZN6hdrEdu7hdrEduPEbPm + 0x0eee (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FAB05179431 _ZN6hdrEdu11hdrEduEntryEv + 0x0b51 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FAB05178857 _ZN6hdrEdu6RunEDUEv + 0x0027 (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FAB0CADAE4E _ZN9sqzEDUObj9EDUDriverEv + 0x01be (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FAB0AFEFFBA sqloEDUEntry + 0x057a (/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007FAB12C4BDD5 address: 0x00007FAB12C4BDD5 ; dladdress: 0x00007FAB12C44000 ; offset in lib: 0x0000000000007DD5 ; (/lib64/libpthread.so.0) 0x00007FAB025C0EAD clone + 0x006d (/lib64/libc.so.6) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade Db2 to v11.5.8.0 or latest version * **************************************************************** | |
Local Fix: | |
Unset DB2_HADR_PEER_WAIT_LIMIT register variable. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade Db2 to v11.5.8.0 or latest version * **************************************************************** | |
Comment | |
Upgrade Db2 to v11.5.8.0 or latest version | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.06.2022 08.07.2022 01.08.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |