Under rare conditions running an SQL which use XML column can
result in a crash/trap.
Select v_results.* from ( select * from dbqds001.dbs_test)
v_results
inner join ( select distinct QDS_XML_ID
from ( select * from dbqds001.dbs_test )
where planNumber = '12748') v_XML_IDs on v_XML_IDs.qds_xml_id =
v_results.qds_xml_id;
db2diag.log:
2015-03-09-17.18.52.046045+000 I7921691A703 LEVEL: Error
PID : 31654110 TID : 23904 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
DTQDS005
APPHDL : 0-39 APPID:
10.203.114.124.8585.150309171903
AUTHID : DB2INST1 HOSTNAME: db2host1
EDUID : 23904 EDUNAME: db2agent (DTQDS005) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:10
MESSAGE : Error in agent servicing application with APPLICATION
NAME:
DATA #1 : Hexdump, 18 bytes
0x07800000041CA962 : 6462 326A 6363 5F61 7070 6C69 6361 7469
db2jcc_applicati
0x07800000041CA972 : 6F6E
on
2015-03-09-17.18.52.055354+000 I7922395A615 LEVEL:
Severe
PID : 31654110 TID : 23904 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
DTQDS005
APPHDL : 0-39 APPID:
10.203.114.124.8585.150309171903
AUTHID : DB2INST1 HOSTNAME: db2host1
EDUID : 23904 EDUNAME: db2agent (DTQDS005) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdEDUIsInDB2KernelOperation, probe:165
MESSAGE : Message 'Nested signal handlers detected' found in
trap file, which
implies stack corruption or failed to unwind stack
frames.
2015-03-09-17.18.52.060747+000 I7923011A572 LEVEL:
Severe
PID : 31654110 TID : 23904 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
DTQDS005
APPHDL : 0-39 APPID:
10.203.114.124.8585.150309171903
AUTHID : DB2INST1 HOSTNAME: db2host1
EDUID : 23904 EDUNAME: db2agent (DTQDS005) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdEDUIsInDB2KernelOperation, probe:190
MESSAGE : Stack analysis failed, which implies stack corruption
or failed to do
'stack walk'.
31654110.23904.000.trap.txt:
<Header>
DB2 build information: DB2 v10.5.0.3 special_32936 SQL10053
timestamp: 2015-03-09-17.18.51.765162
instance name: db2inst1.000
EDU name : db2agent (DTQDS005) 0 [-]
EDU ID : 23904
Signal #11
uname: S:AIX R:1 V:7 M:00C325B74C00 N:db2host1
process id: 31654110
parent process id: 22413564
thread id : 23904 (0x5D60)
kthread id : 65994877
</Header>
...
<POFDisassembly>
0x090000000D32244C : 540003DE rlwinm r0,r0,0,0x10000
# 15:15
0x090000000D322450 : 28000000 cmpli cr0,r0,0
0x090000000D322454 : 38640050 addi r3,r4,80
0x090000000D322458 : 41820008 beq cr0,0xD322460 #
12,bit2
0x090000000D32245C : 60640000 ori r4,r3,0x0
0x090000000D322460 : A01D0008 lhz r0,8(r29)
0x090000000D322464 : 38A40008 addi r5,r4,8
0x090000000D322468 : 5403083C rlwinm
r3,r0,1,0xFFFFFFFFFFFFFFFE # 0:30
>>>> 0x090000000D32246C : 7C051A2E lhzx r0,r5,r3
0x090000000D322470 : 7F602214 add r27,r0,r4
0x090000000D322474 : 2C380000 cmpi cr0,r24,0
0x090000000D322478 : 40820120 bne cr0,0xD322598 #
4,bit2
0x090000000D32247C : E81D0000 ld r0,0(r29)
0x090000000D322480 : EB0101E0 ld r24,480(r1)
</POFDisassembly>
<StackTrace>
-------Frame------ ------Function + Offset------
0x090000000D32246C
packReferenceNodeAndTranslate__17xmlDataDescriptorFP11XMLSTORE_C
B13XMLS_EXT_LXIDR8XMLS_XIDCUcN24PUcP17xmlDataDescriptorPcbT10_ +
0x284
0x090000000F13A05C
m_openNavFromBufferEntry__14XmlnvNavigatorFP11XmlnvBufferP16Xmln
vBufferArrayb + 0x4B4
0x090000000F14BEF0
m_findMatchingBindings__21XmlnvTupleConstructorFbPb + 0x4EC |
