tool.ImportTool: Encountered IOException running import job: java.io.IOException: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.

Stack Overflow | CodeGeek123 | 5 months ago
  1. 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.
  2. 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.
  3. 0

    GitHub comment 27#88879476

    GitHub | 2 years ago | brantg
    org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 27#88880027

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

    PO very slow on zkwebui

    adempiere | 5 years ago | bma99
    org.postgresql.util.PSQLException: ERROR: syntax error at or near ""limit""   Position: 501; State=42601; ErrorCode=0

  1. csanyigabor 4 times, last 3 months ago
  2. Tahir 1 times, last 3 months ago
  3. RoiOtero 3 times, last 5 months ago
  4. haerick 8 times, last 6 months ago
  5. silex 15 times, last 6 months ago
2 more registered users
33 unregistered visitors
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. org.apache.sqoop
    DataDrivenDBInputFormat.getSplits
    1. org.apache.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:149)
    1 frame
  4. Hadoop
    Job$10.run
    1. org.apache.hadoop.mapreduce.JobSubmitter.writeNewSplits(JobSubmitter.java:301)
    2. org.apache.hadoop.mapreduce.JobSubmitter.writeSplits(JobSubmitter.java:318)
    3. org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:196)
    4. org.apache.hadoop.mapreduce.Job$10.run(Job.java:1290)
    5. org.apache.hadoop.mapreduce.Job$10.run(Job.java:1287)
    5 frames
  5. Java RT
    Subject.doAs
    1. java.security.AccessController.doPrivileged(Native Method)
    2. javax.security.auth.Subject.doAs(Subject.java:422)
    2 frames
  6. Hadoop
    UserGroupInformation.doAs
    1. org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1709)
    1 frame
  7. Hadoop
    Job.waitForCompletion
    1. org.apache.hadoop.mapreduce.Job.submit(Job.java:1287)
    2. org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:1308)
    2 frames
  8. org.apache.sqoop
    Sqoop.run
    1. org.apache.sqoop.mapreduce.ImportJobBase.doSubmitJob(ImportJobBase.java:196)
    2. org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:169)
    3. org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:266)
    4. org.apache.sqoop.manager.SqlManager.importQuery(SqlManager.java:729)
    5. org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:499)
    6. org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
    7. org.apache.sqoop.Sqoop.run(Sqoop.java:148)
    7 frames
  9. Hadoop
    ToolRunner.run
    1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
    1 frame
  10. org.apache.sqoop
    Sqoop.main
    1. org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184)
    2. org.apache.sqoop.Sqoop.runTool(Sqoop.java:226)
    3. org.apache.sqoop.Sqoop.runTool(Sqoop.java:235)
    4. org.apache.sqoop.Sqoop.main(Sqoop.java:244)
    4 frames