Обсуждение: pgAdmin4 connecting to Greenplum Community Edition v6.4 shows error

Поиск
Список
Период
Сортировка

pgAdmin4 connecting to Greenplum Community Edition v6.4 shows error

От
Brandon Hsu
Дата:
Hi, Team,

Recently I tried to connect pgAdmin4 4.20 (running under Windows 10 desktop) to a Greenplum Community Edition Cluster (obained from https://github.com/greenplum-db/gpdb/releases) but I get some error messages in the database log.
For example:

2020-04-17 10:06:31.526219 CST,"gpadmin","postgres",p156239,th996268160,"192.168.3.184","64720",2020-04-17 09:44:53 CST,0,con64694,cmd1295,seg-1,,,,sx1,"ERROR","42703","column ""current_query"" does not exist",,,,,,"/*pga4dash*/
SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT count(*) FROM pg_stat_activity WHERE datid = 16399 ) AS ""Total"",
   (SELECT count(*) FROM pg_stat_activity WHERE current_query NOT LIKE '<IDLE>%' AND datid = 16399 )  AS ""Active"",
   (SELECT count(*) FROM pg_stat_activity WHERE current_query LIKE '<IDLE>%' AND datid =  16399 )  AS ""Idle""
) t
UNION ALL
SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16399)) AS ""Transactions"",
   (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16399)) AS ""Commits"",
   (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16399)) AS ""Rollbacks""
) t
UNION ALL
SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16399)) AS ""Inserts"",
   (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16399)) AS ""Updates"",
   (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16399)) AS ""Deletes""
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16399)) AS ""Fetched"",
   (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16399)) AS ""Returned""
) t
UNION ALL
SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
   (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16399)) AS ""Reads"",
   (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 16399)) AS ""Hits""
) t
",218,,"parse_relation.c",3361,

2020-04-17 10:06:53.047897 CST,"gpadmin","postgres",p156239,th996268160,"192.168.3.184","64720",2020-04-17 09:44:53 CST,0,con64694,cmd1301,seg-1,,,,sx1,"ERROR","42703","column ""procpid"" does not exist",,,,,,"/*pga4dash*/
SELECT
    procpid AS pid,
    datname,
    usename,
    application_name,
    client_addr,
    to_char(backend_start, 'YYYY-MM-DD HH24:MI:SS TZ') AS backend_start,
    CASE WHEN current_query LIKE '<IDLE>%' THEN 'idle' ELSE 'active' END AS state,
    CASE WHEN waiting THEN 'yes' ELSE 'no' END AS waiting
FROM
    pg_stat_activity
WHERE
    datid = 16399 ORDER BY pid",25,,"parse_relation.c",3361,


At the same time, I get errors in dashboard page.
image.png

Since I find that pgAdmin4 shows some Greenplum-specific features,
I guess pgAdmin4 supports Greenplum database, which is a Postgres-derived open-source project.

Below is the output of SELECT version();

postgres=# select version();
                                                                                               version
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.4.24 (Greenplum Database 6.4.0 build commit:564b89a8c6bef5e329a59f39dac438b13d9cb3fa) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 6.4.0, 64-bit compiled on Feb 12 2020 00:38:58
(1 row)

Time: 22.226 ms
postgres=# 


Is it possible to improve pgAdmin4 to fix this issue?

Or, Should I just turn off dashboard feature?

Best Regard.

--

徐嘉群 / Brandon Hsu 0912423813

歐立威科技 Omniwaresoft Technology Inc.

Tel: (02)-2558-2656 #117 Fax:02-2558-5559

E-mail : brandon.hsu@omniwaresoft.com.tw

部落格 : http://ravenonhill.blogspot.tw/

Address: 10349台北市大同區鄭州路 87  10 


----------------------------------------------------------------------------------------------------------------------------------------------------
本信件(包括任何附件)為機密信件。若您並非指定收信人,嚴禁複製、傳送、公開或使用其所載的全部或部份資料,任何對於本信件未經授權之使用或散播可能帶有法律責任。
若您偶然獲得此郵件,請回信或立即以電話通知寄件人並且從您的電腦系統中刪除本信件及所有附件,謝謝。
The information in this e-mail may be confidential; it is intended for use solely by the individual or entity named as the recipient hereof. Disclosure, copying, distribution, or use of the contents of this e-mail by persons other than the intended recipient may violate applicable laws and if you have received this e-mail in error, please delete the original message and notify us by collect call immediately. Thank you.

----------------------------------------------------------------------------------------------------------------------------------------------------
Вложения