Skip to content

Functional test 02922_deduplication_with_zero_copy has failed #80288

@nikitamikhaylov

Description

@nikitamikhaylov

Describe the bug

https://s3.amazonaws.com/clickhouse-test-reports/json.html?PR=80188&sha=4bebd81d73a73179d0a2eb98a3b153e7c14fe72d&name_0=PR&name_1=Stateless%20tests%20%28msan%2C%204%2F4%29

Error message and/or stacktrace

2025-05-14 20:16:03 Reason: having stderror:  
2025-05-14 20:16:03 [93bf318188d5] 2025.05.14 20:16:03.036485 [ 3862 ] {eba6fc57-e9ec-451d-b1ca-68891b1e56fe} <Error> executeQuery: Code: 242. DB::Exception: Table is in readonly mode (replica path: /test/02922/test_8l10y3wb/table/replicas/1). (TABLE_IS_READ_ONLY) (version 25.5.1.1) (from [::1]:60732) (comment: 02922_deduplication_with_zero_copy.sh) (query 1, line 2) (in query: system sync replica r1;), Stack trace (when copying this message, always include the lines below):
2025-05-14 20:16:03 
2025-05-14 20:16:03 0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x0000000043bbe786
2025-05-14 20:16:03 1. ./ci/tmp/build/./src/Common/Exception.cpp:108: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000021b3a9b2
2025-05-14 20:16:03 2. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x0000000008df82ff
2025-05-14 20:16:03 3. DB::Exception::Exception<String const&>(int, FormatStringHelperImpl<std::type_identity<String const&>::type>, String const&) @ 0x000000000b0b3f6a
2025-05-14 20:16:03 4. ./ci/tmp/build/./src/Storages/StorageReplicatedMergeTree.cpp:5943: DB::StorageReplicatedMergeTree::assertNotReadonly() const @ 0x000000003afc975e
2025-05-14 20:16:03 5. ./ci/tmp/build/./src/Storages/StorageReplicatedMergeTree.cpp:331: DB::StorageReplicatedMergeTree::waitForProcessingQueue(unsigned long, DB::SyncReplicaMode, std::unordered_set<String, std::hash<String>, std::equal_to<String>, std::allocator<String>>) @ 0x000000003b30f23c
2025-05-14 20:16:03 6. ./ci/tmp/build/./src/Interpreters/InterpreterSystemQuery.cpp:1254: DB::InterpreterSystemQuery::trySyncReplica(std::shared_ptr<DB::IStorage>, DB::SyncReplicaMode, std::unordered_set<String, std::hash<String>, std::equal_to<String>, std::allocator<String>> const&, std::shared_ptr<DB::Context const>) @ 0x0000000035f29f81
2025-05-14 20:16:03 7. ./ci/tmp/build/./src/Interpreters/InterpreterSystemQuery.cpp:1273: DB::InterpreterSystemQuery::syncReplica(DB::ASTSystemQuery&) @ 0x0000000035f0f206
2025-05-14 20:16:03 8. ./ci/tmp/build/./src/Interpreters/InterpreterSystemQuery.cpp:752: DB::InterpreterSystemQuery::execute() @ 0x0000000035ee9304
2025-05-14 20:16:03 9. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1522: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr<DB::IAST>&) @ 0x0000000035e30fe5
2025-05-14 20:16:03 10. ./ci/tmp/build/./src/Interpreters/executeQuery.cpp:1714: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000035e215cc
2025-05-14 20:16:03 11. ./ci/tmp/build/./src/Server/TCPHandler.cpp:685: DB::TCPHandler::runImpl() @ 0x000000003d686cf3
2025-05-14 20:16:03 12. ./ci/tmp/build/./src/Server/TCPHandler.cpp:2673: DB::TCPHandler::run() @ 0x000000003d6f053c
2025-05-14 20:16:03 13. ./ci/tmp/build/./base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x0000000043e047c0
2025-05-14 20:16:03 14. ./ci/tmp/build/./base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x0000000043e056f2
2025-05-14 20:16:03 15. ./ci/tmp/build/./base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x0000000043cdec95
2025-05-14 20:16:03 16. ./ci/tmp/build/./base/poco/Foundation/src/Thread.cpp:45: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x0000000043cdba8e
2025-05-14 20:16:03 17. ./base/poco/Foundation/src/Thread_POSIX.cpp:335: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000043cd8611
2025-05-14 20:16:03 18. ? @ 0x00007f26815f5ac3
2025-05-14 20:16:03 19. ? @ 0x00007f2681687850
2025-05-14 20:16:03 
2025-05-14 20:16:03 Received exception from server (version 25.5.1):
2025-05-14 20:16:03 Code: 242. DB::Exception: Received from localhost:9000. DB::Exception: Table is in readonly mode (replica path: /test/02922/test_8l10y3wb/table/replicas/1). (TABLE_IS_READ_ONLY)
2025-05-14 20:16:03 (query: system sync replica r1;)
2025-05-14 20:16:03 
2025-05-14 20:16:03 stdout:
2025-05-14 20:16:03 zero_copy:
2025-05-14 20:16:03 <table_shared_id>
2025-05-14 20:16:03 tables:
2025-05-14 20:16:03 table
2025-05-14 20:16:03 zero_copy:
2025-05-14 20:16:03 tables:
2025-05-14 20:16:03 
2025-05-14 20:16:03 /repo/tests/queries/0_stateless/test_8l10y3wb/02922_deduplication_with_zero_copy.sh.debuglog:
2025-05-14 20:16:03 + [2025-05-14 20:15:20] [:11] /usr/bin/clickhouse-client --send_logs_level=warning --database=test_8l10y3wb --log_comment 02922_deduplication_with_zero_copy.sh --max_insert_threads 3 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 0 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 14304844 --max_read_buffer_size 539045 --prefer_localhost_replica 1 --max_block_size 56546 --max_joined_block_size_rows 86581 --max_threads 32 --optimize_append_index 0 --use_hedged_requests 1 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 86 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 44804690 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 1 --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 0 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_expressions 1 --compile_aggregate_expressions 0 --compile_sort_description 0 --merge_tree_coarse_index_granularity 12 --optimize_distinct_in_order 0 --max_bytes_before_remerge_sort 2587848866 --min_compress_block_size 813071 --max_compress_block_size 2741523 --merge_tree_compact_parts_min_granules_to_multibuffer_read 88 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 7307485 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Mexico/BajaSur --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.88 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 0 --cross_join_min_bytes_to_compress 1 --min_external_table_block_size_bytes 1 --max_parsing_threads 0 --optimize_functions_to_subcolumns 0 --parallel_replicas_local_plan 1 --query_plan_join_swap_table false --enable_vertical_final 1 --optimize_extract_common_expressions 1 --use_query_condition_cache 1 --secondary_indices_enable_bulk_filtering 1 --use_skip_indexes_if_final 0 --max_bytes_before_external_sort 0 --max_bytes_before_external_group_by 0 --max_bytes_ratio_before_external_sort 0.2 --max_bytes_ratio_before_external_group_by 0.0 --use_skip_indexes_if_final_exact_mode 0 --allow_merge_tree_settings --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 1 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 6393788675 --index_granularity_bytes 23579773 --merge_max_block_size 17543 --index_granularity 4077 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 83497 --primary_key_compress_block_size 90573 --replace_long_file_name

Metadata

Metadata

Assignees

Labels

flaky testflaky test found by CItestingSpecial issue with list of bugs found by CI

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions