Mariadb

MariaDB:mysql_install_db 問題

  • March 29, 2015

我只是在乾淨的 Debian 7 機器上安裝 MariaDB。當我想執行時mysql_install_db,我得到了這組錯誤:

150329 18:01:27 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150329 18:01:27 [Note] InnoDB: The InnoDB memory heap is disabled
150329 18:01:27 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150329 18:01:27 [Note] InnoDB: Memory barrier is not used
150329 18:01:27 [Note] InnoDB: Compressed tables use zlib 1.2.7
150329 18:01:27 [Note] InnoDB: Using Linux native AIO
150329 18:01:27 [Note] InnoDB: Using CPU crc32 instructions
150329 18:01:27 [Note] InnoDB: Initializing buffer pool, size = 256.0M
150329 18:01:27 [Note] InnoDB: Completed initialization of buffer pool
150329 18:01:27 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
150329 18:01:27 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
150329 18:01:27 [Note] InnoDB: Retrying to lock the first data file
150329 18:01:28 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
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.6/en/operating-system-error-codes.html
150329 18:03:07 [ERROR] InnoDB: Can't open './ibdata1'
150329 18:03:07 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
150329 18:03:07 [ERROR] Plugin 'InnoDB' init function returned error.
150329 18:03:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150329 18:03:07 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
150329 18:03:38 [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 '/var/lib/mysql/aria_log_control'
150329 18:03:38 [ERROR] Plugin 'Aria' init function returned error.
150329 18:03:38 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
150329 18:03:38 [ERROR] Unknown/unsupported storage engine: InnoDB
150329 18:03:38 [ERROR] Aborting

150329 18:03:38 [Note] /usr/sbin/mysqld: Shutdown complete

我查看了錯誤 11,根據 MySQL 5.6 文件,這意味著“EAGAIN”。我不確定為什麼不對 MariaDB 進行解釋,因為我不知道下一步該做什麼。誰幫幫我?

MariaDB 已經在執行(因為 Debian 啟動並mysql_install_db為您執行)。

我想到了兩種問題:

  1. 有另一個 mysqld 實例正在執行。

檢查與ps -ef | grep mysqld 2. 你有權限問題。您的使用者無權寫入數據庫文件。檢查./ibdata1文件的權限。

引用自:https://serverfault.com/questions/679142