You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Qiang Tian <ti...@gmail.com> on 2014/07/28 05:32:12 UTC
delete a row in hbase:meta
Hi Guys,
for a row in hbase:meta like below, how to delete it? due to the chars of
startkey, it cannot be found.
delete
'hbase:meta','moma,\x00"\x00\x00\x00\x012+\xF8\xCB\xF0,1406468625503.6936ebd2ae1d85fc09f243a767229339.','info:seqnumDuringOpen'
ERROR: Row Not Found
thanks!
Re: delete a row in hbase:meta
Posted by Qiang Tian <ti...@gmail.com>.
unfortunately the log was deleted and cannot be reproduced...only have
below data in meta table just before the problem happened :
moma,,1406539662740.c0a589ce74c8bad980d16947fdf56 column=info:regioninfo,
timestamp=1406541888175, value={ENCODED =>
c0a589ce74c8bad980d16947fdf56036, NAME =>
'moma,,1406539662740.c0a589ce74c8bad9
036. 80d16947fdf56036.',
STARTKEY => '', ENDKEY => ''}
moma,,1406539662740.c0a589ce74c8bad980d16947fdf56
column=info:seqnumDuringOpen, timestamp=1406541888222,
value=\x00\x00\x00\x00\x00\x00\x00*\x01*
036.
moma,,1406539662740.c0a589ce74c8bad980d16947fdf56 column=info:server,
timestamp=1406541888222, value=HRegionServer3:60020
036.
moma,,1406539662740.c0a589ce74c8bad980d16947fdf56
column=info:serverstartcode, timestamp=1406541888222, value=1406312768813
036.
moma,\x00"\x00\x00\x00\x012+\xF8\xCB\xF0,14064686
column=info:seqnumDuringOpen, timestamp=1406478771359,
value=\x00\x00\x00\x00\x00\x00\x00*\x01*
25503.6936ebd2ae1d85fc09f243a767229339.
moma,\x00"\x00\x00\x00\x012+\xF8\xCB\xF0,14064686 column=info:server,
timestamp=1406478771359, value=HRegionServer2:60020
25503.6936ebd2ae1d85fc09f243a767229339.
moma,\x00"\x00\x00\x00\x012+\xF8\xCB\xF0,14064686
column=info:serverstartcode, timestamp=1406478771359, value=1406312832708
25503.6936ebd2ae1d85fc09f243a767229339.
there are 2 rowkeys:
moma,,1406539662740.c0a589ce74c8bad980d16947fdf56036.
moma,\x00"\x00\x00\x00\x012+\xF8\xCB\xF0,1406468625503.6936ebd2ae1d85fc09f243a767229339.
the first was deleted via drop 'moma' command, the second cannot.
it looks during delete table, we look up "info:regioninfo" in meta to
locate the related regions, since the second has no "info:regioninfo"
column, it is ignored by hbase?
further investigation shows the 2 regions are just after
split(info:seqnumDuringOpen=1), but it looks updating meta during split
should have updated those info...
thanks.
On Mon, Jul 28, 2014 at 1:28 PM, Ted Yu <yu...@gmail.com> wrote:
> Using hbck is recommended for such scenario.
>
> Did you look at master / region server logs to see if there is some clue
> during table drop operation ?
>
> Cheers
>
> On Jul 27, 2014, at 10:00 PM, Qiang Tian <ti...@gmail.com> wrote:
>
> > Thanks Ted,
> > An user on 0.96 deletes a table region on HDFS by mistake, so he wants to
> > delete the entire table and recreate it. after disable&drop, he finds the
> > table's region info still exists in meta table..
> >
> > from the code, we should be able to delete the related info during table
> > drop, I suspect the startRow(<tablename>,,) in getTableStartRowForMeta
> > might not be correct?
> >
> > ps could hbck tool could fix it? (he deleted it finally via java code,
> will
> > see if we could repro it...)
> >
> >
> >
> > On Mon, Jul 28, 2014 at 12:05 PM, Ted Yu <yu...@gmail.com> wrote:
> >
> >> Deleting from hbase:meta is for advanced users :-)
> >>
> >> Can you tell us why that row needs to be deleted ?
> >>
> >> Cheers
> >>
> >>
> >> On Sun, Jul 27, 2014 at 8:32 PM, Qiang Tian <ti...@gmail.com> wrote:
> >>
> >>> Hi Guys,
> >>>
> >>> for a row in hbase:meta like below, how to delete it? due to the chars
> of
> >>> startkey, it cannot be found.
> >>> delete
> >>
> 'hbase:meta','moma,\x00"\x00\x00\x00\x012+\xF8\xCB\xF0,1406468625503.6936ebd2ae1d85fc09f243a767229339.','info:seqnumDuringOpen'
> >>>
> >>> ERROR: Row Not Found
> >>>
> >>> thanks!
> >>
>
Re: delete a row in hbase:meta
Posted by Ted Yu <yu...@gmail.com>.
Using hbck is recommended for such scenario.
Did you look at master / region server logs to see if there is some clue during table drop operation ?
Cheers
On Jul 27, 2014, at 10:00 PM, Qiang Tian <ti...@gmail.com> wrote:
> Thanks Ted,
> An user on 0.96 deletes a table region on HDFS by mistake, so he wants to
> delete the entire table and recreate it. after disable&drop, he finds the
> table's region info still exists in meta table..
>
> from the code, we should be able to delete the related info during table
> drop, I suspect the startRow(<tablename>,,) in getTableStartRowForMeta
> might not be correct?
>
> ps could hbck tool could fix it? (he deleted it finally via java code, will
> see if we could repro it...)
>
>
>
> On Mon, Jul 28, 2014 at 12:05 PM, Ted Yu <yu...@gmail.com> wrote:
>
>> Deleting from hbase:meta is for advanced users :-)
>>
>> Can you tell us why that row needs to be deleted ?
>>
>> Cheers
>>
>>
>> On Sun, Jul 27, 2014 at 8:32 PM, Qiang Tian <ti...@gmail.com> wrote:
>>
>>> Hi Guys,
>>>
>>> for a row in hbase:meta like below, how to delete it? due to the chars of
>>> startkey, it cannot be found.
>>> delete
>> 'hbase:meta','moma,\x00"\x00\x00\x00\x012+\xF8\xCB\xF0,1406468625503.6936ebd2ae1d85fc09f243a767229339.','info:seqnumDuringOpen'
>>>
>>> ERROR: Row Not Found
>>>
>>> thanks!
>>
Re: delete a row in hbase:meta
Posted by Qiang Tian <ti...@gmail.com>.
Thanks Ted,
An user on 0.96 deletes a table region on HDFS by mistake, so he wants to
delete the entire table and recreate it. after disable&drop, he finds the
table's region info still exists in meta table..
from the code, we should be able to delete the related info during table
drop, I suspect the startRow(<tablename>,,) in getTableStartRowForMeta
might not be correct?
ps could hbck tool could fix it? (he deleted it finally via java code, will
see if we could repro it...)
On Mon, Jul 28, 2014 at 12:05 PM, Ted Yu <yu...@gmail.com> wrote:
> Deleting from hbase:meta is for advanced users :-)
>
> Can you tell us why that row needs to be deleted ?
>
> Cheers
>
>
> On Sun, Jul 27, 2014 at 8:32 PM, Qiang Tian <ti...@gmail.com> wrote:
>
> > Hi Guys,
> >
> > for a row in hbase:meta like below, how to delete it? due to the chars of
> > startkey, it cannot be found.
> > delete
> >
> >
> 'hbase:meta','moma,\x00"\x00\x00\x00\x012+\xF8\xCB\xF0,1406468625503.6936ebd2ae1d85fc09f243a767229339.','info:seqnumDuringOpen'
> >
> > ERROR: Row Not Found
> >
> > thanks!
> >
>
Re: delete a row in hbase:meta
Posted by Ted Yu <yu...@gmail.com>.
Deleting from hbase:meta is for advanced users :-)
Can you tell us why that row needs to be deleted ?
Cheers
On Sun, Jul 27, 2014 at 8:32 PM, Qiang Tian <ti...@gmail.com> wrote:
> Hi Guys,
>
> for a row in hbase:meta like below, how to delete it? due to the chars of
> startkey, it cannot be found.
> delete
>
> 'hbase:meta','moma,\x00"\x00\x00\x00\x012+\xF8\xCB\xF0,1406468625503.6936ebd2ae1d85fc09f243a767229339.','info:seqnumDuringOpen'
>
> ERROR: Row Not Found
>
> thanks!
>