-
Bug
-
Resolution: Fixed
-
Low (View bug fix roadmap)
-
3.3.2
-
3.03
-
It looks like under certain circumstances, JIRA does not delete the 'Bugzilla Import Key' changeitem when deleting a project. This results in multiple changeitems not associated with an issue:
mysql> select changeitem.*, jiraissue.pkey from changeitem, changegroup LEFT JOIN jiraissue ON changegroup.issueid=jiraissue.id WHERE jiraissue.id is null and changegroup.id=changeitem.groupid and changeitem.FIELD='Bugzilla Import Key' and oldstring=34112;
------------------------------------------------------------------------------------
ID | groupid | FIELDTYPE | FIELD | OLDVALUE | OLDSTRING | NEWVALUE | NEWSTRING | pkey |
------------------------------------------------------------------------------------
12332002 | 12323896 | jira | Bugzilla Import Key | NULL | 34112 | NULL | 12316832 | NULL |
12345158 | 12333841 | jira | Bugzilla Import Key | NULL | 34112 | NULL | 12319817 | NULL |
12351213 | 12339486 | jira | Bugzilla Import Key | NULL | 34112 | NULL | 12323128 | NULL |
12353432 | 12341632 | jira | Bugzilla Import Key | NULL | 34112 | NULL | 12324792 | NULL |
------------------------------------------------------------------------------------
4 rows in set (0.22 sec)
this confuses the Bugzilla ID search portlet, which searches then redirects to Bugzilla instead.