fritz.eissler Posted February 13, 2019 Share Posted February 13, 2019 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 fritz2019-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_2com.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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now