[ORCA] query crashed when --enable-coverage works

[tender wang]

main branch, up do this commit: 98e79490a26d0d9db4c9239ee1c4b33d8af65ec0

How to repeat:

 CFLAGS="-g -O3" CXXFLAGS="-g -O3" ./configure --prefix=/tender/gpdb-cluster --with-perl --with-python --with-libxml  --with-openssl --enable-coverage

SELECT * FROM xmltable('/root' passing '<root><element>a1a<!-- aaaa -->a2a<?aaaaa?> <!--z-->  bbbb<x>xxx</x>cccc</element></root>' COLUMNS element text); -- crashed

bt:

(gdb) bt
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1  0x00007fc5ea44f859 in __GI_abort () at abort.c:79
#2  0x00007fc5ea829911 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
#3  0x00007fc5ea83538c in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
#4  0x00007fc5ea834369 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
#5  0x00007fc5ea834d21 in __gxx_personality_v0 () from /lib/x86_64-linux-gnu/libstdc++.so.6
#6  0x00007fc5ea62fbef in ?? () from /lib/x86_64-linux-gnu/libgcc_s.so.1
#7  0x00007fc5ea6305aa in _Unwind_Resume () from /lib/x86_64-linux-gnu/libgcc_s.so.1
#8  0x0000563c506aec54 in gpdb::CloseRelation (rel=0x563c53b7f430)
#9  0x0000563c5145097d in gpdb::RelationWrapper::~RelationWrapper (this=<optimized out>, __in_chrg=<optimized out>) at RelationWrapper.cpp:15
#10 0x0000563c506a6a44 in gpdxl::CTranslatorQueryToDXL::NoteDistributionPolicyOpclasses (this=0x563c514323c0 <gpdxl::CTranslatorQueryToDXL::TranslateFromClauseToDXL(Node*)+368>, rte=<optimized out>) at CTranslatorQueryToDXL.cpp:3304
#11 0x0000563c5142fd9f in gpdxl::CTranslatorQueryToDXL::TranslateSelectProjectJoinToDXL (group_clause=0x0, output_attno_to_colid_mapping=0x563c53b84cb0, sort_group_attno_to_colid_mapping=0x563c53b842b0, from_expr=0x563c53ba1ae0,
    target_list=0x563c53ba1b78, this=0x563c53b82790) at CTranslatorQueryToDXL.cpp:672
#12 gpdxl::CTranslatorQueryToDXL::TranslateGroupingSets (this=0x563c53b82790, from_expr=0x563c53ba1ae0, target_list=0x563c53ba1b78, group_clause=<optimized out>, grouping_set=0x0, has_aggs=<optimized out>, sort_grpref_to_colid_mapping=0x563c53b842b0,
    output_attno_to_colid_mapping=0x563c53b847b0) at CTranslatorQueryToDXL.cpp:2440
#13 0x0000563c5143068d in gpdxl::CTranslatorQueryToDXL::TranslateSelectQueryToDXL (this=0x563c53b82790) at CTranslatorQueryToDXL.cpp:618
#14 0x0000563c51435c59 in gpdxl::CTranslatorQueryToDXL::TranslateQueryToDXL (this=0x563c53b82790) at CTranslatorQueryToDXL.cpp:723
#15 0x0000563c5144ef37 in COptTasks::OptimizeTask (ptr=0x7fffa70b0730) at COptTasks.cpp:542
#16 0x0000563c50fc0c56 in gpos::CTask::Execute (this=this@entry=0x563c53b5ff80) at CTask.cpp:168
#17 0x0000563c50fc2382 in gpos::CWorker::Execute (this=0x7fffa70b05e0, task=task@entry=0x563c53b5ff80) at CWorker.cpp:80
#18 0x0000563c50fbff2c in gpos::CAutoTaskProxy::Execute (this=this@entry=0x7fffa70b0610, task=task@entry=0x563c53b5ff80) at CAutoTaskProxy.cpp:286
#19 0x0000563c50fc349e in gpos_exec (params=params@entry=0x7fffa70b06a0) at _api.cpp:237
#20 0x0000563c5144d097 in COptTasks::Execute (func=0x563c5144ebf0 <COptTasks::OptimizeTask(void*)>, func_arg=0x7fffa70b0730) at COptTasks.cpp:234
#21 0x0000563c5144e3a4 in COptTasks::GPOPTOptimizedPlan (query=query@entry=0x563c5398eae0, gpopt_context=gpopt_context@entry=0x7fffa70b0730) at COptTasks.cpp:759
#22 0x0000563c51450a31 in CGPOptimizer::GPOPTOptimizedPlan (query=0x563c5398eae0, had_unexpected_failure=0x7fffa70b07b7) at CGPOptimizer.cpp:58
#23 0x0000563c51450bd5 in GPOPTOptimizedPlan (query=query@entry=0x563c5398eae0, had_unexpected_failure=had_unexpected_failure@entry=0x7fffa70b07b7) at CGPOptimizer.cpp:234
#24 0x0000563c50b7f0c5 in optimize_query (parse=parse@entry=0x563c53965e78, cursorOptions=cursorOptions@entry=256, boundParams=boundParams@entry=0x0) at orca.c:160
#25 0x0000563c50b709ae in standard_planner (parse=0x563c53965e78, cursorOptions=256, boundParams=0x0) at planner.c:373
#26 0x0000563c50b70f65 in planner (parse=parse@entry=0x563c53965e78, cursorOptions=cursorOptions@entry=256, boundParams=<optimized out>) at planner.c:329
#27 0x0000563c50cb5817 in pg_plan_query (querytree=querytree@entry=0x563c53965e78, cursorOptions=cursorOptions@entry=256, boundParams=boundParams@entry=0x0) at postgres.c:1016
#28 0x0000563c50cb597d in pg_plan_queries (querytrees=<optimized out>, cursorOptions=cursorOptions@entry=256, boundParams=boundParams@entry=0x0) at postgres.c:1106
#29 0x0000563c50cb651a in exec_simple_query (query_string=0x563c53964cc0 "SELECT * FROM xmltable('/root' passing '<root><element>a1a<!-- aaaa -->a2a<?aaaaa?> <!--z-->  bbbb<x>xxx</x>cccc</element></root>' COLUMNS element text);") at postgres.c:1848
#30 0x0000563c50cbac2a in PostgresMain (argc=<optimized out>, argv=argv@entry=0x563c53993000, dbname=<optimized out>, username=<optimized out>) at postgres.c:5378
#31 0x0000563c50be441c in BackendRun (port=0x563c53984740, port=0x563c53984740) at postmaster.c:5006
#32 BackendStartup (port=0x563c53984740) at postmaster.c:4683
#33 ServerLoop () at postmaster.c:1999
#34 0x0000563c50be5cde in PostmasterMain (argc=5, argv=<optimized out>) at postmaster.c:1625
#35 0x0000563c506b97c0 in main (argc=5, argv=0x563c5395e640) at main.c:240

[Ashwin Agrawal]

Thanks for reporting, we will look, fix and get back.