-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Low
-
Affects Version/s: 3.3.2
-
Component/s: Import / Export [Deprecated]
-
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.