hi all, my job is running on my on my local ETL, but on the server it ends with this error, after about 3h runningtime. it's not the firewall, the timeout is 6 hours.
any ideas?
cheers fritz
2019-02-13 00:18:01|20190213001800_aa9At|20190213001800_aa9At|20190213001800_aa9At|8428|INTERNE_DEV_PROJEKTE_I|A_PSRT_Transactions|_V937QCq6Eemqz42e0V5E0Q|1.2|DH_LIVE||begin||
[INFO ]: interne_dev_projekte_i.a_psrt_transactions_1_2.A_PSRT_Transactions - talendStats_CONSOLE - Printed row count: 1.
[FATAL]: interne_dev_projekte_i.a_psrt_transactions_1_2.A_PSRT_Transactions - tMysqlOutput_2 Communications link failure during rollback(). Transaction resolution unknown.
Exception in component tMysqlOutput_2
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:5086)
at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4675)
at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1650)
at interne_dev_projekte_i.a_psrt_transactions_1_2.A_PSRT_Transactions.tMysqlInput_1Process(A_PSRT_Transactions.java:8508)
at interne_dev_projekte_i.a_psrt_transactions_1_2.A_PSRT_Transactions.runJobInTOS(A_PSRT_Transactions.java:11400)
at interne_dev_projekte_i.a_psrt_transactions_1_2.A_PSRT_Transactions.main(A_PSRT_Transactions.java:11170)
[INFO ]: interne_dev_projekte_i.a_psrt_transactions_1_2.A_PSRT_Transactions - talendLogs_CONSOLE - Content of row 1: 2019-02-13 03:06:10|20190213001800_aa9At|20190213001800_aa9At|20190213001800_aa9At|INTERNE_DEV_PROJEKTE_I|A_PSRT_Transactions|DH_LIVE|6|Java Exception|tMysqlOutput_2|com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Communications link failure during rollback(). Transaction resolution unknown.|1
