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

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

Vjhu — Sat, 16 Nov 2024 01:09:08 GMT

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 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 — Tue, 10 Nov 2020 05:13:42 GMT

Hello,

Have you tried Connection and ConnectionClose components?

Best regards

Sabrina

Vjhu — Tue, 10 Nov 2020 09:46:22 GMT

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 — Wed, 11 Nov 2020 05:10:39 GMT

Hello,

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

Best regards

Sabrina