BUG #15493: Wrong name of fields/missing fields for the internalstatistic - Mailing list pgsql-bugs
| From | PG Bug reporting form |
|---|---|
| Subject | BUG #15493: Wrong name of fields/missing fields for the internalstatistic |
| Date | |
| Msg-id | 15493-c69664b13991e9b6@postgresql.org Whole thread Raw |
| Responses |
Re: BUG #15493: Wrong name of fields/missing fields for the internal statistic
Re: BUG #15493: Wrong name of fields/missing fields for the internal statistic |
| List | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15493
Logged by: - -
Email address: frank.buettner@mdc-berlin.de
PostgreSQL version: 11.0
Operating system: CentOS 7.5
Description:
How to produce:
- Simple install pgsql 11 on CentOS from yum repo of postgresql.org
- init the cluster
- start the server
- wait some time
After some times, many errors are logged about not existing fields.
< 2018-11-08 14:21:59.820 CET >ERROR: column "procpid" does not exist at
character 132
< 2018-11-08 14:21:59.820 CET >STATEMENT: SELECT datname, datid, usename,
client_addr, '' AS state, COALESCE(ROUND(EXTRACT(epoch FROM
now()-query_start)),0) AS seconds,
procpid as pid, regexp_replace(current_query, E'[\n\r\u2028]+', '
', 'g' ) AS current_query FROM pg_stat_activity WHERE (query_start IS NOT
NULL AND current_query NOT LIKE '<IDLE>%') ORDER BY query_start, procpid
DESC;
< 2018-11-08 14:22:00.117 CET >ERROR: column "current_query" does not exist
at character 200
< 2018-11-08 14:22:00.117 CET >STATEMENT: SELECT COUNT(datid) AS current,
(SELECT setting AS mc FROM pg_settings WHERE name =
'max_connections') AS mc,
d.datname
FROM pg_database d
LEFT JOIN pg_stat_activity s ON (s.datid = d.oid) WHERE
current_query <> '<IDLE>'
GROUP BY 2,3
ORDER BY datname
When I look in the database I can see, that the field has other name:
postgres=# \d+ pg_stat_activity
View "pg_catalog.pg_stat_activity"
Column | Type | Collation | Nullable |
Default | Storage | Description
------------------+--------------------------+-----------+----------+---------+----------+-------------
datid | oid | | |
| plain |
datname | name | | |
| plain |
pid | integer | | |
| plain |
And pg_settings has no column current_query:
postgres=# \d+ pg_settings
View "pg_catalog.pg_settings"
Column | Type | Collation | Nullable | Default | Storage |
Description
-----------------+---------+-----------+----------+---------+----------+-------------
name | text | | | | extended |
setting | text | | | | extended |
unit | text | | | | extended |
category | text | | | | extended |
short_desc | text | | | | extended |
extra_desc | text | | | | extended |
context | text | | | | extended |
vartype | text | | | | extended |
source | text | | | | extended |
min_val | text | | | | extended |
max_val | text | | | | extended |
enumvals | text[] | | | | extended |
boot_val | text | | | | extended |
reset_val | text | | | | extended |
sourcefile | text | | | | extended |
sourceline | integer | | | | plain |
pending_restart | boolean | | | | plain |
pgsql-bugs by date: