[GitHub] [incubator-doris] morningman commented on a change in pull request #7422: [docs] add more faq and FE debugging method

[GitBox <gi...@apache.org>]

morningman commented on a change in pull request #7422:
URL: https://github.com/apache/incubator-doris/pull/7422#discussion_r775757035



##########
File path: docs/en/faq/faq.md
##########
@@ -316,4 +316,27 @@ One situation is OVERCROWDED, which means that a large amount of unsent data at
 
 The second is that the packet size of rpc exceeds `max_body_size`. This problem may occur if the query contains a very large String type or a Bitmap type. It can be circumvented by modifying the following BE parameters:
 
-1. `brpc_max_body_size`: The default is 200MB, if necessary, it can be modified to 3GB (in bytes).
\ No newline at end of file
+1. `brpc_max_body_size`: The default is 200MB, if necessary, it can be modified to 3GB (in bytes).
+
+### Q22.  The query results of unique key model are inconsistent
+
+In some cases, when users use the same SQL to query a table of a unique key model, inconsistent query results may occur. And the query results always change between 2-3 kinds.
+
+This may be because there are data with the same key but different values in the same batch of imported data, which will lead to inconsistent results between different replicas due to uncertain data replace order.
+
+For example, tables are defined as k1 and v1. A batch of imported data is as follows:
+
+```
+1, "abc"
+1, "def"
+```
+
+Then the result of replica 1 may be '1, "ABC', while the result of replica 2 may be '1," def'. This leads to inconsistent query results.
+
+To ensure the unique data order between different replicas, refer to the  [Sequence Column](../administrator-guide/load-data/sequence-column-manual.md) function.
+
+### Q23. ` recoveryTracker should overlap or follow on disk last VLSN of 4,422,880 recoveryFirst= 4,422,882 UNEXPECTED_STATE_FATAL`

Review comment:
       All fixed




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org