List:Internals« Previous MessageNext Message »
From:Davi Arnaut Date:June 13 2009 4:46pm
Subject:Re: Error of the day: ER_CANT_CREATE_FILE
View as plain text  
On 6/13/09 1:39 PM, Davi Arnaut wrote:
> Hi Paul,
>
> On 6/13/09 12:09 PM, Paul DuBois wrote:
>>
> http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html#error_er_cant_create_file:
>>
>
> BTW, this page does not list errors declared within the mysys library,
> yet the server might return some of then to a client.
>
> The list of mysys errors is declared in include/mysys_err.h and the
> messages in mysys/errors.c (there is also some bits in mysys/errors.c).
>
>> 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?
>> * What else?
>
> Currently, this error can only be thrown when copying a .frm file over
> to a new location fails. More precisely, it can only be thrown during
> the execution of a CREATE TABLE dst LIKE src statement when the server
> tries to copy the source table .frm file to the destination table .frm
> file.
>
> For example:
>
> CREATE TABLE t1 LIKE t2 yields:
>
> copy ./test/t1.frm to ./test/t2.frm
>
> CREATE TEMPORARY TABLE t1 LIKE t2 yields:
>
> copy ./test/t1.frm to /var/tmp/mysql/#sql104b_1_0.frm
>
> etc.
>

Oops, it should read:

CREATE TABLE t2 LIKE t1 and CREATE TEMPORARY TABLE t2 LIKE t1
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