Exception in component tPostgresqlInput_1 org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.

[Vjhu]

Hello,

I am having the following error :

Exception in component tPostgresqlInput_1

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

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)

at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:791)

at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:815)

at testcon.test_0_1.test.tPostgresqlInput_1Process(test.java:691)

at testcon.test_0_1.test.runJobInTOS(test.java:966)

at testcon.test_0_1.test.main(test.java:823)

Caused by: java.net.SocketException: Connection reset

at java.net.SocketInputStream.read(Unknown Source)

at java.net.SocketInputStream.read(Unknown Source)

at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:143)

at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:112)

at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:71)

at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:282)

[statistics] disconnected

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1803)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

... 5 more

Job test ended at 17:40 09/11/2020. [exit code=1]

1189 rows are being extracted, however i have the above error.

Query in the tPostgresqlInput:

"select id,  debtor_reference,  client_number from open.t_debtor"

Can anyone help me please?

[Anonymous]

Hello,

Have you tried Connection and ConnectionClose components?

Best regards

Sabrina

[Vjhu]

Hello Sabrina,

Thank you for your help.

Yes i had use them, it was not working.

Today I have run the main job again without any modification , it works without error.

Maybe the issue was related with the DB.

[Anonymous]

Hello,

Feel free to let us know if this issue repro again from your end.

Best regards

Sabrina