mysql failed with EAGAIN after 5 attempts.

3 篇文章 0 订阅
3 篇文章 0 订阅

mysql遇到 failed with EAGAIN after 5 attempts.错误

2020-09-23T19:50:17.468993Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this opved in a future release.
2020-09-23T19:50:17.469099Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 40
2020-09-23T19:50:17.578377Z 1 [Warning] [MY-012582] [InnoDB] io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
2020-09-23T19:50:17.622065Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 1.
2020-09-23T19:50:18.122210Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 2.
2020-09-23T19:50:18.622360Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 3.
2020-09-23T19:50:19.122499Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 4.
2020-09-23T19:50:19.622673Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 5.
2020-09-23T19:50:20.122838Z 1 [ERROR] [MY-012584] [InnoDB] io_setup() failed with EAGAIN after 5 attempts.
2020-09-23T19:50:20.122867Z 1 [ERROR] [MY-012954] [InnoDB] Cannot initialize AIO sub-system
2020-09-23T19:50:20.122892Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before tryi
2020-09-23T19:50:20.123066Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-23T19:50:20.123078Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2020-09-23T19:50:20.123280Z 0 [ERROR] [MY-010119] [Server] Aborting
......

分析原因
由于内存不足导致,可以增加内存,但是并不是好的解决方式

最终解决
my.cnf 中增加以下配置

[mysqld]
innodb_use_native_aio=0
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值