Date and time of the report: 2023-11-28 05:00:04.869870
Analysed period: 2020-07-01 to 2023-11-28.
Bugs considered recent: Since 2023-11-07.
DONE
72
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 | 7 | 6 | 13 |
LCM | 5 | 4 | 9 |
MON | 2 | 0 | 2 |
N2VC | 2 | 0 | 2 |
OSMClient | 8 | 0 | 8 |
POL | 1 | 1 | 2 |
RO | 14 | 4 | 18 |
Robot-tests | 4 | 0 | 4 |
Total | 56 | 16 | 72 |
AGE | CURRENT | RECENT | Total |
---|---|---|---|
VALUE | |||
OPEN-UNCONFIRMED | 47 | 14 | 61 |
CONFIRMED | 8 | 1 | 9 |
IN_PROGRESS | 1 | 1 | 2 |
Total | 56 | 16 | 72 |
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 | 783.000000 | NaN | 783.0 | 783.00 | 783.0 | 783.00 | 783.0 |
1 | DEVOPS | 8.0 | 168.375000 | 138.995311 | 5.0 | 25.00 | 198.5 | 273.00 | 349.0 |
2 | Documentation / Wiki | 4.0 | 164.000000 | 10.099505 | 158.0 | 158.00 | 159.5 | 165.50 | 179.0 |
3 | Gerrit | 1.0 | 580.000000 | NaN | 580.0 | 580.00 | 580.0 | 580.00 | 580.0 |
4 | IM-NBI | 13.0 | 89.153846 | 91.328022 | 13.0 | 18.00 | 28.0 | 199.00 | 244.0 |
5 | LCM | 9.0 | 214.888889 | 238.916536 | 11.0 | 21.00 | 115.0 | 306.00 | 712.0 |
6 | MON | 2.0 | 255.000000 | 49.497475 | 220.0 | 237.50 | 255.0 | 272.50 | 290.0 |
7 | N2VC | 2.0 | 163.500000 | 55.861436 | 124.0 | 143.75 | 163.5 | 183.25 | 203.0 |
8 | OSMClient | 8.0 | 230.250000 | 120.793507 | 130.0 | 159.50 | 172.0 | 267.75 | 423.0 |
9 | POL | 2.0 | 17.000000 | 5.656854 | 13.0 | 15.00 | 17.0 | 19.00 | 21.0 |
10 | RO | 18.0 | 207.166667 | 241.153661 | 5.0 | 21.75 | 125.5 | 323.25 | 857.0 |
11 | Robot-tests | 4.0 | 164.750000 | 9.500000 | 160.0 | 160.00 | 160.0 | 164.75 | 179.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 | 2 | 2.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 | 36 | 53.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 | 179 | 4.0 | 164.000 | 10.099505 | 158.0 | 158.00 | 159.5 | ... | selvi.j@tataelxsi.co.in | 2023-08-31 23:59:59.000000 | CURRENT | 2.0 | assigned_to | CURRENT | 2023-08-31 23:59:59.000000 | False | 0 | 179 |
1 | NaN | 2253 | 2023-08-24 16:59:30 | 179 | 4.0 | 164.750 | 9.500000 | 160.0 | 160.00 | 160.0 | ... | selvi.j@tataelxsi.co.in | 2023-08-31 23:59:59.000000 | CURRENT | 2.0 | cc | CURRENT | 2023-08-31 23:59:59.000000 | False | 0 | 179 |
2 | NaN | 2270 | 2023-11-10 08:21:04 | 136 | 8.0 | 46.250 | 49.660994 | 11.0 | 16.75 | 22.5 | ... | rahul.k4@tataelxsi.co.in | 2023-07-31 23:59:59.000000 | CURRENT | 1.0 | comment | RECENT | 2023-11-28 04:00:04.911110 | False | 0 | 136 |
3 | NaN | 2280 | 2023-11-13 21:03:17 | 115 | 4.0 | 39.750 | 50.367814 | 11.0 | 11.75 | 16.5 | ... | rahul.k4@tataelxsi.co.in | 2023-11-28 04:00:04.911110 | RECENT | 1.0 | everconfirmed | RECENT | 2023-11-28 04:00:04.911110 | False | 101 | 115 |
4 | NaN | 2281 | 2023-08-04 08:10:19 | 115 | 8.0 | 46.250 | 49.660994 | 11.0 | 16.75 | 22.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-08-31 23:59:59.000000 | False | 0 | 115 |
5 | NaN | 2284 | 2023-08-09 11:49:19 | 110 | 8.0 | 29.625 | 32.810876 | 13.0 | 16.00 | 18.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-08-31 23:59:59.000000 | False | 0 | 110 |
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 | 857 | 9.0 | 363.333333 | 257.576202 | 5.0 | 223.00 | 355.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 | 857 |
1 | NaN | 1830 | 2023-11-08 06:14:48 | 712 | 3.0 | 420.666667 | 254.199397 | 244.0 | 275.00 | 306.0 | ... | srojas@whitestack.com | 2023-07-31 23:59:59 | CURRENT | 3.0 | comment | RECENT | 2023-11-28 04:00:04.911110 | False | 581 | 712 |
2 | NaN | 2019 | 2023-10-03 15:03:31 | 578 | 9.0 | 363.333333 | 257.576202 | 5.0 | 223.00 | 355.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59.000000 | False | 193 | 578 |
3 | NaN | 2164 | 2023-10-17 17:21:22 | 439 | 2.0 | 256.500000 | 258.093975 | 74.0 | 165.25 | 256.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59.000000 | False | 138 | 439 |
4 | NaN | 2176 | 2023-10-17 16:56:24 | 423 | 6.0 | 252.000000 | 134.747171 | 130.0 | 152.00 | 198.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59.000000 | False | 382 | 423 |
5 | NaN | 2177 | 2023-10-17 17:02:41 | 420 | 6.0 | 252.000000 | 134.747171 | 130.0 | 152.00 | 198.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59.000000 | False | 379 | 420 |
6 | NaN | 2223 | 2023-03-03 13:23:34 | 273 | 2.0 | 149.000000 | 175.362482 | 25.0 | 87.00 | 149.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-03-31 23:59:59.000000 | False | 0 | 273 |
7 | NaN | 2241 | 2023-04-28 14:57:23 | 213 | 4.0 | 169.500000 | 69.294059 | 66.0 | 165.75 | 199.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-04-30 23:59:59.000000 | False | 0 | 213 |
8 | NaN | 2299 | 2023-10-30 17:35:50 | 28 | 8.0 | 29.625000 | 32.810876 | 13.0 | 16.00 | 18.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-10-31 23:59:59.000000 | False | 0 | 28 |
9 | NaN | 2301 | 2023-11-02 10:16:46 | 25 | 2.0 | 15.000000 | 14.142136 | 5.0 | 10.00 | 15.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-28 04:00:04.911110 | False | 0 | 25 |
10 | NaN | 2305 | 2023-11-06 21:11:09 | 21 | 2.0 | 17.000000 | 5.656854 | 13.0 | 15.00 | 17.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-11-28 04:00:04.911110 | False | 0 | 21 |
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 | 783 | 1.0 | 783.000000 | NaN | 783.0 | 783.00 | 783.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59.000000 | False | 617 | 783 |
1 | NaN | 2015 | 2023-06-14 14:52:04 | 580 | 1.0 | 580.000000 | NaN | 580.0 | 580.00 | 580.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59.000000 | False | 317 | 580 |
2 | NaN | 2093 | 2023-07-19 17:19:49 | 514 | 9.0 | 363.333333 | 257.576202 | 5.0 | 223.00 | 355.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-07-31 23:59:59.000000 | False | 248 | 514 |
3 | NaN | 2195 | 2023-05-15 14:29:20 | 374 | 9.0 | 363.333333 | 257.576202 | 5.0 | 223.00 | 355.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-05-31 23:59:59.000000 | False | 0 | 374 |
4 | NaN | 2200 | 2023-02-07 00:00:27 | 355 | 9.0 | 363.333333 | 257.576202 | 5.0 | 223.00 | 355.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59.000000 | False | 0 | 355 |
5 | NaN | 2205 | 2023-02-13 00:00:24 | 349 | 1.0 | 349.000000 | NaN | 349.0 | 349.00 | 349.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59.000000 | False | 0 | 349 |
6 | NaN | 2214 | 2023-03-07 05:29:42 | 306 | 3.0 | 420.666667 | 254.199397 | 244.0 | 275.00 | 306.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-03-31 23:59:59.000000 | False | 0 | 306 |
7 | NaN | 2215 | 2023-02-13 13:26:07 | 290 | 1.0 | 290.000000 | NaN | 290.0 | 290.00 | 290.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59.000000 | False | 0 | 290 |
8 | NaN | 2221 | 2023-02-27 15:30:34 | 273 | 2.0 | 273.000000 | 0.000000 | 273.0 | 273.00 | 273.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59.000000 | False | 0 | 273 |
9 | NaN | 2222 | 2023-02-27 15:53:28 | 273 | 2.0 | 273.000000 | 0.000000 | 273.0 | 273.00 | 273.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-02-28 23:59:59.000000 | False | 0 | 273 |
10 | NaN | 2229 | 2023-03-30 11:29:33 | 244 | 1.0 | 244.000000 | NaN | 244.0 | 244.00 | 244.0 | ... | NaN | NaT | NaN | NaN | short_desc | CURRENT | 2023-03-31 23:59:59.000000 | False | 0 | 244 |
11 | NaN | 2230 | 2023-03-28 19:37:13 | 244 | 3.0 | 420.666667 | 254.199397 | 244.0 | 275.00 | 306.0 | ... | NaN | NaT | NaN | NaN | cc | CURRENT | 2023-03-31 23:59:59.000000 | False | 0 | 244 |
12 | NaN | 2233 | 2023-04-13 10:02:45 | 228 | 9.0 | 363.333333 | 257.576202 | 5.0 | 223.00 | 355.0 | ... | NaN | NaT | NaN | NaN | cc | CURRENT | 2023-04-30 23:59:59.000000 | False | 0 | 228 |
13 | NaN | 2235 | 2023-06-11 19:42:11 | 223 | 9.0 | 363.333333 | 257.576202 | 5.0 | 223.00 | 355.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59.000000 | False | 0 | 223 |
14 | NaN | 2238 | 2023-04-21 14:35:51 | 220 | 1.0 | 220.000000 | NaN | 220.0 | 220.00 | 220.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-04-30 23:59:59.000000 | False | 0 | 220 |
15 | NaN | 2240 | 2023-04-24 16:52:54 | 217 | 6.0 | 252.000000 | 134.747171 | 130.0 | 152.00 | 198.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-04-30 23:59:59.000000 | False | 0 | 217 |
16 | NaN | 2242 | 2023-05-12 12:45:47 | 203 | 1.0 | 203.000000 | NaN | 203.0 | 203.00 | 203.0 | ... | NaN | NaT | NaN | NaN | version | CURRENT | 2023-05-31 23:59:59.000000 | False | 0 | 203 |
17 | NaN | 2243 | 2023-05-11 09:09:17 | 200 | 4.0 | 169.500000 | 69.294059 | 66.0 | 165.75 | 199.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-05-31 23:59:59.000000 | False | 0 | 200 |
18 | NaN | 2245 | 2023-11-27 17:49:44 | 199 | 4.0 | 169.500000 | 69.294059 | 66.0 | 165.75 | 199.5 | ... | NaN | NaT | NaN | NaN | comment | RECENT | 2023-11-28 04:00:04.911110 | False | 0 | 199 |
19 | NaN | 2251 | 2023-08-24 16:59:52 | 179 | 6.0 | 252.000000 | 134.747171 | 130.0 | 152.00 | 198.0 | ... | selvi.j@tataelxsi.co.in | 2023-08-31 23:59:59 | CURRENT | 2.0 | assigned_to | CURRENT | 2023-08-31 23:59:59.000000 | False | 0 | 179 |
20 | NaN | 2259 | 2023-06-15 17:15:02 | 165 | 2.0 | 165.000000 | 0.000000 | 165.0 | 165.00 | 165.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59.000000 | False | 0 | 165 |
21 | NaN | 2260 | 2023-06-15 17:18:45 | 165 | 2.0 | 165.000000 | 0.000000 | 165.0 | 165.00 | 165.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-06-30 23:59:59.000000 | False | 0 | 165 |
22 | NaN | 2261 | 2023-06-21 13:01:39 | 161 | 4.0 | 164.000000 | 10.099505 | 158.0 | 158.00 | 159.5 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59.000000 | False | 0 | 161 |
23 | NaN | 2263 | 2023-06-21 12:59:45 | 160 | 4.0 | 164.750000 | 9.500000 | 160.0 | 160.00 | 160.0 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59.000000 | False | 0 | 160 |
24 | NaN | 2264 | 2023-06-21 12:59:58 | 160 | 4.0 | 164.750000 | 9.500000 | 160.0 | 160.00 | 160.0 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59.000000 | False | 0 | 160 |
25 | NaN | 2265 | 2023-06-21 13:00:12 | 160 | 4.0 | 164.750000 | 9.500000 | 160.0 | 160.00 | 160.0 | ... | ramerama@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59.000000 | False | 0 | 160 |
26 | NaN | 2266 | 2023-06-22 15:10:37 | 158 | 4.0 | 164.000000 | 10.099505 | 158.0 | 158.00 | 159.5 | ... | rahul.k4@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59.000000 | False | 0 | 158 |
27 | NaN | 2267 | 2023-06-22 15:10:07 | 158 | 4.0 | 164.000000 | 10.099505 | 158.0 | 158.00 | 159.5 | ... | deepika.e@tataelxsi.co.in | 2023-06-30 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-06-30 23:59:59.000000 | False | 0 | 158 |
28 | NaN | 2269 | 2023-07-07 16:05:57 | 143 | 6.0 | 252.000000 | 134.747171 | 130.0 | 152.00 | 198.0 | ... | ramerama@tataelxsi.co.in | 2023-07-31 23:59:59 | CURRENT | 1.0 | version | CURRENT | 2023-07-31 23:59:59.000000 | False | 0 | 143 |
29 | NaN | 2271 | 2023-07-19 18:53:57 | 136 | 9.0 | 363.333333 | 257.576202 | 5.0 | 223.00 | 355.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-07-31 23:59:59.000000 | False | 0 | 136 |
30 | NaN | 2274 | 2023-07-20 15:08:35 | 130 | 6.0 | 252.000000 | 134.747171 | 130.0 | 152.00 | 198.0 | ... | deepika.e@tataelxsi.co.in | 2023-07-31 23:59:59 | CURRENT | 1.0 | assigned_to | CURRENT | 2023-07-31 23:59:59.000000 | False | 0 | 130 |
31 | NaN | 2277 | 2023-07-26 11:00:06 | 124 | 1.0 | 124.000000 | NaN | 124.0 | 124.00 | 124.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-07-31 23:59:59.000000 | False | 0 | 124 |
32 | NaN | 2278 | 2023-08-10 09:39:19 | 124 | 1.0 | 124.000000 | NaN | 124.0 | 124.00 | 124.0 | ... | guillermo.calvino@canonical.com | 2023-07-31 23:59:59 | CURRENT | 1.0 | bug_severity | CURRENT | 2023-08-31 23:59:59.000000 | False | 0 | 124 |
33 | NaN | 2286 | 2023-09-08 11:17:57 | 89 | 1.0 | 89.000000 | NaN | 89.0 | 89.00 | 89.0 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-09-30 23:59:59.000000 | False | 0 | 89 |
34 | NaN | 2287 | 2023-09-18 23:58:26 | 74 | 2.0 | 256.500000 | 258.093975 | 74.0 | 165.25 | 256.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-09-30 23:59:59.000000 | False | 0 | 74 |
35 | NaN | 2288 | 2023-09-22 15:22:41 | 66 | 4.0 | 169.500000 | 69.294059 | 66.0 | 165.75 | 199.5 | ... | NaN | NaT | NaN | NaN | comment | CURRENT | 2023-09-30 23:59:59.000000 | False | 0 | 66 |
36 rows × 40 columns