You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Lili Ma (JIRA)" <ji...@apache.org> on 2016/03/10 06:54:40 UTC
[jira] [Assigned] (HAWQ-509) Run "select * from pg_stat_activity"
returns multiple records for one query
[ https://issues.apache.org/jira/browse/HAWQ-509?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lili Ma reassigned HAWQ-509:
----------------------------
Assignee: Lili Ma (was: Lei Chang)
> Run "select * from pg_stat_activity" returns multiple records for one query
> ---------------------------------------------------------------------------
>
> Key: HAWQ-509
> URL: https://issues.apache.org/jira/browse/HAWQ-509
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Catalog
> Reporter: Lili Ma
> Assignee: Lili Ma
>
> Run a query which contains function will generate multiple records in pg_stat_activity.
> {code}
> create sequence sri_seq;
> create table sri_table (tid bigint, bdate date, aid int, delta int, mtime timestamp) with (appendonly = true, orientation = PARQUET, pagesize = 1048576, rowgroupsize = 8388608, compresstype = SNAPPY)distributed by (tid) ;
> gpsqltest_sri_parquet_part_hash_gpadmin=# begin;
> BEGIN
> gpsqltest_sri_parquet_part_hash_gpadmin=# INSERT INTO sri_table (tid, bdate, aid, delta, mtime) VALUES (nextval('sri_seq'), '1993-10-14', 1, 1, current_timestamp);
> INSERT 0 1
> {code}
> Run ps -ef |grep postgres
> {code}
> gpadmin 604929 604400 13 01:40 ? 00:00:02 postgres: port 5432, gpadmin gpsqltest_... [local] con38 cmd3 idle in transaction [local]
> gpadmin 604936 604400 1 01:40 ? 00:00:00 postgres: port 5432, gpadmin gpsqltest_... [local] con38 seg-1 idle
> {code}
> Run select from pg_stat_activity, there are two records for single insert. Should only return one record.
> {code}
> postgres=# select * from pg_stat_activity ;
> datid | datname | procpid | sess_id | usesysid | usename | current_query | waiting | query_start | backend_start | clie
> nt_addr | client_port | application_name | xact_start | waiting_resource
> -------+-----------------------------------------+---------+---------+----------+---------+----------------------------------+---------+-------------------------------+-------------------------------+-----
> --------+-------------+------------------+-------------------------------+------------------
> 47622 | gpsqltest_sri_parquet_part_hash_gpadmin | 604936 | 38 | 10 | gpadmin | <IDLE> | f | 2016-01-27 01:40:57.94057-08 | 2016-01-27 01:41:00.132015-08 |
> | -1 | | | f
> 47622 | gpsqltest_sri_parquet_part_hash_gpadmin | 604929 | 38 | 10 | gpadmin | <IDLE> in transaction | f | 2016-01-27 01:40:57.94057-08 | 2016-01-27 01:40:45.784561-08 |
> | -1 | psql | 2016-01-27 01:40:50.180561-08 | f
> 16387 | postgres | 604946 | 40 | 10 | gpadmin | select * from pg_stat_activity ; | f | 2016-01-27 01:41:22.163617-08 | 2016-01-27 01:41:10.059942-08 |
> | -1 | psql | 2016-01-27 01:41:22.163617-08 | f
> (3 rows)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)