topic Re: mysql error Can't create/write to file in Alfresco Archive

mysql error Can't create/write to file

senthil_chinnai — Fri, 23 Feb 2007 08:58:00 GMT

Hi Alllease help, I am getting these errors suddenly. I am using MySql on Windows.Caused by: java.sql.SQLException: Can't create/write to file 'D:\Work\MySql\Data Files\#sql_149c_0.MYD' (Errcode: 17) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.M

Re: mysql error Can't create/write to file

kevinr — Fri, 23 Feb 2007 16:24:05 GMT

This looks like a MySQL issue rather than an Alfresco one:

System error: 17 = File exists

For some reason your system is trying to create a tmp file that already exists. I'd try cleaning out your tmp and any mysql tmp directories.

When i googled for the issue it seems to be one other people have had using MySQL (but not Alfresco related).

Thanks,

Kevin

Re: mysql error Can't create/write to file

andy — Fri, 23 Feb 2007 17:01:29 GMT

Hi

I would check you are using InnoDB - my memory - I think that file extension indicates you are using myISAM tables.

Regards

Andy

Re: mysql error Can't create/write to file

senthil_chinnai — Sat, 24 Feb 2007 01:24:29 GMT

Thanks Andy & Kevin. The problem is fixed now. Newer version of McAfee was protecting MySql temporary folder. I have added the temporary folder into McAfee's exclude list and it worked.

Thanks for very much for your valuable suggestions.

Senthil.

Re: mysql error Can't create/write to file

mialfresco — Thu, 15 Oct 2009 09:17:28 GMT

Hi senthil,
I'm also facing the same problem…. from a long time..
Can you provide the complete solution for this.
I'm using Alfresco labs 3.0 stable version and mysql 5.0.18
Even I tried to disable Mcafee "On Access Scan" but still facing the problem.
IS there any other solution for this? if yes please post it.

Thanks in advance.

Re: mysql error Can't create/write to file

mikeh — Thu, 15 Oct 2009 09:44:43 GMT

It's McAfee - disable the service and the problem will go away. You just need to exclude the MySQL filetypes. There's more info on the MySQL forums.

Thanks,
Mike