Hi Jarek, What do you mean with jstack? What i had sent was the terminal output of sqoop.
Sent from Android 24 Nis 2013 17:12 tarihinde "Jarek Jarcec Cecho" <[email protected]> yazdı: > 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 >
