DB2 - Problem description
Problem IT38624 | Status: Closed |
ENGINE CRASH IN XMLRNNODEMGR::FETCHTEMPNODE() | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
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) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to fixpack inclusive of this APAR fix. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to fixpack inclusive of this APAR fix. * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.10.2021 01.12.2021 01.12.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |