sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Swarvanu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-2258) “End Of TNS Channel” when running multiple SQOOP jobs in parallel
Date Tue, 24 Mar 2015 10:46:53 GMT
Swarvanu created SQOOP-2258:

             Summary: “End Of TNS Channel” when running multiple SQOOP jobs in parallel
                 Key: SQOOP-2258
                 URL: https://issues.apache.org/jira/browse/SQOOP-2258
             Project: Sqoop
          Issue Type: Bug
            Reporter: Swarvanu
            Priority: Critical

I have a requirement which requires me to trigger mutiple parallel SQOOP jobs from separate
JVM sessions. Thus I cannot use OOZIE to trigger the jobs in parallel. When I trigger the
jobs separately I am getting the below error :

ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: End of TNS data
java.sql.SQLException: End of TNS data channel
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.apache.sqoop.manager.OracleManager.makeConnection(OracleManager.java:327)
at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:736)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:759)
at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:269)
at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240)
at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:226)
at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295)
at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1833)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1645)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)

If I trigger them sequentially they execute without any issues. The below are some salient
points about my job :

They need to execute in parallel
The do not connect to the same table
They connect to the same database (Oracle)
I am using SQOOP 1.4.5 bundled with cloudera 5.3.1

I tried to find if there was any reported issue with SQOOP parallel run but couldn't find

This message was sent by Atlassian JIRA

View raw message