What version did you upgrade from ? What columns do you have after the upgrade ? Have you started Phoenix at least once with HBase superuser privileges (RWXC) after the upgrade ? Please file a JIRA with this information.
If you can afford to lose the data in SYSTEM.LOG, then the easiest fix is to drop SYSTEM.LOG. Phoenix will re-create it with the correct columns on the next connection. Istvan. On Thu, Aug 10, 2023 at 7:56 AM Andrey Khozov <and...@rydlab.ru> wrote: > Hi everyone! > > After upgrading to Phoenix 5.1.3 we started getting errors in log: ERROR > 504 (42703): Undefined column. > columnName=SYSTEM.LOG.CLIENT_METADATA_CACHE_MISS_COUNTER > > After that I found that we have no 8 columns in our SYSTEM.LOG table: > > https://github.com/apache/phoenix/blob/5.1.3/phoenix-core/src/main/java/org/apache/phoenix/monitoring/MetricType.java#L60-L68 > > Is there any migrations for this columns? Or we should create it > manually? > > -- > Andrey Khozov > > > -- *István Tóth* | Sr. Staff Software Engineer *Email*: st...@cloudera.com cloudera.com <https://www.cloudera.com> [image: Cloudera] <https://www.cloudera.com/> [image: Cloudera on Twitter] <https://twitter.com/cloudera> [image: Cloudera on Facebook] <https://www.facebook.com/cloudera> [image: Cloudera on LinkedIn] <https://www.linkedin.com/company/cloudera> ------------------------------ ------------------------------