MySQL Bugs: #50810: support crash recovery tests in mtr -- restart mysqld

Bug #50810	support crash recovery tests in mtr -- restart mysqld
Submitted:	2 Feb 2010 1:11	Modified:	7 Feb 2010 5:50
Reporter:	Mark Callaghan	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S4 (Feature request)
Version:	5.0,5.1	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	crash, mtr, recovery

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
We can't write crash recovery tests for mysqld (innodb) today because mtr does not restart mysqld processes that have been killed.

There might be a worklog for this:
http://forge.mysql.com/worklog/task.php?id=4137

How to repeat:
write a test that kills a mysqld process using DBUG_EXECUTE_IF. It won't get restarted.

Suggested fix:
Modify the perl scripts

Hum, mtr does support restarting a forcibly crashed server. For example, take a look at myisam_crash_before_flush_keys.test in 5.1 (no such thing on 5.0 though).