Bug #35913 Failed ALTER table leaves orphaned temporary files
Submitted: 8 Apr 2008 20:43 Modified: 15 May 2010 9:00
Reporter: Philip Stoev Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: simpler_testcase_needed

[8 Apr 2008 20:43] Philip Stoev 
Description:
When executing a workload which contains ALTER, the ALTER may fail as follows:

 1025: Error on rename of './test/inter2_log' to './test/#sql2-e6c-797' (errno: 121)

Which results in .par files being accumulated in the database data directory.

How to repeat:
A test case will hopefully follow shortly.
[15 Jul 2008 14:00] Philip Stoev 
This bug involves multiple concurrent alters.
[26 Sep 2008 14:30] John Embretsen 
See also

Bug #39670 - Error on rename (errno: 121) from ALTER TABLE ADD KEY in concurrent test (Falcon)
[30 Sep 2009 8:48] Mattias Jonsson 
This seems like a duplicate of bug#47343, where a repeatable test case exists.
[15 May 2010 9:00] Philip Stoev 
In the absence of a better idea, setting as duplicate of bug #47343 .