Could you provide the version you are using? Do you have autocommit turned on and have you changed the following properties: phoenix.mutate.batchSize phoenix.mutate.maxSize phoenix.mutate.maxSizeBytes
Thanks, Sergey If you are using more recent version, than you may consider to On Thu, Nov 9, 2017 at 5:41 AM, Marcin Januszkiewicz < januszkiewicz.mar...@gmail.com> wrote: > I was trying to create a global index table but it failed out with: > > Error: ERROR 730 (LIM02): MutationState size is bigger than maximum > allowed number of bytes (state=LIM02,code=730) > java.sql.SQLException: ERROR 730 (LIM02): MutationState size is bigger > than maximum allowed number of bytes > at org.apache.phoenix.exception.SQLExceptionCode$Factory$1. > newException(SQLExceptionCode.java:489) > at org.apache.phoenix.exception.SQLExceptionInfo.buildException( > SQLExceptionInfo.java:150) > at org.apache.phoenix.execute.MutationState.throwIfTooBig( > MutationState.java:359) > at org.apache.phoenix.execute.MutationState.join( > MutationState.java:447) > at org.apache.phoenix.compile.MutatingParallelIteratorFactor > y$1.close(MutatingParallelIteratorFactory.java:98) > at org.apache.phoenix.iterate.RoundRobinResultIterator$ > RoundRobinIterator.close(RoundRobinResultIterator.java:298) > at org.apache.phoenix.iterate.RoundRobinResultIterator.next( > RoundRobinResultIterator.java:105) > at org.apache.phoenix.compile.UpsertCompiler$2.execute( > UpsertCompiler.java:821) > at org.apache.phoenix.compile.DelegateMutationPlan.execute( > DelegateMutationPlan.java:31) > at org.apache.phoenix.compile.PostIndexDDLCompiler$1. > execute(PostIndexDDLCompiler.java:117) > at org.apache.phoenix.query.ConnectionQueryServicesImpl. > updateData(ConnectionQueryServicesImpl.java:3360) > at org.apache.phoenix.schema.MetaDataClient.buildIndex( > MetaDataClient.java:1283) > at org.apache.phoenix.schema.MetaDataClient.createIndex( > MetaDataClient.java:1595) > at org.apache.phoenix.compile.CreateIndexCompiler$1.execute( > CreateIndexCompiler.java:85) > at org.apache.phoenix.jdbc.PhoenixStatement$2.call( > PhoenixStatement.java:394) > at org.apache.phoenix.jdbc.PhoenixStatement$2.call( > PhoenixStatement.java:377) > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation( > PhoenixStatement.java:376) > at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation( > PhoenixStatement.java:364) > at org.apache.phoenix.jdbc.PhoenixStatement.execute( > PhoenixStatement.java:1738) > at sqlline.Commands.execute(Commands.java:822) > at sqlline.Commands.sql(Commands.java:732) > at sqlline.SqlLine.dispatch(SqlLine.java:813) > at sqlline.SqlLine.begin(SqlLine.java:686) > at sqlline.SqlLine.start(SqlLine.java:398) > at sqlline.SqlLine.main(SqlLine.java:291) > > Is there a way to predict what max size will be sufficient, or which other > knobs to turn? > > > -- > Pozdrawiam, > Marcin Januszkiewicz >