- 多实例部署时遇到
io_setup() failed with EAGAIN报错
2024-10-30T14:17:28.568852+08:00 0 [System] [MY-013169] [Server] /usr/local/mysql8/bin/mysqld (mysqld 8.0.22) initializing of server in progress as process 171586
2024-10-30T14:17:28.587654+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-10-30T14:17:28.593140+08:00 1 [Warning] [MY-012582] [InnoDB] io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
2024-10-30T14:17:28.593225+08:00 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 1.
2024-10-30T14:17:29.094632+08:00 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 2.
2024-10-30T14:17:29.595951+08:00 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 3.
2024-10-30T14:17:30.097412+08:00 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 4.
2024-10-30T14:17:30.598504+08:00 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 5.
2024-10-30T14:17:31.100042+08:00 1 [ERROR] [MY-012584] [InnoDB] io_setup() failed with EAGAIN after 5 attempts.
2024-10-30T14:17:31.100657+08:00 1 [ERROR] [MY-012954] [InnoDB] Cannot initialize AIO sub-system
2024-10-30T14:17:31.100744+08:00 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
2024-10-30T14:17:31.101051+08:00 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
- 用
ulimit -a 确实下open files有没有问题
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 1029413
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 65535
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 65535
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/sys/fs/aio-max-nr
65536
vi /etc/sysctl.conf
fs.aio-max-nr=262144
sysctl -p
>> Home
