01680_date_time_add_ubsan is flaky (due to a bug in JIT) #48272
Description
Seems everything was fine until yesterday:
SELECT
toStartOfDay(check_start_time) as t,
count() as runs,
100 * countIf(test_status != 'OK') / runs as failure_percentage
FROM checks
WHERE
test_name = '01680_date_time_add_ubsan'
AND pull_request_number = 0
AND check_start_time > today() - interval 30 day
GROUP BY t
ORDER by t
| № | t | runs | failure_percentage |
|---|---|---|---|
| 1 | 2023-03-01 00:00:00 | 190 | 0 |
| 2 | 2023-03-02 00:00:00 | 198 | 0 |
| 3 | 2023-03-03 00:00:00 | 219 | 0 |
| 4 | 2023-03-04 00:00:00 | 61 | 0 |
| 5 | 2023-03-05 00:00:00 | 50 | 0 |
| 6 | 2023-03-06 00:00:00 | 82 | 0 |
| 7 | 2023-03-07 00:00:00 | 158 | 0 |
| 8 | 2023-03-08 00:00:00 | 265 | 0 |
| 9 | 2023-03-09 00:00:00 | 176 | 0 |
| 10 | 2023-03-10 00:00:00 | 150 | 0 |
| 11 | 2023-03-11 00:00:00 | 107 | 0 |
| 12 | 2023-03-12 00:00:00 | 66 | 0 |
| 13 | 2023-03-13 00:00:00 | 83 | 0 |
| 14 | 2023-03-14 00:00:00 | 166 | 0 |
| 15 | 2023-03-15 00:00:00 | 210 | 0 |
| 16 | 2023-03-16 00:00:00 | 133 | 0 |
| 17 | 2023-03-17 00:00:00 | 166 | 0 |
| 18 | 2023-03-18 00:00:00 | 190 | 0 |
| 19 | 2023-03-19 00:00:00 | 50 | 0 |
| 20 | 2023-03-20 00:00:00 | 202 | 0 |
| 21 | 2023-03-21 00:00:00 | 228 | 0 |
| 22 | 2023-03-22 00:00:00 | 237 | 0 |
| 23 | 2023-03-23 00:00:00 | 198 | 0 |
| 24 | 2023-03-24 00:00:00 | 211 | 0 |
| 25 | 2023-03-25 00:00:00 | 88 | 0 |
| 26 | 2023-03-26 00:00:00 | 79 | 0 |
| 27 | 2023-03-27 00:00:00 | 209 | 0 |
| 28 | 2023-03-28 00:00:00 | 245 | 0 |
| 29 | 2023-03-29 00:00:00 | 260 | 0 |
| 30 | 2023-03-30 00:00:00 | 339 | 0.2949852507374631 |
| 31 | 2023-03-31 00:00:00 | 120 | 19.166666666666668 |
2023-03-31 05:47:04 The query succeeded but the server error '407' was expected (query: SELECT DISTINCT result FROM (SELECT toStartOfFifteenMinutes(toDateTime(toStartOfFifteenMinutes(toDateTime(1000.0001220703125) + (number * 65536))) + (number * 9223372036854775807)) AS result FROM system.numbers LIMIT 1048576) ORDER BY result DESC NULLS FIRST FORMAT Null; -- { serverError 407 }).
2023-03-31 05:47:04
2023-03-31 05:47:04 stdout:
2023-03-31 05:47:04 \N
2023-03-31 05:47:04
2023-03-31 05:47:04 Settings used in the test: --max_insert_threads=11 --group_by_two_level_threshold=29673 --group_by_two_level_threshold_bytes=43004415 --distributed_aggregation_memory_efficient=0 --fsync_metadata=0 --output_format_parallel_formatting=1 --input_format_parallel_parsing=1 --min_chunk_bytes_for_parallel_parsing=7451526 --max_read_buffer_size=943333 --prefer_localhost_replica=0 --max_block_size=72709 --max_threads=45 --optimize_or_like_chain=0 --optimize_read_in_order=0 --read_in_order_two_level_merge_threshold=69 --optimize_aggregation_in_order=1 --aggregation_in_order_max_block_bytes=35738655 --min_compress_block_size=1648817 --max_compress_block_size=290228 --use_uncompressed_cache=0 --min_bytes_to_use_direct_io=10312023578 --min_bytes_to_use_mmap_io=139391117 --local_filesystem_read_method=pread --remote_filesystem_read_method=threadpool --local_filesystem_read_prefetch=0 --remote_filesystem_read_prefetch=0 --compile_expressions=1 --compile_aggregate_expressions=0 --compile_sort_description=1 --merge_tree_coarse_index_granularity=3 --optimize_distinct_in_order=0 --optimize_sorting_by_input_stream_properties=1 --http_response_buffer_size=4866157 --http_wait_end_of_query=False --enable_memory_bound_merging_of_aggregation_results=1 --min_count_to_compile_expression=0 --min_count_to_compile_aggregate_expression=0 --min_count_to_compile_sort_description=0
2023-03-31 05:47:04
2023-03-31 05:47:04 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization=1.0 --prefer_fetch_merged_part_size_threshold=2987423327 --vertical_merge_algorithm_min_rows_to_activate=1 --vertical_merge_algorithm_min_columns_to_activate=63 --min_merge_bytes_to_use_direct_io=10737418240 --index_granularity_bytes=25281005 --merge_max_block_size=14399 --index_granularity=63978 --min_bytes_for_wide_part=1073741824
2023-03-31 05:47:04
2023-03-31 05:47:04 Database: test_zqfna9mk