Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-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 5E213101A8 for ; Tue, 3 Sep 2013 14:25:48 +0000 (UTC) Received: (qmail 85847 invoked by uid 500); 3 Sep 2013 14:25:44 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 85817 invoked by uid 500); 3 Sep 2013 14:25:44 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 85809 invoked by uid 99); 3 Sep 2013 14:25:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Sep 2013 14:25:44 +0000 X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [216.82.251.12] (HELO mail1.bemta12.messagelabs.com) (216.82.251.12) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Sep 2013 14:25:39 +0000 Received: from [216.82.249.212:46155] by server-12.bemta-12.messagelabs.com id 94/2B-10790-D41F5225; Tue, 03 Sep 2013 14:25:17 +0000 X-Env-Sender: Omkar.Joshi@lntinfotech.com X-Msg-Ref: server-11.tower-219.messagelabs.com!1378218314!7051346!1 X-Originating-IP: [203.199.118.206] X-StarScan-Received: X-StarScan-Version: 6.9.11; banners=-,-,- X-VirusChecked: Checked Received: (qmail 23287 invoked from network); 3 Sep 2013 14:25:17 -0000 Received: from unknown (HELO VSHINMSHTCAS02.vshodc.lntinfotech.com) (203.199.118.206) by server-11.tower-219.messagelabs.com with AES128-SHA encrypted SMTP; 3 Sep 2013 14:25:17 -0000 Received: from vshinmsmbx01.vshodc.lntinfotech.com ([172.17.24.117]) by VSHINMSHTCAS02.vshodc.lntinfotech.com ([172.17.24.114]) with mapi; Tue, 3 Sep 2013 19:55:14 +0530 From: Omkar Joshi To: "user@hbase.apache.org" Date: Tue, 3 Sep 2013 19:55:12 +0530 Subject: RE: Sqoop import to HBase failing - timeout Thread-Topic: Sqoop import to HBase failing - timeout Thread-Index: Ac6osTrTN96MrRpsTMauKIqGD3bCugAAAnZQ Message-ID: <228082AE2B2E784180B63E1D92E4EB870DE0D92883@VSHINMSMBX01.vshodc.lntinfotech.com> References: <228082AE2B2E784180B63E1D92E4EB870DE0D9284F@VSHINMSMBX01.vshodc.lntinfotech.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org HBase 0.94.11 which has zookeeper 3.4.5 jar in the lib. Regards, Omkar Joshi Technology Office Phone : 022-67954364 -----Original Message----- From: Ted Yu [mailto:yuzhihong@gmail.com]=20 Sent: Tuesday, September 03, 2013 7:53 PM To: user@hbase.apache.org Subject: Re: Sqoop import to HBase failing - timeout What version of HBase are you using ? Are you using zookeeper 3.4.5 ? Thanks On Tue, Sep 3, 2013 at 6:19 AM, Omkar Joshi wr= ote: > Hi, > > I'm executing a simple Sqoop import from an RDBMS to stand-alone HBase. > Only two of thousands of records are getting inserted. When I checked the > hbase log : > > 2013-09-03 23:15:36,843 INFO > org.apache.zookeeper.server.NIOServerCnxnFactory: Accepted socket > connection from /172.25.37.135:54519 > 2013-09-03 23:15:36,848 INFO org.apache.zookeeper.server.ZooKeeperServer: > Client attempting to establish new session at /172.25.37.135:54519 > 2013-09-03 23:15:36,851 INFO org.apache.zookeeper.server.ZooKeeperServer: > Established session 0x140e4e97c9d0009 with negotiated timeout 40000 for > client /172.25.37.135:54519 > 2013-09-03 23:15:38,481 INFO > org.apache.zookeeper.server.PrepRequestProcessor: Processed session > termination for sessionid: 0x140e4e97c9d0008 > 2013-09-03 23:15:38,495 INFO org.apache.zookeeper.server.NIOServerCnxn: > Closed socket connection for client /172.25.37.135:54518 which had > sessionid 0x140e4e97c9d0008 > 2013-09-03 23:15:41,566 INFO > org.apache.zookeeper.server.PrepRequestProcessor: Processed session > termination for sessionid: 0x140e4e97c9d0009 > 2013-09-03 23:15:41,584 INFO org.apache.zookeeper.server.NIOServerCnxn: > Closed socket connection for client /172.25.37.135:54519 which had > sessionid 0x140e4e97c9d0009 > 2013-09-03 23:15:56,154 DEBUG > org.apache.hadoop.hbase.io.hfile.LruBlockCache: Stats: total=3D2.02 MB, > free=3D243.82 MB, max=3D245.84 MB, blocks=3D5, accesses=3D99, hits=3D94, > hitRatio=3D94.94%, , cachingAccesses=3D99, cachingHits=3D94, > cachingHitsRatio=3D94.94%, , evictions=3D0, evicted=3D0, evictedPerRun=3D= NaN > 2013-09-03 23:16:02,552 WARN org.apache.zookeeper.server.NIOServerCnxn: > caught end of stream exception > EndOfStreamException: Unable to read additional data from client sessioni= d > 0x140e4e97c9d0003, likely client has closed socket > at > org.apache.zookeeper.server.NIOServerCnxn.doIO(NIOServerCnxn.java:220) > at > org.apache.zookeeper.server.NIOServerCnxnFactory.run(NIOServerCnxnFactory= .java:208) > at java.lang.Thread.run(Thread.java:722) > 2013-09-03 23:16:02,565 INFO org.apache.zookeeper.server.NIOServerCnxn: > Closed socket connection for client /172.25.37.135:54432 which had > sessionid 0x140e4e97c9d0003 > 2013-09-03 23:16:30,001 INFO org.apache.zookeeper.server.ZooKeeperServer: > Expiring session 0x140e4e97c9d0003, timeout of 40000ms exceeded > > What is causing the connection closure? Do I need to increase the time-ou= t > somewhere? > > Regards, > Omkar Joshi > > > > ________________________________ > The contents of this e-mail and any attachment(s) may contain confidentia= l > or privileged information for the intended recipient(s). Unintended > recipients are prohibited from taking action on the basis of information = in > this e-mail and using or disseminating the information, and must notify t= he > sender and delete it from their system. L&T Infotech will not accept > responsibility or liability for the accuracy or completeness of, or the > presence of any virus or disabling code in this e-mail" >