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 |
