You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Jason Sheldon <ja...@synthasite.com> on 2008/05/12 11:46:23 UTC
hql error
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
Re: hql error
Posted by stack <st...@duboce.net>.
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 <ja...@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
>
>
>
Re: hql error
Posted by Jason Sheldon <ja...@synthasite.com>.
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
> <ja...@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
Re: hql error
Posted by "Jim R. Wilson" <wi...@gmail.com>.
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 <ja...@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
>
>
>
>