[SOLVED]Problem upgrading from mysql to mariadb

sprinf · 2013-08-24 14:51:27

I followed the wiki https://wiki.archlinux.org/index.php/Ma … to_MariaDB but when i reached step 3, that is

systemctl start mysqld

I got the error message

Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details.

when i did

systemctl status mysqld.service

I got

mysqld.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled)
   Active: activating (start-post) (Result: exit-code) since Sat 2013-08-24 15:52:43 WAT; 11s ago
  Process: 27622 ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
  Control: 27623 (mysqld-post)
   CGroup: name=systemd:/system/mysqld.service
           └─control
             ├─27623 /bin/sh /usr/bin/mysqld-post
             └─27766 sleep 1

Aug 24 15:52:43 BigIdeaz mysqld[27622]: 130824 15:52:43 InnoDB: Initializing buffer pool, size = 128.0M
Aug 24 15:52:43 BigIdeaz mysqld[27622]: 130824 15:52:43 InnoDB: Completed initialization of buffer pool
Aug 24 15:52:43 BigIdeaz mysqld[27622]: InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
Aug 24 15:52:43 BigIdeaz mysqld[27622]: InnoDB: than specified in the .cnf file 0 5242880 bytes!
Aug 24 15:52:43 BigIdeaz mysqld[27622]: 130824 15:52:43 [ERROR] Plugin 'InnoDB' init function returned error.
Aug 24 15:52:43 BigIdeaz mysqld[27622]: 130824 15:52:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Aug 24 15:52:44 BigIdeaz mysqld[27622]: 130824 15:52:44 [ERROR] Unknown/unsupported storage engine: InnoDB
Aug 24 15:52:44 BigIdeaz mysqld[27622]: 130824 15:52:44 [ERROR] Aborting
Aug 24 15:52:44 BigIdeaz mysqld[27622]: 130824 15:52:44 [Note] /usr/bin/mysqld: Shutdown complete
Aug 24 15:52:44 BigIdeaz systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE

when i did

journalctl -xn

I got

-- Logs begin at Wed 2013-04-03 20:23:51 WAT, end at Sat 2013-08-24 15:53:12 WAT. --
Aug 24 15:52:43 BigIdeaz mysqld[27622]: 130824 15:52:43 [ERROR] Plugin 'InnoDB' init function returned error.
Aug 24 15:52:43 BigIdeaz mysqld[27622]: 130824 15:52:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Aug 24 15:52:44 BigIdeaz mysqld[27622]: 130824 15:52:44 [ERROR] Unknown/unsupported storage engine: InnoDB
Aug 24 15:52:44 BigIdeaz mysqld[27622]: 130824 15:52:44 [ERROR] Aborting
Aug 24 15:52:44 BigIdeaz mysqld[27622]: 130824 15:52:44 [Note] /usr/bin/mysqld: Shutdown complete
Aug 24 15:52:44 BigIdeaz systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
Aug 24 15:53:12 BigIdeaz dbus-daemon[296]: dbus[296]: [system] Activating via systemd: service name='org.freedesktop.ModemManager1' unit='dbus-org.free
Aug 24 15:53:12 BigIdeaz dbus[296]: [system] Activating via systemd: service name='org.freedesktop.ModemManager1' unit='dbus-org.freedesktop.ModemManag
Aug 24 15:53:12 BigIdeaz dbus[296]: [system] Activation via systemd failed for unit 'dbus-org.freedesktop.ModemManager1.service': Unit dbus-org.freedes
Aug 24 15:53:12 BigIdeaz dbus-daemon[296]: dbus[296]: [system] Activation via systemd failed for unit 'dbus-org.freedesktop.ModemManager1.service': Uni

I have tried Everything but no help

Last edited by sprinf (2013-08-26 06:50:15)

sprinf · 2013-08-26 06:49:48

Notice that it could be needed to remove the following files from /var/lib/mysql : ib_logfile0, ib_logfile1 and aria_log_control before starting the daemon.

I did this from the wiki and it worked Thanks for looking

Arch Linux

#1 2013-08-24 14:51:27

[SOLVED]Problem upgrading from mysql to mariadb

#2 2013-08-26 06:49:48

Re: [SOLVED]Problem upgrading from mysql to mariadb

Board footer