Skip to content

Flaky test: 03737_text_index_materialization #92647

@GrigoryPervakov

Description

@GrigoryPervakov

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 ~~~~~

Metadata

Metadata

Assignees

No one assigned

    Labels

    flaky testflaky test found by CItestingSpecial issue with list of bugs found by CI

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions