Обсуждение: BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command

Поиск

Список

Период

Сортировка

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

От

PG Bug reporting form

Дата:

22 июня 2022 г., 23:37:27

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

Additional error info: data source was invalidated

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

От

Kevin Wolf

Дата:

22 июня 2022 г., 23:46:09

Additional information from the log:

!SESSION 2022-06-22 15:44:46.278 -----------------------------------------------

eclipse.buildId=unknown

java.version=11.0.12

java.vendor=Eclipse Foundation

BootLoader constants: OS=macosx, ARCH=x86_64, WS=cocoa, NL=en_US

Framework arguments: -keyring /Users/kwolf/.eclipse_keyring

Command-line arguments: -os macosx -ws cocoa -arch x86_64 -keyring /Users/kwolf/.eclipse_keyring

!ENTRY org.jkiss.dbeaver.model 4 0 2022-06-22 15:58:21.480

!MESSAGE Operation failed. Retry count remains = 1

!SUBENTRY 1 org.jkiss.dbeaver.model 4 0 2022-06-22 15:58:21.481

!MESSAGE SQL Error [57P01]: FATAL: terminating connection due to administrator command

!SUBENTRY 2 org.jkiss.dbeaver.model 4 0 2022-06-22 15:58:21.481

!MESSAGE FATAL: terminating connection due to administrator command

!STACK 0

org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2565)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2297)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322)

at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322)

at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279)

at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:329)

at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.lambda$0(JDBCStatementImpl.java:131)

at org.jkiss.dbeaver.utils.SecurityManagerUtils.wrapDriverActions(SecurityManagerUtils.java:94)

at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)

at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:575)

at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$1(SQLQueryJob.java:484)

at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:172)

at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:491)

at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:878)

at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3526)

at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118)

at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:172)

at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116)

at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4868)

at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

!SUBENTRY 3 org.jkiss.dbeaver.model 4 0 2022-06-22 15:58:21.481

!MESSAGE An I/O error occurred while sending to the backend.

!ENTRY org.jkiss.dbeaver.model 4 0 2022-06-22 16:03:53.594

!MESSAGE Operation failed. Retry count remains = 1

!SUBENTRY 1 org.jkiss.dbeaver.model 4 0 2022-06-22 16:03:53.594

!MESSAGE SQL Error [57P01]: FATAL: terminating connection due to administrator command

!SUBENTRY 2 org.jkiss.dbeaver.model 4 0 2022-06-22 16:03:53.594