From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: thien.phan@apollo.edu.vn
Subject: BUG #17645: Strange queries that stuck in database system
Date: Sun, 16 Oct 2022 23:43:24 +0000
Message-ID: <17645-7cbc0f9bf94bb2a6@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17645
Logged by: Thien, Phan Phuoc
Email address: thien.phan@apollo.edu.vn
PostgreSQL version: 14.0
Operating system: Windows Server 2012 R2
Description:
Hi,
When I run this query
SELECT NOW() - query_start AS elapsed, pid, client_addr, query,
query_start, *
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start DESc;
I noticed that there are many queries (as below) that create many Windows
processes and CPU is 100%. Is it a bug? Please help!
Thank you very much!
Thien Phan
-- Load field definitions for (free-standing) composite types
SELECT typ.oid, att.attname, att.atttypid
FROM pg_type AS typ
JOIN pg_namespace AS ns ON (ns.oid = typ.typnamespace)
JOIN pg_class AS cls ON (cls.oid = typ.typrelid)
JOIN pg_attribute AS att ON (att.attrelid = typ.typrelid)
WHERE
(typ.typtype = 'c' AND cls.relkind='c') AND
attnum > 0 AND -- Don't load system attributes
NOT attisdropped
ORDER BY typ.oid, att.attnum
2022-10-17 00:01:21.117 +07 [[unknown]][4800][apollo_portal] FATAL:
terminating connection due to administrator command
2022-10-17 00:01:21.117 +07 [[unknown]][4800][apollo_portal] STATEMENT: --
Load field definitions for (free-standing) composite types
SELECT typ.oid, att.attname, att.atttypid
FROM pg_type AS typ
JOIN pg_namespace AS ns ON (ns.oid = typ.typnamespace)
JOIN pg_class AS cls ON (cls.oid = typ.typrelid)
JOIN pg_attribute AS att ON (att.attrelid = typ.typrelid)
WHERE
(typ.typtype = 'c' AND cls.relkind='c') AND
attnum > 0 AND -- Don't load system attributes
NOT attisdropped
ORDER BY typ.oid, att.attnum
2022-10-17 00:01:21.118 +07 [[unknown]][6340][apollo_portal] LOG: could not
send data to client: An established connection was aborted by the software
in your host machine.
2022-10-17 00:01:21.118 +07 [[unknown]][6340][apollo_portal] STATEMENT: --
Load field definitions for (free-standing) composite types
SELECT typ.oid, att.attname, att.atttypid
FROM pg_type AS typ
JOIN pg_namespace AS ns ON (ns.oid = typ.typnamespace)
JOIN pg_class AS cls ON (cls.oid = typ.typrelid)
JOIN pg_attribute AS att ON (att.attrelid = typ.typrelid)
WHERE
(typ.typtype = 'c' AND cls.relkind='c') AND
attnum > 0 AND -- Don't load system attributes
NOT attisdropped
ORDER BY typ.oid, att.attnum
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, thien.phan@apollo.edu.vn
Subject: Re: BUG #17645: Strange queries that stuck in database system
In-Reply-To: <17645-7cbc0f9bf94bb2a6@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox