phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcin Januszkiewicz <katamaran...@gmail.com>
Subject Re: Tuning MutationState size
Date Mon, 13 Nov 2017 09:23:08 GMT
We're using version 4.12 (on cdh 5.12). I issued the CREATE INDEX statement
with phoenix-sqlline with all default parameters.

On Fri, Nov 10, 2017 at 2:21 AM, Sergey Soldatov <sergeysoldatov@gmail.com>
wrote:

> 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.marcin@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.newE
>> xception(SQLExceptionCode.java:489)
>>         at org.apache.phoenix.exception.SQLExceptionInfo.buildException
>> (SQLExceptionInfo.java:150)
>>         at org.apache.phoenix.execute.MutationState.throwIfTooBig(Mutat
>> ionState.java:359)
>>         at org.apache.phoenix.execute.MutationState.join(MutationState.
>> java:447)
>>         at org.apache.phoenix.compile.MutatingParallelIteratorFactory$
>> 1.close(MutatingParallelIteratorFactory.java:98)
>>         at org.apache.phoenix.iterate.RoundRobinResultIterator$RoundRob
>> inIterator.close(RoundRobinResultIterator.java:298)
>>         at org.apache.phoenix.iterate.RoundRobinResultIterator.next(Rou
>> ndRobinResultIterator.java:105)
>>         at org.apache.phoenix.compile.UpsertCompiler$2.execute(UpsertCo
>> mpiler.java:821)
>>         at org.apache.phoenix.compile.DelegateMutationPlan.execute(Dele
>> gateMutationPlan.java:31)
>>         at org.apache.phoenix.compile.PostIndexDDLCompiler$1.execute(
>> PostIndexDDLCompiler.java:117)
>>         at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateD
>> ata(ConnectionQueryServicesImpl.java:3360)
>>         at org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaData
>> Client.java:1283)
>>         at org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDat
>> aClient.java:1595)
>>         at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(Cre
>> ateIndexCompiler.java:85)
>>         at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState
>> ment.java:394)
>>         at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState
>> ment.java:377)
>>         at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>>         at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(Pho
>> enixStatement.java:376)
>>         at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(Pho
>> enixStatement.java:364)
>>         at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStat
>> ement.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
>>
>
>

Mime
View raw message