You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/10/08 06:14:27 UTC
[jira] [Assigned] (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:all-tabpanel ]
Suresh Subbiah reassigned TRAFODION-1077:
-----------------------------------------
Assignee: Selvaganesan Govindarajan
> 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)