JIRA Throws an Exception due to MySQL Error 30

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

The following error appears in the logs when starting JIRA:

Fcom.atlassian.jira.exception.DataAccessException: java.sql.SQLException:
 Can't create/write to file '/tmp/#sql_7400_0.MYI' (Errcode: 30)
        at com.atlassian.jira.upgrade.util.UpgradeUtils.getExactColumnName(UpgradeUtils.java:180)
        at com.atlassian.jira.upgrade.util.UpgradeUtils.getJIRABuildVersionNumber(UpgradeUtils.java:258)
        at com.atlassian.jira.appconsistency.db.MinimumUpgradableVersionCheck.getDbBuildNumber(MinimumUpgradableVersionCheck.java:81)
        ...
Caused by: java.sql.SQLException: Can't create/write to file '/tmp/#sql_7400_0.MYI' (Errcode: 30)
        ...

Cause

The above error indicates that the MySQL database unable to write to the /tmp directory due to either one of the following reason:

  • The /tmp partition has run out of space and the file can't be created,
  • The mysqld process cannot write to that directory because of permission problems.

Any operation that requites a "temp file" will go into the /tmp directory by default. The name you're seeing is just some internal random name.

Resolution

  • Increase the amount of the /tmp directory
  • Clear the content of the /tmp directory
Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.