How to recover a table

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

How to recover a table

Vikas Kanth
I can see the regions of my table at s3://mybucket/hbasedir/data/db1/mytable/77b98d085239ed8668596ea659a7ad7dHowever, Hbase fails to identify the table:

hbase(main):002:0> describe 'mytable'ERROR: Unknown table mytable!
Commands like scan and count are failing as well.I have tried running the repair and fix commands (-fixMeta, -fixAssignment and others) without any success. These commands show 0 inconsistency.Other tables look healthy.
Please let me know how to recover the table. I can't afford to drop the table
Reply | Threaded
Open this post in threaded view
|

Re: How to recover a table

Ted Yu-3
For a user table, you should see the following in the table dir:

drwxr-xr-x   - hbase hdfs          0 2018-02-16 22:20
/apps/hbase/data/data/default/t1/.tabledesc
drwxr-xr-x   - hbase hdfs          0 2018-02-16 22:20
/apps/hbase/data/data/default/t1/.tmp

Is the table descriptor under mytable ?

At the time of 'Unknown table mytable!' error, what do you see in master
log ?

Which hbase release are you using ?

Cheers

On Wed, Feb 21, 2018 at 12:44 PM, Vikas Kanth <
[hidden email]> wrote:

> I can see the regions of my table at s3://mybucket/hbasedir/data/
> db1/mytable/77b98d085239ed8668596ea659a7ad7dHowever, Hbase fails to
> identify the table:
>
> hbase(main):002:0> describe 'mytable'ERROR: Unknown table mytable!
> Commands like scan and count are failing as well.I have tried running the
> repair and fix commands (-fixMeta, -fixAssignment and others) without any
> success. These commands show 0 inconsistency.Other tables look healthy.
> Please let me know how to recover the table. I can't afford to drop the
> table
Reply | Threaded
Open this post in threaded view
|

Re: How to recover a table

Vikas Kanth
 Hi Ted,
Thanks for replying.I can see the descriptors under the table:
s3://mybucket/hbasedir/data/db1/mytable/.tabledesc/.tableinfo.0000000001s3://mybucket/hbasedir/data/db1/mytable/.tabledescs3://mybucket/hbasedir/data/db1/mytable/.tmp

This is what I see in the HBM logs:
2018-02-21 09:02:29,918 WARN  [xxxxxxxxx,16000,1519199162102_ChoreService_3] master.CatalogJanitor: CatalogJanitor disabled! Not running scan.
$ hbase versionHBase 1.3.1
Thanks
Reply | Threaded
Open this post in threaded view
|

Re: How to recover a table

Ted Yu-3
It seems there were 3 files on s3 (they're all on the same line).

If possible, can you pastebin parts of master log which were related to the
table ?

That may give us more clue.

On Thu, Feb 22, 2018 at 10:01 AM, Vikas Kanth <
[hidden email]> wrote:

>  Hi Ted,
> Thanks for replying.I can see the descriptors under the table:
> s3://mybucket/hbasedir/data/db1/mytable/.tabledesc/.
> tableinfo.0000000001s3://mybucket/hbasedir/data/db1/
> mytable/.tabledescs3://mybucket/hbasedir/data/db1/mytable/.tmp
>
> This is what I see in the HBM logs:
> 2018-02-21 09:02:29,918 WARN  [xxxxxxxxx,16000,1519199162102_ChoreService_3]
> master.CatalogJanitor: CatalogJanitor disabled! Not running scan.
> $ hbase versionHBase 1.3.1
> Thanks