Re: sqlline.py kills all regionservers

2017-11-18 Thread James Taylor 
That’s quite an old version of 0.98 and we no longer support Hadoop 1.
Would it be possible for you to upgrade your cluster and use Hadoop 2
instead?

On Sat, Nov 18, 2017 at 1:16 PM Eisenhut, Roman 
wrote:

> Dear Phoenix community,
>
>
>
> I’m trying to implement apache-phoenix-4.13.0-HBase-0.98-bin on
> Hadoop-1.2.1 and HBase-0.98.6.1 on a 4 node cluster, running the following
> services:
>
>- roman-master:
>   - NameNode
>   - SecondaryNamenode
>   - HMaster
>   - HQuorumPeer
>- roman-rs-1:
>   - DataNode
>   - HRegionServer
>- roman-rs-2:
>   - DataNode
>   - HRegionServer
>- roman-rs-3:
>   - DataNode
>   - HRegionServer
>
>
>
> I have copied the corresponding server.jar into the lib directory of my
> HBase installation on every server.
>
>
>
> *ubuntu@roman-master:~$ ls -l /usr/local/hbase-0.98.6.1-hadoop1/lib | grep
> phoenix*
>
> *-rwxrwxrwx 1 ubuntu ubuntu 25706067 Nov 18 18:15
> phoenix-4.13.0-HBase-0.98-server.jar*
>
>
>
> *ubuntu@roman-rs-1:~$ ls -l /usr/local/hbase-0.98.6.1-hadoop1/lib | grep
> phoenix*
>
> *-rwxrwxrwx 1 ubuntu ubuntu 25706067 Nov 18 18:15
> phoenix-4.13.0-HBase-0.98-server.jar*
>
>
>
> *ubuntu@roman-rs-2:/usr/local$ ls -l /usr/local/hbase-0.98.6.1-hadoop1/lib
> | grep phoenix*
>
> *-rwxrwxrwx 1 ubuntu ubuntu 25706067 Nov 18 18:16
> phoenix-4.13.0-HBase-0.98-server.jar*
>
>
>
> *ubuntu@roman-rs-3:/usr/local$ ls -l /usr/local/hbase-0.98.6.1-hadoop1/lib
> | grep phoenix*
>
> *-rwxrwxrwx 1 ubuntu ubuntu 25706067 Nov 18 18:16
> phoenix-4.13.0-HBase-0.98-server.jar*
>
>
>
> I can:
>
>- Start Hadoop
>- Start HBase
>   - Create a table in HBase
>   - Put data
>   - Get data
>- Browse
>   - http://roman-master:50070/dfshealth.jsp
>   - http://roman-master:60010/master-status
>
>
>
> jps shows all the processes are up and running on each machine and the
> http interfaces show everything is running properly. It seems like the
> system is in perfect health. However, as soon as I try to connect to
> phoenix via  */usr/local/
> apache-phoenix-4.13.0-HBase-0.98-bin/bin/sqlline.py roman-master:2181* on
> roman-master, where roman-maste is my zookeeper quorum, it kills every
> regionservers on the entire cluster. After a long time, I don’t know
> exactly how long, sqlline will return an output (can be found under [3]).
>
>
>
> *Connection call*
>
> ubuntu@roman-master:/usr/local/apache-phoenix-4.13.0-HBase-0.98-bin/bin$
> ./sqlline.py roman-master:2181
>
> Setting property: [incremental, false]
>
> Setting property: [isolation, TRANSACTION_READ_COMMITTED]
>
> issuing: !connect jdbc:phoenix:roman-master:2181 none none
> org.apache.phoenix.jdbc.PhoenixDriver
>
> Connecting to jdbc:phoenix:roman-master:2181
>
> 17/11/18 19:24:33 WARN util.NativeCodeLoader: Unable to load native-hadoop
> library for your platform... using builtin-java classes where applicable
>
>
>
> Underneath you’ll find the following files
>
>- Conf files for
>   - Phoenix
>  - env.sh
>   - Hadoop
>  - hadoop-env.sh
>  - core-site.xml
>  - hdfs-site.xml
>   - HBase
>  - hbase-site.xml
>  - hbase-env.sh
>   - [1] master log on roman-master
>- [2] regionserver log roman-rs-1
>- [3] zookeeper log on roman-master
>- [4] output of sqlline.py
>
>
>
> I’m pretty sure there’s a reasonable explanation for this behavior.
> Nevertheless, I’ve been trying to get phoenix up and running for days now
> and I can’t figure out what I’m doing wrong. I hope someone can point me
> into the right direction.
>
>
>
> Best regards,
>
> Roman
>
>
>
>
>
>
>
>
>
>
>
> *Phoenix conf:*
>
>
> ubuntu@roman-master:/usr/local/apache-phoenix-4.13.0-HBase-0.98-bin/bin/config$
> cat env.sh
>
> JAVA_HOME=/usr/lib/jvm/java-8-oracle/
>
> HBASE_PATH=/usr/local/hbase-0.98.6.1-hadoop1/
>
>
>
> *Hadoop conf:*
>
> *Hadoop-env.sh*
>
>
>
> export JAVA_HOME=/usr/lib/jvm/java-8-oracle
>
> # The maximum amount of heap to use, in MB. Default is 1000.
>
> # export HADOOP_HEAPSIZE=2000
>
> # Command specific options appended to HADOOP_OPTS when specified
>
> export HADOOP_NAMENODE_OPTS="-Dcom.sun.management.jmxremote
> $HADOOP_NAMENODE_OPTS"
>
> export HADOOP_SECONDARYNAMENODE_OPTS="-Dcom.sun.management.jmxremote
> $HADOOP_SECONDARYNAMENODE_OPTS"
>
> export HADOOP_DATANODE_OPTS="-Dcom.sun.management.jmxremote
> $HADOOP_DATANODE_OPTS"
>
> export HADOOP_BALANCER_OPTS="-Dcom.sun.management.jmxremote
> $HADOOP_BALANCER_OPTS"
>
> export HADOOP_JOBTRACKER_OPTS="-Dcom.sun.management.jmxremote
> $HADOOP_JOBTRACKER_OPTS"
>
> _EOF_
>
>
>
> 
>
> 
>
>
>
> 
>
> 
>
> fs.default.name
>
> hdfs://roman-master/
>
> true
>
> 
>
> 
>
>hadoop.tmp.dir
>
>/usr/local/hadoop_tmp_dir
>
> 
>
> 
>
>
>
> 
>
> 
>
> 
>
> 
>
>

Re: 4.13.0-HBase-1.1 not released?

2017-11-18 Thread James Taylor 
FYI, we'll do one final release for Phoenix on HBase 1.1 (look for a 4.13.1
release soon). It looks like HBase 1.1 itself is nearing end-of-life, so
probably good to move off of it. If someone is interested in being the RM
for continued Phoenix HBase 1.1 releases, please volunteer.

On Mon, Nov 13, 2017 at 10:24 AM, James R. Taylor 
wrote:

> Hi Xavier,
> Please see these threads for some discussion. Would be great if you could
> volunteer to be the release manager for Phoenix released on HBase 1.1.
>
> https://lists.apache.org/thread.html/8a73efa27edb70ea5cbc89b
> 43c312faefaf2b78751c9459834523b81@%3Cuser.phoenix.apache.org%3E
> https://lists.apache.org/thread.html/04de7c47724d8ef2ed7414d
> 5bdc51325b2a0eecd324556d9e83f3718@%3Cdev.phoenix.apache.org%3E
> https://lists.apache.org/thread.html/ae13def3c024603ce3cdde8
> 71223cbdbae0219b4efe93ed4e48f55d5@%3Cdev.phoenix.apache.org%3E
>
> Thanks,
> James
>
> On 2017-11-13 07:51, Xavier Jodoin  wrote:
> > Hi,
> >
> > I would like to know if there is a reason why phoenix wasn't released
> > for hbase 1.1?
> >
> > Thanks
> >
> > Xavier Jodoin
> >
> >
>