|
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(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
|