2024.04.28 18:08:38.259033 [ 545 ] {} Application: Will watch for the process with pid 547 2024.04.28 18:08:38.259208 [ 547 ] {} Application: Forked a child process to watch 2024.04.28 18:08:38.260451 [ 547 ] {} SentryWriter: Sending crash reports is disabled 2024.04.28 18:08:38.260811 [ 547 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.04.28 18:08:38.769273 [ 547 ] {} Application: Starting ClickHouse 23.8.11.29.altinitystable (revision: 54477, git hash: 8e9be16153250c8307730c9b88c8517181f494ce, build id: DFD779D6EB08E43F554D8C84592C8A8B3CA81272), PID 547 2024.04.28 18:08:38.769924 [ 547 ] {} Application: starting up 2024.04.28 18:08:38.769985 [ 547 ] {} Application: OS name: Linux, version: 5.15.0-73-generic, architecture: x86_64 2024.04.28 18:08:38.786575 [ 547 ] {} Context: ThreadFuzzer is enabled. Application will run slowly and unstable. 2024.04.28 18:08:38.786709 [ 547 ] {} Context: Server was built with sanitizer. It will work slowly. 2024.04.28 18:08:38.786800 [ 547 ] {} Application: Available RAM: 30.61 GiB; physical cores: 16; logical cores: 16. 2024.04.28 18:08:38.788749 [ 547 ] {} Context: The setting 'allow_remote_fs_zero_copy_replication' is enabled for MergeTree tables. But the feature of 'zero-copy replication' is under development and is not ready for production. The usage of this feature can lead to data corruption and loss. The setting should be disabled in production. 2024.04.28 18:08:38.790064 [ 547 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2024.04.28 18:08:38.790112 [ 547 ] {} AsynchronousMetrics: Scanning /sys/block 2024.04.28 18:08:38.790282 [ 547 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2024.04.28 18:08:38.790327 [ 547 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2024.04.28 18:08:39.828538 [ 547 ] {} Application: Integrity check of the executable successfully passed (checksum: 47F304DD93EA3AFB2E0C890310B69575) 2024.04.28 18:08:39.830417 [ 547 ] {} Application: Will do mlock to prevent executable memory from being paged out. It may take a few seconds. 2024.04.28 18:08:39.830481 [ 547 ] {} Application: The memory map of clickhouse executable has been mlock'ed, total 439.58 MiB 2024.04.28 18:08:39.832301 [ 547 ] {} Application: Set max number of file descriptors to 1048576 (was 1024). 2024.04.28 18:08:39.832346 [ 547 ] {} Application: rlimit on number of threads is 18446744073709551615 2024.04.28 18:08:39.832378 [ 547 ] {} Application: Initializing DateLUT. 2024.04.28 18:08:39.832400 [ 547 ] {} Application: Initialized DateLUT with time zone 'Europe/Amsterdam'. 2024.04.28 18:08:39.832558 [ 547 ] {} Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it 2024.04.28 18:08:39.833045 [ 547 ] {} TLDListsHolder: public_suffix_list loading from /etc/clickhouse-server/top_level_domains/public_suffix_list.dat 2024.04.28 18:08:39.845221 [ 547 ] {} TLDListsHolder: public_suffix_list was added (9084 hosts) 2024.04.28 18:08:39.845332 [ 547 ] {} TLDListsHolder: no_new_line_list loading from /etc/clickhouse-server/top_level_domains/no_new_line_list.dat 2024.04.28 18:08:39.845558 [ 547 ] {} TLDListsHolder: no_new_line_list was added (1 hosts) 2024.04.28 18:08:39.845829 [ 547 ] {} Context: The setting 'merge_tree_metadata_cache' is enabled. But the feature of 'metadata cache in RocksDB' is experimental and is not ready for production. The usage of this feature can lead to data corruption and loss. The setting should be disabled in production. See the corresponding report at https://github.com/ClickHouse/ClickHouse/issues/51182 2024.04.28 18:08:39.845995 [ 547 ] {} Application: Initializing MergeTree metadata cache, lru_cache_size: 256.00 MiB continue_if_corrupted: true 2024.04.28 18:08:39.867533 [ 547 ] {} Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use '953ace1ecb79' as replica host. 2024.04.28 18:08:39.867653 [ 547 ] {} Application: Initializing interserver credentials. 2024.04.28 18:08:39.868915 [ 547 ] {} SensitiveDataMaskerConfigRead: 1 query masking rules loaded. 2024.04.28 18:08:39.880786 [ 547 ] {} ConfigReloader: Loading config '/etc/clickhouse-server/config.xml' 2024.04.28 18:08:39.960649 [ 547 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/config.xml', performing update on configuration 2024.04.28 18:08:40.079843 [ 547 ] {} Application: Setting max_server_memory_usage was set to 15.31 GiB (30.61 GiB available * 0.50 max_server_memory_usage_to_ram_ratio) 2024.04.28 18:08:40.079919 [ 547 ] {} Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.31 GiB (30.61 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) 2024.04.28 18:08:40.079956 [ 547 ] {} Application: Merges and mutations memory limit is set to 15.31 GiB 2024.04.28 18:08:40.091928 [ 547 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.04.28 18:08:40.097795 [ 547 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.04.28 18:08:40.239398 [ 547 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.04.28 18:08:40.246347 [ 547 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.04.28 18:08:40.252356 [ 547 ] {} CertificateReloader: Reloading certificate (/etc/clickhouse-server/server.crt) and key (/etc/clickhouse-server/server.key). 2024.04.28 18:08:40.253965 [ 547 ] {} CertificateReloader: Reloaded certificate (/etc/clickhouse-server/server.crt) and key (/etc/clickhouse-server/server.key). 2024.04.28 18:08:40.254024 [ 547 ] {} CertificateReloader: Initializing certificate reloader. 2024.04.28 18:08:40.259279 [ 547 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/config.xml', performed update on configuration 2024.04.28 18:08:40.261271 [ 547 ] {} Context: Keeper server is participant of the main zookeeper cluster, will try to connect to it 2024.04.28 18:08:40.263149 [ 547 ] {} Context: Cannot connect to ZooKeeper (or Keeper) before internal Keeper start, will wait for Keeper synchronously 2024.04.28 18:08:40.263234 [ 547 ] {} KeeperDispatcher: Initializing storage dispatcher 2024.04.28 18:08:40.265606 [ 547 ] {} KeeperContext: Keeper feature flag FILTERED_LIST: enabled 2024.04.28 18:08:40.265648 [ 547 ] {} KeeperContext: Keeper feature flag MULTI_READ: enabled 2024.04.28 18:08:40.265675 [ 547 ] {} KeeperContext: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.04.28 18:08:40.265811 [ 547 ] {} KeeperContext: Disk type 'azure_blob_storage' is not supported for Keeper 2024.04.28 18:08:40.265879 [ 547 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:08:40.516792 [ 547 ] {} S3Client: Provider type: Unknown 2024.04.28 18:08:40.516865 [ 547 ] {} S3Client: API mode of the S3 client: AWS 2024.04.28 18:08:40.531656 [ 547 ] {} WriteBufferFromS3: Create WriteBufferFromS3, Details: bucket test, key common/clickhouse_remove_objects_capability_4b734597-e31d-4913-b1a3-9ee79e302605 2024.04.28 18:08:40.531874 [ 547 ] {} WriteBufferFromS3: finalizeImpl WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_4b734597-e31d-4913-b1a3-9ee79e302605. 2024.04.28 18:08:40.534246 [ 764 ] {} HTTPSessionAdapter: Created HTTP(S) session with localhost:11111 (::1:11111) 2024.04.28 18:08:40.537027 [ 764 ] {} WriteBufferFromS3: Single part upload has completed. Details: bucket test, key common/clickhouse_remove_objects_capability_4b734597-e31d-4913-b1a3-9ee79e302605, size 4 2024.04.28 18:08:40.537305 [ 547 ] {} WriteBufferFromS3: Close WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_4b734597-e31d-4913-b1a3-9ee79e302605. 2024.04.28 18:08:40.539763 [ 547 ] {} S3ObjectStorage: Objects with paths [common/clickhouse_remove_objects_capability_4b734597-e31d-4913-b1a3-9ee79e302605] were removed from S3 2024.04.28 18:08:40.552361 [ 547 ] {} S3ObjectStorage: Objects with paths [common/fiy/uqnowogliczhnmfatvvqjxotblrdk] were removed from S3 2024.04.28 18:08:40.552432 [ 547 ] {} DiskObjectStorage(DiskS3): Starting up disk s3_disk 2024.04.28 18:08:40.552471 [ 547 ] {} DiskObjectStorage(DiskS3): Disk s3_disk started up 2024.04.28 18:08:40.552569 [ 547 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:08:40.552623 [ 547 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.04.28 18:08:40.552675 [ 547 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.04.28 18:08:40.552719 [ 547 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.04.28 18:08:40.552759 [ 547 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:08:40.552799 [ 547 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:08:40.552840 [ 547 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:08:40.552888 [ 547 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:08:40.552929 [ 547 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:08:40.553784 [ 547 ] {} KeeperSnapshotManager: Reading from disk LocalSnapshotDisk 2024.04.28 18:08:40.554712 [ 547 ] {} KeeperLogStore: Reading from disk LocalLogDisk 2024.04.28 18:08:40.554789 [ 547 ] {} KeeperLogStore: No logs exists in /var/lib/clickhouse/coordination/logs. It's Ok if it's the first run of clickhouse-keeper. 2024.04.28 18:08:40.555876 [ 547 ] {} KeeperLogStore: force_sync disabled 2024.04.28 18:08:40.555958 [ 547 ] {} KeeperDispatcher: Waiting server to initialize 2024.04.28 18:08:40.555986 [ 547 ] {} KeeperStateMachine: Totally have 0 snapshots 2024.04.28 18:08:40.556009 [ 547 ] {} KeeperStateMachine: No existing snapshots, last committed log index 0 2024.04.28 18:08:40.556260 [ 547 ] {} KeeperLogStore: Removing all changelogs 2024.04.28 18:08:40.556315 [ 547 ] {} Changelog: Starting new changelog changelog_1_100000.bin.zstd 2024.04.28 18:08:40.556455 [ 547 ] {} KeeperServer: Preprocessing 0 log entries 2024.04.28 18:08:40.556483 [ 547 ] {} KeeperServer: Preprocessing done 2024.04.28 18:08:40.556511 [ 547 ] {} KeeperServer: No config in log store and snapshot, probably it's initial run. Will use config from .xml on disk 2024.04.28 18:08:40.557311 [ 547 ] {} KeeperServer: Got 1000000000000000 value for setting 'reserved_log_items' which is bigger than int32_t max value, lowering value to 2147483647. 2024.04.28 18:08:40.562495 [ 547 ] {} RaftInstance: Raft ASIO listener initiated on :::9234, unsecured 2024.04.28 18:08:40.562589 [ 547 ] {} KeeperStateManager: No state was read 2024.04.28 18:08:40.562677 [ 547 ] {} RaftInstance: invalid election timeout lower bound detected, adjusted to 0 2024.04.28 18:08:40.562709 [ 547 ] {} RaftInstance: invalid election timeout upper bound detected, adjusted to 0 2024.04.28 18:08:40.562761 [ 547 ] {} RaftInstance: parameters: election timeout range 0 - 0, heartbeat 0, leadership expiry 0, max batch 100, backoff 50, snapshot distance 10000, enable randomized snapshot creation NO, log sync stop gap 99999, reserved logs 2147483647, client timeout 10000, auto forwarding on, API call type async, custom commit quorum size 0, custom election quorum size 0, snapshot receiver included, leadership transfer wait time 0, grace period of lagging state machine 0, snapshot IO: blocking, parallel log appending: on 2024.04.28 18:08:40.562805 [ 547 ] {} RaftInstance: new election timeout range: 0 - 0 2024.04.28 18:08:40.562909 [ 547 ] {} RaftInstance: === INIT RAFT SERVER === commit index 0 term 0 election timer allowed log store start 1, end 0 config log idx 0, prev log idx 0 2024.04.28 18:08:40.562974 [ 547 ] {} RaftInstance: peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 2024.04.28 18:08:40.563027 [ 547 ] {} RaftInstance: global manager does not exist. will use local thread for commit and append 2024.04.28 18:08:40.563515 [ 547 ] {} RaftInstance: wait for HB, for 50 + [0, 0] ms 2024.04.28 18:08:40.563544 [ 785 ] {} RaftInstance: bg append_entries thread initiated 2024.04.28 18:08:40.614044 [ 768 ] {} RaftInstance: Election timeout, initiate leader election 2024.04.28 18:08:40.614270 [ 768 ] {} RaftInstance: [PRIORITY] decay, target 1 -> 1, mine 1 2024.04.28 18:08:40.614454 [ 768 ] {} RaftInstance: [ELECTION TIMEOUT] current role: follower, log last term 0, state term 0, target p 1, my p 1, hb dead, pre-vote NOT done 2024.04.28 18:08:40.614962 [ 547 ] {} KeeperDispatcher: Server initialized, waiting for quorum 2024.04.28 18:08:40.716273 [ 768 ] {} RaftInstance: [VOTE INIT] my id 1, my role candidate, term 1, log idx 0, log term 0, priority (target 1 / mine 1) 2024.04.28 18:08:40.716379 [ 768 ] {} RaftInstance: number of pending commit elements: 0 2024.04.28 18:08:40.716432 [ 768 ] {} RaftInstance: state machine commit index 0, precommit index 0, last log index 0 2024.04.28 18:08:40.716508 [ 768 ] {} RaftInstance: [BECOME LEADER] appended new config at 1 2024.04.28 18:08:40.718737 [ 784 ] {} RaftInstance: config at index 1 is committed, prev config log idx 0 2024.04.28 18:08:40.718959 [ 784 ] {} RaftInstance: new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 2024.04.28 18:08:40.719047 [ 784 ] {} RaftInstance: new configuration: log idx 1, prev log idx 0 peer 1, DC ID 0, localhost:9234, voting member, 1 my id: 1, leader: 1, term: 1 2024.04.28 18:08:40.719225 [ 547 ] {} KeeperDispatcher: Quorum initialized 2024.04.28 18:08:40.719935 [ 547 ] {} KeeperDispatcher: Dispatcher initialized 2024.04.28 18:08:40.721395 [ 547 ] {} Application: Listening for Keeper (tcp): [::]:9181 2024.04.28 18:08:40.721769 [ 547 ] {} Application: Listening for replica communication (interserver): http://[::]:9009 2024.04.28 18:08:40.835033 [ 547 ] {} ConfigReloader: Loading config '/etc/clickhouse-server/users.xml' 2024.04.28 18:08:40.849649 [ 547 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performing update on configuration 2024.04.28 18:08:41.060280 [ 547 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performed update on configuration 2024.04.28 18:08:41.063246 [ 547 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /etc/clickhouse-server/users.xml 2024.04.28 18:08:41.063559 [ 547 ] {} Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist 2024.04.28 18:08:41.063613 [ 547 ] {} Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/ 2024.04.28 18:08:41.064625 [ 547 ] {} Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/ 2024.04.28 18:08:41.070426 [ 547 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.04.28 18:08:41.073828 [ 547 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.04.28 18:08:41.076706 [ 547 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.04.28 18:08:41.079274 [ 547 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.04.28 18:08:41.085039 [ 547 ] {} DNSCacheUpdater: Update period 15 seconds 2024.04.28 18:08:41.085184 [ 547 ] {} Application: Loading metadata from /var/lib/clickhouse/ 2024.04.28 18:08:41.085354 [ 607 ] {} DNSResolver: Updating DNS cache 2024.04.28 18:08:41.086162 [ 607 ] {} DNSResolver: Updated DNS cache 2024.04.28 18:08:41.087126 [ 547 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.04.28 18:08:41.087178 [ 547 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000163266 sec 2024.04.28 18:08:41.087211 [ 547 ] {} ReferentialDeps: No tables 2024.04.28 18:08:41.087242 [ 547 ] {} LoadingDeps: No tables 2024.04.28 18:08:41.087368 [ 547 ] {} DatabaseAtomic (system): Starting up tables. 2024.04.28 18:08:41.087460 [ 547 ] {} SystemLog: Creating system.query_log from query_log 2024.04.28 18:08:41.236299 [ 547 ] {} SystemLog: Creating system.query_thread_log from query_thread_log 2024.04.28 18:08:41.239137 [ 547 ] {} SystemLog: Creating system.part_log from part_log 2024.04.28 18:08:41.241505 [ 547 ] {} SystemLog: Creating system.trace_log from trace_log 2024.04.28 18:08:41.243014 [ 547 ] {} SystemLog: Creating system.crash_log from crash_log 2024.04.28 18:08:41.244050 [ 547 ] {} SystemLog: Creating system.text_log from text_log 2024.04.28 18:08:41.245875 [ 547 ] {} SystemLog: Creating system.metric_log from metric_log 2024.04.28 18:08:41.367809 [ 547 ] {} SystemLog: Creating system.filesystem_cache_log from filesystem_cache_log 2024.04.28 18:08:41.369714 [ 547 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.04.28 18:08:41.369789 [ 547 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2024.04.28 18:08:41.371448 [ 547 ] {} SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log 2024.04.28 18:08:41.373483 [ 547 ] {} SystemLog: Creating system.query_views_log from query_views_log 2024.04.28 18:08:41.375626 [ 547 ] {} SystemLog: Creating system.zookeeper_log from zookeeper_log 2024.04.28 18:08:41.379858 [ 547 ] {} SystemLog: Creating system.session_log from session_log 2024.04.28 18:08:41.382568 [ 547 ] {} SystemLog: Creating system.transactions_info_log from transactions_info_log 2024.04.28 18:08:41.384457 [ 547 ] {} SystemLog: Creating system.processors_profile_log from processors_profile_log 2024.04.28 18:08:41.386099 [ 547 ] {} SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log 2024.04.28 18:08:41.388190 [ 547 ] {} Context: Table system.session_log is enabled. It's unreliable and may contain garbage. Do not use it for any kind of security monitoring. 2024.04.28 18:08:41.707441 [ 547 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.04.28 18:08:41.708490 [ 547 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.04.28 18:08:41.708547 [ 547 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00014882 sec 2024.04.28 18:08:41.708590 [ 547 ] {} ReferentialDeps: No tables 2024.04.28 18:08:41.708621 [ 547 ] {} LoadingDeps: No tables 2024.04.28 18:08:41.708723 [ 547 ] {} DatabaseAtomic (default): Starting up tables. 2024.04.28 18:08:41.709062 [ 547 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/ 2024.04.28 18:08:41.709410 [ 547 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.04.28 18:08:41.709447 [ 547 ] {} Application: Loaded metadata. 2024.04.28 18:08:41.709476 [ 547 ] {} Application: Query Profiler disabled because they cannot work under sanitizers when two different stack unwinding methods will interfere with each other. 2024.04.28 18:08:41.709506 [ 547 ] {} Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). 2024.04.28 18:08:41.709827 [ 547 ] {} bool DB::(anonymous namespace)::checkPermissionsImpl(): Code: 412. DB::Exception: Can't receive Netlink response: error -2. (NETLINK_ERROR) (version 23.8.11.29.altinitystable (altinity build)) 2024.04.28 18:08:41.709889 [ 547 ] {} Application: Tasks stats provider: procfs 2024.04.28 18:08:41.713746 [ 547 ] {} AsynchronousMetrics: MemoryTracking: was 4.01 MiB, peak 5.01 MiB, free memory in arenas 0.00 B, will set to 1.70 GiB (RSS), difference: 1.69 GiB 2024.04.28 18:08:41.713815 [ 547 ] {} MemoryTracker: Current memory usage (total): 1.70 GiB. 2024.04.28 18:08:41.755920 [ 623 ] {} WriteBufferFromAzureBlobStorage: Staged block (id: xadcrthkgakeztmoahahaagpmydodndsbyylfkofpyqlwqgrocnwasmsscspgqfp) of size 4 (blob path: evfivqbvjmdslkdbaiykdmveyoiupacz). 2024.04.28 18:08:41.768699 [ 623 ] {} WriteBufferFromAzureBlobStorage: Committed 1 blocks for blob `evfivqbvjmdslkdbaiykdmveyoiupacz` 2024.04.28 18:08:41.795471 [ 623 ] {} DiskObjectStorage(DiskAzureBlobStorage): Starting up disk azure 2024.04.28 18:08:41.795555 [ 623 ] {} DiskObjectStorage(DiskAzureBlobStorage): Disk azure started up 2024.04.28 18:08:41.797612 [ 623 ] {} DiskCache: Registered cached disk (`cached_azure`) with structure: DiskObjectStorage-azure(CachedObjectStorage-cached_azure(AzureObjectStorage)) 2024.04.28 18:08:41.913344 [ 623 ] {} S3Client: Provider type: Unknown 2024.04.28 18:08:41.913409 [ 623 ] {} S3Client: API mode of the S3 client: AWS 2024.04.28 18:08:42.040403 [ 623 ] {} S3ObjectStorage: Objects with paths [common/clickhouse_remove_objects_capability_4b734597-e31d-4913-b1a3-9ee79e302605] were removed from S3 2024.04.28 18:08:42.156937 [ 623 ] {} S3ObjectStorage: Objects with paths [common/pct/nvlzekfgpksejxzisepizzjlsrlzf] were removed from S3 2024.04.28 18:08:42.157045 [ 623 ] {} DiskObjectStorage(DiskS3): Starting up disk s3_disk 2024.04.28 18:08:42.157092 [ 623 ] {} DiskObjectStorage(DiskS3): Disk s3_disk started up 2024.04.28 18:08:42.158768 [ 623 ] {} DiskCache: Registered cached disk (`s3_cache`) with structure: DiskObjectStorage-s3_disk(CachedObjectStorage-s3_cache(S3ObjectStorage)) 2024.04.28 18:08:42.161120 [ 623 ] {} DiskObjectStorage(Local): Starting up disk local_disk 2024.04.28 18:08:42.161168 [ 623 ] {} DiskObjectStorage(Local): Disk local_disk started up 2024.04.28 18:08:42.163292 [ 623 ] {} DiskObjectStorage(Local): Starting up disk local_disk_2 2024.04.28 18:08:42.163330 [ 623 ] {} DiskObjectStorage(Local): Disk local_disk_2 started up 2024.04.28 18:08:42.165806 [ 623 ] {} DiskObjectStorage(Local): Starting up disk local_disk_3 2024.04.28 18:08:42.165847 [ 623 ] {} DiskObjectStorage(Local): Disk local_disk_3 started up 2024.04.28 18:08:42.167310 [ 623 ] {} DiskCache: Registered cached disk (`local_cache`) with structure: DiskObjectStorage-local_disk(CachedObjectStorage-local_cache(LocalObjectStorage)) 2024.04.28 18:08:42.169001 [ 623 ] {} DiskCache: Registered cached disk (`local_cache_2`) with structure: DiskObjectStorage-local_disk(CachedObjectStorage-local_cache_2(LocalObjectStorage)) 2024.04.28 18:08:42.170798 [ 623 ] {} DiskCache: Registered cached disk (`local_cache_3`) with structure: DiskObjectStorage-local_disk_3(CachedObjectStorage-local_cache_3(LocalObjectStorage)) 2024.04.28 18:08:42.172480 [ 623 ] {} DiskCache: Registered cached disk (`s3_cache_multi`) with structure: DiskObjectStorage-s3_disk(CachedObjectStorage-s3_cache_multi(CachedObjectStorage-s3_cache(S3ObjectStorage))) 2024.04.28 18:08:42.174439 [ 623 ] {} DiskCache: Registered cached disk (`s3_cache_multi_2`) with structure: DiskObjectStorage-s3_disk(CachedObjectStorage-s3_cache_multi_2(CachedObjectStorage-s3_cache_multi(CachedObjectStorage-s3_cache(S3ObjectStorage)))) 2024.04.28 18:08:42.175201 [ 623 ] {} DatabaseCatalog: Execution took 466 ms. 2024.04.28 18:08:42.176593 [ 547 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 0.000289813 sec. 2024.04.28 18:08:42.180722 [ 547 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/decimals_dictionary.xml'. 2024.04.28 18:08:42.500215 [ 547 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/executable_dictionary.xml'. 2024.04.28 18:08:42.519444 [ 547 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/executable_pool_dictionary.xml'. 2024.04.28 18:08:42.534766 [ 547 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/ints_dictionary.xml'. 2024.04.28 18:08:42.657479 [ 547 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/strings_dictionary.xml'. 2024.04.28 18:08:42.673137 [ 547 ] {} ExternalUserDefinedExecutableFunctionsLoader: Loading config file '/etc/clickhouse-server/test_function.xml'. 2024.04.28 18:08:42.683543 [ 547 ] {} ExternalUserDefinedExecutableFunctionsLoader: Will load 'test_function' because always_load_everything flag is set. 2024.04.28 18:08:42.683604 [ 547 ] {} ExternalUserDefinedExecutableFunctionsLoader: Will load the object 'test_function' immediately, force = false, loading_id = 1 2024.04.28 18:08:42.683632 [ 547 ] {} ExternalUserDefinedExecutableFunctionsLoader: Start loading object 'test_function' 2024.04.28 18:08:42.683881 [ 547 ] {} ExternalUserDefinedExecutableFunctionsLoader: Supposed update time for 'test_function' is never (loaded, lifetime 0) 2024.04.28 18:08:42.683949 [ 547 ] {} ExternalUserDefinedExecutableFunctionsLoader: Next update time for 'test_function' was set to 294247-01-10 05:00:54 2024.04.28 18:08:42.684981 [ 894 ] {} DDLWorker: Starting DDLWorker thread 2024.04.28 18:08:42.684996 [ 895 ] {} DDLWorker: Started DDLWorker cleanup thread 2024.04.28 18:08:42.685104 [ 547 ] {} Application: Listening for http://[::]:8123 2024.04.28 18:08:42.685134 [ 894 ] {} DDLWorker: Initializing DDLWorker thread 2024.04.28 18:08:42.685696 [ 547 ] {} Application: Listening for https://[::]:8443 2024.04.28 18:08:42.685939 [ 547 ] {} Application: Listening for native protocol (tcp): [::]:9000 2024.04.28 18:08:42.686184 [ 551 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58608 2024.04.28 18:08:42.686545 [ 547 ] {} Application: Listening for native protocol (tcp) with PROXY: [::]:9010 2024.04.28 18:08:42.687032 [ 551 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.04.28 18:08:42.687097 [ 547 ] {} Application: Listening for secure native protocol (tcp_secure): [::]:9440 2024.04.28 18:08:42.687217 [ 551 ] {} TCP-Session: bb3fe047-64e7-47af-b473-089e44690d31 Authenticating user 'default' from [::1]:58608 2024.04.28 18:08:42.687201 [ 552 ] {} KeeperTCPHandlerFactory: Keeper request. Address: [::1]:52828 2024.04.28 18:08:42.687334 [ 551 ] {} TCP-Session: bb3fe047-64e7-47af-b473-089e44690d31 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:08:42.687512 [ 551 ] {} TCP-Session: bb3fe047-64e7-47af-b473-089e44690d31 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:08:42.687555 [ 547 ] {} Application: Listening for MySQL compatibility protocol: [::]:9004 2024.04.28 18:08:42.688140 [ 547 ] {} Application: Listening for PostgreSQL compatibility protocol: [::]:9005 2024.04.28 18:08:42.688197 [ 552 ] {} KeeperTCPHandler: Requesting session ID for the new client 2024.04.28 18:08:42.688396 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:08:42.688580 [ 547 ] {} Application: Listening for Prometheus: http://[::]:9988 2024.04.28 18:08:42.688870 [ 551 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.04.28 18:08:42.688942 [ 551 ] {} ContextAccess (default): List of all grants: GRANT ALL ON *.* WITH GRANT OPTION 2024.04.28 18:08:42.689087 [ 784 ] {} KeeperStateMachine: Session ID response 1 with timeout 30000 2024.04.28 18:08:42.689097 [ 551 ] {} ContextAccess (default): List of all grants including implicit: GRANT ALL ON *.* WITH GRANT OPTION 2024.04.28 18:08:42.689297 [ 552 ] {} KeeperTCPHandler: Received session ID 1 2024.04.28 18:08:42.689457 [ 894 ] {} ZooKeeperClient: Connected to ZooKeeper at [::1]:9181 with session_id 1 2024.04.28 18:08:42.691045 [ 894 ] {} ZooKeeperClient: Keeper feature flag FILTERED_LIST: enabled 2024.04.28 18:08:42.691091 [ 894 ] {} ZooKeeperClient: Keeper feature flag MULTI_READ: enabled 2024.04.28 18:08:42.691120 [ 894 ] {} ZooKeeperClient: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.04.28 18:08:42.691182 [ 894 ] {} ZooKeeper: Initialized, hosts: localhost:9181 2024.04.28 18:08:42.691263 [ 547 ] {} ZooKeeperClient: ZK send fault: 0.002% 2024.04.28 18:08:42.691311 [ 547 ] {} ZooKeeperClient: ZK recv fault: 0.002% 2024.04.28 18:08:42.691343 [ 547 ] {} ZooKeeperClient: ZK send sleep: 0.001% -> 10000ms 2024.04.28 18:08:42.691362 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 1 2024.04.28 18:08:42.691373 [ 547 ] {} Application: Ready for connections. 2024.04.28 18:08:42.691874 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.04.28 18:08:42.692760 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 85 2024.04.28 18:08:42.693520 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 74 2024.04.28 18:08:42.694302 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 85 2024.04.28 18:08:42.695094 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.04.28 18:08:42.695720 [ 894 ] {} DDLWorker: Initialized DDLWorker thread 2024.04.28 18:08:42.695776 [ 894 ] {} DDLWorker: Scheduling tasks 2024.04.28 18:08:42.695807 [ 894 ] {} DDLWorker: Don't have unfinished tasks after restarting 2024.04.28 18:08:42.695842 [ 895 ] {} DDLWorker: Cleaning queue 2024.04.28 18:08:42.696361 [ 894 ] {} DDLWorker: scheduleTasks: initialized=true, size_before_filtering=0, queue_size=0, entries=none..none, first_failed_task_name=none, current_tasks_size=0, last_current_task=none, last_skipped_entry_name=none 2024.04.28 18:08:42.696413 [ 894 ] {} DDLWorker: No tasks to schedule 2024.04.28 18:08:42.696450 [ 894 ] {} DDLWorker: Waiting for queue updates 2024.04.28 18:08:42.719654 [ 551 ] {} TCP-Session: bb3fe047-64e7-47af-b473-089e44690d31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.04.28 18:08:42.720396 [ 551 ] {14a4c0f5-a444-4e7c-bbaf-c78fd2a120a3} executeQuery: (from [::1]:58608) SELECT 1 (stage: Complete) 2024.04.28 18:08:42.721239 [ 551 ] {14a4c0f5-a444-4e7c-bbaf-c78fd2a120a3} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.04.28 18:08:42.721449 [ 551 ] {14a4c0f5-a444-4e7c-bbaf-c78fd2a120a3} InterpreterSelectQuery: FetchColumns -> Complete 2024.04.28 18:08:42.737102 [ 551 ] {14a4c0f5-a444-4e7c-bbaf-c78fd2a120a3} executeQuery: Read 1 rows, 1.00 B in 0.016645 sec., 60.07810153199159 rows/sec., 60.08 B/sec. 2024.04.28 18:08:42.737569 [ 551 ] {14a4c0f5-a444-4e7c-bbaf-c78fd2a120a3} TCPHandler: Processed in 0.018409801 sec. 2024.04.28 18:08:42.791746 [ 551 ] {} TCPHandler: Done processing connection. 2024.04.28 18:08:42.792181 [ 551 ] {} TCP-Session: bb3fe047-64e7-47af-b473-089e44690d31 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:09:33.091498 [ 552 ] {} KeeperTCPHandler: Session #1 expired 2024.04.28 18:09:33.092950 [ 732 ] {} DNSResolver: Updating DNS cache 2024.04.28 18:09:33.093479 [ 786 ] {} KeeperDispatcher: Found dead session 1, will try to close it 2024.04.28 18:09:33.093659 [ 732 ] {} DNSResolver: Updated DNS cache 2024.04.28 18:09:33.093714 [ 786 ] {} KeeperDispatcher: Dead session close request pushed 2024.04.28 18:09:33.093741 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:09:33.094169 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 132 entries to flush up to offset 132 2024.04.28 18:09:33.094295 [ 860 ] {} SystemLog (system.zookeeper_log): Flushing system log, 18 entries to flush up to offset 18 2024.04.28 18:09:33.094089 [ 850 ] {} SystemLog (system.metric_log): Flushing system log, 2 entries to flush up to offset 2 2024.04.28 18:09:33.094556 [ 551 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58610 2024.04.28 18:09:33.094836 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog 2024.04.28 18:09:33.094184 [ 855 ] {} SystemLog (system.text_log): Flushing system log, 260 entries to flush up to offset 260 2024.04.28 18:09:33.094931 [ 860 ] {} SystemLog (system.zookeeper_log): Creating new table system.zookeeper_log for ZooKeeperLog 2024.04.28 18:09:33.094176 [ 856 ] {} SystemLog (system.query_log): Flushing system log, 2 entries to flush up to offset 2 2024.04.28 18:09:33.094913 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.69 GiB, peak 1.73 GiB, free memory in arenas 0.00 B, will set to 1.82 GiB (RSS), difference: 126.26 MiB 2024.04.28 18:09:33.095360 [ 850 ] {} SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog 2024.04.28 18:09:33.095341 [ 856 ] {} SystemLog (system.query_log): Creating new table system.query_log for QueryLog 2024.04.28 18:09:33.095586 [ 551 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.04.28 18:09:33.095417 [ 855 ] {} SystemLog (system.text_log): Creating new table system.text_log for TextLog 2024.04.28 18:09:33.095796 [ 551 ] {} TCP-Session: 6fa34e4f-2b2b-4f68-9e95-f45299d7913d Authenticating user 'default' from [::1]:58610 2024.04.28 18:09:33.095983 [ 551 ] {} TCP-Session: 6fa34e4f-2b2b-4f68-9e95-f45299d7913d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:09:33.096240 [ 551 ] {} TCP-Session: 6fa34e4f-2b2b-4f68-9e95-f45299d7913d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:09:33.111263 [ 851 ] {} StoragePolicy (azure_cache): Storage policy azure_cache created, total volumes 1 2024.04.28 18:09:33.111435 [ 851 ] {} StoragePolicySelector: Storage policy `azure_cache` loaded 2024.04.28 18:09:33.112008 [ 851 ] {} StoragePolicy (s3_cache): Storage policy s3_cache created, total volumes 1 2024.04.28 18:09:33.112088 [ 851 ] {} StoragePolicySelector: Storage policy `s3_cache` loaded 2024.04.28 18:09:33.113097 [ 851 ] {} StoragePolicy (s3_cache_multi): Storage policy s3_cache_multi created, total volumes 1 2024.04.28 18:09:33.113164 [ 851 ] {} StoragePolicySelector: Storage policy `s3_cache_multi` loaded 2024.04.28 18:09:33.113628 [ 851 ] {} StoragePolicy (local_cache): Storage policy local_cache created, total volumes 1 2024.04.28 18:09:33.113682 [ 851 ] {} StoragePolicySelector: Storage policy `local_cache` loaded 2024.04.28 18:09:33.114096 [ 851 ] {} StoragePolicy (local_cache_2): Storage policy local_cache_2 created, total volumes 1 2024.04.28 18:09:33.114141 [ 851 ] {} StoragePolicySelector: Storage policy `local_cache_2` loaded 2024.04.28 18:09:33.114551 [ 851 ] {} StoragePolicy (local_cache_3): Storage policy local_cache_3 created, total volumes 1 2024.04.28 18:09:33.114620 [ 851 ] {} StoragePolicySelector: Storage policy `local_cache_3` loaded 2024.04.28 18:09:33.114737 [ 851 ] {} StoragePolicy (default): Storage policy default created, total volumes 1 2024.04.28 18:09:33.115838 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Loading data parts 2024.04.28 18:09:33.116070 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Loading data parts 2024.04.28 18:09:33.118966 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): There are no data parts 2024.04.28 18:09:33.118970 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): There are no data parts 2024.04.28 18:09:33.127078 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:33.127216 [ 851 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.88 GiB. 2024.04.28 18:09:33.132305 [ 851 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:09:33.132658 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:33.132819 [ 855 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.88 GiB. 2024.04.28 18:09:33.133432 [ 551 ] {} TCP-Session: 6fa34e4f-2b2b-4f68-9e95-f45299d7913d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.04.28 18:09:33.134259 [ 551 ] {89e18aa6-1231-4285-a46c-07ee49f07d1e} executeQuery: (from [::1]:58610) SELECT 'Connected to clickhouse-server after attaching gdb' (stage: Complete) 2024.04.28 18:09:33.135263 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Renaming temporary part tmp_insert_202404_1_1_0 to 202404_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:33.135279 [ 551 ] {89e18aa6-1231-4285-a46c-07ee49f07d1e} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.04.28 18:09:33.135562 [ 551 ] {89e18aa6-1231-4285-a46c-07ee49f07d1e} InterpreterSelectQuery: FetchColumns -> Complete 2024.04.28 18:09:33.138052 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 132 2024.04.28 18:09:33.138709 [ 551 ] {89e18aa6-1231-4285-a46c-07ee49f07d1e} executeQuery: Read 1 rows, 1.00 B in 0.004435 sec., 225.47914317925594 rows/sec., 225.48 B/sec. 2024.04.28 18:09:33.139011 [ 551 ] {89e18aa6-1231-4285-a46c-07ee49f07d1e} TCPHandler: Processed in 0.006206086 sec. 2024.04.28 18:09:33.141697 [ 855 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:09:33.144700 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_insert_202404_1_1_0 to 202404_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:33.146514 [ 855 ] {} SystemLog (system.text_log): Flushed system log up to offset 260 2024.04.28 18:09:33.181382 [ 551 ] {} TCPHandler: Done processing connection. 2024.04.28 18:09:33.181888 [ 551 ] {} TCP-Session: 6fa34e4f-2b2b-4f68-9e95-f45299d7913d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:09:33.210363 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Loading data parts 2024.04.28 18:09:33.211061 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): There are no data parts 2024.04.28 18:09:33.220321 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:33.220424 [ 860 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.88 GiB. 2024.04.28 18:09:33.225265 [ 860 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:09:33.228563 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Renaming temporary part tmp_insert_202404_1_1_0 to 202404_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:33.230194 [ 860 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 18 2024.04.28 18:09:33.237430 [ 856 ] {} system.query_log (f61bb234-b325-4c97-bf3f-90f9b9249d77): Loading data parts 2024.04.28 18:09:33.238067 [ 856 ] {} system.query_log (f61bb234-b325-4c97-bf3f-90f9b9249d77): There are no data parts 2024.04.28 18:09:33.260248 [ 856 ] {} system.query_log (f61bb234-b325-4c97-bf3f-90f9b9249d77): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:33.260374 [ 856 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.88 GiB. 2024.04.28 18:09:33.275980 [ 856 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:09:33.280605 [ 856 ] {} system.query_log (f61bb234-b325-4c97-bf3f-90f9b9249d77): Renaming temporary part tmp_insert_202404_1_1_0 to 202404_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:33.283516 [ 856 ] {} SystemLog (system.query_log): Flushed system log up to offset 2 2024.04.28 18:09:33.287951 [ 905 ] {} ZooKeeperClient: Code: 33. DB::Exception: Cannot read all data. Bytes read: 0. Bytes expected: 4. (CANNOT_READ_ALL_DATA), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x000000001f5f9e63 in /usr/bin/clickhouse 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000f9c9cb4 in /usr/bin/clickhouse 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, unsigned long&, String&&) @ 0x0000000007fbb2d0 in /usr/bin/clickhouse 3. DB::ReadBuffer::readStrict(char*, unsigned long) @ 0x0000000007fbb175 in /usr/bin/clickhouse 4. ./build_docker/./src/IO/ReadHelpers.h:0: Coordination::ZooKeeper::receiveEvent() @ 0x000000001b8f37b8 in /usr/bin/clickhouse 5. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: Coordination::ZooKeeper::receiveThread() @ 0x000000001b8f3084 in /usr/bin/clickhouse 6. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_1>(Coordination::ZooKeeper::ZooKeeper(std::vector> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_1&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000001b8f9dcb in /usr/bin/clickhouse 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x000000000fb060a7 in /usr/bin/clickhouse 8. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000fb0c252 in /usr/bin/clickhouse 9. __tsan_thread_start_func @ 0x0000000007bf022f in /usr/bin/clickhouse 10. ? @ 0x00007f717c9baac3 in ? 11. ? @ 0x00007f717ca4c850 in ? (version 23.8.11.29.altinitystable (altinity build)) 2024.04.28 18:09:33.288135 [ 905 ] {} ZooKeeperClient: Finalizing session 1. finalization_started: false, queue_finished: false, reason: 'Exception in receiveThread' 2024.04.28 18:09:33.373309 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Loading data parts 2024.04.28 18:09:33.373800 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): There are no data parts 2024.04.28 18:09:33.528681 [ 904 ] {} ZooKeeperClient: Code: 210. DB::NetException: I/O error: Broken pipe, while writing to socket ([::1]:52828 -> [::1]:9181). (NETWORK_ERROR), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x000000001f5f9e63 in /usr/bin/clickhouse 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000f9c9cb4 in /usr/bin/clickhouse 2. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::NetException::NetException(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type>, String&&, String&&, String&&) @ 0x000000000fd0876d in /usr/bin/clickhouse 3. ./build_docker/./src/IO/WriteBufferFromPocoSocket.cpp:0: DB::WriteBufferFromPocoSocket::nextImpl() @ 0x000000000fd07c71 in /usr/bin/clickhouse 4. ./build_docker/./src/IO/WriteBuffer.h:60: Coordination::ZooKeeperRequest::write(DB::WriteBuffer&) const @ 0x000000001b8c821c in /usr/bin/clickhouse 5. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:442: Coordination::ZooKeeper::sendThread() @ 0x000000001b8f2307 in /usr/bin/clickhouse 6. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_0>(Coordination::ZooKeeper::ZooKeeper(std::vector> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_0&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000001b8f9b0b in /usr/bin/clickhouse 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x000000000fb060a7 in /usr/bin/clickhouse 8. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000fb0c252 in /usr/bin/clickhouse 9. __tsan_thread_start_func @ 0x0000000007bf022f in /usr/bin/clickhouse 10. ? @ 0x00007f717c9baac3 in ? 11. ? @ 0x00007f717ca4c850 in ? (version 23.8.11.29.altinitystable (altinity build)) 2024.04.28 18:09:33.810136 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:33.810267 [ 850 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.88 GiB. 2024.04.28 18:09:33.891213 [ 905 ] {} ZooKeeperClient: Poco::Exception. Code: 1000, e.code() = 107, Net Exception: Socket is not connected, Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x000000001f5f9e63 in /usr/bin/clickhouse 1. ./build_docker/./base/poco/Foundation/src/Exception.cpp:164: Poco::IOException::IOException(String const&, int) @ 0x000000001f605e0a in /usr/bin/clickhouse 2. ./build_docker/./base/poco/Net/src/NetException.cpp:26: Poco::Net::NetException::NetException(String const&, int) @ 0x000000001f411f2a in /usr/bin/clickhouse 3. ./build_docker/./base/poco/Net/src/SocketImpl.cpp:995: Poco::Net::SocketImpl::error(int, String const&) @ 0x000000001f423021 in /usr/bin/clickhouse 4. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: Poco::Net::SocketImpl::shutdown() @ 0x000000001f424fc5 in /usr/bin/clickhouse 5. ./build_docker/./base/poco/Net/src/StreamSocket.cpp:109: Poco::Net::StreamSocket::shutdown() @ 0x000000001f42ac70 in /usr/bin/clickhouse 6. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:965: Coordination::ZooKeeper::finalize(bool, bool, String const&) @ 0x000000001b8eb0e6 in /usr/bin/clickhouse 7. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: Coordination::ZooKeeper::receiveThread() @ 0x000000001b8f3575 in /usr/bin/clickhouse 8. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_1>(Coordination::ZooKeeper::ZooKeeper(std::vector> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_1&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000001b8f9dcb in /usr/bin/clickhouse 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x000000000fb060a7 in /usr/bin/clickhouse 10. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000fb0c252 in /usr/bin/clickhouse 11. __tsan_thread_start_func @ 0x0000000007bf022f in /usr/bin/clickhouse 12. ? @ 0x00007f717c9baac3 in ? 13. ? @ 0x00007f717ca4c850 in ? (version 23.8.11.29.altinitystable (altinity build)) 2024.04.28 18:09:33.891437 [ 894 ] {} DDLWorker: Scheduling tasks 2024.04.28 18:09:33.891495 [ 895 ] {} DDLWorker: Too early to clean queue, will do it later. 2024.04.28 18:09:33.983499 [ 850 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:09:34.000174 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.82 GiB, peak 1.83 GiB, free memory in arenas 0.00 B, will set to 1.92 GiB (RSS), difference: 103.39 MiB 2024.04.28 18:09:34.128766 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Renaming temporary part tmp_insert_202404_1_1_0 to 202404_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:34.146135 [ 850 ] {} SystemLog (system.metric_log): Flushed system log up to offset 2 2024.04.28 18:09:34.176620 [ 894 ] {} DDLWorker: Lost ZooKeeper connection, will try to connect again: Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x000000001f5f9e63 in /usr/bin/clickhouse 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000f9c9cb4 in /usr/bin/clickhouse 2. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(int, char const (&) [16]) @ 0x000000000f9bed26 in /usr/bin/clickhouse 3. ./build_docker/./src/Common/ZooKeeper/IKeeper.h:470: Coordination::Exception Coordination::Exception::fromMessage(Coordination::Error, char const (&) [16]) @ 0x000000001b8b4c70 in /usr/bin/clickhouse 4. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: Coordination::ZooKeeper::pushRequest(Coordination::ZooKeeper::RequestInfo&&) @ 0x000000001b8f5302 in /usr/bin/clickhouse 5. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:1325: Coordination::ZooKeeper::list(String const&, Coordination::ListRequestType, std::function, std::shared_ptr>) @ 0x000000001b8f84c8 in /usr/bin/clickhouse 6. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:818: zkutil::ZooKeeper::asyncTryGetChildrenNoThrow(String const&, std::shared_ptr>, Coordination::ListRequestType) @ 0x000000001b882f95 in /usr/bin/clickhouse 7. ./build_docker/./src/Common/ZooKeeper/ZooKeeper.cpp:219: zkutil::ZooKeeper::getChildrenImpl(String const&, std::vector>&, Coordination::Stat*, std::shared_ptr>, Coordination::ListRequestType) @ 0x000000001b882975 in /usr/bin/clickhouse 8. ./build_docker/./src/Common/ZooKeeper/ZooKeeper.cpp:0: zkutil::ZooKeeper::tryGetChildrenWatch(String const&, std::vector>&, Coordination::Stat*, std::shared_ptr>, Coordination::ListRequestType) @ 0x000000001b883a14 in /usr/bin/clickhouse 9. ./build_docker/./src/Common/ZooKeeper/ZooKeeper.cpp:266: zkutil::ZooKeeper::tryGetChildren(String const&, std::vector>&, Coordination::Stat*, std::shared_ptr const&, Coordination::ListRequestType) @ 0x000000001b8833d4 in /usr/bin/clickhouse 10. ./build_docker/./src/Common/ZooKeeper/ZooKeeper.cpp:241: zkutil::ZooKeeper::getChildren(String const&, Coordination::Stat*, std::shared_ptr const&, Coordination::ListRequestType) @ 0x000000001b8831d4 in /usr/bin/clickhouse 11. ./build_docker/./contrib/llvm-project/libcxx/include/vector:537: DB::DDLWorker::scheduleTasks(bool) @ 0x00000000189a2ecd in /usr/bin/clickhouse 12. ./build_docker/./src/Interpreters/DDLWorker.cpp:0: DB::DDLWorker::runMainThread() @ 0x000000001899e5ea in /usr/bin/clickhouse 13. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/invoke.h:0: ThreadFromGlobalPoolImpl::ThreadFromGlobalPoolImpl(void (DB::DDLWorker::*&&)(), DB::DDLWorker*&&)::'lambda'()::operator()() @ 0x00000000189b70a0 in /usr/bin/clickhouse 14. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:717: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl(void (DB::DDLWorker::*&&)(), DB::DDLWorker*&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x00000000189b6fe2 in /usr/bin/clickhouse 15. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x000000000fb060a7 in /usr/bin/clickhouse 16. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000000fb0c252 in /usr/bin/clickhouse 17. __tsan_thread_start_func @ 0x0000000007bf022f in /usr/bin/clickhouse 18. ? @ 0x00007f717c9baac3 in ? 19. ? @ 0x00007f717ca4c850 in ? (version 23.8.11.29.altinitystable (altinity build)) 2024.04.28 18:09:35.000170 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.92 GiB, peak 1.92 GiB, free memory in arenas 0.00 B, will set to 1.93 GiB (RSS), difference: 12.05 MiB 2024.04.28 18:09:35.176872 [ 894 ] {} DDLWorker: Initializing DDLWorker thread 2024.04.28 18:09:35.176980 [ 894 ] {} Context: Trying to establish a new connection with ZooKeeper 2024.04.28 18:09:35.177601 [ 552 ] {} KeeperTCPHandlerFactory: Keeper request. Address: [::1]:59710 2024.04.28 18:09:35.177998 [ 552 ] {} KeeperTCPHandler: Requesting session ID for the new client 2024.04.28 18:09:35.178243 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:09:35.279351 [ 784 ] {} KeeperStateMachine: Session ID response 2 with timeout 30000 2024.04.28 18:09:35.279648 [ 552 ] {} KeeperTCPHandler: Received session ID 2 2024.04.28 18:09:35.279864 [ 894 ] {} ZooKeeperClient: Connected to ZooKeeper at [::1]:9181 with session_id 2 2024.04.28 18:09:35.280637 [ 894 ] {} ZooKeeperClient: Keeper feature flag FILTERED_LIST: enabled 2024.04.28 18:09:35.280685 [ 894 ] {} ZooKeeperClient: Keeper feature flag MULTI_READ: enabled 2024.04.28 18:09:35.280717 [ 894 ] {} ZooKeeperClient: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.04.28 18:09:35.280770 [ 894 ] {} ZooKeeper: Initialized, hosts: localhost:9181 2024.04.28 18:09:35.280813 [ 894 ] {} ZooKeeperClient: ZK send fault: 0.002% 2024.04.28 18:09:35.280839 [ 894 ] {} ZooKeeperClient: ZK recv fault: 0.002% 2024.04.28 18:09:35.280864 [ 894 ] {} ZooKeeperClient: ZK send sleep: 0.001% -> 10000ms 2024.04.28 18:09:35.280890 [ 894 ] {} Context: Establishing a new connection with ZooKeeper took 103 ms 2024.04.28 18:09:35.280916 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 1 2024.04.28 18:09:35.281615 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.04.28 18:09:35.282820 [ 894 ] {} DDLWorker: Initialized DDLWorker thread 2024.04.28 18:09:35.282988 [ 894 ] {} DDLWorker: Scheduling tasks 2024.04.28 18:09:35.283036 [ 895 ] {} DDLWorker: Too early to clean queue, will do it later. 2024.04.28 18:09:35.283073 [ 894 ] {} DDLWorker: Don't have unfinished tasks after restarting 2024.04.28 18:09:35.283772 [ 894 ] {} DDLWorker: scheduleTasks: initialized=true, size_before_filtering=0, queue_size=0, entries=none..none, first_failed_task_name=none, current_tasks_size=0, last_current_task=none, last_skipped_entry_name=none 2024.04.28 18:09:35.283829 [ 894 ] {} DDLWorker: No tasks to schedule 2024.04.28 18:09:35.283884 [ 894 ] {} DDLWorker: Waiting for queue updates 2024.04.28 18:09:36.000303 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.93 GiB, peak 1.93 GiB, free memory in arenas 0.00 B, will set to 1.93 GiB (RSS), difference: -3.58 MiB 2024.04.28 18:09:37.146972 [ 855 ] {} SystemLog (system.text_log): Flushing system log, 107 entries to flush up to offset 367 2024.04.28 18:09:37.153674 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:37.153771 [ 855 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.88 GiB. 2024.04.28 18:09:37.157926 [ 855 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:09:37.159910 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_insert_202404_2_2_0 to 202404_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:37.161304 [ 855 ] {} SystemLog (system.text_log): Flushed system log up to offset 367 2024.04.28 18:09:39.000207 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.93 GiB, peak 1.94 GiB, free memory in arenas 0.00 B, will set to 1.93 GiB (RSS), difference: 1.54 MiB 2024.04.28 18:09:40.138269 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2824 entries to flush up to offset 2956 2024.04.28 18:09:40.157002 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:40.157127 [ 851 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.88 GiB. 2024.04.28 18:09:40.162865 [ 851 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:09:40.164354 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Renaming temporary part tmp_insert_202404_2_2_0 to 202404_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:40.165955 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 2956 2024.04.28 18:09:40.594311 [ 865 ] {} SystemLog (system.transactions_info_log): Flushing system log, 7 entries to flush up to offset 7 2024.04.28 18:09:40.594504 [ 865 ] {} SystemLog (system.transactions_info_log): Creating new table system.transactions_info_log for TransactionsInfoLog 2024.04.28 18:09:40.601292 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Loading data parts 2024.04.28 18:09:40.601808 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): There are no data parts 2024.04.28 18:09:40.605448 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:40.605533 [ 865 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.88 GiB. 2024.04.28 18:09:40.607669 [ 865 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:09:40.609669 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Renaming temporary part tmp_insert_202404_1_1_0 to 202404_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:40.610934 [ 865 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 7 2024.04.28 18:09:40.730404 [ 860 ] {} SystemLog (system.zookeeper_log): Flushing system log, 8 entries to flush up to offset 26 2024.04.28 18:09:40.783825 [ 856 ] {} SystemLog (system.query_log): Flushing system log, 2 entries to flush up to offset 4 2024.04.28 18:09:40.917114 [ 856 ] {} system.query_log (f61bb234-b325-4c97-bf3f-90f9b9249d77): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:40.917309 [ 856 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.92 GiB. 2024.04.28 18:09:40.940043 [ 856 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:09:40.941058 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:40.941174 [ 860 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.92 GiB. 2024.04.28 18:09:40.945626 [ 860 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:09:40.948380 [ 856 ] {} system.query_log (f61bb234-b325-4c97-bf3f-90f9b9249d77): Renaming temporary part tmp_insert_202404_2_2_0 to 202404_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:40.954058 [ 856 ] {} SystemLog (system.query_log): Flushed system log up to offset 4 2024.04.28 18:09:41.000191 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.94 GiB, peak 1.94 GiB, free memory in arenas 0.00 B, will set to 1.94 GiB (RSS), difference: -1.96 MiB 2024.04.28 18:09:41.049600 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Renaming temporary part tmp_insert_202404_2_2_0 to 202404_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:41.051681 [ 860 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 26 2024.04.28 18:09:41.161623 [ 855 ] {} SystemLog (system.text_log): Flushing system log, 35 entries to flush up to offset 402 2024.04.28 18:09:41.166008 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:41.166102 [ 855 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.92 GiB. 2024.04.28 18:09:41.269440 [ 855 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:09:41.271623 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_insert_202404_3_3_0 to 202404_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:41.273065 [ 855 ] {} SystemLog (system.text_log): Flushed system log up to offset 402 2024.04.28 18:09:41.646359 [ 850 ] {} SystemLog (system.metric_log): Flushing system log, 10 entries to flush up to offset 12 2024.04.28 18:09:42.000226 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.93 GiB, peak 1.94 GiB, free memory in arenas 0.00 B, will set to 1.95 GiB (RSS), difference: 14.20 MiB 2024.04.28 18:09:42.203885 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:42.204007 [ 850 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.80 GiB. 2024.04.28 18:09:42.376014 [ 850 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:09:42.520136 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Renaming temporary part tmp_insert_202404_2_2_0 to 202404_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:42.742348 [ 850 ] {} SystemLog (system.metric_log): Flushed system log up to offset 12 2024.04.28 18:09:43.000231 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.95 GiB, peak 1.95 GiB, free memory in arenas 0.00 B, will set to 1.96 GiB (RSS), difference: 10.92 MiB 2024.04.28 18:09:44.000218 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.96 GiB, peak 1.96 GiB, free memory in arenas 0.00 B, will set to 1.96 GiB (RSS), difference: 1.43 MiB 2024.04.28 18:09:45.273326 [ 855 ] {} SystemLog (system.text_log): Flushing system log, 15 entries to flush up to offset 417 2024.04.28 18:09:45.276790 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:45.276893 [ 855 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.52 GiB. 2024.04.28 18:09:45.279700 [ 855 ] {} MergedBlockOutputStream: filled checksums 202404_4_4_0 (state Temporary) 2024.04.28 18:09:45.280187 [ 552 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.04.28 18:09:45.280221 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:09:45.281531 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_insert_202404_4_4_0 to 202404_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:45.283089 [ 855 ] {} SystemLog (system.text_log): Flushed system log up to offset 417 2024.04.28 18:09:47.166434 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2471 entries to flush up to offset 5427 2024.04.28 18:09:47.388126 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:47.388269 [ 851 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.34 GiB. 2024.04.28 18:09:47.595478 [ 851 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:09:47.597269 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Renaming temporary part tmp_insert_202404_3_3_0 to 202404_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:47.599375 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 5427 2024.04.28 18:09:48.000185 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.96 GiB, peak 1.97 GiB, free memory in arenas 0.00 B, will set to 1.96 GiB (RSS), difference: 1.76 MiB 2024.04.28 18:09:48.093964 [ 726 ] {} DNSResolver: Updating DNS cache 2024.04.28 18:09:48.094580 [ 726 ] {} DNSResolver: Updated DNS cache 2024.04.28 18:09:48.111083 [ 865 ] {} SystemLog (system.transactions_info_log): Flushing system log, 7 entries to flush up to offset 14 2024.04.28 18:09:48.115875 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:48.115960 [ 865 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.28 GiB. 2024.04.28 18:09:48.118109 [ 865 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:09:48.120458 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Renaming temporary part tmp_insert_202404_2_2_0 to 202404_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:48.121790 [ 865 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 14 2024.04.28 18:09:48.551908 [ 860 ] {} SystemLog (system.zookeeper_log): Flushing system log, 1 entries to flush up to offset 27 2024.04.28 18:09:48.557227 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:48.557354 [ 860 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.23 GiB. 2024.04.28 18:09:48.562512 [ 860 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:09:48.565067 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Renaming temporary part tmp_insert_202404_3_3_0 to 202404_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:48.566959 [ 860 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 27 2024.04.28 18:09:49.000232 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.96 GiB, peak 1.97 GiB, free memory in arenas 0.00 B, will set to 1.96 GiB (RSS), difference: -1.41 MiB 2024.04.28 18:09:49.283307 [ 855 ] {} SystemLog (system.text_log): Flushing system log, 30 entries to flush up to offset 447 2024.04.28 18:09:49.287884 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:49.287999 [ 855 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.14 GiB. 2024.04.28 18:09:49.291355 [ 855 ] {} MergedBlockOutputStream: filled checksums 202404_5_5_0 (state Temporary) 2024.04.28 18:09:49.293200 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_insert_202404_5_5_0 to 202404_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:49.294577 [ 855 ] {} SystemLog (system.text_log): Flushed system log up to offset 447 2024.04.28 18:09:50.000185 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.96 GiB, peak 1.97 GiB, free memory in arenas 0.00 B, will set to 1.96 GiB (RSS), difference: 1.28 MiB 2024.04.28 18:09:50.242799 [ 850 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 20 2024.04.28 18:09:50.549985 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:50.550100 [ 850 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 122.05 GiB. 2024.04.28 18:09:50.826424 [ 850 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:09:50.980624 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Renaming temporary part tmp_insert_202404_3_3_0 to 202404_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:51.000192 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.96 GiB, peak 1.97 GiB, free memory in arenas 0.00 B, will set to 1.97 GiB (RSS), difference: 10.77 MiB 2024.04.28 18:09:51.002705 [ 850 ] {} SystemLog (system.metric_log): Flushed system log up to offset 20 2024.04.28 18:09:52.000223 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.97 GiB, peak 1.97 GiB, free memory in arenas 0.00 B, will set to 1.97 GiB (RSS), difference: 4.21 MiB 2024.04.28 18:09:53.295046 [ 855 ] {} SystemLog (system.text_log): Flushing system log, 15 entries to flush up to offset 462 2024.04.28 18:09:53.301280 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:53.301443 [ 855 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.79 GiB. 2024.04.28 18:09:53.306409 [ 855 ] {} MergedBlockOutputStream: filled checksums 202404_6_6_0 (state Temporary) 2024.04.28 18:09:53.309725 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_insert_202404_6_6_0 to 202404_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:53.310589 [ 615 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06) (MergerMutator): Selected 6 parts from 202404_1_1_0 to 202404_6_6_0 2024.04.28 18:09:53.311090 [ 615 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:53.311199 [ 615 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.79 GiB. 2024.04.28 18:09:53.312109 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} MergeTask::PrepareStage: Merging 6 parts: from 202404_1_1_0 to 202404_6_6_0 into Compact with storage Full 2024.04.28 18:09:53.313172 [ 855 ] {} SystemLog (system.text_log): Flushed system log up to offset 462 2024.04.28 18:09:53.313552 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:09:53.313856 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_1_1_0, total 260 rows starting from the beginning of the part 2024.04.28 18:09:53.314911 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_2_2_0, total 107 rows starting from the beginning of the part 2024.04.28 18:09:53.315664 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_3_3_0, total 35 rows starting from the beginning of the part 2024.04.28 18:09:53.316294 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_4_4_0, total 15 rows starting from the beginning of the part 2024.04.28 18:09:53.316906 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_5_5_0, total 30 rows starting from the beginning of the part 2024.04.28 18:09:53.317524 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_6_6_0, total 15 rows starting from the beginning of the part 2024.04.28 18:09:53.333026 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} MergeTask::MergeProjectionsStage: Merge sorted 462 rows, containing 13 columns (13 merged, 0 gathered) in 0.021345706 sec., 21643.697331913034 rows/sec., 2.91 MiB/sec. 2024.04.28 18:09:53.438184 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} MergedBlockOutputStream: filled checksums 202404_1_6_1 (state Temporary) 2024.04.28 18:09:53.441443 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_merge_202404_1_6_1 to 202404_1_6_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:53.441652 [ 791 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_6_1} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06) (MergerMutator): Merged 6 parts: [202404_1_1_0, 202404_6_6_0] -> 202404_1_6_1 2024.04.28 18:09:53.443023 [ 791 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 5.16 MiB. 2024.04.28 18:09:54.000204 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.97 GiB, peak 1.98 GiB, free memory in arenas 0.00 B, will set to 1.98 GiB (RSS), difference: 5.74 MiB 2024.04.28 18:09:54.599721 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2471 entries to flush up to offset 7898 2024.04.28 18:09:54.819055 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:54.907117 [ 851 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.37 GiB. 2024.04.28 18:09:54.913274 [ 851 ] {} MergedBlockOutputStream: filled checksums 202404_4_4_0 (state Temporary) 2024.04.28 18:09:54.914993 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Renaming temporary part tmp_insert_202404_4_4_0 to 202404_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:54.916880 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 7898 2024.04.28 18:09:55.000220 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.98 GiB, peak 1.99 GiB, free memory in arenas 0.00 B, will set to 1.98 GiB (RSS), difference: 1.38 MiB 2024.04.28 18:09:55.280222 [ 552 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.04.28 18:09:55.280291 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:09:55.621980 [ 865 ] {} SystemLog (system.transactions_info_log): Flushing system log, 13 entries to flush up to offset 27 2024.04.28 18:09:55.625676 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:55.625791 [ 865 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 120.59 GiB. 2024.04.28 18:09:55.628620 [ 865 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:09:55.631197 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Renaming temporary part tmp_insert_202404_3_3_0 to 202404_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:55.632646 [ 865 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 27 2024.04.28 18:09:56.067175 [ 860 ] {} SystemLog (system.zookeeper_log): Flushing system log, 1 entries to flush up to offset 28 2024.04.28 18:09:56.173557 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:56.173692 [ 860 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.74 GiB. 2024.04.28 18:09:56.179082 [ 860 ] {} MergedBlockOutputStream: filled checksums 202404_4_4_0 (state Temporary) 2024.04.28 18:09:56.182367 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Renaming temporary part tmp_insert_202404_4_4_0 to 202404_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:56.184856 [ 860 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 28 2024.04.28 18:09:57.000219 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.98 GiB, peak 1.99 GiB, free memory in arenas 0.00 B, will set to 1.98 GiB (RSS), difference: -2.33 MiB 2024.04.28 18:09:57.313457 [ 855 ] {} SystemLog (system.text_log): Flushing system log, 45 entries to flush up to offset 507 2024.04.28 18:09:57.318201 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:57.318310 [ 855 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.69 GiB. 2024.04.28 18:09:57.321815 [ 855 ] {} MergedBlockOutputStream: filled checksums 202404_7_7_0 (state Temporary) 2024.04.28 18:09:57.324147 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_insert_202404_7_7_0 to 202404_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:57.325779 [ 855 ] {} SystemLog (system.text_log): Flushed system log up to offset 507 2024.04.28 18:09:58.502934 [ 850 ] {} SystemLog (system.metric_log): Flushing system log, 9 entries to flush up to offset 29 2024.04.28 18:09:58.918776 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:09:58.918911 [ 850 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.69 GiB. 2024.04.28 18:09:59.000222 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.98 GiB, peak 1.99 GiB, free memory in arenas 0.00 B, will set to 1.99 GiB (RSS), difference: 6.69 MiB 2024.04.28 18:09:59.199966 [ 850 ] {} MergedBlockOutputStream: filled checksums 202404_4_4_0 (state Temporary) 2024.04.28 18:09:59.239197 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Renaming temporary part tmp_insert_202404_4_4_0 to 202404_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:09:59.260431 [ 850 ] {} SystemLog (system.metric_log): Flushed system log up to offset 29 2024.04.28 18:10:00.000183 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.99 GiB, peak 1.99 GiB, free memory in arenas 0.00 B, will set to 1.99 GiB (RSS), difference: 4.07 MiB 2024.04.28 18:10:01.326109 [ 855 ] {} SystemLog (system.text_log): Flushing system log, 14 entries to flush up to offset 521 2024.04.28 18:10:01.329806 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:01.329898 [ 855 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.74 GiB. 2024.04.28 18:10:01.332921 [ 855 ] {} MergedBlockOutputStream: filled checksums 202404_8_8_0 (state Temporary) 2024.04.28 18:10:01.335209 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_insert_202404_8_8_0 to 202404_8_8_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:01.336572 [ 855 ] {} SystemLog (system.text_log): Flushed system log up to offset 521 2024.04.28 18:10:01.917183 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2471 entries to flush up to offset 10369 2024.04.28 18:10:01.937379 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:01.937501 [ 851 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.69 GiB. 2024.04.28 18:10:01.943142 [ 851 ] {} MergedBlockOutputStream: filled checksums 202404_5_5_0 (state Temporary) 2024.04.28 18:10:01.944496 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Renaming temporary part tmp_insert_202404_5_5_0 to 202404_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:01.945918 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 10369 2024.04.28 18:10:03.094970 [ 671 ] {} DNSResolver: Updating DNS cache 2024.04.28 18:10:03.095568 [ 671 ] {} DNSResolver: Updated DNS cache 2024.04.28 18:10:03.132815 [ 865 ] {} SystemLog (system.transactions_info_log): Flushing system log, 6 entries to flush up to offset 33 2024.04.28 18:10:03.135935 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:03.136114 [ 865 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.69 GiB. 2024.04.28 18:10:03.138508 [ 865 ] {} MergedBlockOutputStream: filled checksums 202404_4_4_0 (state Temporary) 2024.04.28 18:10:03.140559 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Renaming temporary part tmp_insert_202404_4_4_0 to 202404_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:03.141873 [ 865 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 33 2024.04.28 18:10:04.000171 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 1.99 GiB, peak 2.00 GiB, free memory in arenas 0.00 B, will set to 1.99 GiB (RSS), difference: 1.67 MiB 2024.04.28 18:10:05.280194 [ 552 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.04.28 18:10:05.280265 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:10:05.336812 [ 855 ] {} SystemLog (system.text_log): Flushing system log, 23 entries to flush up to offset 544 2024.04.28 18:10:05.442815 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:05.442981 [ 855 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.56 GiB. 2024.04.28 18:10:05.445997 [ 855 ] {} MergedBlockOutputStream: filled checksums 202404_9_9_0 (state Temporary) 2024.04.28 18:10:05.448276 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_insert_202404_9_9_0 to 202404_9_9_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:05.449860 [ 855 ] {} SystemLog (system.text_log): Flushed system log up to offset 544 2024.04.28 18:10:06.761232 [ 850 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 37 2024.04.28 18:10:07.501773 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:07.501893 [ 850 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.42 GiB. 2024.04.28 18:10:07.987893 [ 850 ] {} MergedBlockOutputStream: filled checksums 202404_5_5_0 (state Temporary) 2024.04.28 18:10:08.000207 [ 891 ] {} MemoryTracker: Current memory usage (total): 2.00 GiB. 2024.04.28 18:10:08.174113 [ 831 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): /var/lib/clickhouse/store/bfa/bfaaef5a-6281-427e-a93f-de95bc783a5b/tmp_insert_202404_5_5_0/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 2024.04.28 18:10:08.240655 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Renaming temporary part tmp_insert_202404_5_5_0 to 202404_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:08.364404 [ 850 ] {} SystemLog (system.metric_log): Flushed system log up to offset 37 2024.04.28 18:10:08.946352 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2473 entries to flush up to offset 12842 2024.04.28 18:10:09.000194 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 2.00 GiB, peak 2.00 GiB, free memory in arenas 0.00 B, will set to 2.00 GiB (RSS), difference: 6.03 MiB 2024.04.28 18:10:09.068717 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:09.068847 [ 851 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.29 GiB. 2024.04.28 18:10:09.076844 [ 851 ] {} MergedBlockOutputStream: filled checksums 202404_6_6_0 (state Temporary) 2024.04.28 18:10:09.078910 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Renaming temporary part tmp_insert_202404_6_6_0 to 202404_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:09.079608 [ 707 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36) (MergerMutator): Selected 6 parts from 202404_1_1_0 to 202404_6_6_0 2024.04.28 18:10:09.079878 [ 707 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:09.079999 [ 707 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.29 GiB. 2024.04.28 18:10:09.080932 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} MergeTask::PrepareStage: Merging 6 parts: from 202404_1_1_0 to 202404_6_6_0 into Compact with storage Full 2024.04.28 18:10:09.081423 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 12842 2024.04.28 18:10:09.081546 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:10:09.081720 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_1_1_0, total 132 rows starting from the beginning of the part 2024.04.28 18:10:09.082119 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_2_2_0, total 2824 rows starting from the beginning of the part 2024.04.28 18:10:09.082441 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_3_3_0, total 2471 rows starting from the beginning of the part 2024.04.28 18:10:09.083036 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_4_4_0, total 2471 rows starting from the beginning of the part 2024.04.28 18:10:09.083342 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_5_5_0, total 2471 rows starting from the beginning of the part 2024.04.28 18:10:09.083617 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_6_6_0, total 2473 rows starting from the beginning of the part 2024.04.28 18:10:09.326094 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} MergeTask::MergeProjectionsStage: Merge sorted 12842 rows, containing 4 columns (4 merged, 0 gathered) in 0.245573225 sec., 52293.97463831816 rows/sec., 816.57 KiB/sec. 2024.04.28 18:10:09.431470 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} MergedBlockOutputStream: filled checksums 202404_1_6_1 (state Temporary) 2024.04.28 18:10:09.433402 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Renaming temporary part tmp_merge_202404_1_6_1 to 202404_1_6_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:09.433583 [ 792 ] {0ba6716c-4d24-43a3-a7df-60639fc03b36::202404_1_6_1} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36) (MergerMutator): Merged 6 parts: [202404_1_1_0, 202404_6_6_0] -> 202404_1_6_1 2024.04.28 18:10:09.435239 [ 792 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 8.16 MiB. 2024.04.28 18:10:09.450123 [ 855 ] {} SystemLog (system.text_log): Flushing system log, 37 entries to flush up to offset 581 2024.04.28 18:10:09.555174 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:09.555298 [ 855 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.26 GiB. 2024.04.28 18:10:09.558576 [ 855 ] {} MergedBlockOutputStream: filled checksums 202404_10_10_0 (state Temporary) 2024.04.28 18:10:09.560728 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_insert_202404_10_10_0 to 202404_10_10_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:09.562221 [ 855 ] {} SystemLog (system.text_log): Flushed system log up to offset 581 2024.04.28 18:10:10.000223 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 2.00 GiB, peak 2.01 GiB, free memory in arenas 0.00 B, will set to 2.01 GiB (RSS), difference: 5.65 MiB 2024.04.28 18:10:10.642115 [ 865 ] {} SystemLog (system.transactions_info_log): Flushing system log, 12 entries to flush up to offset 45 2024.04.28 18:10:10.645563 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:10.645672 [ 865 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.11 GiB. 2024.04.28 18:10:10.648471 [ 865 ] {} MergedBlockOutputStream: filled checksums 202404_5_5_0 (state Temporary) 2024.04.28 18:10:10.650848 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Renaming temporary part tmp_insert_202404_5_5_0 to 202404_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:10.652409 [ 865 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 45 2024.04.28 18:10:11.185162 [ 860 ] {} SystemLog (system.zookeeper_log): Flushing system log, 1 entries to flush up to offset 29 2024.04.28 18:10:11.193081 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:11.193516 [ 860 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.21 GiB. 2024.04.28 18:10:11.198496 [ 860 ] {} MergedBlockOutputStream: filled checksums 202404_5_5_0 (state Temporary) 2024.04.28 18:10:11.201246 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Renaming temporary part tmp_insert_202404_5_5_0 to 202404_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:11.203118 [ 860 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 29 2024.04.28 18:10:11.231062 [ 551 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58222 2024.04.28 18:10:11.231312 [ 551 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.04.28 18:10:11.231406 [ 551 ] {} TCP-Session: 7576902c-b366-4b38-8eff-1cb751dafd3c Authenticating user 'default' from [::1]:58222 2024.04.28 18:10:11.231484 [ 551 ] {} TCP-Session: 7576902c-b366-4b38-8eff-1cb751dafd3c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:10:11.231536 [ 551 ] {} TCP-Session: 7576902c-b366-4b38-8eff-1cb751dafd3c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:10:11.257761 [ 551 ] {} TCP-Session: 7576902c-b366-4b38-8eff-1cb751dafd3c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.04.28 18:10:11.258340 [ 551 ] {c5267d26-a288-4d08-acff-afb422a5fe9d} executeQuery: Query span trace_id for opentelemetry log: 3c638a82-9795-d8e5-d87d-61955e077dab 2024.04.28 18:10:11.258890 [ 551 ] {c5267d26-a288-4d08-acff-afb422a5fe9d} executeQuery: (from [::1]:58222) ATTACH DATABASE IF NOT EXISTS datasets ENGINE = Ordinary (stage: Complete) 2024.04.28 18:10:11.259192 [ 551 ] {c5267d26-a288-4d08-acff-afb422a5fe9d} ContextAccess (default): Access granted: CREATE DATABASE ON datasets.* 2024.04.28 18:10:11.270972 [ 551 ] {c5267d26-a288-4d08-acff-afb422a5fe9d} DatabaseOrdinary (datasets): Metadata processed, database datasets has 2 tables and 0 dictionaries in total. 2024.04.28 18:10:11.271050 [ 551 ] {c5267d26-a288-4d08-acff-afb422a5fe9d} TablesLoader: Parsed metadata of 2 tables in 1 databases in 0.011487831 sec 2024.04.28 18:10:11.271614 [ 551 ] {c5267d26-a288-4d08-acff-afb422a5fe9d} ReferentialDeps: No tables 2024.04.28 18:10:11.271677 [ 551 ] {c5267d26-a288-4d08-acff-afb422a5fe9d} LoadingDeps: Table datasets.visits_v1 has no dependencies (level 0) 2024.04.28 18:10:11.271718 [ 551 ] {c5267d26-a288-4d08-acff-afb422a5fe9d} LoadingDeps: Table datasets.hits_v1 has no dependencies (level 0) 2024.04.28 18:10:11.271818 [ 551 ] {c5267d26-a288-4d08-acff-afb422a5fe9d} TablesLoader: Loading 2 tables with dependency level 0 2024.04.28 18:10:11.385135 [ 904 ] {} datasets.hits_v1: Loading data parts 2024.04.28 18:10:11.386305 [ 904 ] {} datasets.hits_v1: Will load 1 parts using up to 64 threads 2024.04.28 18:10:11.386842 [ 947 ] {} datasets.hits_v1: Loading Active part 201403_10_18_2 from disk default 2024.04.28 18:10:11.388580 [ 946 ] {} datasets.visits_v1: Loading data parts 2024.04.28 18:10:11.389596 [ 946 ] {} datasets.visits_v1: Will load 1 parts using up to 64 threads 2024.04.28 18:10:11.389802 [ 948 ] {} datasets.visits_v1: Loading Active part 20140317_20140323_3_4_1 from disk default 2024.04.28 18:10:11.422508 [ 947 ] {} datasets.hits_v1: Finished loading Active part 201403_10_18_2 on disk default 2024.04.28 18:10:11.423983 [ 904 ] {} datasets.hits_v1: Loaded data parts (1 items) 2024.04.28 18:10:11.515554 [ 948 ] {} datasets.visits_v1: Finished loading Active part 20140317_20140323_3_4_1 on disk default 2024.04.28 18:10:11.516581 [ 946 ] {} datasets.visits_v1: Loaded data parts (1 items) 2024.04.28 18:10:11.518344 [ 551 ] {c5267d26-a288-4d08-acff-afb422a5fe9d} DatabaseOrdinary (datasets): Starting up tables. 2024.04.28 18:10:11.523760 [ 551 ] {c5267d26-a288-4d08-acff-afb422a5fe9d} TCPHandler: Processed in 0.266475499 sec. 2024.04.28 18:10:11.524802 [ 551 ] {} TCPHandler: Done processing connection. 2024.04.28 18:10:11.525497 [ 551 ] {} TCP-Session: 7576902c-b366-4b38-8eff-1cb751dafd3c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:10:11.628843 [ 551 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:60532 2024.04.28 18:10:11.629101 [ 551 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.04.28 18:10:11.629186 [ 551 ] {} TCP-Session: bb9ddd2f-841c-40b4-92bf-b1f36944ab2f Authenticating user 'default' from [::1]:60532 2024.04.28 18:10:11.629259 [ 551 ] {} TCP-Session: bb9ddd2f-841c-40b4-92bf-b1f36944ab2f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:10:11.629303 [ 551 ] {} TCP-Session: bb9ddd2f-841c-40b4-92bf-b1f36944ab2f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:10:11.755430 [ 551 ] {} TCP-Session: bb9ddd2f-841c-40b4-92bf-b1f36944ab2f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.04.28 18:10:11.755947 [ 551 ] {f44b20e8-2ebd-4260-bfb1-082826cfc541} executeQuery: Query span trace_id for opentelemetry log: bbd85786-2fbf-ed59-e295-0c3dad9c20f1 2024.04.28 18:10:11.756176 [ 551 ] {f44b20e8-2ebd-4260-bfb1-082826cfc541} executeQuery: (from [::1]:60532) CREATE DATABASE IF NOT EXISTS test (stage: Complete) 2024.04.28 18:10:11.756416 [ 551 ] {f44b20e8-2ebd-4260-bfb1-082826cfc541} ContextAccess (default): Access granted: CREATE DATABASE ON test.* 2024.04.28 18:10:11.757271 [ 551 ] {f44b20e8-2ebd-4260-bfb1-082826cfc541} DatabaseAtomic (test): Metadata processed, database test has 0 tables and 0 dictionaries in total. 2024.04.28 18:10:11.757318 [ 551 ] {f44b20e8-2ebd-4260-bfb1-082826cfc541} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00020245 sec 2024.04.28 18:10:11.757353 [ 551 ] {f44b20e8-2ebd-4260-bfb1-082826cfc541} ReferentialDeps: No tables 2024.04.28 18:10:11.757400 [ 551 ] {f44b20e8-2ebd-4260-bfb1-082826cfc541} LoadingDeps: No tables 2024.04.28 18:10:11.757491 [ 551 ] {f44b20e8-2ebd-4260-bfb1-082826cfc541} DatabaseAtomic (test): Starting up tables. 2024.04.28 18:10:11.757922 [ 551 ] {f44b20e8-2ebd-4260-bfb1-082826cfc541} TCPHandler: Processed in 0.103446523 sec. 2024.04.28 18:10:11.758991 [ 551 ] {} TCPHandler: Done processing connection. 2024.04.28 18:10:11.759406 [ 551 ] {} TCP-Session: bb9ddd2f-841c-40b4-92bf-b1f36944ab2f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:10:11.832034 [ 550 ] {} BaseDaemon: Received signal 15 2024.04.28 18:10:11.832250 [ 550 ] {} Application: Received termination signal (Terminated) 2024.04.28 18:10:11.832337 [ 547 ] {} Application: Received termination signal. 2024.04.28 18:10:11.832612 [ 547 ] {} Application: Waiting for current connections to close. 2024.04.28 18:10:12.000206 [ 891 ] {} AsynchronousMetrics: MemoryTracking: was 2.01 GiB, peak 2.01 GiB, free memory in arenas 0.00 B, will set to 2.02 GiB (RSS), difference: 12.07 MiB 2024.04.28 18:10:13.141982 [ 547 ] {} Application: Closed all listening sockets. 2024.04.28 18:10:13.142091 [ 547 ] {} Application: Closed connections. 2024.04.28 18:10:13.144080 [ 547 ] {} Application: Shutting down storages. 2024.04.28 18:10:13.144147 [ 547 ] {} Context: Shutdown disk azure 2024.04.28 18:10:13.144179 [ 547 ] {} DiskObjectStorage(DiskAzureBlobStorage): Shutting down disk azure 2024.04.28 18:10:13.144209 [ 547 ] {} DiskObjectStorage(DiskAzureBlobStorage): Disk azure shut down 2024.04.28 18:10:13.144258 [ 547 ] {} Context: Shutdown disk cached_azure 2024.04.28 18:10:13.144300 [ 547 ] {} DiskObjectStorage(azure): Shutting down disk azure 2024.04.28 18:10:13.144338 [ 547 ] {} DiskObjectStorage(azure): Disk azure shut down 2024.04.28 18:10:13.144365 [ 547 ] {} Context: Shutdown disk default 2024.04.28 18:10:13.144397 [ 547 ] {} Context: Shutdown disk local_cache 2024.04.28 18:10:13.144431 [ 547 ] {} DiskObjectStorage(local_disk): Shutting down disk local_disk 2024.04.28 18:10:13.144468 [ 547 ] {} DiskObjectStorage(local_disk): Disk local_disk shut down 2024.04.28 18:10:13.144502 [ 547 ] {} Context: Shutdown disk local_cache_2 2024.04.28 18:10:13.144536 [ 547 ] {} DiskObjectStorage(local_disk): Shutting down disk local_disk 2024.04.28 18:10:13.144573 [ 547 ] {} DiskObjectStorage(local_disk): Disk local_disk shut down 2024.04.28 18:10:13.144609 [ 547 ] {} Context: Shutdown disk local_cache_3 2024.04.28 18:10:13.144638 [ 547 ] {} DiskObjectStorage(local_disk_3): Shutting down disk local_disk_3 2024.04.28 18:10:13.144671 [ 547 ] {} DiskObjectStorage(local_disk_3): Disk local_disk_3 shut down 2024.04.28 18:10:13.144708 [ 547 ] {} Context: Shutdown disk local_disk 2024.04.28 18:10:13.144741 [ 547 ] {} DiskObjectStorage(Local): Shutting down disk local_disk 2024.04.28 18:10:13.144773 [ 547 ] {} DiskObjectStorage(Local): Disk local_disk shut down 2024.04.28 18:10:13.144803 [ 547 ] {} Context: Shutdown disk local_disk_2 2024.04.28 18:10:13.144833 [ 547 ] {} DiskObjectStorage(Local): Shutting down disk local_disk_2 2024.04.28 18:10:13.144865 [ 547 ] {} DiskObjectStorage(Local): Disk local_disk_2 shut down 2024.04.28 18:10:13.144897 [ 547 ] {} Context: Shutdown disk local_disk_3 2024.04.28 18:10:13.144929 [ 547 ] {} DiskObjectStorage(Local): Shutting down disk local_disk_3 2024.04.28 18:10:13.144958 [ 547 ] {} DiskObjectStorage(Local): Disk local_disk_3 shut down 2024.04.28 18:10:13.144989 [ 547 ] {} Context: Shutdown disk s3_cache 2024.04.28 18:10:13.145020 [ 547 ] {} DiskObjectStorage(s3_disk): Shutting down disk s3_disk 2024.04.28 18:10:13.145062 [ 547 ] {} DiskObjectStorage(s3_disk): Disk s3_disk shut down 2024.04.28 18:10:13.145097 [ 547 ] {} Context: Shutdown disk s3_cache_multi 2024.04.28 18:10:13.145133 [ 547 ] {} DiskObjectStorage(s3_disk): Shutting down disk s3_disk 2024.04.28 18:10:13.145170 [ 547 ] {} DiskObjectStorage(s3_disk): Disk s3_disk shut down 2024.04.28 18:10:13.145196 [ 547 ] {} Context: Shutdown disk s3_cache_multi_2 2024.04.28 18:10:13.145222 [ 547 ] {} DiskObjectStorage(s3_disk): Shutting down disk s3_disk 2024.04.28 18:10:13.145245 [ 547 ] {} DiskObjectStorage(s3_disk): Disk s3_disk shut down 2024.04.28 18:10:13.145265 [ 547 ] {} Context: Shutdown disk s3_disk 2024.04.28 18:10:13.145297 [ 547 ] {} DiskObjectStorage(DiskS3): Shutting down disk s3_disk 2024.04.28 18:10:13.145328 [ 547 ] {} DiskObjectStorage(DiskS3): Disk s3_disk shut down 2024.04.28 18:10:13.145364 [ 547 ] {} AsynchronousInsertQueue: Shutting down the asynchronous insertion queue 2024.04.28 18:10:13.146519 [ 547 ] {} AsynchronousInsertQueue: Asynchronous insertion queue finished 2024.04.28 18:10:13.146593 [ 547 ] {} Context: Shutting down dictionaries loader 2024.04.28 18:10:13.146819 [ 547 ] {} Context: Shutting down UDFs loader 2024.04.28 18:10:13.146942 [ 547 ] {} Context: Shutting down another UDFs loader 2024.04.28 18:10:13.146985 [ 547 ] {} Context: Shutting down named sessions 2024.04.28 18:10:13.147048 [ 547 ] {} Context: Shutting down system logs 2024.04.28 18:10:13.147156 [ 856 ] {} SystemLog (system.query_log): Flushing system log, 4 entries to flush up to offset 8 2024.04.28 18:10:13.260673 [ 856 ] {} system.query_log (f61bb234-b325-4c97-bf3f-90f9b9249d77): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:13.260799 [ 856 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.21 GiB. 2024.04.28 18:10:13.273915 [ 856 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:10:13.277942 [ 856 ] {} system.query_log (f61bb234-b325-4c97-bf3f-90f9b9249d77): Renaming temporary part tmp_insert_202404_3_3_0 to 202404_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:13.281268 [ 856 ] {} SystemLog (system.query_log): Flushed system log up to offset 8 2024.04.28 18:10:13.281310 [ 856 ] {} SystemLog (system.query_log): Terminating 2024.04.28 18:10:13.283331 [ 849 ] {} SystemLog (system.query_thread_log): Terminating 2024.04.28 18:10:13.284369 [ 854 ] {} SystemLog (system.part_log): Terminating 2024.04.28 18:10:13.284962 [ 853 ] {} SystemLog (system.trace_log): Terminating 2024.04.28 18:10:13.285272 [ 852 ] {} SystemLog (system.crash_log): Terminating 2024.04.28 18:10:13.285840 [ 855 ] {} SystemLog (system.text_log): Flushing system log, 128 entries to flush up to offset 709 2024.04.28 18:10:13.293133 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:13.293266 [ 855 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.21 GiB. 2024.04.28 18:10:13.298177 [ 855 ] {} MergedBlockOutputStream: filled checksums 202404_11_11_0 (state Temporary) 2024.04.28 18:10:13.300727 [ 855 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_insert_202404_11_11_0 to 202404_11_11_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:13.301333 [ 600 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06) (MergerMutator): Selected 6 parts from 202404_1_6_1 to 202404_11_11_0 2024.04.28 18:10:13.301518 [ 600 ] {} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:13.301613 [ 600 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.21 GiB. 2024.04.28 18:10:13.302353 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} MergeTask::PrepareStage: Merging 6 parts: from 202404_1_6_1 to 202404_11_11_0 into Compact with storage Full 2024.04.28 18:10:13.303669 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:10:13.303934 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202404_1_6_1, total 462 rows starting from the beginning of the part 2024.04.28 18:10:13.304542 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202404_7_7_0, total 45 rows starting from the beginning of the part 2024.04.28 18:10:13.305312 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202404_8_8_0, total 14 rows starting from the beginning of the part 2024.04.28 18:10:13.306251 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202404_9_9_0, total 23 rows starting from the beginning of the part 2024.04.28 18:10:13.307078 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202404_10_10_0, total 37 rows starting from the beginning of the part 2024.04.28 18:10:13.307613 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202404_11_11_0, total 128 rows starting from the beginning of the part 2024.04.28 18:10:13.323794 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} MergeTask::MergeProjectionsStage: Merge sorted 709 rows, containing 13 columns (13 merged, 0 gathered) in 0.02183344 sec., 32473.123795425734 rows/sec., 4.17 MiB/sec. 2024.04.28 18:10:13.328694 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} MergedBlockOutputStream: filled checksums 202404_1_11_2 (state Temporary) 2024.04.28 18:10:13.331331 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06): Renaming temporary part tmp_merge_202404_1_11_2 to 202404_1_11_2 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:13.331551 [ 805 ] {b46a046a-dfb5-4e57-98bf-d565bb0aaf06::202404_1_11_2} system.text_log (b46a046a-dfb5-4e57-98bf-d565bb0aaf06) (MergerMutator): Merged 6 parts: [202404_1_6_1, 202404_11_11_0] -> 202404_1_11_2 2024.04.28 18:10:13.332628 [ 805 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 5.16 MiB. 2024.04.28 18:10:13.402974 [ 855 ] {} SystemLog (system.text_log): Flushed system log up to offset 709 2024.04.28 18:10:13.403064 [ 855 ] {} SystemLog (system.text_log): Terminating 2024.04.28 18:10:14.394105 [ 850 ] {} SystemLog (system.metric_log): Flushing system log, 7 entries to flush up to offset 44 2024.04.28 18:10:14.930784 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:14.930904 [ 850 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.16 GiB. 2024.04.28 18:10:15.205046 [ 850 ] {} MergedBlockOutputStream: filled checksums 202404_6_6_0 (state Temporary) 2024.04.28 18:10:15.280363 [ 552 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.04.28 18:10:15.280429 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:10:15.448648 [ 850 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Renaming temporary part tmp_insert_202404_6_6_0 to 202404_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:15.450165 [ 617 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b) (MergerMutator): Selected 6 parts from 202404_1_1_0 to 202404_6_6_0 2024.04.28 18:10:15.450317 [ 617 ] {} system.metric_log (bfaaef5a-6281-427e-a93f-de95bc783a5b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:15.450393 [ 617 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.16 GiB. 2024.04.28 18:10:15.451290 [ 793 ] {bfaaef5a-6281-427e-a93f-de95bc783a5b::202404_1_6_1} MergeTask::PrepareStage: Merging 6 parts: from 202404_1_1_0 to 202404_6_6_0 into Compact with storage Full 2024.04.28 18:10:15.480350 [ 850 ] {} SystemLog (system.metric_log): Flushed system log up to offset 44 2024.04.28 18:10:15.480441 [ 850 ] {} SystemLog (system.metric_log): Terminating 2024.04.28 18:10:15.480875 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 1412 entries to flush up to offset 14254 2024.04.28 18:10:15.493016 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:15.493135 [ 851 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.16 GiB. 2024.04.28 18:10:15.498383 [ 851 ] {} MergedBlockOutputStream: filled checksums 202404_7_7_0 (state Temporary) 2024.04.28 18:10:15.500079 [ 851 ] {} system.asynchronous_metric_log (0ba6716c-4d24-43a3-a7df-60639fc03b36): Renaming temporary part tmp_insert_202404_7_7_0 to 202404_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:15.501884 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 14254 2024.04.28 18:10:15.501939 [ 851 ] {} SystemLog (system.asynchronous_metric_log): Terminating 2024.04.28 18:10:15.502999 [ 857 ] {} SystemLog (system.opentelemetry_span_log): Flushing system log, 18 entries to flush up to offset 18 2024.04.28 18:10:15.503134 [ 857 ] {} SystemLog (system.opentelemetry_span_log): Creating new table system.opentelemetry_span_log for OpenTelemetrySpanLog 2024.04.28 18:10:15.514564 [ 857 ] {} system.opentelemetry_span_log (c6b06443-fcd8-43da-b016-9e4d96cdb81d): Loading data parts 2024.04.28 18:10:15.515286 [ 857 ] {} system.opentelemetry_span_log (c6b06443-fcd8-43da-b016-9e4d96cdb81d): There are no data parts 2024.04.28 18:10:15.520985 [ 857 ] {} system.opentelemetry_span_log (c6b06443-fcd8-43da-b016-9e4d96cdb81d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:15.521081 [ 857 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.16 GiB. 2024.04.28 18:10:15.524639 [ 857 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:10:15.527135 [ 857 ] {} system.opentelemetry_span_log (c6b06443-fcd8-43da-b016-9e4d96cdb81d): Renaming temporary part tmp_insert_202404_1_1_0 to 202404_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:15.528717 [ 857 ] {} SystemLog (system.opentelemetry_span_log): Flushed system log up to offset 18 2024.04.28 18:10:15.528757 [ 857 ] {} SystemLog (system.opentelemetry_span_log): Terminating 2024.04.28 18:10:15.529535 [ 858 ] {} SystemLog (system.query_views_log): Terminating 2024.04.28 18:10:15.530199 [ 860 ] {} SystemLog (system.zookeeper_log): Flushing system log, 1 entries to flush up to offset 30 2024.04.28 18:10:15.535265 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:15.535370 [ 860 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.16 GiB. 2024.04.28 18:10:15.540297 [ 860 ] {} MergedBlockOutputStream: filled checksums 202404_6_6_0 (state Temporary) 2024.04.28 18:10:15.543405 [ 860 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Renaming temporary part tmp_insert_202404_6_6_0 to 202404_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:15.544020 [ 622 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b) (MergerMutator): Selected 6 parts from 202404_1_1_0 to 202404_6_6_0 2024.04.28 18:10:15.544215 [ 622 ] {} system.zookeeper_log (9b7f3409-8c4c-4b42-980f-6c46ad997c3b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:15.544289 [ 622 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.16 GiB. 2024.04.28 18:10:15.545171 [ 795 ] {9b7f3409-8c4c-4b42-980f-6c46ad997c3b::202404_1_6_1} MergeTask::PrepareStage: Merging 6 parts: from 202404_1_1_0 to 202404_6_6_0 into Compact with storage Full 2024.04.28 18:10:15.545404 [ 860 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 30 2024.04.28 18:10:15.545450 [ 860 ] {} SystemLog (system.zookeeper_log): Terminating 2024.04.28 18:10:15.604046 [ 793 ] {bfaaef5a-6281-427e-a93f-de95bc783a5b::202404_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:10:15.612175 [ 793 ] {bfaaef5a-6281-427e-a93f-de95bc783a5b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_1_1_0, total 2 rows starting from the beginning of the part 2024.04.28 18:10:15.644975 [ 793 ] {bfaaef5a-6281-427e-a93f-de95bc783a5b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_2_2_0, total 10 rows starting from the beginning of the part 2024.04.28 18:10:15.648216 [ 795 ] {9b7f3409-8c4c-4b42-980f-6c46ad997c3b::202404_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:10:15.648735 [ 795 ] {9b7f3409-8c4c-4b42-980f-6c46ad997c3b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_1_1_0, total 18 rows starting from the beginning of the part 2024.04.28 18:10:15.650343 [ 795 ] {9b7f3409-8c4c-4b42-980f-6c46ad997c3b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_2_2_0, total 8 rows starting from the beginning of the part 2024.04.28 18:10:15.651901 [ 795 ] {9b7f3409-8c4c-4b42-980f-6c46ad997c3b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_3_3_0, total 1 rows starting from the beginning of the part 2024.04.28 18:10:15.653333 [ 795 ] {9b7f3409-8c4c-4b42-980f-6c46ad997c3b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_4_4_0, total 1 rows starting from the beginning of the part 2024.04.28 18:10:15.654778 [ 795 ] {9b7f3409-8c4c-4b42-980f-6c46ad997c3b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_5_5_0, total 1 rows starting from the beginning of the part 2024.04.28 18:10:15.656381 [ 795 ] {9b7f3409-8c4c-4b42-980f-6c46ad997c3b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_6_6_0, total 1 rows starting from the beginning of the part 2024.04.28 18:10:15.663093 [ 795 ] {} MergeTreeBackgroundExecutor: Code: 236. DB::Exception: Storage is about to be deleted. Done active task as if it was aborted. (ABORTED) 2024.04.28 18:10:15.667451 [ 795 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.35 MiB. 2024.04.28 18:10:15.667966 [ 862 ] {} SystemLog (system.session_log): Flushing system log, 8 entries to flush up to offset 8 2024.04.28 18:10:15.668114 [ 862 ] {} SystemLog (system.session_log): Creating new table system.session_log for SessionLog 2024.04.28 18:10:15.680417 [ 862 ] {} system.session_log (eca900dd-7859-4d34-87cd-08dcbe38b0e2): Loading data parts 2024.04.28 18:10:15.681069 [ 862 ] {} system.session_log (eca900dd-7859-4d34-87cd-08dcbe38b0e2): There are no data parts 2024.04.28 18:10:15.690716 [ 862 ] {} system.session_log (eca900dd-7859-4d34-87cd-08dcbe38b0e2): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:15.690930 [ 862 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.16 GiB. 2024.04.28 18:10:15.695944 [ 862 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:10:15.699384 [ 862 ] {} system.session_log (eca900dd-7859-4d34-87cd-08dcbe38b0e2): Renaming temporary part tmp_insert_202404_1_1_0 to 202404_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:15.701310 [ 862 ] {} SystemLog (system.session_log): Flushed system log up to offset 8 2024.04.28 18:10:15.701357 [ 862 ] {} SystemLog (system.session_log): Terminating 2024.04.28 18:10:15.703121 [ 865 ] {} SystemLog (system.transactions_info_log): Flushing system log, 16 entries to flush up to offset 61 2024.04.28 18:10:15.706165 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:15.706251 [ 865 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.16 GiB. 2024.04.28 18:10:15.708465 [ 865 ] {} MergedBlockOutputStream: filled checksums 202404_6_6_0 (state Temporary) 2024.04.28 18:10:15.710381 [ 865 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Renaming temporary part tmp_insert_202404_6_6_0 to 202404_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.04.28 18:10:15.710897 [ 627 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6) (MergerMutator): Selected 6 parts from 202404_1_1_0 to 202404_6_6_0 2024.04.28 18:10:15.711160 [ 627 ] {} system.transactions_info_log (9ddf6406-654e-4c1c-9d73-af97020662a6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:10:15.711250 [ 627 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 121.16 GiB. 2024.04.28 18:10:15.711734 [ 865 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 61 2024.04.28 18:10:15.711782 [ 865 ] {} SystemLog (system.transactions_info_log): Terminating 2024.04.28 18:10:15.711864 [ 797 ] {9ddf6406-654e-4c1c-9d73-af97020662a6::202404_1_6_1} MergeTask::PrepareStage: Merging 6 parts: from 202404_1_1_0 to 202404_6_6_0 into Compact with storage Full 2024.04.28 18:10:15.712825 [ 797 ] {9ddf6406-654e-4c1c-9d73-af97020662a6::202404_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:10:15.712990 [ 797 ] {9ddf6406-654e-4c1c-9d73-af97020662a6::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_1_1_0, total 7 rows starting from the beginning of the part 2024.04.28 18:10:15.713491 [ 797 ] {9ddf6406-654e-4c1c-9d73-af97020662a6::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_2_2_0, total 7 rows starting from the beginning of the part 2024.04.28 18:10:15.713907 [ 797 ] {9ddf6406-654e-4c1c-9d73-af97020662a6::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_3_3_0, total 13 rows starting from the beginning of the part 2024.04.28 18:10:15.714347 [ 797 ] {9ddf6406-654e-4c1c-9d73-af97020662a6::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_4_4_0, total 6 rows starting from the beginning of the part 2024.04.28 18:10:15.714925 [ 797 ] {9ddf6406-654e-4c1c-9d73-af97020662a6::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_5_5_0, total 12 rows starting from the beginning of the part 2024.04.28 18:10:15.715342 [ 797 ] {9ddf6406-654e-4c1c-9d73-af97020662a6::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_6_6_0, total 16 rows starting from the beginning of the part 2024.04.28 18:10:15.717852 [ 797 ] {} MergeTreeBackgroundExecutor: Code: 236. DB::Exception: Storage is about to be deleted. Done active task as if it was aborted. (ABORTED) 2024.04.28 18:10:15.719104 [ 797 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.18 MiB. 2024.04.28 18:10:15.719355 [ 863 ] {} SystemLog (system.processors_profile_log): Terminating 2024.04.28 18:10:15.719655 [ 864 ] {} SystemLog (system.filesystem_cache_log): Terminating 2024.04.28 18:10:15.719955 [ 861 ] {} SystemLog (system.asynchronous_insert_log): Terminating 2024.04.28 18:10:15.720371 [ 547 ] {} Context: Shutting down database catalog 2024.04.28 18:10:15.720460 [ 547 ] {} DatabaseCatalog: Shutting down database INFORMATION_SCHEMA 2024.04.28 18:10:15.721870 [ 547 ] {} DatabaseCatalog: Shutting down database datasets 2024.04.28 18:10:15.727045 [ 547 ] {} DatabaseCatalog: Shutting down database default 2024.04.28 18:10:15.727085 [ 547 ] {} DatabaseCatalog: Shutting down database information_schema 2024.04.28 18:10:15.728332 [ 547 ] {} DatabaseCatalog: Shutting down database test 2024.04.28 18:10:15.728360 [ 547 ] {} DatabaseCatalog: Shutting down system databases 2024.04.28 18:10:15.783726 [ 793 ] {bfaaef5a-6281-427e-a93f-de95bc783a5b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_3_3_0, total 8 rows starting from the beginning of the part 2024.04.28 18:10:15.924286 [ 793 ] {bfaaef5a-6281-427e-a93f-de95bc783a5b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_4_4_0, total 9 rows starting from the beginning of the part 2024.04.28 18:10:15.954949 [ 793 ] {bfaaef5a-6281-427e-a93f-de95bc783a5b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_5_5_0, total 8 rows starting from the beginning of the part 2024.04.28 18:10:16.094507 [ 793 ] {bfaaef5a-6281-427e-a93f-de95bc783a5b::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_6_6_0, total 7 rows starting from the beginning of the part 2024.04.28 18:10:16.656510 [ 793 ] {} MergeTreeBackgroundExecutor: Code: 236. DB::Exception: Storage is about to be deleted. Done active task as if it was aborted. (ABORTED) 2024.04.28 18:10:16.717152 [ 793 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.15 MiB. 2024.04.28 18:10:16.870712 [ 547 ] {} Context: Shutting down merges executor 2024.04.28 18:10:16.871408 [ 547 ] {} Context: Shutting down fetches executor 2024.04.28 18:10:16.871676 [ 547 ] {} Context: Shutting down moves executor 2024.04.28 18:10:16.871889 [ 547 ] {} Context: Shutting down common executor 2024.04.28 18:10:16.872071 [ 547 ] {} Context: Shutting down DDLWorker 2024.04.28 18:10:16.872217 [ 547 ] {} Context: Shutting down caches 2024.04.28 18:10:16.995462 [ 547 ] {} ExternalUserDefinedExecutableFunctionsLoader: Unloading 'test_function' because its configuration has been removed or detached 2024.04.28 18:10:16.998434 [ 547 ] {} ZooKeeperClient: Finalizing session 2. finalization_started: false, queue_finished: false, reason: 'Destructor called' 2024.04.28 18:10:16.998771 [ 552 ] {} KeeperTCPHandler: Received close event with xid 2147483647 for session id #2 2024.04.28 18:10:16.998810 [ 756 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:10:16.999644 [ 552 ] {} KeeperTCPHandler: Session #2 successfully closed 2024.04.28 18:10:17.001126 [ 547 ] {} BackgroundSchedulePool/BgBufSchPool: Waiting for threads to finish. 2024.04.28 18:10:17.001876 [ 547 ] {} BackgroundSchedulePool/BgSchPool: Waiting for threads to finish. 2024.04.28 18:10:17.003459 [ 547 ] {} BackgroundSchedulePool/BgDistSchPool: Waiting for threads to finish. 2024.04.28 18:10:17.003859 [ 547 ] {} BackgroundSchedulePool/BgMBSchPool: Waiting for threads to finish. 2024.04.28 18:10:17.004339 [ 547 ] {} Application: Shut down storages. 2024.04.28 18:10:17.004373 [ 547 ] {} Application: Waiting for current connections to servers for tables to finish. 2024.04.28 18:10:17.397017 [ 547 ] {} Application: Closed all listening sockets. 2024.04.28 18:10:17.397094 [ 547 ] {} Application: Closed connections to servers for tables. 2024.04.28 18:10:17.397133 [ 547 ] {} KeeperDispatcher: Shutting down storage dispatcher 2024.04.28 18:10:17.604435 [ 547 ] {} RaftInstance: shutting down raft core 2024.04.28 18:10:17.604686 [ 547 ] {} RaftInstance: sent stop signal to the commit thread. 2024.04.28 18:10:17.604750 [ 547 ] {} RaftInstance: cancelled all schedulers. 2024.04.28 18:10:17.604778 [ 547 ] {} RaftInstance: commit thread stopped. 2024.04.28 18:10:17.604818 [ 547 ] {} RaftInstance: all pending commit elements dropped. 2024.04.28 18:10:17.604853 [ 547 ] {} RaftInstance: reset all pointers. 2024.04.28 18:10:17.605565 [ 547 ] {} RaftInstance: joined terminated commit thread. 2024.04.28 18:10:17.605758 [ 547 ] {} RaftInstance: sent stop signal to background append thread. 2024.04.28 18:10:17.605807 [ 785 ] {} RaftInstance: bg append_entries thread terminated 2024.04.28 18:10:17.606029 [ 547 ] {} RaftInstance: clean up auto-forwarding queue: 0 elems 2024.04.28 18:10:17.606088 [ 547 ] {} RaftInstance: clean up auto-forwarding clients 2024.04.28 18:10:17.606147 [ 547 ] {} RaftInstance: raft_server shutdown completed. 2024.04.28 18:10:17.606182 [ 547 ] {} RaftInstance: manually create a snapshot on 17 2024.04.28 18:10:17.606240 [ 547 ] {} RaftInstance: creating a snapshot for index 17 2024.04.28 18:10:17.606279 [ 547 ] {} RaftInstance: create snapshot idx 17 log_term 1 2024.04.28 18:10:17.606318 [ 547 ] {} KeeperStateMachine: Creating snapshot 17 2024.04.28 18:10:17.606399 [ 547 ] {} KeeperStateMachine: Creating a snapshot during shutdown because 'create_snapshot_on_exit' is enabled. 2024.04.28 18:10:17.609000 [ 547 ] {} KeeperStateMachine: Created persistent snapshot 17 with path snapshot_17.bin.zstd 2024.04.28 18:10:17.609051 [ 547 ] {} KeeperStateMachine: Clearing garbage after snapshot 2024.04.28 18:10:17.609082 [ 547 ] {} KeeperStateMachine: Cleared garbage after snapshot 2024.04.28 18:10:17.609136 [ 547 ] {} RaftInstance: snapshot idx 17 log_term 1 created, compact the log store if needed 2024.04.28 18:10:17.609189 [ 547 ] {} KeeperStateMachine: Uploading snapshot snapshot_17.bin.zstd during shutdown because 'upload_snapshot_on_exit' is enabled. 2024.04.28 18:10:17.609233 [ 547 ] {} RaftInstance: create snapshot idx 17 log_term 1 done: 2920 us elapsed 2024.04.28 18:10:17.609432 [ 771 ] {} RaftInstance: failed to accept a rpc connection due to error 125, Operation canceled 2024.04.28 18:10:17.609623 [ 768 ] {} RaftInstance: end of asio worker thread, remaining threads: 15 2024.04.28 18:10:17.609682 [ 775 ] {} RaftInstance: end of asio worker thread, remaining threads: 12 2024.04.28 18:10:17.609652 [ 772 ] {} RaftInstance: end of asio worker thread, remaining threads: 14 2024.04.28 18:10:17.609768 [ 777 ] {} RaftInstance: end of asio worker thread, remaining threads: 10 2024.04.28 18:10:17.609704 [ 778 ] {} RaftInstance: end of asio worker thread, remaining threads: 11 2024.04.28 18:10:17.609777 [ 779 ] {} RaftInstance: end of asio worker thread, remaining threads: 9 2024.04.28 18:10:17.609641 [ 774 ] {} RaftInstance: end of asio worker thread, remaining threads: 13 2024.04.28 18:10:17.610155 [ 780 ] {} RaftInstance: end of asio worker thread, remaining threads: 7 2024.04.28 18:10:17.609831 [ 782 ] {} RaftInstance: end of asio worker thread, remaining threads: 8 2024.04.28 18:10:17.610332 [ 781 ] {} RaftInstance: end of asio worker thread, remaining threads: 4 2024.04.28 18:10:17.610221 [ 769 ] {} RaftInstance: end of asio worker thread, remaining threads: 2 2024.04.28 18:10:17.610101 [ 773 ] {} RaftInstance: end of asio worker thread, remaining threads: 1 2024.04.28 18:10:17.610159 [ 783 ] {} RaftInstance: end of asio worker thread, remaining threads: 6 2024.04.28 18:10:17.610342 [ 776 ] {} RaftInstance: end of asio worker thread, remaining threads: 5 2024.04.28 18:10:17.610359 [ 770 ] {} RaftInstance: end of asio worker thread, remaining threads: 3 2024.04.28 18:10:17.619828 [ 771 ] {} RaftInstance: end of asio worker thread, remaining threads: 0 2024.04.28 18:10:17.620324 [ 765 ] {} KeeperLogStore: Raft server is not set in LogStore. 2024.04.28 18:10:17.621751 [ 547 ] {} KeeperSnapshotManagerS3: Shutting down KeeperSnapshotManagerS3 2024.04.28 18:10:17.621879 [ 547 ] {} KeeperSnapshotManagerS3: KeeperSnapshotManagerS3 shut down 2024.04.28 18:10:17.621920 [ 547 ] {} KeeperDispatcher: Dispatcher shut down 2024.04.28 18:10:17.621962 [ 547 ] {} Context: Destructing remote fs threadpool reader 2024.04.28 18:10:17.621997 [ 547 ] {} Context: Destructing threadpool writer 2024.04.28 18:10:17.622099 [ 547 ] {} Context: Destructing marks loader 2024.04.28 18:10:17.733596 [ 547 ] {} Application: Destroyed global context. 2024.04.28 18:10:17.734369 [ 547 ] {} KeeperLogStore: Changelog is shut down 2024.04.28 18:10:17.744929 [ 547 ] {} Application: shutting down 2024.04.28 18:10:17.744980 [ 547 ] {} Application: Uninitializing subsystem: Logging Subsystem 2024.04.28 18:10:17.751028 [ 550 ] {} BaseDaemon: Received signal -2 2024.04.28 18:10:17.751110 [ 550 ] {} BaseDaemon: Stop SignalListener thread 2024.04.28 18:10:17.957685 [ 545 ] {} Application: Child process exited normally with code 0.