win-4x yet_perf

01. Total results for each kind of outcome and server mode, for previous 30 runs
02. NEW CRASHES/BUGCHECKS: tests that caused FB abnormal termination for LAST run (0 rows)
03. NEW FAILS: tests which failed for LAST run (0 rows)
04. NEW ERRORS: tests which raised runtime error for LAST run (0 rows)
04. STILL FAILS: tests which fail for at least TWO LAST runs (0 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (0 rows)
[CURRENT] 06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (6 rows)
07. Has fails: tests with at least one fail for previous 30 runs (8 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (2 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (0 rows)
10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (1 rows)
11. All tests: outcomes for previous 30 runs (2452 rows)
12. Skipped: tests which was intentionally excluded from execution (66 rows)

Generated UTC 31.03.2025 06:40
Tested: FB40. Build / date: 4.0.6.3195-b9faf7a4 / 2025.03.28;
Test machine: Windows 10 10.0.19045; logical CPUs: 8; RAM: 31 Gb
QA software: Python: 3.11.2; pytest: 7.4.4; firebird.driver: 1.10.9; firebird.Qa: 0.19.3
Jump to the list of unique test names from this report
Jump to the list with last developing commits information

Performance slowdown for more than 5 recent runs - moving medians

At least 2 recent moving medians (window = 5) greater than "normal" for at least 1.5x. No more than 50 rows are shown, pre-filtered in descending order of ratio between latest and "normal" medians:

NN	Test name	mode	Test last update	4.0.6.3195 2025.03.28 b9faf	4.0.6.3194 2025.03.27 ab754	4.0.6.3194 2025.03.26 912aa	4.0.6.3193 2025.03.20 80234	4.0.6.3192 2025.03.13 2a9da	4.0.6.3191 2025.03.10 3d9fd	4.0.6.3190 2025.02.25 c9928	4.0.6.3189 2025.02.22 3fb0b	4.0.6.3188 2025.02.21 8ee1c	4.0.6.3186 2025.02.19 92cb6	4.0.6.3185 2025.02.16 9cac4	4.0.6.3183 2025.02.04 bf738	4.0.6.3181 2025.02.01 00b64	4.0.6.3180 2025.01.27 2edb8	4.0.6.3179 2025.01.24 008d4	4.0.6.3178 2025.01.20 ec94d	4.0.6.3176 2025.01.16 79cc1	4.0.6.3175 2025.01.15 91361	4.0.6.3174 2024.12.23 ffd39	4.0.6.3173 2024.12.19 60b32	4.0.6.3172 2024.12.11 33f5d	4.0.6.3171 2024.12.10 ab1d4	4.0.6.3170 2024.12.02 68abd	4.0.6.3169 2024.11.28 1673f	4.0.6.3168 2024.11.27 7fffc	4.0.6.3168 2024.11.07 f67e2	Test TITLE
1	bugs core 0214 tracker	CS	2025.01.18 11:26	21770	21754	21726	21726	21540	21540	21726	21709	21756	21756	21709	21705	21705	21705	21705	21776	21776	21776	21878	21878	21775	21775	2283	2283	2271	2271	Count (DISTINCT ...) is too slow
2	bugs core 0214 tracker	SS	2025.01.18 11:26	21443	21459	21443	21443	21283	21283	21283	21433	21433	21433	21093	21093	21093	21119	21119	21544	21119	21624	21156	21267	21156	21156	1988	1988	1988	1992	Count (DISTINCT ...) is too slow
3	bugs core 3549 tracker	CS	2022.02.02 14:46	6163	6086	6066	6066	6086	6109	6111	6111	6109	6034	2590	2224	2060	2039	2039	1859	1859	1859	2051	2042	2047	2042	2042	2042	1824	1824	Database corruption after end of session : page xxx is of wrong type expected 4 found 7
4	bugs core 3549 tracker	SS	2022.02.02 14:46	5710	5710	5765	5768	5767	5796	5796	5782	5767	5712	1421	1401	1398	1398	1392	1398	1392	1392	1405	1405	1394	1394	1394	1394	1394	1394	Database corruption after end of session : page xxx is of wrong type expected 4 found 7
5	bugs gh 8178 addi tracker	CS	2024.07.12 10:11	2260	2262	2260	2254	2254	2254	2246	2214	2214	2206	1418	1418	1418	1424	1424	1427	1427	1424	1421	1438	1434	1421	1411	1414	1414	1414	Check result of conversion to string in COALESCE that involves all families of data types.
6	bugs gh 8178 addi tracker	SS	2024.07.12 10:11	2039	2058	2058	2053	2018	2053	2025	2018	2018	2006	1331	1263	1201	1201	1197	1201	1197	1197	1208	1211	1211	1211	1211	1217	1251	1235	Check result of conversion to string in COALESCE that involves all families of data types.

Elapsed time, milliseconds:

NN	Test name	mode	Test last update	4.0.6.3195 2025.03.28 b9faf	4.0.6.3194 2025.03.27 ab754	4.0.6.3194 2025.03.26 912aa	4.0.6.3193 2025.03.20 80234	4.0.6.3192 2025.03.13 2a9da	4.0.6.3191 2025.03.10 3d9fd	4.0.6.3190 2025.02.25 c9928	4.0.6.3189 2025.02.22 3fb0b	4.0.6.3188 2025.02.21 8ee1c	4.0.6.3186 2025.02.19 92cb6	4.0.6.3185 2025.02.16 9cac4	4.0.6.3183 2025.02.04 bf738	4.0.6.3181 2025.02.01 00b64	4.0.6.3180 2025.01.27 2edb8	4.0.6.3179 2025.01.24 008d4	4.0.6.3178 2025.01.20 ec94d	4.0.6.3176 2025.01.16 79cc1	4.0.6.3175 2025.01.15 91361	4.0.6.3174 2024.12.23 ffd39	4.0.6.3173 2024.12.19 60b32	4.0.6.3172 2024.12.11 33f5d	4.0.6.3171 2024.12.10 ab1d4	4.0.6.3170 2024.12.02 68abd	4.0.6.3169 2024.11.28 1673f	4.0.6.3168 2024.11.27 7fffc	4.0.6.3168 2024.11.07 f67e2	4.0.6.3167 2024.11.04 c9228	4.0.6.3165 2024.10.23 b0c36	4.0.6.3164 2024.10.17 35344	4.0.6.3161 2024.10.05 91502	Test TITLE
1	bugs core 0214 tracker	CS	2025.01.18 11:26	22107	21754	21564	21770	21948	21540	21726	21429	21527	22254	21975	21709	21756	21681	21626	21705	22094	21776	21483	22083	21605	21878	22620	21775	2225	2271	2283	2491	2252	2203	Count (DISTINCT ...) is too slow
2	bugs core 0214 tracker	SS	2025.01.18 11:26	21186	21708	21069	21443	21459	21609	21283	20883	20937	21991	21797	21433	20963	20958	21093	21544	21119	21624	21026	21657	21056	21627	21156	21267	1972	1977	1988	1995	1992	2443	Count (DISTINCT ...) is too slow
3	bugs core 3549 tracker	CS	2022.02.02 14:46	6163	6356	6195	6066	6086	5994	5944	6136	6111	6109	6346	6034	2060	2224	2590	2039	1845	1859	2051	1783	2064	1786	3139	2042	2047	1765	1772	2049	1824	2026	Database corruption after end of session : page xxx is of wrong type expected 4 found 7
4	bugs core 3549 tracker	SS	2022.02.02 14:46	5611	5640	5765	5768	5710	5588	5909	5798	5767	5796	5782	5712	1390	1421	1392	1401	1398	1391	1387	1419	1392	1418	1405	1389	1394	1394	1394	1385	1418	1462	Database corruption after end of session : page xxx is of wrong type expected 4 found 7
5	bugs gh 8178 addi tracker	CS	2024.07.12 10:11	2229	2554	2260	2297	2215	2262	2254	2212	2532	2246	2206	2214	1410	1398	1418	1500	1427	1424	1400	1454	1438	1421	1411	1507	1434	1402	1395	1414	1441	1429	Check result of conversion to string in COALESCE that involves all families of data types.
6	bugs gh 8178 addi tracker	SS	2024.07.12 10:11	2006	2039	2058	2088	2013	2336	2053	2018	2018	2066	2025	2006	1331	1263	1197	1201	1201	1196	1197	1359	1194	1208	1211	1217	1275	1209	1207	1251	1290	1235	Check result of conversion to string in COALESCE that involves all families of data types.

List of tests in this report:

http://tracker.firebirdsql.org/browse/CORE-214
http://tracker.firebirdsql.org/browse/CORE-3549
https://github.com/FirebirdSQL/firebird/issues/8178

=== end of list ===

Performance slowdown for more than 5 recent runs - moving medians

Elapsed time, milliseconds:

List of tests in this report:

Last commits information (all timestamps in UTC):