TiDB系列之：部署TiDB集群常见报错解决方法_hard limit of 'nofile' for user '' is not set or t

一、部署TiDB集群

• TiDB系列之：使用TiUP部署TiDB集群最新版本，同时部署TiCDC的详细步骤

• TiDB系列之：认识TiDB数据库，使用TiUP部署TiDB集群，同时部署TiCDC的详细步骤

二、unsupported filesystem ‘ext3’

• mount point / has an unsupported filesystem ‘ext3’
• 这个错误信息的意思是挂载点“/”使用的文件系统类型是“ext3”，但是操作系统不支持该文件系统类型。
• 指定文件目录

global:
  user: "root"
  ssh_port: 22
  deploy_dir: "/data/src/tidb-deploy"
  data_dir: "/data/datum/tidb-data"
1
2
3
4
5

三、soft limit of ‘nofile’

• soft limit of ‘nofile’ for user ‘root’ is not set or too low
• hard limit of ‘nofile’ for user ‘root’ is not set or too low
• soft limit of ‘stack’ for user ‘root’ is not set or too low

解决方法：

cat << EOF >>/etc/security/limits.conf
root           soft    nofile          1000000
root           hard    nofile          1000000
root           soft    stack          32768
root           hard    stack          32768
EOF
1
2
3
4
5
6

四、THP is enabled

• THP is enabled, please disable it for best performance

解决方法：

vim /etc/rc.d/rc.local

if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi

1
2
3
4
5
6
7
8
9

五、numactl not usable

• numactl not usable, bash: numactl: command not found

解决方法：

yum -y install numactl.x86_64
1

六、net.ipv4.tcp_syncookies = 1

• net.ipv4.tcp_syncookies = 1, should be 0

解决方法：

vim /etc/sysctl.conf
net.ipv4.tcp_syncookies = 0
#使修改生效
sysctl -p
1
2
3
4

七、service irqbalance not found,

• service irqbalance not found, should be installed and started

解决方法：

解决方法：

yum -y install irqbalance

systemctl start irqbalance
systemctl enable irqbalance
1
2
3
4

八、登陆TiDB数据库

命令行方式登陆TiDB数据库

mysql -h 10.66.88.141 -P 4000 -u root -p ********
1

客户端DBeaver方式登陆TiDB数据库