Communications link failure during rollback()

0

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

fritz.eissler's picture
Joined: Feb 12 2019 - 8:15am
Last seen: 5 months 3 days ago

0 Answers:

No answers yet
Feedback
randomness