You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Mohammad Arshad (Jira)" <ji...@apache.org> on 2023/08/14 12:37:00 UTC
[jira] [Commented] (AMBARI-25977) Increase default value of phoenix.mutate.maxSizeBytes from 100 MB to 255 MB
[ https://issues.apache.org/jira/browse/AMBARI-25977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17754083#comment-17754083 ]
Mohammad Arshad commented on AMBARI-25977:
------------------------------------------
Thanks [~brahmareddy] for reviewing and merging the PR.
> Increase default value of phoenix.mutate.maxSizeBytes from 100 MB to 255 MB
> ---------------------------------------------------------------------------
>
> Key: AMBARI-25977
> URL: https://issues.apache.org/jira/browse/AMBARI-25977
> Project: Ambari
> Issue Type: Bug
> Components: ambari-metrics
> Affects Versions: metrics-3.0.0
> Reporter: Mohammad Arshad
> Assignee: Mohammad Arshad
> Priority: Major
> Fix For: 2.8.0, 2.7.8
>
> Attachments: screenshot-1.png
>
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> Default value of phoenix.mutate.maxSizeBytes is 104857600(100 MB). As number of records in a batch by default are set to 10000, some times this value is not sufficient and collector fails, to store aggregated data, with following error
> {code:java}
> 2023-07-25 11:21:21,500 WARN org.apache.ambari.metrics.core.timeline.PhoenixHBaseAccessor: Failed on insert records to store : ERROR 730 (LIM02): MutationState size is bigger than maximum allowed number of bytes, try upserting rows in smaller batches or using autocommit on for deletes. maxMutationSizeBytes=104857600 mutationSizeBytes=104858209
> 2023-07-25 11:21:21,500 WARN org.apache.ambari.metrics.core.timeline.PhoenixHBaseAccessor: Metric that cannot be stored : [regionserver.Server.rpcScanRequestCount,hbase]{1690284077957=162.7735639506746, 1690284092957=105.90141339016705, 1690284107957=171.52342993691653, 1690284122957=133.09041926456285}
> 2023-07-25 11:21:21,597 WARN org.apache.ambari.metrics.core.timeline.PhoenixHBaseAccessor: Failed on insert records to store : ERROR 730 (LIM02): MutationState size is bigger than maximum allowed number of bytes, try upserting rows in smaller batches or using autocommit on for deletes. maxMutationSizeBytes=104857600 mutationSizeBytes=104858964
> 2023-07-25 11:21:21,598 WARN org.apache.ambari.metrics.core.timeline.PhoenixHBaseAccessor: Metric that cannot be stored : [regionserver.WAL.SyncTime_median,hbase]{1690284077957=188.0381529206563, 1690284092957=154.30748048226928, 1690284107957=190.57156509009513, 1690284122957=195.3577965382318}
> {code}
> lets set phoenix.mutate.maxSizeBytes value to 267386880 (255 MB) to make it more reasonable with batch size.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@ambari.apache.org
For additional commands, e-mail: issues-help@ambari.apache.org