Sqoop Import Error "Retrying connect to server"


#1

Getting connectivity error while doing the sqoop import, below given are the details and please clarify what’s causing this issue.

sqoop import
-D hadoop.security.credential.provider.path=jceks://hdfs//user/biswajitjena20077682/mysqldb.password.jceks
–connect jdbc:mysql://10.142.1.2/sqoopex
–username sqoopuser
–password-alias mysqldb.password
–m 2
–table hiveemployees
–target-dir /user/biswajitjena20077682/sqoop/import
–append
–as-parquetfile

SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/usr/hdp/2.6.2.0-205/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/usr/hdp/2.6.2.0-205/accumulo/lib/slf4j-log4j12.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]20/01/20 15:10:48 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.2.0-20520/01/20 15:10:50 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.20/01/20 15:10:50 INFO tool.CodeGenTool: Beginning code generation20/01/20 15:10:50 INFO tool.CodeGenTool: Will generate java class as codegen_hiveemployees20/01/20 15:10:50 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM hiveemployees AS t LIMIT 120/01/20 15:10:50 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM hiveemployees AS t LIMIT 120/01/20 15:10:50 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/hdp/2.6.2.0-205/hadoop-mapreduceNote: /tmp/sqoop-biswajitjena20077682/compile/8c0a8203d12152b22b0eeb575d649c31/codegen_hiveemployees.java uses or overrides a deprecated API.Note: Recompile with -Xlint:deprecation for details.20/01/20 15:10:52 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-biswajitjena20077682/compile/8c0a8203d12152b22b0eeb575d649c31/codegen_hiveemployees.jar20/01/20 15:10:52 WARN manager.MySQLManager: It looks like you are importing from mysql.20/01/20 15:10:52 WARN manager.MySQLManager: This transfer can be faster! Use the --direct20/01/20 15:10:52 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.20/01/20 15:10:52 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)20/01/20 15:10:52 INFO mapreduce.ImportJobBase: Beginning import of hiveemployees20/01/20 15:10:52 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM hiveemployees AS t LIMIT 120/01/20 15:10:52 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM hiveemployees AS t LIMIT 120/01/20 15:10:53 INFO client.RMProxy: Connecting to ResourceManager at cxln2.c.thelab-240901.internal/10.142.1.2:805020/01/20 15:10:53 INFO client.AHSProxy: Connecting to Application History server at cxln2.c.thelab-240901.internal/10.142.1.2:1020020/01/20 15:10:54 INFO ipc.Client: Retrying connect to server: cxln2.c.thelab-240901.internal/10.142.1.2:8050. Already tried 0 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS)20/01/20 15:10:55 INFO ipc.Client: Retrying connect to server: cxln2.c.thelab-240901.internal/10.142.1.2:8050. Already tried 1 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS)20/01/20 15:10:56 INFO ipc.Client: Retrying connect to server: cxln2.c.thelab-240901.internal/10.142.1.2:8050. Already tried 2 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS)20/01/20 15:10:57 INFO ipc.Client: Retrying connect to server: cxln2.c.thelab-240901.internal/10.142.1.2:8050. Already tried 3 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS)20/01/20 15:10:58 INFO ipc.Client: Retrying connect to server: cxln2.c.thelab-240901.internal/10.142.1.2:8050. Already tried 4 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS)20/01/20 15:10:59 INFO ipc.Client: Retrying connect to server: cxln2.c.thelab-240901.internal/10.142.1.2:8050. Already tried 5 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS)


#2

Hi,

There is some problem in YARN. I’m checking the logs.

In the mean while I have again restarted it.