kadirozde commented on PR #1701: URL: https://github.com/apache/phoenix/pull/1701#issuecomment-1793023154
> Create index on SYSTEM.CATALOG fails with the following exception. Note the SYSTEM.CATALOG exists and EXECUTE UPGRADE has already been called. I think some checks for index table creation is failing. > > : jdbc:phoenix:localhost> CREATE INDEX IF NOT EXISTS SYS_TABLE_TYPE_INDEX ON SYSTEM.CATALOG(TENANT_ID, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, VIEW_TYPE) WHERE TABLE_TYPE IS NOT NULL; Error: Operation not allowed since cluster hasn't been upgraded. Call EXECUTE UPGRADE. (state=INT13,code=2011) org.apache.phoenix.exception.UpgradeRequiredException: Operation not allowed since cluster hasn't been upgraded. Call EXECUTE UPGRADE. at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1553) at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:2118) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:3056) at org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1557) at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:222) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:559) at or g.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:525) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:524) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:512) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:2216) at sqlline.Commands.execute(Commands.java:814) at sqlline.Commands.sql(Commands.java:754) at sqlline.SqlLine.dispatch(SqlLine.java:646) at sqlline.SqlLine.begin(SqlLine.java:510) at sqlline.SqlLine.start(SqlLine.java:233) at sqlline.SqlLine.main(SqlLine.java:175) I think this failure is not specific to partial indexes. I suggest that we fix it outside this PR. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
