2024.10.22 00:09:48.455078 [ 518 ] {} Application: Will watch for the process with pid 519 2024.10.22 00:09:48.456448 [ 519 ] {} Application: Forked a child process to watch 2024.10.22 00:09:48.457511 [ 519 ] {} SentryWriter: Sending crash reports is disabled 2024.10.22 00:09:48.457768 [ 519 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.10.22 00:09:49.778862 [ 519 ] {} Application: Starting ClickHouse 23.8.16.42.altinitystable (revision: 54477, git hash: 46d4f9bd6a40e43bf5543be25cc704364e0c737b, build id: 411E637077957BC4E4576FBA973C558504650CD7), PID 519 2024.10.22 00:09:49.779699 [ 519 ] {} Application: starting up 2024.10.22 00:09:49.779744 [ 519 ] {} Application: OS name: Linux, version: 5.15.0-122-generic, architecture: x86_64 2024.10.22 00:09:49.803747 [ 519 ] {} Context: ThreadFuzzer is enabled. Application will run slowly and unstable. 2024.10.22 00:09:49.803836 [ 519 ] {} Context: Server was built with sanitizer. It will work slowly. 2024.10.22 00:09:49.803933 [ 519 ] {} Application: Available RAM: 30.60 GiB; physical cores: 16; logical cores: 16. 2024.10.22 00:09:49.807995 [ 519 ] {} 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.10.22 00:09:49.808887 [ 519 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2024.10.22 00:09:49.808945 [ 519 ] {} AsynchronousMetrics: Scanning /sys/block 2024.10.22 00:09:49.809146 [ 519 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2024.10.22 00:09:49.809206 [ 519 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2024.10.22 00:10:29.303821 [ 519 ] {} Application: Integrity check of the executable successfully passed (checksum: C1D0472D10F8987F7DD720B79361C561) 2024.10.22 00:10:29.304865 [ 519 ] {} Application: Will do mlock to prevent executable memory from being paged out. It may take a few seconds. 2024.10.22 00:10:29.304934 [ 519 ] {} Application: The memory map of clickhouse executable has been mlock'ed, total 1.17 GiB 2024.10.22 00:10:29.307114 [ 519 ] {} Application: Set max number of file descriptors to 1048576 (was 1024). 2024.10.22 00:10:29.307194 [ 519 ] {} Application: rlimit on number of threads is 18446744073709551615 2024.10.22 00:10:29.307248 [ 519 ] {} Application: Initializing DateLUT. 2024.10.22 00:10:29.307285 [ 519 ] {} Application: Initialized DateLUT with time zone 'Europe/Amsterdam'. 2024.10.22 00:10:29.307398 [ 519 ] {} Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it 2024.10.22 00:10:29.307879 [ 519 ] {} TLDListsHolder: public_suffix_list loading from /etc/clickhouse-server/top_level_domains/public_suffix_list.dat 2024.10.22 00:10:29.323455 [ 519 ] {} TLDListsHolder: public_suffix_list was added (9084 hosts) 2024.10.22 00:10:29.323556 [ 519 ] {} TLDListsHolder: no_new_line_list loading from /etc/clickhouse-server/top_level_domains/no_new_line_list.dat 2024.10.22 00:10:29.324219 [ 519 ] {} TLDListsHolder: no_new_line_list was added (1 hosts) 2024.10.22 00:10:29.324508 [ 519 ] {} 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.10.22 00:10:29.324691 [ 519 ] {} Application: Initializing MergeTree metadata cache, lru_cache_size: 256.00 MiB continue_if_corrupted: true 2024.10.22 00:10:29.346016 [ 519 ] {} Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'a9dd800a92f2' as replica host. 2024.10.22 00:10:29.346104 [ 519 ] {} Application: Initializing interserver credentials. 2024.10.22 00:10:29.348769 [ 519 ] {} NamedCollectionsUtils: Loaded 6 collections from config 2024.10.22 00:10:29.348944 [ 519 ] {} NamedCollectionsUtils: Loaded 0 collections from SQL 2024.10.22 00:10:29.349360 [ 519 ] {} SensitiveDataMaskerConfigRead: 1 query masking rules loaded. 2024.10.22 00:10:29.355930 [ 519 ] {} ConfigReloader: Loading config '/etc/clickhouse-server/config.xml' 2024.10.22 00:10:29.912090 [ 519 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/config.xml', performing update on configuration 2024.10.22 00:10:29.921079 [ 519 ] {} Application: Setting max_server_memory_usage was set to 15.30 GiB (30.60 GiB available * 0.50 max_server_memory_usage_to_ram_ratio) 2024.10.22 00:10:29.921150 [ 519 ] {} Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.30 GiB (30.60 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) 2024.10.22 00:10:29.921196 [ 519 ] {} Application: Merges and mutations memory limit is set to 15.30 GiB 2024.10.22 00:10:29.931679 [ 519 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.10.22 00:10:29.934399 [ 519 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.10.22 00:10:30.055865 [ 519 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.10.22 00:10:30.058206 [ 519 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.10.22 00:10:30.062572 [ 519 ] {} CertificateReloader: Reloading certificate (/etc/clickhouse-server/server.crt) and key (/etc/clickhouse-server/server.key). 2024.10.22 00:10:30.166280 [ 519 ] {} CertificateReloader: Reloaded certificate (/etc/clickhouse-server/server.crt) and key (/etc/clickhouse-server/server.key). 2024.10.22 00:10:30.166355 [ 519 ] {} CertificateReloader: Initializing certificate reloader. 2024.10.22 00:10:30.175567 [ 519 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/config.xml', performed update on configuration 2024.10.22 00:10:30.178094 [ 519 ] {} Context: Keeper server is participant of the main zookeeper cluster, will try to connect to it 2024.10.22 00:10:30.179440 [ 519 ] {} Context: Cannot connect to ZooKeeper (or Keeper) before internal Keeper start, will wait for Keeper synchronously 2024.10.22 00:10:30.179516 [ 519 ] {} KeeperDispatcher: Initializing storage dispatcher 2024.10.22 00:10:30.180833 [ 519 ] {} KeeperContext: Keeper feature flag FILTERED_LIST: enabled 2024.10.22 00:10:30.180874 [ 519 ] {} KeeperContext: Keeper feature flag MULTI_READ: enabled 2024.10.22 00:10:30.180896 [ 519 ] {} KeeperContext: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.10.22 00:10:30.181021 [ 519 ] {} KeeperContext: Disk type 'azure_blob_storage' is not supported for Keeper 2024.10.22 00:10:30.181073 [ 519 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:10:30.541230 [ 519 ] {} S3Client: Provider type: Unknown 2024.10.22 00:10:30.541301 [ 519 ] {} S3Client: API mode of the S3 client: AWS 2024.10.22 00:10:30.553903 [ 519 ] {} WriteBufferFromS3: Create WriteBufferFromS3, Details: bucket test, key common/clickhouse_remove_objects_capability_e1f5a354-f4fb-4a2b-828b-5d270aced313 2024.10.22 00:10:30.554686 [ 519 ] {} WriteBufferFromS3: finalizeImpl WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_e1f5a354-f4fb-4a2b-828b-5d270aced313. 2024.10.22 00:10:30.556976 [ 905 ] {} HTTPSessionAdapter: Created HTTP(S) session with localhost:11111 (::1:11111) 2024.10.22 00:10:30.559969 [ 905 ] {} WriteBufferFromS3: Single part upload has completed. Details: bucket test, key common/clickhouse_remove_objects_capability_e1f5a354-f4fb-4a2b-828b-5d270aced313, size 4 2024.10.22 00:10:30.560386 [ 519 ] {} WriteBufferFromS3: Close WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_e1f5a354-f4fb-4a2b-828b-5d270aced313. 2024.10.22 00:10:30.563720 [ 519 ] {} S3ObjectStorage: Objects with paths [common/clickhouse_remove_objects_capability_e1f5a354-f4fb-4a2b-828b-5d270aced313] were removed from S3 2024.10.22 00:10:30.581799 [ 519 ] {} S3ObjectStorage: Objects with paths [common/zsj/hstladbqiazbjfvgnwblgdoqmoliz] were removed from S3 2024.10.22 00:10:30.581896 [ 519 ] {} DiskObjectStorage(DiskS3): Starting up disk s3_disk 2024.10.22 00:10:30.581940 [ 519 ] {} DiskObjectStorage(DiskS3): Disk s3_disk started up 2024.10.22 00:10:30.582031 [ 519 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:10:30.582078 [ 519 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.10.22 00:10:30.582111 [ 519 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.10.22 00:10:30.582143 [ 519 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.10.22 00:10:30.582174 [ 519 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:10:30.582211 [ 519 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:10:30.582246 [ 519 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:10:30.582278 [ 519 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:10:30.582309 [ 519 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:10:30.582890 [ 519 ] {} KeeperSnapshotManager: Reading from disk LocalSnapshotDisk 2024.10.22 00:10:30.683836 [ 519 ] {} KeeperLogStore: Reading from disk LocalLogDisk 2024.10.22 00:10:30.684002 [ 519 ] {} KeeperLogStore: No logs exists in /var/lib/clickhouse/coordination/logs. It's Ok if it's the first run of clickhouse-keeper. 2024.10.22 00:10:30.684428 [ 519 ] {} KeeperLogStore: force_sync disabled 2024.10.22 00:10:30.684554 [ 519 ] {} KeeperDispatcher: Waiting server to initialize 2024.10.22 00:10:30.684720 [ 519 ] {} KeeperStateMachine: Totally have 0 snapshots 2024.10.22 00:10:30.684781 [ 519 ] {} KeeperStateMachine: No existing snapshots, last committed log index 0 2024.10.22 00:10:30.684906 [ 519 ] {} KeeperLogStore: Removing all changelogs 2024.10.22 00:10:30.684998 [ 519 ] {} Changelog: Starting new changelog changelog_1_100000.bin.zstd 2024.10.22 00:10:30.686340 [ 519 ] {} KeeperServer: Preprocessing 0 log entries 2024.10.22 00:10:30.686382 [ 519 ] {} KeeperServer: Preprocessing done 2024.10.22 00:10:30.686423 [ 519 ] {} KeeperServer: No config in log store and snapshot, probably it's initial run. Will use config from .xml on disk 2024.10.22 00:10:30.687010 [ 519 ] {} KeeperServer: Got 1000000000000000 value for setting 'reserved_log_items' which is bigger than int32_t max value, lowering value to 2147483647. 2024.10.22 00:10:30.690166 [ 519 ] {} RaftInstance: Raft ASIO listener initiated on :::9234, unsecured 2024.10.22 00:10:30.690275 [ 519 ] {} KeeperStateManager: No state was read 2024.10.22 00:10:30.690343 [ 519 ] {} RaftInstance: invalid election timeout lower bound detected, adjusted to 0 2024.10.22 00:10:30.690396 [ 519 ] {} RaftInstance: invalid election timeout upper bound detected, adjusted to 0 2024.10.22 00:10:30.690451 [ 519 ] {} 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.10.22 00:10:30.690516 [ 519 ] {} RaftInstance: new election timeout range: 0 - 0 2024.10.22 00:10:30.690603 [ 519 ] {} 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.10.22 00:10:30.690689 [ 519 ] {} RaftInstance: peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 2024.10.22 00:10:30.690761 [ 519 ] {} RaftInstance: global manager does not exist. will use local thread for commit and append 2024.10.22 00:10:30.690913 [ 519 ] {} RaftInstance: wait for HB, for 50 + [0, 0] ms 2024.10.22 00:10:30.691011 [ 926 ] {} RaftInstance: bg append_entries thread initiated 2024.10.22 00:10:30.741229 [ 909 ] {} RaftInstance: Election timeout, initiate leader election 2024.10.22 00:10:30.741363 [ 909 ] {} RaftInstance: [PRIORITY] decay, target 1 -> 1, mine 1 2024.10.22 00:10:30.741474 [ 909 ] {} 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.10.22 00:10:30.741837 [ 519 ] {} KeeperDispatcher: Server initialized, waiting for quorum 2024.10.22 00:10:30.743855 [ 909 ] {} RaftInstance: [VOTE INIT] my id 1, my role candidate, term 1, log idx 0, log term 0, priority (target 1 / mine 1) 2024.10.22 00:10:30.743932 [ 909 ] {} RaftInstance: number of pending commit elements: 0 2024.10.22 00:10:30.743983 [ 909 ] {} RaftInstance: state machine commit index 0, precommit index 0, last log index 0 2024.10.22 00:10:30.744067 [ 909 ] {} RaftInstance: [BECOME LEADER] appended new config at 1 2024.10.22 00:10:30.747182 [ 925 ] {} RaftInstance: config at index 1 is committed, prev config log idx 0 2024.10.22 00:10:30.747290 [ 925 ] {} RaftInstance: new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 2024.10.22 00:10:30.747394 [ 925 ] {} 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.10.22 00:10:30.747499 [ 519 ] {} KeeperDispatcher: Quorum initialized 2024.10.22 00:10:30.747716 [ 519 ] {} KeeperDispatcher: Dispatcher initialized 2024.10.22 00:10:30.748961 [ 519 ] {} Application: Listening for Keeper (tcp): [::]:9181 2024.10.22 00:10:30.749144 [ 519 ] {} Application: Listening for replica communication (interserver): http://[::]:9009 2024.10.22 00:10:30.756483 [ 519 ] {} ConfigReloader: Loading config '/etc/clickhouse-server/users.xml' 2024.10.22 00:10:30.881307 [ 519 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performing update on configuration 2024.10.22 00:10:30.994561 [ 519 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performed update on configuration 2024.10.22 00:10:31.121903 [ 519 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /etc/clickhouse-server/users.xml 2024.10.22 00:10:31.122315 [ 519 ] {} Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist 2024.10.22 00:10:31.122393 [ 519 ] {} Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/ 2024.10.22 00:10:31.126478 [ 519 ] {} Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/ 2024.10.22 00:10:31.130357 [ 519 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.10.22 00:10:31.131661 [ 519 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.10.22 00:10:31.132882 [ 519 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.10.22 00:10:31.134266 [ 519 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.10.22 00:10:31.137473 [ 519 ] {} DNSCacheUpdater: Update period 15 seconds 2024.10.22 00:10:31.137544 [ 519 ] {} Application: Loading metadata from /var/lib/clickhouse/ 2024.10.22 00:10:31.137582 [ 747 ] {} DNSResolver: Updating DNS cache 2024.10.22 00:10:31.138270 [ 747 ] {} DNSResolver: Updated DNS cache 2024.10.22 00:10:31.240498 [ 519 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.10.22 00:10:31.240568 [ 519 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000236493 sec 2024.10.22 00:10:31.240613 [ 519 ] {} ReferentialDeps: No tables 2024.10.22 00:10:31.240654 [ 519 ] {} LoadingDeps: No tables 2024.10.22 00:10:31.240929 [ 519 ] {} DatabaseAtomic (system): Starting up tables. 2024.10.22 00:10:31.241041 [ 519 ] {} SystemLog: Creating system.query_log from query_log 2024.10.22 00:10:31.340525 [ 519 ] {} SystemLog: Creating system.query_thread_log from query_thread_log 2024.10.22 00:10:31.349821 [ 519 ] {} SystemLog: Creating system.part_log from part_log 2024.10.22 00:10:31.356907 [ 519 ] {} SystemLog: Creating system.trace_log from trace_log 2024.10.22 00:10:31.360861 [ 519 ] {} SystemLog: Creating system.crash_log from crash_log 2024.10.22 00:10:31.362986 [ 519 ] {} SystemLog: Creating system.text_log from text_log 2024.10.22 00:10:31.366724 [ 519 ] {} SystemLog: Creating system.metric_log from metric_log 2024.10.22 00:10:31.400718 [ 519 ] {} SystemLog: Creating system.filesystem_cache_log from filesystem_cache_log 2024.10.22 00:10:31.405580 [ 519 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.10.22 00:10:31.405660 [ 519 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2024.10.22 00:10:31.409736 [ 519 ] {} SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log 2024.10.22 00:10:31.414614 [ 519 ] {} SystemLog: Creating system.query_views_log from query_views_log 2024.10.22 00:10:31.421090 [ 519 ] {} SystemLog: Creating system.zookeeper_log from zookeeper_log 2024.10.22 00:10:31.431782 [ 519 ] {} SystemLog: Creating system.session_log from session_log 2024.10.22 00:10:31.440632 [ 519 ] {} SystemLog: Creating system.transactions_info_log from transactions_info_log 2024.10.22 00:10:31.445261 [ 519 ] {} SystemLog: Creating system.processors_profile_log from processors_profile_log 2024.10.22 00:10:31.449452 [ 519 ] {} SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log 2024.10.22 00:10:31.555403 [ 519 ] {} 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.10.22 00:10:32.183476 [ 519 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.10.22 00:10:32.184634 [ 519 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.10.22 00:10:32.184703 [ 519 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000180699 sec 2024.10.22 00:10:32.184748 [ 519 ] {} ReferentialDeps: No tables 2024.10.22 00:10:32.184790 [ 519 ] {} LoadingDeps: No tables 2024.10.22 00:10:32.185037 [ 519 ] {} DatabaseAtomic (default): Starting up tables. 2024.10.22 00:10:32.185331 [ 519 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/ 2024.10.22 00:10:32.185465 [ 519 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.10.22 00:10:32.185527 [ 519 ] {} Application: Loaded metadata. 2024.10.22 00:10:32.185628 [ 519 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.10.22 00:10:32.185836 [ 519 ] {} Application: Query Profiler disabled because they cannot work under sanitizers when two different stack unwinding methods will interfere with each other. 2024.10.22 00:10:32.186183 [ 519 ] {} bool DB::(anonymous namespace)::checkPermissionsImpl(): Code: 412. DB::Exception: Can't receive Netlink response: error -2. (NETLINK_ERROR) (version 23.8.16.42.altinitystable (altinity build)) 2024.10.22 00:10:32.186287 [ 519 ] {} Application: Tasks stats provider: procfs 2024.10.22 00:10:32.193800 [ 519 ] {} 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.10.22 00:10:32.193870 [ 519 ] {} MemoryTracker: Current memory usage (total): 1.60 GiB. 2024.10.22 00:10:32.267090 [ 734 ] {} WriteBufferFromAzureBlobStorage: Staged block (id: vybufzgfxvjtysipcfxiwtvtatycqqqhluwzjffoqbpdizirxhyuyhmsvefesiim) of size 4 (blob path: bvnmzacibjxvhgfulndwyurtqprhawdj). 2024.10.22 00:10:32.278803 [ 734 ] {} WriteBufferFromAzureBlobStorage: Committed 1 blocks for blob `bvnmzacibjxvhgfulndwyurtqprhawdj` 2024.10.22 00:10:32.306020 [ 734 ] {} DiskObjectStorage(DiskAzureBlobStorage): Starting up disk azure 2024.10.22 00:10:32.306103 [ 734 ] {} DiskObjectStorage(DiskAzureBlobStorage): Disk azure started up 2024.10.22 00:10:32.307257 [ 734 ] {} DiskCache: Registered cached disk (`cached_azure`) with structure: DiskObjectStorage-azure(CachedObjectStorage-cached_azure(AzureObjectStorage)) 2024.10.22 00:10:32.320273 [ 734 ] {} S3Client: Provider type: Unknown 2024.10.22 00:10:32.320329 [ 734 ] {} S3Client: API mode of the S3 client: AWS 2024.10.22 00:10:32.447241 [ 734 ] {} S3ObjectStorage: Objects with paths [common/clickhouse_remove_objects_capability_e1f5a354-f4fb-4a2b-828b-5d270aced313] were removed from S3 2024.10.22 00:10:32.571969 [ 734 ] {} S3ObjectStorage: Objects with paths [common/hrz/ktaipnmzmullvhltqklwcdbyphymw] were removed from S3 2024.10.22 00:10:32.572081 [ 734 ] {} DiskObjectStorage(DiskS3): Starting up disk s3_disk 2024.10.22 00:10:32.572130 [ 734 ] {} DiskObjectStorage(DiskS3): Disk s3_disk started up 2024.10.22 00:10:32.572873 [ 734 ] {} DiskCache: Registered cached disk (`s3_cache`) with structure: DiskObjectStorage-s3_disk(CachedObjectStorage-s3_cache(S3ObjectStorage)) 2024.10.22 00:10:32.578319 [ 734 ] {} DiskObjectStorage(Local): Starting up disk local_disk 2024.10.22 00:10:32.578374 [ 734 ] {} DiskObjectStorage(Local): Disk local_disk started up 2024.10.22 00:10:32.582839 [ 734 ] {} DiskObjectStorage(Local): Starting up disk local_disk_2 2024.10.22 00:10:32.582931 [ 734 ] {} DiskObjectStorage(Local): Disk local_disk_2 started up 2024.10.22 00:10:32.587606 [ 734 ] {} DiskObjectStorage(Local): Starting up disk local_disk_3 2024.10.22 00:10:32.587637 [ 734 ] {} DiskObjectStorage(Local): Disk local_disk_3 started up 2024.10.22 00:10:32.588373 [ 734 ] {} DiskCache: Registered cached disk (`local_cache`) with structure: DiskObjectStorage-local_disk(CachedObjectStorage-local_cache(LocalObjectStorage)) 2024.10.22 00:10:32.588955 [ 734 ] {} DiskCache: Registered cached disk (`local_cache_2`) with structure: DiskObjectStorage-local_disk(CachedObjectStorage-local_cache_2(LocalObjectStorage)) 2024.10.22 00:10:32.589651 [ 734 ] {} DiskCache: Registered cached disk (`local_cache_3`) with structure: DiskObjectStorage-local_disk_3(CachedObjectStorage-local_cache_3(LocalObjectStorage)) 2024.10.22 00:10:32.590306 [ 734 ] {} DiskCache: Registered cached disk (`s3_cache_multi`) with structure: DiskObjectStorage-s3_disk(CachedObjectStorage-s3_cache_multi(CachedObjectStorage-s3_cache(S3ObjectStorage))) 2024.10.22 00:10:32.590967 [ 734 ] {} 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.10.22 00:10:32.591585 [ 734 ] {} DatabaseCatalog: Execution took 406 ms. 2024.10.22 00:10:32.593436 [ 519 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 0.00026055 sec. 2024.10.22 00:10:32.596451 [ 519 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/decimals_dictionary.xml'. 2024.10.22 00:10:32.714886 [ 519 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/executable_dictionary.xml'. 2024.10.22 00:10:32.738469 [ 519 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/executable_pool_dictionary.xml'. 2024.10.22 00:10:32.855172 [ 519 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/ints_dictionary.xml'. 2024.10.22 00:10:32.892820 [ 519 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/strings_dictionary.xml'. 2024.10.22 00:10:33.000333 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.60 GiB, peak 1.63 GiB, free memory in arenas 0.00 B, will set to 1.69 GiB (RSS), difference: 96.76 MiB 2024.10.22 00:10:33.013500 [ 519 ] {} ExternalUserDefinedExecutableFunctionsLoader: Loading config file '/etc/clickhouse-server/test_function.xml'. 2024.10.22 00:10:33.021665 [ 519 ] {} ExternalUserDefinedExecutableFunctionsLoader: Will load 'test_function' because always_load_everything flag is set. 2024.10.22 00:10:33.021750 [ 519 ] {} ExternalUserDefinedExecutableFunctionsLoader: Will load the object 'test_function' immediately, force = false, loading_id = 1 2024.10.22 00:10:33.021791 [ 519 ] {} ExternalUserDefinedExecutableFunctionsLoader: Start loading object 'test_function' 2024.10.22 00:10:33.022207 [ 519 ] {} ExternalUserDefinedExecutableFunctionsLoader: Supposed update time for 'test_function' is never (loaded, lifetime 0) 2024.10.22 00:10:33.022275 [ 519 ] {} ExternalUserDefinedExecutableFunctionsLoader: Next update time for 'test_function' was set to 294247-01-10 05:00:54 2024.10.22 00:10:33.022971 [ 519 ] {} Application: Listening for http://[::]:8123 2024.10.22 00:10:33.023306 [ 1039 ] {} DDLWorker: Starting DDLWorker thread 2024.10.22 00:10:33.023351 [ 519 ] {} Application: Listening for https://[::]:8443 2024.10.22 00:10:33.023490 [ 1039 ] {} DDLWorker: Initializing DDLWorker thread 2024.10.22 00:10:33.023584 [ 519 ] {} Application: Listening for native protocol (tcp): [::]:9000 2024.10.22 00:10:33.023485 [ 1040 ] {} DDLWorker: Started DDLWorker cleanup thread 2024.10.22 00:10:33.023904 [ 519 ] {} Application: Listening for native protocol (tcp) with PROXY: [::]:9010 2024.10.22 00:10:33.024124 [ 519 ] {} Application: Listening for secure native protocol (tcp_secure): [::]:9440 2024.10.22 00:10:33.024190 [ 519 ] {} Application: Listening for MySQL compatibility protocol: [::]:9004 2024.10.22 00:10:33.024431 [ 519 ] {} Application: Listening for PostgreSQL compatibility protocol: [::]:9005 2024.10.22 00:10:33.024608 [ 519 ] {} Application: Listening for Prometheus: http://[::]:9988 2024.10.22 00:10:33.024479 [ 523 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58186 2024.10.22 00:10:33.025306 [ 524 ] {} KeeperTCPHandlerFactory: Keeper request. Address: [::1]:60436 2024.10.22 00:10:33.028200 [ 523 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.10.22 00:10:33.028434 [ 523 ] {} TCP-Session: 7ba312ec-5705-4701-88cd-6efe0ffd0183 Authenticating user 'default' from [::1]:58186 2024.10.22 00:10:33.028549 [ 523 ] {} TCP-Session: 7ba312ec-5705-4701-88cd-6efe0ffd0183 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:10:33.028654 [ 523 ] {} TCP-Session: 7ba312ec-5705-4701-88cd-6efe0ffd0183 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:10:33.030378 [ 524 ] {} KeeperTCPHandler: Requesting session ID for the new client 2024.10.22 00:10:33.030671 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.10.22 00:10:33.030762 [ 523 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.10.22 00:10:33.030914 [ 523 ] {} ContextAccess (default): List of all grants: GRANT ALL ON *.* WITH GRANT OPTION 2024.10.22 00:10:33.031051 [ 523 ] {} ContextAccess (default): List of all grants including implicit: GRANT ALL ON *.* WITH GRANT OPTION 2024.10.22 00:10:33.031746 [ 925 ] {} KeeperStateMachine: Session ID response 1 with timeout 30000 2024.10.22 00:10:33.031980 [ 524 ] {} KeeperTCPHandler: Received session ID 1 2024.10.22 00:10:33.032173 [ 1039 ] {} ZooKeeperClient: Connected to ZooKeeper at [::1]:9181 with session_id 1 2024.10.22 00:10:33.033480 [ 1039 ] {} ZooKeeperClient: Keeper feature flag FILTERED_LIST: enabled 2024.10.22 00:10:33.033536 [ 1039 ] {} ZooKeeperClient: Keeper feature flag MULTI_READ: enabled 2024.10.22 00:10:33.033562 [ 1039 ] {} ZooKeeperClient: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.10.22 00:10:33.033628 [ 1039 ] {} ZooKeeper: Initialized, hosts: localhost:9181 2024.10.22 00:10:33.033826 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 1 2024.10.22 00:10:33.033827 [ 519 ] {} ZooKeeperClient: ZK send fault: 0.002% 2024.10.22 00:10:33.033977 [ 519 ] {} ZooKeeperClient: ZK recv fault: 0.002% 2024.10.22 00:10:33.034071 [ 519 ] {} ZooKeeperClient: ZK send sleep: 0.001% -> 10000ms 2024.10.22 00:10:33.034273 [ 519 ] {} Application: Ready for connections. 2024.10.22 00:10:33.034462 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.10.22 00:10:33.035394 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 85 2024.10.22 00:10:33.036075 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 74 2024.10.22 00:10:33.036929 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 85 2024.10.22 00:10:33.037598 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.10.22 00:10:33.038168 [ 1039 ] {} DDLWorker: Initialized DDLWorker thread 2024.10.22 00:10:33.038228 [ 1039 ] {} DDLWorker: Scheduling tasks 2024.10.22 00:10:33.038274 [ 1039 ] {} DDLWorker: Don't have unfinished tasks after restarting 2024.10.22 00:10:33.038300 [ 1040 ] {} DDLWorker: Cleaning queue 2024.10.22 00:10:33.038815 [ 1039 ] {} 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.10.22 00:10:33.038869 [ 1039 ] {} DDLWorker: No tasks to schedule 2024.10.22 00:10:33.038912 [ 1039 ] {} DDLWorker: Waiting for queue updates 2024.10.22 00:10:33.075718 [ 523 ] {} TCP-Session: 7ba312ec-5705-4701-88cd-6efe0ffd0183 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.22 00:10:33.091942 [ 523 ] {1f60c2ca-2671-43a7-bbfa-bea413ea1c56} executeQuery: (from [::1]:58186) SELECT 1 (stage: Complete) 2024.10.22 00:10:33.093889 [ 523 ] {1f60c2ca-2671-43a7-bbfa-bea413ea1c56} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.10.22 00:10:33.094380 [ 523 ] {1f60c2ca-2671-43a7-bbfa-bea413ea1c56} InterpreterSelectQuery: FetchColumns -> Complete 2024.10.22 00:10:33.098342 [ 523 ] {1f60c2ca-2671-43a7-bbfa-bea413ea1c56} executeQuery: Read 1 rows, 1.00 B in 0.006767 sec., 147.77597162701346 rows/sec., 147.78 B/sec. 2024.10.22 00:10:33.098710 [ 523 ] {1f60c2ca-2671-43a7-bbfa-bea413ea1c56} TCPHandler: Processed in 0.023749653 sec. 2024.10.22 00:10:33.199560 [ 523 ] {} TCPHandler: Done processing connection. 2024.10.22 00:10:33.200412 [ 523 ] {} TCP-Session: 7ba312ec-5705-4701-88cd-6efe0ffd0183 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:11:25.278532 [ 524 ] {} KeeperTCPHandler: Session #1 expired 2024.10.22 00:11:25.280226 [ 735 ] {} DNSResolver: Updating DNS cache 2024.10.22 00:11:25.280826 [ 927 ] {} KeeperDispatcher: Found dead session 1, will try to close it 2024.10.22 00:11:25.280958 [ 927 ] {} KeeperDispatcher: Dead session close request pushed 2024.10.22 00:11:25.280975 [ 735 ] {} DNSResolver: Updated DNS cache 2024.10.22 00:11:25.281004 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.10.22 00:11:25.281540 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 2 entries to flush up to offset 2 2024.10.22 00:11:25.281576 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 263 entries to flush up to offset 263 2024.10.22 00:11:25.281605 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 500 entries to flush up to offset 500 2024.10.22 00:11:25.281585 [ 996 ] {} SystemLog (system.query_log): Flushing system log, 2 entries to flush up to offset 2 2024.10.22 00:11:25.281576 [ 991 ] {} SystemLog (system.trace_log): Flushing system log, 6 entries to flush up to offset 6 2024.10.22 00:11:25.282037 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.69 GiB, peak 1.70 GiB, free memory in arenas 0.00 B, will set to 1.72 GiB (RSS), difference: 29.46 MiB 2024.10.22 00:11:25.281990 [ 994 ] {} SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog 2024.10.22 00:11:25.281697 [ 999 ] {} SystemLog (system.zookeeper_log): Flushing system log, 18 entries to flush up to offset 18 2024.10.22 00:11:25.282176 [ 523 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:41088 2024.10.22 00:11:25.282337 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog 2024.10.22 00:11:25.282431 [ 991 ] {} SystemLog (system.trace_log): Creating new table system.trace_log for TraceLog 2024.10.22 00:11:25.282359 [ 995 ] {} SystemLog (system.text_log): Creating new table system.text_log for TextLog 2024.10.22 00:11:25.283284 [ 996 ] {} SystemLog (system.query_log): Creating new table system.query_log for QueryLog 2024.10.22 00:11:25.283294 [ 999 ] {} SystemLog (system.zookeeper_log): Creating new table system.zookeeper_log for ZooKeeperLog 2024.10.22 00:11:25.286466 [ 523 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.10.22 00:11:25.286559 [ 523 ] {} TCP-Session: bed5fb56-8981-4e0c-9bbd-2d710eb9bffc Authenticating user 'default' from [::1]:41088 2024.10.22 00:11:25.286644 [ 523 ] {} TCP-Session: bed5fb56-8981-4e0c-9bbd-2d710eb9bffc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:11:25.286748 [ 523 ] {} TCP-Session: bed5fb56-8981-4e0c-9bbd-2d710eb9bffc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:11:25.320605 [ 991 ] {} StoragePolicy (azure_cache): Storage policy azure_cache created, total volumes 1 2024.10.22 00:11:25.320810 [ 991 ] {} StoragePolicySelector: Storage policy `azure_cache` loaded 2024.10.22 00:11:25.321114 [ 991 ] {} StoragePolicy (s3_cache): Storage policy s3_cache created, total volumes 1 2024.10.22 00:11:25.321149 [ 991 ] {} StoragePolicySelector: Storage policy `s3_cache` loaded 2024.10.22 00:11:25.321383 [ 991 ] {} StoragePolicy (s3_cache_multi): Storage policy s3_cache_multi created, total volumes 1 2024.10.22 00:11:25.321432 [ 991 ] {} StoragePolicySelector: Storage policy `s3_cache_multi` loaded 2024.10.22 00:11:25.321598 [ 991 ] {} StoragePolicy (local_cache): Storage policy local_cache created, total volumes 1 2024.10.22 00:11:25.321626 [ 991 ] {} StoragePolicySelector: Storage policy `local_cache` loaded 2024.10.22 00:11:25.321785 [ 991 ] {} StoragePolicy (local_cache_2): Storage policy local_cache_2 created, total volumes 1 2024.10.22 00:11:25.321814 [ 991 ] {} StoragePolicySelector: Storage policy `local_cache_2` loaded 2024.10.22 00:11:25.321980 [ 991 ] {} StoragePolicy (local_cache_3): Storage policy local_cache_3 created, total volumes 1 2024.10.22 00:11:25.322009 [ 991 ] {} StoragePolicySelector: Storage policy `local_cache_3` loaded 2024.10.22 00:11:25.322150 [ 991 ] {} StoragePolicy (default): Storage policy default created, total volumes 1 2024.10.22 00:11:25.325026 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Loading data parts 2024.10.22 00:11:25.325034 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Loading data parts 2024.10.22 00:11:25.325672 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Loading data parts 2024.10.22 00:11:25.326899 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): There are no data parts 2024.10.22 00:11:25.326923 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): There are no data parts 2024.10.22 00:11:25.327041 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): There are no data parts 2024.10.22 00:11:25.333910 [ 523 ] {} TCP-Session: bed5fb56-8981-4e0c-9bbd-2d710eb9bffc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.22 00:11:25.335388 [ 523 ] {66378fe0-5df4-40af-9c55-8c1119e4a2d4} executeQuery: (from [::1]:41088) SELECT 'Connected to clickhouse-server after attaching gdb' (stage: Complete) 2024.10.22 00:11:25.336989 [ 523 ] {66378fe0-5df4-40af-9c55-8c1119e4a2d4} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.10.22 00:11:25.337332 [ 523 ] {66378fe0-5df4-40af-9c55-8c1119e4a2d4} InterpreterSelectQuery: FetchColumns -> Complete 2024.10.22 00:11:25.340177 [ 523 ] {66378fe0-5df4-40af-9c55-8c1119e4a2d4} executeQuery: Read 1 rows, 1.00 B in 0.005085 sec., 196.65683382497542 rows/sec., 196.66 B/sec. 2024.10.22 00:11:25.340647 [ 523 ] {66378fe0-5df4-40af-9c55-8c1119e4a2d4} TCPHandler: Processed in 0.00742013 sec. 2024.10.22 00:11:25.343985 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): Loading data parts 2024.10.22 00:11:25.344464 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:25.344697 [ 1002 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:25.344823 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): There are no data parts 2024.10.22 00:11:25.344845 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:25.345164 [ 991 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:25.349947 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:25.350118 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:25.357999 [ 991 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:11:25.360983 [ 996 ] {} system.query_log (cc5a85f7-e64e-4d57-8dc7-3ced08b1d48a): Loading data parts 2024.10.22 00:11:25.361323 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:11:25.361755 [ 996 ] {} system.query_log (cc5a85f7-e64e-4d57-8dc7-3ced08b1d48a): There are no data parts 2024.10.22 00:11:25.364965 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Renaming temporary part tmp_insert_202410_1_1_0 to 202410_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:25.367880 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_1_1_0 to 202410_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:25.369293 [ 991 ] {} SystemLog (system.trace_log): Flushed system log up to offset 6 2024.10.22 00:11:25.370692 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:25.370820 [ 999 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:25.371841 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 263 2024.10.22 00:11:25.382174 [ 999 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:11:25.388654 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): Renaming temporary part tmp_insert_202410_1_1_0 to 202410_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:25.392208 [ 999 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 18 2024.10.22 00:11:25.392598 [ 996 ] {} system.query_log (cc5a85f7-e64e-4d57-8dc7-3ced08b1d48a): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:25.392827 [ 996 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:25.412994 [ 996 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:11:25.421092 [ 996 ] {} system.query_log (cc5a85f7-e64e-4d57-8dc7-3ced08b1d48a): Renaming temporary part tmp_insert_202410_1_1_0 to 202410_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:25.425462 [ 996 ] {} SystemLog (system.query_log): Flushed system log up to offset 2 2024.10.22 00:11:25.432203 [ 523 ] {} TCPHandler: Done processing connection. 2024.10.22 00:11:25.432831 [ 523 ] {} TCP-Session: bed5fb56-8981-4e0c-9bbd-2d710eb9bffc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:11:25.455702 [ 1002 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:11:25.459668 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Renaming temporary part tmp_insert_202410_1_1_0 to 202410_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:25.462788 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 500 2024.10.22 00:11:25.708905 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Loading data parts 2024.10.22 00:11:25.709586 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): There are no data parts 2024.10.22 00:11:25.756586 [ 1050 ] {} ZooKeeperClient: Code: 33. DB::Exception: Cannot read all data. Bytes read: 0. Bytes expected: 4. (CANNOT_READ_ALL_DATA), Stack trace (when copying this message, always include the lines below): 0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x000000004a1acfe9 in /usr/bin/clickhouse 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000002084a673 in /usr/bin/clickhouse 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, unsigned long&, String&&) @ 0x0000000009e5dd39 in /usr/bin/clickhouse 3. DB::ReadBuffer::readStrict(char*, unsigned long) @ 0x0000000009e5d97c in /usr/bin/clickhouse 4. ./build_docker/./src/Common/TransformEndianness.hpp:18: Coordination::ZooKeeper::receiveEvent() @ 0x000000003fb2cc0b in /usr/bin/clickhouse 5. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: Coordination::ZooKeeper::receiveThread() @ 0x000000003fb2bbc2 in /usr/bin/clickhouse 6. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_1>(Coordination::ZooKeeper::ZooKeeper(std::vector> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_1&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000003fb3fcd2 in /usr/bin/clickhouse 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x0000000020b7c63b 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*) @ 0x0000000020b8b24b in /usr/bin/clickhouse 9. ? @ 0x00007f560e9beac3 in ? 10. ? @ 0x00007f560ea50850 in ? (version 23.8.16.42.altinitystable (altinity build)) 2024.10.22 00:11:25.756739 [ 1050 ] {} ZooKeeperClient: Finalizing session 1. finalization_started: false, queue_finished: false, reason: 'Exception in receiveThread' 2024.10.22 00:11:25.848957 [ 1049 ] {} ZooKeeperClient: Code: 210. DB::NetException: I/O error: Broken pipe, while writing to socket ([::1]:60436 -> [::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) @ 0x000000004a1acfe9 in /usr/bin/clickhouse 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000002084a673 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&&) @ 0x00000000210a241f in /usr/bin/clickhouse 3. ./build_docker/./src/IO/WriteBufferFromPocoSocket.cpp:107: DB::WriteBufferFromPocoSocket::nextImpl() @ 0x00000000210a0d40 in /usr/bin/clickhouse 4. ./build_docker/./src/IO/WriteBuffer.h:60: Coordination::ZooKeeperRequest::write(DB::WriteBuffer&) const @ 0x000000003fad87c7 in /usr/bin/clickhouse 5. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:647: Coordination::ZooKeeper::sendThread() @ 0x000000003fb29d09 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*) @ 0x000000003fb3f612 in /usr/bin/clickhouse 7. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x0000000020b7c63b 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*) @ 0x0000000020b8b24b in /usr/bin/clickhouse 9. ? @ 0x00007f560e9beac3 in ? 10. ? @ 0x00007f560ea50850 in ? (version 23.8.16.42.altinitystable (altinity build)) 2024.10.22 00:11:25.975501 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:25.975623 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:26.000177 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.72 GiB, peak 1.73 GiB, free memory in arenas 0.00 B, will set to 1.82 GiB (RSS), difference: 99.96 MiB 2024.10.22 00:11:26.393822 [ 994 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:11:26.566573 [ 1050 ] {} 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) @ 0x000000004a1acfe9 in /usr/bin/clickhouse 1. ./build_docker/./base/poco/Foundation/src/Exception.cpp:0: Poco::IOException::IOException(String const&, int) @ 0x000000004a1bcbee in /usr/bin/clickhouse 2. ./build_docker/./base/poco/Net/src/NetException.cpp:0: Poco::Net::NetException::NetException(String const&, int) @ 0x0000000049d2540e in /usr/bin/clickhouse 3. ./build_docker/./base/poco/Net/src/SocketImpl.cpp:995: Poco::Net::SocketImpl::error(int, String const&) @ 0x0000000049d4277a in /usr/bin/clickhouse 4. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: Poco::Net::SocketImpl::shutdown() @ 0x0000000049d476d9 in /usr/bin/clickhouse 5. ./build_docker/./base/poco/Net/src/StreamSocket.cpp:109: Poco::Net::StreamSocket::shutdown() @ 0x0000000049d5238e in /usr/bin/clickhouse 6. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:969: Coordination::ZooKeeper::finalize(bool, bool, String const&) @ 0x000000003fb18baf in /usr/bin/clickhouse 7. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: Coordination::ZooKeeper::receiveThread() @ 0x000000003fb2c72e 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*) @ 0x000000003fb3fcd2 in /usr/bin/clickhouse 9. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x0000000020b7c63b 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*) @ 0x0000000020b8b24b in /usr/bin/clickhouse 11. ? @ 0x00007f560e9beac3 in ? 12. ? @ 0x00007f560ea50850 in ? (version 23.8.16.42.altinitystable (altinity build)) 2024.10.22 00:11:26.566833 [ 1039 ] {} DDLWorker: Scheduling tasks 2024.10.22 00:11:26.566946 [ 1040 ] {} DDLWorker: Too early to clean queue, will do it later. 2024.10.22 00:11:26.586795 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Renaming temporary part tmp_insert_202410_1_1_0 to 202410_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:26.710050 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 2 2024.10.22 00:11:27.000216 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.82 GiB, peak 1.83 GiB, free memory in arenas 0.00 B, will set to 1.83 GiB (RSS), difference: 9.75 MiB 2024.10.22 00:11:27.800461 [ 1039 ] {} 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) @ 0x000000004a1acfe9 in /usr/bin/clickhouse 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000002084a673 in /usr/bin/clickhouse 2. ./build_docker/./src/Common/Exception.h:0: DB::Exception::Exception(int, char const (&) [16]) @ 0x0000000020837997 in /usr/bin/clickhouse 3. ./build_docker/./src/Common/ZooKeeper/IKeeper.h:470: Coordination::Exception Coordination::Exception::fromMessage(Coordination::Error, char const (&) [16]) @ 0x000000003faaa076 in /usr/bin/clickhouse 4. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:0: Coordination::ZooKeeper::pushRequest(Coordination::ZooKeeper::RequestInfo&&) @ 0x000000003fb3105c in /usr/bin/clickhouse 5. ./build_docker/./src/Common/ZooKeeper/ZooKeeperImpl.cpp:1329: Coordination::ZooKeeper::list(String const&, Coordination::ListRequestType, std::function, std::shared_ptr>) @ 0x000000003fb3b23f 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) @ 0x000000003fa28702 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) @ 0x000000003fa27846 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) @ 0x000000003fa29d27 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) @ 0x000000003fa28fcd 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) @ 0x000000003fa28bec in /usr/bin/clickhouse 11. ./build_docker/./contrib/llvm-project/libcxx/include/vector:537: DB::DDLWorker::scheduleTasks(bool) @ 0x0000000037a869fa in /usr/bin/clickhouse 12. ./build_docker/./src/Interpreters/DDLWorker.cpp:0: DB::DDLWorker::runMainThread() @ 0x0000000037a7b049 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()() @ 0x0000000037abec07 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*) @ 0x0000000037abea5f in /usr/bin/clickhouse 15. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x0000000020b7c63b 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*) @ 0x0000000020b8b24b in /usr/bin/clickhouse 17. ? @ 0x00007f560e9beac3 in ? 18. ? @ 0x00007f560ea50850 in ? (version 23.8.16.42.altinitystable (altinity build)) 2024.10.22 00:11:28.000230 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.83 GiB, peak 1.83 GiB, free memory in arenas 0.00 B, will set to 1.83 GiB (RSS), difference: 1.28 MiB 2024.10.22 00:11:28.800762 [ 1039 ] {} DDLWorker: Initializing DDLWorker thread 2024.10.22 00:11:28.800902 [ 1039 ] {} Context: Trying to establish a new connection with ZooKeeper 2024.10.22 00:11:28.801880 [ 524 ] {} KeeperTCPHandlerFactory: Keeper request. Address: [::1]:52288 2024.10.22 00:11:28.806180 [ 524 ] {} KeeperTCPHandler: Requesting session ID for the new client 2024.10.22 00:11:28.806486 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.10.22 00:11:28.807065 [ 925 ] {} KeeperStateMachine: Session ID response 2 with timeout 30000 2024.10.22 00:11:28.807455 [ 524 ] {} KeeperTCPHandler: Received session ID 2 2024.10.22 00:11:28.807736 [ 1039 ] {} ZooKeeperClient: Connected to ZooKeeper at [::1]:9181 with session_id 2 2024.10.22 00:11:28.808781 [ 1039 ] {} ZooKeeperClient: Keeper feature flag FILTERED_LIST: enabled 2024.10.22 00:11:28.808866 [ 1039 ] {} ZooKeeperClient: Keeper feature flag MULTI_READ: enabled 2024.10.22 00:11:28.808911 [ 1039 ] {} ZooKeeperClient: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.10.22 00:11:28.809040 [ 1039 ] {} ZooKeeper: Initialized, hosts: localhost:9181 2024.10.22 00:11:28.809280 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 1 2024.10.22 00:11:28.809298 [ 1039 ] {} ZooKeeperClient: ZK send fault: 0.002% 2024.10.22 00:11:28.809402 [ 1039 ] {} ZooKeeperClient: ZK recv fault: 0.002% 2024.10.22 00:11:28.809496 [ 1039 ] {} ZooKeeperClient: ZK send sleep: 0.001% -> 10000ms 2024.10.22 00:11:28.809595 [ 1039 ] {} Context: Establishing a new connection with ZooKeeper took 8 ms 2024.10.22 00:11:28.810818 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.10.22 00:11:28.811773 [ 1039 ] {} DDLWorker: Initialized DDLWorker thread 2024.10.22 00:11:28.811861 [ 1039 ] {} DDLWorker: Scheduling tasks 2024.10.22 00:11:28.811920 [ 1039 ] {} DDLWorker: Don't have unfinished tasks after restarting 2024.10.22 00:11:28.811945 [ 1040 ] {} DDLWorker: Too early to clean queue, will do it later. 2024.10.22 00:11:28.812542 [ 1039 ] {} 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.10.22 00:11:28.812607 [ 1039 ] {} DDLWorker: No tasks to schedule 2024.10.22 00:11:28.812659 [ 1039 ] {} DDLWorker: Waiting for queue updates 2024.10.22 00:11:29.000255 [ 1035 ] {} 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.40 MiB 2024.10.22 00:11:29.372443 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 117 entries to flush up to offset 380 2024.10.22 00:11:29.384909 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:29.385006 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:29.391858 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_2_2_0 (state Temporary) 2024.10.22 00:11:29.396158 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_2_2_0 to 202410_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:29.398127 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 380 2024.10.22 00:11:30.000243 [ 1035 ] {} 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.45 MiB 2024.10.22 00:11:32.463109 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2944 entries to flush up to offset 3444 2024.10.22 00:11:32.492359 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:32.492467 [ 1002 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:32.501852 [ 1002 ] {} MergedBlockOutputStream: filled checksums 202410_2_2_0 (state Temporary) 2024.10.22 00:11:32.504709 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Renaming temporary part tmp_insert_202410_2_2_0 to 202410_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:32.507089 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 3444 2024.10.22 00:11:32.781675 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushing system log, 8 entries to flush up to offset 8 2024.10.22 00:11:32.781865 [ 1001 ] {} SystemLog (system.transactions_info_log): Creating new table system.transactions_info_log for TransactionsInfoLog 2024.10.22 00:11:32.799702 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Loading data parts 2024.10.22 00:11:32.800406 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): There are no data parts 2024.10.22 00:11:32.809745 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:32.809848 [ 1001 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:32.816598 [ 1001 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:11:32.821825 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Renaming temporary part tmp_insert_202410_1_1_0 to 202410_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:32.824196 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 8 2024.10.22 00:11:32.869600 [ 991 ] {} SystemLog (system.trace_log): Flushing system log, 18 entries to flush up to offset 24 2024.10.22 00:11:32.879317 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:32.879423 [ 991 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:32.885593 [ 991 ] {} MergedBlockOutputStream: filled checksums 202410_2_2_0 (state Temporary) 2024.10.22 00:11:32.889969 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Renaming temporary part tmp_insert_202410_2_2_0 to 202410_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:32.892042 [ 991 ] {} SystemLog (system.trace_log): Flushed system log up to offset 24 2024.10.22 00:11:32.892422 [ 999 ] {} SystemLog (system.zookeeper_log): Flushing system log, 8 entries to flush up to offset 26 2024.10.22 00:11:32.911925 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:32.912022 [ 999 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:32.925853 [ 996 ] {} SystemLog (system.query_log): Flushing system log, 2 entries to flush up to offset 4 2024.10.22 00:11:32.956993 [ 996 ] {} system.query_log (cc5a85f7-e64e-4d57-8dc7-3ced08b1d48a): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:32.957103 [ 996 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:32.976855 [ 996 ] {} MergedBlockOutputStream: filled checksums 202410_2_2_0 (state Temporary) 2024.10.22 00:11:32.985029 [ 996 ] {} system.query_log (cc5a85f7-e64e-4d57-8dc7-3ced08b1d48a): Renaming temporary part tmp_insert_202410_2_2_0 to 202410_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:32.989478 [ 996 ] {} SystemLog (system.query_log): Flushed system log up to offset 4 2024.10.22 00:11:33.000211 [ 1035 ] {} 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: 6.81 MiB 2024.10.22 00:11:33.021956 [ 999 ] {} MergedBlockOutputStream: filled checksums 202410_2_2_0 (state Temporary) 2024.10.22 00:11:33.029017 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): Renaming temporary part tmp_insert_202410_2_2_0 to 202410_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:33.031815 [ 999 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 26 2024.10.22 00:11:33.398484 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 41 entries to flush up to offset 421 2024.10.22 00:11:33.404900 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:33.405073 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.64 GiB. 2024.10.22 00:11:33.410562 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_3_3_0 (state Temporary) 2024.10.22 00:11:33.414282 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_3_3_0 to 202410_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:33.416283 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 421 2024.10.22 00:11:34.210310 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 10 entries to flush up to offset 12 2024.10.22 00:11:35.000276 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.85 GiB, peak 1.85 GiB, free memory in arenas 0.00 B, will set to 1.86 GiB (RSS), difference: 8.25 MiB 2024.10.22 00:11:35.035541 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:35.035678 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.55 GiB. 2024.10.22 00:11:35.449577 [ 994 ] {} MergedBlockOutputStream: filled checksums 202410_2_2_0 (state Temporary) 2024.10.22 00:11:35.538928 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Renaming temporary part tmp_insert_202410_2_2_0 to 202410_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:35.560636 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 12 2024.10.22 00:11:36.000264 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.86 GiB, peak 1.86 GiB, free memory in arenas 0.00 B, will set to 1.86 GiB (RSS), difference: 7.83 MiB 2024.10.22 00:11:37.416561 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 14 entries to flush up to offset 435 2024.10.22 00:11:37.421896 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:37.421998 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.32 GiB. 2024.10.22 00:11:37.428145 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_4_4_0 (state Temporary) 2024.10.22 00:11:37.432260 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_4_4_0 to 202410_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:37.434187 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 435 2024.10.22 00:11:38.808144 [ 524 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.10.22 00:11:38.808178 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.10.22 00:11:39.609075 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2576 entries to flush up to offset 6020 2024.10.22 00:11:39.649078 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:39.649361 [ 1002 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.08 GiB. 2024.10.22 00:11:39.666610 [ 1002 ] {} MergedBlockOutputStream: filled checksums 202410_3_3_0 (state Temporary) 2024.10.22 00:11:39.772587 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Renaming temporary part tmp_insert_202410_3_3_0 to 202410_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:39.775950 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 6020 2024.10.22 00:11:40.281325 [ 745 ] {} DNSResolver: Updating DNS cache 2024.10.22 00:11:40.282031 [ 745 ] {} DNSResolver: Updated DNS cache 2024.10.22 00:11:40.324447 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushing system log, 8 entries to flush up to offset 16 2024.10.22 00:11:40.338668 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:40.338806 [ 1001 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.04 GiB. 2024.10.22 00:11:40.348306 [ 1001 ] {} MergedBlockOutputStream: filled checksums 202410_2_2_0 (state Temporary) 2024.10.22 00:11:40.392288 [ 991 ] {} SystemLog (system.trace_log): Flushing system log, 8 entries to flush up to offset 32 2024.10.22 00:11:40.397599 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:40.397693 [ 991 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.04 GiB. 2024.10.22 00:11:40.404207 [ 991 ] {} MergedBlockOutputStream: filled checksums 202410_3_3_0 (state Temporary) 2024.10.22 00:11:40.409566 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Renaming temporary part tmp_insert_202410_3_3_0 to 202410_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:40.412466 [ 991 ] {} SystemLog (system.trace_log): Flushed system log up to offset 32 2024.10.22 00:11:40.456395 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Renaming temporary part tmp_insert_202410_2_2_0 to 202410_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:40.458279 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 16 2024.10.22 00:11:40.532044 [ 999 ] {} SystemLog (system.zookeeper_log): Flushing system log, 1 entries to flush up to offset 27 2024.10.22 00:11:40.541136 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:40.541306 [ 999 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 297.03 GiB. 2024.10.22 00:11:40.551106 [ 999 ] {} MergedBlockOutputStream: filled checksums 202410_3_3_0 (state Temporary) 2024.10.22 00:11:40.659086 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): Renaming temporary part tmp_insert_202410_3_3_0 to 202410_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:40.662173 [ 999 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 27 2024.10.22 00:11:41.000273 [ 1035 ] {} 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.34 MiB 2024.10.22 00:11:41.434396 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 35 entries to flush up to offset 470 2024.10.22 00:11:41.439987 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:41.440081 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.92 GiB. 2024.10.22 00:11:41.445737 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_5_5_0 (state Temporary) 2024.10.22 00:11:41.449523 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_5_5_0 to 202410_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:41.451370 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 470 2024.10.22 00:11:43.060840 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 9 entries to flush up to offset 21 2024.10.22 00:11:43.538422 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:43.538544 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.76 GiB. 2024.10.22 00:11:44.000236 [ 1035 ] {} 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: 8.98 MiB 2024.10.22 00:11:44.470779 [ 994 ] {} MergedBlockOutputStream: filled checksums 202410_3_3_0 (state Temporary) 2024.10.22 00:11:44.971090 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Renaming temporary part tmp_insert_202410_3_3_0 to 202410_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:45.000231 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.88 GiB, peak 1.88 GiB, free memory in arenas 0.00 B, will set to 1.88 GiB (RSS), difference: 3.82 MiB 2024.10.22 00:11:45.195884 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 21 2024.10.22 00:11:45.451628 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 14 entries to flush up to offset 484 2024.10.22 00:11:45.456729 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:45.456836 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.57 GiB. 2024.10.22 00:11:45.462819 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_6_6_0 (state Temporary) 2024.10.22 00:11:45.466970 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_6_6_0 to 202410_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:45.467584 [ 786 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b) (MergerMutator): Selected 6 parts from 202410_1_1_0 to 202410_6_6_0 2024.10.22 00:11:45.467839 [ 786 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:45.467960 [ 786 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.56 GiB. 2024.10.22 00:11:45.468774 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} MergeTask::PrepareStage: Merging 6 parts: from 202410_1_1_0 to 202410_6_6_0 into Compact with storage Full 2024.10.22 00:11:45.469172 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 484 2024.10.22 00:11:45.470639 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.10.22 00:11:45.470945 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_1_1_0, total 263 rows starting from the beginning of the part 2024.10.22 00:11:45.472274 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_2_2_0, total 117 rows starting from the beginning of the part 2024.10.22 00:11:45.473255 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_3_3_0, total 41 rows starting from the beginning of the part 2024.10.22 00:11:45.474028 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_4_4_0, total 14 rows starting from the beginning of the part 2024.10.22 00:11:45.474777 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_5_5_0, total 35 rows starting from the beginning of the part 2024.10.22 00:11:45.475635 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_6_6_0, total 14 rows starting from the beginning of the part 2024.10.22 00:11:45.806835 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} MergeTask::MergeProjectionsStage: Merge sorted 484 rows, containing 13 columns (13 merged, 0 gathered) in 0.338429006 sec., 1430.137462862743 rows/sec., 193.33 KiB/sec. 2024.10.22 00:11:45.810450 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} MergedBlockOutputStream: filled checksums 202410_1_6_1 (state Temporary) 2024.10.22 00:11:45.818468 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_merge_202410_1_6_1 to 202410_1_6_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:45.818758 [ 934 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_6_1} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b) (MergerMutator): Merged 6 parts: [202410_1_1_0, 202410_6_6_0] -> 202410_1_6_1 2024.10.22 00:11:45.820917 [ 934 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 5.16 MiB. 2024.10.22 00:11:46.000235 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.88 GiB, peak 1.88 GiB, free memory in arenas 0.00 B, will set to 1.88 GiB (RSS), difference: 4.15 MiB 2024.10.22 00:11:46.777230 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2578 entries to flush up to offset 8598 2024.10.22 00:11:46.818177 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:46.818339 [ 1002 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.26 GiB. 2024.10.22 00:11:46.837984 [ 1002 ] {} MergedBlockOutputStream: filled checksums 202410_4_4_0 (state Temporary) 2024.10.22 00:11:46.844317 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Renaming temporary part tmp_insert_202410_4_4_0 to 202410_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:46.847973 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 8598 2024.10.22 00:11:47.912774 [ 991 ] {} SystemLog (system.trace_log): Flushing system log, 14 entries to flush up to offset 46 2024.10.22 00:11:47.958483 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushing system log, 14 entries to flush up to offset 30 2024.10.22 00:11:47.963770 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:47.963878 [ 1001 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.46 GiB. 2024.10.22 00:11:48.000218 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.88 GiB, peak 1.89 GiB, free memory in arenas 0.00 B, will set to 1.87 GiB (RSS), difference: -14.96 MiB 2024.10.22 00:11:48.021747 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:48.021917 [ 991 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.46 GiB. 2024.10.22 00:11:48.031027 [ 991 ] {} MergedBlockOutputStream: filled checksums 202410_4_4_0 (state Temporary) 2024.10.22 00:11:48.037940 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Renaming temporary part tmp_insert_202410_4_4_0 to 202410_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:48.040927 [ 991 ] {} SystemLog (system.trace_log): Flushed system log up to offset 46 2024.10.22 00:11:48.070158 [ 1001 ] {} MergedBlockOutputStream: filled checksums 202410_3_3_0 (state Temporary) 2024.10.22 00:11:48.076259 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Renaming temporary part tmp_insert_202410_3_3_0 to 202410_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:48.078460 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 30 2024.10.22 00:11:48.808139 [ 524 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.10.22 00:11:48.808199 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.10.22 00:11:49.000179 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.87 GiB, peak 1.89 GiB, free memory in arenas 0.00 B, will set to 1.86 GiB (RSS), difference: -3.52 MiB 2024.10.22 00:11:49.469406 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 45 entries to flush up to offset 529 2024.10.22 00:11:49.477188 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:49.477312 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.46 GiB. 2024.10.22 00:11:49.483515 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_7_7_0 (state Temporary) 2024.10.22 00:11:49.486908 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_7_7_0 to 202410_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:49.489189 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 529 2024.10.22 00:11:50.000233 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.86 GiB, peak 1.89 GiB, free memory in arenas 0.00 B, will set to 1.86 GiB (RSS), difference: -2.26 MiB 2024.10.22 00:11:52.696134 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 10 entries to flush up to offset 31 2024.10.22 00:11:53.000226 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.86 GiB, peak 1.89 GiB, free memory in arenas 0.00 B, will set to 1.86 GiB (RSS), difference: 2.81 MiB 2024.10.22 00:11:53.257297 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:53.257414 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.46 GiB. 2024.10.22 00:11:53.471484 [ 994 ] {} MergedBlockOutputStream: filled checksums 202410_4_4_0 (state Temporary) 2024.10.22 00:11:53.489470 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 12 entries to flush up to offset 541 2024.10.22 00:11:53.494867 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:53.494982 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.46 GiB. 2024.10.22 00:11:53.500918 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_8_8_0 (state Temporary) 2024.10.22 00:11:53.504670 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_8_8_0 to 202410_8_8_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:53.506662 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 541 2024.10.22 00:11:53.671652 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Renaming temporary part tmp_insert_202410_4_4_0 to 202410_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:53.796741 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 31 2024.10.22 00:11:53.848786 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2576 entries to flush up to offset 11174 2024.10.22 00:11:53.968905 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:53.969010 [ 1002 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.46 GiB. 2024.10.22 00:11:53.978099 [ 1002 ] {} MergedBlockOutputStream: filled checksums 202410_5_5_0 (state Temporary) 2024.10.22 00:11:53.981644 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Renaming temporary part tmp_insert_202410_5_5_0 to 202410_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:53.984425 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 11174 2024.10.22 00:11:54.000172 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.86 GiB, peak 1.89 GiB, free memory in arenas 0.00 B, will set to 1.87 GiB (RSS), difference: 5.31 MiB 2024.10.22 00:11:55.282281 [ 845 ] {} DNSResolver: Updating DNS cache 2024.10.22 00:11:55.282983 [ 845 ] {} DNSResolver: Updated DNS cache 2024.10.22 00:11:55.578646 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushing system log, 6 entries to flush up to offset 36 2024.10.22 00:11:55.582909 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:55.583001 [ 1001 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.46 GiB. 2024.10.22 00:11:55.587973 [ 1001 ] {} MergedBlockOutputStream: filled checksums 202410_4_4_0 (state Temporary) 2024.10.22 00:11:55.592520 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Renaming temporary part tmp_insert_202410_4_4_0 to 202410_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:55.594162 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 36 2024.10.22 00:11:55.662541 [ 999 ] {} SystemLog (system.zookeeper_log): Flushing system log, 1 entries to flush up to offset 28 2024.10.22 00:11:55.672666 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:55.672776 [ 999 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.46 GiB. 2024.10.22 00:11:55.684095 [ 999 ] {} MergedBlockOutputStream: filled checksums 202410_4_4_0 (state Temporary) 2024.10.22 00:11:55.691305 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): Renaming temporary part tmp_insert_202410_4_4_0 to 202410_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:55.694356 [ 999 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 28 2024.10.22 00:11:56.000202 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.87 GiB, peak 1.89 GiB, free memory in arenas 0.00 B, will set to 1.87 GiB (RSS), difference: -1.83 MiB 2024.10.22 00:11:57.506871 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 30 entries to flush up to offset 571 2024.10.22 00:11:57.512234 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:11:57.512331 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.31 GiB. 2024.10.22 00:11:57.517604 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_9_9_0 (state Temporary) 2024.10.22 00:11:57.521214 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_9_9_0 to 202410_9_9_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:11:57.523005 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 571 2024.10.22 00:11:58.808179 [ 524 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.10.22 00:11:58.808288 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.10.22 00:12:00.985478 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 2576 entries to flush up to offset 13750 2024.10.22 00:12:01.108963 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:01.109116 [ 1002 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.00 GiB. 2024.10.22 00:12:01.120392 [ 1002 ] {} MergedBlockOutputStream: filled checksums 202410_6_6_0 (state Temporary) 2024.10.22 00:12:01.124822 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Renaming temporary part tmp_insert_202410_6_6_0 to 202410_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:01.125426 [ 749 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6) (MergerMutator): Selected 6 parts from 202410_1_1_0 to 202410_6_6_0 2024.10.22 00:12:01.125638 [ 749 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:01.125708 [ 749 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 296.00 GiB. 2024.10.22 00:12:01.126707 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} MergeTask::PrepareStage: Merging 6 parts: from 202410_1_1_0 to 202410_6_6_0 into Compact with storage Full 2024.10.22 00:12:01.128008 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.10.22 00:12:01.128193 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_1_1_0, total 500 rows starting from the beginning of the part 2024.10.22 00:12:01.128363 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 13750 2024.10.22 00:12:01.128753 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_2_2_0, total 2944 rows starting from the beginning of the part 2024.10.22 00:12:01.129235 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_3_3_0, total 2576 rows starting from the beginning of the part 2024.10.22 00:12:01.129637 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_4_4_0, total 2578 rows starting from the beginning of the part 2024.10.22 00:12:01.130034 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_5_5_0, total 2576 rows starting from the beginning of the part 2024.10.22 00:12:01.130518 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_6_6_0, total 2576 rows starting from the beginning of the part 2024.10.22 00:12:01.271681 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} MergeTask::MergeProjectionsStage: Merge sorted 13750 rows, containing 4 columns (4 merged, 0 gathered) in 0.145577392 sec., 94451.47911428445 rows/sec., 1.44 MiB/sec. 2024.10.22 00:12:01.274793 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} MergedBlockOutputStream: filled checksums 202410_1_6_1 (state Temporary) 2024.10.22 00:12:01.278102 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Renaming temporary part tmp_merge_202410_1_6_1 to 202410_1_6_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:01.278266 [ 936 ] {c0fe7526-3f9a-4466-94be-727b9b90d9e6::202410_1_6_1} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6) (MergerMutator): Merged 6 parts: [202410_1_1_0, 202410_6_6_0] -> 202410_1_6_1 2024.10.22 00:12:01.280405 [ 936 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 8.16 MiB. 2024.10.22 00:12:01.297095 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 39 2024.10.22 00:12:01.471800 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:01.471955 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.98 GiB. 2024.10.22 00:12:01.523265 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 33 entries to flush up to offset 604 2024.10.22 00:12:01.529828 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:01.529925 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.98 GiB. 2024.10.22 00:12:01.535339 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_10_10_0 (state Temporary) 2024.10.22 00:12:01.538962 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_10_10_0 to 202410_10_10_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:01.540850 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 604 2024.10.22 00:12:02.000226 [ 1035 ] {} AsynchronousMetrics: MemoryTracking: was 1.87 GiB, peak 1.89 GiB, free memory in arenas 0.00 B, will set to 1.88 GiB (RSS), difference: 13.45 MiB 2024.10.22 00:12:02.111017 [ 994 ] {} MergedBlockOutputStream: filled checksums 202410_5_5_0 (state Temporary) 2024.10.22 00:12:02.618003 [ 523 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:43234 2024.10.22 00:12:02.619586 [ 523 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.10.22 00:12:02.619705 [ 523 ] {} TCP-Session: 48f0bb2f-5c31-442d-97e2-88195810b162 Authenticating user 'default' from [::1]:43234 2024.10.22 00:12:02.619792 [ 523 ] {} TCP-Session: 48f0bb2f-5c31-442d-97e2-88195810b162 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:12:02.619856 [ 523 ] {} TCP-Session: 48f0bb2f-5c31-442d-97e2-88195810b162 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:12:02.664060 [ 523 ] {} TCP-Session: 48f0bb2f-5c31-442d-97e2-88195810b162 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.22 00:12:02.665514 [ 523 ] {0f823bc5-fa67-4bec-a39c-7e524d633eed} executeQuery: (from [::1]:43234) ATTACH DATABASE IF NOT EXISTS datasets ENGINE = Ordinary (stage: Complete) 2024.10.22 00:12:02.665878 [ 523 ] {0f823bc5-fa67-4bec-a39c-7e524d633eed} ContextAccess (default): Access granted: CREATE DATABASE ON datasets.* 2024.10.22 00:12:02.721968 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Renaming temporary part tmp_insert_202410_5_5_0 to 202410_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:02.748071 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 39 2024.10.22 00:12:02.881505 [ 523 ] {0f823bc5-fa67-4bec-a39c-7e524d633eed} DatabaseOrdinary (datasets): Metadata processed, database datasets has 2 tables and 0 dictionaries in total. 2024.10.22 00:12:02.881641 [ 523 ] {0f823bc5-fa67-4bec-a39c-7e524d633eed} TablesLoader: Parsed metadata of 2 tables in 1 databases in 0.215299965 sec 2024.10.22 00:12:02.882367 [ 523 ] {0f823bc5-fa67-4bec-a39c-7e524d633eed} ReferentialDeps: No tables 2024.10.22 00:12:02.882479 [ 523 ] {0f823bc5-fa67-4bec-a39c-7e524d633eed} LoadingDeps: Table datasets.visits_v1 has no dependencies (level 0) 2024.10.22 00:12:02.882550 [ 523 ] {0f823bc5-fa67-4bec-a39c-7e524d633eed} LoadingDeps: Table datasets.hits_v1 has no dependencies (level 0) 2024.10.22 00:12:02.882722 [ 523 ] {0f823bc5-fa67-4bec-a39c-7e524d633eed} TablesLoader: Loading 2 tables with dependency level 0 2024.10.22 00:12:03.000232 [ 1035 ] {} 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: 7.25 MiB 2024.10.22 00:12:03.012410 [ 1081 ] {} datasets.hits_v1: Loading data parts 2024.10.22 00:12:03.013285 [ 1081 ] {} datasets.hits_v1: Will load 1 parts using up to 64 threads 2024.10.22 00:12:03.013463 [ 1090 ] {} datasets.hits_v1: Loading Active part 201403_10_18_2 from disk default 2024.10.22 00:12:03.041324 [ 991 ] {} SystemLog (system.trace_log): Flushing system log, 16 entries to flush up to offset 62 2024.10.22 00:12:03.048373 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:03.048492 [ 991 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:03.055628 [ 991 ] {} MergedBlockOutputStream: filled checksums 202410_5_5_0 (state Temporary) 2024.10.22 00:12:03.061752 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Renaming temporary part tmp_insert_202410_5_5_0 to 202410_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:03.064192 [ 991 ] {} SystemLog (system.trace_log): Flushed system log up to offset 62 2024.10.22 00:12:03.094323 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushing system log, 14 entries to flush up to offset 50 2024.10.22 00:12:03.098926 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:03.099020 [ 1001 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:03.104067 [ 1001 ] {} MergedBlockOutputStream: filled checksums 202410_5_5_0 (state Temporary) 2024.10.22 00:12:03.108531 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Renaming temporary part tmp_insert_202410_5_5_0 to 202410_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:03.110440 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 50 2024.10.22 00:12:03.119357 [ 1080 ] {} datasets.visits_v1: Loading data parts 2024.10.22 00:12:03.120349 [ 1080 ] {} datasets.visits_v1: Will load 1 parts using up to 64 threads 2024.10.22 00:12:03.120518 [ 1091 ] {} datasets.visits_v1: Loading Active part 20140317_20140323_3_4_1 from disk default 2024.10.22 00:12:03.162093 [ 1090 ] {} datasets.hits_v1: Finished loading Active part 201403_10_18_2 on disk default 2024.10.22 00:12:03.162753 [ 1081 ] {} datasets.hits_v1: Loaded data parts (1 items) 2024.10.22 00:12:03.194542 [ 999 ] {} SystemLog (system.zookeeper_log): Flushing system log, 1 entries to flush up to offset 29 2024.10.22 00:12:03.304842 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:03.304983 [ 999 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:03.414890 [ 999 ] {} MergedBlockOutputStream: filled checksums 202410_5_5_0 (state Temporary) 2024.10.22 00:12:03.472771 [ 1091 ] {} datasets.visits_v1: Finished loading Active part 20140317_20140323_3_4_1 on disk default 2024.10.22 00:12:03.473576 [ 1080 ] {} datasets.visits_v1: Loaded data parts (1 items) 2024.10.22 00:12:03.475268 [ 523 ] {0f823bc5-fa67-4bec-a39c-7e524d633eed} DatabaseOrdinary (datasets): Starting up tables. 2024.10.22 00:12:03.479698 [ 523 ] {0f823bc5-fa67-4bec-a39c-7e524d633eed} TCPHandler: Processed in 0.816260948 sec. 2024.10.22 00:12:03.481319 [ 523 ] {} TCPHandler: Done processing connection. 2024.10.22 00:12:03.481898 [ 523 ] {} TCP-Session: 48f0bb2f-5c31-442d-97e2-88195810b162 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:12:03.521215 [ 999 ] {} system.zookeeper_log (05827547-b51a-4812-8c33-cd283cb808f4): Renaming temporary part tmp_insert_202410_5_5_0 to 202410_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:03.624238 [ 999 ] {} SystemLog (system.zookeeper_log): Flushed system log up to offset 29 2024.10.22 00:12:03.630912 [ 523 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:43250 2024.10.22 00:12:03.632455 [ 523 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.10.22 00:12:03.632568 [ 523 ] {} TCP-Session: 7e4330fe-3730-49de-9512-a4f36d9c1ed1 Authenticating user 'default' from [::1]:43250 2024.10.22 00:12:03.632656 [ 523 ] {} TCP-Session: 7e4330fe-3730-49de-9512-a4f36d9c1ed1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:12:03.632719 [ 523 ] {} TCP-Session: 7e4330fe-3730-49de-9512-a4f36d9c1ed1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:12:03.675093 [ 523 ] {} TCP-Session: 7e4330fe-3730-49de-9512-a4f36d9c1ed1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.22 00:12:03.676205 [ 523 ] {be54694e-18db-4cb6-8f02-4fc91af3d629} executeQuery: (from [::1]:43250) CREATE DATABASE IF NOT EXISTS test (stage: Complete) 2024.10.22 00:12:03.676370 [ 523 ] {be54694e-18db-4cb6-8f02-4fc91af3d629} ContextAccess (default): Access granted: CREATE DATABASE ON test.* 2024.10.22 00:12:03.677206 [ 523 ] {be54694e-18db-4cb6-8f02-4fc91af3d629} DatabaseAtomic (test): Metadata processed, database test has 0 tables and 0 dictionaries in total. 2024.10.22 00:12:03.677253 [ 523 ] {be54694e-18db-4cb6-8f02-4fc91af3d629} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000180008 sec 2024.10.22 00:12:03.677302 [ 523 ] {be54694e-18db-4cb6-8f02-4fc91af3d629} ReferentialDeps: No tables 2024.10.22 00:12:03.677360 [ 523 ] {be54694e-18db-4cb6-8f02-4fc91af3d629} LoadingDeps: No tables 2024.10.22 00:12:03.677570 [ 523 ] {be54694e-18db-4cb6-8f02-4fc91af3d629} DatabaseAtomic (test): Starting up tables. 2024.10.22 00:12:03.678153 [ 523 ] {be54694e-18db-4cb6-8f02-4fc91af3d629} TCPHandler: Processed in 0.003556311 sec. 2024.10.22 00:12:03.679347 [ 523 ] {} TCPHandler: Done processing connection. 2024.10.22 00:12:03.679991 [ 523 ] {} TCP-Session: 7e4330fe-3730-49de-9512-a4f36d9c1ed1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:12:03.754116 [ 520 ] {} BaseDaemon: Received signal 15 2024.10.22 00:12:03.754324 [ 520 ] {} Application: Received termination signal (Terminated) 2024.10.22 00:12:03.754479 [ 519 ] {} Application: Received termination signal. 2024.10.22 00:12:03.754996 [ 519 ] {} Application: Waiting for current connections to close. 2024.10.22 00:12:04.000271 [ 1035 ] {} 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: 6.01 MiB 2024.10.22 00:12:05.331817 [ 519 ] {} Application: Closed all listening sockets. 2024.10.22 00:12:05.331926 [ 519 ] {} Application: Closed connections. 2024.10.22 00:12:05.335093 [ 519 ] {} Application: Shutting down storages. 2024.10.22 00:12:05.335328 [ 519 ] {} Context: Shutdown disk azure 2024.10.22 00:12:05.335386 [ 519 ] {} DiskObjectStorage(DiskAzureBlobStorage): Shutting down disk azure 2024.10.22 00:12:05.335444 [ 519 ] {} DiskObjectStorage(DiskAzureBlobStorage): Disk azure shut down 2024.10.22 00:12:05.335520 [ 519 ] {} Context: Shutdown disk cached_azure 2024.10.22 00:12:05.335557 [ 519 ] {} DiskObjectStorage(azure): Shutting down disk azure 2024.10.22 00:12:05.335593 [ 519 ] {} DiskObjectStorage(azure): Disk azure shut down 2024.10.22 00:12:05.335612 [ 519 ] {} Context: Shutdown disk default 2024.10.22 00:12:05.335633 [ 519 ] {} Context: Shutdown disk local_cache 2024.10.22 00:12:05.335652 [ 519 ] {} DiskObjectStorage(local_disk): Shutting down disk local_disk 2024.10.22 00:12:05.335682 [ 519 ] {} DiskObjectStorage(local_disk): Disk local_disk shut down 2024.10.22 00:12:05.335721 [ 519 ] {} Context: Shutdown disk local_cache_2 2024.10.22 00:12:05.335752 [ 519 ] {} DiskObjectStorage(local_disk): Shutting down disk local_disk 2024.10.22 00:12:05.335783 [ 519 ] {} DiskObjectStorage(local_disk): Disk local_disk shut down 2024.10.22 00:12:05.335814 [ 519 ] {} Context: Shutdown disk local_cache_3 2024.10.22 00:12:05.335846 [ 519 ] {} DiskObjectStorage(local_disk_3): Shutting down disk local_disk_3 2024.10.22 00:12:05.335874 [ 519 ] {} DiskObjectStorage(local_disk_3): Disk local_disk_3 shut down 2024.10.22 00:12:05.335904 [ 519 ] {} Context: Shutdown disk local_disk 2024.10.22 00:12:05.335930 [ 519 ] {} DiskObjectStorage(Local): Shutting down disk local_disk 2024.10.22 00:12:05.335956 [ 519 ] {} DiskObjectStorage(Local): Disk local_disk shut down 2024.10.22 00:12:05.335985 [ 519 ] {} Context: Shutdown disk local_disk_2 2024.10.22 00:12:05.336006 [ 519 ] {} DiskObjectStorage(Local): Shutting down disk local_disk_2 2024.10.22 00:12:05.336025 [ 519 ] {} DiskObjectStorage(Local): Disk local_disk_2 shut down 2024.10.22 00:12:05.336044 [ 519 ] {} Context: Shutdown disk local_disk_3 2024.10.22 00:12:05.336062 [ 519 ] {} DiskObjectStorage(Local): Shutting down disk local_disk_3 2024.10.22 00:12:05.336080 [ 519 ] {} DiskObjectStorage(Local): Disk local_disk_3 shut down 2024.10.22 00:12:05.336097 [ 519 ] {} Context: Shutdown disk s3_cache 2024.10.22 00:12:05.336116 [ 519 ] {} DiskObjectStorage(s3_disk): Shutting down disk s3_disk 2024.10.22 00:12:05.336137 [ 519 ] {} DiskObjectStorage(s3_disk): Disk s3_disk shut down 2024.10.22 00:12:05.336155 [ 519 ] {} Context: Shutdown disk s3_cache_multi 2024.10.22 00:12:05.336172 [ 519 ] {} DiskObjectStorage(s3_disk): Shutting down disk s3_disk 2024.10.22 00:12:05.336190 [ 519 ] {} DiskObjectStorage(s3_disk): Disk s3_disk shut down 2024.10.22 00:12:05.336206 [ 519 ] {} Context: Shutdown disk s3_cache_multi_2 2024.10.22 00:12:05.336224 [ 519 ] {} DiskObjectStorage(s3_disk): Shutting down disk s3_disk 2024.10.22 00:12:05.336243 [ 519 ] {} DiskObjectStorage(s3_disk): Disk s3_disk shut down 2024.10.22 00:12:05.336259 [ 519 ] {} Context: Shutdown disk s3_disk 2024.10.22 00:12:05.336277 [ 519 ] {} DiskObjectStorage(DiskS3): Shutting down disk s3_disk 2024.10.22 00:12:05.336295 [ 519 ] {} DiskObjectStorage(DiskS3): Disk s3_disk shut down 2024.10.22 00:12:05.336343 [ 519 ] {} AsynchronousInsertQueue: Shutting down the asynchronous insertion queue 2024.10.22 00:12:05.337639 [ 519 ] {} AsynchronousInsertQueue: Asynchronous insertion queue finished 2024.10.22 00:12:05.337724 [ 519 ] {} Context: Shutting down dictionaries loader 2024.10.22 00:12:05.337879 [ 519 ] {} Context: Shutting down UDFs loader 2024.10.22 00:12:05.338016 [ 519 ] {} Context: Shutting down another UDFs loader 2024.10.22 00:12:05.338063 [ 519 ] {} Context: Shutting down named sessions 2024.10.22 00:12:05.338129 [ 519 ] {} Context: Shutting down system logs 2024.10.22 00:12:05.338243 [ 996 ] {} SystemLog (system.query_log): Flushing system log, 4 entries to flush up to offset 8 2024.10.22 00:12:05.462976 [ 996 ] {} system.query_log (cc5a85f7-e64e-4d57-8dc7-3ced08b1d48a): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:05.541123 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 127 entries to flush up to offset 731 2024.10.22 00:12:05.548207 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:05.463115 [ 996 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:05.563593 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:05.569184 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_11_11_0 (state Temporary) 2024.10.22 00:12:05.573554 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_11_11_0 to 202410_11_11_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:05.574139 [ 786 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b) (MergerMutator): Selected 6 parts from 202410_1_6_1 to 202410_11_11_0 2024.10.22 00:12:05.574353 [ 786 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:05.574462 [ 786 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:05.575389 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} MergeTask::PrepareStage: Merging 6 parts: from 202410_1_6_1 to 202410_11_11_0 into Compact with storage Full 2024.10.22 00:12:05.575923 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 731 2024.10.22 00:12:05.577360 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.10.22 00:12:05.577728 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202410_1_6_1, total 484 rows starting from the beginning of the part 2024.10.22 00:12:05.578931 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202410_7_7_0, total 45 rows starting from the beginning of the part 2024.10.22 00:12:05.580125 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202410_8_8_0, total 12 rows starting from the beginning of the part 2024.10.22 00:12:05.581270 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202410_9_9_0, total 30 rows starting from the beginning of the part 2024.10.22 00:12:05.582362 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202410_10_10_0, total 33 rows starting from the beginning of the part 2024.10.22 00:12:05.583551 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} MergeTreeSequentialSource: Reading 2 marks from part 202410_11_11_0, total 127 rows starting from the beginning of the part 2024.10.22 00:12:05.587120 [ 996 ] {} MergedBlockOutputStream: filled checksums 202410_3_3_0 (state Temporary) 2024.10.22 00:12:05.597234 [ 996 ] {} system.query_log (cc5a85f7-e64e-4d57-8dc7-3ced08b1d48a): Renaming temporary part tmp_insert_202410_3_3_0 to 202410_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:05.602136 [ 996 ] {} SystemLog (system.query_log): Flushed system log up to offset 8 2024.10.22 00:12:05.602192 [ 996 ] {} SystemLog (system.query_log): Terminating 2024.10.22 00:12:05.606604 [ 993 ] {} SystemLog (system.query_thread_log): Terminating 2024.10.22 00:12:05.608204 [ 997 ] {} SystemLog (system.part_log): Terminating 2024.10.22 00:12:05.609247 [ 991 ] {} SystemLog (system.trace_log): Flushing system log, 12 entries to flush up to offset 74 2024.10.22 00:12:05.611570 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} MergeTask::MergeProjectionsStage: Merge sorted 731 rows, containing 13 columns (13 merged, 0 gathered) in 0.036578429 sec., 19984.455866051547 rows/sec., 2.54 MiB/sec. 2024.10.22 00:12:05.614484 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:05.614574 [ 991 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:05.614951 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} MergedBlockOutputStream: filled checksums 202410_1_11_2 (state Temporary) 2024.10.22 00:12:05.620128 [ 991 ] {} MergedBlockOutputStream: filled checksums 202410_6_6_0 (state Temporary) 2024.10.22 00:12:05.621288 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_merge_202410_1_11_2 to 202410_1_11_2 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:05.621471 [ 949 ] {f8a2ae40-ebad-48ed-9c0d-e750071f9f1b::202410_1_11_2} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b) (MergerMutator): Merged 6 parts: [202410_1_6_1, 202410_11_11_0] -> 202410_1_11_2 2024.10.22 00:12:05.623421 [ 949 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 5.16 MiB. 2024.10.22 00:12:05.624551 [ 991 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Renaming temporary part tmp_insert_202410_6_6_0 to 202410_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:05.625084 [ 790 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f) (MergerMutator): Selected 6 parts from 202410_1_1_0 to 202410_6_6_0 2024.10.22 00:12:05.625250 [ 790 ] {} system.trace_log (f5d04151-7d1b-4919-bf75-c74a88f5fb0f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:05.625317 [ 790 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:05.626468 [ 935 ] {f5d04151-7d1b-4919-bf75-c74a88f5fb0f::202410_1_6_1} MergeTask::PrepareStage: Merging 6 parts: from 202410_1_1_0 to 202410_6_6_0 into Compact with storage Full 2024.10.22 00:12:05.626847 [ 991 ] {} SystemLog (system.trace_log): Flushed system log up to offset 74 2024.10.22 00:12:05.626890 [ 991 ] {} SystemLog (system.trace_log): Terminating 2024.10.22 00:12:05.629090 [ 935 ] {f5d04151-7d1b-4919-bf75-c74a88f5fb0f::202410_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.10.22 00:12:05.629404 [ 935 ] {f5d04151-7d1b-4919-bf75-c74a88f5fb0f::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_1_1_0, total 6 rows starting from the beginning of the part 2024.10.22 00:12:05.630478 [ 935 ] {f5d04151-7d1b-4919-bf75-c74a88f5fb0f::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_2_2_0, total 18 rows starting from the beginning of the part 2024.10.22 00:12:05.631910 [ 935 ] {f5d04151-7d1b-4919-bf75-c74a88f5fb0f::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_3_3_0, total 8 rows starting from the beginning of the part 2024.10.22 00:12:05.633231 [ 935 ] {f5d04151-7d1b-4919-bf75-c74a88f5fb0f::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_4_4_0, total 14 rows starting from the beginning of the part 2024.10.22 00:12:05.634484 [ 935 ] {f5d04151-7d1b-4919-bf75-c74a88f5fb0f::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_5_5_0, total 16 rows starting from the beginning of the part 2024.10.22 00:12:05.635895 [ 935 ] {f5d04151-7d1b-4919-bf75-c74a88f5fb0f::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_6_6_0, total 12 rows starting from the beginning of the part 2024.10.22 00:12:05.745805 [ 935 ] {} MergeTreeBackgroundExecutor: Code: 236. DB::Exception: Storage is about to be deleted. Done active task as if it was aborted. (ABORTED) 2024.10.22 00:12:05.849883 [ 935 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.19 MiB. 2024.10.22 00:12:05.850398 [ 992 ] {} SystemLog (system.crash_log): Terminating 2024.10.22 00:12:05.850837 [ 995 ] {} SystemLog (system.text_log): Flushing system log, 50 entries to flush up to offset 781 2024.10.22 00:12:05.857225 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:05.857345 [ 995 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:05.862652 [ 995 ] {} MergedBlockOutputStream: filled checksums 202410_12_12_0 (state Temporary) 2024.10.22 00:12:05.966940 [ 995 ] {} system.text_log (f8a2ae40-ebad-48ed-9c0d-e750071f9f1b): Renaming temporary part tmp_insert_202410_12_12_0 to 202410_12_12_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:05.969203 [ 995 ] {} SystemLog (system.text_log): Flushed system log up to offset 781 2024.10.22 00:12:05.969260 [ 995 ] {} SystemLog (system.text_log): Terminating 2024.10.22 00:12:06.559241 [ 994 ] {} SystemLog (system.metric_log): Flushing system log, 5 entries to flush up to offset 44 2024.10.22 00:12:07.034027 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:07.034134 [ 994 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:07.552755 [ 994 ] {} MergedBlockOutputStream: filled checksums 202410_6_6_0 (state Temporary) 2024.10.22 00:12:07.956779 [ 994 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Renaming temporary part tmp_insert_202410_6_6_0 to 202410_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:07.958108 [ 808 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124) (MergerMutator): Selected 6 parts from 202410_1_1_0 to 202410_6_6_0 2024.10.22 00:12:07.958315 [ 808 ] {} system.metric_log (e7375425-7911-4a47-b7f9-b632228a3124): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:07.958391 [ 808 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:07.959056 [ 938 ] {e7375425-7911-4a47-b7f9-b632228a3124::202410_1_6_1} MergeTask::PrepareStage: Merging 6 parts: from 202410_1_1_0 to 202410_6_6_0 into Compact with storage Full 2024.10.22 00:12:08.129327 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 1474 entries to flush up to offset 15224 2024.10.22 00:12:08.146244 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:08.146346 [ 1002 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:08.184740 [ 994 ] {} SystemLog (system.metric_log): Flushed system log up to offset 44 2024.10.22 00:12:08.184835 [ 994 ] {} SystemLog (system.metric_log): Terminating 2024.10.22 00:12:08.235247 [ 938 ] {e7375425-7911-4a47-b7f9-b632228a3124::202410_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.10.22 00:12:08.243931 [ 938 ] {e7375425-7911-4a47-b7f9-b632228a3124::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_1_1_0, total 2 rows starting from the beginning of the part 2024.10.22 00:12:08.256281 [ 1002 ] {} MergedBlockOutputStream: filled checksums 202410_7_7_0 (state Temporary) 2024.10.22 00:12:08.261038 [ 1002 ] {} system.asynchronous_metric_log (c0fe7526-3f9a-4466-94be-727b9b90d9e6): Renaming temporary part tmp_insert_202410_7_7_0 to 202410_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:08.264238 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 15224 2024.10.22 00:12:08.264603 [ 1002 ] {} SystemLog (system.asynchronous_metric_log): Terminating 2024.10.22 00:12:08.265389 [ 998 ] {} SystemLog (system.opentelemetry_span_log): Terminating 2024.10.22 00:12:08.265979 [ 1000 ] {} SystemLog (system.query_views_log): Terminating 2024.10.22 00:12:08.266655 [ 999 ] {} SystemLog (system.zookeeper_log): Terminating 2024.10.22 00:12:08.268012 [ 1005 ] {} SystemLog (system.session_log): Flushing system log, 8 entries to flush up to offset 8 2024.10.22 00:12:08.268233 [ 1005 ] {} SystemLog (system.session_log): Creating new table system.session_log for SessionLog 2024.10.22 00:12:08.301614 [ 1005 ] {} system.session_log (4fb91e7e-b701-43f2-8a5f-3444aaae197c): Loading data parts 2024.10.22 00:12:08.302458 [ 1005 ] {} system.session_log (4fb91e7e-b701-43f2-8a5f-3444aaae197c): There are no data parts 2024.10.22 00:12:08.322941 [ 1005 ] {} system.session_log (4fb91e7e-b701-43f2-8a5f-3444aaae197c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:08.323084 [ 1005 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:08.433719 [ 1005 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:12:08.439337 [ 1005 ] {} system.session_log (4fb91e7e-b701-43f2-8a5f-3444aaae197c): Renaming temporary part tmp_insert_202410_1_1_0 to 202410_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:08.442192 [ 1005 ] {} SystemLog (system.session_log): Flushed system log up to offset 8 2024.10.22 00:12:08.442256 [ 1005 ] {} SystemLog (system.session_log): Terminating 2024.10.22 00:12:08.444298 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushing system log, 16 entries to flush up to offset 66 2024.10.22 00:12:08.449012 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:08.449106 [ 1001 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:08.454264 [ 1001 ] {} MergedBlockOutputStream: filled checksums 202410_6_6_0 (state Temporary) 2024.10.22 00:12:08.458764 [ 1001 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Renaming temporary part tmp_insert_202410_6_6_0 to 202410_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.22 00:12:08.459505 [ 815 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd) (MergerMutator): Selected 6 parts from 202410_1_1_0 to 202410_6_6_0 2024.10.22 00:12:08.459716 [ 815 ] {} system.transactions_info_log (00f682c3-62e1-405d-a545-3a58c5524bcd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:08.459811 [ 815 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 295.93 GiB. 2024.10.22 00:12:08.460559 [ 1001 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 66 2024.10.22 00:12:08.460606 [ 1001 ] {} SystemLog (system.transactions_info_log): Terminating 2024.10.22 00:12:08.460600 [ 940 ] {00f682c3-62e1-405d-a545-3a58c5524bcd::202410_1_6_1} MergeTask::PrepareStage: Merging 6 parts: from 202410_1_1_0 to 202410_6_6_0 into Compact with storage Full 2024.10.22 00:12:08.462411 [ 940 ] {00f682c3-62e1-405d-a545-3a58c5524bcd::202410_1_6_1} MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal 2024.10.22 00:12:08.462633 [ 940 ] {00f682c3-62e1-405d-a545-3a58c5524bcd::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_1_1_0, total 8 rows starting from the beginning of the part 2024.10.22 00:12:08.498089 [ 938 ] {e7375425-7911-4a47-b7f9-b632228a3124::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_2_2_0, total 10 rows starting from the beginning of the part 2024.10.22 00:12:08.563883 [ 940 ] {00f682c3-62e1-405d-a545-3a58c5524bcd::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_2_2_0, total 8 rows starting from the beginning of the part 2024.10.22 00:12:08.564672 [ 940 ] {00f682c3-62e1-405d-a545-3a58c5524bcd::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_3_3_0, total 14 rows starting from the beginning of the part 2024.10.22 00:12:08.565392 [ 940 ] {00f682c3-62e1-405d-a545-3a58c5524bcd::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_4_4_0, total 6 rows starting from the beginning of the part 2024.10.22 00:12:08.566090 [ 940 ] {00f682c3-62e1-405d-a545-3a58c5524bcd::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_5_5_0, total 14 rows starting from the beginning of the part 2024.10.22 00:12:08.566780 [ 940 ] {00f682c3-62e1-405d-a545-3a58c5524bcd::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_6_6_0, total 16 rows starting from the beginning of the part 2024.10.22 00:12:08.572780 [ 940 ] {} MergeTreeBackgroundExecutor: Code: 236. DB::Exception: Storage is about to be deleted. Done active task as if it was aborted. (ABORTED) 2024.10.22 00:12:08.575337 [ 940 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.18 MiB. 2024.10.22 00:12:08.575709 [ 1007 ] {} SystemLog (system.processors_profile_log): Terminating 2024.10.22 00:12:08.576319 [ 1003 ] {} SystemLog (system.filesystem_cache_log): Terminating 2024.10.22 00:12:08.576980 [ 1004 ] {} SystemLog (system.asynchronous_insert_log): Terminating 2024.10.22 00:12:08.577624 [ 519 ] {} Context: Shutting down database catalog 2024.10.22 00:12:08.577722 [ 519 ] {} DatabaseCatalog: Shutting down database INFORMATION_SCHEMA 2024.10.22 00:12:08.580875 [ 519 ] {} DatabaseCatalog: Shutting down database datasets 2024.10.22 00:12:08.589696 [ 519 ] {} DatabaseCatalog: Shutting down database default 2024.10.22 00:12:08.589736 [ 519 ] {} DatabaseCatalog: Shutting down database information_schema 2024.10.22 00:12:08.591959 [ 519 ] {} DatabaseCatalog: Shutting down database test 2024.10.22 00:12:08.591999 [ 519 ] {} DatabaseCatalog: Shutting down system databases 2024.10.22 00:12:08.645327 [ 938 ] {e7375425-7911-4a47-b7f9-b632228a3124::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_3_3_0, total 9 rows starting from the beginning of the part 2024.10.22 00:12:08.791862 [ 938 ] {e7375425-7911-4a47-b7f9-b632228a3124::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_4_4_0, total 10 rows starting from the beginning of the part 2024.10.22 00:12:08.808131 [ 524 ] {} KeeperTCPHandler: Received heartbeat for session #2 2024.10.22 00:12:08.808175 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.10.22 00:12:08.934920 [ 938 ] {e7375425-7911-4a47-b7f9-b632228a3124::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_5_5_0, total 8 rows starting from the beginning of the part 2024.10.22 00:12:09.283466 [ 938 ] {e7375425-7911-4a47-b7f9-b632228a3124::202410_1_6_1} MergeTreeSequentialSource: Reading 2 marks from part 202410_6_6_0, total 5 rows starting from the beginning of the part 2024.10.22 00:12:09.428275 [ 938 ] {e7375425-7911-4a47-b7f9-b632228a3124::202410_1_6_1} SortDescription: Compile sort description Date 1 1DateTime 1 1 2024.10.22 00:12:09.910455 [ 938 ] {} MergeTreeBackgroundExecutor: Code: 236. DB::Exception: Storage is about to be deleted. Done active task as if it was aborted. (ABORTED) 2024.10.22 00:12:10.071095 [ 938 ] {} MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.15 MiB. 2024.10.22 00:12:10.384408 [ 519 ] {} Context: Shutting down merges executor 2024.10.22 00:12:10.384822 [ 519 ] {} Context: Shutting down fetches executor 2024.10.22 00:12:10.384985 [ 519 ] {} Context: Shutting down moves executor 2024.10.22 00:12:10.385138 [ 519 ] {} Context: Shutting down common executor 2024.10.22 00:12:10.385379 [ 519 ] {} Context: Shutting down DDLWorker 2024.10.22 00:12:10.385724 [ 519 ] {} Context: Shutting down caches 2024.10.22 00:12:10.386258 [ 519 ] {} Context: Shutting down AccessControl 2024.10.22 00:12:10.611055 [ 519 ] {} ExternalUserDefinedExecutableFunctionsLoader: Unloading 'test_function' because its configuration has been removed or detached 2024.10.22 00:12:10.841208 [ 519 ] {} ZooKeeperClient: Finalizing session 2. finalization_started: false, queue_finished: false, reason: 'Destructor called' 2024.10.22 00:12:10.841529 [ 524 ] {} KeeperTCPHandler: Received close event with xid 2147483647 for session id #2 2024.10.22 00:12:10.841574 [ 899 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.10.22 00:12:10.842089 [ 524 ] {} KeeperTCPHandler: Session #2 successfully closed 2024.10.22 00:12:10.845438 [ 519 ] {} BackgroundSchedulePool/BgBufSchPool: Waiting for threads to finish. 2024.10.22 00:12:10.846045 [ 519 ] {} BackgroundSchedulePool/BgSchPool: Waiting for threads to finish. 2024.10.22 00:12:10.846296 [ 519 ] {} BackgroundSchedulePool/BgDistSchPool: Waiting for threads to finish. 2024.10.22 00:12:10.846450 [ 519 ] {} BackgroundSchedulePool/BgMBSchPool: Waiting for threads to finish. 2024.10.22 00:12:10.847471 [ 519 ] {} Application: Shut down storages. 2024.10.22 00:12:10.847532 [ 519 ] {} Application: Waiting for current connections to servers for tables to finish. 2024.10.22 00:12:11.089396 [ 519 ] {} Application: Closed all listening sockets. 2024.10.22 00:12:11.089526 [ 519 ] {} Application: Closed connections to servers for tables. 2024.10.22 00:12:11.089608 [ 519 ] {} KeeperDispatcher: Shutting down storage dispatcher 2024.10.22 00:12:11.292402 [ 519 ] {} RaftInstance: shutting down raft core 2024.10.22 00:12:11.292523 [ 519 ] {} RaftInstance: sent stop signal to the commit thread. 2024.10.22 00:12:11.292649 [ 519 ] {} RaftInstance: cancelled all schedulers. 2024.10.22 00:12:11.292724 [ 519 ] {} RaftInstance: commit thread stopped. 2024.10.22 00:12:11.292793 [ 519 ] {} RaftInstance: all pending commit elements dropped. 2024.10.22 00:12:11.292855 [ 519 ] {} RaftInstance: reset all pointers. 2024.10.22 00:12:11.293016 [ 519 ] {} RaftInstance: joined terminated commit thread. 2024.10.22 00:12:11.293181 [ 519 ] {} RaftInstance: sent stop signal to background append thread. 2024.10.22 00:12:11.293212 [ 926 ] {} RaftInstance: bg append_entries thread terminated 2024.10.22 00:12:11.293468 [ 519 ] {} RaftInstance: clean up auto-forwarding queue: 0 elems 2024.10.22 00:12:11.293539 [ 519 ] {} RaftInstance: clean up auto-forwarding clients 2024.10.22 00:12:11.293612 [ 519 ] {} RaftInstance: raft_server shutdown completed. 2024.10.22 00:12:11.293671 [ 519 ] {} RaftInstance: manually create a snapshot on 17 2024.10.22 00:12:11.293732 [ 519 ] {} RaftInstance: creating a snapshot for index 17 2024.10.22 00:12:11.293791 [ 519 ] {} RaftInstance: create snapshot idx 17 log_term 1 2024.10.22 00:12:11.293858 [ 519 ] {} KeeperStateMachine: Creating snapshot 17 2024.10.22 00:12:11.293987 [ 519 ] {} KeeperStateMachine: Creating a snapshot during shutdown because 'create_snapshot_on_exit' is enabled. 2024.10.22 00:12:11.298370 [ 519 ] {} KeeperStateMachine: Created persistent snapshot 17 with path snapshot_17.bin.zstd 2024.10.22 00:12:11.298445 [ 519 ] {} KeeperStateMachine: Clearing garbage after snapshot 2024.10.22 00:12:11.298502 [ 519 ] {} KeeperStateMachine: Cleared garbage after snapshot 2024.10.22 00:12:11.298581 [ 519 ] {} RaftInstance: snapshot idx 17 log_term 1 created, compact the log store if needed 2024.10.22 00:12:11.298649 [ 519 ] {} KeeperStateMachine: Uploading snapshot snapshot_17.bin.zstd during shutdown because 'upload_snapshot_on_exit' is enabled. 2024.10.22 00:12:11.298718 [ 519 ] {} RaftInstance: create snapshot idx 17 log_term 1 done: 4868 us elapsed 2024.10.22 00:12:11.298902 [ 912 ] {} RaftInstance: failed to accept a rpc connection due to error 125, Operation canceled 2024.10.22 00:12:11.299022 [ 911 ] {} RaftInstance: end of asio worker thread, remaining threads: 14 2024.10.22 00:12:11.299036 [ 915 ] {} RaftInstance: end of asio worker thread, remaining threads: 11 2024.10.22 00:12:11.299013 [ 909 ] {} RaftInstance: end of asio worker thread, remaining threads: 15 2024.10.22 00:12:11.299045 [ 917 ] {} RaftInstance: end of asio worker thread, remaining threads: 12 2024.10.22 00:12:11.299081 [ 910 ] {} RaftInstance: end of asio worker thread, remaining threads: 13 2024.10.22 00:12:11.299109 [ 914 ] {} RaftInstance: end of asio worker thread, remaining threads: 8 2024.10.22 00:12:11.299106 [ 913 ] {} RaftInstance: end of asio worker thread, remaining threads: 10 2024.10.22 00:12:11.299337 [ 918 ] {} RaftInstance: end of asio worker thread, remaining threads: 1 2024.10.22 00:12:11.299079 [ 916 ] {} RaftInstance: end of asio worker thread, remaining threads: 9 2024.10.22 00:12:11.299182 [ 923 ] {} RaftInstance: end of asio worker thread, remaining threads: 7 2024.10.22 00:12:11.299204 [ 921 ] {} RaftInstance: end of asio worker thread, remaining threads: 5 2024.10.22 00:12:11.299210 [ 924 ] {} RaftInstance: end of asio worker thread, remaining threads: 4 2024.10.22 00:12:11.299224 [ 922 ] {} RaftInstance: end of asio worker thread, remaining threads: 2 2024.10.22 00:12:11.299221 [ 919 ] {} RaftInstance: end of asio worker thread, remaining threads: 3 2024.10.22 00:12:11.299233 [ 920 ] {} RaftInstance: end of asio worker thread, remaining threads: 6 2024.10.22 00:12:11.309433 [ 912 ] {} RaftInstance: end of asio worker thread, remaining threads: 0 2024.10.22 00:12:11.309811 [ 906 ] {} KeeperLogStore: Raft server is not set in LogStore. 2024.10.22 00:12:11.311873 [ 519 ] {} KeeperSnapshotManagerS3: Shutting down KeeperSnapshotManagerS3 2024.10.22 00:12:11.312038 [ 519 ] {} KeeperSnapshotManagerS3: KeeperSnapshotManagerS3 shut down 2024.10.22 00:12:11.312108 [ 519 ] {} KeeperDispatcher: Dispatcher shut down 2024.10.22 00:12:11.312169 [ 519 ] {} Context: Destructing remote fs threadpool reader 2024.10.22 00:12:11.312231 [ 519 ] {} Context: Destructing threadpool writer 2024.10.22 00:12:11.312366 [ 519 ] {} Context: Destructing marks loader 2024.10.22 00:12:11.322674 [ 519 ] {} Application: Destroyed global context. 2024.10.22 00:12:11.323879 [ 519 ] {} KeeperLogStore: Changelog is shut down 2024.10.22 00:12:11.432976 [ 519 ] {} Application: shutting down 2024.10.22 00:12:11.433064 [ 519 ] {} Application: Uninitializing subsystem: Logging Subsystem 2024.10.22 00:12:11.456023 [ 520 ] {} BaseDaemon: Received signal -2 2024.10.22 00:12:11.456092 [ 520 ] {} BaseDaemon: Stop SignalListener thread 2024.10.22 00:12:11.783558 [ 518 ] {} Application: Child process exited normally with code 0.