問題

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)
  

診断

環境

• Attachment folder is recently moved

Diagnostic Steps

• Attachments exist in jira-home/data folder
• No error thrown in logs

原因

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.

ソリューション

Run the following SQL to update the table:

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.