hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jason Sheldon <ja...@synthasite.com>
Subject Re: hql error
Date Tue, 13 May 2008 06:16:13 GMT
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