Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Location of attachments in JIRA

Tags:

jira

Where does JIRA saves the attachments related to tickets? I want to backup only the screen-shot images and documents found on my JIRA site. Does it save it in MySQL BLOB column types?

like image 331
shantanuo Avatar asked Aug 25 '11 06:08

shantanuo


People also ask

How do I view attachments in Jira?

From service project sidebar, select Project settings > General in the Extension for Jira Service Management section. Go to the Show Attachments section.

Where are attachments stored in Confluence?

By default, Confluence stores attachments in the attachments directory within the configured Confluence home folder.


1 Answers

According to JRA-23758 (now duplicate of JRA-19873):

At current state, attachments in JIRA are stored inside attachments/project-name, in the hierarchy below:

- attachments
 |- project-name
   |- issue key

That is actually an issue:

Since attachments are associated with issue keys, this could pose a problem for those on a Linux/UNIX platform. The ext3 filesystem can only have a maximum of 32,000 subdirectories per directory. The ext4 filesystem has fixed this limitation and increase its size to 64,000 subdirectories per directory.

The problem creeps in when you have 65,000 issues per project. If this was the case, then JIRA would not be able to save any more attachments and this would be problematic.

like image 51
VonC Avatar answered Oct 06 '22 23:10

VonC