You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by hua beatls <be...@gmail.com> on 2013/01/24 11:18:09 UTC
drop table problem
HI,
i have a table in 'transition' state, which couldn't be 'disable' or
enable. I try to 'drop' it but failed. below is the error messages.
hbase(main):012:0> drop 'T21_0513_201301_bigtable'
ERROR: org.apache.hadoop.hbase.TableNotDisabledException:
org.apache.hadoop.hbase.TableNotDisabledException: T21_0513_201301_bigtable
at
org.apache.hadoop.hbase.master.HMaster.checkTableModifiable(HMaster.java:1240)
at
org.apache.hadoop.hbase.master.handler.TableEventHandler.<init>(TableEventHandler.java:70)
at
org.apache.hadoop.hbase.master.handler.DeleteTableHandler.<init>(DeleteTableHandler.java:42)
at org.apache.hadoop.hbase.master.HMaster.deleteTable(HMaster.java:1099)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at
org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:364)
at
org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1345)
below is the excerpts from webui:
Regions in TransitionRegionStatebd8d2bf3ef04d0f8d3dac5ca2f612f42T21_0513_201301_bigtable,27100750000000000000000000000000000000000000000000000000000,1358994123350.bd8d2bf3ef04d0f8d3dac5ca2f612f42.
state=PENDING_OPEN, ts=Thu Jan 24 16:58:34 CST 2013 (699s ago),
server=hadoop1,60020,1358993820407
Re: drop table problem
Posted by Mohammad Tariq <do...@gmail.com>.
Which version are you using?Try hbck and see if you find anything
interesting. This problem was faced by a couple of folks few weeks ago. Try
to search through the mailing list. Probably there is some problem with the
znode holding this table. Remove it and restart everything.
Warm Regards,
Tariq
https://mtariq.jux.com/
cloudfront.blogspot.com
On Thu, Jan 24, 2013 at 3:48 PM, hua beatls <be...@gmail.com> wrote:
> HI,
> i have a table in 'transition' state, which couldn't be 'disable' or
> enable. I try to 'drop' it but failed. below is the error messages.
>
> hbase(main):012:0> drop 'T21_0513_201301_bigtable'
> ERROR: org.apache.hadoop.hbase.TableNotDisabledException:
> org.apache.hadoop.hbase.TableNotDisabledException: T21_0513_201301_bigtable
> at
>
> org.apache.hadoop.hbase.master.HMaster.checkTableModifiable(HMaster.java:1240)
> at
>
> org.apache.hadoop.hbase.master.handler.TableEventHandler.<init>(TableEventHandler.java:70)
> at
>
> org.apache.hadoop.hbase.master.handler.DeleteTableHandler.<init>(DeleteTableHandler.java:42)
> at org.apache.hadoop.hbase.master.HMaster.deleteTable(HMaster.java:1099)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at
>
> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:364)
> at
> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1345)
> below is the excerpts from webui:
> Regions in
> TransitionRegionStatebd8d2bf3ef04d0f8d3dac5ca2f612f42T21_0513_201301_bigtable,27100750000000000000000000000000000000000000000000000000000,1358994123350.bd8d2bf3ef04d0f8d3dac5ca2f612f42.
> state=PENDING_OPEN, ts=Thu Jan 24 16:58:34 CST 2013 (699s ago),
> server=hadoop1,60020,1358993820407
>
Re: drop table problem
Posted by Adrien Mogenet <ad...@gmail.com>.
Normally you wouldn't need to remove the whole /hbase root on ZK. Removing
the node which is related to your table should be enough. Restart your
master so that it will read table state again, and you'll be able to drop
your ghost table.
On Thu, Jan 24, 2013 at 2:47 PM, Kevin O'dell <ke...@cloudera.com>wrote:
> Sorry I should have specified those are different options to try, not an
> ordered set of instructions.
>
> On Thu, Jan 24, 2013 at 8:47 AM, Kevin O'dell <kevin.odell@cloudera.com
> >wrote:
>
> > Typically, hbck won't detect anything wrong here, as Ram said in another
> > thread we really should work in this functionality.
> >
> > 1.) Shut the HBase cluster - go to ZKcli and rmr /hbase - Start HBase
> back
> > up
> >
> > 2.) Move the table, use hbck -fixMeta -fixAssignments, restart the HBase
> > (not a great option if there is data on the table)
> >
> > 3.) Force an assign on the region for the table and see if it clears it
> up
> > (Should create a new znode)
> >
> > 4.) Go to ZK Cli and check /hbase for unassigned regions and other data
> > correlating with that region and remove it, then restart HBase
> >
> > On Thu, Jan 24, 2013 at 8:34 AM, Vikas Jadhav <vikascjadhav87@gmail.com
> >wrote:
> >
> >> try to diable table first
> >>
> >> disable 'table_name'
> >>
> >> drop 'tab-name'
> >>
> >>
> >>
> >> On Thu, Jan 24, 2013 at 3:48 PM, hua beatls <be...@gmail.com> wrote:
> >>
> >> > HI,
> >> > i have a table in 'transition' state, which couldn't be 'disable' or
> >> > enable. I try to 'drop' it but failed. below is the error messages.
> >> >
> >> > hbase(main):012:0> drop 'T21_0513_201301_bigtable'
> >> > ERROR: org.apache.hadoop.hbase.TableNotDisabledException:
> >> > org.apache.hadoop.hbase.TableNotDisabledException:
> >> T21_0513_201301_bigtable
> >> > at
> >> >
> >> >
> >>
> org.apache.hadoop.hbase.master.HMaster.checkTableModifiable(HMaster.java:1240)
> >> > at
> >> >
> >> >
> >>
> org.apache.hadoop.hbase.master.handler.TableEventHandler.<init>(TableEventHandler.java:70)
> >> > at
> >> >
> >> >
> >>
> org.apache.hadoop.hbase.master.handler.DeleteTableHandler.<init>(DeleteTableHandler.java:42)
> >> > at
> org.apache.hadoop.hbase.master.HMaster.deleteTable(HMaster.java:1099)
> >> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >> > at
> >> >
> >> >
> >>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> >> > at
> >> >
> >> >
> >>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> >> > at java.lang.reflect.Method.invoke(Method.java:601)
> >> > at
> >> >
> >> >
> >>
> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:364)
> >> > at
> >> >
> >>
> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1345)
> >> > below is the excerpts from webui:
> >> > Regions in
> >> >
> >>
> TransitionRegionStatebd8d2bf3ef04d0f8d3dac5ca2f612f42T21_0513_201301_bigtable,27100750000000000000000000000000000000000000000000000000000,1358994123350.bd8d2bf3ef04d0f8d3dac5ca2f612f42.
> >> > state=PENDING_OPEN, ts=Thu Jan 24 16:58:34 CST 2013 (699s ago),
> >> > server=hadoop1,60020,1358993820407
> >> >
> >>
> >>
> >>
> >> --
> >> *
> >> *
> >> *
> >>
> >> Thanx and Regards*
> >> * Vikas Jadhav*
> >>
> >
> >
> >
> > --
> > Kevin O'Dell
> > Customer Operations Engineer, Cloudera
> >
>
>
>
> --
> Kevin O'Dell
> Customer Operations Engineer, Cloudera
>
--
Adrien Mogenet
06.59.16.64.22
http://www.mogenet.me
Re: drop table problem
Posted by Kevin O'dell <ke...@cloudera.com>.
Sorry I should have specified those are different options to try, not an
ordered set of instructions.
On Thu, Jan 24, 2013 at 8:47 AM, Kevin O'dell <ke...@cloudera.com>wrote:
> Typically, hbck won't detect anything wrong here, as Ram said in another
> thread we really should work in this functionality.
>
> 1.) Shut the HBase cluster - go to ZKcli and rmr /hbase - Start HBase back
> up
>
> 2.) Move the table, use hbck -fixMeta -fixAssignments, restart the HBase
> (not a great option if there is data on the table)
>
> 3.) Force an assign on the region for the table and see if it clears it up
> (Should create a new znode)
>
> 4.) Go to ZK Cli and check /hbase for unassigned regions and other data
> correlating with that region and remove it, then restart HBase
>
> On Thu, Jan 24, 2013 at 8:34 AM, Vikas Jadhav <vi...@gmail.com>wrote:
>
>> try to diable table first
>>
>> disable 'table_name'
>>
>> drop 'tab-name'
>>
>>
>>
>> On Thu, Jan 24, 2013 at 3:48 PM, hua beatls <be...@gmail.com> wrote:
>>
>> > HI,
>> > i have a table in 'transition' state, which couldn't be 'disable' or
>> > enable. I try to 'drop' it but failed. below is the error messages.
>> >
>> > hbase(main):012:0> drop 'T21_0513_201301_bigtable'
>> > ERROR: org.apache.hadoop.hbase.TableNotDisabledException:
>> > org.apache.hadoop.hbase.TableNotDisabledException:
>> T21_0513_201301_bigtable
>> > at
>> >
>> >
>> org.apache.hadoop.hbase.master.HMaster.checkTableModifiable(HMaster.java:1240)
>> > at
>> >
>> >
>> org.apache.hadoop.hbase.master.handler.TableEventHandler.<init>(TableEventHandler.java:70)
>> > at
>> >
>> >
>> org.apache.hadoop.hbase.master.handler.DeleteTableHandler.<init>(DeleteTableHandler.java:42)
>> > at org.apache.hadoop.hbase.master.HMaster.deleteTable(HMaster.java:1099)
>> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> > at
>> >
>> >
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> > at
>> >
>> >
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> > at java.lang.reflect.Method.invoke(Method.java:601)
>> > at
>> >
>> >
>> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:364)
>> > at
>> >
>> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1345)
>> > below is the excerpts from webui:
>> > Regions in
>> >
>> TransitionRegionStatebd8d2bf3ef04d0f8d3dac5ca2f612f42T21_0513_201301_bigtable,27100750000000000000000000000000000000000000000000000000000,1358994123350.bd8d2bf3ef04d0f8d3dac5ca2f612f42.
>> > state=PENDING_OPEN, ts=Thu Jan 24 16:58:34 CST 2013 (699s ago),
>> > server=hadoop1,60020,1358993820407
>> >
>>
>>
>>
>> --
>> *
>> *
>> *
>>
>> Thanx and Regards*
>> * Vikas Jadhav*
>>
>
>
>
> --
> Kevin O'Dell
> Customer Operations Engineer, Cloudera
>
--
Kevin O'Dell
Customer Operations Engineer, Cloudera
Re: drop table problem
Posted by Kevin O'dell <ke...@cloudera.com>.
Typically, hbck won't detect anything wrong here, as Ram said in another
thread we really should work in this functionality.
1.) Shut the HBase cluster - go to ZKcli and rmr /hbase - Start HBase back
up
2.) Move the table, use hbck -fixMeta -fixAssignments, restart the HBase
(not a great option if there is data on the table)
3.) Force an assign on the region for the table and see if it clears it up
(Should create a new znode)
4.) Go to ZK Cli and check /hbase for unassigned regions and other data
correlating with that region and remove it, then restart HBase
On Thu, Jan 24, 2013 at 8:34 AM, Vikas Jadhav <vi...@gmail.com>wrote:
> try to diable table first
>
> disable 'table_name'
>
> drop 'tab-name'
>
>
>
> On Thu, Jan 24, 2013 at 3:48 PM, hua beatls <be...@gmail.com> wrote:
>
> > HI,
> > i have a table in 'transition' state, which couldn't be 'disable' or
> > enable. I try to 'drop' it but failed. below is the error messages.
> >
> > hbase(main):012:0> drop 'T21_0513_201301_bigtable'
> > ERROR: org.apache.hadoop.hbase.TableNotDisabledException:
> > org.apache.hadoop.hbase.TableNotDisabledException:
> T21_0513_201301_bigtable
> > at
> >
> >
> org.apache.hadoop.hbase.master.HMaster.checkTableModifiable(HMaster.java:1240)
> > at
> >
> >
> org.apache.hadoop.hbase.master.handler.TableEventHandler.<init>(TableEventHandler.java:70)
> > at
> >
> >
> org.apache.hadoop.hbase.master.handler.DeleteTableHandler.<init>(DeleteTableHandler.java:42)
> > at org.apache.hadoop.hbase.master.HMaster.deleteTable(HMaster.java:1099)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> >
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > at
> >
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:601)
> > at
> >
> >
> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:364)
> > at
> >
> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1345)
> > below is the excerpts from webui:
> > Regions in
> >
> TransitionRegionStatebd8d2bf3ef04d0f8d3dac5ca2f612f42T21_0513_201301_bigtable,27100750000000000000000000000000000000000000000000000000000,1358994123350.bd8d2bf3ef04d0f8d3dac5ca2f612f42.
> > state=PENDING_OPEN, ts=Thu Jan 24 16:58:34 CST 2013 (699s ago),
> > server=hadoop1,60020,1358993820407
> >
>
>
>
> --
> *
> *
> *
>
> Thanx and Regards*
> * Vikas Jadhav*
>
--
Kevin O'Dell
Customer Operations Engineer, Cloudera
Re: drop table problem
Posted by Vikas Jadhav <vi...@gmail.com>.
try to diable table first
disable 'table_name'
drop 'tab-name'
On Thu, Jan 24, 2013 at 3:48 PM, hua beatls <be...@gmail.com> wrote:
> HI,
> i have a table in 'transition' state, which couldn't be 'disable' or
> enable. I try to 'drop' it but failed. below is the error messages.
>
> hbase(main):012:0> drop 'T21_0513_201301_bigtable'
> ERROR: org.apache.hadoop.hbase.TableNotDisabledException:
> org.apache.hadoop.hbase.TableNotDisabledException: T21_0513_201301_bigtable
> at
>
> org.apache.hadoop.hbase.master.HMaster.checkTableModifiable(HMaster.java:1240)
> at
>
> org.apache.hadoop.hbase.master.handler.TableEventHandler.<init>(TableEventHandler.java:70)
> at
>
> org.apache.hadoop.hbase.master.handler.DeleteTableHandler.<init>(DeleteTableHandler.java:42)
> at org.apache.hadoop.hbase.master.HMaster.deleteTable(HMaster.java:1099)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at
>
> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:364)
> at
> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1345)
> below is the excerpts from webui:
> Regions in
> TransitionRegionStatebd8d2bf3ef04d0f8d3dac5ca2f612f42T21_0513_201301_bigtable,27100750000000000000000000000000000000000000000000000000000,1358994123350.bd8d2bf3ef04d0f8d3dac5ca2f612f42.
> state=PENDING_OPEN, ts=Thu Jan 24 16:58:34 CST 2013 (699s ago),
> server=hadoop1,60020,1358993820407
>
--
*
*
*
Thanx and Regards*
* Vikas Jadhav*