October 2018 - January 2019
October 2018
- Found / reported bugs: CORE-5931, CORE-5944, CORE-5957
- OLTP-EMUL: new config parameter 'update_conflict_percent' was introduced
- OLTP-EMUL: introduced config parameter 'max_cps' (Max Connections Per Second)
- OLTP-EMUL: refactored all report procedures in order to improve performance
- OLTP-EMUL: refactoring, added UDF 'sleep()' for delays between business operations
- OLTP-EMUL: a number of tests to get maximum number of connections (result is 1300..4500 depending on the load and OS settings)
- OLTP-EMUL, LI-V3.0.4.33065 SS: started investigating how DB encryption affects the performance
November 2018
- Found / reported bugs: CORE-5962, CORE-5964
- OLTP-EMUL: migration from svn to git
- OLTP-EMUL, FB 3.0.4.33065, SS: replication performance benchmark (result is ~20% slowdown)
- OLTP-EMUL, FB 3.0.4.33065, SS: encryption performance benchmark (result is ~55% slowdown)
- OLTP-EMUL: misc refactoring
- Reproduced crash of trace session (fbsvcmgr.exe) with "Unknown tag (0) in isc_svc_query() results" message
- FB 3.0.4.33065: poor scalability in SS vs SC/CS for query that deals with single data page
December 2018
- Created / modified QA tests for 12 tracker tickets
- Implemented test for watching size of used temp space when external sort occurs
- Found that process of DB restore is too long when it is started by non-DBA
- OLTP-EMUL, 2.5 SC, 3.0 SC and 3.0 SS (both on FW = ON and OFF): MON$ access benchmark, found problems in v3 (especially SS)
- OLTP-EMUL: misc improvements
- Detected v4 hang while working with test for CORE-733 and enabled connection pool
January 2019
- Found / reported bugs: CORE-5984, CORE-5985, CORE-5994
- Created / modified QA tests for 20 tracker tickets
- Deeply refactored batch scenario ("rundaily.bat") that launches fbt_run on WinCompile VM
- Refactored batch scenario that watches for crashes on WinCompile VM
- OLTP-EMUL: got broken index on 3.0.5.33085 after workload 100 attachments during 3 hours
- OLTP-EMUL, 100 attachments during 7 hour, 3.0.5 SC: >100M sequential reads from RDB$PAGES
- OLTP-EMUL: misc refactoring
- Found v4 regresson: non-privileged user is unable to see its own attachments from other hosts
- Zero division error is not raised when calling udf_compat!UC_div with 0 as denominator
- Output of "udf_compat!UC_dow" is incorrect for 4.0.0.1378 when OS codepage distinct from ASCII
- Disk cleanup on WinCompile VM
Pavel Zotov
Moscow, Russian Federation
