From user-return-679-apmail-trafodion-user-archive=trafodion.apache.org@trafodion.incubator.apache.org Thu Sep 8 17:03:45 2016 Return-Path: X-Original-To: apmail-trafodion-user-archive@minotaur.apache.org Delivered-To: apmail-trafodion-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5B23219F98 for ; Thu, 8 Sep 2016 17:03:45 +0000 (UTC) Received: (qmail 12885 invoked by uid 500); 8 Sep 2016 17:03:45 -0000 Delivered-To: apmail-trafodion-user-archive@trafodion.apache.org Received: (qmail 12844 invoked by uid 500); 8 Sep 2016 17:03:45 -0000 Mailing-List: contact user-help@trafodion.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@trafodion.incubator.apache.org Delivered-To: mailing list user@trafodion.incubator.apache.org Received: (qmail 12834 invoked by uid 99); 8 Sep 2016 17:03:45 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Sep 2016 17:03:45 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id C9059C034D for ; Thu, 8 Sep 2016 17:03:44 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.79 X-Spam-Level: * X-Spam-Status: No, score=1.79 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_IMAGE_RATIO_04=0.61, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=esgyn.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 28hOEfPY15ZY for ; Thu, 8 Sep 2016 17:03:40 +0000 (UTC) Received: from mail-it0-f47.google.com (mail-it0-f47.google.com [209.85.214.47]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 0E6D060DC6 for ; Thu, 8 Sep 2016 17:03:40 +0000 (UTC) Received: by mail-it0-f47.google.com with SMTP id i184so268785955itf.1 for ; Thu, 08 Sep 2016 10:03:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=esgyn.com; s=google; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=6oZOw92g640xAqnuQb3FjTlnvnQif+7zTXkBl3YX/Jk=; b=bQ77qAP/L4LIYD077GE8mgJLx79Szotx6zd1NnjFaFxTuhymj3/9D/NdHP7/PNdfkY XC8feW7K45M0rmRnpjBJVehq64vj0rHxTecPNv7NIcOnqWKuYRlFQWJg/3KrFj7ROVog cRRK7GVc6Hgb15VppHb4QPuFrk3RFKotRWRzM= 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:from:date :message-id:subject:to:cc; bh=6oZOw92g640xAqnuQb3FjTlnvnQif+7zTXkBl3YX/Jk=; b=W+dvzpkwD9G1YeP7R42lDnG9hHBzwejBUvG2N/Ltjsj6V6OpHcmtqJBTQMHx2Ja4of 9JEDXrh2fuxAx2CXvKcjxZ3S5rw/ldeHeY7c96qFgRdMvAVVMsyuTf14JXy7hze0EuZi CUHFdd9Hj9xDk4pfk6mDRqAlQLQuHgik3PBwf1JNBlR6o5vXO/qvtrKxK2RyPkv/OkXw oAUOC2uPf99DiTa3CWM0m+hbPVVfE3alHNOaCbehjukdv6t2uotxuH9bC7mDzLiZuoT8 5r5kNueRpAagELIJyjESZcOdkfOH0+85m5elGvJ5wm1uS1uVdCqMO+Y/3jJ8XN4ib+hC /k7A== X-Gm-Message-State: AE9vXwNFAXfqh2jwXt0k+RcfEoYdkxkGykwlo0kx2g2AF/hjZDnOxFnM9ruhqhyZ+d3z5GVo0cXbW5DXcOeEpdyO X-Received: by 10.36.150.70 with SMTP id z67mr15986871itd.80.1473354216224; Thu, 08 Sep 2016 10:03:36 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.128.106 with HTTP; Thu, 8 Sep 2016 10:03:35 -0700 (PDT) In-Reply-To: <2f6dd3b79413348067806e7488f12add@mail.gmail.com> References: <2f6dd3b79413348067806e7488f12add@mail.gmail.com> From: Amanda Moran Date: Thu, 8 Sep 2016 10:03:35 -0700 Message-ID: Subject: Re: Load with log error rows gets Trafodion not work To: dev Cc: user@trafodion.incubator.apache.org Content-Type: multipart/alternative; boundary=94eb2c07d074afd2d2053c020283 --94eb2c07d074afd2d2053c020283 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Please run this command: sudo su hdfs --command "hadoop fs -ls /user" Please verify you have the trafodion user id listed there. Thanks! Amanda On Thu, Sep 8, 2016 at 8:08 AM, Selva Govindarajan < selva.govindarajan@esgyn.com> wrote: > Hi Qiao, > > > > The JIRA you mentioned in the message is already fixed and merged to > Trafodion on July 20th. It is unfortunate that this JIRA wasn=E2=80=99t = marked > as resolved. I have marked it as resolved now. This JIRA deals with the > issue of trafodion process aborting when there is an error while logging > the error rows. The error rows are logged in hdfs directly. Most likely > the =E2=80=9CTrafodion=E2=80=9D user has no write permission to the hdfs = directory where > the error is logged. > > > > You can try =E2=80=9CLoad with continue on error =E2=80=A6 =E2=80=9C com= mand instead and check if > it works. > > > > Can you also please send the output of the command below to confirm if th= e > version installed has the above fix. > > > > sqvers -u > > > > Can you also issue the following command to confirm if the Trafodion and > hbase are started successfully. > > > > hbcheck > > sqcheck > > > > > > Selva > > *From:* =E4=B9=94=E5=BD=A6=E5=85=8B [mailto:qyanke@gmail.com] > *Sent:* Thursday, September 8, 2016 12:20 AM > *To:* user@trafodion.incubator.apache.org; dev@trafodion.incubator.apache > .org > *Subject:* Load with log error rows gets Trafodion not work > > > > Hi, all, > > I used load with log error rows to load data from hive, and got the > following error: > > [image: loaderr.png] > > which leading to hbase-region server crashed. > > I restart Hbase region serve and Trafodion, but query in Trafodion has no > response, even the simplest query "get tables;" or " get schemas". > > Can someone help me to let Trafodion go normal? > > https://issues.apache.org/jira/browse/TRAFODION-2109, this jira describe > the same problem. > > > > Any reply is appreciated. > > Thank you > > Qiao > --=20 Thanks, Amanda Moran --94eb2c07d074afd2d2053c020283 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Please run this command:

sudo su hdfs -= -command "hadoop fs -ls /user"

Please ve= rify you have the trafodion user id listed there.=C2=A0

Thanks!=C2=A0

Amanda

On Thu, Sep 8, 2016 at 8:08 AM, Selva Govindarajan <selva.govindarajan@esgyn.com> wrote:

Hi Qiao,

The JIRA you mentioned = in the message is already fixed and merged to Trafodion on July 20th.=C2=A0 It is unfortunate that this JIRA wasn=E2=80=99t marked as resol= ved. I have marked it as resolved now. This JIRA deals with the issue of tr= afodion process aborting when there is an error while logging the error row= s. The error rows are logged in hdfs directly.=C2=A0 Most likely the =E2=80= =9CTrafodion=E2=80=9D user has no write permission to the hdfs directory wh= ere the error is logged.

=C2=A0<= /span>

You can try =E2=80=9CLoad with c= ontinue on error =E2=80=A6 =E2=80=9C =C2=A0command instead and check if it = works.

=C2=A0

Can you also please send the output of the command= below to confirm if the version installed has the above fix.

=C2=A0

sqvers -u

=C2=A0

Can you also issue the following command = to confirm if the Trafodion and hbase are started successfully.

<= p class=3D"MsoNormal">=C2=A0

hbcheck

sqcheck

=C2=A0

<= span style=3D"font-size:11.0pt;font-family:"Comic Sans MS";color:= #1f497d">=C2=A0

Selva

=

From: =E4=B9=94= =E5=BD=A6=E5=85=8B [mailto:qyanke@gmail.com]
Sent: Thursday, September 8,= 2016 12:20 AM
To: user@trafodion.incubator.apache.org; dev@t= rafodion.incubator.apache.org
Subject: Load with log err= or rows gets Trafodion not work

= =C2=A0

Hi, all,

=C2=A0 =C2=A0I used load with log error rows to load data from hive, and= got the following error:

3D=

which leading to hbase-= region server crashed.

I restart Hbase= region serve and Trafodion, but query in Trafodion has no response, even t= he simplest query "get tables;" =C2=A0or " get schemas"= .

Can someone help me to let Trafodion= go normal?

https://issues.apa= che.org/jira/browse/TRAFODION-2109, this jira describe the same pr= oblem.

=C2=A0

Any reply is appreciated.

Thank you

Qiao




--
Thanks,=C2=A0

Amanda Moran
--94eb2c07d074afd2d2053c020283--