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