【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】生产
【复现路径】做过哪些操作出现的问题
【遇到的问题:问题现象及影响】
vmware虚拟机
配置如下
global:
user: “dbadmin”
ssh_port: 37254
deploy_dir: “/data/tidb-deploy”
data_dir: “/data/tidb-data”
resource_control:
memory_limit: “8G”
server_configs:
tidb:
isolation-read.engines: [“tikv”,“tidb”,“tiflash”]
new_collations_enabled_on_first_bootstrap : true
log.slow-threshold: 3000
tikv:
readpool.storage.use-unified-pool: false
readpool.coprocessor.use-unified-pool: true
pd_servers:
- host: 10.8.35.78
- host: 10.8.35.79
- host: 10.8.35.77
tidb_servers: - host: 10.8.35.76
tikv_servers: - host: 10.8.35.78
- host: 10.8.35.79
- host: 10.8.35.77
monitoring_servers: - host: 10.8.35.78
grafana_servers:
- host: 10.8.35.78
alertmanager_servers:
- host: 10.8.35.78
【资源配置】
【附件:截图/日志/监控】
- Try to apply changes to fix failed checks
- Applying changes on 10.8.35.78 … Error
- Applying changes on 10.8.35.79 … Error
- Applying changes on 10.8.35.77 … Error
- Applying changes on 10.8.35.76 … Error
Error: executor.ssh.execute_failed: Failed to execute command over SSH for ‘dbadmin@10.8.35.78:37254’ {ssh_stderr: sysctl: cannot stat /proc/sys/net/ipv4/tcp_tw_recycle: No such file or directory
, ssh_stdout: kernel.randomize_va_space = 2
net.ipv4.tcp_mem = 94500000 915000000 927000000
net.ipv4.tcp_timestamps = 0
net.ipv4.tcp_max_orphans = 3276800
net.core.wmem_default = 8388608
net.core.rmem_default = 8388608
net.core.rmem_max = 16777216
net.core.wmem_max = 16777216
net.core.netdev_max_backlog = 262144
net.core.somaxconn = 65535
net.ipv4.tcp_fin_timeout = 30
net.ipv4.tcp_keepalive_time = 1200
net.ipv4.tcp_keepalive_intvl = 30
net.ipv4.tcp_keepalive_probes = 3
net.ipv4.tcp_rmem = 4096 87380 16777216
net.ipv4.tcp_wmem = 4096 65536 16777216
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_max_syn_backlog = 262144
net.ipv4.tcp_max_tw_buckets = 360000
net.ipv4.ip_local_port_range = 1024 65000
net.ipv4.tcp_synack_retries = 2
net.ipv4.tcp_syn_retries = 2
net.nf_conntrack_max = 2500000
net.netfilter.nf_conntrack_max = 2500000
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
kernel.ctrl-alt-del = 1
kernel.shmmax = 4156878848
kernel.shmall = 1014863
fs.file-max = 1000000
net.ipv4.tcp_syncookies = 0
, ssh_command: export LANG=C; PATH=$PATH:/bin:/sbin:/usr/bin:/usr/sbin /usr/bin/sudo -H bash -c “cp /etc/sysctl.d/99-sysctl.conf{,.bak} 2>/dev/null && sed -i ‘/net.ipv4.tcp_syncookies/d’ /etc/sysctl.d/99-sysctl.conf 2>/dev/null && echo ‘net.ipv4.tcp_syncookies=0’ >> /etc/sysctl.d/99-sysctl.conf && sysctl -p /etc/sysctl.d/99-sysctl.conf”}, cause: Process exited with status 255