Analysis of OSM events in Bugzilla

Date and time of the report: 2024-05-02 05:00:05.435129

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

Bugs considered recent: Since 2024-04-11.

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	14	1	15
LCM	7	3	10
NG-SA	1	0	1
NG-UI	3	0	3
OSMClient	3	0	3
POL	1	0	1
RO	11	0	11
Robot-tests	3	0	3
Total	45	4	49

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	41	0	41
UNCONFIRMED	1	0	1
CONFIRMED	3	2	5
IN_PROGRESS	0	2	2
Total	45	4	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	58.000000	NaN	58.0	58.0	58.0	58.00	58.0
1	Documentation / Wiki	1.0	335.000000	NaN	335.0	335.0	335.0	335.00	335.0
2	IM-NBI	15.0	133.266667	112.147522	30.0	40.0	147.0	174.00	369.0
3	LCM	10.0	124.600000	201.851541	29.0	30.0	32.0	35.75	595.0
4	NG-SA	1.0	92.000000	NaN	92.0	92.0	92.0	92.00	92.0
5	NG-UI	3.0	55.333333	1.154701	54.0	55.0	56.0	56.00	56.0
6	OSMClient	3.0	248.333333	168.624830	54.0	194.5	335.0	345.50	356.0
7	POL	1.0	36.000000	NaN	36.0	36.0	36.0	36.00	36.0
8	RO	11.0	127.545455	138.574430	33.0	50.0	52.0	150.00	384.0
9	Robot-tests	3.0	200.333333	116.624754	133.0	133.0	133.0	234.00	335.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	384	9.0	125.000	145.445866	48.0	51.00	52.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	384
1	NaN	2235	2024-03-11 17:25:51	379	9.0	125.000	145.445866	48.0	51.00	52.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	379
2	NaN	2355	2024-03-25 04:52:49	37	8.0	31.375	2.615203	29.0	29.75	31.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	37

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	369	2.0	362.0	9.899495	355.0	358.50	362.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	369
1	NaN	2251	2024-03-13 00:00:17	335	2.0	194.5	198.697006	54.0	124.25	194.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	335
2	NaN	2253	2024-03-13 00:00:21	335	2.0	234.0	142.835570	133.0	183.50	234.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	335
3	NaN	2307	2024-04-22 00:00:10	175	12.0	94.0	69.184864	30.0	37.00	44.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	175
4	NaN	2308	2024-04-22 00:00:12	175	12.0	94.0	69.184864	30.0	37.00	44.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	175
5	NaN	2312	2024-03-19 00:00:37	173	12.0	94.0	69.184864	30.0	37.00	44.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	173

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	595	1.0	595.0	NaN	595.0	595.0	595.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-04-30 23:59:59	False	138	595
1	NaN	2230	2024-03-11 17:25:47	400	1.0	400.0	NaN	400.0	400.0	400.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	400
2	NaN	2243	2024-04-02 17:29:43	356	1.0	356.0	NaN	356.0	356.0	356.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	305	356
3	NaN	2245	2024-04-02 17:35:28	355	2.0	362.0	9.899495	355.0	358.5	362.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	0	355
4	NaN	2252	2024-03-13 00:00:19	335	1.0	335.0	NaN	335.0	335.0	335.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	335
5	NaN	2286	2024-04-10 08:42:42	245	1.0	245.0	NaN	245.0	245.0	245.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-04-30 23:59:59	False	223	245
6	NaN	2313	2024-03-22 00:00:41	169	12.0	94.0	69.184864	30.0	37.0	44.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	169
7	NaN	2314	2024-04-22 00:00:14	169	12.0	94.0	69.184864	30.0	37.0	44.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	169
8	NaN	2322	2024-04-16 16:49:30	147	1.0	147.0	NaN	147.0	147.0	147.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	132	147
9	NaN	2326	2024-04-07 00:00:42	133	1.0	133.0	NaN	133.0	133.0	133.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-04-30 23:59:59	False	0	133
10	NaN	2332	2024-04-04 00:00:48	133	2.0	234.0	142.835570	133.0	183.5	234.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	0	133
11	NaN	2337	2024-04-08 00:00:50	92	1.0	92.0	NaN	92.0	92.0	92.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	0	92

12 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs