Upgrading JIRA throws error java.sql.SQLException: Temporary file write failure

Still need help?

The Atlassian Community is here for you.

Ask the community

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

Last modified on Jul 9, 2018

Was this helpful?

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