(conn=1910) Read timed out

FGuijarro — Sun, 25 Oct 2020 10:00:01 GMT

Hi,

I´m using Talend Open Studio 7.3.1

I´m trying to merge 10 tables (one for each month from Jan to Oct) from DB_1 to ONE table in DB_2

The workspace is on my laptop
INPUT (10 tables) are on Server_1, DB_1. Each table has around 15.000.000 rows
OUTPUT is just one table on Server_2, DB_2

To connect to the Server_1 and to the Server_2, I need to connect a VPN.

The process starts OK but after 3-4hours, Talend gives me an error. I think it´s because VPN was disconnected automatically but I´m not sure although my internet conection is still connected.

Can you help me with this, please? The error message is:

Starting job Inteligencia_Negocio_JOB at 21:59 24/10/2020.

[statistics] connecting to socket on port 4000

[statistics] connected

(conn=1910) Read timed out

Exception in component tDBOutput_1 (Inteligencia_Negocio_JOB)

java.sql.SQLException: Cannot do an operation on a closed statement

at org.mariadb.jdbc.MariaDbStatement.checkClose(MariaDbStatement.java:1512)

at org.mariadb.jdbc.ClientSidePreparedStatement.executeBatch(ClientSidePreparedStatement.java:280)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.tDBInput_1Process(Inteligencia_Negocio_JOB.java:1936)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.tDBRow_3Process(Inteligencia_Negocio_JOB.java:977)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.tDBRow_2Process(Inteligencia_Negocio_JOB.java:755)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.tDBRow_1Process(Inteligencia_Negocio_JOB.java:530)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.runJobInTOS(Inteligencia_Negocio_JOB.java:2465)

at proyecto_in_2020.inteligencia_negocio_job_0_1.Inteligencia_Negocio_JOB.main(Inteligencia_Negocio_JOB.java:2314)

[statistics] disconnected

Re: (conn=1910) Read timed out

Anonymous — Mon, 26 Oct 2020 03:58:40 GMT

Hello,

It looks like the DB connection is closed.

Are you adding tDBclose and tDBcommit components in your work flow? Screenshots of your job design will be preferred.

Best regards

Sabrina

Re: (conn=1910) Read timed out

FGuijarro — Mon, 26 Oct 2020 10:35:17 GMT

Hi Sabrina,

Thank you for your answer. I really appreciate it!

To connect the DB to the server, it´s always under a VPN so is it possible that VPN start the sleep mode and was disconnected??

This is the design:

Thank you for your feedback!

Best Regards,

Fernando.

topic (conn=1910) Read timed out in Talend Studio

(conn=1910) Read timed out

Re: (conn=1910) Read timed out

Re: (conn=1910) Read timed out