DB2 - Problem description
Problem IT29417 | Status: Closed |
SNAPSHOT MONITOR TRAPPED IN FUNCTION SQLPLGETLOCKWAITINFO() | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
When collecting monitoring data via the GET SNAPSHOT command, there is a small timing window that can cause Db2 server to trap. The following is a sample stack for this trap. -----Frame------ ------Address----- ------Function + Offset------ 0x00001019E67EA6E0 0x000010000E305510 _Z20sqlplGetLockWaitInfoPK14sqeApplicationP9sqeBsuEduP8sqeAgentj PjP14sqlm_timestampP8SQLP_LRBP18sqlm_int_lock_waitPmS6_RK8sqlo_g mtb + 0x0690 ( = offset 0xDF95510 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EA9F0 0x000010000C1936F8 _Z20sqm_write_lock_waitsP14sqeApplicationPK16sqm_agent_entityPK1 6sqeLocalDatabasejRK8sqlo_gmtP19sqm_snapshot_bufferPjP14sqlm_tim estampPmSC_SF_hP16sqlm_header_info + 0x04d8 ( = offset 0xBE236F8 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EAE60 0x000010000C199110 ( = offset 0xBE29110 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EAFE0 0x000010000C183CC4 ( = offset 0xBE13CC4 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EB090 0x000010000C180AEC ( = offset 0xBE10AEC in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EC340 0x000010000C176AE4 _Z12sqlmonssagntj13sqm_entity_idP6sqlmaijPvP14sqlm_collectedttP5 sqlca + 0x2cb4 ( = offset 0xBE06AE4 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67ED500 0x000010000C152318 _Z20sqlmPdbRequestRouterP8sqeAgent + 0x0a18 ( = offset 0xBDE2318 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EDAB0 0x000010000B2AE040 ( = offset 0xAF3E040 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EDD10 0x000010000B2A76F8 _Z21sqleProcessSubRequestP8sqeAgent + 0x22c8 ( = offset 0xAF376F8 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EE120 0x000010000B328608 _ZN8sqeAgent6RunEDUEv + 0x09d8 ( = offset 0xAFB8608 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EE2F0 0x000010001082FFBC _ZN9sqzEDUObj9EDUDriverEv + 0x025c ( = offset 0x104BFFBC in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EE3B0 0x000010001082FD3C _Z10sqlzRunEDUPcj + 0x001c ( = offset 0x104BFD3C in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EE3D0 0x000010000E2761E8 sqloEDUEntry + 0x09c8 ( = offset 0xDF061E8 in /head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00001019E67EE790 0x0000100000088AF4 ( = offset 0x8AF4 in /lib64/libpthread.so.0) 0x00001019E67EEA10 0x0000100016CC8814 clone + 0x00e4 ( = offset 0x128814 in /lib64/libc.so.6) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * monitor a trapped * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * update to v11.1.4 fp5 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.06.2019 20.10.2019 20.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |