|
Problem IT07015
|
Status: Closed |
SEGMENTATION FAULT DURING XML QUERY "REPLACE" PROCESSING WHEN MATCHING EXTENSIVE NUMBER OF TOKENS |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
XML Query using "replace" function might produce segmentation
fault while matching extensive number of tokens in regular
expression processing. Example of such query is following:
db2 -v "SELECT XMLCAST(XMLQUERY('fn:replace(\$x, \"^(.+)\s+$\",
\"\$1\", \"i\")' PASSING x AS \"x\") AS VARCHAR(32000)) FROM
TABLE(VALUES REPEAT('AB ', 1000)) AS t(x)"
During occurrence FODC_Trap is created with stack:
<StackTrace>
-------Frame------ ------Function + Offset------
replace__26XmlrpRegularExpressionImplFPCcUiT1T2RPcRUi + 0xB4
replace__22XmlrpRegularExpressionFPCcUiT1T2RPcRUi + 0xD8
sqlriXmlReplace__FP8sqlrr_cb + 0x132C
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0xCC
sqlrr_process_fetch_request__FP14db2UCinterface + 0x170
sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x888
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x1B68
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x8D8
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x8D8
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x4E4
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5D8
RunEDU__8sqeAgentFv + 0x462EC
RunEDU__8sqeAgentFv + 0xDC
EDUDriver__9sqzEDUObjFv + 0x110
sqloEDUEntry + 0x38C
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.5 fixpack 7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem was first fixed in DB2 version 10.5 fixpack 7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.02.2015
20.01.2016
20.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
