2024.04.28 18:43:56.055135 [ 515 ] {} Application: Will watch for the process with pid 516 2024.04.28 18:43:56.057003 [ 516 ] {} Application: Forked a child process to watch 2024.04.28 18:43:56.057857 [ 516 ] {} SentryWriter: Sending crash reports is disabled 2024.04.28 18:43:56.058084 [ 516 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.04.28 18:43:57.330987 [ 516 ] {} Application: Starting ClickHouse 23.8.11.29.altinitystable (revision: 54477, git hash: 8e9be16153250c8307730c9b88c8517181f494ce, build id: 1F61912BACFB3A8C2B1B19CEF6F3E3500CE60EF1), PID 516 2024.04.28 18:43:57.331864 [ 516 ] {} Application: starting up 2024.04.28 18:43:57.331916 [ 516 ] {} Application: OS name: Linux, version: 5.15.0-73-generic, architecture: x86_64 2024.04.28 18:43:57.360761 [ 516 ] {} Context: ThreadFuzzer is enabled. Application will run slowly and unstable. 2024.04.28 18:43:57.360892 [ 516 ] {} Context: Server was built with sanitizer. It will work slowly. 2024.04.28 18:43:57.361010 [ 516 ] {} Application: Available RAM: 30.61 GiB; physical cores: 16; logical cores: 16. 2024.04.28 18:43:57.365803 [ 516 ] {} 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:43:57.366819 [ 516 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2024.04.28 18:43:57.366907 [ 516 ] {} AsynchronousMetrics: Scanning /sys/block 2024.04.28 18:43:57.367117 [ 516 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2024.04.28 18:43:57.367183 [ 516 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2024.04.28 18:44:37.860479 [ 516 ] {} Application: Integrity check of the executable successfully passed (checksum: C0022111C675897889F4A039A4B9FF26) 2024.04.28 18:44:37.861682 [ 516 ] {} Application: Will do mlock to prevent executable memory from being paged out. It may take a few seconds. 2024.04.28 18:44:37.861755 [ 516 ] {} Application: The memory map of clickhouse executable has been mlock'ed, total 1.17 GiB 2024.04.28 18:44:37.863968 [ 516 ] {} Application: Set max number of file descriptors to 1048576 (was 1024). 2024.04.28 18:44:37.864029 [ 516 ] {} Application: rlimit on number of threads is 18446744073709551615 2024.04.28 18:44:37.864115 [ 516 ] {} Application: Initializing DateLUT. 2024.04.28 18:44:37.864152 [ 516 ] {} Application: Initialized DateLUT with time zone 'Europe/Amsterdam'. 2024.04.28 18:44:37.864269 [ 516 ] {} Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it 2024.04.28 18:44:37.864834 [ 516 ] {} TLDListsHolder: public_suffix_list loading from /etc/clickhouse-server/top_level_domains/public_suffix_list.dat 2024.04.28 18:44:37.880004 [ 516 ] {} TLDListsHolder: public_suffix_list was added (9084 hosts) 2024.04.28 18:44:37.880136 [ 516 ] {} TLDListsHolder: no_new_line_list loading from /etc/clickhouse-server/top_level_domains/no_new_line_list.dat 2024.04.28 18:44:37.880974 [ 516 ] {} TLDListsHolder: no_new_line_list was added (1 hosts) 2024.04.28 18:44:37.881291 [ 516 ] {} 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:44:37.881474 [ 516 ] {} Application: Initializing MergeTree metadata cache, lru_cache_size: 256.00 MiB continue_if_corrupted: true 2024.04.28 18:44:37.902790 [ 516 ] {} Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'e04576d264c0' as replica host. 2024.04.28 18:44:37.902897 [ 516 ] {} Application: Initializing interserver credentials. 2024.04.28 18:44:37.903968 [ 516 ] {} SensitiveDataMaskerConfigRead: 1 query masking rules loaded. 2024.04.28 18:44:37.911540 [ 516 ] {} ConfigReloader: Loading config '/etc/clickhouse-server/config.xml' 2024.04.28 18:44:38.379399 [ 516 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/config.xml', performing update on configuration 2024.04.28 18:44:38.388047 [ 516 ] {} 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:44:38.388137 [ 516 ] {} 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:44:38.388185 [ 516 ] {} Application: Merges and mutations memory limit is set to 15.31 GiB 2024.04.28 18:44:38.399409 [ 516 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.04.28 18:44:38.402214 [ 516 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.04.28 18:44:38.421534 [ 516 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.04.28 18:44:38.423991 [ 516 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.04.28 18:44:38.427692 [ 516 ] {} CertificateReloader: Reloading certificate (/etc/clickhouse-server/server.crt) and key (/etc/clickhouse-server/server.key). 2024.04.28 18:44:38.431005 [ 516 ] {} CertificateReloader: Reloaded certificate (/etc/clickhouse-server/server.crt) and key (/etc/clickhouse-server/server.key). 2024.04.28 18:44:38.431069 [ 516 ] {} CertificateReloader: Initializing certificate reloader. 2024.04.28 18:44:38.437573 [ 516 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/config.xml', performed update on configuration 2024.04.28 18:44:38.440092 [ 516 ] {} Context: Keeper server is participant of the main zookeeper cluster, will try to connect to it 2024.04.28 18:44:38.441456 [ 516 ] {} Context: Cannot connect to ZooKeeper (or Keeper) before internal Keeper start, will wait for Keeper synchronously 2024.04.28 18:44:38.441536 [ 516 ] {} KeeperDispatcher: Initializing storage dispatcher 2024.04.28 18:44:38.442537 [ 516 ] {} KeeperContext: Keeper feature flag FILTERED_LIST: enabled 2024.04.28 18:44:38.442593 [ 516 ] {} KeeperContext: Keeper feature flag MULTI_READ: enabled 2024.04.28 18:44:38.442615 [ 516 ] {} KeeperContext: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.04.28 18:44:38.442744 [ 516 ] {} KeeperContext: Disk type 'azure_blob_storage' is not supported for Keeper 2024.04.28 18:44:38.442801 [ 516 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:44:38.700693 [ 516 ] {} S3Client: Provider type: Unknown 2024.04.28 18:44:38.700815 [ 516 ] {} S3Client: API mode of the S3 client: AWS 2024.04.28 18:44:38.815074 [ 516 ] {} WriteBufferFromS3: Create WriteBufferFromS3, Details: bucket test, key common/clickhouse_remove_objects_capability_db12c38a-81a9-4998-90fc-30030f6e0ecb 2024.04.28 18:44:38.815952 [ 516 ] {} WriteBufferFromS3: finalizeImpl WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_db12c38a-81a9-4998-90fc-30030f6e0ecb. 2024.04.28 18:44:38.818243 [ 899 ] {} HTTPSessionAdapter: Created HTTP(S) session with localhost:11111 (::1:11111) 2024.04.28 18:44:38.821106 [ 899 ] {} WriteBufferFromS3: Single part upload has completed. Details: bucket test, key common/clickhouse_remove_objects_capability_db12c38a-81a9-4998-90fc-30030f6e0ecb, size 4 2024.04.28 18:44:38.821449 [ 516 ] {} WriteBufferFromS3: Close WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_db12c38a-81a9-4998-90fc-30030f6e0ecb. 2024.04.28 18:44:38.825135 [ 516 ] {} S3ObjectStorage: Objects with paths [common/clickhouse_remove_objects_capability_db12c38a-81a9-4998-90fc-30030f6e0ecb] were removed from S3 2024.04.28 18:44:38.846734 [ 516 ] {} S3ObjectStorage: Objects with paths [common/axu/kjtwvewympjpnmrlffbksxmwenzhl] were removed from S3 2024.04.28 18:44:38.846896 [ 516 ] {} DiskObjectStorage(DiskS3): Starting up disk s3_disk 2024.04.28 18:44:38.846955 [ 516 ] {} DiskObjectStorage(DiskS3): Disk s3_disk started up 2024.04.28 18:44:38.847080 [ 516 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:44:38.847130 [ 516 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.04.28 18:44:38.847174 [ 516 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.04.28 18:44:38.847218 [ 516 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.04.28 18:44:38.847272 [ 516 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:44:38.847333 [ 516 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:44:38.847389 [ 516 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:44:38.847464 [ 516 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:44:38.847540 [ 516 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.04.28 18:44:38.848546 [ 516 ] {} KeeperSnapshotManager: Reading from disk LocalSnapshotDisk 2024.04.28 18:44:38.849526 [ 516 ] {} KeeperLogStore: Reading from disk LocalLogDisk 2024.04.28 18:44:38.849676 [ 516 ] {} 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:44:38.850378 [ 516 ] {} KeeperLogStore: force_sync disabled 2024.04.28 18:44:38.850542 [ 516 ] {} KeeperDispatcher: Waiting server to initialize 2024.04.28 18:44:38.850612 [ 516 ] {} KeeperStateMachine: Totally have 0 snapshots 2024.04.28 18:44:38.850662 [ 516 ] {} KeeperStateMachine: No existing snapshots, last committed log index 0 2024.04.28 18:44:38.850811 [ 516 ] {} KeeperLogStore: Removing all changelogs 2024.04.28 18:44:38.850931 [ 516 ] {} Changelog: Starting new changelog changelog_1_100000.bin.zstd 2024.04.28 18:44:38.852276 [ 516 ] {} KeeperServer: Preprocessing 0 log entries 2024.04.28 18:44:38.852330 [ 516 ] {} KeeperServer: Preprocessing done 2024.04.28 18:44:38.852380 [ 516 ] {} KeeperServer: No config in log store and snapshot, probably it's initial run. Will use config from .xml on disk 2024.04.28 18:44:38.852986 [ 516 ] {} 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:44:38.860258 [ 516 ] {} RaftInstance: Raft ASIO listener initiated on :::9234, unsecured 2024.04.28 18:44:38.860445 [ 516 ] {} KeeperStateManager: No state was read 2024.04.28 18:44:38.860521 [ 516 ] {} RaftInstance: invalid election timeout lower bound detected, adjusted to 0 2024.04.28 18:44:38.860575 [ 516 ] {} RaftInstance: invalid election timeout upper bound detected, adjusted to 0 2024.04.28 18:44:38.860643 [ 516 ] {} 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:44:38.860706 [ 516 ] {} RaftInstance: new election timeout range: 0 - 0 2024.04.28 18:44:38.860790 [ 516 ] {} 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:44:38.860869 [ 516 ] {} RaftInstance: peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 2024.04.28 18:44:38.860977 [ 516 ] {} RaftInstance: global manager does not exist. will use local thread for commit and append 2024.04.28 18:44:38.861143 [ 516 ] {} RaftInstance: wait for HB, for 50 + [0, 0] ms 2024.04.28 18:44:38.861445 [ 921 ] {} RaftInstance: bg append_entries thread initiated 2024.04.28 18:44:38.911550 [ 904 ] {} RaftInstance: Election timeout, initiate leader election 2024.04.28 18:44:38.911741 [ 904 ] {} RaftInstance: [PRIORITY] decay, target 1 -> 1, mine 1 2024.04.28 18:44:38.911887 [ 904 ] {} 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:44:38.911959 [ 516 ] {} KeeperDispatcher: Server initialized, waiting for quorum 2024.04.28 18:44:38.914564 [ 904 ] {} 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:44:38.914658 [ 904 ] {} RaftInstance: number of pending commit elements: 0 2024.04.28 18:44:38.914718 [ 904 ] {} RaftInstance: state machine commit index 0, precommit index 0, last log index 0 2024.04.28 18:44:38.914806 [ 904 ] {} RaftInstance: [BECOME LEADER] appended new config at 1 2024.04.28 18:44:38.918524 [ 920 ] {} RaftInstance: config at index 1 is committed, prev config log idx 0 2024.04.28 18:44:38.918616 [ 920 ] {} RaftInstance: new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 2024.04.28 18:44:38.918701 [ 920 ] {} 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:44:38.918811 [ 516 ] {} KeeperDispatcher: Quorum initialized 2024.04.28 18:44:38.919069 [ 516 ] {} KeeperDispatcher: Dispatcher initialized 2024.04.28 18:44:38.920593 [ 516 ] {} Application: Listening for Keeper (tcp): [::]:9181 2024.04.28 18:44:38.920765 [ 516 ] {} Application: Listening for replica communication (interserver): http://[::]:9009 2024.04.28 18:44:38.929153 [ 516 ] {} ConfigReloader: Loading config '/etc/clickhouse-server/users.xml' 2024.04.28 18:44:38.949889 [ 516 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performing update on configuration 2024.04.28 18:44:39.062681 [ 516 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performed update on configuration 2024.04.28 18:44:39.186408 [ 516 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /etc/clickhouse-server/users.xml 2024.04.28 18:44:39.186967 [ 516 ] {} Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist 2024.04.28 18:44:39.187048 [ 516 ] {} Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/ 2024.04.28 18:44:39.191087 [ 516 ] {} Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/ 2024.04.28 18:44:39.194686 [ 516 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.04.28 18:44:39.196137 [ 516 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.04.28 18:44:39.197664 [ 516 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.04.28 18:44:39.198887 [ 516 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.04.28 18:44:39.202065 [ 516 ] {} DNSCacheUpdater: Update period 15 seconds 2024.04.28 18:44:39.202139 [ 516 ] {} Application: Loading metadata from /var/lib/clickhouse/ 2024.04.28 18:44:39.202185 [ 733 ] {} DNSResolver: Updating DNS cache 2024.04.28 18:44:39.203044 [ 733 ] {} DNSResolver: Updated DNS cache 2024.04.28 18:44:39.204867 [ 516 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.04.28 18:44:39.204968 [ 516 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000183995 sec 2024.04.28 18:44:39.205019 [ 516 ] {} ReferentialDeps: No tables 2024.04.28 18:44:39.205067 [ 516 ] {} LoadingDeps: No tables 2024.04.28 18:44:39.205323 [ 516 ] {} DatabaseAtomic (system): Starting up tables. 2024.04.28 18:44:39.205427 [ 516 ] {} SystemLog: Creating system.query_log from query_log 2024.04.28 18:44:39.303456 [ 516 ] {} SystemLog: Creating system.query_thread_log from query_thread_log 2024.04.28 18:44:39.313010 [ 516 ] {} SystemLog: Creating system.part_log from part_log 2024.04.28 18:44:39.320818 [ 516 ] {} SystemLog: Creating system.trace_log from trace_log 2024.04.28 18:44:39.325224 [ 516 ] {} SystemLog: Creating system.crash_log from crash_log 2024.04.28 18:44:39.327506 [ 516 ] {} SystemLog: Creating system.text_log from text_log 2024.04.28 18:44:39.331646 [ 516 ] {} SystemLog: Creating system.metric_log from metric_log 2024.04.28 18:44:39.475286 [ 516 ] {} SystemLog: Creating system.filesystem_cache_log from filesystem_cache_log 2024.04.28 18:44:39.481045 [ 516 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.04.28 18:44:39.481152 [ 516 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2024.04.28 18:44:39.485598 [ 516 ] {} SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log 2024.04.28 18:44:39.491579 [ 516 ] {} SystemLog: Creating system.query_views_log from query_views_log 2024.04.28 18:44:39.498474 [ 516 ] {} SystemLog: Creating system.zookeeper_log from zookeeper_log 2024.04.28 18:44:39.511494 [ 516 ] {} SystemLog: Creating system.session_log from session_log 2024.04.28 18:44:39.521893 [ 516 ] {} SystemLog: Creating system.transactions_info_log from transactions_info_log 2024.04.28 18:44:39.526971 [ 516 ] {} SystemLog: Creating system.processors_profile_log from processors_profile_log 2024.04.28 18:44:39.531999 [ 516 ] {} SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log 2024.04.28 18:44:39.638532 [ 516 ] {} 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:44:40.281845 [ 516 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.04.28 18:44:40.383445 [ 516 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.04.28 18:44:40.383526 [ 516 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000226465 sec 2024.04.28 18:44:40.383572 [ 516 ] {} ReferentialDeps: No tables 2024.04.28 18:44:40.383615 [ 516 ] {} LoadingDeps: No tables 2024.04.28 18:44:40.383871 [ 516 ] {} DatabaseAtomic (default): Starting up tables. 2024.04.28 18:44:40.384157 [ 516 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/ 2024.04.28 18:44:40.384273 [ 516 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.04.28 18:44:40.384339 [ 516 ] {} Application: Loaded metadata. 2024.04.28 18:44:40.384419 [ 516 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.04.28 18:44:40.384595 [ 516 ] {} 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:44:40.385124 [ 516 ] {} 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:44:40.385406 [ 516 ] {} Application: Tasks stats provider: procfs 2024.04.28 18:44:40.393179 [ 516 ] {} AsynchronousMetrics: MemoryTracking: was 4.01 MiB, peak 5.01 MiB, free memory in arenas 0.00 B, will set to 1.60 GiB (RSS), difference: 1.60 GiB 2024.04.28 18:44:40.393306 [ 516 ] {} MemoryTracker: Current memory usage (total): 1.60 GiB. 2024.04.28 18:44:40.471435 [ 741 ] {} WriteBufferFromAzureBlobStorage: Staged block (id: ghsefzvychbqxxpxasigqfefuieusbkcupeqdsmdbhhzclgqykhvoblqabdaszel) of size 4 (blob path: ccscrqcifqokhfahqrkgeopnqpmepcwy). 2024.04.28 18:44:40.485521 [ 741 ] {} WriteBufferFromAzureBlobStorage: Committed 1 blocks for blob `ccscrqcifqokhfahqrkgeopnqpmepcwy` 2024.04.28 18:44:40.516275 [ 741 ] {} DiskObjectStorage(DiskAzureBlobStorage): Starting up disk azure 2024.04.28 18:44:40.516347 [ 741 ] {} DiskObjectStorage(DiskAzureBlobStorage): Disk azure started up 2024.04.28 18:44:40.517582 [ 741 ] {} DiskCache: Registered cached disk (`cached_azure`) with structure: DiskObjectStorage-azure(CachedObjectStorage-cached_azure(AzureObjectStorage)) 2024.04.28 18:44:40.531062 [ 741 ] {} S3Client: Provider type: Unknown 2024.04.28 18:44:40.531137 [ 741 ] {} S3Client: API mode of the S3 client: AWS 2024.04.28 18:44:40.660593 [ 741 ] {} S3ObjectStorage: Objects with paths [common/clickhouse_remove_objects_capability_db12c38a-81a9-4998-90fc-30030f6e0ecb] were removed from S3 2024.04.28 18:44:40.686888 [ 741 ] {} S3ObjectStorage: Objects with paths [common/ywd/gexeklckjaquicfrxwbputjrcngcf] were removed from S3 2024.04.28 18:44:40.687024 [ 741 ] {} DiskObjectStorage(DiskS3): Starting up disk s3_disk 2024.04.28 18:44:40.687078 [ 741 ] {} DiskObjectStorage(DiskS3): Disk s3_disk started up 2024.04.28 18:44:40.687924 [ 741 ] {} DiskCache: Registered cached disk (`s3_cache`) with structure: DiskObjectStorage-s3_disk(CachedObjectStorage-s3_cache(S3ObjectStorage)) 2024.04.28 18:44:40.693545 [ 741 ] {} DiskObjectStorage(Local): Starting up disk local_disk 2024.04.28 18:44:40.693608 [ 741 ] {} DiskObjectStorage(Local): Disk local_disk started up 2024.04.28 18:44:40.698427 [ 741 ] {} DiskObjectStorage(Local): Starting up disk local_disk_2 2024.04.28 18:44:40.698471 [ 741 ] {} DiskObjectStorage(Local): Disk local_disk_2 started up 2024.04.28 18:44:40.804046 [ 741 ] {} DiskObjectStorage(Local): Starting up disk local_disk_3 2024.04.28 18:44:40.804114 [ 741 ] {} DiskObjectStorage(Local): Disk local_disk_3 started up 2024.04.28 18:44:40.805207 [ 741 ] {} DiskCache: Registered cached disk (`local_cache`) with structure: DiskObjectStorage-local_disk(CachedObjectStorage-local_cache(LocalObjectStorage)) 2024.04.28 18:44:40.805951 [ 741 ] {} DiskCache: Registered cached disk (`local_cache_2`) with structure: DiskObjectStorage-local_disk(CachedObjectStorage-local_cache_2(LocalObjectStorage)) 2024.04.28 18:44:40.806605 [ 741 ] {} DiskCache: Registered cached disk (`local_cache_3`) with structure: DiskObjectStorage-local_disk_3(CachedObjectStorage-local_cache_3(LocalObjectStorage)) 2024.04.28 18:44:40.807239 [ 741 ] {} DiskCache: Registered cached disk (`s3_cache_multi`) with structure: DiskObjectStorage-s3_disk(CachedObjectStorage-s3_cache_multi(CachedObjectStorage-s3_cache(S3ObjectStorage))) 2024.04.28 18:44:40.807843 [ 741 ] {} 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:44:40.808582 [ 741 ] {} DatabaseCatalog: Execution took 424 ms. 2024.04.28 18:44:40.810804 [ 516 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 0.000359854 sec. 2024.04.28 18:44:40.813975 [ 516 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/decimals_dictionary.xml'. 2024.04.28 18:44:40.833828 [ 516 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/executable_dictionary.xml'. 2024.04.28 18:44:40.954314 [ 516 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/executable_pool_dictionary.xml'. 2024.04.28 18:44:40.968102 [ 516 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/ints_dictionary.xml'. 2024.04.28 18:44:41.000288 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.60 GiB, peak 1.63 GiB, free memory in arenas 0.00 B, will set to 1.68 GiB (RSS), difference: 81.93 MiB 2024.04.28 18:44:41.005250 [ 516 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/strings_dictionary.xml'. 2024.04.28 18:44:41.127707 [ 516 ] {} ExternalUserDefinedExecutableFunctionsLoader: Loading config file '/etc/clickhouse-server/test_function.xml'. 2024.04.28 18:44:41.136752 [ 516 ] {} ExternalUserDefinedExecutableFunctionsLoader: Will load 'test_function' because always_load_everything flag is set. 2024.04.28 18:44:41.136818 [ 516 ] {} ExternalUserDefinedExecutableFunctionsLoader: Will load the object 'test_function' immediately, force = false, loading_id = 1 2024.04.28 18:44:41.136864 [ 516 ] {} ExternalUserDefinedExecutableFunctionsLoader: Start loading object 'test_function' 2024.04.28 18:44:41.137325 [ 516 ] {} ExternalUserDefinedExecutableFunctionsLoader: Supposed update time for 'test_function' is never (loaded, lifetime 0) 2024.04.28 18:44:41.137397 [ 516 ] {} ExternalUserDefinedExecutableFunctionsLoader: Next update time for 'test_function' was set to 294247-01-10 05:00:54 2024.04.28 18:44:41.137961 [ 516 ] {} Application: Listening for http://[::]:8123 2024.04.28 18:44:41.138237 [ 516 ] {} Application: Listening for https://[::]:8443 2024.04.28 18:44:41.138241 [ 1036 ] {} DDLWorker: Starting DDLWorker thread 2024.04.28 18:44:41.138292 [ 1037 ] {} DDLWorker: Started DDLWorker cleanup thread 2024.04.28 18:44:41.138486 [ 516 ] {} Application: Listening for native protocol (tcp): [::]:9000 2024.04.28 18:44:41.138481 [ 1036 ] {} DDLWorker: Initializing DDLWorker thread 2024.04.28 18:44:41.138622 [ 516 ] {} Application: Listening for native protocol (tcp) with PROXY: [::]:9010 2024.04.28 18:44:41.138891 [ 516 ] {} Application: Listening for secure native protocol (tcp_secure): [::]:9440 2024.04.28 18:44:41.138959 [ 516 ] {} Application: Listening for MySQL compatibility protocol: [::]:9004 2024.04.28 18:44:41.139382 [ 516 ] {} Application: Listening for PostgreSQL compatibility protocol: [::]:9005 2024.04.28 18:44:41.139386 [ 520 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:55336 2024.04.28 18:44:41.139493 [ 516 ] {} Application: Listening for Prometheus: http://[::]:9988 2024.04.28 18:44:41.140512 [ 521 ] {} KeeperTCPHandlerFactory: Keeper request. Address: [::1]:55082 2024.04.28 18:44:41.142994 [ 520 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.04.28 18:44:41.143241 [ 520 ] {} TCP-Session: e0c0d71f-94c6-4bf6-bee8-367003f5fb8b Authenticating user 'default' from [::1]:55336 2024.04.28 18:44:41.143376 [ 520 ] {} TCP-Session: e0c0d71f-94c6-4bf6-bee8-367003f5fb8b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:44:41.143513 [ 520 ] {} TCP-Session: e0c0d71f-94c6-4bf6-bee8-367003f5fb8b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:44:41.144126 [ 521 ] {} KeeperTCPHandler: Requesting session ID for the new client 2024.04.28 18:44:41.144371 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:44:41.145538 [ 920 ] {} KeeperStateMachine: Session ID response 1 with timeout 30000 2024.04.28 18:44:41.145840 [ 521 ] {} KeeperTCPHandler: Received session ID 1 2024.04.28 18:44:41.146104 [ 1036 ] {} ZooKeeperClient: Connected to ZooKeeper at [::1]:9181 with session_id 1 2024.04.28 18:44:41.146571 [ 520 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.04.28 18:44:41.146768 [ 520 ] {} ContextAccess (default): List of all grants: GRANT ALL ON *.* WITH GRANT OPTION 2024.04.28 18:44:41.146879 [ 520 ] {} ContextAccess (default): List of all grants including implicit: GRANT ALL ON *.* WITH GRANT OPTION 2024.04.28 18:44:41.147722 [ 1036 ] {} ZooKeeperClient: Keeper feature flag FILTERED_LIST: enabled 2024.04.28 18:44:41.147882 [ 1036 ] {} ZooKeeperClient: Keeper feature flag MULTI_READ: enabled 2024.04.28 18:44:41.147923 [ 1036 ] {} ZooKeeperClient: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.04.28 18:44:41.148021 [ 1036 ] {} ZooKeeper: Initialized, hosts: localhost:9181 2024.04.28 18:44:41.148161 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 1 2024.04.28 18:44:41.148320 [ 516 ] {} ZooKeeperClient: ZK send fault: 0.002% 2024.04.28 18:44:41.148458 [ 516 ] {} ZooKeeperClient: ZK recv fault: 0.002% 2024.04.28 18:44:41.148890 [ 516 ] {} ZooKeeperClient: ZK send sleep: 0.001% -> 10000ms 2024.04.28 18:44:41.149043 [ 516 ] {} Application: Ready for connections. 2024.04.28 18:44:41.149749 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.04.28 18:44:41.151006 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 85 2024.04.28 18:44:41.151702 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 74 2024.04.28 18:44:41.152486 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 85 2024.04.28 18:44:41.153231 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.04.28 18:44:41.153879 [ 1036 ] {} DDLWorker: Initialized DDLWorker thread 2024.04.28 18:44:41.153963 [ 1036 ] {} DDLWorker: Scheduling tasks 2024.04.28 18:44:41.154030 [ 1037 ] {} DDLWorker: Cleaning queue 2024.04.28 18:44:41.154044 [ 1036 ] {} DDLWorker: Don't have unfinished tasks after restarting 2024.04.28 18:44:41.188388 [ 520 ] {} TCP-Session: e0c0d71f-94c6-4bf6-bee8-367003f5fb8b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.04.28 18:44:41.189753 [ 520 ] {e85f4d03-2fd0-4d71-8c58-07bb71173b93} executeQuery: (from [::1]:55336) SELECT 1 (stage: Complete) 2024.04.28 18:44:41.191391 [ 520 ] {e85f4d03-2fd0-4d71-8c58-07bb71173b93} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.04.28 18:44:41.191860 [ 520 ] {e85f4d03-2fd0-4d71-8c58-07bb71173b93} InterpreterSelectQuery: FetchColumns -> Complete 2024.04.28 18:44:41.208536 [ 520 ] {e85f4d03-2fd0-4d71-8c58-07bb71173b93} executeQuery: Read 1 rows, 1.00 B in 0.019164 sec., 52.18117303276978 rows/sec., 52.18 B/sec. 2024.04.28 18:44:41.209030 [ 520 ] {e85f4d03-2fd0-4d71-8c58-07bb71173b93} TCPHandler: Processed in 0.021125722 sec. 2024.04.28 18:44:41.255140 [ 1036 ] {} 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:44:41.255252 [ 1036 ] {} DDLWorker: No tasks to schedule 2024.04.28 18:44:41.255303 [ 1036 ] {} DDLWorker: Waiting for queue updates 2024.04.28 18:44:41.296871 [ 520 ] {} TCPHandler: Done processing connection. 2024.04.28 18:44:41.297788 [ 520 ] {} TCP-Session: e0c0d71f-94c6-4bf6-bee8-367003f5fb8b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:45:41.498034 [ 521 ] {} KeeperTCPHandler: Session #1 expired 2024.04.28 18:45:41.499461 [ 854 ] {} DNSResolver: Updating DNS cache 2024.04.28 18:45:41.500143 [ 854 ] {} DNSResolver: Updated DNS cache 2024.04.28 18:45:41.500172 [ 923 ] {} KeeperDispatcher: Found dead session 1, will try to close it 2024.04.28 18:45:41.500342 [ 923 ] {} KeeperDispatcher: Dead session close request pushed 2024.04.28 18:45:41.500383 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:45:41.500963 [ 987 ] {} SystemLog (system.trace_log): Flushing system log, 6 entries to flush up to offset 6 2024.04.28 18:45:41.500990 [ 989 ] {} SystemLog (system.zookeeper_log): Flushing system log, 18 entries to flush up to offset 18 2024.04.28 18:45:41.501034 [ 993 ] {} SystemLog (system.query_log): Flushing system log, 2 entries to flush up to offset 2 2024.04.28 18:45:41.501101 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 485 entries to flush up to offset 485 2024.04.28 18:45:41.501419 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.68 GiB, peak 1.68 GiB, free memory in arenas 0.00 B, will set to 1.73 GiB (RSS), difference: 46.61 MiB 2024.04.28 18:45:41.501533 [ 520 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:55340 2024.04.28 18:45:41.501063 [ 992 ] {} SystemLog (system.text_log): Flushing system log, 261 entries to flush up to offset 261 2024.04.28 18:45:41.501102 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 2 entries to flush up to offset 2 2024.04.28 18:45:41.501649 [ 989 ] {} SystemLog (system.zookeeper_log): Creating new table system.zookeeper_log for ZooKeeperLog 2024.04.28 18:45:41.501693 [ 993 ] {} SystemLog (system.query_log): Creating new table system.query_log for QueryLog 2024.04.28 18:45:41.502006 [ 987 ] {} SystemLog (system.trace_log): Creating new table system.trace_log for TraceLog 2024.04.28 18:45:41.502321 [ 992 ] {} SystemLog (system.text_log): Creating new table system.text_log for TextLog 2024.04.28 18:45:41.501977 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog 2024.04.28 18:45:41.503174 [ 994 ] {} SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog 2024.04.28 18:45:41.506338 [ 520 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.04.28 18:45:41.506437 [ 520 ] {} TCP-Session: d818cdea-12ba-45e4-9ebe-db1720884530 Authenticating user 'default' from [::1]:55340 2024.04.28 18:45:41.506541 [ 520 ] {} TCP-Session: d818cdea-12ba-45e4-9ebe-db1720884530 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:45:41.506650 [ 520 ] {} TCP-Session: d818cdea-12ba-45e4-9ebe-db1720884530 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:45:41.534966 [ 990 ] {} StoragePolicy (azure_cache): Storage policy azure_cache created, total volumes 1 2024.04.28 18:45:41.535062 [ 990 ] {} StoragePolicySelector: Storage policy `azure_cache` loaded 2024.04.28 18:45:41.535269 [ 990 ] {} StoragePolicy (s3_cache): Storage policy s3_cache created, total volumes 1 2024.04.28 18:45:41.535297 [ 990 ] {} StoragePolicySelector: Storage policy `s3_cache` loaded 2024.04.28 18:45:41.535469 [ 990 ] {} StoragePolicy (s3_cache_multi): Storage policy s3_cache_multi created, total volumes 1 2024.04.28 18:45:41.535501 [ 990 ] {} StoragePolicySelector: Storage policy `s3_cache_multi` loaded 2024.04.28 18:45:41.535664 [ 990 ] {} StoragePolicy (local_cache): Storage policy local_cache created, total volumes 1 2024.04.28 18:45:41.535698 [ 990 ] {} StoragePolicySelector: Storage policy `local_cache` loaded 2024.04.28 18:45:41.535864 [ 990 ] {} StoragePolicy (local_cache_2): Storage policy local_cache_2 created, total volumes 1 2024.04.28 18:45:41.535892 [ 990 ] {} StoragePolicySelector: Storage policy `local_cache_2` loaded 2024.04.28 18:45:41.536063 [ 990 ] {} StoragePolicy (local_cache_3): Storage policy local_cache_3 created, total volumes 1 2024.04.28 18:45:41.536091 [ 990 ] {} StoragePolicySelector: Storage policy `local_cache_3` loaded 2024.04.28 18:45:41.536176 [ 990 ] {} StoragePolicy (default): Storage policy default created, total volumes 1 2024.04.28 18:45:41.537798 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): Loading data parts 2024.04.28 18:45:41.538031 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): Loading data parts 2024.04.28 18:45:41.539231 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): There are no data parts 2024.04.28 18:45:41.539406 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): There are no data parts 2024.04.28 18:45:41.548991 [ 520 ] {} TCP-Session: d818cdea-12ba-45e4-9ebe-db1720884530 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.04.28 18:45:41.550073 [ 520 ] {3a7e104a-508b-4213-a56c-fa85850c32b2} executeQuery: (from [::1]:55340) SELECT 'Connected to clickhouse-server after attaching gdb' (stage: Complete) 2024.04.28 18:45:41.551814 [ 520 ] {3a7e104a-508b-4213-a56c-fa85850c32b2} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.04.28 18:45:41.552209 [ 520 ] {3a7e104a-508b-4213-a56c-fa85850c32b2} InterpreterSelectQuery: FetchColumns -> Complete 2024.04.28 18:45:41.555374 [ 520 ] {3a7e104a-508b-4213-a56c-fa85850c32b2} executeQuery: Read 1 rows, 1.00 B in 0.005585 sec., 179.05102954341987 rows/sec., 179.05 B/sec. 2024.04.28 18:45:41.555832 [ 520 ] {3a7e104a-508b-4213-a56c-fa85850c32b2} TCPHandler: Processed in 0.007441847 sec. 2024.04.28 18:45:41.623149 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Loading data parts 2024.04.28 18:45:41.623663 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): There are no data parts 2024.04.28 18:45:41.640265 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): Loading data parts 2024.04.28 18:45:41.640760 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): There are no data parts 2024.04.28 18:45:41.642559 [ 520 ] {} TCPHandler: Done processing connection. 2024.04.28 18:45:41.643438 [ 520 ] {} TCP-Session: d818cdea-12ba-45e4-9ebe-db1720884530 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:45:41.651266 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:41.651477 [ 990 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:41.653721 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:41.653937 [ 987 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:41.663794 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:41.663995 [ 989 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:41.664345 [ 993 ] {} system.query_log (4edf58bd-01cc-4b31-a8ec-2333b594a9ee): Loading data parts 2024.04.28 18:45:41.665176 [ 993 ] {} system.query_log (4edf58bd-01cc-4b31-a8ec-2333b594a9ee): There are no data parts 2024.04.28 18:45:41.666133 [ 987 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:45:41.667075 [ 990 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:45:41.672023 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): 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:45:41.672787 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): 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:45:41.677650 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 485 2024.04.28 18:45:41.678022 [ 987 ] {} SystemLog (system.trace_log): Flushed system log up to offset 6 2024.04.28 18:45:41.679363 [ 989 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:45:41.687192 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): 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:45:41.690920 [ 989 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 18 2024.04.28 18:45:41.699629 [ 993 ] {} system.query_log (4edf58bd-01cc-4b31-a8ec-2333b594a9ee): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:41.699913 [ 993 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:41.722106 [ 993 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:45:41.731990 [ 993 ] {} system.query_log (4edf58bd-01cc-4b31-a8ec-2333b594a9ee): 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:45:41.737296 [ 993 ] {} SystemLog (system.query_log): Flushed system log up to offset 2 2024.04.28 18:45:41.739347 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:41.739502 [ 992 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:41.747350 [ 992 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:45:41.751346 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:45:41.753651 [ 992 ] {} SystemLog (system.text_log): Flushed system log up to offset 261 2024.04.28 18:45:41.942767 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): Loading data parts 2024.04.28 18:45:41.943454 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): There are no data parts 2024.04.28 18:45:42.000263 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.72 GiB, peak 1.74 GiB, free memory in arenas 0.00 B, will set to 1.81 GiB (RSS), difference: 86.62 MiB 2024.04.28 18:45:42.034214 [ 1047 ] {} ZooKeeperClient: Code: 210. DB::NetException: Connection reset by peer, while reading from socket ([::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) @ 0x000000004a16c8c9 in /usr/bin/clickhouse 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000002083fc93 in /usr/bin/clickhouse 2. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::NetException::NetException(int, FormatStringHelperImpl::type, std::type_identity::type>, String&&, String&&) @ 0x0000000021092af9 in /usr/bin/clickhouse 3. ./build_docker/./src/IO/ReadBufferFromPocoSocket.cpp:86: DB::ReadBufferFromPocoSocket::nextImpl() @ 0x0000000021091168 in /usr/bin/clickhouse 4. DB::ReadBuffer::readStrict(char*, unsigned long) @ 0x0000000009e5254c in /usr/bin/clickhouse 5. ./build_docker/./src/Common/TransformEndianness.hpp:18: Coordination::ZooKeeper::receiveEvent() @ 0x000000003faf0088 in /usr/bin/clickhouse 6. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: Coordination::ZooKeeper::receiveThread() @ 0x000000003faef042 in /usr/bin/clickhouse 7. ./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*) @ 0x000000003fb03012 in /usr/bin/clickhouse 8. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x0000000020b71bdb in /usr/bin/clickhouse 9. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:303: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x0000000020b807eb in /usr/bin/clickhouse 10. ? @ 0x00007f2f0f2a8ac3 in ? 11. ? @ 0x00007f2f0f33a850 in ? (version 23.8.11.29.altinitystable (altinity build)) 2024.04.28 18:45:42.034404 [ 1047 ] {} ZooKeeperClient: Finalizing session 1. finalization_started: false, queue_finished: false, reason: 'Exception in receiveThread' 2024.04.28 18:45:42.139216 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:42.139367 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:42.232359 [ 1046 ] {} ZooKeeperClient: Code: 210. DB::NetException: I/O error: Broken pipe, while writing to socket ([::1]:55082 -> [::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) @ 0x000000004a16c8c9 in /usr/bin/clickhouse 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000002083fc93 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&&) @ 0x000000002109741f in /usr/bin/clickhouse 3. ./build_docker/./src/IO/WriteBufferFromPocoSocket.cpp:107: DB::WriteBufferFromPocoSocket::nextImpl() @ 0x0000000021095d40 in /usr/bin/clickhouse 4. ./build_docker/./src/IO/WriteBuffer.h:60: Coordination::ZooKeeperRequest::write(DB::WriteBuffer&) const @ 0x000000003fa9bc47 in /usr/bin/clickhouse 5. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:647: Coordination::ZooKeeper::sendThread() @ 0x000000003faed189 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*) @ 0x000000003fb02952 in /usr/bin/clickhouse 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x0000000020b71bdb in /usr/bin/clickhouse 8. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:303: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x0000000020b807eb in /usr/bin/clickhouse 9. ? @ 0x00007f2f0f2a8ac3 in ? 10. ? @ 0x00007f2f0f33a850 in ? (version 23.8.11.29.altinitystable (altinity build)) 2024.04.28 18:45:42.450910 [ 1047 ] {} 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) @ 0x000000004a16c8c9 in /usr/bin/clickhouse 1. ./build_docker/./base/poco/Foundation/src/Exception.cpp:0: Poco::IOException::IOException(String const&, int) @ 0x000000004a17c4ce in /usr/bin/clickhouse 2. ./build_docker/./base/poco/Net/src/NetException.cpp:0: Poco::Net::NetException::NetException(String const&, int) @ 0x0000000049ce4cee in /usr/bin/clickhouse 3. ./build_docker/./base/poco/Net/src/SocketImpl.cpp:995: Poco::Net::SocketImpl::error(int, String const&) @ 0x0000000049d0205a in /usr/bin/clickhouse 4. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: Poco::Net::SocketImpl::shutdown() @ 0x0000000049d06fb9 in /usr/bin/clickhouse 5. ./build_docker/./base/poco/Net/src/StreamSocket.cpp:109: Poco::Net::StreamSocket::shutdown() @ 0x0000000049d11c6e in /usr/bin/clickhouse 6. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:965: Coordination::ZooKeeper::finalize(bool, bool, String const&) @ 0x000000003fadc02f in /usr/bin/clickhouse 7. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: Coordination::ZooKeeper::receiveThread() @ 0x000000003faefbae 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*) @ 0x000000003fb03012 in /usr/bin/clickhouse 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x0000000020b71bdb in /usr/bin/clickhouse 10. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:303: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x0000000020b807eb in /usr/bin/clickhouse 11. ? @ 0x00007f2f0f2a8ac3 in ? 12. ? @ 0x00007f2f0f33a850 in ? (version 23.8.11.29.altinitystable (altinity build)) 2024.04.28 18:45:42.451156 [ 1036 ] {} DDLWorker: Scheduling tasks 2024.04.28 18:45:42.660829 [ 994 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:45:43.000228 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.81 GiB, peak 1.81 GiB, free memory in arenas 0.00 B, will set to 1.84 GiB (RSS), difference: 22.63 MiB 2024.04.28 18:45:43.458646 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): 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:45:43.485697 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 2 2024.04.28 18:45:43.743991 [ 1036 ] {} 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) @ 0x000000004a16c8c9 in /usr/bin/clickhouse 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000002083fc93 in /usr/bin/clickhouse 2. ./build_docker/./src/Common/Exception.h:0: DB::Exception::Exception(int, char const (&) [16]) @ 0x000000002082cfb7 in /usr/bin/clickhouse 3. ./build_docker/./src/Common/ZooKeeper/IKeeper.h:470: Coordination::Exception Coordination::Exception::fromMessage(Coordination::Error, char const (&) [16]) @ 0x000000003fa6d4f6 in /usr/bin/clickhouse 4. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: Coordination::ZooKeeper::pushRequest(Coordination::ZooKeeper::RequestInfo&&) @ 0x000000003faf439c 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>) @ 0x000000003fafe57f 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) @ 0x000000003f9ebb82 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) @ 0x000000003f9eacc6 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) @ 0x000000003f9ed1a7 in /usr/bin/clickhouse 9. ./build_docker/./src/Common/ZooKeeper/ZooKeeper.cpp:0: zkutil::ZooKeeper::tryGetChildren(String const&, std::vector>&, Coordination::Stat*, std::shared_ptr const&, Coordination::ListRequestType) @ 0x000000003f9ec44d 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) @ 0x000000003f9ec06c in /usr/bin/clickhouse 11. ./build_docker/./contrib/llvm-project/libcxx/include/vector:537: DB::DDLWorker::scheduleTasks(bool) @ 0x0000000037a7367a in /usr/bin/clickhouse 12. ./build_docker/./src/Interpreters/DDLWorker.cpp:0: DB::DDLWorker::runMainThread() @ 0x0000000037a67cc9 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()() @ 0x0000000037aab887 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*) @ 0x0000000037aab6df in /usr/bin/clickhouse 15. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x0000000020b71bdb in /usr/bin/clickhouse 16. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:303: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x0000000020b807eb in /usr/bin/clickhouse 17. ? @ 0x00007f2f0f2a8ac3 in ? 18. ? @ 0x00007f2f0f33a850 in ? (version 23.8.11.29.altinitystable (altinity build)) 2024.04.28 18:45:44.744324 [ 1036 ] {} DDLWorker: Initializing DDLWorker thread 2024.04.28 18:45:44.744446 [ 1036 ] {} Context: Trying to establish a new connection with ZooKeeper 2024.04.28 18:45:44.745207 [ 521 ] {} KeeperTCPHandlerFactory: Keeper request. Address: [::1]:36346 2024.04.28 18:45:44.747591 [ 521 ] {} KeeperTCPHandler: Requesting session ID for the new client 2024.04.28 18:45:44.747796 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:45:44.748168 [ 920 ] {} KeeperStateMachine: Session ID response 2 with timeout 30000 2024.04.28 18:45:44.748322 [ 521 ] {} KeeperTCPHandler: Received session ID 2 2024.04.28 18:45:44.748504 [ 1036 ] {} ZooKeeperClient: Connected to ZooKeeper at [::1]:9181 with session_id 2 2024.04.28 18:45:44.749199 [ 1036 ] {} ZooKeeperClient: Keeper feature flag FILTERED_LIST: enabled 2024.04.28 18:45:44.749251 [ 1036 ] {} ZooKeeperClient: Keeper feature flag MULTI_READ: enabled 2024.04.28 18:45:44.749295 [ 1036 ] {} ZooKeeperClient: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.04.28 18:45:44.749355 [ 1036 ] {} ZooKeeper: Initialized, hosts: localhost:9181 2024.04.28 18:45:44.749449 [ 1036 ] {} ZooKeeperClient: ZK send fault: 0.002% 2024.04.28 18:45:44.749479 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 1 2024.04.28 18:45:44.749516 [ 1036 ] {} ZooKeeperClient: ZK recv fault: 0.002% 2024.04.28 18:45:44.749568 [ 1036 ] {} ZooKeeperClient: ZK send sleep: 0.001% -> 10000ms 2024.04.28 18:45:44.749618 [ 1036 ] {} Context: Establishing a new connection with ZooKeeper took 5 ms 2024.04.28 18:45:44.750474 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.04.28 18:45:44.851780 [ 1036 ] {} DDLWorker: Initialized DDLWorker thread 2024.04.28 18:45:44.851874 [ 1036 ] {} DDLWorker: Scheduling tasks 2024.04.28 18:45:44.851909 [ 1036 ] {} DDLWorker: Don't have unfinished tasks after restarting 2024.04.28 18:45:44.851931 [ 1037 ] {} DDLWorker: Cleaning queue 2024.04.28 18:45:44.852562 [ 1036 ] {} 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:45:44.852633 [ 1036 ] {} DDLWorker: No tasks to schedule 2024.04.28 18:45:44.852678 [ 1036 ] {} DDLWorker: Waiting for queue updates 2024.04.28 18:45:45.000227 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.84 GiB, peak 1.84 GiB, free memory in arenas 0.00 B, will set to 1.84 GiB (RSS), difference: 2.41 MiB 2024.04.28 18:45:45.754270 [ 992 ] {} SystemLog (system.text_log): Flushing system log, 115 entries to flush up to offset 376 2024.04.28 18:45:45.766227 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:45.766330 [ 992 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:45.772827 [ 992 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:45:45.777367 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:45:45.779469 [ 992 ] {} SystemLog (system.text_log): Flushed system log up to offset 376 2024.04.28 18:45:46.000230 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.84 GiB, peak 1.84 GiB, free memory in arenas 0.00 B, will set to 1.84 GiB (RSS), difference: 1.20 MiB 2024.04.28 18:45:48.678048 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2824 entries to flush up to offset 3309 2024.04.28 18:45:48.802973 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:48.803090 [ 990 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:48.812363 [ 990 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:45:48.815482 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): 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:45:48.817882 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 3309 2024.04.28 18:45:49.000233 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.84 GiB, peak 1.85 GiB, free memory in arenas 0.00 B, will set to 1.84 GiB (RSS), difference: 1.54 MiB 2024.04.28 18:45:49.001231 [ 996 ] {} SystemLog (system.transactions_info_log): Flushing system log, 8 entries to flush up to offset 8 2024.04.28 18:45:49.001450 [ 996 ] {} SystemLog (system.transactions_info_log): Creating new table system.transactions_info_log for TransactionsInfoLog 2024.04.28 18:45:49.024529 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): Loading data parts 2024.04.28 18:45:49.025769 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): There are no data parts 2024.04.28 18:45:49.036042 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:49.036146 [ 996 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:49.043451 [ 996 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:45:49.149258 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): 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:45:49.151826 [ 996 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 8 2024.04.28 18:45:49.178328 [ 987 ] {} SystemLog (system.trace_log): Flushing system log, 18 entries to flush up to offset 24 2024.04.28 18:45:49.187603 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:49.187703 [ 987 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:49.191187 [ 989 ] {} SystemLog (system.zookeeper_log): Flushing system log, 10 entries to flush up to offset 28 2024.04.28 18:45:49.194122 [ 987 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:45:49.213082 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:49.213198 [ 989 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:49.222847 [ 989 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:45:49.229461 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): 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:45:49.232392 [ 989 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 28 2024.04.28 18:45:49.237845 [ 993 ] {} SystemLog (system.query_log): Flushing system log, 2 entries to flush up to offset 4 2024.04.28 18:45:49.298890 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): 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:45:49.301560 [ 987 ] {} SystemLog (system.trace_log): Flushed system log up to offset 24 2024.04.28 18:45:49.374013 [ 993 ] {} system.query_log (4edf58bd-01cc-4b31-a8ec-2333b594a9ee): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:49.374181 [ 993 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:49.395449 [ 993 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:45:49.404636 [ 993 ] {} system.query_log (4edf58bd-01cc-4b31-a8ec-2333b594a9ee): 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:45:49.409165 [ 993 ] {} SystemLog (system.query_log): Flushed system log up to offset 4 2024.04.28 18:45:49.779945 [ 992 ] {} SystemLog (system.text_log): Flushing system log, 41 entries to flush up to offset 417 2024.04.28 18:45:49.786238 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:49.786359 [ 992 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.41 GiB. 2024.04.28 18:45:49.792527 [ 992 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:45:49.797006 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:45:49.899390 [ 992 ] {} SystemLog (system.text_log): Flushed system log up to offset 417 2024.04.28 18:45:50.000210 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.84 GiB, peak 1.85 GiB, free memory in arenas 0.00 B, will set to 1.85 GiB (RSS), difference: 5.99 MiB 2024.04.28 18:45:50.986004 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 11 entries to flush up to offset 13 2024.04.28 18:45:51.652713 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:51.652909 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.24 GiB. 2024.04.28 18:45:51.988879 [ 994 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:45:52.000248 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.85 GiB, peak 1.85 GiB, free memory in arenas 0.00 B, will set to 1.87 GiB (RSS), difference: 17.23 MiB 2024.04.28 18:45:52.180700 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): 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:45:52.206211 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 13 2024.04.28 18:45:53.000251 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.87 GiB, peak 1.87 GiB, free memory in arenas 0.00 B, will set to 1.86 GiB (RSS), difference: -2.28 MiB 2024.04.28 18:45:53.899739 [ 992 ] {} SystemLog (system.text_log): Flushing system log, 15 entries to flush up to offset 432 2024.04.28 18:45:53.906677 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:53.906806 [ 992 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 117.03 GiB. 2024.04.28 18:45:53.913449 [ 992 ] {} MergedBlockOutputStream: filled checksums 202404_4_4_0 (state Temporary) 2024.04.28 18:45:53.917741 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:45:53.919742 [ 992 ] {} SystemLog (system.text_log): Flushed system log up to offset 432 2024.04.28 18:45:54.748895 [ 521 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.04.28 18:45:54.748954 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:45:55.819002 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2471 entries to flush up to offset 5780 2024.04.28 18:45:55.841327 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:55.841484 [ 990 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.85 GiB. 2024.04.28 18:45:55.853329 [ 990 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:45:55.857703 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): 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:45:55.860497 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 5780 2024.04.28 18:45:56.500434 [ 745 ] {} DNSResolver: Updating DNS cache 2024.04.28 18:45:56.501174 [ 745 ] {} DNSResolver: Updated DNS cache 2024.04.28 18:45:56.652067 [ 996 ] {} SystemLog (system.transactions_info_log): Flushing system log, 8 entries to flush up to offset 16 2024.04.28 18:45:56.661167 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:56.661288 [ 996 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.77 GiB. 2024.04.28 18:45:56.667537 [ 996 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:45:56.672953 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): 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:45:56.675420 [ 996 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 16 2024.04.28 18:45:56.732698 [ 989 ] {} SystemLog (system.zookeeper_log): Flushing system log, 1 entries to flush up to offset 29 2024.04.28 18:45:56.741623 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:56.741730 [ 989 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.77 GiB. 2024.04.28 18:45:56.801832 [ 987 ] {} SystemLog (system.trace_log): Flushing system log, 5 entries to flush up to offset 29 2024.04.28 18:45:56.807761 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:56.807863 [ 987 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.76 GiB. 2024.04.28 18:45:56.815273 [ 987 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:45:56.822275 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): 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:45:56.824933 [ 987 ] {} SystemLog (system.trace_log): Flushed system log up to offset 29 2024.04.28 18:45:56.854888 [ 989 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:45:56.863841 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): 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:45:56.867542 [ 989 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 29 2024.04.28 18:45:57.000194 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.86 GiB, peak 1.87 GiB, free memory in arenas 0.00 B, will set to 1.86 GiB (RSS), difference: -1.92 MiB 2024.04.28 18:45:57.919956 [ 992 ] {} SystemLog (system.text_log): Flushing system log, 35 entries to flush up to offset 467 2024.04.28 18:45:57.925633 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:45:57.925732 [ 992 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.65 GiB. 2024.04.28 18:45:57.932188 [ 992 ] {} MergedBlockOutputStream: filled checksums 202404_5_5_0 (state Temporary) 2024.04.28 18:45:57.936905 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:45:57.939611 [ 992 ] {} SystemLog (system.text_log): Flushed system log up to offset 467 2024.04.28 18:45:59.706449 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 9 entries to flush up to offset 22 2024.04.28 18:46:00.000272 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.86 GiB, peak 1.87 GiB, free memory in arenas 0.00 B, will set to 1.87 GiB (RSS), difference: 3.52 MiB 2024.04.28 18:46:00.417126 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:00.417254 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.42 GiB. 2024.04.28 18:46:01.000232 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.87 GiB, peak 1.87 GiB, free memory in arenas 0.00 B, will set to 1.88 GiB (RSS), difference: 5.40 MiB 2024.04.28 18:46:01.055053 [ 994 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:46:01.379942 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): 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:46:01.614246 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 22 2024.04.28 18:46:01.939939 [ 992 ] {} SystemLog (system.text_log): Flushing system log, 14 entries to flush up to offset 481 2024.04.28 18:46:01.946355 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:01.946486 [ 992 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.29 GiB. 2024.04.28 18:46:01.954420 [ 992 ] {} MergedBlockOutputStream: filled checksums 202404_6_6_0 (state Temporary) 2024.04.28 18:46:02.000247 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.87 GiB, peak 1.88 GiB, free memory in arenas 0.00 B, will set to 1.88 GiB (RSS), difference: 8.02 MiB 2024.04.28 18:46:02.160996 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:46:02.161937 [ 784 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959) (MergerMutator): Selected 6 parts from 202404_1_1_0 to 202404_6_6_0 2024.04.28 18:46:02.162382 [ 784 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:02.162823 [ 784 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.26 GiB. 2024.04.28 18:46:02.164022 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::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:46:02.164472 [ 992 ] {} SystemLog (system.text_log): Flushed system log up to offset 481 2024.04.28 18:46:02.166241 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:46:02.166831 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_1_1_0, total 261 rows starting from the beginning of the part 2024.04.28 18:46:02.168372 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_2_2_0, total 115 rows starting from the beginning of the part 2024.04.28 18:46:02.169169 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_3_3_0, total 41 rows starting from the beginning of the part 2024.04.28 18:46:02.169977 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::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:46:02.170974 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_5_5_0, total 35 rows starting from the beginning of the part 2024.04.28 18:46:02.171887 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_6_6_0, total 14 rows starting from the beginning of the part 2024.04.28 18:46:02.194736 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_6_1} MergeTask::MergeProjectionsStage: Merge sorted 481 rows, containing 13 columns (13 merged, 0 gathered) in 0.031317917 sec., 15358.620434430553 rows/sec., 2.04 MiB/sec. 2024.04.28 18:46:02.198071 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_6_1} MergedBlockOutputStream: filled checksums 202404_1_6_1 (state Temporary) 2024.04.28 18:46:02.204958 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_6_1} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:46:02.205275 [ 928 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_6_1} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959) (MergerMutator): Merged 6 parts: [202404_1_1_0, 202404_6_6_0] -> 202404_1_6_1 2024.04.28 18:46:02.308006 [ 928 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 5.16 MiB. 2024.04.28 18:46:02.861507 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2471 entries to flush up to offset 8251 2024.04.28 18:46:02.883169 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:02.883320 [ 990 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.98 GiB. 2024.04.28 18:46:02.995364 [ 990 ] {} MergedBlockOutputStream: filled checksums 202404_4_4_0 (state Temporary) 2024.04.28 18:46:02.999866 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): 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:46:03.000169 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.89 GiB, peak 1.89 GiB, free memory in arenas 0.00 B, will set to 1.89 GiB (RSS), difference: 3.50 MiB 2024.04.28 18:46:03.003645 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 8251 2024.04.28 18:46:04.000234 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.88 GiB, peak 1.89 GiB, free memory in arenas 0.00 B, will set to 1.88 GiB (RSS), difference: -4.63 MiB 2024.04.28 18:46:04.175638 [ 996 ] {} SystemLog (system.transactions_info_log): Flushing system log, 14 entries to flush up to offset 30 2024.04.28 18:46:04.181453 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:04.181577 [ 996 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.22 GiB. 2024.04.28 18:46:04.188423 [ 996 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:46:04.194097 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): 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:46:04.196424 [ 996 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 30 2024.04.28 18:46:04.325213 [ 987 ] {} SystemLog (system.trace_log): Flushing system log, 12 entries to flush up to offset 41 2024.04.28 18:46:04.331329 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:04.331442 [ 987 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.22 GiB. 2024.04.28 18:46:04.337786 [ 987 ] {} MergedBlockOutputStream: filled checksums 202404_4_4_0 (state Temporary) 2024.04.28 18:46:04.342266 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): 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:46:04.344595 [ 987 ] {} SystemLog (system.trace_log): Flushed system log up to offset 41 2024.04.28 18:46:04.748909 [ 521 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.04.28 18:46:04.749047 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:46:06.164766 [ 992 ] {} SystemLog (system.text_log): Flushing system log, 45 entries to flush up to offset 526 2024.04.28 18:46:06.171205 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:06.171316 [ 992 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.22 GiB. 2024.04.28 18:46:06.177083 [ 992 ] {} MergedBlockOutputStream: filled checksums 202404_7_7_0 (state Temporary) 2024.04.28 18:46:06.181413 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:46:06.183889 [ 992 ] {} SystemLog (system.text_log): Flushed system log up to offset 526 2024.04.28 18:46:07.000278 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.88 GiB, peak 1.89 GiB, free memory in arenas 0.00 B, will set to 1.88 GiB (RSS), difference: -2.36 MiB 2024.04.28 18:46:09.114748 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 9 entries to flush up to offset 31 2024.04.28 18:46:09.704767 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:09.704902 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.22 GiB. 2024.04.28 18:46:10.000233 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.88 GiB, peak 1.89 GiB, free memory in arenas 0.00 B, will set to 1.89 GiB (RSS), difference: 9.95 MiB 2024.04.28 18:46:10.004471 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2471 entries to flush up to offset 10722 2024.04.28 18:46:10.023178 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:10.023285 [ 990 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.22 GiB. 2024.04.28 18:46:10.031685 [ 990 ] {} MergedBlockOutputStream: filled checksums 202404_5_5_0 (state Temporary) 2024.04.28 18:46:10.034823 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): 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:46:10.035857 [ 994 ] {} MergedBlockOutputStream: filled checksums 202404_4_4_0 (state Temporary) 2024.04.28 18:46:10.037767 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 10722 2024.04.28 18:46:10.184189 [ 992 ] {} SystemLog (system.text_log): Flushing system log, 18 entries to flush up to offset 544 2024.04.28 18:46:10.189851 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:10.189951 [ 992 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.22 GiB. 2024.04.28 18:46:10.238777 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): 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:46:10.268265 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 31 2024.04.28 18:46:10.296855 [ 992 ] {} MergedBlockOutputStream: filled checksums 202404_8_8_0 (state Temporary) 2024.04.28 18:46:10.301878 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:46:10.405195 [ 992 ] {} SystemLog (system.text_log): Flushed system log up to offset 544 2024.04.28 18:46:11.000221 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.89 GiB, peak 1.90 GiB, free memory in arenas 0.00 B, will set to 1.89 GiB (RSS), difference: -1.20 MiB 2024.04.28 18:46:11.501432 [ 841 ] {} DNSResolver: Updating DNS cache 2024.04.28 18:46:11.502102 [ 841 ] {} DNSResolver: Updated DNS cache 2024.04.28 18:46:11.696687 [ 996 ] {} SystemLog (system.transactions_info_log): Flushing system log, 6 entries to flush up to offset 36 2024.04.28 18:46:11.701268 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:11.701370 [ 996 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.22 GiB. 2024.04.28 18:46:11.706666 [ 996 ] {} MergedBlockOutputStream: filled checksums 202404_4_4_0 (state Temporary) 2024.04.28 18:46:11.711319 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): 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:46:11.713355 [ 996 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 36 2024.04.28 18:46:11.844913 [ 987 ] {} SystemLog (system.trace_log): Flushing system log, 4 entries to flush up to offset 45 2024.04.28 18:46:11.851560 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:11.851700 [ 987 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.22 GiB. 2024.04.28 18:46:11.867874 [ 989 ] {} SystemLog (system.zookeeper_log): Flushing system log, 1 entries to flush up to offset 30 2024.04.28 18:46:11.959680 [ 987 ] {} MergedBlockOutputStream: filled checksums 202404_5_5_0 (state Temporary) 2024.04.28 18:46:11.965815 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): 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:46:12.000223 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.89 GiB, peak 1.90 GiB, free memory in arenas 0.00 B, will set to 1.89 GiB (RSS), difference: 1.29 MiB 2024.04.28 18:46:12.068626 [ 987 ] {} SystemLog (system.trace_log): Flushed system log up to offset 45 2024.04.28 18:46:12.079006 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:12.079138 [ 989 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.22 GiB. 2024.04.28 18:46:12.089326 [ 989 ] {} MergedBlockOutputStream: filled checksums 202404_4_4_0 (state Temporary) 2024.04.28 18:46:12.097836 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): 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:46:12.101451 [ 989 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 30 2024.04.28 18:46:13.000270 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.89 GiB, peak 1.90 GiB, free memory in arenas 0.00 B, will set to 1.88 GiB (RSS), difference: -3.11 MiB 2024.04.28 18:46:14.407538 [ 992 ] {} SystemLog (system.text_log): Flushing system log, 31 entries to flush up to offset 575 2024.04.28 18:46:14.413884 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:14.413990 [ 992 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 116.01 GiB. 2024.04.28 18:46:14.420299 [ 992 ] {} MergedBlockOutputStream: filled checksums 202404_9_9_0 (state Temporary) 2024.04.28 18:46:14.424799 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:46:14.427387 [ 992 ] {} SystemLog (system.text_log): Flushed system log up to offset 575 2024.04.28 18:46:14.748843 [ 521 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.04.28 18:46:14.748952 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:46:17.039031 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2824 entries to flush up to offset 13546 2024.04.28 18:46:17.167371 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:17.167514 [ 990 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.82 GiB. 2024.04.28 18:46:17.179342 [ 990 ] {} MergedBlockOutputStream: filled checksums 202404_6_6_0 (state Temporary) 2024.04.28 18:46:17.183608 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): 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:46:17.184127 [ 747 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0) (MergerMutator): Selected 6 parts from 202404_1_1_0 to 202404_6_6_0 2024.04.28 18:46:17.184239 [ 747 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:17.184371 [ 747 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.82 GiB. 2024.04.28 18:46:17.185214 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::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:46:17.186251 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::202404_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:46:17.186433 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_1_1_0, total 485 rows starting from the beginning of the part 2024.04.28 18:46:17.187091 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::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:46:17.187094 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 13546 2024.04.28 18:46:17.187498 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::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:46:17.187860 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::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:46:17.188231 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::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:46:17.188652 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_6_6_0, total 2824 rows starting from the beginning of the part 2024.04.28 18:46:17.230694 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::202404_1_6_1} MergeTask::MergeProjectionsStage: Merge sorted 13546 rows, containing 4 columns (4 merged, 0 gathered) in 0.045839833 sec., 295507.1847665762 rows/sec., 4.51 MiB/sec. 2024.04.28 18:46:17.234144 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::202404_1_6_1} MergedBlockOutputStream: filled checksums 202404_1_6_1 (state Temporary) 2024.04.28 18:46:17.237872 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::202404_1_6_1} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): 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:46:17.238115 [ 930 ] {63bb866d-3c1c-4481-b76c-3bd57dc742e0::202404_1_6_1} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0) (MergerMutator): Merged 6 parts: [202404_1_1_0, 202404_6_6_0] -> 202404_1_6_1 2024.04.28 18:46:17.240864 [ 930 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 8.16 MiB. 2024.04.28 18:46:17.768651 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 9 entries to flush up to offset 40 2024.04.28 18:46:18.000224 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.88 GiB, peak 1.90 GiB, free memory in arenas 0.00 B, will set to 1.89 GiB (RSS), difference: 8.49 MiB 2024.04.28 18:46:18.427673 [ 992 ] {} SystemLog (system.text_log): Flushing system log, 32 entries to flush up to offset 607 2024.04.28 18:46:18.434429 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:18.434640 [ 992 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.74 GiB. 2024.04.28 18:46:18.440752 [ 992 ] {} MergedBlockOutputStream: filled checksums 202404_10_10_0 (state Temporary) 2024.04.28 18:46:18.445538 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:46:18.448046 [ 992 ] {} SystemLog (system.text_log): Flushed system log up to offset 607 2024.04.28 18:46:18.588729 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:18.588864 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.72 GiB. 2024.04.28 18:46:19.000229 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.90 GiB, peak 1.90 GiB, free memory in arenas 0.00 B, will set to 1.90 GiB (RSS), difference: 4.40 MiB 2024.04.28 18:46:19.034084 [ 994 ] {} MergedBlockOutputStream: filled checksums 202404_5_5_0 (state Temporary) 2024.04.28 18:46:19.213563 [ 996 ] {} SystemLog (system.transactions_info_log): Flushing system log, 13 entries to flush up to offset 49 2024.04.28 18:46:19.219437 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:19.219565 [ 996 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.47 GiB. 2024.04.28 18:46:19.224912 [ 996 ] {} MergedBlockOutputStream: filled checksums 202404_5_5_0 (state Temporary) 2024.04.28 18:46:19.229900 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): 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:46:19.231893 [ 996 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 49 2024.04.28 18:46:19.366247 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): 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:46:19.403749 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 40 2024.04.28 18:46:19.568979 [ 987 ] {} SystemLog (system.trace_log): Flushing system log, 18 entries to flush up to offset 63 2024.04.28 18:46:19.601674 [ 989 ] {} SystemLog (system.zookeeper_log): Flushing system log, 1 entries to flush up to offset 31 2024.04.28 18:46:19.611598 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:19.611710 [ 989 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:19.622242 [ 989 ] {} MergedBlockOutputStream: filled checksums 202404_5_5_0 (state Temporary) 2024.04.28 18:46:19.628847 [ 989 ] {} system.zookeeper_log (77cb0483-fc05-4b62-ac83-1d6810bcccea): 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:46:19.632304 [ 989 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 31 2024.04.28 18:46:19.642072 [ 998 ] {} SystemLog (system.session_log): Flushing system log, 4 entries to flush up to offset 4 2024.04.28 18:46:19.642258 [ 998 ] {} SystemLog (system.session_log): Creating new table system.session_log for SessionLog 2024.04.28 18:46:19.665577 [ 998 ] {} system.session_log (80f170e8-4521-4a89-bb4f-7ca429c6b39a): Loading data parts 2024.04.28 18:46:19.667079 [ 998 ] {} system.session_log (80f170e8-4521-4a89-bb4f-7ca429c6b39a): There are no data parts 2024.04.28 18:46:19.675912 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:19.676085 [ 987 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:19.681115 [ 998 ] {} system.session_log (80f170e8-4521-4a89-bb4f-7ca429c6b39a): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:19.681239 [ 998 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:19.684361 [ 987 ] {} MergedBlockOutputStream: filled checksums 202404_6_6_0 (state Temporary) 2024.04.28 18:46:19.691671 [ 998 ] {} MergedBlockOutputStream: filled checksums 202404_1_1_0 (state Temporary) 2024.04.28 18:46:19.696990 [ 998 ] {} system.session_log (80f170e8-4521-4a89-bb4f-7ca429c6b39a): 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:46:19.697424 [ 520 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:53668 2024.04.28 18:46:19.699244 [ 520 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.04.28 18:46:19.699364 [ 520 ] {} TCP-Session: 5eb47f13-c49d-4196-ad30-a88aa432e8f0 Authenticating user 'default' from [::1]:53668 2024.04.28 18:46:19.699455 [ 520 ] {} TCP-Session: 5eb47f13-c49d-4196-ad30-a88aa432e8f0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:46:19.699522 [ 520 ] {} TCP-Session: 5eb47f13-c49d-4196-ad30-a88aa432e8f0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:46:19.700315 [ 998 ] {} SystemLog (system.session_log): Flushed system log up to offset 4 2024.04.28 18:46:19.741984 [ 520 ] {} TCP-Session: 5eb47f13-c49d-4196-ad30-a88aa432e8f0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.04.28 18:46:19.743623 [ 520 ] {c3cf10ee-b4b4-4a57-a48b-9ebb340a4131} executeQuery: (from [::1]:53668) ATTACH DATABASE IF NOT EXISTS datasets ENGINE = Ordinary (stage: Complete) 2024.04.28 18:46:19.744099 [ 520 ] {c3cf10ee-b4b4-4a57-a48b-9ebb340a4131} ContextAccess (default): Access granted: CREATE DATABASE ON datasets.* 2024.04.28 18:46:19.761673 [ 520 ] {c3cf10ee-b4b4-4a57-a48b-9ebb340a4131} DatabaseOrdinary (datasets): Metadata processed, database datasets has 2 tables and 0 dictionaries in total. 2024.04.28 18:46:19.761791 [ 520 ] {c3cf10ee-b4b4-4a57-a48b-9ebb340a4131} TablesLoader: Parsed metadata of 2 tables in 1 databases in 0.017087608 sec 2024.04.28 18:46:19.762753 [ 520 ] {c3cf10ee-b4b4-4a57-a48b-9ebb340a4131} ReferentialDeps: No tables 2024.04.28 18:46:19.762922 [ 520 ] {c3cf10ee-b4b4-4a57-a48b-9ebb340a4131} LoadingDeps: Table datasets.visits_v1 has no dependencies (level 0) 2024.04.28 18:46:19.763018 [ 520 ] {c3cf10ee-b4b4-4a57-a48b-9ebb340a4131} LoadingDeps: Table datasets.hits_v1 has no dependencies (level 0) 2024.04.28 18:46:19.763298 [ 520 ] {c3cf10ee-b4b4-4a57-a48b-9ebb340a4131} TablesLoader: Loading 2 tables with dependency level 0 2024.04.28 18:46:19.791378 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): 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:46:19.792218 [ 770 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd) (MergerMutator): Selected 6 parts from 202404_1_1_0 to 202404_6_6_0 2024.04.28 18:46:19.792533 [ 770 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:19.792641 [ 770 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:19.793704 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::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:46:19.794784 [ 987 ] {} SystemLog (system.trace_log): Flushed system log up to offset 63 2024.04.28 18:46:19.796189 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::202404_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:46:19.796577 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_1_1_0, total 6 rows starting from the beginning of the part 2024.04.28 18:46:19.797667 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_2_2_0, total 18 rows starting from the beginning of the part 2024.04.28 18:46:19.798664 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_3_3_0, total 5 rows starting from the beginning of the part 2024.04.28 18:46:19.799457 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_4_4_0, total 12 rows starting from the beginning of the part 2024.04.28 18:46:19.800206 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_5_5_0, total 4 rows starting from the beginning of the part 2024.04.28 18:46:19.800741 [ 1086 ] {} datasets.hits_v1: Loading data parts 2024.04.28 18:46:19.801013 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_6_6_0, total 18 rows starting from the beginning of the part 2024.04.28 18:46:19.801759 [ 1086 ] {} datasets.hits_v1: Will load 1 parts using up to 64 threads 2024.04.28 18:46:19.801988 [ 1087 ] {} datasets.hits_v1: Loading Active part 201403_10_18_2 from disk default 2024.04.28 18:46:19.806831 [ 1085 ] {} datasets.visits_v1: Loading data parts 2024.04.28 18:46:19.807607 [ 1085 ] {} datasets.visits_v1: Will load 1 parts using up to 64 threads 2024.04.28 18:46:19.807741 [ 1088 ] {} datasets.visits_v1: Loading Active part 20140317_20140323_3_4_1 from disk default 2024.04.28 18:46:19.817676 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::202404_1_6_1} MergeTask::MergeProjectionsStage: Merge sorted 63 rows, containing 13 columns (13 merged, 0 gathered) in 0.024541878 sec., 2567.0407130212284 rows/sec., 844.78 KiB/sec. 2024.04.28 18:46:19.818839 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::202404_1_6_1} MergedBlockOutputStream: filled checksums 202404_1_6_1 (state Temporary) 2024.04.28 18:46:19.824196 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::202404_1_6_1} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): 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:46:19.824373 [ 939 ] {3bbddd7a-06c2-41fe-98f8-641ade75f6dd::202404_1_6_1} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd) (MergerMutator): Merged 6 parts: [202404_1_1_0, 202404_6_6_0] -> 202404_1_6_1 2024.04.28 18:46:19.825945 [ 939 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 5.16 MiB. 2024.04.28 18:46:20.000238 [ 1031 ] {} AsynchronousMetrics: MemoryTracking: was 1.90 GiB, peak 1.90 GiB, free memory in arenas 0.00 B, will set to 1.92 GiB (RSS), difference: 25.95 MiB 2024.04.28 18:46:20.055353 [ 1087 ] {} datasets.hits_v1: Finished loading Active part 201403_10_18_2 on disk default 2024.04.28 18:46:20.056147 [ 1086 ] {} datasets.hits_v1: Loaded data parts (1 items) 2024.04.28 18:46:20.058640 [ 1088 ] {} datasets.visits_v1: Finished loading Active part 20140317_20140323_3_4_1 on disk default 2024.04.28 18:46:20.059459 [ 1085 ] {} datasets.visits_v1: Loaded data parts (1 items) 2024.04.28 18:46:20.061508 [ 520 ] {c3cf10ee-b4b4-4a57-a48b-9ebb340a4131} DatabaseOrdinary (datasets): Starting up tables. 2024.04.28 18:46:20.066600 [ 520 ] {c3cf10ee-b4b4-4a57-a48b-9ebb340a4131} TCPHandler: Processed in 0.325124866 sec. 2024.04.28 18:46:20.068337 [ 520 ] {} TCPHandler: Done processing connection. 2024.04.28 18:46:20.069043 [ 520 ] {} TCP-Session: 5eb47f13-c49d-4196-ad30-a88aa432e8f0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:46:20.228822 [ 520 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:53670 2024.04.28 18:46:20.230287 [ 520 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.04.28 18:46:20.230423 [ 520 ] {} TCP-Session: c71389ce-2629-4e85-9d6d-4499f4fbf527 Authenticating user 'default' from [::1]:53670 2024.04.28 18:46:20.230756 [ 520 ] {} TCP-Session: c71389ce-2629-4e85-9d6d-4499f4fbf527 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:46:20.230833 [ 520 ] {} TCP-Session: c71389ce-2629-4e85-9d6d-4499f4fbf527 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:46:20.271143 [ 520 ] {} TCP-Session: c71389ce-2629-4e85-9d6d-4499f4fbf527 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.04.28 18:46:20.272026 [ 520 ] {f5c5fb19-85de-40d5-a699-09797104d2a1} executeQuery: (from [::1]:53670) CREATE DATABASE IF NOT EXISTS test (stage: Complete) 2024.04.28 18:46:20.272187 [ 520 ] {f5c5fb19-85de-40d5-a699-09797104d2a1} ContextAccess (default): Access granted: CREATE DATABASE ON test.* 2024.04.28 18:46:20.273134 [ 520 ] {f5c5fb19-85de-40d5-a699-09797104d2a1} DatabaseAtomic (test): Metadata processed, database test has 0 tables and 0 dictionaries in total. 2024.04.28 18:46:20.273180 [ 520 ] {f5c5fb19-85de-40d5-a699-09797104d2a1} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000179015 sec 2024.04.28 18:46:20.273219 [ 520 ] {f5c5fb19-85de-40d5-a699-09797104d2a1} ReferentialDeps: No tables 2024.04.28 18:46:20.273265 [ 520 ] {f5c5fb19-85de-40d5-a699-09797104d2a1} LoadingDeps: No tables 2024.04.28 18:46:20.273471 [ 520 ] {f5c5fb19-85de-40d5-a699-09797104d2a1} DatabaseAtomic (test): Starting up tables. 2024.04.28 18:46:20.274105 [ 520 ] {f5c5fb19-85de-40d5-a699-09797104d2a1} TCPHandler: Processed in 0.003555328 sec. 2024.04.28 18:46:20.275479 [ 520 ] {} TCPHandler: Done processing connection. 2024.04.28 18:46:20.276165 [ 520 ] {} TCP-Session: c71389ce-2629-4e85-9d6d-4499f4fbf527 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.04.28 18:46:20.374106 [ 517 ] {} BaseDaemon: Received signal 15 2024.04.28 18:46:20.374317 [ 517 ] {} Application: Received termination signal (Terminated) 2024.04.28 18:46:20.374461 [ 516 ] {} Application: Received termination signal. 2024.04.28 18:46:20.375056 [ 516 ] {} Application: Waiting for current connections to close. 2024.04.28 18:46:21.801513 [ 516 ] {} Application: Closed all listening sockets. 2024.04.28 18:46:21.801671 [ 516 ] {} Application: Closed connections. 2024.04.28 18:46:21.805681 [ 516 ] {} Application: Shutting down storages. 2024.04.28 18:46:21.805795 [ 516 ] {} Context: Shutdown disk azure 2024.04.28 18:46:21.805859 [ 516 ] {} DiskObjectStorage(DiskAzureBlobStorage): Shutting down disk azure 2024.04.28 18:46:21.805915 [ 516 ] {} DiskObjectStorage(DiskAzureBlobStorage): Disk azure shut down 2024.04.28 18:46:21.805970 [ 516 ] {} Context: Shutdown disk cached_azure 2024.04.28 18:46:21.805998 [ 516 ] {} DiskObjectStorage(azure): Shutting down disk azure 2024.04.28 18:46:21.806025 [ 516 ] {} DiskObjectStorage(azure): Disk azure shut down 2024.04.28 18:46:21.806046 [ 516 ] {} Context: Shutdown disk default 2024.04.28 18:46:21.806068 [ 516 ] {} Context: Shutdown disk local_cache 2024.04.28 18:46:21.806088 [ 516 ] {} DiskObjectStorage(local_disk): Shutting down disk local_disk 2024.04.28 18:46:21.806111 [ 516 ] {} DiskObjectStorage(local_disk): Disk local_disk shut down 2024.04.28 18:46:21.806132 [ 516 ] {} Context: Shutdown disk local_cache_2 2024.04.28 18:46:21.806152 [ 516 ] {} DiskObjectStorage(local_disk): Shutting down disk local_disk 2024.04.28 18:46:21.806172 [ 516 ] {} DiskObjectStorage(local_disk): Disk local_disk shut down 2024.04.28 18:46:21.806191 [ 516 ] {} Context: Shutdown disk local_cache_3 2024.04.28 18:46:21.806212 [ 516 ] {} DiskObjectStorage(local_disk_3): Shutting down disk local_disk_3 2024.04.28 18:46:21.806232 [ 516 ] {} DiskObjectStorage(local_disk_3): Disk local_disk_3 shut down 2024.04.28 18:46:21.806252 [ 516 ] {} Context: Shutdown disk local_disk 2024.04.28 18:46:21.806273 [ 516 ] {} DiskObjectStorage(Local): Shutting down disk local_disk 2024.04.28 18:46:21.806321 [ 516 ] {} DiskObjectStorage(Local): Disk local_disk shut down 2024.04.28 18:46:21.806343 [ 516 ] {} Context: Shutdown disk local_disk_2 2024.04.28 18:46:21.806363 [ 516 ] {} DiskObjectStorage(Local): Shutting down disk local_disk_2 2024.04.28 18:46:21.806383 [ 516 ] {} DiskObjectStorage(Local): Disk local_disk_2 shut down 2024.04.28 18:46:21.806405 [ 516 ] {} Context: Shutdown disk local_disk_3 2024.04.28 18:46:21.806437 [ 516 ] {} DiskObjectStorage(Local): Shutting down disk local_disk_3 2024.04.28 18:46:21.806460 [ 516 ] {} DiskObjectStorage(Local): Disk local_disk_3 shut down 2024.04.28 18:46:21.806486 [ 516 ] {} Context: Shutdown disk s3_cache 2024.04.28 18:46:21.806687 [ 516 ] {} DiskObjectStorage(s3_disk): Shutting down disk s3_disk 2024.04.28 18:46:21.806726 [ 516 ] {} DiskObjectStorage(s3_disk): Disk s3_disk shut down 2024.04.28 18:46:21.806750 [ 516 ] {} Context: Shutdown disk s3_cache_multi 2024.04.28 18:46:21.806772 [ 516 ] {} DiskObjectStorage(s3_disk): Shutting down disk s3_disk 2024.04.28 18:46:21.806805 [ 516 ] {} DiskObjectStorage(s3_disk): Disk s3_disk shut down 2024.04.28 18:46:21.806828 [ 516 ] {} Context: Shutdown disk s3_cache_multi_2 2024.04.28 18:46:21.806849 [ 516 ] {} DiskObjectStorage(s3_disk): Shutting down disk s3_disk 2024.04.28 18:46:21.806890 [ 516 ] {} DiskObjectStorage(s3_disk): Disk s3_disk shut down 2024.04.28 18:46:21.806918 [ 516 ] {} Context: Shutdown disk s3_disk 2024.04.28 18:46:21.806942 [ 516 ] {} DiskObjectStorage(DiskS3): Shutting down disk s3_disk 2024.04.28 18:46:21.806962 [ 516 ] {} DiskObjectStorage(DiskS3): Disk s3_disk shut down 2024.04.28 18:46:21.807021 [ 516 ] {} AsynchronousInsertQueue: Shutting down the asynchronous insertion queue 2024.04.28 18:46:21.808325 [ 516 ] {} AsynchronousInsertQueue: Asynchronous insertion queue finished 2024.04.28 18:46:21.808482 [ 516 ] {} Context: Shutting down dictionaries loader 2024.04.28 18:46:21.808642 [ 516 ] {} Context: Shutting down UDFs loader 2024.04.28 18:46:21.808774 [ 516 ] {} Context: Shutting down another UDFs loader 2024.04.28 18:46:21.808827 [ 516 ] {} Context: Shutting down named sessions 2024.04.28 18:46:21.808901 [ 516 ] {} Context: Shutting down system logs 2024.04.28 18:46:21.809024 [ 993 ] {} SystemLog (system.query_log): Flushing system log, 4 entries to flush up to offset 8 2024.04.28 18:46:21.829158 [ 993 ] {} system.query_log (4edf58bd-01cc-4b31-a8ec-2333b594a9ee): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:21.829273 [ 993 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:22.053653 [ 993 ] {} MergedBlockOutputStream: filled checksums 202404_3_3_0 (state Temporary) 2024.04.28 18:46:22.064284 [ 993 ] {} system.query_log (4edf58bd-01cc-4b31-a8ec-2333b594a9ee): 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:46:22.069312 [ 993 ] {} SystemLog (system.query_log): Flushed system log up to offset 8 2024.04.28 18:46:22.069375 [ 993 ] {} SystemLog (system.query_log): Terminating 2024.04.28 18:46:22.175125 [ 985 ] {} SystemLog (system.query_thread_log): Terminating 2024.04.28 18:46:22.176997 [ 995 ] {} SystemLog (system.part_log): Terminating 2024.04.28 18:46:22.177929 [ 987 ] {} SystemLog (system.trace_log): Flushing system log, 10 entries to flush up to offset 73 2024.04.28 18:46:22.183568 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:22.183699 [ 987 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:22.290226 [ 987 ] {} MergedBlockOutputStream: filled checksums 202404_7_7_0 (state Temporary) 2024.04.28 18:46:22.294894 [ 987 ] {} system.trace_log (3bbddd7a-06c2-41fe-98f8-641ade75f6dd): 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:46:22.297132 [ 987 ] {} SystemLog (system.trace_log): Flushed system log up to offset 73 2024.04.28 18:46:22.297190 [ 987 ] {} SystemLog (system.trace_log): Terminating 2024.04.28 18:46:22.298178 [ 986 ] {} SystemLog (system.crash_log): Terminating 2024.04.28 18:46:22.298701 [ 992 ] {} SystemLog (system.text_log): Flushing system log, 168 entries to flush up to offset 775 2024.04.28 18:46:22.309685 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:22.309820 [ 992 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:22.318420 [ 992 ] {} MergedBlockOutputStream: filled checksums 202404_11_11_0 (state Temporary) 2024.04.28 18:46:22.323922 [ 992 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): 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:46:22.324784 [ 803 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959) (MergerMutator): Selected 6 parts from 202404_1_6_1 to 202404_11_11_0 2024.04.28 18:46:22.325033 [ 803 ] {} system.text_log (70b785ec-d3d2-4910-8d55-1ed6f2104959): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:22.325154 [ 803 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:22.326065 [ 929 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::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:46:22.327194 [ 992 ] {} SystemLog (system.text_log): Flushed system log up to offset 775 2024.04.28 18:46:22.327250 [ 992 ] {} SystemLog (system.text_log): Terminating 2024.04.28 18:46:22.428188 [ 929 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_11_2} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:46:22.428552 [ 929 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202404_1_6_1, total 481 rows starting from the beginning of the part 2024.04.28 18:46:22.429609 [ 929 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::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:46:22.430366 [ 929 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202404_8_8_0, total 18 rows starting from the beginning of the part 2024.04.28 18:46:22.431419 [ 929 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202404_9_9_0, total 31 rows starting from the beginning of the part 2024.04.28 18:46:22.432132 [ 929 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202404_10_10_0, total 32 rows starting from the beginning of the part 2024.04.28 18:46:22.433060 [ 929 ] {70b785ec-d3d2-4910-8d55-1ed6f2104959::202404_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202404_11_11_0, total 168 rows starting from the beginning of the part 2024.04.28 18:46:22.441272 [ 929 ] {} MergeTreeBackgroundExecutor: Code: 236. DB::Exception: Storage is about to be deleted. Done active task as if it was aborted. (ABORTED) 2024.04.28 18:46:22.446241 [ 929 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.19 MiB. 2024.04.28 18:46:22.642869 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 4 entries to flush up to offset 44 2024.04.28 18:46:23.361124 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:23.361277 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:24.137379 [ 994 ] {} MergedBlockOutputStream: filled checksums 202404_6_6_0 (state Temporary) 2024.04.28 18:46:24.188030 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 1412 entries to flush up to offset 14958 2024.04.28 18:46:24.200749 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:24.200879 [ 990 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:24.209530 [ 990 ] {} MergedBlockOutputStream: filled checksums 202404_7_7_0 (state Temporary) 2024.04.28 18:46:24.213009 [ 990 ] {} system.asynchronous_metric_log (63bb866d-3c1c-4481-b76c-3bd57dc742e0): 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:46:24.216268 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 14958 2024.04.28 18:46:24.559986 [ 994 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): 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:46:24.561452 [ 821 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551) (MergerMutator): Selected 6 parts from 202404_1_1_0 to 202404_6_6_0 2024.04.28 18:46:24.561634 [ 821 ] {} system.metric_log (d8670a35-05fb-46c2-95ab-6c9ffc98e551): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:24.561706 [ 821 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:24.562453 [ 933 ] {d8670a35-05fb-46c2-95ab-6c9ffc98e551::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:46:24.596137 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 44 2024.04.28 18:46:24.596249 [ 994 ] {} SystemLog (system.metric_log): Terminating 2024.04.28 18:46:24.596998 [ 990 ] {} SystemLog (system.asynchronous_metric_log): Terminating 2024.04.28 18:46:24.597968 [ 988 ] {} SystemLog (system.opentelemetry_span_log): Terminating 2024.04.28 18:46:24.598610 [ 991 ] {} SystemLog (system.query_views_log): Terminating 2024.04.28 18:46:24.599620 [ 989 ] {} SystemLog (system.zookeeper_log): Terminating 2024.04.28 18:46:24.601048 [ 998 ] {} SystemLog (system.session_log): Flushing system log, 4 entries to flush up to offset 8 2024.04.28 18:46:24.614765 [ 998 ] {} system.session_log (80f170e8-4521-4a89-bb4f-7ca429c6b39a): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:24.614884 [ 998 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:24.623090 [ 998 ] {} MergedBlockOutputStream: filled checksums 202404_2_2_0 (state Temporary) 2024.04.28 18:46:24.627828 [ 998 ] {} system.session_log (80f170e8-4521-4a89-bb4f-7ca429c6b39a): 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:46:24.630335 [ 998 ] {} SystemLog (system.session_log): Flushed system log up to offset 8 2024.04.28 18:46:24.630384 [ 998 ] {} SystemLog (system.session_log): Terminating 2024.04.28 18:46:24.631232 [ 996 ] {} SystemLog (system.transactions_info_log): Flushing system log, 18 entries to flush up to offset 67 2024.04.28 18:46:24.636341 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:24.636490 [ 996 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:24.642417 [ 996 ] {} MergedBlockOutputStream: filled checksums 202404_6_6_0 (state Temporary) 2024.04.28 18:46:24.647831 [ 996 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): 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:46:24.648356 [ 825 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6) (MergerMutator): Selected 6 parts from 202404_1_1_0 to 202404_6_6_0 2024.04.28 18:46:24.648637 [ 825 ] {} system.transactions_info_log (b0b64bf8-b009-4e36-bc46-d47d174e6cb6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.04.28 18:46:24.648729 [ 825 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 115.69 GiB. 2024.04.28 18:46:24.649535 [ 934 ] {b0b64bf8-b009-4e36-bc46-d47d174e6cb6::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:46:24.650262 [ 996 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 67 2024.04.28 18:46:24.650308 [ 996 ] {} SystemLog (system.transactions_info_log): Terminating 2024.04.28 18:46:24.651481 [ 934 ] {b0b64bf8-b009-4e36-bc46-d47d174e6cb6::202404_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:46:24.651727 [ 934 ] {b0b64bf8-b009-4e36-bc46-d47d174e6cb6::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_1_1_0, total 8 rows starting from the beginning of the part 2024.04.28 18:46:24.652642 [ 934 ] {b0b64bf8-b009-4e36-bc46-d47d174e6cb6::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:46:24.653363 [ 934 ] {b0b64bf8-b009-4e36-bc46-d47d174e6cb6::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_3_3_0, total 14 rows starting from the beginning of the part 2024.04.28 18:46:24.654057 [ 934 ] {b0b64bf8-b009-4e36-bc46-d47d174e6cb6::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:46:24.654886 [ 934 ] {b0b64bf8-b009-4e36-bc46-d47d174e6cb6::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_5_5_0, total 13 rows starting from the beginning of the part 2024.04.28 18:46:24.655599 [ 934 ] {b0b64bf8-b009-4e36-bc46-d47d174e6cb6::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_6_6_0, total 18 rows starting from the beginning of the part 2024.04.28 18:46:24.661756 [ 934 ] {} MergeTreeBackgroundExecutor: Code: 236. DB::Exception: Storage is about to be deleted. Done active task as if it was aborted. (ABORTED) 2024.04.28 18:46:24.748972 [ 521 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.04.28 18:46:24.749016 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:46:24.765461 [ 934 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.18 MiB. 2024.04.28 18:46:24.765960 [ 1000 ] {} SystemLog (system.processors_profile_log): Terminating 2024.04.28 18:46:24.766968 [ 999 ] {} SystemLog (system.filesystem_cache_log): Terminating 2024.04.28 18:46:24.767811 [ 997 ] {} SystemLog (system.asynchronous_insert_log): Terminating 2024.04.28 18:46:24.768583 [ 516 ] {} Context: Shutting down database catalog 2024.04.28 18:46:24.768714 [ 516 ] {} DatabaseCatalog: Shutting down database INFORMATION_SCHEMA 2024.04.28 18:46:24.772498 [ 516 ] {} DatabaseCatalog: Shutting down database datasets 2024.04.28 18:46:24.882623 [ 516 ] {} DatabaseCatalog: Shutting down database default 2024.04.28 18:46:24.882689 [ 516 ] {} DatabaseCatalog: Shutting down database information_schema 2024.04.28 18:46:24.885102 [ 516 ] {} DatabaseCatalog: Shutting down database test 2024.04.28 18:46:24.885150 [ 516 ] {} DatabaseCatalog: Shutting down system databases 2024.04.28 18:46:24.944335 [ 933 ] {d8670a35-05fb-46c2-95ab-6c9ffc98e551::202404_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.04.28 18:46:24.954064 [ 933 ] {d8670a35-05fb-46c2-95ab-6c9ffc98e551::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:46:25.203976 [ 933 ] {d8670a35-05fb-46c2-95ab-6c9ffc98e551::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_2_2_0, total 11 rows starting from the beginning of the part 2024.04.28 18:46:25.353914 [ 933 ] {d8670a35-05fb-46c2-95ab-6c9ffc98e551::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_3_3_0, total 9 rows starting from the beginning of the part 2024.04.28 18:46:25.403953 [ 933 ] {d8670a35-05fb-46c2-95ab-6c9ffc98e551::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:46:25.651342 [ 933 ] {d8670a35-05fb-46c2-95ab-6c9ffc98e551::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_5_5_0, total 9 rows starting from the beginning of the part 2024.04.28 18:46:25.999106 [ 933 ] {d8670a35-05fb-46c2-95ab-6c9ffc98e551::202404_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202404_6_6_0, total 4 rows starting from the beginning of the part 2024.04.28 18:46:26.165303 [ 933 ] {d8670a35-05fb-46c2-95ab-6c9ffc98e551::202404_1_6_1} SortDescription: Compile sort description Date 1 1DateTime 1 1 2024.04.28 18:46:26.467033 [ 933 ] {} MergeTreeBackgroundExecutor: Code: 236. DB::Exception: Storage is about to be deleted. Done active task as if it was aborted. (ABORTED) 2024.04.28 18:46:26.836734 [ 933 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.15 MiB. 2024.04.28 18:46:27.141950 [ 516 ] {} Context: Shutting down merges executor 2024.04.28 18:46:27.142415 [ 516 ] {} Context: Shutting down fetches executor 2024.04.28 18:46:27.142632 [ 516 ] {} Context: Shutting down moves executor 2024.04.28 18:46:27.142798 [ 516 ] {} Context: Shutting down common executor 2024.04.28 18:46:27.142932 [ 516 ] {} Context: Shutting down DDLWorker 2024.04.28 18:46:27.143257 [ 516 ] {} Context: Shutting down caches 2024.04.28 18:46:27.878742 [ 516 ] {} ExternalUserDefinedExecutableFunctionsLoader: Unloading 'test_function' because its configuration has been removed or detached 2024.04.28 18:46:28.007710 [ 516 ] {} ZooKeeperClient: Finalizing session 2. finalization_started: false, queue_finished: false, reason: 'Destructor called' 2024.04.28 18:46:28.008029 [ 521 ] {} KeeperTCPHandler: Received close event with xid 2147483647 for session id #2 2024.04.28 18:46:28.008146 [ 894 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.04.28 18:46:28.008839 [ 521 ] {} KeeperTCPHandler: Session #2 successfully closed 2024.04.28 18:46:28.114742 [ 516 ] {} BackgroundSchedulePool/BgBufSchPool: Waiting for threads to finish. 2024.04.28 18:46:28.115525 [ 516 ] {} BackgroundSchedulePool/BgSchPool: Waiting for threads to finish. 2024.04.28 18:46:28.115891 [ 516 ] {} BackgroundSchedulePool/BgDistSchPool: Waiting for threads to finish. 2024.04.28 18:46:28.116098 [ 516 ] {} BackgroundSchedulePool/BgMBSchPool: Waiting for threads to finish. 2024.04.28 18:46:28.117519 [ 516 ] {} Application: Shut down storages. 2024.04.28 18:46:28.117628 [ 516 ] {} Application: Waiting for current connections to servers for tables to finish. 2024.04.28 18:46:28.310239 [ 516 ] {} Application: Closed all listening sockets. 2024.04.28 18:46:28.310369 [ 516 ] {} Application: Closed connections to servers for tables. 2024.04.28 18:46:28.310463 [ 516 ] {} KeeperDispatcher: Shutting down storage dispatcher 2024.04.28 18:46:28.512224 [ 516 ] {} RaftInstance: shutting down raft core 2024.04.28 18:46:28.512339 [ 516 ] {} RaftInstance: sent stop signal to the commit thread. 2024.04.28 18:46:28.512478 [ 516 ] {} RaftInstance: cancelled all schedulers. 2024.04.28 18:46:28.512574 [ 516 ] {} RaftInstance: commit thread stopped. 2024.04.28 18:46:28.512649 [ 516 ] {} RaftInstance: all pending commit elements dropped. 2024.04.28 18:46:28.512714 [ 516 ] {} RaftInstance: reset all pointers. 2024.04.28 18:46:28.512830 [ 516 ] {} RaftInstance: joined terminated commit thread. 2024.04.28 18:46:28.512985 [ 516 ] {} RaftInstance: sent stop signal to background append thread. 2024.04.28 18:46:28.513047 [ 921 ] {} RaftInstance: bg append_entries thread terminated 2024.04.28 18:46:28.513320 [ 516 ] {} RaftInstance: clean up auto-forwarding queue: 0 elems 2024.04.28 18:46:28.513392 [ 516 ] {} RaftInstance: clean up auto-forwarding clients 2024.04.28 18:46:28.513445 [ 516 ] {} RaftInstance: raft_server shutdown completed. 2024.04.28 18:46:28.513715 [ 904 ] {} RaftInstance: end of asio worker thread, remaining threads: 15 2024.04.28 18:46:28.513738 [ 914 ] {} RaftInstance: end of asio worker thread, remaining threads: 10 2024.04.28 18:46:28.513725 [ 915 ] {} RaftInstance: end of asio worker thread, remaining threads: 10 2024.04.28 18:46:28.513729 [ 908 ] {} RaftInstance: end of asio worker thread, remaining threads: 12 2024.04.28 18:46:28.513738 [ 907 ] {} RaftInstance: end of asio worker thread, remaining threads: 13 2024.04.28 18:46:28.513753 [ 909 ] {} RaftInstance: end of asio worker thread, remaining threads: 9 2024.04.28 18:46:28.513763 [ 912 ] {} RaftInstance: end of asio worker thread, remaining threads: 7 2024.04.28 18:46:28.513767 [ 911 ] {} RaftInstance: end of asio worker thread, remaining threads: 7 2024.04.28 18:46:28.514001 [ 917 ] {} RaftInstance: end of asio worker thread, remaining threads: 4 2024.04.28 18:46:28.514014 [ 906 ] {} RaftInstance: end of asio worker thread, remaining threads: 0 2024.04.28 18:46:28.514013 [ 913 ] {} RaftInstance: end of asio worker thread, remaining threads: 5 2024.04.28 18:46:28.513782 [ 918 ] {} RaftInstance: end of asio worker thread, remaining threads: 6 2024.04.28 18:46:28.513925 [ 905 ] {} RaftInstance: end of asio worker thread, remaining threads: 12 2024.04.28 18:46:28.513976 [ 916 ] {} RaftInstance: end of asio worker thread, remaining threads: 2 2024.04.28 18:46:28.514013 [ 910 ] {} RaftInstance: end of asio worker thread, remaining threads: 3 2024.04.28 18:46:28.513992 [ 919 ] {} RaftInstance: end of asio worker thread, remaining threads: 1 2024.04.28 18:46:28.517677 [ 516 ] {} KeeperSnapshotManagerS3: Shutting down KeeperSnapshotManagerS3 2024.04.28 18:46:28.517840 [ 516 ] {} KeeperSnapshotManagerS3: KeeperSnapshotManagerS3 shut down 2024.04.28 18:46:28.517914 [ 516 ] {} KeeperDispatcher: Dispatcher shut down 2024.04.28 18:46:28.517972 [ 516 ] {} Context: Destructing remote fs threadpool reader 2024.04.28 18:46:28.518040 [ 516 ] {} Context: Destructing threadpool writer 2024.04.28 18:46:28.518189 [ 516 ] {} Context: Destructing marks loader 2024.04.28 18:46:28.630409 [ 516 ] {} Application: Destroyed global context. 2024.04.28 18:46:28.642051 [ 516 ] {} KeeperLogStore: Changelog is shut down 2024.04.28 18:46:28.650063 [ 516 ] {} Application: shutting down 2024.04.28 18:46:28.650125 [ 516 ] {} Application: Uninitializing subsystem: Logging Subsystem 2024.04.28 18:46:28.775906 [ 517 ] {} BaseDaemon: Received signal -2 2024.04.28 18:46:28.775984 [ 517 ] {} BaseDaemon: Stop SignalListener thread 2024.04.28 18:46:29.109817 [ 515 ] {} Application: Child process exited normally with code 0.