List:General Discussion« Previous MessageNext Message »
From:Mark Uhrmacher Date:February 18 2005 10:35pm
Subject:Re: ERROR 25 (HY000): Can't create symlink
View as plain text  
Hi Andy,

I see that.  Unfortunately, I have no idea why mysql is trying to create 
a symlink to a symlink it just created.  Does anyone have any idea why 
mysql would do that?

Thanks,

Mark


Ady Wicaksono wrote:

> Hi Mark,
>
> There's perror to check what happen, so when you have Error 17 you 
> check from your bash shell like this
>
> # perror 17
> Error code  17:  File exists
>
> Gotcha !.... The reason is file exists :)
>
> Good luck
>
> Mark Uhrmacher wrote:
>
>> Hi all,
>>
>> I've been getting a strange error when attempting to add an index to 
>> a set tables that make up a merge table.  Here is a transcript of the 
>> session:
>>
>> mysql> alter table he_access_offline_3 add index status (status);
>> ERROR 25 (HY000): Can't create symlink './Logs/#sql-156e_48d8.MYI' 
>> pointing at '/var/lib/mysql/Logs/#sql-156e_48d8.MYI' (Error 17)
>> mysql> alter table he_access_offline_2 add index status (status);
>> ERROR 25 (HY000): Can't create symlink './Logs/#sql-156e_48d8.MYI' 
>> pointing at '/var/lib/mysql/Logs/#sql-156e_48d8.MYI' (Error 17)
>> mysql> alter table he_access_offline_1 add index status (status);
>> ERROR 25 (HY000): Can't create symlink './Logs/#sql-156e_48d8.MYI' 
>> pointing at '/var/lib/mysql/Logs/#sql-156e_48d8.MYI' (Error 17)
>>
>> What is interesting is that I could create that index on 
>> he_access_offline_4 which is also a member of the merge table (called 
>> he_access_offline).
>>
>> Doing some research with Google I found someone had a similar problem 
>> when they were using symlinks from files in mysql's datadir to the 
>> actual location of their data files.  In my case the contents of 
>> /var/lib/mysql/Logs are actual files and not symlinks.  The 
>> permissions appear to be set correctly and, in fact, I've created 
>> other indexes on these same tables using the same scheme.  I'm not 
>> sure what has changed.
>>
>> Also, restarting the server doesn't eliminate the problem.
>>
>> System Info:
>> MySQL 4.1.9 on Fedora Core 2.  I downloaded the binary from mysql.com.
>>
>> Any ideas?
>>
>> Thanks,
>>
>> Mark
>>
>>
>
>


Thread
ERROR 25 (HY000): Can't create symlinkMark Uhrmacher18 Feb
  • Re: ERROR 25 (HY000): Can't create symlinkAdy Wicaksono18 Feb
    • Re: ERROR 25 (HY000): Can't create symlinkMark Uhrmacher18 Feb
      • Re: ERROR 25 (HY000): Can't create symlinkGleb Paharenko21 Feb