-
Bug
-
Resolution: Fixed
-
Highest (View bug fix roadmap)
-
6.4.0.3, 7.2.6, 8.20.24, 9.4.8, 9.9.1
-
6.04
-
66
-
Severity 3 - Minor
-
161
-
-
Summary
JIRA Agile doesn't delete rank data from AO_60DB71_LEXORANK table when the Custom Field was deleted
Steps to Reproduce
- Follow KB Remove+Duplicate+LexoRank and delete duplicated Agile Rank data.
- Check AO_60DB71_LEXORANK table
select "FIELD_ID",count("FIELD_ID") from "AO_60DB71_LEXORANK" group by "FIELD_ID";
- Check AO_60DB71_LEXORANKBALANCER table
select "FIELD_ID" from "AO_60DB71_LEXORANKBALANCER";
Expected Results
Data with single FIELD_ID
select "FIELD_ID",count("FIELD_ID") from "AO_60DB71_LEXORANK" group by "FIELD_ID"; 15200 854577 select "FIELD_ID" from "AO_60DB71_LEXORANKBALANCER"; 15200
Actual Results
Data with multiple FIELD_ID:
select "FIELD_ID",count("FIELD_ID") from "AO_60DB71_LEXORANK" group by "FIELD_ID"; 15200 854577 15201 822690 select "FIELD_ID" from "AO_60DB71_LEXORANKBALANCER"; 15200 15201
Notes
Potentially fixed in JIRA Software 7.0.4.
To check current Agile custom fields:
// List Agile customfields select * from customfield where customfieldtypekey like 'com.pyxis.greenhopper.jira%'; // Default lexorank field SELECT propertyvalue FROM propertyentry LEFT JOIN propertynumber ON propertyentry.ID = propertynumber.ID WHERE property_key = 'GreenHopper.LexoRank.Default.customfield.id';
Workaround
Stop JIRA and delete data manually.
- causes
-
JSWSERVER-22000 Lexorank Cleanup Scheduler broken on Oracle databases
-
- Short Term Backlog
-
-
JSEV-3253 You do not have permission to view this issue
- depended on by
-
JSWSERVER-20910 Remove the ability to have multiple Rank Fields
- Gathering Interest
-
JSWSERVER-20911 Introduce Jira Healthcheck warning to identify multiple Rank fields
- Gathering Interest
- relates to
-
JSWSERVER-3723 Support multiple Global Rank Custom Fields
- Closed
- is blocked by
-
FLASH-3472 Loading...
- mentioned in
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
- was cloned as
-
RUM-808 Loading...
Form Name |
---|
[JSWSERVER-13098] JIRA Agile doesn't delete rank from table when the Custom Field was deleted
Remote Link | Original: This issue links to "Page (Atlassian Documentation)" [ 177702 ] |
Remote Link | New: This issue links to "Page (Confluence)" [ 991646 ] |
Remote Link | Original: This issue links to "Page (Atlassian Documentation)" [ 188358 ] |
Remote Link | Original: This issue links to "Page (Atlassian Documentation)" [ 543347 ] |
Assignee | Original: Francisco Crespo Smith [ d001924c850a ] | New: Karol Lopacinski [ klopacinski ] |
Assignee | Original: Karol Lopacinski [ klopacinski ] | New: Francisco Crespo Smith [ d001924c850a ] |
Link | New: This issue causes JSWSERVER-22000 [ JSWSERVER-22000 ] |
Resolution | New: Fixed [ 1 ] | |
Status | Original: Waiting for Release [ 12075 ] | New: Closed [ 6 ] |
UIS | Original: 160 | New: 161 |
Support reference count | Original: 65 | New: 66 |