Analysis of OSM events in Bugzilla

Date and time of the report: 2024-03-29 05:00:04.811595

Analysed period: 2020-07-01 to 2024-03-29.

Bugs considered recent: Since 2024-03-08.

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:

85

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	NS deletion takes longer than expected for bas...	2	[Master, v15.0]	LCM	2024-03-14 15:35:49
1	Robot testsuite heal_02 fails in a step when c...	2	[Master, v15.0]	Robot-tests	2023-12-20 15:09:20
2	Robot testsuite heal_03 fails when checking if...	2	[Master, v15.0]	Robot-tests	2023-12-20 17:06:32
3	Robot testsuite lcmop_01 fails in daily job wh...	2	[Master, v15.0]	Robot-tests	2023-12-20 14:23:08
4	Updating a VNF instance with an NS update oper...	3	[Master, v14.0, v12.0]	LCM	2023-12-12 11:11:02

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
DEVOPS	3	0	3
Documentation / Wiki	4	0	4
IM-NBI	12	6	18
LCM	7	4	11
N2VC	1	0	1
NG-SA	1	0	1
NG-UI	2	1	3
OSMClient	6	1	7
POL	1	1	2
RO	18	6	24
Robot-tests	11	0	11
Total	66	19	85

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	61	15	76
CONFIRMED	5	1	6
IN_PROGRESS	0	3	3
Total	66	19	85

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	DEVOPS	3.0	139.000000	111.216006	24.0	85.50	147.0	196.50	246.0
1	Documentation / Wiki	4.0	286.000000	10.099505	280.0	280.00	281.5	287.50	301.0
2	IM-NBI	18.0	152.944444	121.780648	3.0	35.75	140.0	221.00	366.0
3	LCM	11.0	200.545455	173.066671	3.0	103.00	107.0	281.00	561.0
4	N2VC	1.0	246.000000	NaN	246.0	246.00	246.0	246.00	246.0
5	NG-SA	1.0	58.000000	NaN	58.0	58.00	58.0	58.00	58.0
6	NG-UI	3.0	21.333333	1.154701	20.0	21.00	22.0	22.00	22.0
7	OSMClient	7.0	279.571429	152.409380	20.0	258.50	287.0	294.00	545.0
8	POL	2.0	72.500000	99.702056	2.0	37.25	72.5	107.75	143.0
9	RO	24.0	203.250000	231.464384	6.0	20.25	141.5	258.00	979.0
10	Robot-tests	11.0	167.272727	94.867372	99.0	99.00	99.0	282.00	301.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
DEVOPS	0	0	2	2.0
Documentation / Wiki	1	0	3	4.0
IM-NBI	0	3	10	13.0
LCM	0	3	7	10.0
N2VC	0	0	1	1.0
OSMClient	1	1	4	6.0
POL	0	1	0	1.0
RO	3	3	10	16.0
Robot-tests	0	1	10	11.0
All	5	12	47	64.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	1603	2024-03-11 17:25:03	979	15.0	221.400000	292.791686	6.0	17.50	21.0	...	gulsum.atici@canonical.com	2022-03-31 23:59:59	CURRENT	2.0	comment	RECENT	2024-03-29 04:00:04.843653	False	319	979
1	NaN	2176	2024-03-22 13:35:30	545	7.0	279.571429	152.409380	20.0	258.50	287.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	382	545
2	NaN	2252	2024-03-13 00:00:19	301	4.0	286.000000	10.099505	280.0	280.00	281.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-29 04:00:04.843653	False	0	301
3	NaN	2270	2024-03-11 17:26:24	258	8.0	168.250000	49.660994	133.0	138.75	144.5	...	rahul.k4@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	258
4	NaN	2281	2024-03-11 17:26:36	237	8.0	168.250000	49.660994	133.0	138.75	144.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	237

5 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	2093	2024-03-11 17:25:08	636	15.0	221.400000	292.791686	6.0	17.50	21.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	248	636
1	NaN	2164	2024-03-11 17:25:10	561	3.0	288.000000	240.576391	107.0	151.50	196.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	138	561
2	NaN	2195	2024-03-11 17:25:24	496	15.0	221.400000	292.791686	6.0	17.50	21.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	496
3	NaN	2214	2024-03-11 17:25:40	428	4.0	250.000000	171.648866	99.0	105.00	236.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	428
4	NaN	2233	2024-03-11 17:25:49	350	15.0	221.400000	292.791686	6.0	17.50	21.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-29 04:00:04.843653	False	0	350
5	NaN	2241	2024-03-11 16:03:32	335	4.0	291.500000	69.294059	188.0	287.75	321.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	335
6	NaN	2251	2024-03-13 00:00:17	301	7.0	279.571429	152.409380	20.0	258.50	287.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-29 04:00:04.843653	False	0	301
7	NaN	2253	2024-03-13 00:00:21	301	7.0	206.285714	100.581168	99.0	99.00	282.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	RECENT	2024-03-29 04:00:04.843653	False	0	301
8	NaN	2284	2024-03-11 17:26:38	232	12.0	92.333333	79.687268	3.0	9.75	135.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	232
9	NaN	2299	2024-03-11 17:26:50	150	12.0	92.333333	79.687268	3.0	9.75	135.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	150
10	NaN	2305	2024-03-11 17:26:59	143	2.0	72.500000	99.702056	2.0	37.25	72.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	143
11	NaN	2319	2024-03-21 01:00:10	133	3.0	81.000000	68.789534	3.0	55.00	107.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-29 04:00:04.843653	False	125	133

12 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	2229	2024-03-11 17:25:45	366	1.0	366.000000	NaN	366.0	366.00	366.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	366
1	NaN	2230	2024-03-11 17:25:47	366	4.0	250.000000	171.648866	99.0	105.00	236.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-29 04:00:04.843653	False	0	366
2	NaN	2235	2024-03-11 17:25:51	345	15.0	221.400000	292.791686	6.0	17.50	21.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-29 04:00:04.843653	False	0	345
3	NaN	2243	2024-03-11 17:29:12	322	4.0	291.500000	69.294059	188.0	287.75	321.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-29 04:00:04.843653	False	305	322
4	NaN	2245	2024-02-21 12:49:36	321	4.0	291.500000	69.294059	188.0	287.75	321.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	321
5	NaN	2259	2024-03-12 17:32:24	287	7.0	279.571429	152.409380	20.0	258.50	287.0	...	gerardo.garciadeblas@telefonica.com	2024-03-29 04:00:04.843653	RECENT	1.0	assigned_to	RECENT	2024-03-29 04:00:04.843653	False	0	287
6	NaN	2260	2024-03-12 17:32:32	287	7.0	279.571429	152.409380	20.0	258.50	287.0	...	gerardo.garciadeblas@telefonica.com	2024-03-29 04:00:04.843653	RECENT	1.0	assigned_to	RECENT	2024-03-29 04:00:04.843653	False	0	287
7	NaN	2261	2024-03-11 17:26:07	283	4.0	286.000000	10.099505	280.0	280.00	281.5	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	283
8	NaN	2263	2024-03-11 17:26:10	282	7.0	206.285714	100.581168	99.0	99.00	282.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	282
9	NaN	2264	2024-03-11 17:26:12	282	7.0	206.285714	100.581168	99.0	99.00	282.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	282
10	NaN	2265	2024-03-11 17:26:14	282	7.0	206.285714	100.581168	99.0	99.00	282.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	282
11	NaN	2266	2024-03-11 17:26:17	280	4.0	286.000000	10.099505	280.0	280.00	281.5	...	rahul.k4@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	280
12	NaN	2267	2024-03-11 17:26:19	280	4.0	286.000000	10.099505	280.0	280.00	281.5	...	deepika.e@tataelxsi.co.in	2023-06-30 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	280
13	NaN	2269	2024-03-11 17:26:21	265	7.0	279.571429	152.409380	20.0	258.50	287.0	...	ramerama@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	265
14	NaN	2271	2024-03-11 17:26:26	258	15.0	221.400000	292.791686	6.0	17.50	21.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	258
15	NaN	2274	2024-03-11 17:26:28	252	7.0	279.571429	152.409380	20.0	258.50	287.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	252
16	NaN	2277	2024-03-11 17:26:31	246	1.0	246.000000	NaN	246.0	246.00	246.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	246
17	NaN	2278	2024-03-11 17:26:33	246	1.0	246.000000	NaN	246.0	246.00	246.0	...	guillermo.calvino@canonical.com	2023-07-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	246
18	NaN	2286	2024-03-11 17:26:41	211	1.0	211.000000	NaN	211.0	211.00	211.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	211
19	NaN	2287	2024-03-11 17:26:43	196	3.0	288.000000	240.576391	107.0	151.50	196.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	196
20	NaN	2288	2024-03-11 17:26:45	188	4.0	291.500000	69.294059	188.0	287.75	321.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	188
21	NaN	2298	2024-03-11 17:26:47	154	8.0	168.250000	49.660994	133.0	138.75	144.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	154
22	NaN	2301	2024-03-11 17:26:52	147	1.0	147.000000	NaN	147.0	147.00	147.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	147
23	NaN	2303	2024-03-11 17:26:54	146	8.0	168.250000	49.660994	133.0	138.75	144.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	146
24	NaN	2306	2024-03-11 17:27:01	143	8.0	168.250000	49.660994	133.0	138.75	144.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	143
25	NaN	2307	2024-02-20 16:25:14	141	12.0	92.333333	79.687268	3.0	9.75	135.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	141
26	NaN	2308	2024-02-20 16:24:22	141	12.0	92.333333	79.687268	3.0	9.75	135.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	141
27	NaN	2310	2024-03-11 17:27:04	140	8.0	168.250000	49.660994	133.0	138.75	144.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	140
28	NaN	2312	2024-03-19 00:00:37	139	12.0	92.333333	79.687268	3.0	9.75	135.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-29 04:00:04.843653	False	0	139
29	NaN	2313	2024-03-22 00:00:41	135	12.0	92.333333	79.687268	3.0	9.75	135.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-03-29 04:00:04.843653	False	0	135
30	NaN	2314	2024-02-20 16:27:21	135	12.0	92.333333	79.687268	3.0	9.75	135.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	135
31	NaN	2316	2024-03-11 17:27:12	135	8.0	168.250000	49.660994	133.0	138.75	144.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	135
32	NaN	2318	2024-03-11 17:27:14	133	8.0	168.250000	49.660994	133.0	138.75	144.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	133
33	NaN	2320	2024-03-11 17:27:19	127	15.0	221.400000	292.791686	6.0	17.50	21.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	127
34	NaN	2322	2024-03-11 17:27:21	113	1.0	113.000000	NaN	113.0	113.00	113.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	113
35	NaN	2323	2024-03-11 17:27:23	107	4.0	250.000000	171.648866	99.0	105.00	236.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	107
36	NaN	2324	2024-03-11 17:27:26	107	3.0	81.000000	68.789534	3.0	55.00	107.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	107
37	NaN	2325	2024-03-11 17:27:28	107	3.0	288.000000	240.576391	107.0	151.50	196.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	107
38	NaN	2326	2024-02-05 18:34:33	99	4.0	99.000000	0.000000	99.0	99.00	99.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	99
39	NaN	2328	2024-03-14 15:35:49	99	4.0	250.000000	171.648866	99.0	105.00	236.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-29 04:00:04.843653	False	85	99
40	NaN	2329	2024-03-21 00:35:22	99	1.0	99.000000	NaN	99.0	99.00	99.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-03-29 04:00:04.843653	False	91	99
41	NaN	2330	2024-03-11 17:27:36	99	7.0	206.285714	100.581168	99.0	99.00	282.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	99
42	NaN	2331	2024-03-11 17:27:39	99	4.0	99.000000	0.000000	99.0	99.00	99.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-03-29 04:00:04.843653	False	0	99
43	NaN	2332	2024-02-02 14:50:02	99	7.0	206.285714	100.581168	99.0	99.00	282.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	99
44	NaN	2333	2024-03-11 17:27:42	99	4.0	99.000000	0.000000	99.0	99.00	99.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	99
45	NaN	2334	2024-03-11 17:27:44	99	7.0	206.285714	100.581168	99.0	99.00	282.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	99
46	NaN	2335	2024-03-11 17:27:46	99	4.0	99.000000	0.000000	99.0	99.00	99.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-03-29 04:00:04.843653	False	0	99

47 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs