MySQL Bugs: #56288: Can't create/write to file Errcode 17

Bug #56288	Can't create/write to file Errcode 17
Submitted:	26 Aug 2010 11:56	Modified:	27 Aug 2010 15:08
Reporter:	Shital Adp	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S1 (Critical)
Version:	5.0.45-community-nt	OS:	Windows (XP SP2)
Assigned to:		CPU Architecture:	Any
Tags:	Can't create/write to file .MYI, Errcode 17

Description:
Hi,

I am using MySQL 5.0.45-community-nt for a data migration project. Source and target databases for the migration are MySQL. 
Also I am using a ETL tool for selecting data from the source and inserting it in the target DB. The script id giving following error dusring execution:

Can't create/write to file 'C:\Program Files\MySQL\MySQL Server 5.0\Data\#sql_29c_0.MYI' (Errcode: 17)

I tried using the "5.2.3-falcon-alpha-community-nt" version but still the same error. 

This error seems to be quiet common. However I am not able to get the solution. 

How to repeat:
1. select data from a table.
2. join the result of the previous select with new tables.
3. The select statement will fail with the error.  

I am using a tool to do this which writes a script and executes the queries.

INI file

Attachment: my.ini (application/octet-stream, text), 9.05 KiB.

Thank you for the bug report. Your server version is quite older, please upgrade and comment results here. Thanks in advance.

Hi,

I installed "5.2.3-falcon-alpha-community-nt" the same error occurs.

This looks to be a very common problem with MySQL. But I didnt find a single solution which could solve the problem. I searched on the net for two days but in vain.
We wish to use the 5.0.45 version however if there is no alternative than using a higher version for solving the problem then that also would help. But please let us know the specific version in which this bug is fixed or if there are any settings in the my.ini file to be done please let us know.

Thank you for the feedback.

Please try current version 5.0.91

Hi,

We tried setting the temp-pool=FALSE in my.ini (server section) ane the problem doesnt occur on 5.0.45. for the current script we are executing. 
Could you please verify whether this was the fix for this issue? or using  5.0.91 will be better although I have not tried using it yet.

Thank you for the feedback.

No, in this case upgrade would not help. We have this problem reported already: see bug #32917. I am closing this report as duplicate of bug #32917