Below query is crashing Db2 engine with segV in
XmlrnNodeMgr::fetchTempNode()
select xfiltransxml.sta ,xfiltransxml.* ,temp.*
from xfiltransxml
join XmlTable(xmlnamespaces (DEFAULT 'http://'),
'$i/' PASSING transxml as "i"
COLUMNS ItemNo char(15) path '../../ItemNo' ,
Attribute1 char(5) path '../Attribute1' ,
Attribute2 char(5) path '../Attribute2'
) as Temp
on 1 = 1
where ItemNo = ''
AND Attribute1 = ''
AND Attribute2 = ''
and xfiltransxml.sysandrtidstamp > ''
order by lopnr
with ur ;
-----Frame------ ------Address----- ------Function +
Offset------
0x00003FFF683EC5F0 0x00003FFF7D6E312C XmlnvBasicArray::reset() +
0x00fc
( = offset 0xDF1312C in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683EC6E0 0x00003FFF7D6F67B8
XmlnvNavigator::m_exitSubtree(bool&,
XmlnvNavigator::NavigateFlag&) + 0x0258
( = offset 0xDF267B8 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683EC830 0x00003FFF7D6F40F0
XmlnvNavigator::m_traverse(bool) + 0x3470
( = offset 0xDF240F0 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683ECA90 0x00003FFF7D6F0A24
XmlnvNavigator::getTuple(bool&, sqlrr_cb*) + 0x0174
( = offset 0xDF20A24 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683ECB70 0x00003FFF7C449B0C sqlriXMLScan(sqlrr_cb*) +
0x04f8
( = offset 0xCC79B0C in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683ECCB0 0x00003FFF7C3D3BA0 sqlriNljnPiped(sqlrr_cb*)
+ 0x01b0
( = offset 0xCC03BA0 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683ECDB0 0x00003FFF7C328C70 sqlriSectInvoke(sqlrr_cb*,
sqlri_opparm*) + 0x0410
( = offset 0xCB58C70 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683ECF00 0x00003FFF7BB8C3B4
sqlrr_process_fetch_request(db2UCinterface*) + 0x0c94
( = offset 0xC3BC3B4 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683ED050 0x00003FFF7BB8A250
sqlrr_fetch(db2UCinterface*, db2UCCursorInfo*) + 0x2540
( = offset 0xC3BA250 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683ED310 0x00003FFF791BE64C
sqljs_ddm_cntqry(db2UCinterface*, sqljDDMObject*) + 0x048c
( = offset 0x99EE64C in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683ED520 0x00003FFF7918F9A4
sqljsParseRdbAccessed(sqljsDrdaAsCb*, sqljDDMObject*,
db2UCinterface*) + 0x0294
( = offset 0x99BF9A4 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683ED640 0x00003FFF79190C84 sqljsParse(sqljsDrdaAsCb*,
db2UCinterface*, sqeAgent*, bool) + 0x0404
( = offset 0x99C0C84 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683ED930 0x00003FFF79171328
( = offset 0x99A1328 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683EDDD0 0x00003FFF79169908
( = offset 0x9999908 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683EDE50 0x00003FFF79167DF0
( = offset 0x9997DF0 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683EE110 0x00003FFF791651A4
sqljsDrdaAsDriver(SQLCC_INITSTRUCT_T*) + 0x0254
( = offset 0x99951A4 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683EE200 0x00003FFF788AAFB0 sqeAgent::RunEDU() +
0x0b60
( = offset 0x90DAFB0 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683EE3D0 0x00003FFF7D5BCC04 sqzEDUObj::EDUDriver() +
0x0344
( = offset 0xDDECC04 in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683EE440 0x00003FFF7D5BC89C sqlzRunEDU(char*, unsigned
int) + 0x001c
( = offset 0xDDEC89C in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683EE460 0x00003FFF7B3163DC sqloEDUEntry + 0x034c
( = offset 0xBB463DC in
/home/db2v111/sqllib/lib64/libdb2e.so.1)
0x00003FFF683EE790 0x00003FFF82A38AF4
( = offset 0x8AF4 in /lib64/libpthread.so.0)
0x00003FFF683EEA10 0x00003FFF6ED78814 clone + 0x00e4
( = offset 0x128814 in /lib64/libc.so.6) |
