List:Internals« Previous MessageNext Message »
From:Davi Arnaut Date:June 23 2009 8:41pm
Subject:Re: Error of the day: ER_CANT_CREATE_FILE
View as plain text  
On 6/23/09 4:11 AM, Stewart Smith wrote:
> On Sat, Jun 13, 2009 at 10:09:13AM -0500, Paul DuBois wrote:
>>
> http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html#error_er_cant_create_file
>> :
>>
>> Error: 1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE)
>>
>> Message: Can't create file '%s' (errno: %d)
>>
>>
>> Likely cause:
>> * Server trying to create file in which it has no write permission?
>
> The never-ever-tested-but-can-still-happen ENOENT and ENOSPC.
>

As i said in a earlier mail, server raises a different error 
(ER_BAD_DB_ERROR) if errno is ENOENT. ENOSPC? sure.. specially if there 
is file system quota or disk is full.
Thread
Error of the day: ER_CANT_CREATE_FILEPaul DuBois13 Jun
  • Re: Error of the day: ER_CANT_CREATE_FILEDavi Arnaut13 Jun
    • Re: Error of the day: ER_CANT_CREATE_FILEDavi Arnaut13 Jun
    • Re: Error of the day: ER_CANT_CREATE_FILEMichael Widenius24 Jun
      • Re: Error of the day: ER_CANT_CREATE_FILEDavi Arnaut24 Jun
      • Re: Error of the day: ER_CANT_CREATE_FILEDavi Arnaut24 Jun
  • Re: Error of the day: ER_CANT_CREATE_FILEStewart Smith23 Jun
    • RE: Error of the day: ER_CANT_CREATE_FILERick James23 Jun
    • Re: Error of the day: ER_CANT_CREATE_FILEDavi Arnaut23 Jun