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 255931051C for ; Fri, 12 Apr 2013 14:00:42 +0000 (UTC) Received: (qmail 56737 invoked by uid 500); 12 Apr 2013 14:00:39 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 56664 invoked by uid 500); 12 Apr 2013 14:00:39 -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 56655 invoked by uid 99); 12 Apr 2013 14:00:39 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Apr 2013 14:00:39 +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 azuryyyu@gmail.com designates 209.85.210.175 as permitted sender) Received: from [209.85.210.175] (HELO mail-ia0-f175.google.com) (209.85.210.175) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Apr 2013 14:00:35 +0000 Received: by mail-ia0-f175.google.com with SMTP id e16so2377749iaa.6 for ; Fri, 12 Apr 2013 07:00:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=jc1ExO3Bdo1fVFopPm64kk94fjU0YvBy2Q+JQhf3Q1o=; b=InITHaMXlIf+fZyo4wIoTWcXyaC4vSkMbrDHP6U4bWTnnFY2r8Bmk4AWCv4j0Oq7dv iD9Bvff+8N3RtUf0q96R96vPCR+2HCaCxb1ECBVcttGc7sSAK/xmEmUVquxtBz3rVbJv ExQdLc0Qnwcf1lFC3NlFpRvnXz93DEsajanL/qt+wB8vXnV9d+r5H3A4qllordS2FV8K wwNjInt0JWoQIFtzsFTmaG6jBLUfTGjwqVhfCaOdwHX5oVc6rnzCYmZKnwvIsExiWMqe 9kzVzHejhWGkK2Fw9DhcscKSP4+7BgwLAcQvzIQ0NTi5GowOXF7ut/AVym+fVHCd9YrT 8NHg== MIME-Version: 1.0 X-Received: by 10.50.20.69 with SMTP id l5mr1746872ige.106.1365775214535; Fri, 12 Apr 2013 07:00:14 -0700 (PDT) Received: by 10.64.8.7 with HTTP; Fri, 12 Apr 2013 07:00:14 -0700 (PDT) Received: by 10.64.8.7 with HTTP; Fri, 12 Apr 2013 07:00:14 -0700 (PDT) In-Reply-To: References: Date: Fri, 12 Apr 2013 22:00:14 +0800 Message-ID: Subject: Re: Error while doing multi get from HBase From: Azuryy Yu To: user@hbase.apache.org Content-Type: multipart/alternative; boundary=047d7bd76ae68167de04da2a5256 X-Virus-Checked: Checked by ClamAV on apache.org --047d7bd76ae68167de04da2a5256 Content-Type: text/plain; charset=ISO-8859-1 and whats your block cache size? there are two possible reasons: 1. result is too big 2. GC options are not optimized. can you paste your gc options here? --Send from my Sony mobile. On Apr 12, 2013 9:53 PM, "anand nalya" wrote: > Hi Azuryy, > > I'm using the default cache size of 100 for scanner. For mutigets, I've > tried with 1 (13ms), 10(356ms), 100(1135ms), 1000(4330ms), and > 10000(17744ms) keys. Normal workload will be around 10000 keys at a time. > > Are there any optimization that can be done for multigets. Is HBase a good > candidate for usecase? > > Thanks, > Anand > > > On 12 April 2013 19:17, anand nalya wrote: > > > Hi Ted, > > > > The region servers are not loaded. It is showing 5% CPU usage. The > > datanode is showing around 50% CPU utilization. disk IO is aroung 7Mbps. > > > > There is nothing noticeable in GC log. > > > > Thanks, > > Anand > > > > > > On 12 April 2013 02:56, Ted Yu wrote: > > > >> How loaded were the region servers when the query was running ? > >> > >> Did you check GC log ? > >> > >> Thanks > >> > >> On Thu, Apr 11, 2013 at 8:23 AM, anand nalya > >> wrote: > >> > >> > Hi, > >> > > >> > I'm using HBase 0.94.5 with thrift server. I'm trying to get the rows > >> from > >> > HBase using > >> > > >> > org.apache.hadoop.hbase.thrift.generated.Hbase.Client.getRows(ByteBuffer, > >> > List, Map) but it is giving > results > >> > very slowly (around 2 mins for 100 rows). For larger number of > records, > >> > there is no response. > >> > > >> > I've two region server and a total of 128 regions. Total data size is > >> > around 250GB (250 million records) uniformly distributed across > regions. > >> > > >> > Regionserver only show the following in its log: > >> > > >> > 2013-04-11 19:53:44,535 ERROR > >> > org.apache.hadoop.hbase.regionserver.HRegionServer: > >> > org.apache.hadoop.hbase.ipc.CallerDisconnectedException: Aborting call > >> > multi(org.apache.hadoop.hbase.client.MultiAction@49ac272), rpc > >> version=1, > >> > client version=29, methodsFingerPrint=-1368823753 from > >> > 192.168.145.195:52277after 74994 ms, since caller disconnected > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.ipc.HBaseServer$Call.throwExceptionIfCallerDisconnected(HBaseServer.java:436) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextInternal(HRegion.java:3723) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw(HRegion.java:3643) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.next(HRegion.java:3626) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.next(HRegion.java:3664) > >> > at > >> org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:4576) > >> > at > >> org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:4549) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegionServer.get(HRegionServer.java:2042) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegionServer.multi(HRegionServer.java:3516) > >> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > >> > at > >> > > >> > > >> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > >> > at > >> > > >> > > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >> > at java.lang.reflect.Method.invoke(Method.java:597) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320) > >> > at > >> > > >> > org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1426) > >> > 2013-04-11 19:53:46,121 ERROR > >> > org.apache.hadoop.hbase.regionserver.HRegionServer: > >> > org.apache.hadoop.hbase.ipc.CallerDisconnectedException: Aborting call > >> > multi(org.apache.hadoop.hbase.client.MultiAction@49ac272), rpc > >> version=1, > >> > client version=29, methodsFingerPrint=-1368823753 from > >> > 192.168.145.195:52277after 76580 ms, since caller disconnected > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.ipc.HBaseServer$Call.throwExceptionIfCallerDisconnected(HBaseServer.java:436) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextInternal(HRegion.java:3723) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw(HRegion.java:3643) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.next(HRegion.java:3626) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.next(HRegion.java:3664) > >> > at > >> org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:4576) > >> > at > >> org.apache.hadoop.hbase.regionserver.HRegion.get(HRegion.java:4549) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegionServer.get(HRegionServer.java:2042) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.regionserver.HRegionServer.multi(HRegionServer.java:3516) > >> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > >> > at > >> > > >> > > >> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > >> > at > >> > > >> > > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >> > at java.lang.reflect.Method.invoke(Method.java:597) > >> > at > >> > > >> > > >> > org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320) > >> > at > >> > > >> > org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1426) > >> > > >> > > >> > Any idea what might be wrong here? > >> > > >> > Thanks, > >> > Anand > >> > > >> > > > > > --047d7bd76ae68167de04da2a5256--