topic Re: TDBSP in Talend Studio

TDBSP

Arbi — Tue, 05 Mar 2024 09:35:02 GMT

Hello ,

I have a Talend job on TAC that uses the tDBSP component to execute a stored procedure on MariaDB. Despite the stored procedure execution finishing, the tDBSP component does not stop, and the job remains running indefinitely.

Talend Version 8

tDBSP_1 (conn=285651) Socket error
java.sql.SQLNonTransientConnectionException: (conn=285651) Socket error

Re: TDBSP

Arbi — Tue, 05 Mar 2024 09:19:30 GMT

Hello ,

Can anyone help me with this?

Re: TDBSP

Xiaodi_Shi — Tue, 05 Mar 2024 10:16:51 GMT

Hello,

We need a little bit more information to address your issue. Could you please let us know if there is any more error message in TAC technical log?

Please try to restart the JobServer as TalendUser and re-trigger the job to see if it could resolve this issue?

Best regards

Sabrina

Re: TDBSP

Arbi — Tue, 05 Mar 2024 10:58:19 GMT

Hello sabrina ,

Caused by: java.net.SocketException: Connexion terminée par expiration du délai d'attente (Read failed)

I have the same issue on my Studio and TAC

Re: TDBSP

Arbi — Tue, 05 Mar 2024 21:04:26 GMT

hello

The tMysqlSP component is still running even the stored procedure has been completed on the data base maria db . I've had the same problem when I run the job on tac or from my studio.

the job works fine if I run it on the test environment.

I try to execute the stored procedure With the component tMysqlRow and also With java code on Tjava but i have the same issue

Re: TDBSP

Xiaodi_Shi — Wed, 06 Mar 2024 02:33:17 GMT

Hello,

It has problems with timeout exceptions.

Do your own firewalls seem to be the reason of the timeout? If not, what does your your stored procedure look like? Is the problem within the code logic?

Best regards

Sabrina