Number of open en closed issues does not add up to total number of issues
this issue relates to:
- https://gitlab.com/gitlab-org/gitlab-ce/issues/37078#note_82491899
- https://gitlab.com/gitlab-org/gitlab-ce/issues/37078#note_92809562
- https://gitlab.com/gitlab-org/gitlab-ce/issues/37078#note_92813809
Summary
Number of closed & opened milestones do not add up to number of all-issues on group issues page (19 + 11 ≠ 27).
Steps to reproduce
I'm am not sure how this came to be on our CE-server. Simply visiting the group-milestones page reveals the problem:
output of query to milestones table
I'm not familiar with the internals of gitlab but maybe someone can deduce the problemen from the milestones table? see the output below (titles are hashed because I am not currently at liberty to show this info)
gitlabhq_production=# select id, iid, substring(md5(title), 0, 6) as title_hash, state, group_id from milestones;
id | iid | title_hash | state | group_id
----+-----+------------+--------+----------
1 | 1 | 2bd31 | closed |
3 | 1 | 63eb4 | closed |
28 | 3 | 1f15c | active | 3
14 | 2 | 1568b | active |
13 | 1 | 76691 | active |
4 | 1 | 13834 | closed |
24 | 2 | 57cba | active | 3
2 | 2 | 3fba0 | active |
32 | 4 | 834ab | active | 3
26 | 9 | a3907 | active |
33 | 10 | 1990a | active |
18 | 1 | 03850 | closed | 3
22 | 1 | cb135 | active |
29 | 5 | 3ff85 | closed |
7 | 2 | 13834 | closed |
23 | 8 | 9602b | active |
27 | 4 | dc02c | closed |
11 | 1 | 76691 | closed |
5 | 2 | 53775 | closed |
15 | 2 | 1568b | closed |
12 | 1 | cf02a | active |
19 | 7 | a7f17 | closed |
20 | 2 | a7f17 | active |
10 | 1 | cf02a | active |
6 | 3 | ddf53 | active |
8 | 4 | cf02a | active |
17 | 6 | daded | active |
34 | 8 | 1731c | active |
30 | 6 | 55c20 | active |
31 | 7 | b498d | closed |
35 | 11 | 2f333 | active |
37 | 5 | 33f1b | active | 3
38 | 3 | 4cb60 | active |
40 | 6 | 92b1c | active | 3
(34 rows)