Date and time of the report: 2023-12-06 05:00:05.003543
Analysed period: 2020-07-01 to 2023-12-06.
Bugs considered recent: Since 2023-11-15.
DONE
71
BUG_DESCRIPTION | NUM_BRANCHES | RELEASE | MODULE | TIMESTAMP | |
---|---|---|---|---|---|
0 | Unable to install OSM in air-gapped environmet | 2 | [Master, v14.0] | DEVOPS | 2023-11-02 10:16:24 |
AGE | CURRENT | RECENT | Total |
---|---|---|---|
MODULE | |||
Bugzilla | 1 | 0 | 1 |
DEVOPS | 7 | 1 | 8 |
Documentation / Wiki | 4 | 0 | 4 |
Gerrit | 1 | 0 | 1 |
IM-NBI | 13 | 0 | 13 |
LCM | 6 | 3 | 9 |
MON | 2 | 0 | 2 |
N2VC | 1 | 0 | 1 |
OSMClient | 8 | 0 | 8 |
POL | 2 | 0 | 2 |
RO | 16 | 2 | 18 |
Robot-tests | 4 | 0 | 4 |
Total | 65 | 6 | 71 |
AGE | CURRENT | RECENT | Total |
---|---|---|---|
VALUE | |||
OPEN-UNCONFIRMED | 55 | 5 | 60 |
CONFIRMED | 8 | 0 | 8 |
IN_PROGRESS | 2 | 1 | 3 |
Total | 65 | 6 | 71 |
NOTE: To see how a boxplot representation works, you may refer to this article.
Table with distributions of ages of currently open bugs:
MODULE | count | mean | std | min | 25% | 50% | 75% | max | |
---|---|---|---|---|---|---|---|---|---|
0 | Bugzilla | 1.0 | 791.000000 | NaN | 791.0 | 791.00 | 791.0 | 791.00 | 791.0 |
1 | DEVOPS | 8.0 | 176.375000 | 138.995311 | 13.0 | 33.00 | 206.5 | 281.00 | 357.0 |
2 | Documentation / Wiki | 4.0 | 172.000000 | 10.099505 | 166.0 | 166.00 | 167.5 | 173.50 | 187.0 |
3 | Gerrit | 1.0 | 588.000000 | NaN | 588.0 | 588.00 | 588.0 | 588.00 | 588.0 |
4 | IM-NBI | 13.0 | 97.153846 | 91.328022 | 21.0 | 26.00 | 36.0 | 207.00 | 252.0 |
5 | LCM | 9.0 | 222.888889 | 238.916536 | 19.0 | 29.00 | 123.0 | 314.00 | 720.0 |
6 | MON | 2.0 | 263.000000 | 49.497475 | 228.0 | 245.50 | 263.0 | 280.50 | 298.0 |
7 | N2VC | 1.0 | 132.000000 | NaN | 132.0 | 132.00 | 132.0 | 132.00 | 132.0 |
8 | OSMClient | 8.0 | 238.250000 | 120.793507 | 138.0 | 167.50 | 180.0 | 275.75 | 431.0 |
9 | POL | 2.0 | 25.000000 | 5.656854 | 21.0 | 23.00 | 25.0 | 27.00 | 29.0 |
10 | RO | 18.0 | 215.166667 | 241.153661 | 13.0 | 29.75 | 133.5 | 331.25 | 865.0 |
11 | Robot-tests | 4.0 | 172.750000 | 9.500000 | 168.0 | 168.00 | 168.0 | 172.75 | 187.0 |
Four types of bug age outliers are identified:
Recommendations file does not exist.
AGE | 1. Open outliers | 2. Open beyond q3 | 3. Open beyond 2 months | All |
---|---|---|---|---|
MODULE | ||||
Bugzilla | 0 | 0 | 1 | 1.0 |
DEVOPS | 0 | 2 | 4 | 6.0 |
Documentation / Wiki | 1 | 0 | 3 | 4.0 |
Gerrit | 0 | 0 | 1 | 1.0 |
IM-NBI | 1 | 2 | 4 | 7.0 |
LCM | 1 | 2 | 3 | 6.0 |
MON | 0 | 0 | 2 | 2.0 |
N2VC | 0 | 0 | 1 | 1.0 |
OSMClient | 0 | 2 | 6 | 8.0 |
POL | 0 | 1 | 0 | 1.0 |
RO | 2 | 2 | 7 | 11.0 |
Robot-tests | 1 | 0 | 3 | 4.0 |
All | 6 | 11 | 35 | 52.0 |
Too old bugs:
RECOMMENDATION | BUG_ID | BUG_DESCRIPTION | ISSUER | CREATION_TIME | CREATION_AGE | MONTH | STATE | STATE_UPDATE_TIME | STATE_UPDATE_AGE | ... | LAST_ASSIGNMENT_MONTH | LAST_ASSIGNMENT_AGE | OWNER_CHANGES | LAST_EVENT | LAST_EVENT_TIME | LAST_EVENT_AGE | LAST_EVENT_MONTH | SOLVED | BUG_RESOLUTION_TIME | TIME_SINCE_CREATION |
---|
0 rows × 29 columns
Pure outliers:
RECOMMENDATION | BUG_ID | LAST_EVENT_TIME | Time bug open (days) | count | mean | std | min | 25% | 50% | ... | OWNER | LAST_ASSIGNMENT_MONTH | LAST_ASSIGNMENT_AGE | OWNER_CHANGES | LAST_EVENT | LAST_EVENT_AGE | LAST_EVENT_MONTH | SOLVED | BUG_RESOLUTION_TIME | TIME_SINCE_CREATION | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | NaN | 2252 | 2023-08-24 16:59:46 | 187 | 4.0 | 172.000 | 10.099505 | 166.0 | 166.00 | 167.5 | ... | selvi.j@tataelxsi.co.in | 2023-08-31 23:59:59 | CURRENT | 2.0 | assigned_to | CURRENT | 2023-08-31 23:59:59 | False | 0 | 187 |
1 | NaN | 2253 | 2023-08-24 16:59:30 | 187 | 4.0 | 172.750 | 9.500000 | 168.0 | 168.00 | 168.0 | ... | selvi.j@tataelxsi.co.in | 2023-08-31 23:59:59 | CURRENT | 2.0 | cc | CURRENT | 2023-08-31 23:59:59 | False | 0 | 187 |
2 | NaN | 2270 | 2023-11-10 08:21:04 | 144 | 8.0 | 54.250 | 49.660994 | 19.0 | 24.75 | 30.5 | ... | rahul.k4@tataelxsi.co.in | 2023-07-31 23:59:59 | CURRENT | 1.0 | comment | CURRENT | 2023-11-30 23:59:59 | False | 0 | 144 |
3 | NaN | 2280 | 2023-11-13 21:03:17 | 123 | 4.0 | 47.750 | 50.367814 | 19.0 | 19.75 | 24.5 | ... | rahul.k4@tataelxsi.co.in | 2023-11-30 23:59:59 | CURRENT | 1.0 | everconfirmed | CURRENT | 2023-11-30 23:59:59 | False | 101 | 123 |
4 | NaN | 2281 | 2023-08-04 08:10:19 | 123 | 8.0 | 54.250 | 49.660994 | 19.0 | 24.75 | 30.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-08-31 23:59:59 | False | 0 | 123 |
5 | NaN | 2284 | 2023-08-09 11:49:19 | 118 | 8.0 | 37.625 | 32.810876 | 21.0 | 24.00 | 26.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-08-31 23:59:59 | False | 0 | 118 |
6 rows × 40 columns
Beyond Q3:
RECOMMENDATION | BUG_ID | LAST_EVENT_TIME | Time bug open (days) | count | mean | std | min | 25% | 50% | ... | OWNER | LAST_ASSIGNMENT_MONTH | LAST_ASSIGNMENT_AGE | OWNER_CHANGES | LAST_EVENT | LAST_EVENT_AGE | LAST_EVENT_MONTH | SOLVED | BUG_RESOLUTION_TIME | TIME_SINCE_CREATION | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | NaN | 1603 | 2023-02-15 00:00:12 | 865 | 9.0 | 371.333333 | 257.576202 | 13.0 | 231.00 | 363.0 | ... | gulsum.atici@canonical.com | 2022-03-31 23:59:59 | CURRENT | 2.0 | keywords | CURRENT | 2023-02-28 23:59:59.000000 | False | 319 | 865 |
1 | NaN | 1830 | 2023-11-08 06:14:48 | 720 | 3.0 | 428.666667 | 254.199397 | 252.0 | 283.00 | 314.0 | ... | srojas@whitestack.com | 2023-07-31 23:59:59 | CURRENT | 3.0 | comment | CURRENT | 2023-11-30 23:59:59.000000 | False | 581 | 720 |
2 | NaN | 2019 | 2023-10-03 15:03:31 | 586 | 9.0 | 371.333333 | 257.576202 | 13.0 | 231.00 | 363.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59.000000 | False | 193 | 586 |
3 | NaN | 2164 | 2023-10-17 17:21:22 | 447 | 2.0 | 264.500000 | 258.093975 | 82.0 | 173.25 | 264.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59.000000 | False | 138 | 447 |
4 | NaN | 2176 | 2023-10-17 16:56:24 | 431 | 6.0 | 260.000000 | 134.747171 | 138.0 | 160.00 | 206.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59.000000 | False | 382 | 431 |
5 | NaN | 2177 | 2023-10-17 17:02:41 | 428 | 6.0 | 260.000000 | 134.747171 | 138.0 | 160.00 | 206.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59.000000 | False | 379 | 428 |
6 | NaN | 2223 | 2023-03-03 13:23:34 | 281 | 2.0 | 157.000000 | 175.362482 | 33.0 | 95.00 | 157.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-03-31 23:59:59.000000 | False | 0 | 281 |
7 | NaN | 2241 | 2023-04-28 14:57:23 | 221 | 4.0 | 177.500000 | 69.294059 | 74.0 | 173.75 | 207.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-04-30 23:59:59.000000 | False | 0 | 221 |
8 | NaN | 2299 | 2023-12-04 16:05:27 | 36 | 8.0 | 37.625000 | 32.810876 | 21.0 | 24.00 | 26.5 | ... | NaN | NaT | NaN | NaN | comment | RECENT | 2023-12-06 04:00:05.028859 | False | 0 | 36 |
9 | NaN | 2301 | 2023-11-02 10:16:46 | 33 | 2.0 | 23.000000 | 14.142136 | 13.0 | 18.00 | 23.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59.000000 | False | 0 | 33 |
10 | NaN | 2305 | 2023-11-06 21:11:09 | 29 | 2.0 | 25.000000 | 5.656854 | 21.0 | 23.00 | 25.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-30 23:59:59.000000 | False | 0 | 29 |
11 rows × 40 columns
Beyond 2 months:
RECOMMENDATION | BUG_ID | LAST_EVENT_TIME | Time bug open (days) | count | mean | std | min | 25% | 50% | ... | OWNER | LAST_ASSIGNMENT_MONTH | LAST_ASSIGNMENT_AGE | OWNER_CHANGES | LAST_EVENT | LAST_EVENT_AGE | LAST_EVENT_MONTH | SOLVED | BUG_RESOLUTION_TIME | TIME_SINCE_CREATION | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | NaN | 1683 | 2023-06-14 13:12:23 | 791 | 1.0 | 791.000000 | NaN | 791.0 | 791.00 | 791.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59 | False | 617 | 791 |
1 | NaN | 2015 | 2023-06-14 14:52:04 | 588 | 1.0 | 588.000000 | NaN | 588.0 | 588.00 | 588.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59 | False | 317 | 588 |
2 | NaN | 2093 | 2023-07-19 17:19:49 | 522 | 9.0 | 371.333333 | 257.576202 | 13.0 | 231.00 | 363.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-07-31 23:59:59 | False | 248 | 522 |
3 | NaN | 2195 | 2023-05-15 14:29:20 | 382 | 9.0 | 371.333333 | 257.576202 | 13.0 | 231.00 | 363.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-05-31 23:59:59 | False | 0 | 382 |
4 | NaN | 2200 | 2023-02-07 00:00:27 | 363 | 9.0 | 371.333333 | 257.576202 | 13.0 | 231.00 | 363.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59 | False | 0 | 363 |
5 | NaN | 2205 | 2023-02-13 00:00:24 | 357 | 1.0 | 357.000000 | NaN | 357.0 | 357.00 | 357.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59 | False | 0 | 357 |
6 | NaN | 2214 | 2023-03-07 05:29:42 | 314 | 3.0 | 428.666667 | 254.199397 | 252.0 | 283.00 | 314.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-03-31 23:59:59 | False | 0 | 314 |
7 | NaN | 2215 | 2023-02-13 13:26:07 | 298 | 1.0 | 298.000000 | NaN | 298.0 | 298.00 | 298.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59 | False | 0 | 298 |
8 | NaN | 2221 | 2023-02-27 15:30:34 | 281 | 2.0 | 281.000000 | 0.000000 | 281.0 | 281.00 | 281.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59 | False | 0 | 281 |
9 | NaN | 2222 | 2023-02-27 15:53:28 | 281 | 2.0 | 281.000000 | 0.000000 | 281.0 | 281.00 | 281.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59 | False | 0 | 281 |
10 | NaN | 2229 | 2023-03-30 11:29:33 | 252 | 1.0 | 252.000000 | NaN | 252.0 | 252.00 | 252.0 | ... | NaN | NaT | NaN | NaN | short_desc | CURRENT | 2023-03-31 23:59:59 | False | 0 | 252 |
11 | NaN | 2230 | 2023-03-28 19:37:13 | 252 | 3.0 | 428.666667 | 254.199397 | 252.0 | 283.00 | 314.0 | ... | NaN | NaT | NaN | NaN | cc | CURRENT | 2023-03-31 23:59:59 | False | 0 | 252 |
12 | NaN | 2233 | 2023-04-13 10:02:45 | 236 | 9.0 | 371.333333 | 257.576202 | 13.0 | 231.00 | 363.0 | ... | NaN | NaT | NaN | NaN | cc | CURRENT | 2023-04-30 23:59:59 | False | 0 | 236 |
13 | NaN | 2235 | 2023-06-11 19:42:11 | 231 | 9.0 | 371.333333 | 257.576202 | 13.0 | 231.00 | 363.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59 | False | 0 | 231 |
14 | NaN | 2238 | 2023-04-21 14:35:51 | 228 | 1.0 | 228.000000 | NaN | 228.0 | 228.00 | 228.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-04-30 23:59:59 | False | 0 | 228 |
15 | NaN | 2240 | 2023-04-24 16:52:54 | 225 | 6.0 | 260.000000 | 134.747171 | 138.0 | 160.00 | 206.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-04-30 23:59:59 | False | 0 | 225 |
16 | NaN | 2243 | 2023-05-11 09:09:17 | 208 | 4.0 | 177.500000 | 69.294059 | 74.0 | 173.75 | 207.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-05-31 23:59:59 | False | 0 | 208 |
17 | NaN | 2245 | 2023-11-27 17:49:44 | 207 | 4.0 | 177.500000 | 69.294059 | 74.0 | 173.75 | 207.5 | ... | NaN | NaT | NaN | NaN | comment | RECENT | 2023-11-30 23:59:59 | False | 0 | 207 |
18 | NaN | 2251 | 2023-08-24 16:59:52 | 187 | 6.0 | 260.000000 | 134.747171 | 138.0 | 160.00 | 206.0 | ... | selvi.j@tataelxsi.co.in | 2023-08-31 23:59:59 | CURRENT | 2.0 | assigned_to | CURRENT | 2023-08-31 23:59:59 | False | 0 | 187 |
19 | NaN | 2259 | 2023-06-15 17:15:02 | 173 | 2.0 | 173.000000 | 0.000000 | 173.0 | 173.00 | 173.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59 | False | 0 | 173 |
20 | NaN | 2260 | 2023-06-15 17:18:45 | 173 | 2.0 | 173.000000 | 0.000000 | 173.0 | 173.00 | 173.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59 | False | 0 | 173 |
21 | NaN | 2261 | 2023-06-21 13:01:39 | 169 | 4.0 | 172.000000 | 10.099505 | 166.0 | 166.00 | 167.5 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 169 |
22 | NaN | 2263 | 2023-06-21 12:59:45 | 168 | 4.0 | 172.750000 | 9.500000 | 168.0 | 168.00 | 168.0 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 168 |
23 | NaN | 2264 | 2023-06-21 12:59:58 | 168 | 4.0 | 172.750000 | 9.500000 | 168.0 | 168.00 | 168.0 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 168 |
24 | NaN | 2265 | 2023-06-21 13:00:12 | 168 | 4.0 | 172.750000 | 9.500000 | 168.0 | 168.00 | 168.0 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 168 |
25 | NaN | 2266 | 2023-06-22 15:10:37 | 166 | 4.0 | 172.000000 | 10.099505 | 166.0 | 166.00 | 167.5 | ... | rahul.k4@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 166 |
26 | NaN | 2267 | 2023-06-22 15:10:07 | 166 | 4.0 | 172.000000 | 10.099505 | 166.0 | 166.00 | 167.5 | ... | deepika.e@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59 | False | 0 | 166 |
27 | NaN | 2269 | 2023-07-07 16:05:57 | 151 | 6.0 | 260.000000 | 134.747171 | 138.0 | 160.00 | 206.0 | ... | ramerama@tataelxsi.co.in | 2023-07-31 23:59:59 | CURRENT | 1.0 | version | CURRENT | 2023-07-31 23:59:59 | False | 0 | 151 |
28 | NaN | 2271 | 2023-07-19 18:53:57 | 144 | 9.0 | 371.333333 | 257.576202 | 13.0 | 231.00 | 363.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-07-31 23:59:59 | False | 0 | 144 |
29 | NaN | 2274 | 2023-07-20 15:08:35 | 138 | 6.0 | 260.000000 | 134.747171 | 138.0 | 160.00 | 206.0 | ... | deepika.e@tataelxsi.co.in | 2023-07-31 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-07-31 23:59:59 | False | 0 | 138 |
30 | NaN | 2277 | 2023-07-26 11:00:06 | 132 | 1.0 | 132.000000 | NaN | 132.0 | 132.00 | 132.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-07-31 23:59:59 | False | 0 | 132 |
31 | NaN | 2278 | 2023-08-10 09:39:19 | 132 | 1.0 | 132.000000 | NaN | 132.0 | 132.00 | 132.0 | ... | guillermo.calvino@canonical.com | 2023-07-31 23:59:59 | CURRENT | 1.0 | bug_severity | CURRENT | 2023-08-31 23:59:59 | False | 0 | 132 |
32 | NaN | 2286 | 2023-09-08 11:17:57 | 97 | 1.0 | 97.000000 | NaN | 97.0 | 97.00 | 97.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-09-30 23:59:59 | False | 0 | 97 |
33 | NaN | 2287 | 2023-09-18 23:58:26 | 82 | 2.0 | 264.500000 | 258.093975 | 82.0 | 173.25 | 264.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-09-30 23:59:59 | False | 0 | 82 |
34 | NaN | 2288 | 2023-09-22 15:22:41 | 74 | 4.0 | 177.500000 | 69.294059 | 74.0 | 173.75 | 207.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-09-30 23:59:59 | False | 0 | 74 |
35 rows × 40 columns