phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacob Isaac (Jira)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5606) Upgrade from 4.14 -> 4.15 fails
Date Sat, 07 Dec 2019 05:12:00 GMT
Jacob Isaac created PHOENIX-5606:
------------------------------------

             Summary: Upgrade from 4.14 -> 4.15 fails
                 Key: PHOENIX-5606
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5606
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.15.0
            Reporter: Jacob Isaac


Disable ns mapping and set autoUpgrade to true initially

1. Connect to a 4.14 server with a 4.14 client
--> This will create SYSTEM.CATALOG with the 4.14  timestamp

2. Upgrade server jar to 4.15

3. Connect with a 4.15 client for the first time with autoUpgrade disabled (or doNotUpgrade
property set)
--> This should fail to upgrade SYSTEM.CATALOG and should throw an UpgradeRequiredException

4. Now, sqlline should show the UpgradeRequiredException, but not kill the connection, then
run EXECUTE UPGRADE

Fails with the following exception :-

0: jdbc:phoenix:localhost> EXECUTE UPGRADE;
Error: ERROR 504 (42703): Undefined column. columnName=SYSTEM.CATALOG.VIEW_INDEX_ID_DATA_TYPE
(state=42703,code=504)
org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=SYSTEM.CATALOG.VIEW_INDEX_ID_DATA_TYPE
	at org.apache.phoenix.schema.PTableImpl.getColumnForColumnName(PTableImpl.java:1106)
	at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:528)
	at org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:483)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:797)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:783)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:404)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393)
	at org.apache.phoenix.jdbc.PhoenixStatement.access$700(PhoenixStatement.java:215)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:434)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:381)
	at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:173)
	at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:183)
	at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2908)
	at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:1064)
	at org.apache.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:217)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:411)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393)
	at org.apache.phoenix.jdbc.PhoenixStatement.access$700(PhoenixStatement.java:215)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:434)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:381)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1824)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemChildLink(ConnectionQueryServicesImpl.java:3732)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeOtherSystemTablesIfRequired(ConnectionQueryServicesImpl.java:3719)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemTables(ConnectionQueryServicesImpl.java:3648)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableExecuteUpgradeStatement$1.execute(PhoenixStatement.java:1403)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:411)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393)
	at org.apache.phoenix.jdbc.PhoenixStatement.access$700(PhoenixStatement.java:215)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:434)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:381)
	at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1843)
	at sqlline.Commands.execute(Commands.java:822)
	at sqlline.Commands.sql(Commands.java:732)
	at sqlline.SqlLine.dispatch(SqlLine.java:807)
	at sqlline.SqlLine.begin(SqlLine.java:681)
	at sqlline.SqlLine.start(SqlLine.java:398)
	at sqlline.SqlLine.main(SqlLine.java:292)
0: jdbc:phoenix:localhost> !quit
Closing: org.apache.phoenix.jdbc.PhoenixConnection



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message