Intermittent Teradata ConnectorException error

wgonzalez — Mon, 05 Oct 2015 23:52:32 GMT

Has anyone seen an intermittent error while exporting from HDP to external DB via Teradata Connector:

2015-09-22 13:03:29,969 WARN [main] org.apache.hadoop.mapred.YarnChild: Exception running child : com.teradata.connector.common.exception.ConnectorException: java.net.ConnectException: Connection refused 
at java.net.PlainSocketImpl.socketConnect(Native Method) 
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) 
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) 
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) 
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) 
at java.net.Socket.connect(Socket.java:579) 
at java.net.Socket.connect(Socket.java:528) 
at java.net.Socket.<init>(Socket.java:425) 
at java.net.Socket.<init>(Socket.java:208) 
at com.teradata.connector.teradata.TeradataInternalFastloadOutputFormat.getRecordWriter(TeradataInternalFastloadOutputFormat.java:301) 
at com.teradata.connector.common.ConnectorOutputFormat$ConnectorFileRecordWriter.<init>(ConnectorOutputFormat.java:84) 
at com.teradata.connector.common.ConnectorOutputFormat.getRecordWriter(ConnectorOutputFormat.java:33) 
at org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.<init>(MapTask.java:644) 
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:764) 
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) 
at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163) 
at java.security.AccessController.doPrivileged(Native Method) 
at javax.security.auth.Subject.doAs(Subject.java:415) 
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628) 
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)

The connection string is:

hadoop jar /usr/hdp/2.2.4.5-1/sqoop/lib/teradata-connector-1.3.5-hadoop220.jar com.teradata.hadoop.tool.TeradataExportTool -url jdbc:teradata://<server>/Database=PR_ODMM_STG -username PR_BATCH_ODMM_SQL -password xxxxx -errortabledatabase PR_ODMM_STG -jobtype hdfs -sourcepaths /user/hive/warehouse/edw_odmm_stg.db/omn_aggregates/batch_id=15/agg_tab_partition=STG_INTERNAL_SEARCH_KEYWORD_1 -nummappers 5 -separator \u001E -targettable STG_INTERNAL_SEARCH_KEYWORD_1 -errortablename NTERNAL_SEARCH_KEYWORD_1 -method  internal.fastload  &

Re: Intermittent Teradata ConnectorException error

nsabharwal — Tue, 06 Oct 2015 19:52:30 GMT

@wgonzalez@hortonworks.com

ConnectException: Connection refused

Please notice that and check if you are able to connect to source/target

Re: Intermittent Teradata ConnectorException error

bsaini — Tue, 06 Oct 2015 20:00:42 GMT

+1 Connection refused translates to - Unable to reach service because port is wrong.

See more details here - https://wiki.apache.org/hadoop/ConnectionRefused

Re: Intermittent Teradata ConnectorException error

nandandl — Tue, 14 Jun 2016 16:59:46 GMT

Hi, we are facing same issue. The issue in intermittent. Has anybody found the root cause for this?

Once we rerun the same job after some time it gets executed successfully.

Re: Intermittent Teradata ConnectorException error

nandandl — Tue, 14 Jun 2016 17:47:29 GMT

Hi, we are facing same issue. the issue in intermittent. Has anybody found the issue here?

Once we rerun the same job after some time it gets executed successfully.

question Re: Intermittent Teradata ConnectorException error in Support Questions

Intermittent Teradata ConnectorException error

Re: Intermittent Teradata ConnectorException error

Re: Intermittent Teradata ConnectorException error

Re: Intermittent Teradata ConnectorException error

Re: Intermittent Teradata ConnectorException error