Analysis of OSM events in Bugzilla

Date and time of the report: 2023-08-02 05:00:05.308911

Analysed period: 2020-07-01 to 2023-08-02.

Bugs considered recent: Since 2023-07-12.

1. Imports and cleans raw source data with all Bugzilla events

DONE

2. Current state of open bugs

2.1 Number of open bugs

Total number of open bugs:

59

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	NS instantiation fails in VIMs with microversi...	2	[Master, v14.0]	RO	2023-07-20 11:08:01
1	Registration of K8s cluster fails through the GUI	3	[Master, v13.0, v12.0]	NG-UI	2023-03-15 17:43:13

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
Bugzilla	1	0	1
DEVOPS	4	1	5
Documentation / Wiki	4	0	4
Gerrit	1	0	1
IM-NBI	5	0	5
LCM	5	1	6
MON	2	0	2
N2VC	1	1	2
NG-UI	5	0	5
OSMClient	7	2	9
RO	11	4	15
Robot-tests	4	0	4
Total	50	9	59

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	42	8	50
CONFIRMED	8	0	8
IN_PROGRESS	0	1	1
Total	50	9	59

Age distribution per module

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	665.000000	NaN	665.0	665.00	665.0	665.00	665.0
1	DEVOPS	5.0	140.400000	82.023167	6.0	155.00	155.0	155.00	231.0
2	Documentation / Wiki	4.0	46.000000	10.099505	40.0	40.00	41.5	47.50	61.0
3	Gerrit	1.0	462.000000	NaN	462.0	462.00	462.0	462.00	462.0
4	IM-NBI	5.0	123.800000	64.766504	81.0	82.00	95.0	126.00	235.0
5	LCM	6.0	330.500000	165.924983	126.0	221.25	334.5	391.50	594.0
6	MON	2.0	137.000000	49.497475	102.0	119.50	137.0	154.50	172.0
7	N2VC	2.0	45.500000	55.861436	6.0	25.75	45.5	65.25	85.0
8	NG-UI	5.0	139.200000	14.498276	119.0	139.00	139.0	139.00	160.0
9	OSMClient	9.0	100.444444	118.412532	6.0	25.00	47.0	99.00	305.0
10	RO	15.0	187.800000	214.549428	12.0	23.00	105.0	292.00	739.0
11	Robot-tests	4.0	46.750000	9.500000	42.0	42.00	42.0	46.75	61.0

2.3 Outliers

Four types of bug age outliers are identified:

1. Too old bugs.
2. Pure outliers for boxplot: Beyond Q3+1.5IQR for the MDG.
3. Beyond 3rd quartile of ages.
4. Age beyond 2 months.

Recommendations file does not exist.

Summary table of outliers:

AGE	1. Open outliers	2. Open beyond q3	3. Open beyond 2 months	All
MODULE
Bugzilla	0	0	1	1.0
DEVOPS	0	0	4	4.0
Documentation / Wiki	1	0	0	1.0
Gerrit	0	0	1	1.0
IM-NBI	0	1	4	5.0
LCM	0	1	5	6.0
MON	0	0	2	2.0
N2VC	0	0	1	1.0
NG-UI	0	1	4	5.0
OSMClient	0	2	2	4.0
RO	0	3	5	8.0
Robot-tests	1	0	0	1.0
All	2	8	29	39.0

Outlier details

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-06-22 15:05:50	61	4.0	46.00	10.099505	40.0	40.0	41.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	short_desc	CURRENT	2023-06-30 23:59:59	False	0	61
1	NaN	2253	2023-06-21 13:02:19	61	4.0	46.75	9.500000	42.0	42.0	42.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	61

2 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	739	13.0	214.384615	218.996780	12.0	49.0	110.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2023-02-28 23:59:59	False	319	739
1	NaN	1830	2023-07-19 19:05:29	594	4.0	314.000000	208.786973	126.0	172.5	268.0	...	srojas@whitestack.com	2023-07-31 23:59:59	RECENT	3.0	assigned_to	RECENT	2023-07-31 23:59:59	False	581	594
2	NaN	2019	2023-01-24 10:01:15	460	13.0	214.384615	218.996780	12.0	49.0	110.0	...	NaN	NaT	NaN	NaN	version	CURRENT	2023-01-31 23:59:59	False	193	460
3	NaN	2093	2023-07-19 17:19:49	396	13.0	214.384615	218.996780	12.0	49.0	110.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2023-07-31 23:59:59	False	248	396
4	NaN	2176	2023-02-08 00:00:20	305	6.0	134.000000	134.747171	12.0	34.0	80.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2023-02-28 23:59:59	False	0	305
5	NaN	2177	2023-02-07 00:00:23	302	6.0	134.000000	134.747171	12.0	34.0	80.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59	False	0	302
6	NaN	2219	2023-02-22 17:40:55	160	3.0	139.333333	20.502032	119.0	129.0	139.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59	False	0	160
7	NaN	2241	2023-04-28 14:57:23	95	3.0	86.000000	7.810250	81.0	81.5	82.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-04-30 23:59:59	False	0	95

8 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	665	1.0	665.000000	NaN	665.0	665.0	665.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59	False	617	665
1	NaN	2015	2023-06-14 14:52:04	462	1.0	462.000000	NaN	462.0	462.0	462.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59	False	317	462
2	NaN	2088	2023-06-01 18:03:52	406	1.0	406.000000	NaN	406.0	406.0	406.0	...	gcuba@whitestack.com	2022-08-31 23:59:59	CURRENT	1.0	comment	CURRENT	2023-06-30 23:59:59	False	321	406
3	NaN	2144	2023-03-06 00:00:17	348	4.0	314.000000	208.786973	126.0	172.5	268.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-03-31 23:59:59	False	0	348
4	NaN	2158	2023-07-27 10:14:27	328	13.0	214.384615	218.996780	12.0	49.0	110.0	...	gulsum.atici@canonical.com	2022-09-30 23:59:59	CURRENT	1.0	comment	RECENT	2023-07-31 23:59:59	False	179	328
5	NaN	2164	2023-01-31 00:39:01	321	1.0	321.000000	NaN	321.0	321.0	321.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2023-01-31 23:59:59	False	138	321
6	NaN	2195	2023-05-15 14:29:20	256	13.0	214.384615	218.996780	12.0	49.0	110.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-05-31 23:59:59	False	0	256
7	NaN	2200	2023-02-07 00:00:27	237	13.0	214.384615	218.996780	12.0	49.0	110.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59	False	0	237
8	NaN	2201	2023-02-09 00:00:24	235	1.0	235.000000	NaN	235.0	235.0	235.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59	False	0	235
9	NaN	2205	2023-02-13 00:00:24	231	1.0	231.000000	NaN	231.0	231.0	231.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59	False	0	231
10	NaN	2214	2023-03-07 05:29:42	188	4.0	314.000000	208.786973	126.0	172.5	268.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-03-31 23:59:59	False	0	188
11	NaN	2215	2023-02-13 13:26:07	172	1.0	172.000000	NaN	172.0	172.0	172.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59	False	0	172
12	NaN	2221	2023-02-27 15:30:34	155	2.0	155.000000	0.000000	155.0	155.0	155.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59	False	0	155
13	NaN	2222	2023-02-27 15:53:28	155	2.0	155.000000	0.000000	155.0	155.0	155.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-02-28 23:59:59	False	0	155
14	NaN	2223	2023-03-03 13:23:34	155	1.0	155.000000	NaN	155.0	155.0	155.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-03-31 23:59:59	False	0	155
15	NaN	2225	2023-06-21 13:04:50	139	3.0	139.333333	20.502032	119.0	129.0	139.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	2.0	assigned_to	CURRENT	2023-06-30 23:59:59	False	0	139
16	NaN	2226	2023-03-15 17:53:51	139	1.0	139.000000	NaN	139.0	139.0	139.0	...	NaN	NaT	NaN	NaN	dependson	CURRENT	2023-03-31 23:59:59	False	0	139
17	NaN	2227	2023-03-15 17:53:51	139	1.0	139.000000	NaN	139.0	139.0	139.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-03-31 23:59:59	False	0	139
18	NaN	2229	2023-03-30 11:29:33	126	1.0	126.000000	NaN	126.0	126.0	126.0	...	NaN	NaT	NaN	NaN	short_desc	CURRENT	2023-03-31 23:59:59	False	0	126
19	NaN	2230	2023-03-28 19:37:13	126	4.0	314.000000	208.786973	126.0	172.5	268.0	...	NaN	NaT	NaN	NaN	cc	CURRENT	2023-03-31 23:59:59	False	0	126
20	NaN	2232	2023-04-04 21:32:09	119	3.0	139.333333	20.502032	119.0	129.0	139.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-04-30 23:59:59	False	0	119
21	NaN	2233	2023-04-13 10:02:45	110	13.0	214.384615	218.996780	12.0	49.0	110.0	...	NaN	NaT	NaN	NaN	cc	CURRENT	2023-04-30 23:59:59	False	0	110
22	NaN	2235	2023-06-11 19:42:11	105	13.0	214.384615	218.996780	12.0	49.0	110.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-06-30 23:59:59	False	0	105
23	NaN	2238	2023-04-21 14:35:51	102	1.0	102.000000	NaN	102.0	102.0	102.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-04-30 23:59:59	False	0	102
24	NaN	2240	2023-04-24 16:52:54	99	6.0	134.000000	134.747171	12.0	34.0	80.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-04-30 23:59:59	False	0	99
25	NaN	2242	2023-05-12 12:45:47	85	1.0	85.000000	NaN	85.0	85.0	85.0	...	NaN	NaT	NaN	NaN	version	CURRENT	2023-05-31 23:59:59	False	0	85
26	NaN	2243	2023-05-11 09:09:17	82	3.0	86.000000	7.810250	81.0	81.5	82.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-05-31 23:59:59	False	0	82
27	NaN	2245	2023-07-07 15:44:24	81	3.0	86.000000	7.810250	81.0	81.5	82.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2023-07-31 23:59:59	False	0	81
28	NaN	2251	2023-06-21 13:02:49	61	6.0	134.000000	134.747171	12.0	34.0	80.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	61

29 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs