Skip to content

Flaky test 02530_dictionaries_update_field #65382

Closed
#81180
Closed
Flaky test 02530_dictionaries_update_field#65382
#81180
Labels
flaky testflaky test found by CI
@alexkats

Description

@alexkats
alexkats
opened on Jun 18, 2024
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

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions