Re: BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command
Дата
Msg-id CAKFQuwYtSJKEZQzwih28Ukb5Tenh4p=ahwxo2gBMZdJLRd26vQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command  (Kevin Wolf <kwolf@veritone.com>)
Список pgsql-bugs
Дерево обсуждения
On Wed, Jun 22, 2022 at 8:27 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17529
Logged by:          Kevin Wolf
Email address:      kwolf@veritone.com
PostgreSQL version: 11.8
Operating system:   macbook
Description:       

When running the following command, it returns the terminating connection
error message due to administrator command

SELECT  i.indexrelid::regclass,
       s.leaf_fragmentation
FROM pg_index AS i
   JOIN pg_class AS t ON i.indexrelid = t.oid
   JOIN pg_opclass AS opc ON i.indclass[0] = opc.oid
   JOIN pg_am ON opc.opcmethod = pg_am.oid
   CROSS JOIN LATERAL pgstatindex(i.indexrelid) AS s
   where s.leaf_fragmentation > 80
   and s.leaf_fragmentation != 'NaN'::NUMERIC
   --order by 2 desc
   limit 10


I cannot reproduce on HEAD (in basically an empty database) and you are 2 years out of support.  Please upgrade to 11.16 and try again.

Please try to produce a somewhat more succinct test case and log output, preferably without JDBC involved (that query can be executed in psql) should the problem persist after updating to the current supported release.

David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Postgres do not allow to create many tables with more than 63-symbols prefix
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #17530: pg_dump comment on triggers is "off" by comparison to all of the other objects...