List:Internals« Previous MessageNext Message »
From:Davi Arnaut Date:June 24 2009 2:56pm
Subject:Re: Error of the day: ER_CANT_CREATE_FILE
View as plain text  
On 6/24/09 11:44 AM, Michael Widenius wrote:
> Hi!
>
>>>>>> "Davi" == Davi Arnaut<Davi.Arnaut@stripped>  writes:
>
> Davi>  Hi Paul,
> Davi>  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:
>
> Davi>  BTW, this page does not list errors declared within the mysys library,
> Davi>  yet the server might return some of then to a client.
>
> Davi>  The list of mysys errors is declared in include/mysys_err.h and the
> Davi>  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?
>
> Davi>  Currently, this error can only be thrown when copying a .frm file over
> Davi>  to a new location fails. More precisely, it can only be thrown during
> Davi>  the execution of a CREATE TABLE dst LIKE src statement when the server
> Davi>  tries to copy the source table .frm file to the destination table .frm
> file.
>
> Actually it can happen for any 'create file' event that the server
> executes.
>

[..]

Monty,

ER_CANT_CREATE_FILE is only raised in mysql_create_like_schema_frm. We 
aren't talking about equivalent errors.

davi@skynet:~/bzr/mysql-5.1$ grep -r ER_CANT_CREATE_FILE *
sql/derror.cc:    EE(EE_CANTCREATEFILE) = ER(ER_CANT_CREATE_FILE);
sql/sql_table.cc: 
my_error(ER_CANT_CREATE_FILE,MYF(0),dst_path,my_errno);
sql/share/errmsg.txt:ER_CANT_CREATE_FILE
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