Jacob Isaac created PHOENIX-6688:
------------------------------------
Summary: Upgrade to phoenix 4.16 metadata upgrade fails when
SYSCAT has large number of tenant views
Key: PHOENIX-6688
URL: https://issues.apache.org/jira/browse/PHOENIX-6688
Project: Phoenix
Issue Type: Bug
Components: core
Affects Versions: 4.16.1, 4.17.0, 5.2.0
Reporter: Jacob Isaac
Caused by: org.apache.phoenix.schema.MaxMutationSizeExceededException: ERROR
729 (LIM01): MutationState size is bigger than maximum allowed number of rows,
try upserting rows in smaller batches or using autocommit on for deletes.
at
org.apache.phoenix.exception.SQLExceptionCode$21.newException(SQLExceptionCode.java:526)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:228)
at
org.apache.phoenix.util.ServerUtil.parseRemoteException(ServerUtil.java:191)
at
org.apache.phoenix.util.ServerUtil.parseServerExceptionOrNull(ServerUtil.java:175)
at
org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:142)
at
org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:1341)
at
org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:1280)
at
org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:187)
at
org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:93)
at
org.apache.phoenix.compile.UpsertCompiler$ClientUpsertSelectMutationPlan.execute(UpsertCompiler.java:1409)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:414)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:396)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:395)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:383)
at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1885)
at org.apache.phoenix.util.UpgradeUtil.moveChildLinks(UpgradeUtil.java:1181)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemChildLink(ConnectionQueryServicesImpl.java:4055)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeOtherSystemTablesIfRequired(ConnectionQueryServicesImpl.java:4033)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemTables(ConnectionQueryServicesImpl.java:3958)
at
org.apache.phoenix.query.DelegateConnectionQueryServices.upgradeSystemTables(DelegateConnectionQueryServices.java:362)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableExecuteUpgradeStatement$1.execute(PhoenixStatement.java:1445)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:414)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:396)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:395)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:383)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1866)
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
