com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Can't create/write to file 'C:\DOCUME~1\yclian\LOCALS~1\Temp\#sql_16f0_0.MYI' (Errcode: 13)

Atlassian JIRA | Yuen-Chi Lian [Atlassian] | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Talked with Dylan about this week ago. I have tried finding out the root of the problem but couldn't. I am receiving this error message frequently. It doesn't happen if JIRA starts on a clean DB, but fails most of the time (or miracly works after minutes of delay) on an existing JIRA db: {noformat} 2007-01-16 21:17:28,093 main ERROR [ContainerBase.[Standalone].[localhost].[/]] Exception sending context initialized event to listener instance of class com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcer com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Can't create/write to file 'C:\DOCUME~1\yclian\LOCALS~1\Temp\#sql_16f0_0.MYI' (Errcode: 13) at com.atlassian.jira.upgrade.util.UpgradeUtils.getExactColumnName(UpgradeUtils.java:222) at com.atlassian.jira.appconsistency.db.Build178SchemaCheck.isColumnInTable(Build178SchemaCheck.java:81) at com.atlassian.jira.appconsistency.db.Build178SchemaCheck.check(Build178SchemaCheck.java:71) at com.atlassian.jira.appconsistency.db.Build178SchemaCheck.isOk(Build178SchemaCheck.java:40) at com.atlassian.jira.appconsistency.db.DatabaseChecker.checkDatabase(DatabaseChecker.java:108) at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcer.contextInitialized(DatabaseCompatibilityEnforcer.java:32) {noformat} Tested on MySQL 4.x (no problem) and MySQL 5.x (mysql-essential-5.0.1x and mysql-essential-5.0.27) under Windows environment. {noformat} OS Name: Microsoft Windows XP Professional OS Version: 5.1.2600 Service Pack 2 Build 2600 OS Manufacturer: Microsoft Corporation OS Configuration: Standalone Workstation OS Build Type: Multiprocessor Free {noformat} I'm working on source dist running under IntelliJ IDEA 5.1.1#4192, do not encounter this problem at all in using the standalone version. Also, I do not have this problem in my Ubuntu box (which should be using MySQL 5.x).

    Atlassian JIRA | 1 decade ago | Yuen-Chi Lian [Atlassian]
    com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Can't create/write to file 'C:\DOCUME~1\yclian\LOCALS~1\Temp\#sql_16f0_0.MYI' (Errcode: 13)
  2. 0

    Talked with Dylan about this week ago. I have tried finding out the root of the problem but couldn't. I am receiving this error message frequently. It doesn't happen if JIRA starts on a clean DB, but fails most of the time (or miracly works after minutes of delay) on an existing JIRA db: {noformat} 2007-01-16 21:17:28,093 main ERROR [ContainerBase.[Standalone].[localhost].[/]] Exception sending context initialized event to listener instance of class com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcer com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Can't create/write to file 'C:\DOCUME~1\yclian\LOCALS~1\Temp\#sql_16f0_0.MYI' (Errcode: 13) at com.atlassian.jira.upgrade.util.UpgradeUtils.getExactColumnName(UpgradeUtils.java:222) at com.atlassian.jira.appconsistency.db.Build178SchemaCheck.isColumnInTable(Build178SchemaCheck.java:81) at com.atlassian.jira.appconsistency.db.Build178SchemaCheck.check(Build178SchemaCheck.java:71) at com.atlassian.jira.appconsistency.db.Build178SchemaCheck.isOk(Build178SchemaCheck.java:40) at com.atlassian.jira.appconsistency.db.DatabaseChecker.checkDatabase(DatabaseChecker.java:108) at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcer.contextInitialized(DatabaseCompatibilityEnforcer.java:32) {noformat} Tested on MySQL 4.x (no problem) and MySQL 5.x (mysql-essential-5.0.1x and mysql-essential-5.0.27) under Windows environment. {noformat} OS Name: Microsoft Windows XP Professional OS Version: 5.1.2600 Service Pack 2 Build 2600 OS Manufacturer: Microsoft Corporation OS Configuration: Standalone Workstation OS Build Type: Multiprocessor Free {noformat} I'm working on source dist running under IntelliJ IDEA 5.1.1#4192, do not encounter this problem at all in using the standalone version. Also, I do not have this problem in my Ubuntu box (which should be using MySQL 5.x).

    Atlassian JIRA | 1 decade ago | Yuen-Chi Lian [Atlassian]
    com.atlassian.jira.exception.DataAccessException: java.sql.SQLException: Can't create/write to file 'C:\DOCUME~1\yclian\LOCALS~1\Temp\#sql_16f0_0.MYI' (Errcode: 13)

    Root Cause Analysis

    1. com.atlassian.jira.exception.DataAccessException

      java.sql.SQLException: Can't create/write to file 'C:\DOCUME~1\yclian\LOCALS~1\Temp\#sql_16f0_0.MYI' (Errcode: 13)

      at com.atlassian.jira.upgrade.util.UpgradeUtils.getExactColumnName()
    2. com.atlassian.jira
      DatabaseCompatibilityEnforcer.contextInitialized
      1. com.atlassian.jira.upgrade.util.UpgradeUtils.getExactColumnName(UpgradeUtils.java:222)
      2. com.atlassian.jira.appconsistency.db.Build178SchemaCheck.isColumnInTable(Build178SchemaCheck.java:81)
      3. com.atlassian.jira.appconsistency.db.Build178SchemaCheck.check(Build178SchemaCheck.java:71)
      4. com.atlassian.jira.appconsistency.db.Build178SchemaCheck.isOk(Build178SchemaCheck.java:40)
      5. com.atlassian.jira.appconsistency.db.DatabaseChecker.checkDatabase(DatabaseChecker.java:108)
      6. com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcer.contextInitialized(DatabaseCompatibilityEnforcer.java:32)
      6 frames