[SOLVED] mariadb won't start in 64-bit

[laidlaws]

Just updated my Mga2 to 64-bit. mariadb won't start. systemctl status gives:

Code: Select all

sudo systemctl status mysqld.service
mysqld.service - MySQL database server
          Loaded: loaded (/lib/systemd/system/mysqld.service; enabled)
          Active: failed (Result: exit-code) since Sun, 03 Feb 2013 18:30:44 +1100; 1min 50s ago
         Process: 8440 ExecStartPost=/usr/sbin/mysqld-wait-ready $MAINPID (code=exited, status=1/FAILURE)
         Process: 8081 ExecStart=/usr/bin/mysqld_safe --nowatch (code=exited, status=0/SUCCESS)
         Process: 8064 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS)
        Main PID: 8439 (code=exited, status=1/FAILURE)
          CGroup: name=systemd:/system/mysqld.service

Feb 03 18:30:42 dougshost.douglaidlaw.net mysqld-prepare-db-dir[8064]: touch:...
Feb 03 18:30:42 dougshost.douglaidlaw.net mysqld-prepare-db-dir[8064]: chown:...
Feb 03 18:30:42 dougshost.douglaidlaw.net mysqld-prepare-db-dir[8064]: chmod:...
Feb 03 18:30:43 dougshost.douglaidlaw.net mysqld_safe[8081]: 130203 18:30:43 ...
Feb 03 18:30:43 dougshost.douglaidlaw.net mysqld_safe[8081]: 130203 18:30:43 ...
Feb 03 18:30:43 dougshost.douglaidlaw.net mysqld_safe[8081]: /usr/bin/mysqld_.

No socket file exists, but that may be because the process isn't running?

[laidlaws]

Further info after clearing the innodb or similar tables and the mysql log:

Code: Select all

130203 22:08:53 [Note] Plugin 'PBXT' is disabled.
130203 22:08:53 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
130203 22:08:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130203 22:08:53 [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
130203 22:08:53 [ERROR] Aborting

Running mysql_upgrade fails because there is no socket file.

[laidlaws]

SOLVED: aria control file, half my databases and various other files in /var/lib/mysql were owned by user and group rtkit. As a result, the aria control file could not be read. Changed them to user and group mysql. mariadb then started first time.