MySQL issue: Exception while getting MetaDataInfo
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(SQLError.java:946)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
[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.java:1166)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2046)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaData.java:76)
[09 Jul 2007 14:05:35:748] at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:1920)
[09 Jul 2007 14:05:35:748] at com.adventnet.nms.store.relational.MetaDataInfo.getMetaDataInfo(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(NmsMainBE.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
