Processing configuration file '/etc/clickhouse-server/config.xml'. Logging information to console 2021.09.30 14:36:01.937108 [ 61 ] {} Application: Will watch for the process with pid 79 2021.09.30 14:36:01.945426 [ 79 ] {} Application: Forked a child process to watch 2021.09.30 14:36:01.946170 [ 79 ] {} SentryWriter: Sending crash reports is disabled 2021.09.30 14:36:02.120103 [ 79 ] {} : Starting ClickHouse 21.3.14.1 with revision 54448, build id: EECCDFD443ECEC6C7FFF503B14F9FFC61B46A555, PID 79 2021.09.30 14:36:02.121000 [ 79 ] {} Application: starting up 2021.09.30 14:36:02.266304 [ 79 ] {} Application: Calculated checksum of the binary: 8F1CD5E057B78C7BF9D86478DE637C11, integrity check passed. 2021.09.30 14:36:02.274286 [ 79 ] {} Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /usr/bin/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. 2021.09.30 14:36:02.275345 [ 79 ] {} SensitiveDataMaskerConfigRead: 1 query masking rules loaded. 2021.09.30 14:36:02.279397 [ 79 ] {} Application: Setting max_server_memory_usage was set to 27.87 GiB (30.96 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) 2021.09.30 14:36:02.283961 [ 79 ] {} Access(local directory): File /pmmdata/clickhouse/access/users.list doesn't exist 2021.09.30 14:36:02.283979 [ 79 ] {} Access(local directory): Recovering lists in directory /pmmdata/clickhouse/access/ 2021.09.30 14:36:02.284498 [ 79 ] {} Application: Loading metadata from /srv/clickhouse/ 2021.09.30 14:36:02.288219 [ 79 ] {} DatabaseAtomic (system): Total 0 tables and 0 dictionaries. 2021.09.30 14:36:02.288238 [ 79 ] {} DatabaseAtomic (system): Starting up tables. 2021.09.30 14:36:02.294453 [ 79 ] {} DatabaseAtomic (default): Total 0 tables and 0 dictionaries. 2021.09.30 14:36:02.294468 [ 79 ] {} DatabaseAtomic (default): Starting up tables. 2021.09.30 14:36:02.294545 [ 79 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2021.09.30 14:36:02.294559 [ 79 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 16 threads 2021.09.30 14:36:02.296049 [ 79 ] {} Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /usr/bin/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. 2021.09.30 14:36:02.296414 [ 79 ] {} Application: Listening for http://0.0.0.0:8123 2021.09.30 14:36:02.310572 [ 79 ] {} Application: Listening for connections with native protocol (tcp): 0.0.0.0:9000 2021.09.30 14:36:02.310907 [ 79 ] {} Application: Listening for replica communication (interserver): http://0.0.0.0:9009 2021.09.30 14:36:02.376409 [ 79 ] {} Application: Listening for MySQL compatibility protocol: 0.0.0.0:9004 2021.09.30 14:36:02.376477 [ 79 ] {} Application: Listening for PostgreSQL compatibility protocol: 0.0.0.0:9005 2021.09.30 14:36:02.394953 [ 79 ] {} DNSCacheUpdater: Update period 15 seconds 2021.09.30 14:36:02.395001 [ 79 ] {} Application: Available RAM: 30.96 GiB; physical cores: 2; logical cores: 4. 2021.09.30 14:36:02.395815 [ 79 ] {} Application: Ready for connections. 2021.09.30 14:36:03.181518 [ 140 ] {} TCPHandler: Code: 81, e.displayText() = DB::Exception: Database `pmm` doesn't exist, Stack trace: 0. DB::TCPHandler::runImpl() @ 0xf69103f in /usr/bin/clickhouse 1. DB::TCPHandler::run() @ 0xf6a1849 in /usr/bin/clickhouse 2. Poco::Net::TCPServerConnection::start() @ 0x11d56f5f in /usr/bin/clickhouse 3. Poco::Net::TCPServerDispatcher::run() @ 0x11d58971 in /usr/bin/clickhouse 4. Poco::PooledThread::run() @ 0x11e8f099 in /usr/bin/clickhouse 5. Poco::ThreadImpl::runnableEntry(void*) @ 0x11e8aefa in /usr/bin/clickhouse 6. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so 7. __clone @ 0xfe9fd in /usr/lib64/libc-2.17.so 2021.09.30 14:36:03.186183 [ 140 ] {ef4f412b-d261-4e67-8df2-cb941c6cef7b} DatabaseOrdinary (pmm): Total 0 tables and 0 dictionaries. 2021.09.30 14:36:03.186200 [ 140 ] {ef4f412b-d261-4e67-8df2-cb941c6cef7b} DatabaseOrdinary (pmm): Starting up tables. 2021.10.01 14:36:03.336379 [ 140 ] {85e988ba-0c60-4b5f-b1aa-057243cdfca8} executeQuery: Read 152 rows, 2.26 KiB in 0.001884605 sec., 80653 rows/sec., 1.17 MiB/sec. 2021.10.01 14:36:03.336789 [ 140 ] {45d792fd-0d69-43ee-87a8-0441e444d0cf} pmm.metrics: Removed 0 parts. 2021.10.01 14:36:03.337484 [ 140 ] {ad38fd39-05d3-4a6f-9b20-1cb7a6dc8e2b} pmm.metrics: Removed 0 parts. 2021.10.02 14:36:03.336806 [ 140 ] {2387e235-7274-4a60-88a0-832bfdb22cc8} executeQuery: Read 175 rows, 2.60 KiB in 0.002133884 sec., 82010 rows/sec., 1.19 MiB/sec. 2021.10.02 14:36:03.337246 [ 140 ] {6e79f600-a960-4278-b18b-242840d8d09e} pmm.metrics: Removed 0 parts. 2021.10.02 14:36:03.337629 [ 140 ] {1953c946-5c84-45a3-9757-085cbb729405} pmm.metrics: Removed 0 parts. 2021.10.03 14:36:03.349523 [ 140 ] {21b936b6-3e6d-401e-9b4f-5643c0bc035c} executeQuery: Read 240 rows, 3.56 KiB in 0.001825939 sec., 131439 rows/sec., 1.90 MiB/sec. 2021.10.03 14:36:03.351210 [ 140 ] {dbf83f7e-a746-470e-bdd7-8d5b4c48a05f} pmm.metrics: Removed 0 parts. 2021.10.03 14:36:03.352371 [ 140 ] {f294caad-c867-4ca3-b4d6-6fdbd62eda26} pmm.metrics: Removed 0 parts. 2021.10.04 14:36:03.336199 [ 140 ] {02e1d71b-5870-4419-9435-90f69a49ee4d} executeQuery: Read 184 rows, 2.74 KiB in 0.001860038 sec., 98922 rows/sec., 1.44 MiB/sec. 2021.10.04 14:36:03.336622 [ 140 ] {a9103dad-6401-4a9d-84a7-2cc5dd57de5e} pmm.metrics: Removed 0 parts. 2021.10.04 14:36:03.337454 [ 140 ] {93f20896-6bf4-4709-bbb3-8c4449bc24da} pmm.metrics: Removed 0 parts. 2021.10.05 14:36:03.336556 [ 140 ] {5a95ac23-02ff-43e5-9fed-b92fcc2c96b2} executeQuery: Read 173 rows, 2.58 KiB in 0.001887958 sec., 91633 rows/sec., 1.33 MiB/sec. 2021.10.05 14:36:03.337049 [ 140 ] {dea9205f-b124-4a13-991d-1a1fa72c51f7} pmm.metrics: Removed 0 parts. 2021.10.05 14:36:03.337458 [ 140 ] {7700fa2c-5c16-4437-82b9-e91edcbb295f} pmm.metrics: Removed 0 parts.