[Bug] 幻读

[liuyong19892]

Search before asking

• I had searched in the issues and found no similar issues.

Version

2.1.9-rc02

What's Wrong?

UNIQUE KEY(aaaid) PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"min_load_replica_num" = "1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "DEFAULT",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"function_column.sequence_col" = "update_time",
"store_row_column" = "true",
"row_store_page_size" = "16384",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728",
"enable_mow_light_delete" = "false"
) select update_time from statisticsInfo where aaaid = '156999999999' 这个查询结果会随机在2条抖动 集群3+5

What You Expected?

是什么问题？ 能不能修复

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[liuyong19892]

query_result.csv

[liuyong19892]

set use_fix_replica=0; 找出来 0号副本是错的 但是执行ADMIN COMPACT TABLE statisticsInfo PARTITION (statisticsInfo) WHERE type = 'cumulative'; 并没有解决版本合并最新