Results 1 to 3 of 3
  1. #1
    sandeepspatil is offline Member
    Join Date
    Jul 2007
    Posts
    5
    Rep Power
    0

    Default 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

  2. #2
    JavaBean's Avatar
    JavaBean is offline Moderator
    Join Date
    May 2007
    Posts
    1,270
    Rep Power
    9

    Default

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

  3. #3
    sandeepspatil is offline Member
    Join Date
    Jul 2007
    Posts
    5
    Rep Power
    0

    Default

    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

Similar Threads

  1. Alignment Issue...
    By chanduseec in forum JavaServer Faces (JSF)
    Replies: 1
    Last Post: 09-30-2008, 06:47 AM
  2. Replies: 1
    Last Post: 03-08-2008, 06:41 PM
  3. JFormattedTextField Issue
    By teracomp in forum AWT / Swing
    Replies: 1
    Last Post: 01-21-2008, 06:55 PM
  4. Try Catch issue
    By curtis_fraser in forum Advanced Java
    Replies: 2
    Last Post: 12-13-2007, 11:04 PM
  5. Issue
    By chaitu444 in forum New To Java
    Replies: 2
    Last Post: 11-06-2007, 07:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •