JIRA Throws an Exception due to MySQL Error 30
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
Powered by Confluence and Scroll Viewport.