> 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.
Thanks for advice! May be we will choose this way. > Please file a JIRA with this information. Ok! -- Андрей Хозов Тел.: +7 (906) 814-61-33 On Thu, 2023-08-10 at 09:32 +0200, Istvan Toth wrote: > 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? > >