Join Firebird!

Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses

Follow Us

Select your media preference

Newsletter

Subscribe to Firebird’s Newsletter to receive the latest news

Developer's Report: QA Stress Testing & Tools Development
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
 
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