MySQL启动报错问题InnoDB:Unable to lock/ibdata1 error
16lz
2021-12-22
在OS X环境下MySQL启动时报错:
016-03-03T00:02:30.483037Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 352016-03-03T00:02:30.483100Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
ps -ef |grep mysqld74 7711 1 0 8:04上午 ?? 0:00.34 /usr/local/mysql/bin/mysqld --user=_mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=/usr/local/mysql/data/mysqld.local.err --pid-file=/usr/local/mysql/data/mysqld.local.pid
sudo kill -9 7711
ps -ef |grep mysqld74 7759 1 0 8:10上午 ?? 0:00.29 /usr/local/mysql/bin/mysqld --user=_mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=/usr/local/mysql/data/mysqld.local.err --pid-file=/usr/local/mysql/data/mysqld.local.pid
lsof -c mysqld
Mac OS X, lsof only shows your own processes unless running as root with sudo
于是再次运行:
sudo lsof -c mysqldCOMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAMEmysqld 8655 _mysql cwd DIR 1,4 544 3090250 /usr/local/mysql/datamysqld 8655 _mysql txt REG 1,4 31130736 3089789 /usr/local/mysql/bin/mysqld
sudo launchctl unload -w /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
ps -ef |grep mysqld
sudo launchctl load -w /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
LAUNCHD是什么?
launchd是Mac OS X从10.4开始引入,用于用于初始化系统环境的关键进程,它是内核装载成功之后在OS环境下启动的第一个进程。传统的Linux会使用/etc/rc.*或者/etc/init来管理开机要启动的服务,而在OS X中就是使用launchd来管理。采用这种方式来配置启动项很简单,只需要一个plist文件。/Library/LaunchDaemons目录下的plist文件都是系统启动后立即启动进程。使用launchctl命令加载/卸载plist文件,加载配置文件后,程序启动,卸载配置文件后程序关闭。
卸载配置文件后又尝试直接用mysqld命令来启动mysql进程试试:
/usr/local/mysql/bin/mysqld2016-03-03T01:35:50.359258Z 0 [ERROR] InnoDB: ./ib_logfile0 can't be opened in read-write mode.2016-03-03T01:35:50.359283Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2016-03-03T01:35:50.670517Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2016-03-03T01:35:50.670555Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2016-03-03T01:35:50.670568Z 0 [ERROR] Failed to initialize plugins.2016-03-03T01:35:50.670574Z 0 [ERROR] Aborting
2016-03-03T01:38:10.977313Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!2016-03-03T01:38:10.977339Z 0 [ERROR] Aborting2016-03-03T01:38:10.977350Z 0 [Note] Binlog end2016-03-03T01:38:10.977410Z 0 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
更多相关文章
- Linux下MYSQL 5.7 找回root密码的问题(亲测可用)
- Android(安卓)10 定位问题,获取NMEA(支持5.0~10.0)
- mybatisplus的坑 insert标签insert into select无参数问题的解决
- 关于Android(安卓)Studio3.2新建项目Android(安卓)resource link
- Android(安卓)报错:Caused by: android.os.FileUriExposedExcepti
- Android软键盘适配问题
- Ionic 运行报错No resource identifier found for attribute 'ap
- SlidingMenu和ActionBarSherlock结合做出出色的App布局,Facebook
- android解决坚屏拍照和保存图片旋转90度的问题,并兼容4.0