mysql -无法锁定aria控制文件
mysql -无法锁定aria控制文件
提问于 2016-08-22 17:19:39
当MariaDB第一次正常工作时，我遇到了一些问题。当我不能再启动MySQL守护进程时，我才重新启动服务器。它似乎还在使用我以前的USB- be的文件路径(/media/brood)，而我已经改用了一个新的HDD (/media/seagate)。这是我在/var/log/mysql/error.log中遇到的错误：
160728 9:32:32 [ERROR] mysqld: Can't lock aria control file '/media/brood/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
160728 9:33:03 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/media/brood/mysql/aria_log_control'
160728 9:33:03 [ERROR] Plugin 'Aria' init function returned error.
160728 9:33:03 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
160728 9:33:03 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160728 9:33:03 [Note] InnoDB: The InnoDB memory heap is disabled
160728 9:33:03 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
160728 9:33:03 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
160728 9:33:03 [Note] InnoDB: Compressed tables use zlib 1.2.8
160728 9:33:03 [Note] InnoDB: Using Linux native AIO
160728 9:33:03 [Note] InnoDB: Not using CPU crc32 instructions
160728 9:33:03 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160728 9:33:03 [Note] InnoDB: Completed initialization of buffer pool
160728 9:33:03 [ERROR] InnoDB: Unable to lock ./ib_logfile0, error: 11
160728 9:33:03 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
160728 9:33:03 [ERROR] InnoDB: Unable to open './ib_logfile0'
160728 9:33:03 [ERROR] Plugin 'InnoDB' init function returned error.
160728 9:33:03 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160728 9:33:03 [Note] Plugin 'FEEDBACK' is disabled.
mysqld: Too many arguments (first extra is 'stop').
160728 9:33:03 [ERROR] Aborting
160728 9:33:03 [Note] mysqld: Shutdown complete这也可能是权限问题，也可能是文件仍然被锁定(我不知道这是如何工作的)，因为上次Raspberry Pi重新启动时，是因为有人不小心拔出了Pi的电源插头。
回答 1
Stack Overflow用户
发布于 2016-08-23 10:19:26
为什么日志包含到旧mysql数据文件夹的路径对我来说仍然是个谜。(它甚至不是以前的USB棒，为了使故事更完整，它实际上是我之前使用的USB棒！)但是问题解决了！答案实际上比我想象的要简单得多，结果是，我哥哥卸载了一些东西(他说，这是一个玩老游戏的仿真器)，当他注意到它卸载了mariadb 10.0(奇怪！)。所以我做了一个简单的sudo apt-get install mariadb-server-10.0，你猜怎么着！它解决了我的问题！
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/39085279
复制相关文章
相似问题
腾讯云开发者
