clickhouse-backup list报错warn BackupList bd.Walk return error: file does not exist logger=SFTP

 

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

防偷防爬。

https://www.cnblogs.com/PiscesCanon/p/17799651.html