How to simulate "MYSQL has gone away" error?

Question

I'm running lots of cron job and once in a while there is a MYSQL has gone away error.

I've now written some code to handle the error, but how do I simulate the error on my localhost so that the code can be tested thoroughly?

Answer 1

Kill a long-running thread.

See: KILL syntax

The documentation about that error also lists different causes, so you could emulate some of them (eg: change the timeout to be very low, etc).

Answer 2

If it was on another machine you could unplug the network cable!

Answer 3

Mock the (affected method in the) Database adapter and have it raise the error. That's the usual approach when unit-testing code that has dependencies on external resources. If you are not using PHPUnit yet, this is a great opportunity to get started with it.

Further reading

• http://en.wikipedia.org/wiki/Mock_object
• http://www.phpunit.de/
• http://www.phpunit.de/manual/current/en/test-doubles.html#test-doubles.mock-objects