[PHOENIX-1477] Phoenix 4.0 -> 4.2 upgrade doesn't work

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.2.0
• Fix Version/s: 4.3.0, 4.2.2
• Assignee: Jeffrey Zhong
• Reporter: Jeffrey Zhong
• Created: 22/Nov/14 01:40
• Updated: 21/Nov/15 02:17
• Resolved: 02/Dec/14 21:50

Description

After upgrade to Phoenix 4.2 from 4.0, a user will see the following exceptions:

org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=INDEX_TYPE
	at org.apache.phoenix.schema.PTableImpl.getColumn(PTableImpl.java:545)
	at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:269)
	at org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:337)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:467)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:458)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:259)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:252)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:250)
	at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:196)
	at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:172)
	at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:177)
	at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1506)
	at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:535)
	at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:184)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:260)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:252)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:250)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1026)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1539)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1498)
	at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1498)
	at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162)
	at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:126)
	at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
	at java.sql.DriverManager.getConnection(DriverManager.java:419)
	at java.sql.DriverManager.getConnection(DriverManager.java:391)
	at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:182)