java.sql.SQLException: Can't create/write to file 'D:\temp\

[mahanare]

Hi,

After installing the latest community download, i am not able to start the server. It shows error and and it is not coming up.

Here is a snippet from the exception stacktrace while starting the tomcat. It was actually throwing this error to c:\windows\temp folder, but then in changed the directory in the configuration file so it shows d:\temp. 

Please help me get rid of this error.

        … 33 more
Caused by: java.sql.SQLException: Can't create/write to file 'D:\temp\#sql_1c7c_0.MYI' (Errcode: 13)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)
        at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2471)
        at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:50)
        at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2345)
        at org.hibernate.tool.hbm2ddl.TableMetadata.initColumns(TableMetadata.java:146)
        at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:32)
        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:90)
        … 36 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[pmonks]

<disclaimer>
This is an issue with MySQL, so you will probably get more accurate information from their forums.
</disclaimer>

That said, I get this error occasionally too and in my case it appears to be caused by a problematic interaction between the virus scanner I have installed and the MySQL server.  It's infrequent enough that I just live with it, but it is somewhat annoying and I wasn't able to find any better solutions / workarounds from my (albeit limited) trawling of the MySQL forums (short of shutting off my virus scanner, which I'm unwilling to do).

If you do find out further details from MySQL it'd be great if you could post them back here!

Cheers,
Peter

[chraja]

this is a MySql problem, Excluding the Temp folder  from the MacAfee scan list solved the problem for me .

If not MacAfee , I guess there could be some other application which restricts writing this file into temp folder .

Here is the post related to the issue
http://forums.alfresco.com/en/viewtopic.php?f=4&t=5369