Analysis of OSM events in Bugzilla

Date and time of the report: 2024-05-09 05:00:05.468706

Analysed period: 2020-07-01 to 2024-05-09.

Bugs considered recent: Since 2024-04-18.

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:

56

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP
0	Operational-status is not getting updated when...	2	[v14.0, v14.0]	LCM	2024-03-30 17:08:31
1	Robot testsuite heal_02 fails in a step when c...	2	[Master, v15.0]	Robot-tests	2024-05-07 09:42:34
2	Robot testsuite heal_03 fails when checking if...	2	[Master, v15.0]	Robot-tests	2024-05-07 09:44:42
3	Robot testsuite lcmop_01 fails in daily job wh...	2	[Master, v15.0]	Robot-tests	2024-05-07 09:43:12

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
DEVOPS	1	0	1
IM-NBI	15	3	18
LCM	9	1	10
MON	0	1	1
OSMClient	2	3	5
POL	1	0	1
RO	11	1	12
Robot-tests	0	8	8
Total	39	17	56

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	32	6	38
UNCONFIRMED	1	0	1
CONFIRMED	5	10	15
IN_PROGRESS	1	1	2
Total	39	17	56

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	1.0	65.000000	NaN	65.0	65.00	65.0	65.00	65.0
1	IM-NBI	18.0	117.000000	114.993606	0.0	40.25	51.0	179.00	376.0
2	LCM	10.0	131.600000	201.851541	36.0	37.00	39.0	42.75	602.0
3	MON	1.0	184.000000	NaN	184.0	184.00	184.0	184.00	184.0
4	OSMClient	5.0	143.800000	171.718374	1.0	1.00	61.0	293.00	363.0
5	POL	1.0	43.000000	NaN	43.0	43.00	43.0	43.00	43.0
6	RO	12.0	123.416667	137.634865	1.0	55.75	59.0	109.50	391.0
7	Robot-tests	8.0	185.750000	84.712539	140.0	140.00	140.0	185.75	323.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	1	1.0
IM-NBI	0	4	4	8.0
LCM	1	0	2	3.0
MON	0	0	1	1.0
OSMClient	0	1	2	3.0
RO	2	1	3	6.0
Robot-tests	0	0	8	8.0
All	3	6	21	30.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	2233	2024-03-11 17:25:49	391	9.0	132.000	145.445866	55.0	58.00	59.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	391
1	NaN	2235	2024-03-11 17:25:51	386	9.0	132.000	145.445866	55.0	58.00	59.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	386
2	NaN	2355	2024-03-25 04:52:49	44	8.0	38.375	2.615203	36.0	36.75	38.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	44

3 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	2241	2024-03-11 16:03:32	376	2.0	369.000000	9.899495	362.0	365.50	369.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	376
1	NaN	2274	2024-05-07 17:51:14	293	2.0	177.000000	164.048773	61.0	119.00	177.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	bug_status	RECENT	2024-05-09 03:00:05.508023	False	292	293
2	NaN	2307	2024-04-22 00:00:10	182	15.0	80.933333	74.071844	0.0	38.00	50.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59.000000	False	0	182
3	NaN	2308	2024-04-22 00:00:12	182	15.0	80.933333	74.071844	0.0	38.00	50.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59.000000	False	0	182
4	NaN	2312	2024-03-19 00:00:37	180	15.0	80.933333	74.071844	0.0	38.00	50.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	180
5	NaN	2359	2024-03-29 08:26:14	40	2.0	20.500000	27.577164	1.0	10.75	20.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	40

6 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	2164	2024-04-05 00:00:12	602	1.0	602.000000	NaN	602.0	602.0	602.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-04-30 23:59:59.000000	False	138	602
1	NaN	2230	2024-03-11 17:25:47	407	1.0	407.000000	NaN	407.0	407.0	407.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	407
2	NaN	2243	2024-04-02 17:29:43	363	1.0	363.000000	NaN	363.0	363.0	363.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59.000000	False	305	363
3	NaN	2245	2024-04-02 17:35:28	362	2.0	369.000000	9.899495	362.0	365.5	369.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59.000000	False	0	362
4	NaN	2263	2024-05-07 17:30:10	323	5.0	213.200000	100.233228	140.0	140.0	140.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	bug_status	RECENT	2024-05-09 03:00:05.508023	False	322	323
5	NaN	2265	2024-05-07 17:30:31	323	5.0	213.200000	100.233228	140.0	140.0	140.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	keywords	RECENT	2024-05-09 03:00:05.508023	False	322	323
6	NaN	2286	2024-04-10 08:42:42	252	1.0	252.000000	NaN	252.0	252.0	252.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-04-30 23:59:59.000000	False	223	252
7	NaN	2305	2024-05-07 17:39:02	184	1.0	184.000000	NaN	184.0	184.0	184.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-09 03:00:05.508023	False	182	184
8	NaN	2313	2024-03-22 00:00:41	176	15.0	80.933333	74.071844	0.0	38.0	50.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	176
9	NaN	2314	2024-05-08 00:00:12	176	15.0	80.933333	74.071844	0.0	38.0	50.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-05-09 03:00:05.508023	False	0	176
10	NaN	2322	2024-04-16 16:49:30	154	1.0	154.000000	NaN	154.0	154.0	154.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59.000000	False	132	154
11	NaN	2330	2024-05-07 09:43:21	140	5.0	213.200000	100.233228	140.0	140.0	140.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	keywords	RECENT	2024-05-09 03:00:05.508023	False	138	140
12	NaN	2331	2024-05-07 09:43:47	140	3.0	140.000000	0.000000	140.0	140.0	140.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	keywords	RECENT	2024-05-09 03:00:05.508023	False	138	140
13	NaN	2332	2024-05-07 09:42:34	140	5.0	213.200000	100.233228	140.0	140.0	140.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-05-09 03:00:05.508023	False	138	140
14	NaN	2333	2024-05-07 09:44:04	140	3.0	140.000000	0.000000	140.0	140.0	140.0	...	NaN	NaT	NaN	NaN	resolution	RECENT	2024-05-09 03:00:05.508023	False	138	140
15	NaN	2334	2024-05-07 09:44:42	140	5.0	213.200000	100.233228	140.0	140.0	140.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-05-09 03:00:05.508023	False	138	140
16	NaN	2335	2024-05-07 09:54:15	140	3.0	140.000000	0.000000	140.0	140.0	140.0	...	NaN	NaT	NaN	NaN	resolution	RECENT	2024-05-09 03:00:05.508023	False	138	140
17	NaN	2338	2024-03-13 22:13:04	65	1.0	65.000000	NaN	65.0	65.0	65.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	1	65
18	NaN	2341	2024-05-08 00:00:19	62	9.0	132.000000	145.445866	55.0	58.0	59.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-09 03:00:05.508023	False	0	62
19	NaN	2342	2024-03-15 06:49:27	62	9.0	132.000000	145.445866	55.0	58.0	59.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	62
20	NaN	2343	2024-03-08 07:10:36	61	2.0	177.000000	164.048773	61.0	119.0	177.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	61

21 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs