Qilin Cao created PHOENIX-5433:
----------------------------------
Summary: Upgrade phoenix from 4.4.0 to 4.14.0 occur SYSTEM.STATS
TableNotFoundException
Key: PHOENIX-5433
URL: https://issues.apache.org/jira/browse/PHOENIX-5433
Project: Phoenix
Issue Type: Bug
Reporter: Qilin Cao
When upgrade from phoenix 4.4.0 to phoenix 4.14.0, it occur
TableNotFoundException. This is because there is a step to drop table
SYSTEM.STATS when upgrade to 4.7.0,, but when upgrade to 4.14.0 the step alter
table SYSTEM.STATS can not found the table, so it execute failed.
{code:java}
19/08/05 10:19:36 ERROR query.ConnectionQueryServicesImpl: Unable to determine
tables requiring upgrade due to PHOENIX-2067
org.apache.phoenix.exception.UpgradeRequiredException: Operation not allowed
since cluster hasn't been upgraded. Call EXECUTE UPGRADE.
at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:298)
at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:289)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:288)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:281)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:1757)
at
org.apache.phoenix.util.UpgradeUtil.getPhysicalTablesWithDescRowKey(UpgradeUtil.java:1399)
at
org.apache.phoenix.util.UpgradeUtil.getPhysicalTablesWithDescRowKey(UpgradeUtil.java:1390)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemCatalogIfRequired(ConnectionQueryServicesImpl.java:2817)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemTables(ConnectionQueryServicesImpl.java:3049)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2584)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2496)
at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2496)
at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:150)
at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
at sqlline.Commands.connect(Commands.java:1064)
at sqlline.Commands.connect(Commands.java:996)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
at sqlline.SqlLine.dispatch(SqlLine.java:809)
at sqlline.SqlLine.initArgs(SqlLine.java:588)
at sqlline.SqlLine.begin(SqlLine.java:661)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:291)
19/08/05 10:21:07 WARN query.ConnectionQueryServicesImpl: Starting restore of
SYSTEM.CATALOG using snapshot
SNAPSHOT_SYSTEM.CATALOG_4.3.x_TO_4.14.0_20190805101927 because upgrade failed
19/08/05 10:21:12 WARN query.ConnectionQueryServicesImpl: Successfully restored
SYSTEM.CATALOG using snapshot
SNAPSHOT_SYSTEM.CATALOG_4.3.x_TO_4.14.0_20190805101927
19/08/05 10:21:15 WARN query.ConnectionQueryServicesImpl: Successfully restored
and enabled SYSTEM.CATALOG using snapshot
SNAPSHOT_SYSTEM.CATALOG_4.3.x_TO_4.14.0_20190805101927
Error: ERROR 1012 (42M03): Table undefined. tableName=SYSTEM.STATS
(state=42M03,code=1012)
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table
undefined. tableName=SYSTEM.STATS
{code}
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
