Support Questions

Find answers, ask questions, and share your expertise

unable to start phoenix query server via ambari


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/ -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.



Cloudera Employee

Hello @ryu ,


Refer below link for Enabling PQS via ambari



</snippet from the link>

To enable Phoenix with Ambari:

  1. Open Ambari.

  2. Select Services tab > HBase > Configs tab.

  3. Scroll down to the Phoenix SQL settings.

  4. (Optional) Reset the Phoenix Query Timeout.

  5. Click the Enable Phoenix slider button.



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



Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.