org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.

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: An I/O error occured while sending to the backend.
  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

    Sqoop Query on PostgresSQL returns Backend I/O Exception

    Stack Overflow | 5 months ago | CodeGeek123
    tool.ImportTool: Encountered IOException running import job: java.io.IOException: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 27#88879476

    GitHub | 2 years ago | brantg
    org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
  6. 0

    GitHub comment 27#88880027

    GitHub | 2 years ago | ahsanhadi
    org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
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. java.io.EOFException

    No message provided

    at org.postgresql.core.PGStream.ReceiveChar()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.PGStream.ReceiveChar(PGStream.java:271)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1700)
    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