When MariaDB gets all tsundere


Shana goes HMMMMM

This is a cross–post from Anime@UTS, the University of Technology Sydney’s best (and only) anime club. Desu~

Hello club members! Over the coming days, your humble second term webmaster will be unfurling the new site design and back end. Developed with Kiri, it will be bolder and more interesting than the current theme, along with a few new features I hope will make the site more awesome for all ^_^.

As part of a behind the scenes look into the Daily Lives of Webmasters (and Webmistresses), I thought I'd share a local issue I had, and the solution so absurdly simple it'd make any other webmaster and sysadmin enter hammerspace to retrieve a weapon to beat me senseless with. Alex knows what I'm talking about.

It's not like I wanted you to start, or anything

I'd been rebuilding my local (and increasingly misnamed) LAMP stack on my MacBook Air to test prior to deployment. The world seems to be moving to MariaDB for reasons that are beyond the scope of this post, so rather than updating MySQL I figured I'd give it a shot.

The following errors in the log file said OH NO YOU DON'T:

140208 21:39:37 mysqld_safe mysqld from pid file /usr/local/var/mysql/iYuki.local.pid ended
140208 21:39:47 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
140208 21:39:47 InnoDB: The InnoDB memory heap is disabled
140208 21:39:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140208 21:39:47 InnoDB: Compressed tables use zlib 1.2.5
140208 21:39:47 InnoDB: Initializing buffer pool, size = 128.0M
140208 21:39:47 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
140208 21:39:47 [ERROR] Plugin 'InnoDB' init function returned error.
140208 21:39:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140208 21:39:47 [ERROR] Unknown/unsupported storage engine: InnoDB
140208 21:39:47 [ERROR] Aborting
140208 21:39:47 [Note] /usr/local/Cellar/mariadb/5.5.35/bin/mysqld: Shutdown complete

Well darn, I said, as I stroked my non existent beard. Frank would do that better than me.

The problem, as is perennially the case, existed between my keyboard and chair. In the process of uninstalling MySQL and installing MariaDB, I'd failed to remove MySQL's logfiles which differed in size to what MariaDB was expecting.

Removing these logfiles solved the issue. Once removed, MariaDB was able to recreate them to its taste:

% rm /usr/local/var/mysql/ib_logfile*
% echo Everybody's Heard that The Bird is The Word
% echo Desu

What does this have to with anime? Baka, it's everything! Which means, I got nothing. Happy Saturday!

Author bio and support


Ruben Schade is a technical writer and infrastructure architect in Sydney, Australia who refers to himself in the third person. Hi!

The site is powered by Hugo, FreeBSD, and OpenZFS on OrionVM, everyone’s favourite bespoke cloud infrastructure provider.

If you found this post helpful or entertaining, you can shout me a coffee or send a comment. Thanks ☺️.