|
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
DB2 Version 10.5 Fix Pack 9 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
|
 |
