Thank you very very much. I solved it! $HBASE_HOME was not set.
HBASE_HOME=/etc/hbase
export HBASE_HOME
/usr/bin/phoenix-sqlline.py localhost:2181:/hbase
-- Johannes
Am 22.02.2016 um 17:01 schrieb James Taylor:
Your client-side hbase-site.xml is likely not getting picked up. Make
sure it's on the classpath.
Thanks,
James
On Mon, Feb 22, 2016 at 1:04 AM, Johannes <[email protected]
<mailto:[email protected]>> wrote:
James, thank you very much for your fast reply.
I set the saltBuckets to 0, I disabled and dropped the
SYSTEM.SEQUENCE, I restartet HBase and reconnected the Phoenix
sqlline. After that, it creates SYSTEM.STATS, SYSTEM.FUNCTION and
again, SYSTEM.SEQUENCE with many many regions until all region
servers crash.
-- Johannes
Am 22.02.2016 um 09:10 schrieb James Taylor:
Hi Johannes,
To override this behavior, you can do the following:
- set phoenix.sequence.saltBuckets in your client-side
hbase-site.xml to 0.
- manually disable and drop SYSTEM.SEQUENCE from an HBase shell.
Note - this assumes you're not using sequences - if you are, let
us know.
- re-connect a Phoenix client to the cluster
At this point, the SYSTEM.SEQUENCE table will again be in a
single region. FWIW, we've change the default value of
the phoenix.sequence.saltBuckets to 0 (I believe as of 4.6), as
the previous value was too high for smaller clusters.
Thanks,
James
On Sun, Feb 21, 2016 at 11:57 PM, Johannes <[email protected]> wrote:
Hi,
I am using the Cloudera Manager on a six-node cluster
(master: aaa, the others: node[1-5]). It runs CDH 5.5.2 and
consists of HBase, HDFS and ZooKeeper. I downloaded,
distributed and enabled the Phoenix Parcel
4.5.2-1.clabs_phoenix1.2.0.p0.774
On the HBase-Web-UI:
* Region Servers: my five nodes, two have Num. Regions = 1
(hbase:namespace and hbase:meta), the others have 0
Now I start Phoenix:
* cd /etc/hbase/conf
* /usr/bin/phoenix-sqlline.py localhost:2181:/hbase
On the HBase-Web-UI:
* SYSTEM.CATALOG is created
* SYSTEM.SEQUENCE is created and has 12 regions
* Browser reload (F5): Now, SYSTEM.SEQUENCE has 200 region
* When SYSTEM.SEQUENCE has 224 regions, all Region Servers
are dead.
* Regions in transition. Red entry:
SYSTEM.SEQUENCE,,1455886910318.84b30d86ec2535f7ff514b9eca1a62ff.
state=FAILED_OPEN, ts=Fri Feb 19 14:01:52 CET 2016 (34s ago),
server=aaa,60020,1455886812045
I also tried to use the Phoenix tar instead of the Cloudera
parcel. Exactly the same behavior.
Thanks for every kind of help!
Johannes
