[ 
https://issues.apache.org/jira/browse/TRAFODION-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15505069#comment-15505069
 ] 

ASF GitHub Bot commented on TRAFODION-1755:
-------------------------------------------

Github user asfgit closed the pull request at:

    https://github.com/apache/incubator-trafodion/pull/711


> 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)

Reply via email to