BUG #17645: Strange queries that stuck in database system

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: thien(dot)phan(at)apollo(dot)edu(dot)vn
Subject: BUG #17645: Strange queries that stuck in database system
Date: 2022-10-16 23:43:24
Message-ID: 17645-7cbc0f9bf94bb2a6@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17645
Logged by: Thien, Phan Phuoc
Email address: thien(dot)phan(at)apollo(dot)edu(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Facundo Etchezar 2022-10-17 01:14:17 Re: BUG #17637: case-when branches taken even if they dont match, raising errors
Previous Message Tom Lane 2022-10-16 23:21:50 Re: BUG #17644: EXPLAIN VERBOSE fails on query with SEARCH BREADTH FIRST