When MariaDB gets all tsundere
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!