From: | Brandon Hsu <brandon(dot)hsu(at)omniwaresoft(dot)com(dot)tw> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | pgAdmin4 connecting to Greenplum Community Edition v6.4 shows error |
Date: | 2020-04-17 02:37:48 |
Message-ID: | CA+JYH_0A9+t9Q65XDqzSir5Q6W7WcFR4upEzn8O-xT6YB454eA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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: 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(dot)hsu(at)omniwaresoft(dot)com(dot)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.
----------------------------------------------------------------------------------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Arnav | 2020-04-17 12:27:41 | View pervious versions of row |
Previous Message | Brandon Hsu | 2020-04-17 02:09:05 | Re: pgAdmin4 dependency package "python3-psycopg2" should be place in "pgdg-common" repo. |