[PHOENIX-3912] Backward compatibility fails after PHOENIX-3823

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 4.11.0
• Assignee: Unassigned
• Reporter: Mujtaba Chohan
• Created: 05/Jun/17 19:39
• Updated: 05/Jun/17 20:21
• Resolved: 05/Jun/17 20:21

Description

After PHOENIX-3823, connecting 4.x client to 4.x server upgraded from 4.10 client/server get in TNF exception on first connection.

Error: ERROR 1012 (42M03): Table undefined. tableName=SYSTEM.CATALOG (state=42M03,code=1012)
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=SYSTEM.CATALOG
	at org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:577)
	at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:392)
	at org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:229)
	at org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:502)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:726)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:712)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:385)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:375)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:373)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:362)
	at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1657)
	at org.apache.phoenix.util.UpgradeUtil.addParentToChildLinks(UpgradeUtil.java:1119)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemTables(ConnectionQueryServicesImpl.java:2801)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2465)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2386)
	at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2386)
	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)