Project import creates the same label twice in the same issue

Question

We recently upgraded Jira server from 6.4.14 to 7.2.9 and found the following 2 potential regressions in version 7.2.9.

problem 1: Has anyone experienced the the problem when using 'Project Import' to import a project to another jira instance that it creates the same label twice in the LABEL table in the same issue?

problem 2:  When deleting an issue from the Jira navigator(on browser), the label(s) associated to the deleted issue still remain in the table LABEL.

Andy Heinzer · Answer

Hi James,

Thanks for explaining that.   I agree that the project import should not be doing this.  However I have not found any other reported cases for this behavior.  So I created a new bug on this over at https://jira.atlassian.com/browse/JRASERVER-65870

I would recommend that you vote on and watch this issue for updates.   I do not have a time table for if/when this might be fixed.   But I would also invite you to comment on that bug there to try to help explain why this defect is a problem in your scenario, in your own words.

JamesC · Answer

Hi Andy,

I am part of data migration team reponsible for migrating data from  either Jira systme or non-Jira system into a centralized data-center Jira .  The amount of data migrated overtime is large and  would case a huge data integrity issue in the target data base if project import is creating duplicate labels.  In addition, our DBA would not allow this to happen, as it might impact whether we are allowed continue to do migration until the problem is fixed.

This does not appear to be the problem when I was using previous Jira versions (6.4.x).  It appears his might be a regression bug in Jira 7.x.

Thanks again, James

Andy Heinzer · Answer

Hi James,
I was able to repo this in my 7.4.2 instance.   You are correct that the project import does appear to be creating a duplicate entry for the labels table in the database, but there does not appear to be any duplicates in regards to the UI where we can see the issue in JIRA.

I'm still not sure why this is.   I then went through and removed that label from this issue in the UI once more.  Doing so removes both entries from the database.   So it does appear that this duplication is a result of the import, but that JIRA UI does not appear to have any problem with having that same label exist twice in that table.

Could you let me know more about why this is a problem for you?   Are you doing some external SQL reporting on the JIRA database on this table?   If so, I could then see why this is a problem.   However if not, and you are only using the JIRA UI, it's harder for me to understand why this is a problem.    It's not a requirement to explain why this is a painpoint, but it would help us to then understand how to best address this problem.

It might be we still need to create a bug report or feature request to address this.  However it might also be possible to create a SQL command we could run to remove these duplicates, but before we go down that avenue, I just want to know more about why this is a problem.

Thanks,
Andy