Analysis of OSM events in Bugzilla

Date and time of the report: 2024-05-08 05:00:05.260251

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

Bugs considered recent: Since 2024-04-17.

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	2	17
LCM	9	1	10
MON	0	1	1
NG-SA	1	0	1
OSMClient	2	3	5
POL	1	0	1
RO	11	1	12
Robot-tests	0	8	8
Total	40	16	56

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	33	5	38
UNCONFIRMED	1	0	1
CONFIRMED	5	10	15
IN_PROGRESS	1	1	2
Total	40	16	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	64.000000	NaN	64.0	64.00	64.0	64.00	64.0
1	IM-NBI	17.0	122.882353	114.647766	0.0	43.00	50.0	179.00	375.0
2	LCM	10.0	130.600000	201.851541	35.0	36.00	38.0	41.75	601.0
3	MON	1.0	183.000000	NaN	183.0	183.00	183.0	183.00	183.0
4	NG-SA	1.0	98.000000	NaN	98.0	98.00	98.0	98.00	98.0
5	OSMClient	5.0	142.800000	171.718374	0.0	0.00	60.0	292.00	362.0
6	POL	1.0	42.000000	NaN	42.0	42.00	42.0	42.00	42.0
7	RO	12.0	122.416667	137.634865	0.0	54.75	58.0	108.50	390.0
8	Robot-tests	8.0	184.750000	84.712539	139.0	139.00	139.0	184.75	322.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
NG-SA	0	0	1	1.0
OSMClient	0	1	1	2.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	390	9.0	131.000	145.445866	54.0	57.00	58.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	390
1	NaN	2235	2024-03-11 17:25:51	385	9.0	131.000	145.445866	54.0	57.00	58.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	385
2	NaN	2355	2024-03-25 04:52:49	43	8.0	37.375	2.615203	35.0	35.75	37.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	43

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	375	2.0	368.000000	9.899495	361.0	364.50	368.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	375
1	NaN	2274	2024-05-07 17:51:14	292	2.0	176.000000	164.048773	60.0	118.00	176.0	...	deepika.e@tataelxsi.co.in	2023-07-31 23:59:59	CURRENT	1.0	bug_status	RECENT	2024-05-08 03:00:05.302377	False	292	292
2	NaN	2307	2024-04-22 00:00:10	181	14.0	85.714286	73.272336	0.0	39.25	49.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59.000000	False	0	181
3	NaN	2308	2024-04-22 00:00:12	181	14.0	85.714286	73.272336	0.0	39.25	49.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59.000000	False	0	181
4	NaN	2312	2024-03-19 00:00:37	179	14.0	85.714286	73.272336	0.0	39.25	49.5	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	179
5	NaN	2359	2024-03-29 08:26:14	39	2.0	19.500000	27.577164	0.0	9.75	19.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	39

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	601	1.0	601.000000	NaN	601.0	601.00	601.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-04-30 23:59:59.000000	False	138	601
1	NaN	2230	2024-03-11 17:25:47	406	1.0	406.000000	NaN	406.0	406.00	406.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	406
2	NaN	2243	2024-04-02 17:29:43	362	1.0	362.000000	NaN	362.0	362.00	362.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59.000000	False	305	362
3	NaN	2245	2024-04-02 17:35:28	361	2.0	368.000000	9.899495	361.0	364.50	368.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59.000000	False	0	361
4	NaN	2263	2024-05-07 17:30:10	322	5.0	212.200000	100.233228	139.0	139.00	139.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	bug_status	RECENT	2024-05-08 03:00:05.302377	False	322	322
5	NaN	2265	2024-05-07 17:30:31	322	5.0	212.200000	100.233228	139.0	139.00	139.0	...	ramerama@tataelxsi.co.in	2023-06-30 23:59:59	CURRENT	1.0	keywords	RECENT	2024-05-08 03:00:05.302377	False	322	322
6	NaN	2286	2024-04-10 08:42:42	251	1.0	251.000000	NaN	251.0	251.00	251.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-04-30 23:59:59.000000	False	223	251
7	NaN	2305	2024-05-07 17:39:02	183	1.0	183.000000	NaN	183.0	183.00	183.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-08 03:00:05.302377	False	182	183
8	NaN	2313	2024-03-22 00:00:41	175	14.0	85.714286	73.272336	0.0	39.25	49.5	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	175
9	NaN	2314	2024-05-07 07:32:43	175	14.0	85.714286	73.272336	0.0	39.25	49.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-05-08 03:00:05.302377	False	0	175
10	NaN	2322	2024-04-16 16:49:30	153	1.0	153.000000	NaN	153.0	153.00	153.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59.000000	False	132	153
11	NaN	2330	2024-05-07 09:43:21	139	5.0	212.200000	100.233228	139.0	139.00	139.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	keywords	RECENT	2024-05-08 03:00:05.302377	False	138	139
12	NaN	2331	2024-05-07 09:43:47	139	3.0	139.000000	0.000000	139.0	139.00	139.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	keywords	RECENT	2024-05-08 03:00:05.302377	False	138	139
13	NaN	2332	2024-05-07 09:42:34	139	5.0	212.200000	100.233228	139.0	139.00	139.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-05-08 03:00:05.302377	False	138	139
14	NaN	2333	2024-05-07 09:44:04	139	3.0	139.000000	0.000000	139.0	139.00	139.0	...	NaN	NaT	NaN	NaN	resolution	RECENT	2024-05-08 03:00:05.302377	False	138	139
15	NaN	2334	2024-05-07 09:44:42	139	5.0	212.200000	100.233228	139.0	139.00	139.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-05-08 03:00:05.302377	False	138	139
16	NaN	2335	2024-05-07 09:54:15	139	3.0	139.000000	0.000000	139.0	139.00	139.0	...	NaN	NaT	NaN	NaN	resolution	RECENT	2024-05-08 03:00:05.302377	False	138	139
17	NaN	2337	2024-04-08 00:00:50	98	1.0	98.000000	NaN	98.0	98.00	98.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59.000000	False	0	98
18	NaN	2338	2024-03-13 22:13:04	64	1.0	64.000000	NaN	64.0	64.00	64.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	1	64
19	NaN	2341	2024-03-07 11:14:15	61	9.0	131.000000	145.445866	54.0	57.00	58.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59.000000	False	0	61
20	NaN	2342	2024-03-15 06:49:27	61	9.0	131.000000	145.445866	54.0	57.00	58.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