Analysis of OSM events in Bugzilla

Date and time of the report: 2024-04-22 05:00:05.059968

Analysed period: 2020-07-01 to 2024-04-22.

Bugs considered recent: Since 2024-04-01.

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:

49

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

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
DEVOPS	1	0	1
Documentation / Wiki	1	0	1
IM-NBI	13	2	15
LCM	5	5	10
NG-SA	1	0	1
NG-UI	3	0	3
OSMClient	3	0	3
POL	1	0	1
RO	10	1	11
Robot-tests	3	0	3
Total	41	8	49

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	38	4	42
UNCONFIRMED	0	1	1
CONFIRMED	3	2	5
IN_PROGRESS	0	1	1
Total	41	8	49

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	48.000000	NaN	48.0	48.0	48.0	48.00	48.0
1	Documentation / Wiki	1.0	325.000000	NaN	325.0	325.0	325.0	325.00	325.0
2	IM-NBI	15.0	123.266667	112.147522	20.0	30.0	137.0	164.00	359.0
3	LCM	10.0	114.600000	201.851541	19.0	20.0	22.0	25.75	585.0
4	NG-SA	1.0	82.000000	NaN	82.0	82.0	82.0	82.00	82.0
5	NG-UI	3.0	45.333333	1.154701	44.0	45.0	46.0	46.00	46.0
6	OSMClient	3.0	238.333333	168.624830	44.0	184.5	325.0	335.50	346.0
7	POL	1.0	26.000000	NaN	26.0	26.0	26.0	26.00	26.0
8	RO	11.0	117.545455	138.574430	23.0	40.0	42.0	140.00	374.0
9	Robot-tests	3.0	190.333333	116.624754	123.0	123.0	123.0	224.00	325.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
Documentation / Wiki	0	0	1	1.0
IM-NBI	0	4	4	8.0
LCM	1	0	2	3.0
NG-SA	0	0	1	1.0
OSMClient	0	1	1	2.0
RO	2	0	1	3.0
Robot-tests	0	1	2	3.0
All	3	6	12	21.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	374	9.0	115.000	145.445866	38.0	41.00	42.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	374
1	NaN	2235	2024-03-11 17:25:51	369	9.0	115.000	145.445866	38.0	41.00	42.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	369
2	NaN	2355	2024-03-25 04:52:49	27	8.0	21.375	2.615203	19.0	19.75	21.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	27

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	359	2.0	352.0	9.899495	345.0	348.50	352.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	359
1	NaN	2251	2024-03-13 00:00:17	325	2.0	184.5	198.697006	44.0	114.25	184.5	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2024-03-31 23:59:59	False	0	325
2	NaN	2253	2024-03-13 00:00:21	325	2.0	224.0	142.835570	123.0	173.50	224.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2024-03-31 23:59:59	False	0	325
3	NaN	2307	2024-02-20 16:25:14	165	12.0	84.0	69.184864	20.0	27.00	34.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	165
4	NaN	2308	2024-02-20 16:24:22	165	12.0	84.0	69.184864	20.0	27.00	34.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59	False	0	165
5	NaN	2312	2024-03-19 00:00:37	163	12.0	84.0	69.184864	20.0	27.00	34.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	163

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	585	1.0	585.0	NaN	585.0	585.0	585.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2024-04-22 03:00:05.093418	False	138	585
1	NaN	2230	2024-03-11 17:25:47	390	1.0	390.0	NaN	390.0	390.0	390.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	390
2	NaN	2243	2024-04-02 17:29:43	346	1.0	346.0	NaN	346.0	346.0	346.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-22 03:00:05.093418	False	305	346
3	NaN	2245	2024-04-02 17:35:28	345	2.0	352.0	9.899495	345.0	348.5	352.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-22 03:00:05.093418	False	0	345
4	NaN	2252	2024-03-13 00:00:19	325	1.0	325.0	NaN	325.0	325.0	325.0	...	selvi.j@tataelxsi.co.in	2023-08-31 23:59:59	CURRENT	2.0	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	325
5	NaN	2286	2024-04-10 08:42:42	235	1.0	235.0	NaN	235.0	235.0	235.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-04-22 03:00:05.093418	False	223	235
6	NaN	2313	2024-03-22 00:00:41	159	12.0	84.0	69.184864	20.0	27.0	34.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59.000000	False	0	159
7	NaN	2314	2024-02-20 16:27:21	159	12.0	84.0	69.184864	20.0	27.0	34.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-02-29 23:59:59.000000	False	0	159
8	NaN	2322	2024-04-16 16:49:30	137	1.0	137.0	NaN	137.0	137.0	137.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-22 03:00:05.093418	False	132	137
9	NaN	2326	2024-04-07 00:00:42	123	1.0	123.0	NaN	123.0	123.0	123.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	RECENT	2024-04-22 03:00:05.093418	False	0	123
10	NaN	2332	2024-04-04 00:00:48	123	2.0	224.0	142.835570	123.0	173.5	224.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-22 03:00:05.093418	False	0	123
11	NaN	2337	2024-04-08 00:00:50	82	1.0	82.0	NaN	82.0	82.0	82.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-22 03:00:05.093418	False	0	82

12 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs