Broken Fedora 20 MariaDB/MySQL packages

Standard

Just tried to install MariaDB and later MySQL databases on Fedora 20, but could not start the server. The log file shows:


[root@localhost ~]# cat /var/log/mysqld.log
140108 15:11:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140108 15:11:19 [ERROR] mysqld: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13)
140108 15:11:19 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/var/lib/mysql/aria_log_control'
140108 15:11:19 [ERROR] Plugin 'Aria' init function returned error.
140108 15:11:19 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
140108 15:11:19 InnoDB: The InnoDB memory heap is disabled
140108 15:11:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140108 15:11:19 InnoDB: Compressed tables use zlib 1.2.8
140108 15:11:19 InnoDB: Using Linux native AIO
140108 15:11:19 InnoDB: Initializing buffer pool, size = 128.0M
140108 15:11:20 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
140108 15:11:20 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
140108 15:11:20 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
140108 15:11:20 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
140108 15:11:20 InnoDB: Waiting for the background threads to start
140108 15:11:21 Percona XtraDB (http://www.percona.com) 5.5.34-MariaDB-31.1 started; log sequence number 0
140108 15:11:21 [Note] Plugin 'FEEDBACK' is disabled.
140108 15:11:21 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140108 15:11:21 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140108 15:11:21 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
140108 15:11:21 [ERROR] Aborting

140108 15:11:21 InnoDB: Starting shutdown...
140108 15:11:22 InnoDB: Shutdown completed; log sequence number 1597945
140108 15:11:22 [Note] /usr/libexec/mysqld: Shutdown complete

140108 15:11:22 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
[root@localhost ~]#

The problem is mysql_install_db script in packages mariadb-server-5.5.34-2.fc20 and community-mysql-server-5.5.35-1.fc20 does not set up proper permissions on server data directory. Run following command under root to fix it:

chown -R mysql:mysql /var/lib/mysql

Leave a Reply

Your email address will not be published. Required fields are marked *