Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Problems with Zeppeling and phoenix after upgrade from HDP2.6 to HDP3.1

Problems with Zeppeling and phoenix after upgrade from HDP2.6 to HDP3.1

New Contributor

I have strange problem after HDP upgrade.

hbase shell working fine.

But zeppeling is not working.

It throws error:

 

%jdbc(phoenix)

select * from test limit 10

java.sql.SQLException: java.util.NoSuchElementException at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemTables(ConnectionQueryServicesImpl.java:3211)

 

 

In hbase shell i'm getting data.

After some researching, i found that phoenix-sqline is not working too.

I'm getting following messages as user hbase:

 

[hbase@edge-node] ~ $ phoenix-sqlline
Setting property: [incremental, false]
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix: none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/3.1.4.0-315/phoenix/phoenix-5.0.0.3.1.4.0-315-client.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/3.1.4.0-315/hadoop/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
20/04/30 11:28:06 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
20/04/30 11:28:35 WARN query.ConnectionQueryServicesImpl: Starting restore of SYSTEM:CATALOG using snapshot SNAPSHOT_SYSTEM.CATALOG_4.7.x_TO_5.0.0_20200430112809 because upgrade failed
20/04/30 11:28:36 WARN query.ConnectionQueryServicesImpl: Successfully restored SYSTEM:CATALOG using snapshot SNAPSHOT_SYSTEM.CATALOG_4.7.x_TO_5.0.0_20200430112809
20/04/30 11:28:41 WARN query.ConnectionQueryServicesImpl: Successfully restored and enabled SYSTEM:CATALOG using snapshot SNAPSHOT_SYSTEM.CATALOG_4.7.x_TO_5.0.0_20200430112809
Error: java.util.NoSuchElementException (state=,code=0)
java.sql.SQLException: java.util.NoSuchElementException

 

 

And from root user:

 

[root@edge-node] /var/log/hbase # phoenix-sqlline
Setting property: [incremental, false]
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix: none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/3.1.4.0-315/phoenix/phoenix-5.0.0.3.1.4.0-315-client.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/3.1.4.0-315/hadoop/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
20/04/30 11:37:57 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
20/04/30 11:38:01 WARN query.ConnectionQueryServicesImpl: Could not check for Phoenix SYSTEM tables, assuming they exist and are properly configured
Error: Operation not allowed since cluster hasn't been upgraded. Call EXECUTE UPGRADE. (state=INT13,code=2011)
org.apache.phoenix.exception.UpgradeRequiredException: Operation not allowed since cluster hasn't been upgraded. Call EXECUTE UPGRADE.
at org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:1342)

 

 

What is wrong?

How can i debug and fix it?

 

Don't have an account?
Coming from Hortonworks? Activate your account here