[jira] [Commented] (TRAFODION-2981) mxosrvr crashes during explain using EXPLAIN_QID

[ASF GitHub Bot (JIRA)]

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/trafodion/pull/1464


> mxosrvr crashes during explain using EXPLAIN_QID
> 
>
> Key: TRAFODION-2981
> URL: https://issues.apache.org/jira/browse/TRAFODION-2981
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: mashengchen
>Assignee: mashengchen
>Priority: Major
>
> When the following sequence of commands are executed via trafci, the mxosrvr 
> abends and we do not get the explain output.
> SELECT * FROM TABLE(explain(null, 
> 'EXPLAIN_QID=MXID11070192123841538945334162206U308T150010100_923_SQL_CUR_2'));
>  
> this issue is related to TRAFODION-1755



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2981) mxosrvr crashes during explain using EXPLAIN_QID

[ASF GitHub Bot (JIRA)]

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

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

Github user sandhyasun commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1464#discussion_r173272707
  
--- Diff: core/sql/executor/ExExplain.cpp ---
@@ -1724,9 +1724,9 @@ short ExExplainTcb::getExplainFromRepos(char * qid, 
Lng32 qidLen)
   if (vi->get(0, ptr, len))
 goto label_error2;
   
-  explainFragLen_ = str_decoded_len(len); // remove trailing null 
terminator
+  explainFragLen_ = str_decoded_len(len - 1); // remove trailing null 
terminator
--- End diff --

The JIRA isn't showing  trace fileor debugging info. Can you explain what 
the issue was with passingin 'len' into str_decoded_len ? Seems like the 
explainFragLen_ would have had sufficient length to allocate the explain 
fragment ? Some explanation in the PR or JIRA will help. 


> mxosrvr crashes during explain using EXPLAIN_QID
> 
>
> Key: TRAFODION-2981
> URL: https://issues.apache.org/jira/browse/TRAFODION-2981
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: mashengchen
>Assignee: mashengchen
>Priority: Major
>
> When the following sequence of commands are executed via trafci, the mxosrvr 
> abends and we do not get the explain output.
> SELECT * FROM TABLE(explain(null, 
> 'EXPLAIN_QID=MXID11070192123841538945334162206U308T150010100_923_SQL_CUR_2'));
>  
> this issue is related to TRAFODION-1755



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2981) mxosrvr crashes during explain using EXPLAIN_QID

[ASF GitHub Bot (JIRA)]

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

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

GitHub user mashengchen opened a pull request:

https://github.com/apache/trafodion/pull/1464

TRAFODION-2981 mxosrvr crashes during explain using EXPLAIN_QID

SELECT * FROM TABLE(explain(null, 
'EXPLAIN_QID=MXID11070192123841538945334162206U308T150010100_923_SQL_CUR_2'));
this is related to TRAFODION-1755


You can merge this pull request into a Git repository by running:

$ git pull https://github.com/mashengchen/trafodion TRAFODION-2981

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/trafodion/pull/1464.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #1464


commit 6b8fc454df57076d54c3e566eec8bcd3ea806a6d
Author: aven 
Date:   2018-03-06T09:59:04Z

TRAFODION-2981 mxosrvr crashes during explain using EXPLAIN_QID




> mxosrvr crashes during explain using EXPLAIN_QID
> 
>
> Key: TRAFODION-2981
> URL: https://issues.apache.org/jira/browse/TRAFODION-2981
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: mashengchen
>Assignee: mashengchen
>Priority: Major
>
> When the following sequence of commands are executed via trafci, the mxosrvr 
> abends and we do not get the explain output.
> SELECT * FROM TABLE(explain(null, 
> 'EXPLAIN_QID=MXID11070192123841538945334162206U308T150010100_923_SQL_CUR_2'));
>  
> this issue is related to TRAFODION-1755



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)