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 обсуждение исходный текст |
Ответы |
Re: BUG #17645: Strange queries that stuck in database system
|
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: