unable to start phoenix query server via ambari

ryu — Fri, 14 May 2021 22:02:03 GMT

Hi experts,

So I recently installed Hbase via ambari.

I am able to start hbase master and regionserver.

However, when I start the phoenix queryserver, ambari does not throw any errors, however, within a couple seconds, the phoenix queryserver stops.

This is the error I found below:

[root@test02 ~]# cat /var/log/hbase/phoenix-hbase-queryserver.out
Error: Could not find or load main class org.apache.phoenix.queryserver.server.QueryServer
starting Query Server, logging to /var/log/hbase/phoenix-hbase-queryserver.log
2021-05-14 16:39:23.784483 launching /usr/jdk64/jdk1.8.0_112/bin/java -cp /etc/hbase/conf:/etc/hadoop/conf:/usr/lib/phoenix/bin/../phoenix-4.15.0-HBase-1.5-client.jar:::/etc/hadoop/conf:/usr/lib/hadoop/lib/*:/usr/lib/hadoop/.//*:/usr/lib/hadoop-hdfs/./:/usr/lib/hadoop-hdfs/lib/*:/usr/lib/hadoop-hdfs/.//*:/usr/lib/hadoop-yarn/lib/*:/usr/lib/hadoop-yarn/.//*:/usr/lib/hadoop-mapreduce/lib/*:/usr/lib/hadoop-mapreduce/.//*::mysql-connector-java.jar:/usr/lib/hadoop-mapreduce/*:/usr/lib/tez/*:/usr/lib/tez/lib/*:/etc/tez/conf
-Dproc_phoenixserver -Dlog4j.configuration=file:/usr/lib/phoenix/bin/log4j.properties -Dpsql.root.logger=INFO,DRFA -Dpsql.log.dir=/var/log/hbase -Dpsql.log.file=phoenix-hbase-queryserver.log org.apache.phoenix.queryserver.server.QueryServer
close failed in file object destructor:
IOError: [Errno 9] Bad file descriptor

Any help is much appreciated.

Thanks,

Re: unable to start phoenix query server via ambari

9een — Fri, 02 Jul 2021 18:19:18 GMT

Hello @ryu ,

Refer below link for Enabling PQS via ambari

++++++++++++

https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.5.3/bk_data-access/content/ch_using-phoenix.html#enabling-phoenix

</snippet from the link>

To enable Phoenix with Ambari:

Open Ambari.
Select Services tab > HBase > Configs tab.
Scroll down to the Phoenix SQL settings.
(Optional) Reset the Phoenix Query Timeout.
Click the Enable Phoenix slider button.

++++++++++++

Also would recommend to review below doc for installing phoenix via command line

https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.5.3/bk_command-line-installation/content/ch_install_phoenix_chapter.html

question unable to start phoenix query server via ambari in Support Questions

unable to start phoenix query server via ambari

Re: unable to start phoenix query server via ambari