MySQL error 17: Can't create/write to file

You appear to be having a problem with MySQL, not Drupal. MySQL is saying it cannot write to that directory. Are you able to query the MySQL server directly (e.g. PHPMyAdmin, or MySQL Query Browser)?

Have you tried restarting your MySQL service?

Error 17 means that MySQL is trying to create a temporary file that already exists.
So stop the MySQL service. Remove the contents from c:\windows\temp (some items may be in use, just skip those)
Start the MySQL service and you should be good to go.

Please post back your findings.

- Arie

Looks like jadoiron won't be posting any feedback so I'm setting this to fixed.

Feel free to reopen if you think that is wrong.

- Arie

It's not fixed. I understand that this is MySQL error. But how to solve it ?
My temp folder excluded from antivirus scanning, permision is set to full access for everybody, including system. And what I get is
user warning: Can't create/write to file 'W:\WEB\Temp\#sql_1304_0.MYD' (Errcode: 17) query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 170 ORDER BY v.weight, t.weight, t.name in W:\WEB\htdocs\modules\taxonomy\taxonomy.module on line 618.

After that only restart of MySQL server helps.
Any suggestions ?

You could try creating a temp directory especially for MySQL and pointing to it in my.ini
Also exclude that directory from the virusscanner to avoid locking and make sure MySQL has sufficient permissions.

Please post back how that works for you.

- Arie

Thanks ainigma32.
Only Drupal using W:/Web/Temp folder, and, as I wrote before, it is excluded from virus scan. And it present in my.ini as tmpdir=W:/web/temp

Added.
Now I have increased InnoDB log file size (from 27 M to 256 M). Looks better. No errors yet. Will see what will happend after weekend.

So, looks like this problem solved, FOR ME. No more Can't create/write errors.

Good to hear.

- Arie

Got it back.
Interesting that when this happening *.myd file's size always the same - 17872 bytes.

The problem disappear when I fixed problem with cron.

#11 @Ether, best fix. I had the same errors, tried messing with the mysql server. But it was simply I need to load cron.php (when moving servers I happen to forget to reset its hourly ping, so I guess it got backed up)

what is the best solution for this I'm also getting the same problem.

I'm getting this error. The error message is:

user warning: Can't create/write to file '/tmp/#sql_3746_0.MYD' (Errcode: 17) query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 128 ORDER BY v.weight, t.weight, t.name in /var/www/html/drupal/modules/taxonomy/taxonomy.module on line 617.

At first even issuing a 'describe' command in mysql would come back with the same "Can't create/write to file '/tmp/#sql_3746_0.MYD' (Errcode: 17)."

For example, I do this in mysql:

use mysql;
describe db;

and I get this error. Then I run this in mysql:

flush tables;

Now mysql is okay, I can do the 'describe'. I can even run the same failed query from the Drupal error message. I just type the exact same query (switching to the right database first). But browsing my site still show the same error.

I would think once the query can run in mysql, the Drupal should be okay. But drupal continue to have the error.

I have seen this error several times now. Sometime the file '/tmp/#sql_3746_0.MYD' is there. Sometime that file is not.

The problem clear up after I run cron.php.

I'm running on a Linux host. There should be file permission to the /tmp dir.

Please don't hijack an issue. Open you own issue.