Analysis of OSM events in Bugzilla

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

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

Bugs considered recent: Since 2024-04-12.

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	59.000000	NaN	59.0	59.0	59.0	59.00	59.0
1	Documentation / Wiki	1.0	336.000000	NaN	336.0	336.0	336.0	336.00	336.0
2	IM-NBI	15.0	134.266667	112.147522	31.0	41.0	148.0	175.00	370.0
3	LCM	10.0	125.600000	201.851541	30.0	31.0	33.0	36.75	596.0
4	NG-SA	1.0	93.000000	NaN	93.0	93.0	93.0	93.00	93.0
5	NG-UI	3.0	56.333333	1.154701	55.0	56.0	57.0	57.00	57.0
6	OSMClient	3.0	249.333333	168.624830	55.0	195.5	336.0	346.50	357.0
7	POL	1.0	37.000000	NaN	37.0	37.0	37.0	37.00	37.0
8	RO	11.0	128.545455	138.574430	34.0	51.0	53.0	151.00	385.0
9	Robot-tests	3.0	201.333333	116.624754	134.0	134.0	134.0	235.00	336.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	385	9.0	126.000	145.445866	49.0	52.00	53.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	385
1	NaN	2235	2024-03-11 17:25:51	380	9.0	126.000	145.445866	49.0	52.00	53.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	380
2	NaN	2355	2024-03-25 04:52:49	38	8.0	32.375	2.615203	30.0	30.75	32.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	38

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	370	2.0	363.0	9.899495	356.0	359.50	363.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-03-31 23:59:59	False	0	370
1	NaN	2251	2024-03-13 00:00:17	336	2.0	195.5	198.697006	55.0	125.25	195.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	336
2	NaN	2253	2024-03-13 00:00:21	336	2.0	235.0	142.835570	134.0	184.50	235.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	336
3	NaN	2307	2024-04-22 00:00:10	176	12.0	95.0	69.184864	31.0	38.00	45.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	176
4	NaN	2308	2024-04-22 00:00:12	176	12.0	95.0	69.184864	31.0	38.00	45.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	176
5	NaN	2312	2024-03-19 00:00:37	174	12.0	95.0	69.184864	31.0	38.00	45.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	174

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	596	1.0	596.0	NaN	596.0	596.0	596.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-04-30 23:59:59	False	138	596
1	NaN	2230	2024-03-11 17:25:47	401	1.0	401.0	NaN	401.0	401.0	401.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	401
2	NaN	2243	2024-04-02 17:29:43	357	1.0	357.0	NaN	357.0	357.0	357.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	305	357
3	NaN	2245	2024-04-02 17:35:28	356	2.0	363.0	9.899495	356.0	359.5	363.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	0	356
4	NaN	2252	2024-03-13 00:00:19	336	1.0	336.0	NaN	336.0	336.0	336.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	336
5	NaN	2286	2024-04-10 08:42:42	246	1.0	246.0	NaN	246.0	246.0	246.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-04-30 23:59:59	False	223	246
6	NaN	2313	2024-03-22 00:00:41	170	12.0	95.0	69.184864	31.0	38.0	45.0	...	NaN	NaT	NaN	NaN	keywords	CURRENT	2024-03-31 23:59:59	False	0	170
7	NaN	2314	2024-04-22 00:00:14	170	12.0	95.0	69.184864	31.0	38.0	45.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	0	170
8	NaN	2322	2024-04-16 16:49:30	148	1.0	148.0	NaN	148.0	148.0	148.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-04-30 23:59:59	False	132	148
9	NaN	2326	2024-04-07 00:00:42	134	1.0	134.0	NaN	134.0	134.0	134.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	comment	CURRENT	2024-04-30 23:59:59	False	0	134
10	NaN	2332	2024-04-04 00:00:48	134	2.0	235.0	142.835570	134.0	184.5	235.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	0	134
11	NaN	2337	2024-04-08 00:00:50	93	1.0	93.0	NaN	93.0	93.0	93.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-04-30 23:59:59	False	0	93

12 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs