Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Phoenix Query Server Unrecoverable service error

avatar
New Contributor

Dear! 

Once I installed and started PQS on Ambari, the service was successfully installed and started, but a second later I encountered PQS automatically stopped. 

I checked var/log/phoenix-hase-query-server.log found that, 

... Unrecoverable service error : shutting down. 

 

Anybody used to encounter such this issue?

Regard!

1 ACCEPTED SOLUTION

avatar
Master Collaborator

@Stewards  Can you please check if the guava jar exists under the /usr/hdp/current/phoenix-server/lib path and also make sure it has the right permission

View solution in original post

4 REPLIES 4

avatar
Master Collaborator

@Stewards  Can you share complete stack trace of the error

avatar
New Contributor

I am using HDP 3.1.0.0. 

when I start PQS using /usr/hdp/current/phoenix-server/bin/queryserver.py start

starting Query Server, logging to /var/log/hbase/phoenix-hbase-queryserver.log

 

 

2024-08-26 14:26:17,009 INFO org.apache.phoenix.queryserver.server.QueryServer: env:PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/hbase/.local/bin:/home/hbase/bin
2024-08-26 14:26:17,010 INFO org.apache.phoenix.queryserver.server.QueryServer: env:HISTCONTROL=ignoredups
2024-08-26 14:26:17,010 INFO org.apache.phoenix.queryserver.server.QueryServer: env:LESSOPEN=||/usr/bin/lesspipe.sh %s
2024-08-26 14:26:17,010 INFO org.apache.phoenix.queryserver.server.QueryServer: env:SHELL=/bin/bash
2024-08-26 14:26:17,010 INFO org.apache.phoenix.queryserver.server.QueryServer: env:QT_GRAPHICSSYSTEM_CHECKED=1
2024-08-26 14:26:17,010 INFO org.apache.phoenix.queryserver.server.QueryServer: env:QTINC=/usr/lib64/qt-3.3/include
2024-08-26 14:26:17,010 INFO org.apache.phoenix.queryserver.server.QueryServer: env:HISTSIZE=1000
2024-08-26 14:26:17,010 INFO org.apache.phoenix.queryserver.server.QueryServer: env:TERM=xterm
2024-08-26 14:26:17,010 INFO org.apache.phoenix.queryserver.server.QueryServer: env:XFILESEARCHPATH=/usr/dt/app-defaults/%L/Dt
2024-08-26 14:26:17,010 INFO org.apache.phoenix.queryserver.server.QueryServer: env:USER=hbase
2024-08-26 14:26:17,010 INFO org.apache.phoenix.queryserver.server.QueryServer: env:LANG=en_US.UTF-8
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:XDG_SESSION_ID=734
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:MAIL=/var/spool/mail/hbase
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:HOSTNAME=hadoop-master.wingmoney.com
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:QTDIR=/usr/lib64/qt-3.3
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:LOGNAME=hbase
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:PWD=/home/hbase
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lha=01;31:*.lz4=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.tzo=01;31:*.t7z=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lrz=01;31:*.lz=01;31:*.lzo=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.alz=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.cab=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:QTLIB=/usr/lib64/qt-3.3/lib
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:HOME=/home/hbase
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:SHLVL=1
2024-08-26 14:26:17,011 INFO org.apache.phoenix.queryserver.server.QueryServer: env:_=/usr/hdp/current/phoenix-server/bin/queryserver.py
2024-08-26 14:26:17,013 INFO org.apache.phoenix.queryserver.server.QueryServer: vmName=Java HotSpot(TM) 64-Bit Server VM, vmVendor=Oracle Corporation, vmVersion=25.112-b15
2024-08-26 14:26:17,013 INFO org.apache.phoenix.queryserver.server.QueryServer: vmInputArguments=[-Dproc_phoenixserver, -Dlog4j.configuration=file:/usr/hdp/3.1.0.0-78/phoenix/bin/log4j.properties, -Dpsql.root.logger=INFO,DRFA, -Dpsql.log.dir=/var/log/hbase, -Dpsql.log.file=phoenix-hbase-queryserver.log, -XX:ParallelGCThreads=8]
2024-08-26 14:26:17,018 INFO org.apache.phoenix.queryserver.server.QueryServer: Kerberos is off and hostname is : hadoop-master.wingmoney.com
2024-08-26 14:26:17,019 FATAL org.apache.phoenix.queryserver.server.QueryServer: Unrecoverable service error. Shutting down.
java.lang.NoClassDefFoundError: com/google/common/base/Preconditions
at org.apache.phoenix.queryserver.server.PhoenixMetaFactoryImpl.create(PhoenixMetaFactoryImpl.java:57)
at org.apache.phoenix.queryserver.server.QueryServer.run(QueryServer.java:227)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.phoenix.queryserver.server.QueryServer.main(QueryServer.java:526)
Caused by: java.lang.ClassNotFoundException: com.google.common.base.Preconditions
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 4 more

 

best regard, 

 

 

avatar
Master Collaborator

@Stewards  Can you please check if the guava jar exists under the /usr/hdp/current/phoenix-server/lib path and also make sure it has the right permission

avatar
New Contributor

-rw-r--r-- 1 root root 1891110 Dec 6 2018 guava-13.0.1.jar

there's jar file above in /usr/hdp/current/phoenix-server/lib path.