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