Jump to content
JasperReports Library 7.0 is now available ×

Communications link failure during rollback()


fritz.eissler

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...