This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 60b802eafa [typo](docs) update document syntax and add links to
referenced articles (#21817)
60b802eafa is described below
commit 60b802eafacc789b5a1cad7630144c215f9127e5
Author: Euporia <[email protected]>
AuthorDate: Sun Aug 6 10:41:08 2023 +0800
[typo](docs) update document syntax and add links to referenced articles
(#21817)
---
docs/en/docs/faq/data-faq.md | 2 +-
docs/zh-CN/docs/data-operate/update-delete/update.md | 2 +-
docs/zh-CN/docs/faq/data-faq.md | 4 ++--
3 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/docs/en/docs/faq/data-faq.md b/docs/en/docs/faq/data-faq.md
index e5926c65c4..278bf5596f 100644
--- a/docs/en/docs/faq/data-faq.md
+++ b/docs/en/docs/faq/data-faq.md
@@ -58,7 +58,7 @@ But unfortunately, the table of the Unique Key model cannot
establish a material
This error usually occurs during data import operations. The error code is
-235. The meaning of this error is that the data version of the corresponding
tablet exceeds the maximum limit (default 500, controlled by the BE parameter
`max_tablet_version_num`), and subsequent writes will be rejected. For example,
the error in the question means that the data version of the tablet 27306172
exceeds the limit.
-This error is usually caused by the import frequency being too high, which is
greater than the compaction speed of the backend data, causing versions to pile
up and eventually exceed the limit. At this point, we can first pass the show
tablet 27306172 statement, and then execute the show proc statement in the
result to check the status of each copy of the tablet. The versionCount in the
result represents the number of versions. If you find that a copy has too many
versions, you need to r [...]
+This error is usually caused by the import frequency being too high, which is
greater than the compaction speed of the backend data, causing versions to pile
up and eventually exceed the limit. At this point, we can first pass the show
tablet 27306172 statement, and then execute the show proc statement in the
result to check the status of each copy of the tablet. The versionCount in the
result represents the number of versions. If you find that a copy has too many
versions, you need to r [...]
The -238 error usually occurs when the same batch of imported data is too
large, resulting in too many Segment files for a tablet (default is 200,
controlled by the BE parameter `max_segment_num_per_rowset`). At this time, it
is recommended to reduce the amount of data imported in one batch, or
appropriately increase the BE configuration parameter value to solve the
problem. Since version 2.0, users can enable segment compaction feature to
reduce segment file number by setting `enable_se [...]
diff --git a/docs/zh-CN/docs/data-operate/update-delete/update.md
b/docs/zh-CN/docs/data-operate/update-delete/update.md
index 232a10caff..c2e8207de7 100644
--- a/docs/zh-CN/docs/data-operate/update-delete/update.md
+++ b/docs/zh-CN/docs/data-operate/update-delete/update.md
@@ -30,7 +30,7 @@ under the License.
## 适用场景
-- 对满足某些条件的行，修改他的取值；
+- 对满足某些条件的行，修改其取值；
- 点更新，小范围更新，待更新的行最好是整个表的非常小的一部分；
- update 命令只能在 Unique 数据模型的表中执行。
diff --git a/docs/zh-CN/docs/faq/data-faq.md b/docs/zh-CN/docs/faq/data-faq.md
index 45c6629ff6..8f8f59d001 100644
--- a/docs/zh-CN/docs/faq/data-faq.md
+++ b/docs/zh-CN/docs/faq/data-faq.md
@@ -58,9 +58,9 @@ Unique Key模型的表是一个对业务比较友好的表，因为其特有的
这个错误通常发生在数据导入操作中。错误码为 -235。这个错误的含义是，对应tablet的数据版本超过了最大限制（默认500，由 BE 参数
`max_tablet_version_num` 控制），后续写入将被拒绝。比如问题中这个错误，即表示 27306172 这个tablet的数据版本超过了限制。
-这个错误通常是因为导入的频率过高，大于后台数据的compaction速度，导致版本堆积并最终超过了限制。此时，我们可以先通过show tablet
27306172 语句，然后执行结果中的 show proc 语句，查看tablet各个副本的情况。结果中的
versionCount即表示版本数量。如果发现某个副本的版本数量过多，则需要降低导入频率或停止导入，并观察版本数是否有下降。如果停止导入后，版本数依然没有下降，则需要去对应的BE节点查看be.INFO日志，搜索tablet
id以及 compaction关键词，检查compaction是否正常运行。关于compaction调优相关，可以参阅 ApacheDoris
公众号文章：Doris 最佳实践-Compaction调优(3)
+这个错误通常是因为导入的频率过高，大于后台数据的compaction速度，导致版本堆积并最终超过了限制。此时，我们可以先通过show tablet
27306172 语句，然后执行结果中的 show proc 语句，查看tablet各个副本的情况。结果中的
versionCount即表示版本数量。如果发现某个副本的版本数量过多，则需要降低导入频率或停止导入，并观察版本数是否有下降。如果停止导入后，版本数依然没有下降，则需要去对应的BE节点查看be.INFO日志，搜索tablet
id以及 compaction关键词，检查compaction是否正常运行。关于compaction调优相关，可以参阅 ApacheDoris
公众号文章：[Doris
最佳实践-Compaction调优(3)](https://mp.weixin.qq.com/s/cZmXEsNPeRMLHp379kc2aA)
--238 错误通常出现在同一批导入数据量过大的情况，从而导致某一个 tablet 的 Segment 文件过多（默认是 200，由 BE 参数
`max_segment_num_per_rowset` 控制）。此时建议减少一批次导入的数据量，或者适当提高 BE
配置参数值来解决。在2.0版本及以后，可以通过打开 segment compaction 功能来减少 Segment 文件数量(BE config 中
enable_segcompaction=true)。
+-238 错误通常出现在同一批导入数据量过大的情况，从而导致某一个 tablet 的 Segment 文件过多（默认是 200，由 BE 参数
`max_segment_num_per_rowset` 控制）。此时建议减少一批次导入的数据量，或者适当提高 BE
配置参数值来解决。在2.0版本及以后，可以通过打开 segment compaction 功能来减少 Segment 文件数量(BE config 中
`enable_segcompaction=true`)。
### Q5. tablet 110309738 has few replicas: 1, alive backends: [10003]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
