hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From stack <st...@duboce.net>
Subject Re: hql error
Date Wed, 14 May 2008 06:35:06 GMT
Jason:

Do the logs tell you anything Jason?  Anything in the .out output 
files?  How many rows approximately?  Looks like you have two regions 
going by the listing below.  These are probably the catalog -ROOT- and 
.META. regions.  Can you enable DEBUG and reload your tables?  (See 
http://wiki.apache.org/hadoop/Hbase/FAQ#5 for how).  Send us over the 
logs.  Have you upped your file descriptors ulmit above 1024?

St.Ack


Jason Sheldon wrote:
> Hi
>
>
> I am running a multi-node cluster:-
>
> HBase Version    0.1.2, r654321    HBase version and svn revision
> HBase Compiled    Wed May 7 16:52:05 PDT 2008, stack    When HBase 
> version was compiled and by whom
> Hadoop Version    0.16.3, r647354    Hadoop version and svn revision
> Hadoop Compiled    Fri Apr 11 23:58:10 UTC 2008, hadoopqa    When 
> Hadoop version was compiled and by whom
> Filesystem    hdfs://10.211.55.7:9000/hbase    Filesystem HBase is 
> running on
> HBase Root Directory    hdfs://10.211.55.7:9000/hbase    Location of 
> HBase home directory
> Online META Regions
> Name    Server
> -ROOT-    10.211.55.4:60020
> .META.,,1    10.211.55.6:60020
> Tables
> Name     Descriptor
> Users     name: Users, families: {firstname:={name: firstname, max 
> versions: 3, compression: NONE, in memory: false, max length: 
> 2147483647, bloom filter: none}, id:={name: id, max versions: 3, 
> compression: NONE, in memory: false, max length: 2147483647, bloom 
> filter: none}, surname:={name: surname, max versions: 3, compression: 
> NONE, in memory: false, max length: 2147483647, bloom filter: none}}
>
> 1 table(s) in set.
> Region Servers
>     Address    Start Code    Load
> 10.211.55.5:60020    1210658749423    requests: 0 regions: 0
> 10.211.55.6:60020    1210658749320    requests: 0 regions: 1
> 10.211.55.3:60020    1210658749111    requests: 0 regions: 0
> 10.211.55.4:60020    1210658749070    requests: 4 regions: 1
> Total:     servers: 4         requests: 4 regions: 2
>
> My regions keep going down it seems for some reason.
>
> In my hbase-site.xml I have
>
> <configuration>
>     <property>
>     <name>hbase.master</name>
>     <value>10.211.55.7:60000</value>
>     <description>The host and port that the HBase master runs at.
>     </description>
>   </property>
>
>   <property>
>     <name>hbase.rootdir</name>
>     <value>hdfs://10.211.55.7:9000/hbase</value>
>     <description>The directory shared by region servers.
>     </description>
>   </property>
> </configuration>
>
>
> I keep getting the exception doing different things eg using hql in 
> shell to do the query or using API commands from a test java client.
>
> The first time I create the table I can get at the data thereafter it 
> goes offline or so it seems
>
>
> On 12 May 2008, at 20:05, Jim R. Wilson wrote:
>
>> Are you running a single-node cluster, or multi-node?  Also, what is
>> your `hbase.master` property set to in your conf/hbase-site.xml?  I'm
>> curious whether your region server is being run within the same
>> process as the master.
>>
>> Finally, did you do anything else prior to running that query, such as
>> deleting and recreating the table, or issuing a "DELETE * FROM
>> tablename"?  Dropping a table or deleting all rows therefrom has been
>> known to make regions go offline.
>>
>> -- Jim R. Wilson (jimbojw)
>>
>> On Mon, May 12, 2008 at 4:46 AM, Jason Sheldon <jason@synthasite.com> 
>> wrote:
>>> Hi
>>>
>>> I just got my hbase running and did a create for a very simple table 
>>> just
>>> to familiarise myself. It contains name,surname and a few arbitrary 
>>> columns;
>>>
>>> When I go into hbase shell and type
>>>
>>> select * from UserTable where row='1';
>>>
>>> I get
>>>
>>> INFO hbase.HTable: Creating scanner over User starting at key
>>> org.apache.hadoop.hbase.NotServingRegionException:
>>> org.apache.hadoop.hbase.NotServingRegionException: User,,1210582227961
>>>        at
>>> org.apache.hadoop.hbase.HRegionServer.getRegion(HRegionServer.java:1744) 
>>>
>>>        at
>>> org.apache.hadoop.hbase.HRegionServer.getRegion(HRegionServer.java:1716) 
>>>
>>>        at
>>> org.apache.hadoop.hbase.HRegionServer.openScanner(HRegionServer.java:1585) 
>>>
>>>        at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
>>>        at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

>>>
>>>        at java.lang.reflect.Method.invoke(Method.java:585)
>>>        at
>>> org.apache.hadoop.hbase.ipc.HbaseRPC$Server.call(HbaseRPC.java:413)
>>>        at org.apache.hadoop.ipc.Server$Handler.run(Server.java:901)
>>>
>>>        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>> Method)
>>>        at
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

>>>
>>>        at
>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

>>>
>>>        at 
>>> java.lang.reflect.Constructor.newInstance(Constructor.java:494)
>>>        at
>>> org.apache.hadoop.hbase.RemoteExceptionHandler.decodeRemoteException(RemoteExceptionHandler.java:82)

>>>
>>>        at
>>> org.apache.hadoop.hbase.HTable$ClientScanner.nextScanner(HTable.java:874) 
>>>
>>>        at
>>> org.apache.hadoop.hbase.HTable$ClientScanner.<init>(HTable.java:817)
>>>        at org.apache.hadoop.hbase.HTable.obtainScanner(HTable.java:522)
>>>        at org.apache.hadoop.hbase.HTable.obtainScanner(HTable.java:411)
>>>        at
>>> org.apache.hadoop.hbase.hql.SelectCommand.scanPrint(SelectCommand.java:219) 
>>>
>>>        at
>>> org.apache.hadoop.hbase.hql.SelectCommand.execute(SelectCommand.java:100) 
>>>
>>>        at
>>> org.apache.hadoop.hbase.hql.HQLClient.executeQuery(HQLClient.java:50)
>>>        at org.apache.hadoop.hbase.Shell.main(Shell.java:114)
>>>
>>>
>>>
>>> Jason Sheldon
>>> Platform Engineer
>>> SynthaSite
>>>
>>> Web: http://www.synthasite.com
>>>
>>>
>>>
>>>
>
> Jason Sheldon
> Platform Engineer
> SynthaSite
>
> Web: http://www.synthasite.com
>
>
>


Mime
View raw message