From user-return-1786-apmail-sqoop-user-archive=sqoop.apache.org@sqoop.apache.org Fri Oct 18 02:22:33 2013 Return-Path: X-Original-To: apmail-sqoop-user-archive@www.apache.org Delivered-To: apmail-sqoop-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BAA8810A9F for ; Fri, 18 Oct 2013 02:22:33 +0000 (UTC) Received: (qmail 36782 invoked by uid 500); 18 Oct 2013 02:22:33 -0000 Delivered-To: apmail-sqoop-user-archive@sqoop.apache.org Received: (qmail 36757 invoked by uid 500); 18 Oct 2013 02:22:32 -0000 Mailing-List: contact user-help@sqoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@sqoop.apache.org Delivered-To: mailing list user@sqoop.apache.org Received: (qmail 36749 invoked by uid 99); 18 Oct 2013 02:22:32 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Oct 2013 02:22:32 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of abe@cloudera.com designates 209.85.214.182 as permitted sender) Received: from [209.85.214.182] (HELO mail-ob0-f182.google.com) (209.85.214.182) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Oct 2013 02:22:28 +0000 Received: by mail-ob0-f182.google.com with SMTP id va2so2676780obc.13 for ; Thu, 17 Oct 2013 19:22:08 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=CEO8+FhMwjG3r0FKtHm3pn8PwiQsxEdhm9JMZDQqqh8=; b=gH+8B3bUotjDGkUYKb93YlhXv4ksp4DUyfSP7OKz+7wiOqQr3CgaPbqpfjTvjil45/ S6PcCAKf42Vk6kjKHAqTFtwEFmM4ZYW4wvoxYhvJiurXfJCeld35NmQBqIpIPdz7QmcJ 6xhj51KZlG6LXeRLQIwdVInSijnb9o0RV/tuYqblXc3eCaRw682nR/0ZToNZYQ9o9rki kb9BKtksFaGTA2nUVr7Udb1Q1IKLoLuwl6VGmF/ZKUQlBCYTqqLj11DEnBDzxtuwbkpW qu+KfTKBPTNXrMgMl53iY3IHdtBePwMmkP4HlJv/FbeGOm6NpEu8eS6PBCSnsPcAU5wD Is+Q== X-Gm-Message-State: ALoCoQlKjV8hldTSZNL30RyTLw4KuzP8pa0QwJtdyxq3+HAADAGDdl25GV2t6JDe3YKAyMPY6TOU MIME-Version: 1.0 X-Received: by 10.182.39.161 with SMTP id q1mr67094obk.54.1382062927897; Thu, 17 Oct 2013 19:22:07 -0700 (PDT) Received: by 10.76.112.180 with HTTP; Thu, 17 Oct 2013 19:22:07 -0700 (PDT) In-Reply-To: <7970b31eabe448738e9a37d65f1c065c@MERCMBX20D.na.SAS.com> References: <612293f0adcb4276b036bdc0cb32175b@MERCMBX20D.na.SAS.com> <7970b31eabe448738e9a37d65f1c065c@MERCMBX20D.na.SAS.com> Date: Thu, 17 Oct 2013 19:22:07 -0700 Message-ID: Subject: Re: Sqoop hangs From: Abraham Elmahrek To: "user@sqoop.apache.org" Content-Type: multipart/alternative; boundary=001a11c2de60dff91b04e8fa99de X-Virus-Checked: Checked by ClamAV on apache.org --001a11c2de60dff91b04e8fa99de Content-Type: text/plain; charset=ISO-8859-1 Firas, That setting should point to the location of your hadoop mapreduce installation (ie. /usr/lib/hadoop-0.20-mapreduce). Sqoop uses MapReduce to distribute the transfer of data. This means that a MapReduce job will be created and several tasks to perform the work. Could you please inspect your job tracker and task logs? Also, remember to run your sqoop job with the "verbose" (--verbose) command to get the most out of logging. If you're still having difficulty, please provide your sqoop log, job tracker log, and relevant task logs. -Abe On Thu, Oct 17, 2013 at 1:09 PM, Firas Khasawneh wrote: > Hi Abraham,**** > > ** ** > > I am using hadoop 1.2.1. In my path, the only doubt, I have is the setting > of HADOOP_MAPRED_HOME. I tried to set it to hadoop home, to /tmp and to a > directory that does not exist. I am still not getting any errors. It just > hangs and never come back.**** > > ** ** > > Thanks,**** > > Firas **** > > ** ** > > *From:* Firas Khasawneh > *Sent:* Thursday, October 17, 2013 3:57 PM > *To:* user@sqoop.apache.org > *Subject:* RE: Sqoop hangs**** > > ** ** > > Hi Abraham,**** > > ** ** > > I am using Postgres 9.1 on Ubuntu. Nothing in the logs. I am also able to > do table-list from sqoop.**** > > ** ** > > Thanks,**** > > Firas**** > > ** ** > > *From:* Abraham Elmahrek [mailto:abe@cloudera.com ] > *Sent:* Thursday, October 17, 2013 3:50 PM > *To:* user@sqoop.apache.org > *Subject:* Re: Sqoop hangs**** > > ** ** > > Firas,**** > > ** ** > > Have you checked your postgresql logs? The database could be in a > deadlock. Also, what version of PostGreSQL are you running?**** > > ** ** > > -Abe**** > > ** ** > > On Thu, Oct 17, 2013 at 12:24 PM, Firas Khasawneh > wrote:**** > > Hi,**** > > **** > > When importing from a Postgres database, sqoop hangs and never exists > unless I kill it from the command line. Any help regarding this? I am not > seeing any errors or log files for sqoop.**** > > **** > > Thanks,**** > > Firas**** > > **** > > ** ** > --001a11c2de60dff91b04e8fa99de Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Firas,

That setting should point to the= location of your hadoop mapreduce installation (ie. /usr/lib/hadoop-0.20-m= apreduce).

Sqoop uses MapReduce to distribute the = transfer of data. This means that a MapReduce job will be created and sever= al tasks to perform the work. Could you please inspect your job tracker and= task logs? Also, remember to run your sqoop job with the "verbose&quo= t; (--verbose) command to get the most out of logging.

If you're still having difficulty, please provide y= our sqoop log, job tracker log, and relevant task logs.

-Abe


On Thu, Oct 17, 2013 at 1:09 PM, Firas Khasawneh <Firas.Khasawneh@sa= s.com> wrote:

Hi Abraham,=

=A0<= /p>

I am using hadoop 1.2.1. = In my path, the only doubt, I have is the setting of HADOOP_MAPRED_HOME. I = tried to set it to hadoop home, to /tmp and to a directory that does not exist. I am still not getting any errors. It just hangs and = never come back.

=A0<= /p>

Thanks,

Firas

=A0<= /p>

From: Firas = Khasawneh
Sent: Thursday, October 17, 2013 3:57 PM
To: user@= sqoop.apache.org
Subject: RE: Sqoop hangs

=A0

Hi Abraham,=

=A0<= /p>

I am using Postgres 9.1 o= n Ubuntu. Nothing in the logs. I am also able to do table-list from sqoop.<= u>

=A0<= /p>

Thanks,

Firas

=A0<= /p>

From: Abraha= m Elmahrek [mailto:ab= e@cloudera.com]
Sent: Thursday, October 17, 2013 3:50 PM
To: user@= sqoop.apache.org
Subject: Re: Sqoop hangs

=A0

Firas,

=A0

Have you checked your postgresql logs? The database = could be in a deadlock. Also, what version of PostGreSQL are you running?

=A0

-Abe

=A0

On Thu, Oct 17, 2013 at 12:24 PM, Firas Khasawneh &l= t;Firas.Khasaw= neh@sas.com> wrote:

Hi,

=A0

When importing from a Postgres database, sqoop hangs= and never exists unless I kill it from the command line. Any help regardin= g this? I am not seeing any errors or log files for sqoop.

=A0

Thanks,

Firas

=A0

=A0


--001a11c2de60dff91b04e8fa99de--