You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Xian Woo <in...@gmail.com> on 2011/08/03 11:16:51 UTC
about 'number of empty REGIONINFO_QUALIFIER rows in .META.'
Hello ,guys,
I've got a table of which rows range from 'row1' to 'row-9999' When I
tried to insert some value into the table using hbase shell , an error
occurred.
hbase(main):014:0> put 'testRow', 'row-7555', 'CF:coasd', 456
ERROR: java.io.IOException: HRegionInfo was null or empty in .META.,
row=keyvalues={testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:server/1312358658802/Put/vlen=21,
testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:serverstartcode/1312358658802/Put/vlen=8}
I checked what the hbck said :
Number of Tables: 0
Number of Tables in flux: 2
Number of live region servers: 2
server5.yun.com,60020,1312359067366
server4.yun.com,60020,1312355578234
Number of dead region servers: 0
RegionServer: server5.yun.com,60020,1312359067366 number of regions: 4
testRow,row-3520,1312363767658.035828750a724d6ce041643aa9a05d19. id:
1312363767658 encoded_name: 035828750a724d6ce041643aa9a05d19 start: row-3520
end: row-4614
testRow,row-4614,1312363803029.bf9f39ab3e172b72e7d967185f61c4b5. id:
1312363803029 encoded_name: bf9f39ab3e172b72e7d967185f61c4b5 start: row-4614
end: row-5453
testRow,row-5453,1312363803029.f47d71e4743914daf9dec91916698d79. id:
1312363803029 encoded_name: f47d71e4743914daf9dec91916698d79 start: row-5453
end:
testRow1,,1312362321918.5af6ffbf5a81c8a94418ffd66f35b8fa. id:
1312362321918 encoded_name: 5af6ffbf5a81c8a94418ffd66f35b8fa start: end:
RegionServer: server4.yun.com,60020,1312355578234 number of regions: 4
-ROOT-,,0.70236052 id: 0 encoded_name: 70236052 start: end:
.META.,,1.1028785192 id: 1 encoded_name: 1028785192 start: end:
testRow,,1312363098100.5319467240a0a755f83caf71e4c4f1f4. id: 1312363098100
encoded_name: 5319467240a0a755f83caf71e4c4f1f4 start: end: row-252
testRow,row-252,1312363151512.b9f2b07ad2ea34d483d7f05764008be0. id:
1312363151512 encoded_name: b9f2b07ad2ea34d483d7f05764008be0 start: row-252
end: row-3520
Number of empty REGIONINFO_QUALIFIER rows in .META.: 1
keyvalues={testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:server/1312358658802/Put/vlen=21,
testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:serverstartcode/1312358658802/Put/vlen=8}
Summary:
-ROOT- is okay.
Number of regions: 1
Deployed on: server4.yun.com:60020
.META. is okay.
Number of regions: 1
Deployed on: server4.yun.com:60020
testRow is okay.
Number of regions: 5
Deployed on: server4.yun.com:60020 server5.yun.com:60020
testRow1 is okay.
Number of regions: 1
Deployed on: server5.yun.com:60020
0 inconsistencies detected.
Status: OK
What does 'empty REGIONINFO_QUALIFIER rows' mean? How to delete this
corrupted region? Or how can I fix this problem?
Thanks ,guys.
Best wishes!
Woo
Re: about 'number of empty REGIONINFO_QUALIFIER rows in .META.'
Posted by Xian Woo <in...@gmail.com>.
When I delete the specified row, everything about that table is fine. I can
now continue inserting values and the web ui page shows the appropriate
regions about this table.
Thanks man.
With regards.
Woo
2011/8/4 Jean-Daniel Cryans <jd...@apache.org>
> This used to be leftovers from old bugs we had with the old master,
> but I'm not aware of any current bug that cause that. Maybe a failed
> split that rolled back, only your master and region server logs can
> tell.
>
> Looking at the output it seems that your table is healthy, but that
> row in .META. without a regioninfo is screwing up the region lookup.
> Since it's not assigned, you can safely delete it like this:
>
> deleteall '.META.',
> 'testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683.'
>
> J-D
>
> On Wed, Aug 3, 2011 at 2:16 AM, Xian Woo <in...@gmail.com> wrote:
> > Hello ,guys,
> >
> > I've got a table of which rows range from 'row1' to 'row-9999' When I
> > tried to insert some value into the table using hbase shell , an error
> > occurred.
> >
> > hbase(main):014:0> put 'testRow', 'row-7555', 'CF:coasd', 456
> >
> > ERROR: java.io.IOException: HRegionInfo was null or empty in .META.,
> >
> row=keyvalues={testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:server/1312358658802/Put/vlen=21,
> >
> testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:serverstartcode/1312358658802/Put/vlen=8}
> >
> > I checked what the hbck said :
> >
> > Number of Tables: 0
> > Number of Tables in flux: 2
> > Number of live region servers: 2
> > server5.yun.com,60020,1312359067366
> > server4.yun.com,60020,1312355578234
> > Number of dead region servers: 0
> > RegionServer: server5.yun.com,60020,1312359067366 number of regions: 4
> > testRow,row-3520,1312363767658.035828750a724d6ce041643aa9a05d19. id:
> > 1312363767658 encoded_name: 035828750a724d6ce041643aa9a05d19 start:
> row-3520
> > end: row-4614
> > testRow,row-4614,1312363803029.bf9f39ab3e172b72e7d967185f61c4b5. id:
> > 1312363803029 encoded_name: bf9f39ab3e172b72e7d967185f61c4b5 start:
> row-4614
> > end: row-5453
> > testRow,row-5453,1312363803029.f47d71e4743914daf9dec91916698d79. id:
> > 1312363803029 encoded_name: f47d71e4743914daf9dec91916698d79 start:
> row-5453
> > end:
> > testRow1,,1312362321918.5af6ffbf5a81c8a94418ffd66f35b8fa. id:
> > 1312362321918 encoded_name: 5af6ffbf5a81c8a94418ffd66f35b8fa start: end:
> > RegionServer: server4.yun.com,60020,1312355578234 number of regions: 4
> > -ROOT-,,0.70236052 id: 0 encoded_name: 70236052 start: end:
> > .META.,,1.1028785192 id: 1 encoded_name: 1028785192 start: end:
> > testRow,,1312363098100.5319467240a0a755f83caf71e4c4f1f4. id:
> 1312363098100
> > encoded_name: 5319467240a0a755f83caf71e4c4f1f4 start: end: row-252
> > testRow,row-252,1312363151512.b9f2b07ad2ea34d483d7f05764008be0. id:
> > 1312363151512 encoded_name: b9f2b07ad2ea34d483d7f05764008be0 start:
> row-252
> > end: row-3520
> > Number of empty REGIONINFO_QUALIFIER rows in .META.: 1
> >
> >
> keyvalues={testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:server/1312358658802/Put/vlen=21,
> >
> testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:serverstartcode/1312358658802/Put/vlen=8}
> > Summary:
> > -ROOT- is okay.
> > Number of regions: 1
> > Deployed on: server4.yun.com:60020
> > .META. is okay.
> > Number of regions: 1
> > Deployed on: server4.yun.com:60020
> > testRow is okay.
> > Number of regions: 5
> > Deployed on: server4.yun.com:60020 server5.yun.com:60020
> > testRow1 is okay.
> > Number of regions: 1
> > Deployed on: server5.yun.com:60020
> > 0 inconsistencies detected.
> > Status: OK
> >
> > What does 'empty REGIONINFO_QUALIFIER rows' mean? How to delete this
> > corrupted region? Or how can I fix this problem?
> >
> > Thanks ,guys.
> >
> > Best wishes!
> >
> > Woo
> >
>
Re: about 'number of empty REGIONINFO_QUALIFIER rows in .META.'
Posted by Jean-Daniel Cryans <jd...@apache.org>.
This used to be leftovers from old bugs we had with the old master,
but I'm not aware of any current bug that cause that. Maybe a failed
split that rolled back, only your master and region server logs can
tell.
Looking at the output it seems that your table is healthy, but that
row in .META. without a regioninfo is screwing up the region lookup.
Since it's not assigned, you can safely delete it like this:
deleteall '.META.',
'testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683.'
J-D
On Wed, Aug 3, 2011 at 2:16 AM, Xian Woo <in...@gmail.com> wrote:
> Hello ,guys,
>
> I've got a table of which rows range from 'row1' to 'row-9999' When I
> tried to insert some value into the table using hbase shell , an error
> occurred.
>
> hbase(main):014:0> put 'testRow', 'row-7555', 'CF:coasd', 456
>
> ERROR: java.io.IOException: HRegionInfo was null or empty in .META.,
> row=keyvalues={testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:server/1312358658802/Put/vlen=21,
> testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:serverstartcode/1312358658802/Put/vlen=8}
>
> I checked what the hbck said :
>
> Number of Tables: 0
> Number of Tables in flux: 2
> Number of live region servers: 2
> server5.yun.com,60020,1312359067366
> server4.yun.com,60020,1312355578234
> Number of dead region servers: 0
> RegionServer: server5.yun.com,60020,1312359067366 number of regions: 4
> testRow,row-3520,1312363767658.035828750a724d6ce041643aa9a05d19. id:
> 1312363767658 encoded_name: 035828750a724d6ce041643aa9a05d19 start: row-3520
> end: row-4614
> testRow,row-4614,1312363803029.bf9f39ab3e172b72e7d967185f61c4b5. id:
> 1312363803029 encoded_name: bf9f39ab3e172b72e7d967185f61c4b5 start: row-4614
> end: row-5453
> testRow,row-5453,1312363803029.f47d71e4743914daf9dec91916698d79. id:
> 1312363803029 encoded_name: f47d71e4743914daf9dec91916698d79 start: row-5453
> end:
> testRow1,,1312362321918.5af6ffbf5a81c8a94418ffd66f35b8fa. id:
> 1312362321918 encoded_name: 5af6ffbf5a81c8a94418ffd66f35b8fa start: end:
> RegionServer: server4.yun.com,60020,1312355578234 number of regions: 4
> -ROOT-,,0.70236052 id: 0 encoded_name: 70236052 start: end:
> .META.,,1.1028785192 id: 1 encoded_name: 1028785192 start: end:
> testRow,,1312363098100.5319467240a0a755f83caf71e4c4f1f4. id: 1312363098100
> encoded_name: 5319467240a0a755f83caf71e4c4f1f4 start: end: row-252
> testRow,row-252,1312363151512.b9f2b07ad2ea34d483d7f05764008be0. id:
> 1312363151512 encoded_name: b9f2b07ad2ea34d483d7f05764008be0 start: row-252
> end: row-3520
> Number of empty REGIONINFO_QUALIFIER rows in .META.: 1
>
> keyvalues={testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:server/1312358658802/Put/vlen=21,
> testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:serverstartcode/1312358658802/Put/vlen=8}
> Summary:
> -ROOT- is okay.
> Number of regions: 1
> Deployed on: server4.yun.com:60020
> .META. is okay.
> Number of regions: 1
> Deployed on: server4.yun.com:60020
> testRow is okay.
> Number of regions: 5
> Deployed on: server4.yun.com:60020 server5.yun.com:60020
> testRow1 is okay.
> Number of regions: 1
> Deployed on: server5.yun.com:60020
> 0 inconsistencies detected.
> Status: OK
>
> What does 'empty REGIONINFO_QUALIFIER rows' mean? How to delete this
> corrupted region? Or how can I fix this problem?
>
> Thanks ,guys.
>
> Best wishes!
>
> Woo
>
Re: about 'number of empty REGIONINFO_QUALIFIER rows in .META.'
Posted by Xian Woo <in...@gmail.com>.
In addition, when I opened the Web Based UI and clicked on the "testRow" button
in "User Tables", I didn't get any information about "Online Regions" while
I can still scan or get this table..
2011/8/3 Xian Woo <in...@gmail.com>
> Hello ,guys,
>
> I've got a table of which rows range from 'row1' to 'row-9999' When I
> tried to insert some value into the table using hbase shell , an error
> occurred.
>
> hbase(main):014:0> put 'testRow', 'row-7555', 'CF:coasd', 456
>
> ERROR: java.io.IOException: HRegionInfo was null or empty in .META.,
> row=keyvalues={testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:server/1312358658802/Put/vlen=21,
> testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:serverstartcode/1312358658802/Put/vlen=8}
>
> I checked what the hbck said :
>
> Number of Tables: 0
> Number of Tables in flux: 2
> Number of live region servers: 2
> server5.yun.com,60020,1312359067366
> server4.yun.com,60020,1312355578234
> Number of dead region servers: 0
> RegionServer: server5.yun.com,60020,1312359067366 number of regions: 4
> testRow,row-3520,1312363767658.035828750a724d6ce041643aa9a05d19. id:
> 1312363767658 encoded_name: 035828750a724d6ce041643aa9a05d19 start: row-3520
> end: row-4614
> testRow,row-4614,1312363803029.bf9f39ab3e172b72e7d967185f61c4b5. id:
> 1312363803029 encoded_name: bf9f39ab3e172b72e7d967185f61c4b5 start: row-4614
> end: row-5453
> testRow,row-5453,1312363803029.f47d71e4743914daf9dec91916698d79. id:
> 1312363803029 encoded_name: f47d71e4743914daf9dec91916698d79 start: row-5453
> end:
> testRow1,,1312362321918.5af6ffbf5a81c8a94418ffd66f35b8fa. id:
> 1312362321918 encoded_name: 5af6ffbf5a81c8a94418ffd66f35b8fa start: end:
> RegionServer: server4.yun.com,60020,1312355578234 number of regions: 4
> -ROOT-,,0.70236052 id: 0 encoded_name: 70236052 start: end:
> .META.,,1.1028785192 id: 1 encoded_name: 1028785192 start: end:
> testRow,,1312363098100.5319467240a0a755f83caf71e4c4f1f4. id:
> 1312363098100 encoded_name: 5319467240a0a755f83caf71e4c4f1f4 start: end:
> row-252
> testRow,row-252,1312363151512.b9f2b07ad2ea34d483d7f05764008be0. id:
> 1312363151512 encoded_name: b9f2b07ad2ea34d483d7f05764008be0 start: row-252
> end: row-3520
> Number of empty REGIONINFO_QUALIFIER rows in .META.: 1
>
> keyvalues={testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:server/1312358658802/Put/vlen=21,
> testRow,row-6621,1312357031304.f5685bf0b6292525cb6ff7bf1b784683./info:serverstartcode/1312358658802/Put/vlen=8}
> Summary:
> -ROOT- is okay.
> Number of regions: 1
> Deployed on: server4.yun.com:60020
> .META. is okay.
> Number of regions: 1
> Deployed on: server4.yun.com:60020
> testRow is okay.
> Number of regions: 5
> Deployed on: server4.yun.com:60020 server5.yun.com:60020
> testRow1 is okay.
> Number of regions: 1
> Deployed on: server5.yun.com:60020
> 0 inconsistencies detected.
> Status: OK
>
> What does 'empty REGIONINFO_QUALIFIER rows' mean? How to delete this
> corrupted region? Or how can I fix this problem?
>
> Thanks ,guys.
>
> Best wishes!
>
> Woo
>
>