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]> 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 >> > > >
