topic Re: tAmazonAuroraConnection getting connection error in Talend Studio

tAmazonAuroraConnection getting connection error

Anonymous — Fri, 15 Feb 2019 06:52:29 GMT

Hi All,

I am using tAmazonAuroraConnection for connecting aurora DB, but getting the below error.

"Starting job testjob at 10:47 15/02/2019.

[statistics] connecting to socket on port 3744
[statistics] connected
Exception in component tDBConnection_1_in (testjob)
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1127)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:674)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1086)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2506)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at local_project.testjob_0_1.testjob.tDBConnection_1_inProcess(testjob.java:381)
at local_project.testjob_0_1.testjob.runJobInTOS(testjob.java:832)
at local_project.testjob_0_1.testjob.main(testjob.java:683)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3161)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:598)
... 18 more
[statistics] disconnected"

The host and port used for connecting through Talend has been working though SQL workbench and Telnet to the server is also working . Tried changing the Additional JDBC Parameter: "noDatetimeStringSync" to Additional JDBC Parameter: "noDatetimeStringSync=true&useSSL=true&requireSSL=true" but it didn't help.

Re: tAmazonAuroraConnection getting connection error

Anonymous — Fri, 15 Feb 2019 06:54:38 GMT

Adding the pentaho version used: TOS_BD-20181026_1147-V7.1.1

Re: tAmazonAuroraConnection getting connection error

vapukov — Fri, 15 Feb 2019 07:16:43 GMT

hi,

could you connect from same machine to AWS Aurora with another application?

what do you use?

Re: tAmazonAuroraConnection getting connection error

Anonymous — Fri, 15 Feb 2019 12:07:54 GMT

Yes I was able to connect through another application. I have found a workaround for this issue, the aurora DB configured in AWS is using postgreSQL engine but the talend tAmazonAurora components are using MySQL engine. I used a normal DB component and choose the DB type as postgreSQL after setting up the metadata connection for the same which led to the installation of the required postgreSQL jar file and now the job is running fine.

Re: tAmazonAuroraConnection getting connection error

vapukov — Fri, 15 Feb 2019 12:11:26 GMT

perfect,

this is not an issue - aws aurora for mysql and aws aurora for postgresql it is 2 different product, and aurora for postgresql younger than for mysql

just when talend "name" the component aurora was only for mysql it was a synonyms

Re: tAmazonAuroraConnection getting connection error

Anonymous — Fri, 29 Nov 2019 13:14:18 GMT

I have a similar situation, but I stuck on something else.

Else the DB is on PostgreSQL, so my data extraction process took 15 minutes.

Now the DB is migrated on Amazon aurora, I am using the same component on Talend, same job, same data volume all same but now the execution time is raised to 45 minutes.

Re: tAmazonAuroraConnection getting connection error

Anonymous — Fri, 29 Nov 2019 13:15:15 GMT

*else the DB --> Earlier the DB