clickhouse-backup list警告warn BackupList bd.Walk return error: file does not exist logger=SFTP
当clickhouse-backup的默认配置文件/etc/clickhouse-backup/config.yml中配置的远程存储如sftp相关配置下的path参数对应路径不存在时,会警告。
比如如下配置:
vi /etc/clickhouse-backup/config.yml
general:
remote_storage: sftp
clickhouse:
username: default
password: "defaultsys"
skip_tables:
- system.*
- INFORMATION_SCHEMA.*
- information_schema.*
- default.*
sftp:
address: "192.168.1.100"
port: 22
username: "root"
password: "root"
key: ""
path: "/clickhouse/backup"
concurrency: 4
compression_format: none
compression_level: 2
若目录/clickhouse/backup在远程机器ip为192.168.1.100上边不存在时,使用clickhouse-backup会警告:
[root@zkm backup]# clickhouse-backup list
2023/10/31 09:48:01.841268 info clickhouse connection prepared: tcp://localhost:9000 run ping logger=clickhouse
2023/10/31 09:48:01.845838 info clickhouse connection open: tcp://localhost:9000 logger=clickhouse
2023/10/31 09:48:01.845945 info SELECT value FROM `system`.`build_options` where name='VERSION_INTEGER' logger=clickhouse
2023/10/31 09:48:01.848798 info SELECT count() is_disk_type_present FROM system.columns WHERE database='system' AND table='disks' AND name='type' logger=clickhouse
2023/10/31 09:48:01.897167 info SELECT path, any(name) AS name, any(type) AS type FROM system.disks GROUP BY path logger=clickhouse
2023/10/31 09:48:01.908907 info SELECT count() AS is_macros_exists FROM system.tables WHERE database='system' AND name='macros' SETTINGS empty_result_for_aggregation_by_empty_set=0 logger=clickhouse
2023/10/31 09:48:01.912994 info SELECT macro, substitution FROM system.macros logger=clickhouse
2023/10/31 09:48:02.103029 warn BackupList bd.Walk return error: file does not exist logger=SFTP
zkm_local 2.46KiB 31/10/2023 01:47:49 local
2023/10/31 09:48:02.104238 info clickhouse connection closed logger=clickhouse
防偷防爬。