Attachment thumbnails not displaying after Jira migration
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
After performing a migration and manually moving the JIRA home folder to import attachments:
The thumbnails for attachments are broken (Selection_005.png, Selection_006.png)
Newly created attachments have its thumbnail shown correctly (Selection_007.png)
Diagnosis
Environment
Attachment folder is recently moved
Diagnostic Steps
Attachments exist in jira-home/data folder
No error thrown in logs
Cause
This is due to the thumnailable flag in the database being incorrectly set. It needs to be reset from '0' to '1' for attachments that have MIME type set to image.
Solution
Resolution
Run the following SQL to update the table:
1
UPDATE fileattachment set thumbnailable = null where thumbnailable = 0;When loading an issue in Jira, the value in the database is checked. If Jira finds a NULL value: it will load the file from disk, check its MIME type to see if the linked attachment is an image file and based on that, set the thumbnailable flag to '0' or '1' for all future requests. A value of 1 indicates that the attachment is an image and a thumbnail can be shown. A value of 0 indicates that the file is not an image and therefore a thumbnail can't be displayed.
Was this helpful?