MySQL issue: Exception while getting MetaDataInfo

[sandeepspatil]

Hi Folks,

Our application is starting MySQL internally during startup.
Sometimes, I get the following exception and MySQL doesn't start:

[09 Jul 2007 14:05:35:733] Exception while getting MetaDataInfo : Can't create/write to file 'C:\DOCUME~1\sridhar\LOCALS~1\Temp\#sql_884_0.MYI' (Errcode: 13)
[09 Jul 2007 14:05:35:733] java.sql.SQLException: Can't create/write to file 'C:\DOCUME~1\sridhar\LOCALS~1\Temp\#sql_884_0.MYI' (Errcode: 13)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:946)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2870)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 73)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1665)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.Connection.execSQL(Connection.java: 3118)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.Connection.execSQL(Connection.java: 3047)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.Statement.executeQuery(Statement.ja va:1166)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.DatabaseMetaData$2.forEach(Database MetaData.java:2046)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doFor All(DatabaseMetaData.java:76)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.DatabaseMetaData.getColumns(Databas eMetaData.java:1920)
[09 Jul 2007 14:05:35:748] at com.adventnet.nms.store.relational.MetaDataInfo.ge tMetaDataInfo(MetaDataInfo.java:355)
[09 Jul 2007 14:05:35:748] at com.adventnet.nms.store.relational.RelationalUtil. initMetaInfo(RelationalUtil.java:1251)
[09 Jul 2007 14:05:35:748] at com.adventnet.nms.store.relational.RelationalUtil. initMetaInfo(RelationalUtil.java:1240)
[09 Jul 2007 14:05:35:748] at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainB E.java:361)
[09 Jul 2007 14:05:35:748] Exception while getting MetaDataInfo : Can't create/write to file



If any of you have seen the same, please do let me know what can be the problem and how to overcome the same.

Thanks much,
Sandeep

[JavaBean]

It looks like a permission problem:

If the error file shows Errcode 13 (which means Permission denied), this means that the access privileges of the data directory or its contents was disallow from the server. Change the permissions for the involved files and directories and start the server again. If it still fails, try to make a trace file to find the problem. See the Creating Trace Files section.

Source: MySQL Troubleshooting Guide

You should check if that user has rights to write there..

[sandeepspatil]

Hi,

I do have the permission. I've logged in as admin.
There was another related mail thread that says it may be to do with Virus Scan settings on the machine:
Exception while locating Identity Manager Repository

Will try the solution provided there.

Thanks,
Sandeep