| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC98122 | Status: Closed |
DB2 may trap or abend if an error is encountered during a shared index or table scan | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
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 Summary: | |
**************************************************************** * 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 | |
| available fix packs: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
| Solution | |
fixed in db2 version 105 fix pack 3 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.12.2013 08.09.2014 08.09.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.4 |
|
