Hi Hakki, would you mind sharing jstack of the stuck process? Jarcec
On Wed, Apr 24, 2013 at 09:58:56AM +0300, hakki buyukcengiz wrote: > Hi, > > I had running sqoop export commands like: > > sqoop export --connect 'jdbc:oracle:thin:@<ip>:<port>:<service>' --username > DUMMY --password 'DUMMY' --table TEST_STG --export-dir > /user/export_import/SQOOP --fields-terminated-by '\t' --lines-terminated-by > '\n' > > This command had run successfully but suddenly it become falling into > stuck. When I start, it prints the normal message like this: > > [root@devnode1 ~]# sqoop export --connect > 'jdbc:oracle:thin:@<ip>:<port>:<service>' > --username DUMMY --password 'DUMMY' --table TEST_STG --export-dir > /user/export_import/SQOOP --fields-terminated-by '\t' --lines-terminated-by > '\n' > 13/04/24 09:46:19 WARN tool.BaseSqoopTool: Setting your password on the > command-line is insecure. Consider using -P instead. > 13/04/24 09:46:19 INFO manager.SqlManager: Using default fetchSize of 1000 > 13/04/24 09:46:19 INFO tool.CodeGenTool: Beginning code generation > 13/04/24 09:46:31 INFO manager.OracleManager: Time zone has been set to GMT > 13/04/24 09:46:31 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM TEST_STG t WHERE 1=0 > 13/04/24 09:46:31 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is > /opt/cloudera/parcels/CDH-4.2.0-1.cdh4.2.0.p0.10/bin/../lib/hadoop-0.20-mapreduce > 13/04/24 09:46:31 INFO orm.CompilationManager: Found hadoop core jar at: > /opt/cloudera/parcels/CDH-4.2.0-1.cdh4.2.0.p0.10/bin/../lib/hadoop-0.20-mapreduce/hadoop-2.0.0-mr1-cdh4.2.0-core.jar > Note: > /tmp/sqoop-root/compile/13ac98badc5d4c43ab02815245c500e8/TEST_STG.java uses > or overrides a deprecated API. > Note: Recompile with -Xlint:deprecation for details. > 13/04/24 09:46:33 INFO orm.CompilationManager: Writing jar file: > /tmp/sqoop-root/compile/13ac98badc5d4c43ab02815245c500e8/TEST_STG.jar > 13/04/24 09:46:33 INFO mapreduce.ExportJobBase: Beginning export of > TEST_STG_HAKKI_4 > 13/04/24 09:46:34 INFO manager.OracleManager: Time zone has been set to GMT > > > And after this point sqoop gives no further message. It inserts no record > to the db too. > What can be the reason for this? > > Thanks, > > -- > Hakki Buyukcengiz > TR
signature.asc
Description: Digital signature
