BUG #17645: Strange queries that stuck in database system

Поиск
Список
Период
Сортировка
Искать
От
PG Bug reporting form
Тема
BUG #17645: Strange queries that stuck in database system
Дата
Msg-id
17645-7cbc0f9bf94bb2a6@postgresql.org
Список
Дерево обсуждения
BUG #17645: Strange queries that stuck in database system PG Bug reporting form <noreply@postgresql.org>
Re: BUG #17645: Strange queries that stuck in database system Julien Rouhaud <rjuju123@gmail.com>
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 != ''  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

В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата:
От: Facundo Etchezar
Дата:
FAQ