Skip to main content
Stewards
Stewards
Silver ⭐️⭐️
August 23, 2024
Solved

Phoenix Query Server Unrecoverable service error

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!

    Scharan
    ScharanAnswer
    Gold ⭐️
    August 26, 2024

    @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 in thread

    4 replies

    Scharan
    Gold ⭐️
    Scharan
    Gold ⭐️
    August 23, 2024

    @Stewards  Can you share complete stack trace of the error

    Translate
      Stewards
      StewardsAuthor
      Silver ⭐️⭐️
      August 26, 2024

      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, 

       

       

      Translate
        Scharan
        Gold ⭐️
        ScharanAnswer
        Gold ⭐️
        August 26, 2024

        @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

        Translate
          Terms & ConditionsAccessibility statement