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.