-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Flaky test: 03737_text_index_materialization #92647
Copy link
Copy link
Closed
Labels
flaky testflaky test found by CIflaky test found by CItestingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI
Description
Important: This issue was automatically generated and is used by CI for matching failures. DO NOT modify the body content. DO NOT remove labels.
Test name: 03737_text_index_materialization
Failure reason: result differs with reference
CI report: Stateless tests (amd_debug, AsyncInsert, s3 storage, parallel)
CIDB statistics: cidb
Test output:
2025-12-18 10:42:56 Reason: result differs with reference:
2025-12-18 10:42:56 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03737_text_index_materialization.reference 2025-12-18 10:35:30.731865707 -0700
2025-12-18 10:42:56 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03737_text_index_materialization.stdout 2025-12-18 10:42:56.344087371 -0700
2025-12-18 10:42:56 @@ -3,27 +3,27 @@
2025-12-18 10:42:56 1
2025-12-18 10:42:56 111
2025-12-18 10:42:56 Filter column: like(__table1.text, \'%v322%\'_String) (removed)
2025-12-18 10:42:56 Granules: 196/196
2025-12-18 10:42:56 Granules: 98/196
2025-12-18 10:42:56 1
2025-12-18 10:42:56 After OPTIMIZE FINAL
2025-12-18 10:42:56 1
2025-12-18 10:42:56 111
2025-12-18 10:42:56 Filter column: like(__table1.text, \'%v322%\'_String) (removed)
2025-12-18 10:42:56 -Granules: 196/196
2025-12-18 10:42:56 -Granules: 4/196
2025-12-18 10:42:56 +Granules: 569/569
2025-12-18 10:42:56 +Granules: 4/569
2025-12-18 10:42:56 1
2025-12-18 10:42:56 After CLEAR INDEX idx_text
2025-12-18 10:42:56 0
2025-12-18 10:42:56 111
2025-12-18 10:42:56 Filter column: like(__table1.text, \'%v322%\'_String) (removed)
2025-12-18 10:42:56 -Granules: 196/196
2025-12-18 10:42:56 -Granules: 196/196
2025-12-18 10:42:56 +Granules: 569/569
2025-12-18 10:42:56 +Granules: 569/569
2025-12-18 10:42:56 1
2025-12-18 10:42:56 After MATERIALIZIZE INDEX idx_text
2025-12-18 10:42:56 1
2025-12-18 10:42:56 111
2025-12-18 10:42:56 Filter column: like(__table1.text, \'%v322%\'_String) (removed)
2025-12-18 10:42:56 -Granules: 196/196
2025-12-18 10:42:56 -Granules: 4/196
2025-12-18 10:42:56 +Granules: 569/569
2025-12-18 10:42:56 +Granules: 4/569
2025-12-18 10:42:56 1
2025-12-18 10:42:56
2025-12-18 10:42:56
2025-12-18 10:42:56 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/test_brqu4aen/03737_text_index_materialization.sh.debuglog:
2025-12-18 10:42:56 + [2025-12-18 10:42:53] [:38] /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client --send_logs_level=warning --database=test_brqu4aen --log_comment 03737_text_index_materialization.sh-test_brqu4aen --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 8590726 --merge_max_block_size 352 --index_granularity 44622 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 72567 --primary_key_compress_block_size 53066 --replace_long_file_name_to_hash 0 --max_file_name_length 70 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 383352927 --compact_parts_max_granules_to_buffer 76 --compact_parts_merge_max_bytes_to_prefetch_part 18146888 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 89 --old_parts_lifetime 176 --prewarm_mark_cache 1 --use_const_adaptive_granularity 0 --enable_index_granularity_compression 1 --enable_block_number_column 0 --enable_block_offset_column 0 --use_primary_key_cache 0 --prewarm_primary_key_cache 1 --object_serialization_version v2 --object_shared_data_serialization_version advanced --object_shared_data_serialization_version_for_zero_level_parts advanced --object_shared_data_buckets_for_compact_part 8 --object_shared_data_buckets_for_wide_part 25 --dynamic_serialization_version v3 --serialization_info_version basic --string_serialization_version with_size_stream --nullable_serialization_version basic --enable_shared_storage_snapshot_in_query 1 --allow_repeated_settings --client_logs_file=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/03737_text_index_materialization.stderr-fatal -q '
2025-12-18 10:42:56 SET allow_experimental_full_text_index = 1;
2025-12-18 10:42:56 DROP TABLE IF EXISTS t_text_index_materialization;
2025-12-18 10:42:56
2025-12-18 10:42:56 CREATE TABLE t_text_index_materialization
2025-12-18 10:42:56 (
2025-12-18 10:42:56 id UInt64,
2025-12-18 10:42:56 text String
2025-12-18 10:42:56 )
2025-12-18 10:42:56 ENGINE = MergeTree ORDER BY id
~~~~~ truncated 33 lines ~~~~~
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
flaky testflaky test found by CIflaky test found by CItestingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI