Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-11943

DatabaseCompatibilityEnforcer fails with MySQL 5.x Errcode: 13

    XMLWordPrintable

Details

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      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:

      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)
      

      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.

      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
      

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

      Attachments

        1. atlassian-jira_3.7.log
          61 kB
        2. entityengine.xml
          6 kB
        3. server.xml
          1 kB

        Activity

          People

            Unassigned Unassigned
            yuenchi.lian Yuen-Chi Lian [Atlassian]
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: