DB2 - Problembeschreibung
Problem IC78487 | Status: Geschlossen |
SELECT ON XML COLUMN CAN CRASH DATABASE. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Select on xml column may cause database to crash. The stack will look like as below: 0x0000002A97EDC7A6 _ZNK17sqlnq_fcscstchild2ppEv + 0x0010 (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1) 0x0000002A97F42723 _Z19sqlno_log_bad_statsP9sqlnq_cstii + 0x0025 (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1) 0x0000002A97F2C849_Z18sqlno_ff_frq_rangeP13sqlno_globalsP19sqlno _ff_essentialsPdjS3_jP10sqlz_valueS5_P9sqlnq_cst14sqlnq_funclass S8_f17sqlno_prefix_typePK14sqlrxCollationPfSD_P26sqlno_xml_rngse l_interface + 0x0351 (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1) 0x0000002A97F18253_Z14sqlno_ff_rangeP13sqlno_globalsP9sqlnq_qncf PdS3_S3_jP9sqlnq_cstff14sqlnq_funclassfP10sqlz_valuePfP26sqlno_x ml_rngsel_interface + 0x0aef (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1) 0x0000002A981A1E6E_ZN26sqlno_xml_rngsel_interface6rngSelEP13sqln o_globalsPfP9sqlnq_pidN10XmlrnStats14XMLRN_ESTIMATEE + 0x037e (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1) 0x0000002A98198712_Z30sqlno_xmlfo_estimateLPatValCntP13sqlno_glo balsP9sqlnq_pidP9sqlnq_qncS2_17SQLNO_XMLPRD_TYPEP26sqlno_xml_rng sel_interfaceN10XmlrnStats14XMLRN_ESTIMATEEPfSA_ + 0x0a42 (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * Select on xml column may cause database to crash. * * * * The stack will look like as below: * * * * 0x0000002A97EDC7A6 _ZNK17sqlnq_fcscstchild2ppEv + 0x0010 * * * * (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so * * .1) * * 0x0000002A97F42723 _Z19sqlno_log_bad_statsP9sqlnq_cstii + * * 0x0025 * * * * (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so * * .1) * * 0x0000002A97F2C849_Z18sqlno_ff_frq_rangeP13sqlno_globalsP19s * * qlno * * _ff_essentialsPdjS3_jP10sqlz_valueS5_P9sqlnq_cst14sqlnq_func * * lass * * S8_f17sqlno_prefix_typePK14sqlrxCollationPfSD_P26sqlno_xml_r * * ngse * * l_interface * * + 0x0351 * * * * (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so * * .1) * * 0x0000002A97F18253_Z14sqlno_ff_rangeP13sqlno_globalsP9sqlnq_ * * qncf * * PdS3_S3_jP9sqlnq_cstff14sqlnq_funclassfP10sqlz_valuePfP26sql * * no_x * * ml_rngsel_interface * * + 0x0aef * * * * (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so * * .1) * * 0x0000002A981A1E6E_ZN26sqlno_xml_rngsel_interface6rngSelEP13 * * sqln * * o_globalsPfP9sqlnq_pidN10XmlrnStats14XMLRN_ESTIMATEE * * + 0x037e * * * * (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so * * .1) * * 0x0000002A98198712_Z30sqlno_xmlfo_estimateLPatValCntP13sqlno * * _glo * * balsP9sqlnq_pidP9sqlnq_qncS2_17SQLNO_XMLPRD_TYPEP26sqlno_xml * * _rng * * sel_interfaceN10XmlrnStats14XMLRN_ESTIMATEEPfSA_ * * + 0x0a42 * * * * (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so * * .1) * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.7 FP5. * **************************************************************** | |
Local-Fix: | |
n/a | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 V9.7 FP 5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 02.09.2011 28.03.2012 28.03.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |