Upgrading JIRA throws error java.sql.SQLException: Temporary file write failure
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
Summary
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
1
2
3
4
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
Solution
Workaround
Increase disk size of the /tmp directory on the database server using documentation for your specific Linux distribution
Was this helpful?