[
https://issues.apache.org/jira/browse/TRAFODION-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15482342#comment-15482342
]
ASF GitHub Bot commented on TRAFODION-1755:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/694
> MXOSRVR abends when doing an explain command
> --------------------------------------------
>
> Key: TRAFODION-1755
> URL: https://issues.apache.org/jira/browse/TRAFODION-1755
> Project: Apache Trafodion
> Issue Type: Bug
> Components: connectivity-mxosrvr, sql-exe
> Reporter: Venkat Muthuswamy
> Assignee: Anoop Sharma
>
> When the following sequence of commands are executed via trafci, the mxosrvr
> abends and we do not get the explain output.
> =======================
> SET SCHEMA 'trafodion.opencart2';
> cqd allow_incompatible_comparison 'ON';
> cqd disable_read_only 'ON';
> cqd mode_special_1 'ON';
> SELECT * FROM TABLE(explain(null, 'EXPLAIN_STMT=SELECT tr1.tax_class_id,
> tr2.tax_rate_id, tr2.name, tr2.rate, tr2."type", tr1.priority FROM
> oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id =
> tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON
> (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON
> (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON
> (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = ''shipping'' AND
> tr2cg.customer_group_id = ''1'' AND z2gz.country_id = ''222'' AND
> (z2gz.zone_id = ''0'' OR z2gz.zone_id = ''3563'') ORDER BY tr1.priority ASC
> '));
> ====================
> The same set of commands when run from sqlci work fine and we get the explain
> output. But when run through trafci, it fails.
> Interestingly if we change one of the LEFT JOIN to just JOIN as below, it
> works fine from trafci too.
> SELECT * FROM TABLE(explain(null, 'EXPLAIN_STMT=SELECT tr1.tax_class_id,
> tr2.tax_rate_id, tr2.name, tr2.rate, tr2."type", tr1.priority FROM
> oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id =
> tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON
> (tr2.tax_rate_id = tr2cg.tax_rate_id) JOIN oc_zone_to_geo_zone z2gz ON
> (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON
> (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = ''shipping'' AND
> tr2cg.customer_group_id = ''1'' AND z2gz.country_id = ''222'' AND
> (z2gz.zone_id = ''0'' OR z2gz.zone_id = ''3563'') ORDER BY tr1.priority ASC
> '));
> A core file is generated when the mxosrvr abends and the stack trace shows
> the following:
> #1 0x00007f859added8d in abort () from /lib64/libc.so.6
> #2 0x00007f859add674e in __assert_fail_base () from /lib64/libc.so.6
> #3 0x00007f859add6810 in __assert_fail () from /lib64/libc.so.6
> #4 0x00007f859a2844a6 in str_decoded_len (charLen=16161) at
> ../common/str.cpp:929
> #5 0x00007f8598d148e9 in ExExplainTcb::processExplainStmt
> (this=0x7f85861b51c8) at ../executor/ExExplain.cpp:545
> #6 0x00007f8598d15087 in ExExplainTcb::work (this=0x7f85861b51c8) at
> ../executor/ExExplain.cpp:742
> #7 0x00007f8598bda209 in ex_tcb::sWork (tcb=0x7f85861b51c8) at
> ../executor/ex_tcb.h:103
> #8 0x00007f8598d6556b in ExSubtask::work (this=0x7f85861b6a98) at
> ../executor/ExScheduler.cpp:754
> #9 0x00007f8598d6492e in ExScheduler::work (this=0x7f85861b4d30,
> prevWaitTime=0) at ../executor/ExScheduler.cpp:331
> #10 0x00007f8598c35106 in ex_root_tcb::execute (this=0x7f85861b6b18,
> cliGlobals=0x2498fd0, glob=0x7f85861b3028, input_desc=0x7f85861beb80,
> diagsArea=@0x7f858763d240, reExecute=0)
> at ../executor/ex_root.cpp:1058
> #11 0x00007f859a6e1b67 in CliStatement::execute (this=0x7f85861b25b8,
> cliGlobals=0x2498fd0, input_desc=0x7f85861beb80, diagsArea=...,
> execute_state=CliStatement::INITIAL_STATE_, fixupOnly=0,
> cliflags=0) at ../cli/Statement.cpp:4525
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
