2024.10.22 00:06:58.777038 [ 466 ] {} Application: Will watch for the process with pid 468 2024.10.22 00:06:58.777294 [ 468 ] {} Application: Forked a child process to watch 2024.10.22 00:06:58.778539 [ 468 ] {} SentryWriter: Sending crash reports is disabled 2024.10.22 00:06:58.779066 [ 468 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.10.22 00:06:59.882049 [ 468 ] {} Application: Starting ClickHouse 23.8.16.42.altinitystable (revision: 54477, git hash: 46d4f9bd6a40e43bf5543be25cc704364e0c737b, build id: 357BD09AC2B3A46F0B44F66168828D9D6CC8F70F), PID 468 2024.10.22 00:06:59.886041 [ 468 ] {} Application: starting up 2024.10.22 00:06:59.886300 [ 468 ] {} Application: OS name: Linux, version: 5.15.0-122-generic, architecture: x86_64 2024.10.22 00:06:59.936072 [ 468 ] {} Context: Server was built in debug mode. It will work slowly. 2024.10.22 00:06:59.939093 [ 468 ] {} Context: ThreadFuzzer is enabled. Application will run slowly and unstable. 2024.10.22 00:06:59.944769 [ 468 ] {} Application: Available RAM: 30.60 GiB; physical cores: 16; logical cores: 16. 2024.10.22 00:07:00.034053 [ 468 ] {} 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:07:00.147458 [ 468 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2024.10.22 00:07:00.148985 [ 468 ] {} AsynchronousMetrics: Scanning /sys/block 2024.10.22 00:07:00.172992 [ 468 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2024.10.22 00:07:00.174069 [ 468 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2024.10.22 00:07:17.598149 [ 468 ] {} Application: Integrity check of the executable successfully passed (checksum: 14165EF9ABB7482E2085E723F61605D4) 2024.10.22 00:07:17.607086 [ 468 ] {} Application: Will do mlock to prevent executable memory from being paged out. It may take a few seconds. 2024.10.22 00:07:17.643557 [ 468 ] {} Application: The memory map of clickhouse executable has been mlock'ed, total 471.31 MiB 2024.10.22 00:07:17.647243 [ 468 ] {} Application: Set OOM score adjustment to 555 2024.10.22 00:07:17.660767 [ 468 ] {} Application: Set max number of file descriptors to 1048576 (was 1024). 2024.10.22 00:07:17.662155 [ 468 ] {} Application: rlimit on number of threads is 18446744073709551615 2024.10.22 00:07:17.677353 [ 468 ] {} Application: Initializing DateLUT. 2024.10.22 00:07:17.678916 [ 468 ] {} Application: Initialized DateLUT with time zone 'Europe/Amsterdam'. 2024.10.22 00:07:17.687043 [ 468 ] {} Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it 2024.10.22 00:07:17.705397 [ 468 ] {} TLDListsHolder: public_suffix_list loading from /etc/clickhouse-server/top_level_domains/public_suffix_list.dat 2024.10.22 00:07:18.746543 [ 468 ] {} TLDListsHolder: public_suffix_list was added (9084 hosts) 2024.10.22 00:07:18.750631 [ 468 ] {} TLDListsHolder: no_new_line_list loading from /etc/clickhouse-server/top_level_domains/no_new_line_list.dat 2024.10.22 00:07:18.757018 [ 468 ] {} TLDListsHolder: no_new_line_list was added (1 hosts) 2024.10.22 00:07:18.760904 [ 468 ] {} 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:07:18.866463 [ 468 ] {} Application: Initializing MergeTree metadata cache, lru_cache_size: 256.00 MiB continue_if_corrupted: true 2024.10.22 00:07:20.180193 [ 468 ] {} Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use 'f111be1a9f3c' as replica host. 2024.10.22 00:07:20.186230 [ 468 ] {} Application: Initializing interserver credentials. 2024.10.22 00:07:20.868941 [ 468 ] {} NamedCollectionsUtils: Loaded 6 collections from config 2024.10.22 00:07:20.874594 [ 468 ] {} NamedCollectionsUtils: Loaded 0 collections from SQL 2024.10.22 00:07:20.881063 [ 468 ] {} SensitiveDataMaskerConfigRead: 1 query masking rules loaded. 2024.10.22 00:07:20.900922 [ 468 ] {} ConfigReloader: Loading config '/etc/clickhouse-server/config.xml' 2024.10.22 00:07:23.825543 [ 468 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/config.xml', performing update on configuration 2024.10.22 00:07:25.969112 [ 468 ] {} 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:07:25.970793 [ 468 ] {} 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:07:25.972936 [ 468 ] {} Application: Merges and mutations memory limit is set to 15.30 GiB 2024.10.22 00:07:28.255657 [ 468 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.10.22 00:07:28.276079 [ 468 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.10.22 00:07:29.047295 [ 468 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.10.22 00:07:29.232778 [ 468 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.10.22 00:07:29.398735 [ 468 ] {} CertificateReloader: Reloading certificate (/etc/clickhouse-server/server.crt) and key (/etc/clickhouse-server/server.key). 2024.10.22 00:07:29.438361 [ 468 ] {} CertificateReloader: Reloaded certificate (/etc/clickhouse-server/server.crt) and key (/etc/clickhouse-server/server.key). 2024.10.22 00:07:29.441982 [ 468 ] {} CertificateReloader: Initializing certificate reloader. 2024.10.22 00:07:29.708652 [ 468 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/config.xml', performed update on configuration 2024.10.22 00:07:29.774310 [ 468 ] {} Context: Keeper server is participant of the main zookeeper cluster, will try to connect to it 2024.10.22 00:07:29.800319 [ 468 ] {} Context: Cannot connect to ZooKeeper (or Keeper) before internal Keeper start, will wait for Keeper synchronously 2024.10.22 00:07:29.831605 [ 468 ] {} KeeperDispatcher: Initializing storage dispatcher 2024.10.22 00:07:29.968610 [ 468 ] {} KeeperContext: Keeper feature flag FILTERED_LIST: enabled 2024.10.22 00:07:29.975241 [ 468 ] {} KeeperContext: Keeper feature flag MULTI_READ: enabled 2024.10.22 00:07:29.976890 [ 468 ] {} KeeperContext: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.10.22 00:07:29.990160 [ 468 ] {} KeeperContext: Disk type 'azure_blob_storage' is not supported for Keeper 2024.10.22 00:07:29.999630 [ 468 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:07:33.677776 [ 468 ] {} S3Client: Provider type: Unknown 2024.10.22 00:07:33.678525 [ 468 ] {} S3Client: API mode of the S3 client: AWS 2024.10.22 00:07:35.675233 [ 468 ] {} WriteBufferFromS3: Create WriteBufferFromS3, Details: bucket test, key common/clickhouse_remove_objects_capability_fdaabc72-1a82-4137-b6d4-08f8e5beda7c 2024.10.22 00:07:35.676443 [ 468 ] {} WriteBufferFromS3: finalizeImpl WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_fdaabc72-1a82-4137-b6d4-08f8e5beda7c. 2024.10.22 00:07:35.763984 [ 779 ] {} HTTPSessionAdapter: Created HTTP(S) session with localhost:11111 (::1:11111) 2024.10.22 00:07:35.799677 [ 779 ] {} WriteBufferFromS3: Single part upload has completed. Details: bucket test, key common/clickhouse_remove_objects_capability_fdaabc72-1a82-4137-b6d4-08f8e5beda7c, size 4 2024.10.22 00:07:35.803595 [ 468 ] {} WriteBufferFromS3: Close WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_fdaabc72-1a82-4137-b6d4-08f8e5beda7c. 2024.10.22 00:07:35.831997 [ 468 ] {} S3ObjectStorage: Objects with paths [common/clickhouse_remove_objects_capability_fdaabc72-1a82-4137-b6d4-08f8e5beda7c] were removed from S3 2024.10.22 00:07:36.567782 [ 468 ] {} S3ObjectStorage: Objects with paths [common/aag/piwkbzegjbuhpwvaypjgnwqsgsxmc] were removed from S3 2024.10.22 00:07:36.568913 [ 468 ] {} DiskObjectStorage(DiskS3): Starting up disk s3_disk 2024.10.22 00:07:36.570360 [ 468 ] {} DiskObjectStorage(DiskS3): Disk s3_disk started up 2024.10.22 00:07:36.573427 [ 468 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:07:36.594167 [ 468 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.10.22 00:07:36.610629 [ 468 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.10.22 00:07:36.629061 [ 468 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.10.22 00:07:36.631786 [ 468 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:07:36.736597 [ 468 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:07:36.739484 [ 468 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:07:36.744586 [ 468 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:07:36.749505 [ 468 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.10.22 00:07:36.776699 [ 468 ] {} KeeperSnapshotManager: Reading from disk LocalSnapshotDisk 2024.10.22 00:07:36.910462 [ 468 ] {} KeeperLogStore: Reading from disk LocalLogDisk 2024.10.22 00:07:36.912321 [ 468 ] {} 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:07:36.917318 [ 468 ] {} KeeperLogStore: force_sync disabled 2024.10.22 00:07:36.919184 [ 468 ] {} KeeperDispatcher: Waiting server to initialize 2024.10.22 00:07:36.920490 [ 468 ] {} KeeperStateMachine: Totally have 0 snapshots 2024.10.22 00:07:36.921397 [ 468 ] {} KeeperStateMachine: No existing snapshots, last committed log index 0 2024.10.22 00:07:36.923808 [ 468 ] {} KeeperLogStore: Removing all changelogs 2024.10.22 00:07:36.925129 [ 468 ] {} Changelog: Starting new changelog changelog_1_100000.bin.zstd 2024.10.22 00:07:36.928521 [ 468 ] {} KeeperServer: Preprocessing 0 log entries 2024.10.22 00:07:36.929677 [ 468 ] {} KeeperServer: Preprocessing done 2024.10.22 00:07:36.931556 [ 468 ] {} KeeperServer: No config in log store and snapshot, probably it's initial run. Will use config from .xml on disk 2024.10.22 00:07:36.951133 [ 468 ] {} 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:07:37.067766 [ 468 ] {} RaftInstance: Raft ASIO listener initiated on :::9234, unsecured 2024.10.22 00:07:37.069622 [ 468 ] {} KeeperStateManager: No state was read 2024.10.22 00:07:37.072637 [ 468 ] {} RaftInstance: invalid election timeout lower bound detected, adjusted to 0 2024.10.22 00:07:37.074374 [ 468 ] {} RaftInstance: invalid election timeout upper bound detected, adjusted to 0 2024.10.22 00:07:37.075934 [ 468 ] {} 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:07:37.078395 [ 468 ] {} RaftInstance: new election timeout range: 0 - 0 2024.10.22 00:07:37.096182 [ 468 ] {} 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:07:37.099407 [ 468 ] {} RaftInstance: peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 2024.10.22 00:07:37.102597 [ 468 ] {} RaftInstance: global manager does not exist. will use local thread for commit and append 2024.10.22 00:07:37.103967 [ 468 ] {} RaftInstance: wait for HB, for 50 + [0, 0] ms 2024.10.22 00:07:37.181490 [ 468 ] {} KeeperDispatcher: Server initialized, waiting for quorum 2024.10.22 00:07:37.178326 [ 794 ] {} RaftInstance: Election timeout, initiate leader election 2024.10.22 00:07:37.188627 [ 794 ] {} RaftInstance: [PRIORITY] decay, target 1 -> 1, mine 1 2024.10.22 00:07:37.275154 [ 803 ] {} RaftInstance: bg append_entries thread initiated 2024.10.22 00:07:37.298383 [ 794 ] {} 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:07:37.446415 [ 794 ] {} 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:07:37.494453 [ 794 ] {} RaftInstance: number of pending commit elements: 0 2024.10.22 00:07:37.525283 [ 794 ] {} RaftInstance: state machine commit index 0, precommit index 0, last log index 0 2024.10.22 00:07:37.644878 [ 794 ] {} RaftInstance: [BECOME LEADER] appended new config at 1 2024.10.22 00:07:37.772988 [ 802 ] {} RaftInstance: config at index 1 is committed, prev config log idx 0 2024.10.22 00:07:37.782955 [ 802 ] {} RaftInstance: new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 2024.10.22 00:07:37.791859 [ 802 ] {} 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:07:37.804050 [ 468 ] {} KeeperDispatcher: Quorum initialized 2024.10.22 00:07:37.805605 [ 468 ] {} KeeperDispatcher: Dispatcher initialized 2024.10.22 00:07:37.828036 [ 468 ] {} Application: Listening for Keeper (tcp): [::]:9181 2024.10.22 00:07:37.829815 [ 468 ] {} Application: Listening for replica communication (interserver): http://[::]:9009 2024.10.22 00:07:37.867691 [ 468 ] {} ConfigReloader: Loading config '/etc/clickhouse-server/users.xml' 2024.10.22 00:07:38.151090 [ 468 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performing update on configuration 2024.10.22 00:07:40.028786 [ 468 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performed update on configuration 2024.10.22 00:07:40.043611 [ 468 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /etc/clickhouse-server/users.xml 2024.10.22 00:07:40.049749 [ 468 ] {} Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist 2024.10.22 00:07:40.051188 [ 468 ] {} Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/ 2024.10.22 00:07:40.159557 [ 468 ] {} Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/ 2024.10.22 00:07:40.298112 [ 468 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.10.22 00:07:40.320177 [ 468 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.10.22 00:07:40.357061 [ 468 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.10.22 00:07:40.395338 [ 468 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.10.22 00:07:40.531984 [ 468 ] {} DNSCacheUpdater: Update period 15 seconds 2024.10.22 00:07:40.546623 [ 468 ] {} Application: Loading metadata from /var/lib/clickhouse/ 2024.10.22 00:07:40.566042 [ 596 ] {} DNSResolver: Updating DNS cache 2024.10.22 00:07:40.770446 [ 468 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.10.22 00:07:40.774911 [ 468 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.026528865 sec 2024.10.22 00:07:40.778577 [ 468 ] {} ReferentialDeps: No tables 2024.10.22 00:07:40.779584 [ 468 ] {} LoadingDeps: No tables 2024.10.22 00:07:40.819462 [ 468 ] {} DatabaseAtomic (system): Starting up tables. 2024.10.22 00:07:40.859247 [ 596 ] {} DNSResolver: Updated DNS cache 2024.10.22 00:07:40.863775 [ 596 ] {} DNSCacheUpdater: Execution took 317 ms. 2024.10.22 00:07:40.938258 [ 468 ] {} SystemLog: Creating system.query_log from query_log 2024.10.22 00:07:42.080887 [ 468 ] {} SystemLog: Creating system.query_thread_log from query_thread_log 2024.10.22 00:07:42.227330 [ 468 ] {} SystemLog: Creating system.part_log from part_log 2024.10.22 00:07:42.268440 [ 468 ] {} SystemLog: Creating system.trace_log from trace_log 2024.10.22 00:07:42.298202 [ 468 ] {} SystemLog: Creating system.crash_log from crash_log 2024.10.22 00:07:42.312337 [ 468 ] {} SystemLog: Creating system.text_log from text_log 2024.10.22 00:07:42.346397 [ 468 ] {} SystemLog: Creating system.metric_log from metric_log 2024.10.22 00:07:44.203444 [ 468 ] {} SystemLog: Creating system.filesystem_cache_log from filesystem_cache_log 2024.10.22 00:07:44.447012 [ 468 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.10.22 00:07:44.452784 [ 468 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2024.10.22 00:07:44.479678 [ 468 ] {} SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log 2024.10.22 00:07:44.634207 [ 468 ] {} SystemLog: Creating system.query_views_log from query_views_log 2024.10.22 00:07:44.765267 [ 468 ] {} SystemLog: Creating system.zookeeper_log from zookeeper_log 2024.10.22 00:07:45.174951 [ 468 ] {} SystemLog: Creating system.session_log from session_log 2024.10.22 00:07:45.546846 [ 468 ] {} SystemLog: Creating system.transactions_info_log from transactions_info_log 2024.10.22 00:07:45.698118 [ 468 ] {} SystemLog: Creating system.processors_profile_log from processors_profile_log 2024.10.22 00:07:45.820197 [ 468 ] {} SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log 2024.10.22 00:07:46.104672 [ 468 ] {} 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:07:50.282162 [ 895 ] {} SystemLog (system.text_log): Flushing system log, 153 entries to flush up to offset 153 2024.10.22 00:07:50.329100 [ 895 ] {} SystemLog (system.text_log): Creating new table system.text_log for TextLog 2024.10.22 00:07:50.818250 [ 895 ] {} WriteBufferFromAzureBlobStorage: Staged block (id: ndtfceioigtawefdadvngyczoastmrlfetnhotraeitncgklbdqfcuswpfjrybnr) of size 4 (blob path: puxbbxevtjytsbvoqabfmktgxkzqzwxf). 2024.10.22 00:07:50.928491 [ 895 ] {} WriteBufferFromAzureBlobStorage: Committed 1 blocks for blob `puxbbxevtjytsbvoqabfmktgxkzqzwxf` 2024.10.22 00:07:51.250637 [ 895 ] {} DiskObjectStorage(DiskAzureBlobStorage): Starting up disk azure 2024.10.22 00:07:51.276183 [ 895 ] {} DiskObjectStorage(DiskAzureBlobStorage): Disk azure started up 2024.10.22 00:07:51.405943 [ 895 ] {} DiskCache: Registered cached disk (`cached_azure`) with structure: DiskObjectStorage-azure(CachedObjectStorage-cached_azure(AzureObjectStorage)) 2024.10.22 00:07:52.191716 [ 895 ] {} S3Client: Provider type: Unknown 2024.10.22 00:07:52.199357 [ 895 ] {} S3Client: API mode of the S3 client: AWS 2024.10.22 00:07:53.550403 [ 895 ] {} WriteBufferFromS3: Create WriteBufferFromS3, Details: bucket test, key common/clickhouse_remove_objects_capability_fdaabc72-1a82-4137-b6d4-08f8e5beda7c (LogSeriesLimiter: on interval from 2024-10-22 00:07:35 to 2024-10-22 00:07:53 accepted series 1 / 2 for the logger WriteBufferFromS3 : 1.7491308770058435e+38) 2024.10.22 00:07:53.555342 [ 895 ] {} WriteBufferFromS3: finalizeImpl WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_fdaabc72-1a82-4137-b6d4-08f8e5beda7c. 2024.10.22 00:07:53.628461 [ 779 ] {} WriteBufferFromS3: Single part upload has completed. Details: bucket test, key common/clickhouse_remove_objects_capability_fdaabc72-1a82-4137-b6d4-08f8e5beda7c, size 4 2024.10.22 00:07:53.761279 [ 895 ] {} WriteBufferFromS3: Close WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_fdaabc72-1a82-4137-b6d4-08f8e5beda7c. 2024.10.22 00:07:53.766270 [ 896 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 2024.10.22 00:07:53.773104 [ 896 ] {} SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog 2024.10.22 00:07:53.774477 [ 895 ] {} S3ObjectStorage: Objects with paths [common/clickhouse_remove_objects_capability_fdaabc72-1a82-4137-b6d4-08f8e5beda7c] were removed from S3 2024.10.22 00:07:53.952611 [ 468 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.10.22 00:07:53.967616 [ 468 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.10.22 00:07:53.968214 [ 468 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.003088181 sec 2024.10.22 00:07:53.968955 [ 468 ] {} ReferentialDeps: No tables 2024.10.22 00:07:53.969640 [ 468 ] {} LoadingDeps: No tables 2024.10.22 00:07:53.971442 [ 468 ] {} DatabaseAtomic (default): Starting up tables. 2024.10.22 00:07:53.974641 [ 468 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/ 2024.10.22 00:07:53.975969 [ 468 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.10.22 00:07:53.976332 [ 468 ] {} Application: Loaded metadata. 2024.10.22 00:07:53.976940 [ 468 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.10.22 00:07:53.979671 [ 468 ] {} 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:07:53.980506 [ 468 ] {} Application: Tasks stats provider: procfs 2024.10.22 00:07:54.089249 [ 895 ] {} S3ObjectStorage: Objects with paths [common/xol/xblhfzmempufujlliezaibgzigsiw] were removed from S3 2024.10.22 00:07:54.090343 [ 895 ] {} DiskObjectStorage(DiskS3): Starting up disk s3_disk 2024.10.22 00:07:54.092025 [ 895 ] {} DiskObjectStorage(DiskS3): Disk s3_disk started up 2024.10.22 00:07:54.113125 [ 895 ] {} DiskCache: Registered cached disk (`s3_cache`) with structure: DiskObjectStorage-s3_disk(CachedObjectStorage-s3_cache(S3ObjectStorage)) 2024.10.22 00:07:54.191480 [ 895 ] {} DiskObjectStorage(Local): Starting up disk local_disk 2024.10.22 00:07:54.198598 [ 895 ] {} DiskObjectStorage(Local): Disk local_disk started up 2024.10.22 00:07:54.273052 [ 895 ] {} DiskObjectStorage(Local): Starting up disk local_disk_2 2024.10.22 00:07:54.273948 [ 895 ] {} DiskObjectStorage(Local): Disk local_disk_2 started up 2024.10.22 00:07:54.429723 [ 895 ] {} DiskObjectStorage(Local): Starting up disk local_disk_3 2024.10.22 00:07:54.443437 [ 895 ] {} DiskObjectStorage(Local): Disk local_disk_3 started up 2024.10.22 00:07:54.531228 [ 895 ] {} DiskCache: Registered cached disk (`local_cache`) with structure: DiskObjectStorage-local_disk(CachedObjectStorage-local_cache(LocalObjectStorage)) 2024.10.22 00:07:54.562199 [ 895 ] {} DiskCache: Registered cached disk (`local_cache_2`) with structure: DiskObjectStorage-local_disk(CachedObjectStorage-local_cache_2(LocalObjectStorage)) 2024.10.22 00:07:54.617248 [ 468 ] {} AsynchronousMetrics: MemoryTracking: was 62.38 MiB, peak 94.32 MiB, free memory in arenas 168.00 KiB, will set to 775.54 MiB (RSS), difference: 713.16 MiB 2024.10.22 00:07:54.695689 [ 895 ] {} DiskCache: Registered cached disk (`local_cache_3`) with structure: DiskObjectStorage-local_disk_3(CachedObjectStorage-local_cache_3(LocalObjectStorage)) 2024.10.22 00:07:54.725670 [ 895 ] {} DiskCache: Registered cached disk (`s3_cache_multi`) with structure: DiskObjectStorage-s3_disk(CachedObjectStorage-s3_cache_multi(CachedObjectStorage-s3_cache(S3ObjectStorage))) 2024.10.22 00:07:54.751046 [ 895 ] {} 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:07:54.757203 [ 895 ] {} StoragePolicy (azure_cache): Storage policy azure_cache created, total volumes 1 2024.10.22 00:07:54.757885 [ 895 ] {} StoragePolicySelector: Storage policy `azure_cache` loaded 2024.10.22 00:07:54.762569 [ 895 ] {} StoragePolicy (s3_cache): Storage policy s3_cache created, total volumes 1 2024.10.22 00:07:54.763375 [ 895 ] {} StoragePolicySelector: Storage policy `s3_cache` loaded 2024.10.22 00:07:54.769014 [ 895 ] {} StoragePolicy (s3_cache_multi): Storage policy s3_cache_multi created, total volumes 1 2024.10.22 00:07:54.769924 [ 895 ] {} StoragePolicySelector: Storage policy `s3_cache_multi` loaded 2024.10.22 00:07:54.773979 [ 895 ] {} StoragePolicy (local_cache): Storage policy local_cache created, total volumes 1 2024.10.22 00:07:54.774671 [ 895 ] {} StoragePolicySelector: Storage policy `local_cache` loaded 2024.10.22 00:07:54.779381 [ 895 ] {} StoragePolicy (local_cache_2): Storage policy local_cache_2 created, total volumes 1 2024.10.22 00:07:54.780794 [ 895 ] {} StoragePolicySelector: Storage policy `local_cache_2` loaded 2024.10.22 00:07:54.787793 [ 895 ] {} StoragePolicy (local_cache_3): Storage policy local_cache_3 created, total volumes 1 2024.10.22 00:07:54.789588 [ 895 ] {} StoragePolicySelector: Storage policy `local_cache_3` loaded 2024.10.22 00:07:54.794825 [ 895 ] {} StoragePolicy (default): Storage policy default created, total volumes 1 2024.10.22 00:07:54.818668 [ 895 ] {} system.text_log (ffa745eb-8a28-47e2-b73e-5e0c8034f61b): Loading data parts 2024.10.22 00:07:54.831566 [ 592 ] {} DatabaseCatalog: Execution took 855 ms. 2024.10.22 00:07:54.859463 [ 468 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 0.003150557 sec. 2024.10.22 00:07:54.891426 [ 895 ] {} system.text_log (ffa745eb-8a28-47e2-b73e-5e0c8034f61b): There are no data parts 2024.10.22 00:07:55.061028 [ 468 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/decimals_dictionary.xml'. 2024.10.22 00:07:55.257040 [ 468 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/executable_dictionary.xml'. 2024.10.22 00:07:55.365031 [ 468 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/executable_pool_dictionary.xml'. 2024.10.22 00:07:55.464182 [ 954 ] {} AsynchronousMetrics: MemoryTracking: was 793.27 MiB, peak 793.27 MiB, free memory in arenas 368.00 KiB, will set to 777.86 MiB (RSS), difference: -15.41 MiB 2024.10.22 00:07:55.534297 [ 468 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/ints_dictionary.xml'. 2024.10.22 00:07:55.562670 [ 895 ] {} system.text_log (ffa745eb-8a28-47e2-b73e-5e0c8034f61b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:07:55.565300 [ 895 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 301.66 GiB. 2024.10.22 00:07:55.751573 [ 895 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:07:55.891407 [ 617 ] {} DNSResolver: Updating DNS cache 2024.10.22 00:07:55.903486 [ 895 ] {} system.text_log (ffa745eb-8a28-47e2-b73e-5e0c8034f61b): 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:07:55.918041 [ 617 ] {} DNSResolver: Updated DNS cache 2024.10.22 00:07:55.921997 [ 895 ] {} SystemLog (system.text_log): Flushed system log up to offset 153 2024.10.22 00:07:56.154500 [ 468 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/strings_dictionary.xml'. 2024.10.22 00:07:56.372746 [ 468 ] {} ExternalUserDefinedExecutableFunctionsLoader: Loading config file '/etc/clickhouse-server/test_function.xml'. 2024.10.22 00:07:56.409792 [ 954 ] {} AsynchronousMetrics: MemoryTracking: was 792.35 MiB, peak 793.27 MiB, free memory in arenas 1.32 MiB, will set to 799.48 MiB (RSS), difference: 7.13 MiB 2024.10.22 00:07:56.499432 [ 468 ] {} ExternalUserDefinedExecutableFunctionsLoader: Will load 'test_function' because always_load_everything flag is set. 2024.10.22 00:07:56.500515 [ 468 ] {} ExternalUserDefinedExecutableFunctionsLoader: Will load the object 'test_function' immediately, force = false, loading_id = 1 2024.10.22 00:07:56.501651 [ 468 ] {} ExternalUserDefinedExecutableFunctionsLoader: Start loading object 'test_function' 2024.10.22 00:07:56.514446 [ 468 ] {} ExternalUserDefinedExecutableFunctionsLoader: Supposed update time for 'test_function' is never (loaded, lifetime 0) 2024.10.22 00:07:56.515850 [ 468 ] {} ExternalUserDefinedExecutableFunctionsLoader: Next update time for 'test_function' was set to 294247-01-10 05:00:54 2024.10.22 00:07:56.536708 [ 468 ] {} Application: Listening for http://[::]:8123 2024.10.22 00:07:56.540348 [ 468 ] {} Application: Listening for https://[::]:8443 2024.10.22 00:07:56.543117 [ 468 ] {} Application: Listening for native protocol (tcp): [::]:9000 2024.10.22 00:07:56.545723 [ 468 ] {} Application: Listening for native protocol (tcp) with PROXY: [::]:9010 2024.10.22 00:07:56.548492 [ 468 ] {} Application: Listening for secure native protocol (tcp_secure): [::]:9440 2024.10.22 00:07:56.550630 [ 468 ] {} Application: Listening for MySQL compatibility protocol: [::]:9004 2024.10.22 00:07:56.552760 [ 468 ] {} Application: Listening for PostgreSQL compatibility protocol: [::]:9005 2024.10.22 00:07:56.554193 [ 468 ] {} Application: Listening for Prometheus: http://[::]:9988 2024.10.22 00:07:56.556320 [ 468 ] {} Application: Ready for connections. 2024.10.22 00:07:56.580029 [ 958 ] {} DDLWorker: Starting DDLWorker thread 2024.10.22 00:07:56.585511 [ 958 ] {} DDLWorker: Initializing DDLWorker thread 2024.10.22 00:07:56.589975 [ 473 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:36164 2024.10.22 00:07:56.619037 [ 473 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.10.22 00:07:56.730675 [ 473 ] {} TCP-Session: d1dae651-90ba-4adc-b7f1-6cd638c2f0f0 Authenticating user 'default' from [::1]:36164 2024.10.22 00:07:56.762177 [ 474 ] {} KeeperTCPHandlerFactory: Keeper request. Address: [::1]:37914 2024.10.22 00:07:56.770638 [ 959 ] {} DDLWorker: Started DDLWorker cleanup thread 2024.10.22 00:07:56.781224 [ 474 ] {} KeeperTCPHandler: Requesting session ID for the new client 2024.10.22 00:07:56.793333 [ 757 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.10.22 00:07:56.811167 [ 802 ] {} KeeperStateMachine: Session ID response 1 with timeout 30000 2024.10.22 00:07:56.817212 [ 474 ] {} KeeperTCPHandler: Received session ID 1 2024.10.22 00:07:56.818174 [ 958 ] {} ZooKeeperClient: Connected to ZooKeeper at [::1]:9181 with session_id 1 2024.10.22 00:07:56.834308 [ 473 ] {} TCP-Session: d1dae651-90ba-4adc-b7f1-6cd638c2f0f0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:07:56.835645 [ 473 ] {} TCP-Session: d1dae651-90ba-4adc-b7f1-6cd638c2f0f0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:07:56.993615 [ 958 ] {} ZooKeeperClient: Keeper feature flag FILTERED_LIST: enabled 2024.10.22 00:07:56.994891 [ 958 ] {} ZooKeeperClient: Keeper feature flag MULTI_READ: enabled 2024.10.22 00:07:56.995994 [ 958 ] {} ZooKeeperClient: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.10.22 00:07:56.998267 [ 958 ] {} ZooKeeper: Initialized, hosts: localhost:9181 2024.10.22 00:07:57.000694 [ 757 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 1 2024.10.22 00:07:57.017271 [ 757 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.10.22 00:07:57.059661 [ 757 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 85 2024.10.22 00:07:57.081001 [ 757 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 74 2024.10.22 00:07:57.121179 [ 757 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 85 2024.10.22 00:07:57.231896 [ 473 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.10.22 00:07:57.232941 [ 473 ] {} ContextAccess (default): List of all grants: GRANT ALL ON *.* WITH GRANT OPTION 2024.10.22 00:07:57.233907 [ 473 ] {} ContextAccess (default): List of all grants including implicit: GRANT ALL ON *.* WITH GRANT OPTION 2024.10.22 00:07:57.267648 [ 757 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.10.22 00:07:57.327847 [ 473 ] {} TCP-Session: d1dae651-90ba-4adc-b7f1-6cd638c2f0f0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.22 00:07:57.341669 [ 473 ] {fd16f777-166c-4656-a5dd-a0788c85a204} executeQuery: Query span trace_id for opentelemetry log: ee555650-8437-3afc-5445-150eb3e354b9 2024.10.22 00:07:57.345533 [ 473 ] {fd16f777-166c-4656-a5dd-a0788c85a204} executeQuery: (from [::1]:36164) SELECT 1 (stage: Complete) 2024.10.22 00:07:57.371331 [ 473 ] {fd16f777-166c-4656-a5dd-a0788c85a204} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.10.22 00:07:57.377292 [ 473 ] {fd16f777-166c-4656-a5dd-a0788c85a204} InterpreterSelectQuery: FetchColumns -> Complete 2024.10.22 00:07:57.396102 [ 958 ] {} DDLWorker: Initialized DDLWorker thread 2024.10.22 00:07:57.397271 [ 958 ] {} DDLWorker: Scheduling tasks 2024.10.22 00:07:57.398175 [ 959 ] {} DDLWorker: Cleaning queue 2024.10.22 00:07:57.398472 [ 958 ] {} DDLWorker: Don't have unfinished tasks after restarting 2024.10.22 00:07:57.493602 [ 473 ] {fd16f777-166c-4656-a5dd-a0788c85a204} executeQuery: Read 1 rows, 1.00 B in 0.148654 sec., 6.727030554172777 rows/sec., 6.73 B/sec. 2024.10.22 00:07:57.510832 [ 954 ] {} AsynchronousMetrics: MemoryTracking: was 807.62 MiB, peak 807.62 MiB, free memory in arenas 1.16 MiB, will set to 811.21 MiB (RSS), difference: 3.60 MiB 2024.10.22 00:07:57.514737 [ 473 ] {fd16f777-166c-4656-a5dd-a0788c85a204} TCPHandler: Processed in 0.186210003 sec. 2024.10.22 00:07:57.551725 [ 958 ] {} 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:07:57.654118 [ 958 ] {} DDLWorker: No tasks to schedule 2024.10.22 00:07:57.655184 [ 958 ] {} DDLWorker: Waiting for queue updates 2024.10.22 00:07:57.717688 [ 473 ] {} TCPHandler: Done processing connection. 2024.10.22 00:07:57.800220 [ 473 ] {} TCP-Session: d1dae651-90ba-4adc-b7f1-6cd638c2f0f0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:12:26.025001 [ 474 ] {} KeeperTCPHandler: Session #1 expired 2024.10.22 00:12:26.045262 [ 895 ] {} SystemLog (system.text_log): Flushing system log, 135 entries to flush up to offset 288 2024.10.22 00:12:26.057365 [ 890 ] {} SystemLog (system.query_log): Flushing system log, 2 entries to flush up to offset 2 2024.10.22 00:12:26.058594 [ 473 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:35786 2024.10.22 00:12:26.060729 [ 890 ] {} SystemLog (system.query_log): Creating new table system.query_log for QueryLog 2024.10.22 00:12:26.059829 [ 807 ] {} KeeperDispatcher: Found dead session 1, will try to close it 2024.10.22 00:12:26.063924 [ 473 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.10.22 00:12:26.065395 [ 757 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.10.22 00:12:26.065550 [ 473 ] {} TCP-Session: 21401369-fd0a-458d-9c42-e7f04afc5f98 Authenticating user 'default' from [::1]:35786 2024.10.22 00:12:26.059559 [ 898 ] {} SystemLog (system.opentelemetry_span_log): Flushing system log, 5 entries to flush up to offset 5 2024.10.22 00:12:26.070610 [ 898 ] {} SystemLog (system.opentelemetry_span_log): Creating new table system.opentelemetry_span_log for OpenTelemetrySpanLog 2024.10.22 00:12:26.061657 [ 902 ] {} SystemLog (system.transactions_info_log): Flushing system log, 1 entries to flush up to offset 1 2024.10.22 00:12:26.071329 [ 473 ] {} TCP-Session: 21401369-fd0a-458d-9c42-e7f04afc5f98 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:12:26.066737 [ 897 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 1059 entries to flush up to offset 1059 2024.10.22 00:12:26.072692 [ 473 ] {} TCP-Session: 21401369-fd0a-458d-9c42-e7f04afc5f98 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:12:26.074388 [ 897 ] {} SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog 2024.10.22 00:12:26.070547 [ 901 ] {} SystemLog (system.session_log): Flushing system log, 2 entries to flush up to offset 2 2024.10.22 00:12:26.078974 [ 902 ] {} SystemLog (system.transactions_info_log): Creating new table system.transactions_info_log for TransactionsInfoLog 2024.10.22 00:12:26.079632 [ 901 ] {} SystemLog (system.session_log): Creating new table system.session_log for SessionLog 2024.10.22 00:12:26.066110 [ 807 ] {} KeeperDispatcher: Dead session close request pushed 2024.10.22 00:12:26.089739 [ 594 ] {} DNSResolver: Updating DNS cache 2024.10.22 00:12:26.040387 [ 900 ] {} SystemLog (system.zookeeper_log): Flushing system log, 18 entries to flush up to offset 18 2024.10.22 00:12:26.159911 [ 594 ] {} DNSResolver: Updated DNS cache 2024.10.22 00:12:26.160846 [ 900 ] {} SystemLog (system.zookeeper_log): Creating new table system.zookeeper_log for ZooKeeperLog 2024.10.22 00:12:26.062885 [ 893 ] {} SystemLog (system.trace_log): Flushing system log, 14 entries to flush up to offset 14 2024.10.22 00:12:26.166151 [ 893 ] {} SystemLog (system.trace_log): Creating new table system.trace_log for TraceLog 2024.10.22 00:12:26.451937 [ 473 ] {} TCP-Session: 21401369-fd0a-458d-9c42-e7f04afc5f98 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.22 00:12:26.464559 [ 473 ] {3d131524-2bb6-4e18-8cec-cf271298be06} executeQuery: (from [::1]:35786) SELECT 'Connected to clickhouse-server after attaching gdb' (stage: Complete) 2024.10.22 00:12:26.481710 [ 473 ] {3d131524-2bb6-4e18-8cec-cf271298be06} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.10.22 00:12:26.484146 [ 473 ] {3d131524-2bb6-4e18-8cec-cf271298be06} InterpreterSelectQuery: FetchColumns -> Complete 2024.10.22 00:12:26.546664 [ 895 ] {} system.text_log (ffa745eb-8a28-47e2-b73e-5e0c8034f61b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:26.555839 [ 895 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 301.65 GiB. 2024.10.22 00:12:26.576396 [ 473 ] {3d131524-2bb6-4e18-8cec-cf271298be06} executeQuery: Read 1 rows, 1.00 B in 0.111678 sec., 8.954315084439191 rows/sec., 8.95 B/sec. 2024.10.22 00:12:26.596892 [ 473 ] {3d131524-2bb6-4e18-8cec-cf271298be06} TCPHandler: Processed in 0.153060154 sec. 2024.10.22 00:12:26.746145 [ 895 ] {} MergedBlockOutputStream: filled checksums 202410_2_2_0 (state Temporary) 2024.10.22 00:12:26.753581 [ 902 ] {} system.transactions_info_log (5276570e-a364-404e-a403-3e186cba01a8): Loading data parts 2024.10.22 00:12:26.758935 [ 897 ] {} system.asynchronous_metric_log (77c672cd-125d-412b-9cb8-29507f0d4ac1): Loading data parts 2024.10.22 00:12:26.795462 [ 901 ] {} system.session_log (ed97c24a-3021-4d92-aee2-1ef2de3fa803): Loading data parts 2024.10.22 00:12:26.813219 [ 895 ] {} system.text_log (ffa745eb-8a28-47e2-b73e-5e0c8034f61b): 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:12:26.812632 [ 473 ] {} TCPHandler: Done processing connection. 2024.10.22 00:12:26.818866 [ 898 ] {} system.opentelemetry_span_log (6ccc75a8-1522-4520-a414-6e81fb929787): Loading data parts 2024.10.22 00:12:26.834619 [ 902 ] {} system.transactions_info_log (5276570e-a364-404e-a403-3e186cba01a8): There are no data parts 2024.10.22 00:12:26.851755 [ 897 ] {} system.asynchronous_metric_log (77c672cd-125d-412b-9cb8-29507f0d4ac1): There are no data parts 2024.10.22 00:12:26.933579 [ 901 ] {} system.session_log (ed97c24a-3021-4d92-aee2-1ef2de3fa803): There are no data parts 2024.10.22 00:12:26.969444 [ 893 ] {} system.trace_log (b1d331ed-9402-47f3-92ba-69560d00c0ac): Loading data parts 2024.10.22 00:12:26.995412 [ 895 ] {} SystemLog (system.text_log): Flushed system log up to offset 288 2024.10.22 00:12:27.003973 [ 896 ] {} system.metric_log (92e05502-7cd1-42a9-b81b-a85674c93a09): Loading data parts 2024.10.22 00:12:27.008045 [ 898 ] {} system.opentelemetry_span_log (6ccc75a8-1522-4520-a414-6e81fb929787): There are no data parts 2024.10.22 00:12:27.025825 [ 893 ] {} system.trace_log (b1d331ed-9402-47f3-92ba-69560d00c0ac): There are no data parts 2024.10.22 00:12:27.047506 [ 896 ] {} system.metric_log (92e05502-7cd1-42a9-b81b-a85674c93a09): There are no data parts 2024.10.22 00:12:27.050060 [ 473 ] {} TCP-Session: 21401369-fd0a-458d-9c42-e7f04afc5f98 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.22 00:12:27.164515 [ 900 ] {} system.zookeeper_log (4de457e0-9d34-4a1d-91af-81e270dc2c3e): Loading data parts 2024.10.22 00:12:27.206486 [ 902 ] {} system.transactions_info_log (5276570e-a364-404e-a403-3e186cba01a8): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:27.212612 [ 902 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 301.65 GiB. 2024.10.22 00:12:27.271443 [ 902 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:12:27.276476 [ 900 ] {} system.zookeeper_log (4de457e0-9d34-4a1d-91af-81e270dc2c3e): There are no data parts 2024.10.22 00:12:27.278155 [ 893 ] {} system.trace_log (b1d331ed-9402-47f3-92ba-69560d00c0ac): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:27.281254 [ 893 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 301.65 GiB. 2024.10.22 00:12:27.307283 [ 890 ] {} system.query_log (3c89ec5e-dff4-4fa3-aa5c-2c2b424d63ef): Loading data parts 2024.10.22 00:12:27.330609 [ 901 ] {} system.session_log (ed97c24a-3021-4d92-aee2-1ef2de3fa803): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:27.333658 [ 901 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 301.65 GiB. 2024.10.22 00:12:27.334429 [ 893 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:12:27.360266 [ 898 ] {} system.opentelemetry_span_log (6ccc75a8-1522-4520-a414-6e81fb929787): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:27.362012 [ 898 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 301.65 GiB. 2024.10.22 00:12:27.381145 [ 898 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:12:27.396144 [ 954 ] {} AsynchronousMetrics: MemoryTracking: was 821.41 MiB, peak 821.41 MiB, free memory in arenas 1.10 MiB, will set to 913.70 MiB (RSS), difference: 92.29 MiB 2024.10.22 00:12:27.404347 [ 898 ] {} system.opentelemetry_span_log (6ccc75a8-1522-4520-a414-6e81fb929787): 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:27.405690 [ 890 ] {} system.query_log (3c89ec5e-dff4-4fa3-aa5c-2c2b424d63ef): There are no data parts 2024.10.22 00:12:27.432588 [ 954 ] {} AsynchronousMetrics: Scanning /sys/block 2024.10.22 00:12:27.451195 [ 898 ] {} SystemLog (system.opentelemetry_span_log): Flushed system log up to offset 5 2024.10.22 00:12:27.452372 [ 902 ] {} system.transactions_info_log (5276570e-a364-404e-a403-3e186cba01a8): 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:27.497836 [ 902 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 1 2024.10.22 00:12:27.498523 [ 893 ] {} system.trace_log (b1d331ed-9402-47f3-92ba-69560d00c0ac): 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:27.517752 [ 901 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:12:27.568358 [ 901 ] {} system.session_log (ed97c24a-3021-4d92-aee2-1ef2de3fa803): 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:27.621565 [ 901 ] {} SystemLog (system.session_log): Flushed system log up to offset 2 2024.10.22 00:12:27.664935 [ 897 ] {} system.asynchronous_metric_log (77c672cd-125d-412b-9cb8-29507f0d4ac1): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.22 00:12:27.665489 [ 954 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 0.018651874 sec. 2024.10.22 00:12:27.666312 [ 897 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 301.65 GiB. 2024.10.22 00:12:27.738580 [ 893 ] {} SystemLog (system.trace_log): Flushed system log up to offset 14 2024.10.22 00:12:27.839471 [ 897 ] {} MergedBlockOutputStream: filled checksums 202410_1_1_0 (state Temporary) 2024.10.22 00:12:27.930271 [ 969 ] {} ZooKeeperClient: Code: 210. DB::NetException: Connection reset by peer, while reading from socket ([::1]:9181). (NETWORK_ERROR), Stack trace (when copying this message, always include the lines below): 0. /build/contrib/llvm-project/libcxx/include/exception:134: std::exception::capture() @ 0x000000000b1a6742 in /usr/bin/clickhouse 1. /build/contrib/llvm-project/libcxx/include/exception:112: std::exception::exception[abi:v15000]() @ 0x000000000b1a670d in /usr/bin/clickhouse 2. /build/base/poco/Foundation/src/Exception.cpp:27: Poco::Exception::Exception(String const&, int) @ 0x000000002495b180 in /usr/bin/clickhouse 3. /build/src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000138e1a6e in /usr/bin/clickhouse 4. /build/src/Common/Exception.h:73: DB::Exception::Exception(String&&, int, bool) @ 0x000000000b19878a in /usr/bin/clickhouse 5. /build/src/Common/NetException.h:26: DB::NetException::NetException(int, FormatStringHelperImpl::type, std::type_identity::type>, String&&, String&&) @ 0x0000000013cf152c in /usr/bin/clickhouse 6. /build/src/IO/ReadBufferFromPocoSocket.cpp:86: DB::ReadBufferFromPocoSocket::nextImpl() @ 0x0000000013cf07a0 in /usr/bin/clickhouse 7. /build/src/IO/ReadBuffer.h:71: DB::ReadBuffer::next() @ 0x000000000b21bd7c in /usr/bin/clickhouse 8. /build/src/IO/ReadBuffer.h:105: DB::ReadBuffer::read(char*, unsigned long) @ 0x000000000b21b973 in /usr/bin/clickhouse 9. /build/src/IO/ReadBuffer.h:196: DB::ReadBuffer::readStrict(char*, unsigned long) @ 0x000000000b5e4468 in /usr/bin/clickhouse 10. /build/src/IO/ReadHelpers.h:117: void DB::readPODBinary(int&, DB::ReadBuffer&) @ 0x0000000013999f02 in /usr/bin/clickhouse 11. /build/src/IO/ReadHelpers.h:1099: void DB::readBinary(int&, DB::ReadBuffer&) @ 0x0000000013999ebd in /usr/bin/clickhouse 12. /build/src/IO/ReadHelpers.h:1136: void DB::readBinaryEndian<(std::endian)64206, int>(int&, DB::ReadBuffer&) @ 0x000000001e60277d in /usr/bin/clickhouse 13. /build/src/IO/ReadHelpers.h:1149: void DB::readBinaryBigEndian(int&, DB::ReadBuffer&) @ 0x000000001e60273d in /usr/bin/clickhouse 14. /build/src/Common/ZooKeeper/ZooKeeperIO.h:51: void Coordination::read(int&, DB::ReadBuffer&) @ 0x000000001e5fdbbd in /usr/bin/clickhouse 15. /build/src/Common/ZooKeeper/ZooKeeperImpl.cpp:284: void Coordination::ZooKeeper::read(int&) @ 0x000000001f30be14 in /usr/bin/clickhouse 16. /build/src/Common/ZooKeeper/ZooKeeperImpl.cpp:744: Coordination::ZooKeeper::receiveEvent() @ 0x000000001f30124c in /usr/bin/clickhouse 17. /build/src/Common/ZooKeeper/ZooKeeperImpl.cpp:710: Coordination::ZooKeeper::receiveThread() @ 0x000000001f300cc4 in /usr/bin/clickhouse 18. /build/src/Common/ZooKeeper/ZooKeeperImpl.cpp:356: Coordination::ZooKeeper::ZooKeeper(std::vector> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_1::operator()() const @ 0x000000001f306af8 in /usr/bin/clickhouse 19. /build/contrib/llvm-project/libcxx/include/__functional/invoke.h:394: decltype(std::declval> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_1&>()()) std::__invoke[abi:v15000]> 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&) @ 0x000000001f306ad5 in /usr/bin/clickhouse 20. /build/contrib/llvm-project/libcxx/include/tuple:1789: decltype(auto) std::__apply_tuple_impl[abi:v15000]> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_1&, std::tuple<>&>(Coordination::ZooKeeper::ZooKeeper(std::vector> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_1&, std::tuple<>&, std::__tuple_indices<>) @ 0x000000001f306ab9 in /usr/bin/clickhouse 21. /build/contrib/llvm-project/libcxx/include/tuple:1798: decltype(auto) std::apply[abi:v15000]> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr, std::optional>&&)::$_1&, std::tuple<>&>(Coordination::ZooKeeper::ZooKeeper(std::vector> const&, zkutil::ZooKeeperArgs const&, std::shared_ptr