You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Michal Medvecky <me...@pexe.so> on 2016/07/18 20:11:57 UTC

Cache of region boundaries are out of date

Hello,

I have ~1B table and trying to select some columns. I get this exception:

java.lang.RuntimeException:
org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108
(XCL08): Cache of region boundaries are out of date.
        at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
        at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
        at sqlline.SqlLine.print(SqlLine.java:1653)
        at sqlline.Commands.execute(Commands.java:833)
        at sqlline.Commands.sql(Commands.java:732)
        at sqlline.SqlLine.dispatch(SqlLine.java:808)
        at sqlline.SqlLine.begin(SqlLine.java:681)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:292)

I tried DELETE FROM SYSTEM.STATS WHERE PHYSICAL_NAME='MEDIA';

but did not help.

Any suggestions?

I'm using 4.6.0 on HBase 1.1.

Thank you,

Michal

Re: Cache of region boundaries are out of date

Posted by as...@gmail.com.

If your application allows it, you should restart your HBase to recompute
the stats.

Alicia

On Mon, Jul 18, 2016 at 1:11 PM, Michal Medvecky <me...@pexe.so> wrote:

> Hello,
>
> I have ~1B table and trying to select some columns. I get this exception:
>
> java.lang.RuntimeException:
> org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108
> (XCL08): Cache of region boundaries are out of date.
>         at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
>         at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
>         at sqlline.SqlLine.print(SqlLine.java:1653)
>         at sqlline.Commands.execute(Commands.java:833)
>         at sqlline.Commands.sql(Commands.java:732)
>         at sqlline.SqlLine.dispatch(SqlLine.java:808)
>         at sqlline.SqlLine.begin(SqlLine.java:681)
>         at sqlline.SqlLine.start(SqlLine.java:398)
>         at sqlline.SqlLine.main(SqlLine.java:292)
>
> I tried DELETE FROM SYSTEM.STATS WHERE PHYSICAL_NAME='MEDIA';
>
> but did not help.
>
> Any suggestions?
>
> I'm using 4.6.0 on HBase 1.1.
>
> Thank you,
>
> Michal
>