Skip to content

Stateless 01075_window_view_proc_tumble_to_now_populate is flaky #65583

@rschu1ze

Description

@rschu1ze

E.g. here:

2024-06-21 20:33:10 --- /usr/share/clickhouse-test/queries/0_stateless/01075_window_view_proc_tumble_to_now_populate.reference	2024-06-21 20:16:45.789487544 +0700
2024-06-21 20:33:10 +++ /tmp/clickhouse-test/0_stateless/01075_window_view_proc_tumble_to_now_populate.stdout	2024-06-21 20:33:10.462322040 +0700
2024-06-21 20:33:10 @@ -1,2 +0,0 @@
2024-06-21 20:33:10 -OK
2024-06-21 20:33:10 -1
2024-06-21 20:33:10 
2024-06-21 20:33:10 
2024-06-21 20:33:10 Settings used in the test: --max_insert_threads 1 --group_by_two_level_threshold 627835 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 18525059 --max_read_buffer_size 562922 --prefer_localhost_replica 1 --max_block_size 62472 --max_joined_block_size_rows 83940 --max_threads 41 --optimize_append_index 0 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --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 0 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 4745639 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 2009869872 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method threadpool --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 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 24 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 2998448173 --min_compress_block_size 2872585 --max_compress_block_size 2959475 --merge_tree_compact_parts_min_granules_to_multibuffer_read 84 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 797576 --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 3 --min_count_to_compile_sort_description 3 --session_timezone Africa/Juba --prefer_warmed_unmerged_parts_seconds 4 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.55 --prefer_external_sort_block_bytes 100000000 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 100000000 --max_parsing_threads 10
2024-06-21 20:33:10 
2024-06-21 20:33:10 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.31758160666027024 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 4150793154 --index_granularity_bytes 30766154 --merge_max_block_size 9951 --index_granularity 36978 --min_bytes_for_wide_part 195093815 --marks_compress_block_size 70239 --primary_key_compress_block_size 72720 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 13111052 --compact_parts_max_bytes_to_buffer 262529670 --compact_parts_max_granules_to_buffer 57 --compact_parts_merge_max_bytes_to_prefetch_part 6787568 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 0 --old_parts_lifetime 10
2024-06-21 20:33:10 
2024-06-21 20:33:10 Database: test_scanmv9w

Test history:
https://play.clickhouse.com/play?user=play#c2VsZWN0IHB1bGxfcmVxdWVzdF9udW1iZXIgYXMgcHIsIGNoZWNrX3N0YXJ0X3RpbWUsIGNoZWNrX25hbWUsIHRlc3RfbmFtZSwgdGVzdF9zdGF0dXMgYXMgc3RhdHVzLCByZXBvcnRfdXJsCmZyb20gY2hlY2tzCndoZXJlIHRvRGF0ZShjaGVja19zdGFydF90aW1lKSA+ICcyMDI0LTA2LTAxJyBhbmQgc3RhdHVzPSAnRkFJTCcgYW5kIHRlc3RfbmFtZSBsaWtlICclMDEwNzVfd2luZG93X3ZpZXdfcHJvY190dW1ibGVfdG9fbm93X3BvcHVsYXRlJScKb3JkZXIgYnkgY2hlY2tfc3RhcnRfdGltZSBkZXNj

Metadata

Metadata

Assignees

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