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
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