InnoDB: Error in opening ./ibdata1 问题重现

    今日由于需要重启线上服务器,当SA跟我说他那边已经OK 的时候,我便开始重启mysql:/usr/local/mysql/bin/mysqld_safe --user=mysql & 

但是看了下mysql错误日志,却发现如下错误:

InnoDB: Error in opening ./ibdata1
120412 13:38:09  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
120412 13:38:09 InnoDB: Could not open or create data files.
120412 13:38:09 InnoDB: If you tried to add new data files, and it failed here,
120412 13:38:09 InnoDB: you should now edit innodb_data_file_path in my.cnf back
120412 13:38:09 InnoDB: to what it was, and remove the new ibdata files InnoDB created
120412 13:38:09 InnoDB: in this failed attempt. InnoDB only wrote those files full of
120412 13:38:09 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
120412 13:38:09 InnoDB: remove old data files which contain your precious data!
120412 13:38:09 [ERROR] Plugin 'InnoDB' init function returned error.
120412 13:38:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120412 13:38:09 [ERROR] Unknown/unsupported storage engine: innodb
120412 13:38:09 [ERROR] Aborting

120412 13:38:09 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

120412 13:38:09 mysqld_safe mysqld from pid file /data/mysql_db/mysql-b.pid ended


连接mysql报错如下:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

不过可以通过IP链接

mysql -uroot -p127.0.0.1 


经过反复试验。终于找到了问题所在,原因是在重启系统的时候已经默认启动了mysql,我又启动了一次。



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值