We are migrating from Red Hat to Centos and facing issue in our Talend ETL Job

Issues related to applications and software problems
Post Reply
sdpak_99
Posts: 1
Joined: 2018/10/28 23:48:10

We are migrating from Red Hat to Centos and facing issue in our Talend ETL Job

Post by sdpak_99 » 2018/10/28 23:51:49

Hi Team,

We are migrating from Red Hat to Centos and facing issue in our Talend ETL Job (this is basically using OJDBC7 and java internally to read from an oracle table).

We use Java 1.7

In Red Hat we don't face any problem.

However in Centos we intermittently face

java.sql.SQLRecoverableException: IO Error: Connection reset
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:682)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at....
Caused by: java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:115)
at java.net.SocketOutputStream.write(SocketOutputStream.java:155)


Wanted to understand if this is a common problem and how do CENTOS users resolve this?

Thanks,
Deepak

User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: We are migrating from Red Hat to Centos and facing issue in our Talend ETL Job

Post by TrevorH » 2018/10/29 00:11:18

Since they are built from the same sources, the problem is unlikely to be a direct RHEL vs CentOS issue. Are your RHEL and CentOS versions identical? Are all packages at the exact same level? Was the setup done manually or using some configuration management package that ensures an identical setup.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

Post Reply