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

Started by PG Bug reporting formalmost 4 years ago7 messagesbugs

noreply@postgresql.org

almost 4 years ago

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

Kevin Wolf

kwolf@veritone.com

almost 4 years ago

In reply to: PG Bug reporting form (#1)

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

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