2024.09.24 01:07:42.487004 [ 518 ] {} Application: Will watch for the process with pid 520 2024.09.24 01:07:42.487151 [ 520 ] {} Application: Forked a child process to watch 2024.09.24 01:07:42.487832 [ 520 ] {} SentryWriter: Sending crash reports is disabled 2024.09.24 01:07:42.488067 [ 520 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.09.24 01:07:42.951063 [ 520 ] {} Application: Starting ClickHouse 23.8.16.41.altinitystable (revision: 54477, git hash: 9992f5eba3591142ff413d31cb83a7bf4f0e2553, build id: 1ABC2DEFC9DB6E23BB0599BEA7A054DB05467FC7), PID 520 2024.09.24 01:07:42.953693 [ 520 ] {} Application: starting up 2024.09.24 01:07:42.953775 [ 520 ] {} Application: OS name: Linux, version: 5.15.0-73-generic, architecture: x86_64 2024.09.24 01:07:42.987317 [ 520 ] {} Context: Server was built in debug mode. It will work slowly. 2024.09.24 01:07:42.988158 [ 520 ] {} Context: ThreadFuzzer is enabled. Application will run slowly and unstable. 2024.09.24 01:07:42.989052 [ 520 ] {} Application: Available RAM: 30.61 GiB; physical cores: 16; logical cores: 16. 2024.09.24 01:07:42.996782 [ 520 ] {} 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.09.24 01:07:43.011831 [ 520 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2024.09.24 01:07:43.012266 [ 520 ] {} AsynchronousMetrics: Scanning /sys/block 2024.09.24 01:07:43.013707 [ 520 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2024.09.24 01:07:43.014327 [ 520 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2024.09.24 01:07:54.938543 [ 520 ] {} Application: Integrity check of the executable successfully passed (checksum: D97C5D7DBC3C55377591912A221F20D4) 2024.09.24 01:07:54.940064 [ 520 ] {} Application: Will do mlock to prevent executable memory from being paged out. It may take a few seconds. 2024.09.24 01:07:54.962803 [ 520 ] {} Application: The memory map of clickhouse executable has been mlock'ed, total 471.34 MiB 2024.09.24 01:07:54.963686 [ 520 ] {} Application: Set OOM score adjustment to 555 2024.09.24 01:07:54.967257 [ 520 ] {} Application: Set max number of file descriptors to 1048576 (was 1024). 2024.09.24 01:07:54.967644 [ 520 ] {} Application: rlimit on number of threads is 18446744073709551615 2024.09.24 01:07:54.968522 [ 520 ] {} Application: Initializing DateLUT. 2024.09.24 01:07:54.968860 [ 520 ] {} Application: Initialized DateLUT with time zone 'Europe/Amsterdam'. 2024.09.24 01:07:54.970006 [ 520 ] {} Context: Setting up /var/lib/clickhouse/tmp/ to store temporary data in it 2024.09.24 01:07:54.973352 [ 520 ] {} TLDListsHolder: public_suffix_list loading from /etc/clickhouse-server/top_level_domains/public_suffix_list.dat 2024.09.24 01:07:55.704591 [ 520 ] {} TLDListsHolder: public_suffix_list was added (9084 hosts) 2024.09.24 01:07:55.705219 [ 520 ] {} TLDListsHolder: no_new_line_list loading from /etc/clickhouse-server/top_level_domains/no_new_line_list.dat 2024.09.24 01:07:55.706751 [ 520 ] {} TLDListsHolder: no_new_line_list was added (1 hosts) 2024.09.24 01:07:55.707993 [ 520 ] {} 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.09.24 01:07:55.709124 [ 520 ] {} Application: Initializing MergeTree metadata cache, lru_cache_size: 256.00 MiB continue_if_corrupted: true 2024.09.24 01:07:56.097759 [ 520 ] {} Application: Configuration parameter 'interserver_http_host' doesn't exist or exists and empty. Will use '1bfc6af5cd54' as replica host. 2024.09.24 01:07:56.098457 [ 520 ] {} Application: Initializing interserver credentials. 2024.09.24 01:07:56.130972 [ 520 ] {} NamedCollectionsUtils: Loaded 6 collections from config 2024.09.24 01:07:56.133023 [ 520 ] {} NamedCollectionsUtils: Loaded 0 collections from SQL 2024.09.24 01:07:56.135826 [ 520 ] {} SensitiveDataMaskerConfigRead: 1 query masking rules loaded. 2024.09.24 01:07:56.175278 [ 520 ] {} ConfigReloader: Loading config '/etc/clickhouse-server/config.xml' 2024.09.24 01:07:58.502546 [ 520 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/config.xml', performing update on configuration 2024.09.24 01:07:58.777423 [ 520 ] {} Application: Setting max_server_memory_usage was set to 15.31 GiB (30.61 GiB available * 0.50 max_server_memory_usage_to_ram_ratio) 2024.09.24 01:07:58.777829 [ 520 ] {} Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.31 GiB (30.61 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) 2024.09.24 01:07:58.778544 [ 520 ] {} Application: Merges and mutations memory limit is set to 15.31 GiB 2024.09.24 01:07:59.581784 [ 520 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.09.24 01:07:59.587985 [ 520 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.09.24 01:08:00.033822 [ 520 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.09.24 01:08:00.071140 [ 520 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.09.24 01:08:00.169085 [ 520 ] {} CertificateReloader: Reloading certificate (/etc/clickhouse-server/server.crt) and key (/etc/clickhouse-server/server.key). 2024.09.24 01:08:00.243569 [ 520 ] {} CertificateReloader: Reloaded certificate (/etc/clickhouse-server/server.crt) and key (/etc/clickhouse-server/server.key). 2024.09.24 01:08:00.249209 [ 520 ] {} CertificateReloader: Initializing certificate reloader. 2024.09.24 01:08:00.460024 [ 520 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/config.xml', performed update on configuration 2024.09.24 01:08:00.582305 [ 520 ] {} Context: Keeper server is participant of the main zookeeper cluster, will try to connect to it 2024.09.24 01:08:00.589085 [ 520 ] {} Context: Cannot connect to ZooKeeper (or Keeper) before internal Keeper start, will wait for Keeper synchronously 2024.09.24 01:08:00.590140 [ 520 ] {} KeeperDispatcher: Initializing storage dispatcher 2024.09.24 01:08:00.598820 [ 520 ] {} KeeperContext: Keeper feature flag FILTERED_LIST: enabled 2024.09.24 01:08:00.599337 [ 520 ] {} KeeperContext: Keeper feature flag MULTI_READ: enabled 2024.09.24 01:08:00.599626 [ 520 ] {} KeeperContext: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.09.24 01:08:00.600798 [ 520 ] {} KeeperContext: Disk type 'azure_blob_storage' is not supported for Keeper 2024.09.24 01:08:00.601573 [ 520 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.09.24 01:08:03.106230 [ 520 ] {} S3Client: Provider type: Unknown 2024.09.24 01:08:03.106693 [ 520 ] {} S3Client: API mode of the S3 client: AWS 2024.09.24 01:08:03.458827 [ 520 ] {} WriteBufferFromS3: Create WriteBufferFromS3, Details: bucket test, key common/clickhouse_remove_objects_capability_0ba8e9ea-5834-4b94-802e-6110b1de1bc0 2024.09.24 01:08:03.459287 [ 520 ] {} WriteBufferFromS3: finalizeImpl WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_0ba8e9ea-5834-4b94-802e-6110b1de1bc0. 2024.09.24 01:08:03.826689 [ 795 ] {} HTTPSessionAdapter: Created HTTP(S) session with localhost:11111 (::1:11111) 2024.09.24 01:08:03.934841 [ 795 ] {} WriteBufferFromS3: Single part upload has completed. Details: bucket test, key common/clickhouse_remove_objects_capability_0ba8e9ea-5834-4b94-802e-6110b1de1bc0, size 4 2024.09.24 01:08:03.935832 [ 520 ] {} WriteBufferFromS3: Close WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_0ba8e9ea-5834-4b94-802e-6110b1de1bc0. 2024.09.24 01:08:03.947019 [ 520 ] {} S3ObjectStorage: Objects with paths [common/clickhouse_remove_objects_capability_0ba8e9ea-5834-4b94-802e-6110b1de1bc0] were removed from S3 2024.09.24 01:08:04.020401 [ 520 ] {} S3ObjectStorage: Objects with paths [common/otj/puiwcvcfrucyvmbyitaakdczmqdpf] were removed from S3 2024.09.24 01:08:04.020925 [ 520 ] {} DiskObjectStorage(DiskS3): Starting up disk s3_disk 2024.09.24 01:08:04.021508 [ 520 ] {} DiskObjectStorage(DiskS3): Disk s3_disk started up 2024.09.24 01:08:04.022170 [ 520 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.09.24 01:08:04.022800 [ 520 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.09.24 01:08:04.023459 [ 520 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.09.24 01:08:04.024079 [ 520 ] {} KeeperContext: Disk type 'local_blob_storage' is not supported for Keeper 2024.09.24 01:08:04.024708 [ 520 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.09.24 01:08:04.025286 [ 520 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.09.24 01:08:04.025795 [ 520 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.09.24 01:08:04.026414 [ 520 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.09.24 01:08:04.026957 [ 520 ] {} KeeperContext: Disk type 'cache' is not supported for Keeper 2024.09.24 01:08:04.032121 [ 520 ] {} KeeperSnapshotManager: Reading from disk LocalSnapshotDisk 2024.09.24 01:08:04.038309 [ 520 ] {} KeeperLogStore: Reading from disk LocalLogDisk 2024.09.24 01:08:04.038893 [ 520 ] {} KeeperLogStore: No logs exists in /var/lib/clickhouse/coordination/logs. It's Ok if it's the first run of clickhouse-keeper. 2024.09.24 01:08:04.040658 [ 520 ] {} KeeperLogStore: force_sync disabled 2024.09.24 01:08:04.041121 [ 520 ] {} KeeperDispatcher: Waiting server to initialize 2024.09.24 01:08:04.041424 [ 520 ] {} KeeperStateMachine: Totally have 0 snapshots 2024.09.24 01:08:04.042837 [ 520 ] {} KeeperStateMachine: No existing snapshots, last committed log index 0 2024.09.24 01:08:04.043412 [ 520 ] {} KeeperLogStore: Removing all changelogs 2024.09.24 01:08:04.043988 [ 520 ] {} Changelog: Starting new changelog changelog_1_100000.bin.zstd 2024.09.24 01:08:04.045421 [ 520 ] {} KeeperServer: Preprocessing 0 log entries 2024.09.24 01:08:04.045708 [ 520 ] {} KeeperServer: Preprocessing done 2024.09.24 01:08:04.046241 [ 520 ] {} KeeperServer: No config in log store and snapshot, probably it's initial run. Will use config from .xml on disk 2024.09.24 01:08:04.069698 [ 520 ] {} KeeperServer: Got 1000000000000000 value for setting 'reserved_log_items' which is bigger than int32_t max value, lowering value to 2147483647. 2024.09.24 01:08:04.260889 [ 520 ] {} RaftInstance: Raft ASIO listener initiated on :::9234, unsecured 2024.09.24 01:08:04.261901 [ 520 ] {} KeeperStateManager: No state was read 2024.09.24 01:08:04.286469 [ 520 ] {} RaftInstance: invalid election timeout lower bound detected, adjusted to 0 2024.09.24 01:08:04.293428 [ 520 ] {} RaftInstance: invalid election timeout upper bound detected, adjusted to 0 2024.09.24 01:08:04.294074 [ 520 ] {} 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.09.24 01:08:04.295125 [ 520 ] {} RaftInstance: new election timeout range: 0 - 0 2024.09.24 01:08:04.296141 [ 520 ] {} 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.09.24 01:08:04.297587 [ 520 ] {} RaftInstance: peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 2024.09.24 01:08:04.298749 [ 520 ] {} RaftInstance: global manager does not exist. will use local thread for commit and append 2024.09.24 01:08:04.300047 [ 520 ] {} RaftInstance: wait for HB, for 50 + [0, 0] ms 2024.09.24 01:08:04.325060 [ 819 ] {} RaftInstance: bg append_entries thread initiated 2024.09.24 01:08:04.357280 [ 520 ] {} KeeperDispatcher: Server initialized, waiting for quorum 2024.09.24 01:08:04.356684 [ 802 ] {} RaftInstance: Election timeout, initiate leader election 2024.09.24 01:08:04.360566 [ 802 ] {} RaftInstance: [PRIORITY] decay, target 1 -> 1, mine 1 2024.09.24 01:08:04.363867 [ 802 ] {} 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.09.24 01:08:04.370442 [ 802 ] {} RaftInstance: [VOTE INIT] my id 1, my role candidate, term 1, log idx 0, log term 0, priority (target 1 / mine 1) 2024.09.24 01:08:04.372308 [ 802 ] {} RaftInstance: number of pending commit elements: 0 2024.09.24 01:08:04.374806 [ 802 ] {} RaftInstance: state machine commit index 0, precommit index 0, last log index 0 2024.09.24 01:08:04.378350 [ 802 ] {} RaftInstance: [BECOME LEADER] appended new config at 1 2024.09.24 01:08:04.393887 [ 818 ] {} RaftInstance: config at index 1 is committed, prev config log idx 0 2024.09.24 01:08:04.417672 [ 818 ] {} RaftInstance: new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 2024.09.24 01:08:04.420520 [ 818 ] {} 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.09.24 01:08:04.425293 [ 520 ] {} KeeperDispatcher: Quorum initialized 2024.09.24 01:08:04.426264 [ 520 ] {} KeeperDispatcher: Dispatcher initialized 2024.09.24 01:08:04.521293 [ 520 ] {} Application: Listening for Keeper (tcp): [::]:9181 2024.09.24 01:08:04.525288 [ 520 ] {} Application: Listening for replica communication (interserver): http://[::]:9009 2024.09.24 01:08:04.625846 [ 520 ] {} ConfigReloader: Loading config '/etc/clickhouse-server/users.xml' 2024.09.24 01:08:05.033262 [ 520 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performing update on configuration 2024.09.24 01:08:05.505335 [ 520 ] {} ConfigReloader: Loaded config '/etc/clickhouse-server/users.xml', performed update on configuration 2024.09.24 01:08:05.551781 [ 520 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /etc/clickhouse-server/users.xml 2024.09.24 01:08:05.589722 [ 520 ] {} Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist 2024.09.24 01:08:05.605700 [ 520 ] {} Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/ 2024.09.24 01:08:05.622646 [ 520 ] {} Access(user directories): Added local_directory access storage 'local_directory', path: /var/lib/clickhouse/access/ 2024.09.24 01:08:05.921674 [ 520 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.09.24 01:08:05.989231 [ 520 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.09.24 01:08:06.018386 [ 520 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.09.24 01:08:06.106691 [ 520 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.09.24 01:08:06.281281 [ 520 ] {} DNSCacheUpdater: Update period 15 seconds 2024.09.24 01:08:06.282394 [ 520 ] {} Application: Loading metadata from /var/lib/clickhouse/ 2024.09.24 01:08:06.286962 [ 615 ] {} DNSResolver: Updating DNS cache 2024.09.24 01:08:06.314384 [ 615 ] {} DNSResolver: Updated DNS cache 2024.09.24 01:08:06.537665 [ 520 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.09.24 01:08:06.553190 [ 520 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.06388695 sec 2024.09.24 01:08:06.553770 [ 520 ] {} ReferentialDeps: No tables 2024.09.24 01:08:06.554339 [ 520 ] {} LoadingDeps: No tables 2024.09.24 01:08:06.557612 [ 520 ] {} DatabaseAtomic (system): Starting up tables. 2024.09.24 01:08:06.558671 [ 520 ] {} SystemLog: Creating system.query_log from query_log 2024.09.24 01:08:06.991011 [ 520 ] {} SystemLog: Creating system.query_thread_log from query_thread_log 2024.09.24 01:08:07.278920 [ 520 ] {} SystemLog: Creating system.part_log from part_log 2024.09.24 01:08:07.450702 [ 520 ] {} SystemLog: Creating system.trace_log from trace_log 2024.09.24 01:08:07.562314 [ 520 ] {} SystemLog: Creating system.crash_log from crash_log 2024.09.24 01:08:07.592449 [ 520 ] {} SystemLog: Creating system.text_log from text_log 2024.09.24 01:08:07.607535 [ 520 ] {} SystemLog: Creating system.metric_log from metric_log 2024.09.24 01:08:07.897751 [ 520 ] {} SystemLog: Creating system.filesystem_cache_log from filesystem_cache_log 2024.09.24 01:08:07.907758 [ 520 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.09.24 01:08:07.908347 [ 520 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2024.09.24 01:08:07.917339 [ 520 ] {} SystemLog: Creating system.opentelemetry_span_log from opentelemetry_span_log 2024.09.24 01:08:08.050402 [ 520 ] {} SystemLog: Creating system.query_views_log from query_views_log 2024.09.24 01:08:08.245780 [ 520 ] {} SystemLog: Creating system.zookeeper_log from zookeeper_log 2024.09.24 01:08:08.482688 [ 520 ] {} SystemLog: Creating system.session_log from session_log 2024.09.24 01:08:08.509529 [ 520 ] {} SystemLog: Creating system.transactions_info_log from transactions_info_log 2024.09.24 01:08:08.521046 [ 520 ] {} SystemLog: Creating system.processors_profile_log from processors_profile_log 2024.09.24 01:08:08.532226 [ 520 ] {} SystemLog: Creating system.asynchronous_insert_log from asynchronous_insert_log 2024.09.24 01:08:08.544860 [ 520 ] {} 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.09.24 01:08:12.616763 [ 901 ] {} SystemLog (system.text_log): Flushing system log, 152 entries to flush up to offset 152 2024.09.24 01:08:12.618444 [ 901 ] {} SystemLog (system.text_log): Creating new table system.text_log for TextLog 2024.09.24 01:08:13.293303 [ 901 ] {} WriteBufferFromAzureBlobStorage: Staged block (id: rxxkctkhervhcvcviiikflvvcheuqnblfrlyblfkyfgshpgvemtprmbkholgoanj) of size 4 (blob path: jdbtmthuhogpwtjesaqzskoqiyhjktdf). 2024.09.24 01:08:13.409629 [ 901 ] {} WriteBufferFromAzureBlobStorage: Committed 1 blocks for blob `jdbtmthuhogpwtjesaqzskoqiyhjktdf` 2024.09.24 01:08:13.430846 [ 520 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.09.24 01:08:13.443901 [ 520 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.09.24 01:08:13.446835 [ 520 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.004091153 sec 2024.09.24 01:08:13.447376 [ 520 ] {} ReferentialDeps: No tables 2024.09.24 01:08:13.447702 [ 901 ] {} DiskObjectStorage(DiskAzureBlobStorage): Starting up disk azure 2024.09.24 01:08:13.447823 [ 520 ] {} LoadingDeps: No tables 2024.09.24 01:08:13.448213 [ 901 ] {} DiskObjectStorage(DiskAzureBlobStorage): Disk azure started up 2024.09.24 01:08:13.448800 [ 520 ] {} DatabaseAtomic (default): Starting up tables. 2024.09.24 01:08:13.451478 [ 520 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/lib/clickhouse/user_defined/ 2024.09.24 01:08:13.461298 [ 520 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.09.24 01:08:13.469405 [ 520 ] {} Application: Loaded metadata. 2024.09.24 01:08:13.481524 [ 520 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.09.24 01:08:13.529300 [ 901 ] {} DiskCache: Registered cached disk (`cached_azure`) with structure: DiskObjectStorage-azure(CachedObjectStorage-cached_azure(AzureObjectStorage)) 2024.09.24 01:08:13.545250 [ 520 ] {} bool DB::(anonymous namespace)::checkPermissionsImpl(): Code: 412. DB::Exception: Can't receive Netlink response: error -2. (NETLINK_ERROR) (version 23.8.16.41.altinitystable (altinity build)) 2024.09.24 01:08:13.549529 [ 520 ] {} Application: Tasks stats provider: procfs 2024.09.24 01:08:13.998564 [ 520 ] {} AsynchronousMetrics: MemoryTracking: was 62.34 MiB, peak 94.32 MiB, free memory in arenas 5.13 MiB, will set to 772.95 MiB (RSS), difference: 710.61 MiB 2024.09.24 01:08:14.242100 [ 901 ] {} S3Client: Provider type: Unknown 2024.09.24 01:08:14.242442 [ 901 ] {} S3Client: API mode of the S3 client: AWS 2024.09.24 01:08:14.845870 [ 901 ] {} WriteBufferFromS3: Create WriteBufferFromS3, Details: bucket test, key common/clickhouse_remove_objects_capability_0ba8e9ea-5834-4b94-802e-6110b1de1bc0 (LogSeriesLimiter: on interval from 2024-09-24 01:08:03 to 2024-09-24 01:08:14 accepted series 1 / 2 for the logger WriteBufferFromS3 : 1.7491308770058435e+38) 2024.09.24 01:08:14.846475 [ 901 ] {} WriteBufferFromS3: finalizeImpl WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_0ba8e9ea-5834-4b94-802e-6110b1de1bc0. 2024.09.24 01:08:14.858013 [ 795 ] {} WriteBufferFromS3: Single part upload has completed. Details: bucket test, key common/clickhouse_remove_objects_capability_0ba8e9ea-5834-4b94-802e-6110b1de1bc0, size 4 2024.09.24 01:08:14.975770 [ 901 ] {} WriteBufferFromS3: Close WriteBufferFromS3. Details: bucket test, key common/clickhouse_remove_objects_capability_0ba8e9ea-5834-4b94-802e-6110b1de1bc0. 2024.09.24 01:08:14.983564 [ 901 ] {} S3ObjectStorage: Objects with paths [common/clickhouse_remove_objects_capability_0ba8e9ea-5834-4b94-802e-6110b1de1bc0] were removed from S3 2024.09.24 01:08:15.031021 [ 901 ] {} S3ObjectStorage: Objects with paths [common/tvw/gmqnqmztfpxwcnafjblerhdcgidpm] were removed from S3 2024.09.24 01:08:15.031433 [ 901 ] {} DiskObjectStorage(DiskS3): Starting up disk s3_disk 2024.09.24 01:08:15.032081 [ 901 ] {} DiskObjectStorage(DiskS3): Disk s3_disk started up 2024.09.24 01:08:15.037852 [ 901 ] {} DiskCache: Registered cached disk (`s3_cache`) with structure: DiskObjectStorage-s3_disk(CachedObjectStorage-s3_cache(S3ObjectStorage)) 2024.09.24 01:08:15.154915 [ 901 ] {} DiskObjectStorage(Local): Starting up disk local_disk 2024.09.24 01:08:15.155390 [ 901 ] {} DiskObjectStorage(Local): Disk local_disk started up 2024.09.24 01:08:15.165534 [ 901 ] {} DiskObjectStorage(Local): Starting up disk local_disk_2 2024.09.24 01:08:15.165997 [ 901 ] {} DiskObjectStorage(Local): Disk local_disk_2 started up 2024.09.24 01:08:15.176661 [ 901 ] {} DiskObjectStorage(Local): Starting up disk local_disk_3 2024.09.24 01:08:15.177196 [ 901 ] {} DiskObjectStorage(Local): Disk local_disk_3 started up 2024.09.24 01:08:15.182876 [ 901 ] {} DiskCache: Registered cached disk (`local_cache`) with structure: DiskObjectStorage-local_disk(CachedObjectStorage-local_cache(LocalObjectStorage)) 2024.09.24 01:08:15.199253 [ 901 ] {} DiskCache: Registered cached disk (`local_cache_2`) with structure: DiskObjectStorage-local_disk(CachedObjectStorage-local_cache_2(LocalObjectStorage)) 2024.09.24 01:08:15.235382 [ 901 ] {} DiskCache: Registered cached disk (`local_cache_3`) with structure: DiskObjectStorage-local_disk_3(CachedObjectStorage-local_cache_3(LocalObjectStorage)) 2024.09.24 01:08:15.276388 [ 901 ] {} DiskCache: Registered cached disk (`s3_cache_multi`) with structure: DiskObjectStorage-s3_disk(CachedObjectStorage-s3_cache_multi(CachedObjectStorage-s3_cache(S3ObjectStorage))) 2024.09.24 01:08:15.310875 [ 901 ] {} 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.09.24 01:08:15.371069 [ 901 ] {} StoragePolicy (azure_cache): Storage policy azure_cache created, total volumes 1 2024.09.24 01:08:15.376757 [ 901 ] {} StoragePolicySelector: Storage policy `azure_cache` loaded 2024.09.24 01:08:15.407936 [ 901 ] {} StoragePolicy (s3_cache): Storage policy s3_cache created, total volumes 1 2024.09.24 01:08:15.408486 [ 901 ] {} StoragePolicySelector: Storage policy `s3_cache` loaded 2024.09.24 01:08:15.425299 [ 901 ] {} StoragePolicy (s3_cache_multi): Storage policy s3_cache_multi created, total volumes 1 2024.09.24 01:08:15.431889 [ 901 ] {} StoragePolicySelector: Storage policy `s3_cache_multi` loaded 2024.09.24 01:08:15.466891 [ 901 ] {} StoragePolicy (local_cache): Storage policy local_cache created, total volumes 1 2024.09.24 01:08:15.467538 [ 901 ] {} StoragePolicySelector: Storage policy `local_cache` loaded 2024.09.24 01:08:15.474749 [ 901 ] {} StoragePolicy (local_cache_2): Storage policy local_cache_2 created, total volumes 1 2024.09.24 01:08:15.475475 [ 901 ] {} StoragePolicySelector: Storage policy `local_cache_2` loaded 2024.09.24 01:08:15.478582 [ 901 ] {} StoragePolicy (local_cache_3): Storage policy local_cache_3 created, total volumes 1 2024.09.24 01:08:15.489319 [ 901 ] {} StoragePolicySelector: Storage policy `local_cache_3` loaded 2024.09.24 01:08:15.490388 [ 901 ] {} StoragePolicy (default): Storage policy default created, total volumes 1 2024.09.24 01:08:15.494160 [ 901 ] {} system.text_log (8bad261e-b74d-4d54-ab99-c4b8b8fd036e): Loading data parts 2024.09.24 01:08:15.498179 [ 621 ] {} DatabaseCatalog: Execution took 2047 ms. 2024.09.24 01:08:15.523468 [ 520 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 0.002309061 sec. 2024.09.24 01:08:15.536518 [ 901 ] {} system.text_log (8bad261e-b74d-4d54-ab99-c4b8b8fd036e): There are no data parts 2024.09.24 01:08:15.621327 [ 902 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 76 entries to flush up to offset 76 2024.09.24 01:08:15.624239 [ 902 ] {} SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog 2024.09.24 01:08:15.642684 [ 520 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/decimals_dictionary.xml'. 2024.09.24 01:08:15.751964 [ 902 ] {} system.asynchronous_metric_log (5ce314f4-bb42-4c8c-ad5f-7d23c2051179): Loading data parts 2024.09.24 01:08:15.767362 [ 901 ] {} system.text_log (8bad261e-b74d-4d54-ab99-c4b8b8fd036e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.09.24 01:08:15.768102 [ 901 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.64 GiB. 2024.09.24 01:08:15.788121 [ 901 ] {} MergedBlockOutputStream: filled checksums 202409_1_1_0 (state Temporary) 2024.09.24 01:08:15.898203 [ 902 ] {} system.asynchronous_metric_log (5ce314f4-bb42-4c8c-ad5f-7d23c2051179): There are no data parts 2024.09.24 01:08:15.919028 [ 520 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/executable_dictionary.xml'. 2024.09.24 01:08:15.946687 [ 901 ] {} system.text_log (8bad261e-b74d-4d54-ab99-c4b8b8fd036e): Renaming temporary part tmp_insert_202409_1_1_0 to 202409_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.09.24 01:08:16.003958 [ 520 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/executable_pool_dictionary.xml'. 2024.09.24 01:08:16.063491 [ 901 ] {} SystemLog (system.text_log): Flushed system log up to offset 152 2024.09.24 01:08:16.064176 [ 902 ] {} system.asynchronous_metric_log (5ce314f4-bb42-4c8c-ad5f-7d23c2051179): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.09.24 01:08:16.064870 [ 902 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.64 GiB. 2024.09.24 01:08:16.066233 [ 900 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 2024.09.24 01:08:16.067867 [ 900 ] {} SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog 2024.09.24 01:08:16.092264 [ 902 ] {} MergedBlockOutputStream: filled checksums 202409_1_1_0 (state Temporary) 2024.09.24 01:08:16.105369 [ 902 ] {} system.asynchronous_metric_log (5ce314f4-bb42-4c8c-ad5f-7d23c2051179): Renaming temporary part tmp_insert_202409_1_1_0 to 202409_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.09.24 01:08:16.115467 [ 902 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 76 2024.09.24 01:08:16.146426 [ 520 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/ints_dictionary.xml'. 2024.09.24 01:08:16.147644 [ 907 ] {} SystemLog (system.transactions_info_log): Flushing system log, 2 entries to flush up to offset 2 2024.09.24 01:08:16.149583 [ 907 ] {} SystemLog (system.transactions_info_log): Creating new table system.transactions_info_log for TransactionsInfoLog 2024.09.24 01:08:16.165071 [ 898 ] {} SystemLog (system.trace_log): Flushing system log, 15 entries to flush up to offset 15 2024.09.24 01:08:16.166639 [ 898 ] {} SystemLog (system.trace_log): Creating new table system.trace_log for TraceLog 2024.09.24 01:08:16.195352 [ 953 ] {} AsynchronousMetrics: MemoryTracking: was 800.27 MiB, peak 803.42 MiB, free memory in arenas 5.46 MiB, will set to 789.68 MiB (RSS), difference: -10.59 MiB 2024.09.24 01:08:16.271826 [ 907 ] {} system.transactions_info_log (1b2e22c0-97ca-4023-93a5-92eb557c2b05): Loading data parts 2024.09.24 01:08:16.312417 [ 907 ] {} system.transactions_info_log (1b2e22c0-97ca-4023-93a5-92eb557c2b05): There are no data parts 2024.09.24 01:08:16.385092 [ 907 ] {} system.transactions_info_log (1b2e22c0-97ca-4023-93a5-92eb557c2b05): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.09.24 01:08:16.385821 [ 907 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.64 GiB. 2024.09.24 01:08:16.493457 [ 898 ] {} system.trace_log (b725782f-e854-46a1-a8f3-e6a4dcfe0734): Loading data parts 2024.09.24 01:08:16.524183 [ 898 ] {} system.trace_log (b725782f-e854-46a1-a8f3-e6a4dcfe0734): There are no data parts 2024.09.24 01:08:16.567578 [ 907 ] {} MergedBlockOutputStream: filled checksums 202409_1_1_0 (state Temporary) 2024.09.24 01:08:16.625953 [ 907 ] {} system.transactions_info_log (1b2e22c0-97ca-4023-93a5-92eb557c2b05): Renaming temporary part tmp_insert_202409_1_1_0 to 202409_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.09.24 01:08:16.634979 [ 907 ] {} SystemLog (system.transactions_info_log): Flushed system log up to offset 2 2024.09.24 01:08:16.639141 [ 520 ] {} ExternalDictionariesLoader: Loading config file '/etc/clickhouse-server/strings_dictionary.xml'. 2024.09.24 01:08:16.781847 [ 898 ] {} system.trace_log (b725782f-e854-46a1-a8f3-e6a4dcfe0734): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.09.24 01:08:16.790717 [ 898 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.69 GiB. 2024.09.24 01:08:16.906235 [ 520 ] {} ExternalUserDefinedExecutableFunctionsLoader: Loading config file '/etc/clickhouse-server/test_function.xml'. 2024.09.24 01:08:16.946893 [ 898 ] {} MergedBlockOutputStream: filled checksums 202409_1_1_0 (state Temporary) 2024.09.24 01:08:17.030369 [ 520 ] {} ExternalUserDefinedExecutableFunctionsLoader: Will load 'test_function' because always_load_everything flag is set. 2024.09.24 01:08:17.030840 [ 520 ] {} ExternalUserDefinedExecutableFunctionsLoader: Will load the object 'test_function' immediately, force = false, loading_id = 1 2024.09.24 01:08:17.031304 [ 520 ] {} ExternalUserDefinedExecutableFunctionsLoader: Start loading object 'test_function' 2024.09.24 01:08:17.035345 [ 520 ] {} ExternalUserDefinedExecutableFunctionsLoader: Supposed update time for 'test_function' is never (loaded, lifetime 0) 2024.09.24 01:08:17.035924 [ 520 ] {} ExternalUserDefinedExecutableFunctionsLoader: Next update time for 'test_function' was set to 294247-01-10 05:00:54 2024.09.24 01:08:17.051984 [ 957 ] {} DDLWorker: Starting DDLWorker thread 2024.09.24 01:08:17.052197 [ 958 ] {} DDLWorker: Started DDLWorker cleanup thread 2024.09.24 01:08:17.061200 [ 957 ] {} DDLWorker: Initializing DDLWorker thread 2024.09.24 01:08:17.075911 [ 898 ] {} system.trace_log (b725782f-e854-46a1-a8f3-e6a4dcfe0734): Renaming temporary part tmp_insert_202409_1_1_0 to 202409_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.09.24 01:08:17.061497 [ 520 ] {} Application: Listening for http://[::]:8123 2024.09.24 01:08:17.077459 [ 520 ] {} Application: Listening for https://[::]:8443 2024.09.24 01:08:17.078353 [ 520 ] {} Application: Listening for native protocol (tcp): [::]:9000 2024.09.24 01:08:17.080050 [ 520 ] {} Application: Listening for native protocol (tcp) with PROXY: [::]:9010 2024.09.24 01:08:17.081625 [ 520 ] {} Application: Listening for secure native protocol (tcp_secure): [::]:9440 2024.09.24 01:08:17.082129 [ 520 ] {} Application: Listening for MySQL compatibility protocol: [::]:9004 2024.09.24 01:08:17.082718 [ 520 ] {} Application: Listening for PostgreSQL compatibility protocol: [::]:9005 2024.09.24 01:08:17.083259 [ 520 ] {} Application: Listening for Prometheus: http://[::]:9988 2024.09.24 01:08:17.129861 [ 898 ] {} SystemLog (system.trace_log): Flushed system log up to offset 15 2024.09.24 01:08:17.205701 [ 522 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:49080 2024.09.24 01:08:17.209078 [ 523 ] {} KeeperTCPHandlerFactory: Keeper request. Address: [::1]:43142 2024.09.24 01:08:17.274877 [ 523 ] {} KeeperTCPHandler: Requesting session ID for the new client 2024.09.24 01:08:17.286075 [ 781 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.09.24 01:08:17.304218 [ 953 ] {} AsynchronousMetrics: MemoryTracking: was 801.30 MiB, peak 804.44 MiB, free memory in arenas 5.49 MiB, will set to 814.05 MiB (RSS), difference: 12.76 MiB 2024.09.24 01:08:17.306089 [ 818 ] {} KeeperStateMachine: Session ID response 1 with timeout 30000 2024.09.24 01:08:17.323953 [ 522 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.09.24 01:08:17.333492 [ 522 ] {} TCP-Session: 6730c919-a3b8-4818-a70a-b2fb01413ced Authenticating user 'default' from [::1]:49080 2024.09.24 01:08:17.334917 [ 522 ] {} TCP-Session: 6730c919-a3b8-4818-a70a-b2fb01413ced Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.09.24 01:08:17.336380 [ 522 ] {} TCP-Session: 6730c919-a3b8-4818-a70a-b2fb01413ced Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.09.24 01:08:17.341879 [ 523 ] {} KeeperTCPHandler: Received session ID 1 2024.09.24 01:08:17.342459 [ 957 ] {} ZooKeeperClient: Connected to ZooKeeper at [::1]:9181 with session_id 1 2024.09.24 01:08:17.387580 [ 957 ] {} ZooKeeperClient: Keeper feature flag FILTERED_LIST: enabled 2024.09.24 01:08:17.388330 [ 957 ] {} ZooKeeperClient: Keeper feature flag MULTI_READ: enabled 2024.09.24 01:08:17.388710 [ 957 ] {} ZooKeeperClient: Keeper feature flag CHECK_NOT_EXISTS: enabled 2024.09.24 01:08:17.389065 [ 522 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.09.24 01:08:17.389404 [ 957 ] {} ZooKeeper: Initialized, hosts: localhost:9181 2024.09.24 01:08:17.389867 [ 522 ] {} ContextAccess (default): List of all grants: GRANT ALL ON *.* WITH GRANT OPTION 2024.09.24 01:08:17.390407 [ 781 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 1 2024.09.24 01:08:17.390409 [ 520 ] {} ZooKeeperClient: ZK send fault: 0.002% 2024.09.24 01:08:17.390542 [ 522 ] {} ContextAccess (default): List of all grants including implicit: GRANT ALL ON *.* WITH GRANT OPTION 2024.09.24 01:08:17.391202 [ 520 ] {} ZooKeeperClient: ZK recv fault: 0.002% 2024.09.24 01:08:17.391493 [ 520 ] {} ZooKeeperClient: ZK send sleep: 0.001% -> 10000ms 2024.09.24 01:08:17.392187 [ 520 ] {} Application: Ready for connections. 2024.09.24 01:08:17.457938 [ 522 ] {} TCP-Session: 6730c919-a3b8-4818-a70a-b2fb01413ced Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.09.24 01:08:17.463678 [ 522 ] {df69ffcc-02cb-47d8-ba1a-84cf095dc092} executeQuery: (from [::1]:49080) SELECT 1 (stage: Complete) 2024.09.24 01:08:17.486092 [ 522 ] {df69ffcc-02cb-47d8-ba1a-84cf095dc092} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.09.24 01:08:17.487509 [ 522 ] {df69ffcc-02cb-47d8-ba1a-84cf095dc092} InterpreterSelectQuery: FetchColumns -> Complete 2024.09.24 01:08:17.494659 [ 781 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.09.24 01:08:17.655638 [ 522 ] {df69ffcc-02cb-47d8-ba1a-84cf095dc092} executeQuery: Read 1 rows, 1.00 B in 0.191306 sec., 5.22722758303451 rows/sec., 5.23 B/sec. 2024.09.24 01:08:17.670473 [ 522 ] {df69ffcc-02cb-47d8-ba1a-84cf095dc092} TCPHandler: Processed in 0.216552587 sec. 2024.09.24 01:08:17.696829 [ 781 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 85 2024.09.24 01:08:17.725665 [ 781 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 74 2024.09.24 01:08:17.739907 [ 781 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 85 2024.09.24 01:08:17.758385 [ 781 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 89 2024.09.24 01:08:17.769369 [ 957 ] {} DDLWorker: Initialized DDLWorker thread 2024.09.24 01:08:17.769852 [ 957 ] {} DDLWorker: Scheduling tasks 2024.09.24 01:08:17.770260 [ 957 ] {} DDLWorker: Don't have unfinished tasks after restarting 2024.09.24 01:08:17.771957 [ 958 ] {} DDLWorker: Cleaning queue 2024.09.24 01:08:17.779486 [ 957 ] {} 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.09.24 01:08:17.779874 [ 957 ] {} DDLWorker: No tasks to schedule 2024.09.24 01:08:17.780172 [ 957 ] {} DDLWorker: Waiting for queue updates 2024.09.24 01:08:17.828156 [ 522 ] {} TCPHandler: Done processing connection. 2024.09.24 01:08:17.851787 [ 522 ] {} TCP-Session: 6730c919-a3b8-4818-a70a-b2fb01413ced Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.09.24 01:09:54.654886 [ 523 ] {} KeeperTCPHandler: Session #1 expired 2024.09.24 01:09:54.655885 [ 629 ] {} BackgroundJobsAssignee:DataProcessing: Execution took 96706 ms. 2024.09.24 01:09:54.658499 [ 898 ] {} SystemLog (system.trace_log): Flushing system log, 7 entries to flush up to offset 22 2024.09.24 01:09:54.658613 [ 902 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 810 entries to flush up to offset 886 2024.09.24 01:09:54.658773 [ 907 ] {} SystemLog (system.transactions_info_log): Flushing system log, 2 entries to flush up to offset 4 2024.09.24 01:09:54.659970 [ 901 ] {} SystemLog (system.text_log): Flushing system log, 162 entries to flush up to offset 314 2024.09.24 01:09:54.666980 [ 522 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:60724 2024.09.24 01:09:54.667870 [ 820 ] {} KeeperDispatcher: Found dead session 1, will try to close it 2024.09.24 01:09:54.668334 [ 905 ] {} SystemLog (system.zookeeper_log): Flushing system log, 18 entries to flush up to offset 18 2024.09.24 01:09:54.668601 [ 895 ] {} SystemLog (system.query_log): Flushing system log, 2 entries to flush up to offset 2 2024.09.24 01:09:54.671414 [ 522 ] {} TCPHandler: Connected ClickHouse client version 23.8.0, revision: 54465, user: default. 2024.09.24 01:09:54.672241 [ 905 ] {} SystemLog (system.zookeeper_log): Creating new table system.zookeeper_log for ZooKeeperLog 2024.09.24 01:09:54.672377 [ 781 ] {} KeeperDispatcher: Processing requests batch, size: 1, bytes: 0 2024.09.24 01:09:54.671754 [ 820 ] {} KeeperDispatcher: Dead session close request pushed 2024.09.24 01:09:54.673007 [ 895 ] {} SystemLog (system.query_log): Creating new table system.query_log for QueryLog 2024.09.24 01:09:54.675329 [ 522 ] {} TCP-Session: 08116a88-1e60-4754-ba53-a594ddbc4e2d Authenticating user 'default' from [::1]:60724 2024.09.24 01:09:54.678188 [ 522 ] {} TCP-Session: 08116a88-1e60-4754-ba53-a594ddbc4e2d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.09.24 01:09:54.679997 [ 522 ] {} TCP-Session: 08116a88-1e60-4754-ba53-a594ddbc4e2d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.09.24 01:09:54.682192 [ 906 ] {} SystemLog (system.session_log): Flushing system log, 2 entries to flush up to offset 2 2024.09.24 01:09:54.684028 [ 906 ] {} SystemLog (system.session_log): Creating new table system.session_log for SessionLog 2024.09.24 01:09:54.794134 [ 522 ] {} TCP-Session: 08116a88-1e60-4754-ba53-a594ddbc4e2d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.09.24 01:09:54.793099 [ 635 ] {} DNSResolver: Updating DNS cache 2024.09.24 01:09:54.798433 [ 522 ] {a62b3313-22a3-4f1d-8821-00f7ea9d72ee} executeQuery: (from [::1]:60724) SELECT 'Connected to clickhouse-server after attaching gdb' (stage: Complete) 2024.09.24 01:09:54.803673 [ 635 ] {} DNSResolver: Updated DNS cache 2024.09.24 01:09:54.805341 [ 522 ] {a62b3313-22a3-4f1d-8821-00f7ea9d72ee} ContextAccess (default): Access granted: SELECT(dummy) ON system.one 2024.09.24 01:09:54.806208 [ 522 ] {a62b3313-22a3-4f1d-8821-00f7ea9d72ee} InterpreterSelectQuery: FetchColumns -> Complete 2024.09.24 01:09:54.951884 [ 907 ] {} system.transactions_info_log (1b2e22c0-97ca-4023-93a5-92eb557c2b05): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.09.24 01:09:54.969802 [ 898 ] {} system.trace_log (b725782f-e854-46a1-a8f3-e6a4dcfe0734): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.09.24 01:09:54.970844 [ 898 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.62 GiB. 2024.09.24 01:09:54.972804 [ 907 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.62 GiB. 2024.09.24 01:09:54.985634 [ 522 ] {a62b3313-22a3-4f1d-8821-00f7ea9d72ee} executeQuery: Read 1 rows, 1.00 B in 0.14771 sec., 6.770022341073725 rows/sec., 6.77 B/sec. 2024.09.24 01:09:55.005183 [ 522 ] {a62b3313-22a3-4f1d-8821-00f7ea9d72ee} TCPHandler: Processed in 0.210363448 sec. 2024.09.24 01:09:55.117903 [ 898 ] {} MergedBlockOutputStream: filled checksums 202409_2_2_0 (state Temporary) 2024.09.24 01:09:55.133169 [ 907 ] {} MergedBlockOutputStream: filled checksums 202409_2_2_0 (state Temporary) 2024.09.24 01:09:55.144069 [ 522 ] {} TCPHandler: Done processing connection. 2024.09.24 01:09:55.242467 [ 953 ] {} AsynchronousMetrics: MemoryTracking: was 821.50 MiB, peak 823.50 MiB, free memory in arenas 6.45 MiB, will set to 817.90 MiB (RSS), difference: -3.60 MiB 2024.09.24 01:09:55.265654 [ 898 ] {} system.trace_log (b725782f-e854-46a1-a8f3-e6a4dcfe0734): Renaming temporary part tmp_insert_202409_2_2_0 to 202409_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.09.24 01:09:55.265246 [ 522 ] {} TCP-Session: 08116a88-1e60-4754-ba53-a594ddbc4e2d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.09.24 01:09:55.273834 [ 968 ] {} 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() @ 0x000000000b1a33c2 in /usr/bin/clickhouse 1. /build/contrib/llvm-project/libcxx/include/exception:112: std::exception::exception[abi:v15000]() @ 0x000000000b1a338d in /usr/bin/clickhouse 2. /build/base/poco/Foundation/src/Exception.cpp:27: Poco::Exception::Exception(String const&, int) @ 0x000000002495ef40 in /usr/bin/clickhouse 3. /build/src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000138de6ae in /usr/bin/clickhouse 4. /build/src/Common/Exception.h:73: DB::Exception::Exception(String&&, int, bool) @ 0x000000000b19540a in /usr/bin/clickhouse 5. /build/src/Common/NetException.h:26: DB::NetException::NetException(int, FormatStringHelperImpl::type, std::type_identity::type>, String&&, String&&) @ 0x0000000013cee00c in /usr/bin/clickhouse 6. /build/src/IO/ReadBufferFromPocoSocket.cpp:86: DB::ReadBufferFromPocoSocket::nextImpl() @ 0x0000000013ced280 in /usr/bin/clickhouse 7. /build/src/IO/ReadBuffer.h:71: DB::ReadBuffer::next() @ 0x000000000b2189bc in /usr/bin/clickhouse 8. /build/src/IO/ReadBuffer.h:105: DB::ReadBuffer::read(char*, unsigned long) @ 0x000000000b2185b3 in /usr/bin/clickhouse 9. /build/src/IO/ReadBuffer.h:196: DB::ReadBuffer::readStrict(char*, unsigned long) @ 0x000000000b5e10a8 in /usr/bin/clickhouse 10. /build/src/IO/ReadHelpers.h:117: void DB::readPODBinary(int&, DB::ReadBuffer&) @ 0x0000000013996b42 in /usr/bin/clickhouse 11. /build/src/IO/ReadHelpers.h:1099: void DB::readBinary(int&, DB::ReadBuffer&) @ 0x0000000013996afd in /usr/bin/clickhouse 12. /build/src/IO/ReadHelpers.h:1136: void DB::readBinaryEndian<(std::endian)64206, int>(int&, DB::ReadBuffer&) @ 0x000000001e5fe55d in /usr/bin/clickhouse 13. /build/src/IO/ReadHelpers.h:1149: void DB::readBinaryBigEndian(int&, DB::ReadBuffer&) @ 0x000000001e5fe51d in /usr/bin/clickhouse 14. /build/src/Common/ZooKeeper/ZooKeeperIO.h:51: void Coordination::read(int&, DB::ReadBuffer&) @ 0x000000001e5f999d in /usr/bin/clickhouse 15. /build/src/Common/ZooKeeper/ZooKeeperImpl.cpp:284: void Coordination::ZooKeeper::read(int&) @ 0x000000001f3074b4 in /usr/bin/clickhouse 16. /build/src/Common/ZooKeeper/ZooKeeperImpl.cpp:744: Coordination::ZooKeeper::receiveEvent() @ 0x000000001f2fc8ec in /usr/bin/clickhouse 17. /build/src/Common/ZooKeeper/ZooKeeperImpl.cpp:710: Coordination::ZooKeeper::receiveThread() @ 0x000000001f2fc364 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 @ 0x000000001f302198 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&) @ 0x000000001f302175 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<>) @ 0x000000001f302159 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, std::optional>&&)::$_1&, std::tuple<>&) @ 0x000000001f3020bd in /usr/bin/clickhouse 22. /build/src/Common/ThreadPool.h:242: ThreadFromGlobalPoolImpl::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'()::operator()() @ 0x000000001f301fe5 in /usr/bin/clickhouse 23. /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]::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