Details
-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
8.1.3, 8.2.6, 8.3.5, 8.6.1, 8.7.1, 8.9.2, 8.5.10, 8.13.2, 8.20.3
-
8.01
-
4
-
Severity 3 - Minor
-
1
-
Description
Issue Summary
When archiving issues they are not removed from the Lexorank tables, this defeats the spirit of archiving an issue and has been validated as a bug by our Dev team.
Steps to Reproduce
- Spin up a new instance of Jira Software
- Create a test project with sample data
- Validate the ranking of all issues in the lexorank table:
jira855=# select * from "AO_60DB71_LEXORANK"; FIELD_ID | ID | ISSUE_ID | LOCK_HASH | LOCK_TIME | RANK | TYPE | BUCKET ----------+----+----------------------+-----------+-----------+-----------+------+-------- 10019 | 2 | 9223372036854775807 | | | 1|zzzzzz: | 2 | 1 10019 | 55 | 10222 | | | 1|hzzzzz: | 1 | 1 10019 | 54 | 10221 | | | 1|hzzzzr: | 1 | 1 10019 | 53 | 10220 | | | 1|hzzzzj: | 1 | 1 10019 | 52 | 10219 | | | 1|hzzzzb: | 1 | 1 10019 | 51 | 10218 | | | 1|hzzzz3: | 1 | 1 10019 | 50 | 10217 | | | 1|hzzzyv: | 1 | 1 10019 | 49 | 10216 | | | 1|hzzzyn: | 1 | 1 10019 | 47 | 10214 | | | 1|hzzzyf: | 1 | 1 10019 | 46 | 10213 | | | 1|hzzzy7: | 1 | 1 10019 | 44 | 10211 | | | 1|hzzzxz: | 1 | 1 10019 | 43 | 10210 | | | 1|hzzzxr: | 1 | 1 10019 | 48 | 10215 | | | 1|hzzzxj: | 1 | 1 10019 | 33 | 10200 | | | 1|hzzzxb: | 1 | 1 10019 | 42 | 10209 | | | 1|hzzzx3: | 1 | 1 10019 | 45 | 10212 | | | 1|hzzzwv: | 1 | 1 10019 | 40 | 10207 | | | 1|hzzzwn: | 1 | 1 10019 | 39 | 10206 | | | 1|hzzzwf: | 1 | 1 10019 | 37 | 10204 | | | 1|hzzzw7: | 1 | 1 10019 | 36 | 10203 | | | 1|hzzzvz: | 1 | 1 10019 | 35 | 10202 | | | 1|hzzzvr: | 1 | 1 10019 | 41 | 10208 | | | 1|hzzzvj: | 1 | 1 10019 | 38 | 10205 | | | 1|hzzzvb: | 1 | 1 10019 | 34 | 10201 | | | 1|hzzzv3: | 1 | 1 10019 | 13 | 10101 | | | 1|hzzzuv: | 1 | 1 10019 | 12 | 10100 | | | 1|hzzzun: | 1 | 1 10019 | 5 | 10002 | | | 1|hzzzuf: | 1 | 1 10019 | 4 | 10001 | | | 1|hzzzu7: | 1 | 1 10019 | 3 | 10000 | | | 1|hzzztz: | 1 | 1 10019 | 1 | -9223372036854775808 | | | 1|000000: | 0 | 1
- Archive all of the issues in the project.
- The lexorank table remains untouched and the archived issues are "abandoned"
- Perform a rebalance (table remains in the same state)
- Perform a lock and reindex (tables remains in the same state)
Expected Results
The issues that were archived should be removed from AO_60DB71_LEXORANK.
Actual Results
The AO_60DB71_LEXORANK table remains untouched.
Workaround
- Remove rows related to arhived issues from AO_60DB71_LEXORANK table manually.
Attachments
Issue Links
- causes
-
PS-70066 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...
-
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...
-
Page Loading...
-
Page Loading...
-
Page Loading...