Archive for December, 2009

Strange MySQL error

Wednesday, December 2nd, 2009

While upgrading to Plesk 9.2.3 on one of my non-production servers, the Plesk upgrade process failed with the following error:

MySQL query failed: Got error -1 from storage engine

I was stumped by this error initially, since searching on the Plesk forums and Google, did not really yield any results.

I finally stumbled across a post by Derick Ng on Planet CakePHP, in which the same problem was described. Kudos to the poster for making the information available.

Bottom line is that I used the non-production server to do an InnoDB database recovery and the MySQL server was still setting the InnoDB engine into recovery mode. While the InnoDB engine is in recovery mode, you can not add data to the InnoDB tables.

Check for innodb_force_recovery in your my.cnf

vi Reference Card

Wednesday, December 2nd, 2009

This is a vi cheat sheet, showing most of the common vi functions. I found myself every now and again forgetting some of the common functions that I do not use every day. This document, which is copyrighted by its author, helped me out a few times.

Get the vi Reference Sheet.