TiDB 6.5 Error Report

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb6.5报错

| username: tidb狂热爱好者

[TiDB Usage Environment] Production Environment / Test / Poc
[TiDB Version] Production
[Reproduction Path] What operations were performed to cause the issue

[Encountered Issue: Problem Phenomenon and Impact]
VMware Virtual Machine
Configuration as follows
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

[Resource Configuration]
[Attachments: Screenshots / Logs / Monitoring]

  • 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

| username: tidb狂热爱好者 | Original post link

Manually executing sudo sysctl -p on each machine resolved the issue.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.