-
Notifications
You must be signed in to change notification settings - Fork 8.3k
00900_long_parquet_load is flaky #88893
Copy link
Copy link
Closed
Labels
flaky testflaky test found by CIflaky test found by CI
Description
Example failure (from here)
2025-10-21 22:37:02 Reason: result differs with reference:
2025-10-21 22:37:02 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00900_long_parquet_load.reference 2025-10-21 22:31:37.888796929 -1100
2025-10-21 22:37:02 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/00900_long_parquet_load.stdout 2025-10-21 22:37:01.945168713 -1100
2025-10-21 22:37:02 @@ -57,44 +57,20 @@
2025-10-21 22:37:02 �
2025-10-21 22:37:02 �
2025-10-21 22:37:02 �
2025-10-21 22:37:02 �
2025-10-21 22:37:02 �
2025-10-21 22:37:02 \b
2025-10-21 22:37:02 \t
2025-10-21 22:37:02 \n
2025-10-21 22:37:02 �
2025-10-21 22:37:02 === Try load data from byte_array_decimal.parquet
2025-10-21 22:37:02 -1
2025-10-21 22:37:02 -2
2025-10-21 22:37:02 -3
2025-10-21 22:37:02 -4
2025-10-21 22:37:02 -5
2025-10-21 22:37:02 -6
2025-10-21 22:37:02 -7
2025-10-21 22:37:02 -8
2025-10-21 22:37:02 -9
2025-10-21 22:37:02 -10
2025-10-21 22:37:02 -11
2025-10-21 22:37:02 -12
2025-10-21 22:37:02 -13
2025-10-21 22:37:02 -14
2025-10-21 22:37:02 -15
2025-10-21 22:37:02 -16
2025-10-21 22:37:02 -17
2025-10-21 22:37:02 -18
2025-10-21 22:37:02 -19
2025-10-21 22:37:02 -20
2025-10-21 22:37:02 -21
2025-10-21 22:37:02 -22
2025-10-21 22:37:02 -23
2025-10-21 22:37:02 -24
2025-10-21 22:37:02 === Try load data from case_insensitive_column_matching.parquet
2025-10-21 22:37:02 123 1
2025-10-21 22:37:02 456 2
2025-10-21 22:37:02 === Try load data from datapage_v2.snappy.parquet
2025-10-21 22:37:02 abc 1 2 1 [1,2,3]
2025-10-21 22:37:02 abc 2 3 1 []
2025-10-21 22:37:02 abc 3 4 1 []
2025-10-21 22:37:02 abc 5 2 1 [1,2]
2025-10-21 22:37:02 \N 4 5 0 [1,2,3]
2025-10-21 22:37:02 === Try load data from datatype-date32.parquet
2025-10-21 22:37:02
2025-10-21 22:37:02
2025-10-21 22:37:02 /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/test_4mzy78p6/00900_long_parquet_load.sh.debuglog:
2025-10-21 22:37:02 ++ [2025-10-21 22:36:03] [:21] dirname /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/clickhouse-client
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:21] CB_DIR=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:22] '[' /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp == . ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:23] '[' -z '' ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:23] ROOT_DIR=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/../..
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:25] DATA_DIR=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:27] '[' -n /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/../.. ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:27] '[' -z '' ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:27] PARQUET_READER=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/../../contrib/arrow/cpp/build/release/parquet-reader
2025-10-21 22:37:02 ++ [2025-10-21 22:36:03] [:42] xargs -0 -n 1 basename
2025-10-21 22:37:02 ++ [2025-10-21 22:36:03] [:42] LC_ALL=C
2025-10-21 22:37:02 ++ [2025-10-21 22:36:03] [:42] sort
2025-10-21 22:37:02 ++ [2025-10-21 22:36:03] [:42] find /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02588_data.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02716_data.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02718_data.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02725_data.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02960_polygon_bound_bug.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/03445_geoparquet_null_linestring.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/03445_geoparquet_null_point.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/03445_geoparquet_null_polygon.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/03445_geoparquet_wkb.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/03445_geoparquet_wkt.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/68131.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/alltypes_dictionary.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/alltypes_list.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/alltypes_plain.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/alltypes_plain.snappy.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/array_float.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/array_int.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/array_string.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/binary.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/byte_array_decimal.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/case_insensitive_column_matching.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/datapage_v2.snappy.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/datatype-date32.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/delta_length_byte_array_encoding.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/dict-page-offset-zero.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/example_half_float.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/fixed_array_int.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/fixed_array_nested_list_int.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/fixed_array_str.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/fixed_length_decimal_1.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/fixed_length_decimal_legacy.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/fixed_length_decimal.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/hadoop_lz4_compressed.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/int32_decimal.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/int64_decimal.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/integers_1_5_no_3_bf_minmax.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/int-list-zero-based-chunked-array.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/ipv6_bloom_filter.gz.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/list_columns.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/list_monotonically_increasing_offsets.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/multi_column_bf.gz.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/nation.dict-malformed.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/native_parquet_reader.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/nested_lists.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/nested_lists.snappy.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/nested_maps.snappy.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/nine_byte_decimals_from_spark.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/non_hadoop_lz4_compressed.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/nonnullable.impala.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/nullable.impala.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/nullable_list.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/nullbool.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/nulls.snappy.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/row_group.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/sample_json.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/single_nan.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/string_int_list_inconsistent_offset_multiple_batches.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/time32_test.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/time64_test.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/userdata1.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/userdata2.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/userdata3.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/userdata4.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/userdata5.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/v0.7.1.all-named-index.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/v0.7.1.column-metadata-handling.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/v0.7.1.parquet /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/v0.7.1.some-named-index.parquet -print0
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:42] for NAME in $(find "$DATA_DIR"/*.parquet -print0 | xargs -0 -n 1 basename | LC_ALL=C sort)
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:43] JSON=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02588_data.parquet.json
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:44] COLUMNS_FILE=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02588_data.parquet.columns
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' -z /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/../../contrib/arrow/cpp/build/release/parquet-reader ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' '!' -s /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/../../contrib/arrow/cpp/build/release/parquet-reader ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' '!' -s /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02588_data.parquet.columns ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] continue
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:42] for NAME in $(find "$DATA_DIR"/*.parquet -print0 | xargs -0 -n 1 basename | LC_ALL=C sort)
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:43] JSON=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02716_data.parquet.json
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:44] COLUMNS_FILE=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02716_data.parquet.columns
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' -z /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/../../contrib/arrow/cpp/build/release/parquet-reader ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' '!' -s /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/../../contrib/arrow/cpp/build/release/parquet-reader ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' '!' -s /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02716_data.parquet.columns ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] continue
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:42] for NAME in $(find "$DATA_DIR"/*.parquet -print0 | xargs -0 -n 1 basename | LC_ALL=C sort)
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:43] JSON=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02718_data.parquet.json
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:44] COLUMNS_FILE=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02718_data.parquet.columns
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' -z /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/../../contrib/arrow/cpp/build/release/parquet-reader ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' '!' -s /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/../../contrib/arrow/cpp/build/release/parquet-reader ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' '!' -s /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02718_data.parquet.columns ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] continue
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:42] for NAME in $(find "$DATA_DIR"/*.parquet -print0 | xargs -0 -n 1 basename | LC_ALL=C sort)
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:43] JSON=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02725_data.parquet.json
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:44] COLUMNS_FILE=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02725_data.parquet.columns
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' -z /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/../../contrib/arrow/cpp/build/release/parquet-reader ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' '!' -s /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/ci/tmp/../../contrib/arrow/cpp/build/release/parquet-reader ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] '[' '!' -s /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02725_data.parquet.columns ']'
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:46] continue
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:42] for NAME in $(find "$DATA_DIR"/*.parquet -print0 | xargs -0 -n 1 basename | LC_ALL=C sort)
2025-10-21 22:37:02 + [2025-10-21 22:36:03] [:43] JSON=/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/data_parquet/02960_polygon_bound_bug.parquet.json
2025-10-21 22:37:02 + [2025-10-21 22:
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
flaky testflaky test found by CIflaky test found by CI