Sqoop Import Fails after Multiple Retries

Technical Discussions Sqoop
#1

Hi,
While Trying to use SQOOP IMPORT, it’s retrying for Max number of times and exiting without any actual imports happenening.

SQOOP EVAL is working fine!

Kindly look into it and help me out!

I’ve connected to Sqoop few months back and it was working fine then.

–username sqoopuser
–password NHkkP876rp
–table order_items
–warehouse-dir /user/yasartoshare4263/sqoop_import/retail_db
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/21 07:13:31 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.2.0-205
20/01/21 07:13:31 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
20/01/21 07:13:31 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
20/01/21 07:13:31 INFO tool.CodeGenTool: Beginning code generation
20/01/21 07:13:32 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM order_items AS t LIMIT 1
20/01/21 07:13:32 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM order_items AS t LIMIT 1
20/01/21 07:13:32 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/hdp/2.6.2.0-205/hadoop-mapreduce
Note: /tmp/sqoop-yasartoshare4263/compile/be52cc9d513b993e3bc5fe1f82ae3940/order_items.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
20/01/21 07:13:34 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-yasartoshare4263/compile/be52cc9d513b993e3bc5fe1f82ae3940/order_items.jar
20/01/21 07:13:34 WARN manager.MySQLManager: It looks like you are importing from mysql.
20/01/21 07:13:34 WARN manager.MySQLManager: This transfer can be faster! Use the --direct
20/01/21 07:13:34 WARN manager.MySQLManager: option to exercise a MySQL-specific fast path.
20/01/21 07:13:34 INFO manager.MySQLManager: Setting zero DATETIME behavior to convertToNull (mysql)
20/01/21 07:13:34 INFO mapreduce.ImportJobBase: Beginning import of order_items
20/01/21 07:13:35 INFO client.RMProxy: Connecting to ResourceManager at cxln2.c.thelab-240901.internal/10.142.1.2:8050
20/01/21 07:13:35 INFO client.AHSProxy: Connecting to Application History server at cxln2.c.thelab-240901.internal/10.142.1.2:10200
20/01/21 07:13:37 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/21 07:13:38 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/21 07:13:39 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/21 07:13:40 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/21 07:13:41 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/21 07:13:42 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
)
20/01/21 07:13:43 INFO ipc.Client: Retrying connect to server: cxln2.c.thelab-240901.internal/10.142.1.2:8050. Already tried 6 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS
)
20/01/21 07:13:44 INFO ipc.Client: Retrying connect to server: cxln2.c.thelab-240901.internal/10.142.1.2:8050. Already tried 7 time(s); retry policy is RetryUpToMaximumCountWithFixedSleep(maxRetries=50, sleepTime=1000 MILLISECONDS
)

#2

Even I was getting the same error. I was trying to retrieve only 3 rows.

#3

Similar issue for me, tried multiple tables issue is redundant

#4

Looks like nobody from SUpport Team cares on this issue???!

#5

We have already fixed the issue

#6

It’s working Now! Thanks!