Home > database >  Kettle connection postgresql often quote the IO error
Kettle connection postgresql often quote the IO error

Time:05-10

Kettle conversion error IO error several times every day, and restart the database service, close to open the kettle, or later can run normally, and then continue to report errors over time, validate this how to solve the problem of what a great god, troubled for a long time


The specific content of the error as follows
2021/05/09 18:13:16 - insert/update. 0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from the 2020-01-31 04.53.04 by buildguy) : ERROR in step, have everyone to stop because of:
2021/05/09 18:13:16 - insert/update -- detail. 0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from the 2020-01-31 04.53.04 by buildguy) : ERROR in step, have everyone to stop because of:
2021/05/09 18:13:16 - insert/update. 0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from the 2020-01-31 04.53.04 by buildguy) : org. Pentaho. Di. Core. Exception. KettleDatabaseException:
2021/05/09 18:13:16 - insert/update. 0 - Error & up row in the database
2021/05/09 18:13:16 - insert/update. 0 to An I/O error occurred while sending to the backend.
2021/05/09 18:13:16 - insert/update. 0
2021/05/09 18:13:16 - insert/update. 0 - at org. Pentaho. Di. Core. The database. Database. GetLookup (3108). The database Java:
2021/05/09 18:13:16 - insert/update. 0 - at org. Pentaho. Di. Core. The database. Database. GetLookup (3087). The database Java:
2021/05/09 18:13:16 - insert/update. 0 - at org. Pentaho. Di. Core. The database. Database. GetLookup (3083). The database Java:
2021/05/09 18:13:16 - insert/update. 0 - at org. Pentaho. Di. Trans. Steps. Insertupdate. Insertupdate. LookupValues (insertupdate. Java: 89)
2021/05/09 18:13:16 - insert/update. 0 - at org. Pentaho. Di. Trans. Steps. Insertupdate. Insertupdate. The processRow (insertupdate. Java: 299)
2021/05/09 18:13:16 - insert/update. 0 - at org. Pentaho. Di. Trans. Step. RunThread. Run (62) RunThread. Java:
2021/05/09 18:13:16 - insert/update. 0 - at Java. Lang. Thread. The run (748) Thread. Java:
2021/05/09 18:13:16 - insert/update. 0 - under Caused by: org. Postgresql. Util. PSQLException: An I/O error occurred while sending to the backend.
2021/05/09 18:13:16 - insert/update. 0 - at org. Postgresql. Core. The v3. QueryExecutorImpl. Execute (QueryExecutorImpl. Java: 350)
2021/05/09 18:13:16 - insert/update. 0 - at org. Postgresql. JDBC. PgStatement. ExecuteInternal (PgStatement. Java: 481)
2021/05/09 18:13:16 - insert/update. 0 - at org. Postgresql. JDBC. PgStatement. Execute (PgStatement. Java: 401)
2021/05/09 18:13:16 - insert/update. 0 - at org. Postgresql. JDBC. PgPreparedStatement. ExecuteWithFlags (PgPreparedStatement. Java: 164)
2021/05/09 18:13:16 - insert/update. 0 - at org. Postgresql. JDBC. PgPreparedStatement. ExecuteQuery (PgPreparedStatement. Java: 114)
2021/05/09 18:13:16 - insert/update. 0 - at org.apache.com mons. DBCP. DelegatingPreparedStatement. ExecuteQuery (DelegatingPreparedStatement. Java: 96)
2021/05/09 18:13:16 - insert/update. 0 - at org.apache.com mons. DBCP. DelegatingPreparedStatement. ExecuteQuery (DelegatingPreparedStatement. Java: 96)
2021/05/09 18:13:16 - insert/update. 0 - at org. Pentaho. Di. Core. The database. Database. GetLookup (3093). The database Java:
2021/05/09 18:13:16 - insert/update. 0 -... Six more
2021/05/09 18:13:16 - insert/update. 0 - under Caused by: java.net.SocketException: Connection reset by peer: socket write error
2021/05/09 18:13:16 - insert/update. 0 - at java.net.SocketOutputStream.socketWrite0 (Native Method)
2021/05/09 18:13:16 - insert/update. 0 - at java.net.SocketOutputStream.socketWrite (111). SocketOutputStream that Java:
2021/05/09 18:13:16 - insert/update. 0 - at java.net.SocketOutputStream.write (155). SocketOutputStream that Java:
2021/05/09 18:13:16 - insert/update. 0 - at sun. Security. SSL. OutputRecord. WriteBuffer (OutputRecord. Java: 431)
2021/05/09 18:13:16 - insert/update. 0 - at sun. Security. SSL. OutputRecord. Write (OutputRecord. Java: 417)
2021/05/09 18:13:16 - insert/update. 0 - at sun. Security. SSL. SSLSocketImpl. WriteRecordInternal (SSLSocketImpl. Java: 886)
2021/05/09 18:13:16 - insert/update. 0 - at sun. Security. SSL. SSLSocketImpl. WriteRecord (SSLSocketImpl. Java: 857)
2021/05/09 18:13:16 - insert/update. 0 - at sun. Security. SSL. AppOutputStream. Write (AppOutputStream. Java: 123)
2021/05/09 18:13:16 - insert/update. 0 - at Java. IO. BufferedOutputStream. FlushBuffer (BufferedOutputStream. Java: 82)
2021/05/09 18:13:16 - insert/update. 0 - at Java. IO. BufferedOutputStream. Flush (BufferedOutputStream. Java: 140)
2021/05/09 18:13:16 - insert/update. 0 - at org. Postgresql. Core. PGStream. Flush (PGStream. Java: 665)
2021/05/09 18:13:16 - insert/update. 0 - at org. Postgresql. Core. The v3. QueryExecutorImpl. SendSync (QueryExecutorImpl. Java: 1470)
2021/05/09 18:13:16 - insert/update. 0 - at org. Postgresql. Core. The v3. QueryExecutorImpl. Execute (QueryExecutorImpl. Java: 321)
2021/05/09 18:13:16 - insert/update. 0 -... 13 more
2021/05/09 18:13:16 - insert/update -- detail. 0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from the 2020-01-31 04.53.04 by buildguy) : org. Pentaho. Di. Core. Exception. KettleDatabaseException:
2021/05/09 18:13:16 - insert/update -- detail. 0 - Error & up row in the database
2021/05/09 18:13:16 - insert/update -- detail. 0 to An I/O error occurred while sending to the backend.
2021/05/09 18:13:16 - insert/update -- detail. 0
2021/05/09 18:13:16 - insert/update -- detail. 0 - at org. Pentaho. Di. Core. The database. Database. GetLookup (3108). The database Java:
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related