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

JIRA | Søren Vejrup Carlsen | 3 years ago
  1. 0

    Got this error from page http://kb-test-adm-001.kb.dk:8077/History/Harveststatus-running.jsp while testing {quote} SQL error querying runningJobsMonitor SQLException trace: SQL State:57P01 Error Code:0 org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at dk.netarkivet.harvester.datamodel.RunningJobsInfoDBDAO.getMostRecentByHarvestName(RunningJobsInfoDBDAO.java:444) at org.apache.jsp.Harveststatus_002drunning_jsp._jspService(org.apache.jsp.Harveststatus_002drunning_jsp:145) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:322) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) NextException: SQL State:08006 Error Code:0 org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at dk.netarkivet.harvester.datamodel.RunningJobsInfoDBDAO.getMostRecentByHarvestName(RunningJobsInfoDBDAO.java:444) at org.apache.jsp.Harveststatus_002drunning_jsp._jspService(org.apache.jsp.Harveststatus_002drunning_jsp:145) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:322) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: java.io.EOFException at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:271) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1700) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ... 28 more End of SQLException trace Details NetarchiveSuite Version: 4.2.0 status CODEFREEZE (r2776), TEST2139 {quote}

    JIRA | 3 years ago | Søren Vejrup Carlsen
    org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
  2. 0

    cannot insert multiple commands into a prepared statement with hibernate and postgresql 8.3.23

    Stack Overflow | 1 year ago | Wallace
    org.postgresql.util.PSQLException: ERROR: cannot insert multiple commands into a prepared statement
  3. 0

    Issue with Hibernate and Apache Tomcat

    Stack Overflow | 4 years ago | artaxerxe
    javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    PostgreSQL on cloudfoundry throws PSQLException: FATAL: terminating connection due to administrator command

    Stack Overflow | 4 years ago | user1853147
    org.springframework.dao.DataAccessResourceFailureException: Hibernate operation: could not execute query; SQL [select this_.id as id8_0_, this_.version as version8_0_, this_.language as language8_0_, this_.url as url8_0_ from sonar_adapter_configuration this_]; FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
  6. 0

    PostgreSQL connection in Java - SQLException

    Stack Overflow | 3 years ago | Judit
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "mytable" Position: 15
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    FATAL: terminating connection due to administrator command

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
    6 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyStatement.executeQuery
    1. com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
    1 frame
  4. dk.netarkivet.harvester
    RunningJobsInfoDBDAO.getMostRecentByHarvestName
    1. dk.netarkivet.harvester.datamodel.RunningJobsInfoDBDAO.getMostRecentByHarvestName(RunningJobsInfoDBDAO.java:444)
    1 frame
  5. org.apache.jsp
    Harveststatus_002drunning_jsp._jspService
    1. org.apache.jsp.Harveststatus_002drunning_jsp._jspService(org.apache.jsp.Harveststatus_002drunning_jsp:145)
    1 frame
  6. GWT dev
    HttpJspBase.service
    1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109)
    1 frame
  7. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    1 frame
  8. GWT dev
    JspServlet.service
    1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
    2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486)
    3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380)
    3 frames
  9. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    1 frame
  10. Jetty Server
    SocketConnector$Connection.run
    1. org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
    2. org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
    3. org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
    4. org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
    5. org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
    6. org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
    7. org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
    8. org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    9. org.mortbay.jetty.Server.handle(Server.java:322)
    10. org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
    11. org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928)
    12. org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
    13. org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
    14. org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
    15. org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
    15 frames
  11. Jetty Util
    QueuedThreadPool$PoolThread.run
    1. org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
    1 frame