Informix - Problembeschreibung
Problem IT26222 | Status: Geschlossen |
EXECUTING QUERIES USING XML EXISTSNODE ROUTINE IN PARALLEL CAN ASSERT SERVER | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
Initial testing with attached repro seems to indicate this is aix64 specific as running the repro on 12.10.FC10 on linux x86_64 does not reproduce, but the same version does dupe on aix64. An example of a query that fails when two sessions are running it in parallel and there is a single idsxmlvp: SELECT * FROM cjis_message_out WHERE i_document_name = 21 AND dt_create_datetime = "2018-08-06 07:21:08" AND existsnode( c_xml_message_data, '//CaseIdentifiers/CaseEventSequenceID[ID=2795649]') = 1; In the af.file, the stack that is generated has a lot of nosymtab, undefined symbols shown. An example of this stack is immediately below; however, setting AFDEBUG to 1 and grabbing procstack from the asserting idsxmlvp shows a more detailed stack below. From af.file: ********** 0x00000001000ae90c (oninit)afstack 0x00000001000ada80 (oninit)afhandler 0x00000001000adf78 (oninit)affail_interface 0x00000001000d0970 (oninit)mt_ex_throw_sig@AF11_4 0x0000000100059f58 (oninit)afsig_handler 0x090000000050ff14 (*nosymtab*)0x90000000050ff14 0x0000000200000002 (*nosymtab*)0x200000002 0x090000000050f768 (*nosymtab*)0x90000000050f768 0x090000000003946c (*nosymtab*)0x90000000003946c 0x0900000000055ae8 (*nosymtab*)0x900000000055ae8 0x09000000000dd244 (*nosymtab*)0x9000000000dd244 0x090000000d7d5a50 (*nosymtab*)0x90000000d7d5a50 0x090000000d7d6008 (*nosymtab*)0x90000000d7d6008 0x090000000d7d6148 (*nosymtab*)0x90000000d7d6148 0x090000000db606fc (*nosymtab*)0x90000000db606fc 0x090000000db99e1c (*nosymtab*)0x90000000db99e1c 0x090000000de4511c (*nosymtab*)0x90000000de4511c 0x090000000de3e2d8 (*nosymtab*)0x90000000de3e2d8 0x090000000088c2ec (*nosymtab*)0x90000000088c2ec 0x090000000de32198 (*nosymtab*)0x90000000de32198 0x090000000de31e6c (*nosymtab*)0x90000000de31e6c 0x090000000de31d34 (*nosymtab*)0x90000000de31d34 0x090000000de33780 (*nosymtab*)0x90000000de33780 0x090000000de35cb8 (*nosymtab*)0x90000000de35cb8 0x090000000de33420 (*nosymtab*)0x90000000de33420 0x090000000de3446c (*nosymtab*)0x90000000de3446c 0x090000000de33618 (*nosymtab*)0x90000000de33618 0x090000000de33278 (*nosymtab*)0x90000000de33278 0x090000000de33178 (*nosymtab*)0x90000000de33178 0x090000000de33038 (*nosymtab*)0x90000000de33038 0x090000000de32f84 (*nosymtab*)0x90000000de32f84 0x090000000de32d1c (*nosymtab*)0x90000000de32d1c 0x090000000de32cb8 (*nosymtab*)0x90000000de32cb8 0x090000000de32ab4 (*nosymtab*)0x90000000de32ab4 0x090000000de32844 (*nosymtab*)0x90000000de32844 0x090000000de32580 (*nosymtab*)0x90000000de32580 0x090000000de32458 (*nosymtab*)0x90000000de32458 0x090000000de2f748 (*nosymtab*)0x90000000de2f748 0x090000000e05f280 (*nosymtab*)0x90000000e05f280 0x090000000e05e668 (*nosymtab*)0x90000000e05e668 0x090000000d7dfc74 (*nosymtab*)0x90000000d7dfc74 0x0000000100cbb9f8 (oninit)udrlm_clang_execute_internal 0x0000000100cbb440 (oninit)udrlm_clang_execute 0x00000001015bba78 (oninit)udrlm_exec_routine 0x00000001005fa3d4 (oninit)udr_execute 0x000000010048f46c (oninit)ev_udr 0x0000000100484520 (oninit)new_eval 0x000000010074d258 (oninit)gettupl 0x0000000100744504 (oninit)scan_next 0x0000000100985c14 (oninit)getrow 0x0000000100986f8c (oninit)fetchrow 0x0000000100c14a94 (oninit)exfetch 0x00000001007c4724 (oninit)sql_nfetch 0x00000001007c3df4 (oninit)sq_nfetch 0x000000010070c68c (oninit)sqmain 0x00000001013b90b8 (oninit)listen_verify 0x00000001013b7b2c (oninit)spawn_thread 0x0000000101365620 (oninit)th_init_initgls 0x00000001017d9b20 (oninit)startup From procstack: ************* $ rasu procstack 4260720 4260720: oninit 0x0900000000153954 __fd_poll(??, ??, ??) + 0xb4 0x0000000100051b40 invoke_debugger() + 0xe0 0x00000001000acf34 afhandler() + 0xd14 0x00000001000adf74 affail_interface() + 0x94 0x00000001000d096c mt_ex_throw_sig@AF11_4() + 0x40c 0x0000000100059f54 afsig_handler() + 0xd4 0x090000000050ff14 pthread_kill(??, ??) + 0xd4 0x090000000050f764 _p_raise(??) + 0x44 0x0900000000039468 raise(??) + 0x48 0x0900000000055ae4 abort() + 0xc4 0x09000000000dd240 __assert_c99(??, ??, ??, ??) + 0x2c0 0x090000000d7d5a4c xslt4c_1_10::XalanVector::invariants() const(0x700000021edaa80) + 0x8c 0x090000000d7d6004 xslt4c_1_10::XalanVector::~XalanVector()(0x700000021edaa80, 0x200000002) + 0x24 0x090000000d7d6144 xslt4c_1_10::XalanDOMString::~XalanDOMString()(0x700000021edaa80 , 0x200000002) + 0x24 0x090000000db606f8 xslt4c_1_10::XSLException::~XSLException()() + 0x58 0x090000000db99e18 xslt4c_1_10::XalanXPathException::~XalanXPathException()() + 0x58 0x090000000de45118 xslt4c_1_10::XPathParserException::~XPathParserException()() + 0x58 0x090000000de3e2d4 xslt4c_1_10::XPathParserException::__dftdt()() + 0x14 0x090000000088c2e8 __DoThrowV6() + 0x2e8 0x090000000de32194 xslt4c_1_10::XPathProcessorImpl::error(const xslt4c_1_10::XalanDOMString&) const() + 0x274 0x090000000de31e68 xslt4c_1_10::XPathProcessorImpl::error(xslt4c_1_10::XalanMessage s::Codes,unsigned short,const xslt4c_1_10::XalanDOMString&) const() + 0x108 0x090000000de31d30 xslt4c_1_10::XPathProcessorImpl::consumeExpected(unsigned short)() + 0x50 0x090000000de3377c xslt4c_1_10::XPathProcessorImpl::Predicate()() + 0x3c 0x090000000de35cb4 xslt4c_1_10::XPathProcessorImpl::Step()() + 0x434 0x090000000de3341c xslt4c_1_10::XPathProcessorImpl::RelativeLocationPath()() + 0x3c 0x090000000de34468 xslt4c_1_10::XPathProcessorImpl::LocationPath()() + 0x1e8 0x090000000de33614 xslt4c_1_10::XPathProcessorImpl::PrimaryExpr()() + 0x1b4 0x090000000de33274 xslt4c_1_10::XPathProcessorImpl::FilterExpr()() + 0x34 0x090000000de33174 xslt4c_1_10::XPathProcessorImpl::PathExpr()() + 0x34 0x090000000de33034 xslt4c_1_10::XPathProcessorImpl::UnionExpr()() + 0x54 0x090000000de32f80 xslt4c_1_10::XPathProcessorImpl::UnaryExpr()() + 0xa0 0x090000000de32d18 xslt4c_1_10::XPathProcessorImpl::MultiplicativeExpr(int)() + 0x38 0x090000000de32cb4 xslt4c_1_10::XPathProcessorImpl::AdditiveExpr(int)() + 0x1d4 0x090000000de32ab0 xslt4c_1_10::XPathProcessorImpl::RelationalExpr(int)() + 0x230 0x090000000de32840 xslt4c_1_10::XPathProcessorImpl::EqualityExpr(int)() + 0x1e0 0x090000000de3257c xslt4c_1_10::XPathProcessorImpl::AndExpr()() + 0x3c 0x090000000de32454 xslt4c_1_10::XPathProcessorImpl::OrExpr()() + 0x34 0x090000000de2f744 xslt4c_1_10::XPathProcessorImpl::initXPath(xslt4c_1_10::XPath&,x slt4c_1_10::XPathConstructionContext&,const xslt4c_1_10::XalanDOMString&,const xslt4c_1_10::PrefixResolver&,const xercesc_2_6::Locator*,bool,bool)() + 0x84 0x090000000e05f27c xslt4c_1_10::XPathEvaluator::evaluate(xslt4c_1_10::DOMSupport&,x slt4c_1_10::XalanNode*,const unsigned short*,const xslt4c_1_10::PrefixResolver&,xslt4c_1_10::XPathEnvSupport&)() + 0x11c 0x090000000e05e664 xslt4c_1_10::XPathEvaluator::evaluate(xslt4c_1_10::DOMSupport&,x slt4c_1_10::XalanNode*,const unsigned short*,const xslt4c_1_10::XalanElement*)() + 0xa4 0x090000000d7dfc70 xmlexistnodeinputclob(0x700000040064fa8, 0x7000000223dca80, 0x7000000223dc7e8) + 0x6d0 0x0000000100cbb9f4 udrlm_clang_execute_internal() + 0x514 0x0000000100cbb43c udrlm_clang_execute() + 0x7c 0x00000001015bba74 udrlm_exec_routine() + 0x674 0x00000001005fa3d0 udr_execute() + 0x7f0 0x000000010048f468 ev_udr() + 0x488 0x000000010048451c new_eval() + 0x1fc 0x000000010074d254 gettupl() + 0x974 0x0000000100744500 scan_next() + 0x740 0x0000000100985c10 getrow() + 0x450 0x0000000100986f88 fetchrow() + 0x348 0x0000000100c14a90 exfetch() + 0x70 0x00000001007c4720 sql_nfetch() + 0x860 0x00000001007c3df0 sq_nfetch() + 0xf0 0x000000010070c688 sqmain() + 0x1c8 0x00000001013b90b4 listen_verify() + 0x4b4 0x00000001013b7b28 spawn_thread() + 0x1028 0x000000010136561c th_init_initgls() + 0x5c 0x00000001017d9b1c startup() + 0x1bc | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Executing queries using xml existsnode routine in parallel * * can assert server. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 07.09.2018 03.10.2019 03.10.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC13 | |
Problem behoben lt. FixList in der Version |