Phoenix upgrade from 4.7.0(base 1.1.2) to 5.1.2(base 2.3.0) is failing with ColumnNotFoundException

[Arshad, Mohammad]

Hello All,



Upgraded HBase from 1.1.2 to 2.3.0. After applying HBASE-25902, hbase upgrade 
was successful.



But phoenix upgrade from version 4.7.0(hbase version 1.1.2) to 5.1.2(hbase 
version 2.3,0) is failing with following error.



22/07/18 10:53:26 WARN query.ConnectionQueryServicesImpl: Failed upgrading 
System tables. Snapshots for system tables created so far: 
{SYSTEM.CATALOG=SNAPSHOT_SYSTEM.CATALOG_4.7.x_TO_5.1.0_20220718105325}

Error: ERROR 504 (42703): Undefined column. 
columnName=SYSTEM.CATALOG.COLUMN_QUALIFIER (state=42703,code=504)

org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined 
column. columnName=SYSTEM.CATALOG.COLUMN_QUALIFIER

at 
org.apache.phoenix.schema.PTableImpl.getColumnForColumnName(PTableImpl.java:1175)

at 
org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:528)



When phoenix clients connect above error is logged.



is anyone faced this issue earlier, is there known solution for this issue?



Thanks & Regards

Arshad