Upgrading JIRA throws error java.sql.SQLException: Temporary file write failure
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
The result of getting this error is not yet known.
Diagnosis
- Database server running Linux
- Error appears in the atlassian-jira.log after an upgrade
2018-06-18 16:20:08,187 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Could not add column "UPDATED" to table "customfieldvalue"
2018-06-18 16:20:08,188 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
ALTER TABLE customfieldvalue ADD UPDATED DECIMAL(18,0)
Error was: java.sql.SQLException: Temporary file write failure.
Cause
Disk space in the /tmp directory on the database server is low
Workaround
Increase disk size of the /tmp directory on the database server using documentation for your specific Linux distribution