DB2 - Problembeschreibung
Problem IC98122 | Status: Geschlossen |
DB2 may trap or abend if an error is encountered during a shared index or table scan | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
This issue may happen during error handling while the shared scanner is working a table scan or index scan. The issue is a crash deferencing a NULL ptr. <Trap> <Header> DB2 build information: DB2 v10.5.0.2 n130612 SQL10050 timestamp: 2013-06-14-14.25.20.536467 instance name: xiaeg1.000 EDU name : db2agent (FVTDB) [R] EDU ID : 156 Signal #11 uname: S:Linux R:2.6.16.60-0.85.1-smp V:#1 SMP Thu Mar 17 11:45:06 UTC 2011 M:x86_64 N:hotelfvt07 process id: 7227 parent process id: 7225 thread id : 46913114073408 (0x2AAACF7FE940) kthread id : 7743 </Header> <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00002AAAC00A72BD _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0465 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2osse.so.1) 0x00002AAAC00A7B13 ossDumpStackTraceV98 + 0x0071 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2osse.so.1) 0x00002AAAC00A0A86 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x03b2 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2osse.so.1) 0x00002AAAB616F743 sqlo_trce + 0x0685 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB63249BB sqloEDUCodeTrapHandler + 0x0643 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAABD4D60 address: 0x00002AAAAABD4D60 ; dladdress: 0x00002AAAAABC7000 ; offset in lib: 0x000000000000DD60 ; (/lib64/libpthread.so.0) 0x00002AAAAE162FE8 _Z24sqldInsertScannerIntoSGMP13SQLD_DFM_WORKP8SQLD_TCBP9SQLD_IXC BP10SQLI_IXPCRmmmiljiPiPl + 0x09c6 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAADDBEFE9 _Z29sqldInsertTableScannerIntoSGMP13SQLD_DFM_WORKP8SQLD_TCBmmmii PiPj + 0x00a5 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAADDC224F _Z25sqldSetupSharingScanInSGMP8sqeAgentP8SQLD_CCBP13SQLD_DFM_WOR KmP10SQLI_IXPCRP9SQLD_IXCBtmhijfi + 0x0e67 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAADF456B5 address: 0x00002AAAADF456B5 ; dladdress: 0x00002AAAAACE0000 ; offset in lib: 0x00000000032656B5 ; (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAADF4890A _Z12sqldScanOpenP8sqeAgentP14SQLD_SCANINFO1P14SQLD_SCANINFO2PPv + 0x3244 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB742DBE3 _Z8sqlriopnP8sqlrr_cbP9sqlri_taoPi + 0x17fd (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB769ED7B _Z17sqlritaSimplePermP8sqlrr_cb + 0x03b7 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB740BAA0 _Z15sqlriExecThreadP8sqlrr_cbP12sqlri_opparm + 0x0a84 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB75032CB _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x191f (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB6CF7418 _Z27sqlrr_process_fetch_requestP14db2UCinterface + 0x13dc (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB6CEA6B7 _Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x189f (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB3F34949 _Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x0219 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB3F1ED62 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x035c (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB3F2083D _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x02a1 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB3F12BF5 address: 0x00002AAAB3F12BF5 ; dladdress: 0x00002AAAAACE0000 ; offset in lib: 0x0000000009232BF5 ; (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB3F1505E address: 0x00002AAAB3F1505E ; dladdress: 0x00002AAAAACE0000 ; offset in lib: 0x000000000923505E ; (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB3F0FEA6 address: 0x00002AAAB3F0FEA6 ; dladdress: 0x00002AAAAACE0000 ; offset in lib: 0x000000000922FEA6 ; (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB3F0F57F _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x028b (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB3645FFE _ZN8sqeAgent6RunEDUEv + 0x0588 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB8C4DBEE _ZN9sqzEDUObj9EDUDriverEv + 0x0182 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB8C4D834 _Z10sqlzRunEDUPcj + 0x0026 (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAB632284D sqloEDUEntry + 0x0a5d (/home/hotelfvt07/xiaeg1/sqllib/lib64/libdb2e.so.1) 0x00002AAAAABCD193 address: 0x00002AAAAABCD193 ; dladdress: 0x00002AAAAABC7000 ; offset in lib: 0x0000000000006193 ; (/lib64/libpthread.so.0) 0x00002AAAC0AD90DD __clone + 0x006d (/lib64/libc.so.6) </StackTrace> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * * * * The trapping function is sqldInsertScannerIntoSGM(). The * * ptr is 'scanner'. * **************************************************************** * RECOMMENDATION: * * upgrade to db2 version 105 fix pack 3 * **************************************************************** | |
Local-Fix: | |
N/A | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
fixed in db2 version 105 fix pack 3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.12.2013 08.09.2014 08.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |