Skip to content

Flaky test 02530_dictionaries_update_field #65382

@alexkats

Description

@alexkats
Recent failures

CI DB Request

PR sha dur check_start_time ago check_name test_name report_url
0 bd4e76b 62.07 2024-06-17 13:32:49 19 hours Stateless tests (release, old analyzer, s3, DatabaseReplicated) [2/4] 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/0/bd4e76b1b8b6e00ae30d47f14f6818f7b3b5549e/stateless_tests__release__old_analyzer__s3__databasereplicated__[2_4].html
64597 1803535bf 187.73 2024-06-17 12:21:43 20 hours Stateless tests (release) 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/64597/1803535bfd10336b442d9fe133074d5f7cc6a596/stateless_tests__release_.html
58970 f57fd32 185.78 2024-06-17 08:52:27 1 day Stateless tests (release) 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/58970/f57fd32d239fd8bca10c5562ab0bda825f672523/stateless_tests__release_.html
61500 9ecbc56 85.01 2024-06-17 04:40:31 1 day and 4 hours Stateless tests (release, old analyzer, s3, DatabaseReplicated) [2/4] 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/61500/9ecbc568903abba46fc0f874bb938882224591ac/stateless_tests__release__old_analyzer__s3__databasereplicated__[2_4].html
65186 fdbc8001c 58.22 2024-06-14 17:37:05 3 days and 15 hours Stateless tests (release, old analyzer, s3, DatabaseReplicated) [1/3] 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/65186/fdbc8001c0df5b5c51361051b61a6892967838d6/stateless_tests__release__old_analyzer__s3__databasereplicated__[1_3].html
65279 cb8f2d2 129.45 2024-06-14 15:36:18 3 days and 17 hours Stateless tests (release, old analyzer, s3, DatabaseReplicated) [2/4] 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/65279/cb8f2d26999373dfb6737764b57785cca8e28161/stateless_tests__release__old_analyzer__s3__databasereplicated__[2_4].html
64781 08b481a 870.28 2024-06-14 05:06:39 4 days and 4 hours Stateless tests (ubsan) [2/2] 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/64781/08b481af3d8d59088216df5bc182871ef73284ff/stateless_tests__ubsan__[2_2].html
65170 9e31e3545 207.97 2024-06-13 01:26:46 5 days and 7 hours Stateless tests (aarch64) 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/65170/9e31e35455dd8b7f904aeaf3dc8be6267dd9bafb/stateless_tests__aarch64_.html
65100 d8c3b6e 182.39 2024-06-12 20:03:09 5 days and 13 hours Stateless tests (aarch64) 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/65100/d8c3b6e9d606c0aea2d329791319d63959b86529/stateless_tests__aarch64_.html
65110 384c733 184.2 2024-06-12 19:02:44 5 days and 14 hours Stateless tests (aarch64) 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/65110/384c7339415340a8238dfc50cc14336bbd148a3f/stateless_tests__aarch64_.html
65021 09b5713 122.98 2024-06-12 03:43:40 6 days and 5 hours Stateless tests (coverage) [4/6] 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/65021/09b57139be7aa31679cadf3242f69d66c9cbf8c2/stateless_tests__coverage__[4_6].html
64991 39914d8 183.08 2024-06-11 23:19:36 6 days and 9 hours Stateless tests (release) 02530_dictionaries_update_field https://s3.amazonaws.com/clickhouse-test-reports/64991/39914d848da11ba0d14cf345fb670667a1d4cde9/stateless_tests__release_.html
2024-06-17 06:31:02 --- /usr/share/clickhouse-test/queries/0_stateless/02530_dictionaries_update_field.reference	2024-06-17 06:21:38.819457262 -0600
2024-06-17 06:31:02 +++ /tmp/clickhouse-test/0_stateless/02530_dictionaries_update_field.stdout	2024-06-17 06:31:02.461753083 -0600
2024-06-17 06:31:02 @@ -98,5 +98,5 @@
2024-06-17 06:31:02  SELECT sleepEachRow(1) FROM numbers(20) SETTINGS function_sleep_max_microseconds_per_block = 20000000 FORMAT Null;
2024-06-17 06:31:02  SELECT key, value FROM dict_complex_key_hashed_custom ORDER BY key ASC;
2024-06-17 06:31:02  1	First
2024-06-17 06:31:02 -2	SecondUpdated
2024-06-17 06:31:02 +2	Second
2024-06-17 06:31:02  3	Third
2024-06-17 06:31:02 
2024-06-17 06:31:02 
2024-06-17 06:31:02 Settings used in the test: --max_insert_threads 0 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 39123191 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 19695453 --max_read_buffer_size 1009623 --prefer_localhost_replica 0 --max_block_size 86236 --max_joined_block_size_rows 44466 --max_threads 32 --optimize_append_index 0 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 1 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 74 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 34620926 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 23 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 2406503778 --min_compress_block_size 2563957 --max_compress_block_size 1146147 --merge_tree_compact_parts_min_granules_to_multibuffer_read 95 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 9601598 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone America/Mazatlan --prefer_warmed_unmerged_parts_seconds 9 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.89 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 1 --max_parsing_threads 0
2024-06-17 06:31:02 
2024-06-17 06:31:02 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 60 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 1032236099 --index_granularity_bytes 30122696 --merge_max_block_size 15974 --index_granularity 46486 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 12915 --primary_key_compress_block_size 43068 --replace_long_file_name_to_hash 1 --max_file_name_length 82 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 397054965 --compa

Metadata

Metadata

Assignees

No one assigned

    Labels

    flaky testflaky test found by CI

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions