multiple issues' updated_at changed without obvious activity on them
### Summary
From time to time, some issues in a project have their updated_at field "touched" without any visible activity.
### Steps to reproduce
I wish I could provide some steps. We can only witness it after the fact.
### Example Project
We use a self hosted Gitlab CE but this is happening on multiple projects.
### What is the current *bug* behavior?
When we go on the closed issues page and sort by last updated we can see that a lot of issues have been updated at the exact same time. This is all happening within a few seconds which tends to show it's something automatic. When going inside the issues the last activity show is often weeks or months before.
### What is the expected *correct* behavior?
The updated_at field should only be changed when actual activity occurs on an issue. This is especially problematic when trying to review recently closed issues.
### Relevant logs and/or screenshots
```
SELECT title, updated_at, iid, project_id, state FROM issues WHERE updated_at BETWEEN '2017-06-30 13:30:44.790628+00' AND '2017-06-30 13:40:44.790628+00' ORDER BY updated_at DESC;
title | updated_at | iid | project_id | state
-----------------------------------------------------------------------------------------------+-------------------------------+-----+------------+--------
En tant que user (..) pouvoir choisir la langue | 2017-06-30 13:34:47.645079+00 | 1 | 318 | closed
En tant que user (..) accéder au menu principal | 2017-06-30 13:34:47.62465+00 | 2 | 318 | closed
En tant qu'admin (..) traduire mon contenu | 2017-06-30 13:34:47.608227+00 | 4 | 318 | closed
En tant que user (..) accéder au footer | 2017-06-30 13:34:47.586712+00 | 5 | 318 | closed
En tant que user (..) suivre Horizon sur les réseaux sociaux | 2017-06-30 13:34:47.570287+00 | 9 | 318 | closed
En tant que user (..) accéder aux informations du groupe | 2017-06-30 13:34:47.505495+00 | 12 | 318 | closed
En tant que user (..) parcourir l'historique du groupe d'une date à une autre | 2017-06-30 13:34:46.538022+00 | 13 | 318 | closed
En tant que user (..) avoir des appels à d'autres contenus du site | 2017-06-30 13:34:46.521423+00 | 15 | 318 | closed
En tant que user (..) connaitre les coordonnées et localisation du groupe | 2017-06-30 13:34:46.504289+00 | 16 | 318 | closed
En tant que user (..) trouver les biens à vendre | 2017-06-30 13:34:46.487464+00 | 17 | 318 | closed
En tant que user (..) trouver un bien à vendre via des filtres de recherches | 2017-06-30 13:34:46.470845+00 | 18 | 318 | closed
En tant que user (..) quitter ma recherche à tout moment | 2017-06-30 13:34:46.454119+00 | 20 | 318 | closed
En tant que user (..) naviguer dans la carte des biens | 2017-06-30 13:34:46.437664+00 | 21 | 318 | closed
En tant que user (..) naviguer d'un bien à en autre | 2017-06-30 13:34:46.421027+00 | 22 | 318 | closed
En tant qu'admin (..) pouvoir gérer mes projets | 2017-06-30 13:34:46.404063+00 | 23 | 318 | closed
En tant qu'admin (..) gérer l'ordre des biens | 2017-06-30 13:34:46.387495+00 | 24 | 318 | closed
En tant que user (..) connaitre tous les détails d'un projet | 2017-06-30 13:34:46.370765+00 | 25 | 318 | closed
En tant que user (..) naviguer dans une galerie photos | 2017-06-30 13:34:46.354118+00 | 26 | 318 | closed
En tant qu'admin (..) gérer le contenu des habitations et détails par projet | 2017-06-30 13:34:46.337293+00 | 27 | 318 | closed
En tant qu'admin (..) éditer la page "activités" | 2017-06-30 13:34:46.31884+00 | 36 | 318 | closed
En tant que user (..) connaitre les activités du groupe horizon | 2017-06-30 13:34:46.302361+00 | 37 | 318 | closed
En tant qu'user (..) accéder à un abstract de références / projets futurs | 2017-06-30 13:34:46.285851+00 | 38 | 318 | closed
En tant qu'admin (..) gérer et éditer mes références / projets futurs | 2017-06-30 13:34:46.268973+00 | 39 | 318 | closed
Revoir la grille références / projets futurs | 2017-06-30 13:34:46.252462+00 | 40 | 318 | closed
En tant qu'user (..) accéder à n'importe quel page de contenu classique | 2017-06-30 13:34:46.227338+00 | 41 | 318 | closed
Intégrer retours clients styleguide / sketch | 2017-06-30 13:34:46.159387+00 | 42 | 318 | closed
En tant que user (...) faire une recherche pour les biens à louer | 2017-06-30 13:34:45.117026+00 | 44 | 318 | closed
En tant qu'admin (..) éditer la page d'accueil | 2017-06-30 13:34:45.100238+00 | 46 | 318 | closed
En tant qu'admin (..) éditer une galerie | 2017-06-30 13:34:45.083396+00 | 47 | 318 | closed
En tant qu'admin (..) gérer et créer le contenu des pages de type rich content | 2017-06-30 13:34:45.066923+00 | 48 | 318 | closed
En tant qu'user (..) envoyer un formulaire de demande d'information | 2017-06-30 13:34:45.049623+00 | 49 | 318 | closed
En tant qu'admin (..) recevoir les données des inscriptions à la newsletter | 2017-06-30 13:34:45.032776+00 | 8 | 318 | closed
En tant que user (..) avoir un nouvel onglet quand je clique sur itinéraire dans les projets | 2017-06-30 13:34:45.016443+00 | 54 | 318 | closed
En tant qu'admin (..) accéder à la page visiter (évènements) | 2017-06-30 13:34:44.999221+00 | 57 | 318 | closed
Overlay titre / image | 2017-06-30 13:34:44.974231+00 | 60 | 318 | closed
En tant qu'admin (..) éditer la page contact | 2017-06-30 13:34:44.957569+00 | 51 | 318 | closed
Manque de style header page contact | 2017-06-30 13:34:44.940516+00 | 64 | 318 | closed
En tant qu'admin (..) gérer les différentes actualités | 2017-06-30 13:34:44.790628+00 | 34 | 318 | closed
(38 rows)
```
Screenshot of issue 21 show a last activity 3 months ago: https://www.dropbox.com/s/pe23280wkjnoi8m/Screenshot%202017-07-03%2012.08.26.png?dl=0
#### Results of GitLab environment info
<details>
<summary>Expand for output related to GitLab environment info</summary>
<pre>
System information
System:
Current User: git
Using RVM: no
Ruby Version: 2.3.3p222
Gem Version: 2.6.6
Bundler Version:1.13.7
Rake Version: 10.5.0
Redis Version: 3.2.5
Git Version: 2.13.0
Sidekiq Version:5.0.0
Go Version: unknown
GitLab information
Version: 9.3.0
Revision: acb7f25
Directory: /opt/gitlab/embedded/service/gitlab-rails
DB Adapter: postgresql
URL: https://git.epic.net
HTTP Clone URL: https://git.epic.net/some-group/some-project.git
SSH Clone URL: git@git.epic.net:some-group/some-project.git
Using LDAP: no
Using Omniauth: no
GitLab Shell
Version: 5.0.5
Repository storage paths:
- default: /var/opt/gitlab/git-data/repositories
Hooks: /opt/gitlab/embedded/service/gitlab-shell/hooks
Git: /opt/gitlab/embedded/bin/git
</pre>
</details>
#### Results of GitLab application Check
<details>
<summary>Expand for output related to the GitLab application check</summary>
<pre>
Checking GitLab Shell ...
GitLab Shell version >= 5.0.5 ? ... OK (5.0.5)
Repo base directory exists?
default... yes
Repo storage directories are symlinks?
default... no
Repo paths owned by git:root, or git:git?
default... yes
Repo paths access is drwxrws---?
default... yes
hooks directories in repos are links: ...
6/2 ... ok
8/3 ... ok
8/4 ... ok
9/5 ... ok
9/6 ... ok
9/7 ... ok
7/9 ... ok
11/13 ... ok
12/14 ... ok
12/15 ... ok
12/16 ... ok
13/17 ... ok
47/18 ... ok
14/19 ... ok
15/20 ... ok
7/21 ... ok
12/22 ... ok
12/23 ... ok
11/25 ... ok
8/26 ... ok
16/27 ... ok
17/28 ... ok
16/29 ... ok
18/30 ... ok
7/31 ... ok
21/33 ... ok
23/34 ... ok
47/35 ... ok
24/36 ... ok
26/37 ... ok
26/38 ... ok
47/39 ... ok
27/40 ... ok
28/41 ... ok
11/42 ... ok
12/43 ... ok
29/44 ... ok
47/45 ... ok
30/47 ... ok
31/48 ... ok
32/49 ... ok
47/50 ... ok
7/51 ... ok
1/52 ... ok
12/53 ... ok
12/54 ... ok
7/55 ... ok
13/57 ... ok
12/58 ... ok
34/59 ... ok
7/60 ... ok
35/61 ... ok
18/64 ... ok
7/65 ... ok
47/66 ... ok
25/67 ... ok
37/68 ... ok
38/69 ... ok
7/70 ... ok
12/71 ... ok
39/72 ... ok
12/73 ... ok
47/74 ... ok
12/75 ... ok
41/76 ... ok
42/77 ... ok
13/78 ... ok
8/79 ... ok
8/80 ... ok
43/81 ... ok
44/82 ... ok
45/83 ... ok
41/84 ... ok
46/85 ... ok
47/86 ... ok
13/87 ... ok
12/88 ... ok
7/90 ... ok
7/91 ... ok
29/93 ... ok
8/95 ... ok
7/96 ... ok
49/97 ... ok
50/98 ... ok
8/99 ... ok
7/100 ... ok
12/101 ... ok
51/103 ... ok
7/104 ... ok
54/105 ... ok
51/106 ... ok
51/107 ... ok
14/108 ... ok
11/109 ... ok
11/110 ... ok
27/112 ... ok
47/114 ... ok
58/115 ... ok
59/116 ... ok
42/118 ... ok
61/119 ... ok
62/120 ... ok
63/121 ... ok
11/122 ... ok
65/123 ... ok
11/124 ... ok
66/126 ... ok
47/127 ... ok
68/129 ... ok
69/130 ... ok
71/131 ... ok
30/132 ... ok
13/133 ... ok
47/134 ... ok
43/135 ... ok
43/136 ... ok
43/137 ... ok
43/138 ... ok
43/139 ... ok
43/140 ... ok
43/141 ... ok
21/142 ... ok
75/143 ... ok
76/144 ... ok
51/145 ... ok
51/146 ... ok
71/147 ... ok
77/148 ... ok
7/149 ... ok
77/150 ... ok
78/151 ... ok
80/152 ... ok
80/153 ... ok
81/155 ... ok
83/156 ... ok
71/157 ... ok
7/158 ... ok
85/159 ... ok
7/161 ... ok
49/163 ... ok
44/164 ... ok
7/165 ... ok
51/166 ... ok
7/167 ... ok
92/168 ... ok
51/169 ... ok
93/170 ... ok
51/171 ... repository is empty
7/172 ... ok
43/174 ... ok
43/175 ... ok
7/177 ... ok
95/178 ... ok
19/179 ... ok
96/180 ... ok
97/182 ... ok
7/183 ... ok
99/184 ... ok
7/185 ... ok
101/186 ... ok
100/187 ... ok
103/188 ... ok
105/189 ... ok
1/190 ... ok
108/191 ... ok
100/192 ... ok
43/193 ... ok
43/194 ... ok
100/198 ... ok
71/199 ... ok
96/200 ... ok
43/201 ... ok
7/202 ... ok
113/203 ... ok
71/204 ... ok
114/205 ... ok
114/206 ... ok
114/207 ... repository is empty
114/208 ... repository is empty
78/209 ... ok
93/210 ... ok
93/211 ... ok
100/212 ... ok
11/213 ... ok
97/214 ... ok
100/215 ... ok
2/216 ... ok
87/219 ... ok
43/220 ... ok
118/223 ... ok
43/224 ... ok
43/226 ... ok
119/228 ... ok
156/231 ... ok
43/232 ... ok
87/233 ... ok
119/235 ... ok
122/237 ... ok
24/238 ... ok
80/239 ... ok
51/240 ... ok
123/241 ... ok
2/242 ... ok
71/245 ... ok
2/246 ... ok
2/247 ... ok
2/248 ... ok
125/249 ... ok
125/251 ... ok
125/252 ... ok
125/253 ... ok
125/254 ... ok
125/255 ... ok
156/256 ... ok
100/257 ... ok
126/258 ... ok
126/259 ... ok
123/260 ... ok
156/261 ... ok
156/262 ... ok
127/264 ... ok
128/265 ... ok
128/266 ... ok
128/267 ... ok
11/268 ... ok
7/269 ... ok
7/270 ... ok
99/271 ... ok
130/273 ... ok
130/274 ... ok
131/275 ... ok
132/276 ... ok
131/277 ... ok
131/278 ... ok
131/279 ... ok
131/280 ... ok
131/281 ... ok
131/282 ... ok
131/283 ... ok
131/284 ... ok
131/285 ... ok
131/286 ... ok
11/287 ... ok
131/289 ... ok
131/290 ... ok
131/292 ... repository is empty
132/293 ... ok
7/296 ... ok
51/297 ... ok
156/298 ... ok
119/299 ... ok
126/300 ... ok
121/301 ... ok
121/302 ... ok
121/303 ... ok
121/304 ... ok
2/305 ... ok
136/306 ... ok
138/307 ... ok
100/308 ... ok
119/309 ... repository is empty
128/310 ... ok
122/311 ... ok
140/312 ... ok
141/313 ... ok
141/314 ... ok
141/315 ... ok
142/316 ... ok
143/317 ... ok
23/318 ... ok
11/320 ... ok
145/321 ... repository is empty
100/322 ... ok
100/324 ... ok
134/325 ... ok
61/327 ... ok
149/328 ... ok
7/329 ... ok
156/330 ... ok
128/331 ... ok
71/333 ... ok
128/334 ... ok
128/335 ... ok
128/336 ... ok
126/337 ... ok
1/338 ... repository is empty
7/340 ... ok
119/342 ... ok
133/343 ... ok
2/344 ... ok
2/345 ... ok
2/346 ... ok
134/347 ... ok
7/348 ... ok
24/349 ... ok
153/350 ... ok
43/351 ... ok
1/352 ... ok
7/354 ... ok
19/355 ... ok
154/356 ... ok
155/357 ... ok
157/359 ... ok
156/360 ... ok
2/361 ... repository is empty
156/362 ... ok
153/363 ... ok
113/364 ... ok
157/365 ... ok
157/366 ... ok
19/367 ... ok
87/368 ... ok
11/369 ... ok
156/370 ... ok
159/371 ... repository is empty
71/372 ... ok
84/373 ... ok
23/374 ... ok
149/375 ... ok
153/376 ... ok
19/377 ... ok
161/378 ... ok
96/379 ... ok
92/380 ... ok
128/381 ... ok
128/382 ... ok
128/383 ... ok
128/384 ... ok
119/385 ... ok
161/386 ... ok
164/387 ... repository is empty
Running /opt/gitlab/embedded/service/gitlab-shell/bin/check
Check GitLab API access: OK
Access to /var/opt/gitlab/.ssh/authorized_keys: OK
Send ping to redis server: OK
gitlab-shell self-check successful
Checking GitLab Shell ... Finished
Checking Sidekiq ...
Running? ... yes
Number of Sidekiq processes ... 1
Checking Sidekiq ... Finished
Checking Reply by email ...
IMAP server credentials are correct? ... yes
Init.d configured correctly? ... skipped (omnibus-gitlab has no init script)
MailRoom running? ... can't check because of previous errors
Checking Reply by email ... Finished
Checking LDAP ...
LDAP is disabled in config/gitlab.yml
Checking LDAP ... Finished
Checking GitLab ...
Git configured correctly? ... yes
Database config exists? ... yes
All migrations up? ... yes
Database contains orphaned GroupMembers? ... no
GitLab config exists? ... yes
GitLab config up to date? ... yes
Log directory writable? ... yes
Tmp directory writable? ... yes
Uploads directory exists? ... yes
Uploads directory has correct permissions? ... yes
Uploads directory tmp has correct permissions? ... no
Try fixing it:
sudo chown -R git /var/opt/gitlab/gitlab-rails/uploads
sudo find /var/opt/gitlab/gitlab-rails/uploads -type f -exec chmod 0644 {} \;
sudo find /var/opt/gitlab/gitlab-rails/uploads -type d -not -path /var/opt/gitlab/gitlab-rails/uploads -exec chmod 0700 {} \;
For more information see:
doc/install/installation.md in section "GitLab"
Please fix the error above and rerun the checks.
Init script exists? ... skipped (omnibus-gitlab has no init script)
Init script up-to-date? ... skipped (omnibus-gitlab has no init script)
Projects have namespace: ...
6/2 ... yes
8/3 ... yes
8/4 ... yes
9/5 ... yes
9/6 ... yes
9/7 ... yes
7/9 ... yes
11/13 ... yes
12/14 ... yes
12/15 ... yes
12/16 ... yes
13/17 ... yes
47/18 ... yes
14/19 ... yes
15/20 ... yes
7/21 ... yes
12/22 ... yes
12/23 ... yes
11/25 ... yes
8/26 ... yes
16/27 ... yes
17/28 ... yes
16/29 ... yes
18/30 ... yes
7/31 ... yes
21/33 ... yes
23/34 ... yes
47/35 ... yes
24/36 ... yes
26/37 ... yes
26/38 ... yes
47/39 ... yes
27/40 ... yes
28/41 ... yes
11/42 ... yes
12/43 ... yes
29/44 ... yes
47/45 ... yes
30/47 ... yes
31/48 ... yes
32/49 ... yes
47/50 ... yes
7/51 ... yes
1/52 ... yes
12/53 ... yes
12/54 ... yes
7/55 ... yes
13/57 ... yes
12/58 ... yes
34/59 ... yes
7/60 ... yes
35/61 ... yes
18/64 ... yes
7/65 ... yes
47/66 ... yes
25/67 ... yes
37/68 ... yes
38/69 ... yes
7/70 ... yes
12/71 ... yes
39/72 ... yes
12/73 ... yes
47/74 ... yes
12/75 ... yes
41/76 ... yes
42/77 ... yes
13/78 ... yes
8/79 ... yes
8/80 ... yes
43/81 ... yes
44/82 ... yes
45/83 ... yes
41/84 ... yes
46/85 ... yes
47/86 ... yes
13/87 ... yes
12/88 ... yes
7/90 ... yes
7/91 ... yes
29/93 ... yes
8/95 ... yes
7/96 ... yes
49/97 ... yes
50/98 ... yes
8/99 ... yes
7/100 ... yes
12/101 ... yes
51/103 ... yes
7/104 ... yes
54/105 ... yes
51/106 ... yes
51/107 ... yes
14/108 ... yes
11/109 ... yes
11/110 ... yes
27/112 ... yes
47/114 ... yes
58/115 ... yes
59/116 ... yes
42/118 ... yes
61/119 ... yes
62/120 ... yes
63/121 ... yes
11/122 ... yes
65/123 ... yes
11/124 ... yes
66/126 ... yes
47/127 ... yes
68/129 ... yes
69/130 ... yes
71/131 ... yes
30/132 ... yes
13/133 ... yes
47/134 ... yes
43/135 ... yes
43/136 ... yes
43/137 ... yes
43/138 ... yes
43/139 ... yes
43/140 ... yes
43/141 ... yes
21/142 ... yes
75/143 ... yes
76/144 ... yes
51/145 ... yes
51/146 ... yes
71/147 ... yes
77/148 ... yes
7/149 ... yes
77/150 ... yes
78/151 ... yes
80/152 ... yes
80/153 ... yes
81/155 ... yes
83/156 ... yes
71/157 ... yes
7/158 ... yes
85/159 ... yes
7/161 ... yes
49/163 ... yes
44/164 ... yes
7/165 ... yes
51/166 ... yes
7/167 ... yes
92/168 ... yes
51/169 ... yes
93/170 ... yes
51/171 ... yes
7/172 ... yes
43/174 ... yes
43/175 ... yes
7/177 ... yes
95/178 ... yes
19/179 ... yes
96/180 ... yes
97/182 ... yes
7/183 ... yes
99/184 ... yes
7/185 ... yes
101/186 ... yes
100/187 ... yes
103/188 ... yes
105/189 ... yes
1/190 ... yes
108/191 ... yes
100/192 ... yes
43/193 ... yes
43/194 ... yes
100/198 ... yes
71/199 ... yes
96/200 ... yes
43/201 ... yes
7/202 ... yes
113/203 ... yes
71/204 ... yes
114/205 ... yes
114/206 ... yes
114/207 ... yes
114/208 ... yes
78/209 ... yes
93/210 ... yes
93/211 ... yes
100/212 ... yes
11/213 ... yes
97/214 ... yes
100/215 ... yes
2/216 ... yes
87/219 ... yes
43/220 ... yes
118/223 ... yes
43/224 ... yes
43/226 ... yes
119/228 ... yes
156/231 ... yes
43/232 ... yes
87/233 ... yes
119/235 ... yes
122/237 ... yes
24/238 ... yes
80/239 ... yes
51/240 ... yes
123/241 ... yes
2/242 ... yes
71/245 ... yes
2/246 ... yes
2/247 ... yes
2/248 ... yes
125/249 ... yes
125/251 ... yes
125/252 ... yes
125/253 ... yes
125/254 ... yes
125/255 ... yes
156/256 ... yes
100/257 ... yes
126/258 ... yes
126/259 ... yes
123/260 ... yes
156/261 ... yes
156/262 ... yes
127/264 ... yes
128/265 ... yes
128/266 ... yes
128/267 ... yes
11/268 ... yes
7/269 ... yes
7/270 ... yes
99/271 ... yes
130/273 ... yes
130/274 ... yes
131/275 ... yes
132/276 ... yes
131/277 ... yes
131/278 ... yes
131/279 ... yes
131/280 ... yes
131/281 ... yes
131/282 ... yes
131/283 ... yes
131/284 ... yes
131/285 ... yes
131/286 ... yes
11/287 ... yes
131/289 ... yes
131/290 ... yes
131/292 ... yes
132/293 ... yes
7/296 ... yes
51/297 ... yes
156/298 ... yes
119/299 ... yes
126/300 ... yes
121/301 ... yes
121/302 ... yes
121/303 ... yes
121/304 ... yes
2/305 ... yes
136/306 ... yes
138/307 ... yes
100/308 ... yes
119/309 ... yes
128/310 ... yes
122/311 ... yes
140/312 ... yes
141/313 ... yes
141/314 ... yes
141/315 ... yes
142/316 ... yes
143/317 ... yes
23/318 ... yes
11/320 ... yes
145/321 ... yes
100/322 ... yes
100/324 ... yes
134/325 ... yes
61/327 ... yes
149/328 ... yes
7/329 ... yes
156/330 ... yes
128/331 ... yes
71/333 ... yes
128/334 ... yes
128/335 ... yes
128/336 ... yes
126/337 ... yes
1/338 ... yes
7/340 ... yes
119/342 ... yes
133/343 ... yes
2/344 ... yes
2/345 ... yes
2/346 ... yes
134/347 ... yes
7/348 ... yes
24/349 ... yes
153/350 ... yes
43/351 ... yes
1/352 ... yes
7/354 ... yes
19/355 ... yes
154/356 ... yes
155/357 ... yes
157/359 ... yes
156/360 ... yes
2/361 ... yes
156/362 ... yes
153/363 ... yes
113/364 ... yes
157/365 ... yes
157/366 ... yes
19/367 ... yes
87/368 ... yes
11/369 ... yes
156/370 ... yes
159/371 ... yes
71/372 ... yes
84/373 ... yes
23/374 ... yes
149/375 ... yes
153/376 ... yes
19/377 ... yes
161/378 ... yes
96/379 ... yes
92/380 ... yes
128/381 ... yes
128/382 ... yes
128/383 ... yes
128/384 ... yes
119/385 ... yes
161/386 ... yes
164/387 ... yes
Redis version >= 2.8.0? ... yes
Ruby version >= 2.3.3 ? ... yes (2.3.3)
Git version >= 2.7.3 ? ... yes (2.13.0)
Active users: ... 39
Checking GitLab ... Finished
</pre>
</details>
issue