You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/10/31 23:54:58 UTC
[jira] [Commented] (TRAFODION-1077) LP Bug: 1435894 - AQR info
missing from GET STATISTICS
[ https://issues.apache.org/jira/browse/TRAFODION-1077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15623835#comment-15623835 ]
ASF GitHub Bot commented on TRAFODION-1077:
-------------------------------------------
GitHub user selvaganesang opened a pull request:
https://github.com/apache/incubator-trafodion/pull/805
[TRAFODION-1077] AQR info missing from GET STATISTICS
Automatic query retry info was populated, but it got reset as part
of successful retry prepare.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion trafodion-1077
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/805.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 #805
----
commit a74957a0fd090249c53db8bf2d1217f14cff0ffd
Author: selvaganesang <se...@esgyn.com>
Date: 2016-10-31T22:29:02Z
[TRAFODION-1077] AQR info missing from GET STATISTICS
Automatic query retry info was populated, but it got reset as part
of successful retry prepare.
----
> LP Bug: 1435894 - AQR info missing from GET STATISTICS
> ------------------------------------------------------
>
> Key: TRAFODION-1077
> URL: https://issues.apache.org/jira/browse/TRAFODION-1077
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Apache Trafodion
> Assignee: Selvaganesan Govindarajan
>
> Three counters to give information on auto-query retry are not being populated in runtime statistics.
> >>cqd AUTO_QUERY_RETRY_WARNINGS 'ON';
> --- SQL operation complete.
> >>
> >>prepare s1 from insert into aqr_stats values( 1, 1);
> --- SQL command prepared.
> >>
> >>create index idx_aqr_stats on aqr_stats(b);
> --- SQL operation complete.
> >>
> >>execute s1;
> *** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry.
> *** WARNING[8738] Statement must be recompiled due to redefinition of the object(s) accessed.
> --- 1 row(s) inserted.
> >>
> >>log ;
> >>
> >>log stats_arq_stats.log clear;
> >>
> >>get statistics for qid current;
> Qid MXID11000004482212293966812093419000000000206U3333300_93_S1
> Compile Start Time 2015/03/24 14:20:38.942825
> Compile End Time 2015/03/24 14:20:40.386591
> Compile Elapsed Time 0:00:01.443766
> Execute Start Time 2015/03/24 14:20:40.386660
> Execute End Time 2015/03/24 14:20:40.419509
> Execute Elapsed Time 0:00:00.032849
> State CLOSE
> Rows Affected 1
> SQL Error Code 8597
> Stats Error Code 0
> Query Type SQL_INSERT_NON_UNIQUE
> Sub Query Type SQL_STMT_NA
> Estimated Accessed Rows 0
> Estimated Used Rows 0
> Parent Qid NONE
> Parent Query System NONE
> Child Qid NONE
> Number of SQL Processes 1
> Number of Cpus 1
> Transaction Id 50
> Source String insert into aqr_stats values( 1, 1);
> SQL Source Length 36
> Rows Returned 0
> First Row Returned Time -1
> Last Error before AQR 0
> Number of AQR retries 0
> Delay before AQR 0
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)