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 & Development
September to December 2020

December 2020
  • Created / modified QA tests for 15 tracker tickets
  • Found / reported bugs: CORE-6460
  • OLTP-EMUL: reworked CONNECT/DISCONNECT triggers because of new system variable RESETTING
  • OLTP-EMUL: developed reports for estimating efficiency of ExtConnPool usage
  • Reported test for CORE-2668 hanging on build 3.0.8.33400 (Classic)
  • OLTP-EMUL: re-implemented exceptions handling block
  • Refactored several tests after noticing false failures on build 4.0.0.2298 (related to the results ordering)
November 2020
  • Created / modified QA tests for ~50 tracker tickets
  • Found / reported bugs: CORE-6441, CORE-6445, CORE-6447, CORE-6450, CORE-6453
  • OLTP-EMUL: updated table fb_errors with actual gdscodes and messages text
  • Reported build 4.0.0.2260 crash while executing "ALTER EXTERNAL CONNECTIONS POOL CLEAR ALL"
  • fbt_cross_report: changed SIMILAR-TO pattern for detect message about possible FB crash
  • OLTP-EMUL, regular launches on POSIX host: multiple crashes since build 4.0.0.2271
  • OLTP-EMUL: deep rework related to test External Connections Pool feature
  • OLTP-EMUL: reported two crashes on build 3.0.8.33392 (SS, Linux)
  • Investigated how different context variables from the SYSTEM namespace affects the performance
  • OLTP-EMUL: reported several crashes on build 4.0.0.2272
October 2020
  • Created / modified QA tests for ~20 tracker tickets
  • Found / reported bugs: CORE-6414, CORE-6415
  • OLTP-EMUL: checked build 33357 (compiled with gcc 4.8.3)
  • OLTP-EMUL: reported crashing build 4.0.0.2214 SS when changing DB state to full shutdown + several runs testing the fix
  • Refactored auxiliary script that runs .fbt-tests
  • CORE-5302: reported performance regression since Jan-2020
  • Refactored script that checks FB crashes on Windows (watch4dumps.bat)
  • Read consistency / statement-level restarts: started to implement tests which use PSQL
  • Reported crash on FB 3.x and 4.x when PSQL code contains infinite loop of SP calls
  • Reported unexpected SQLSTATE while running test for CORE-5685
  • Implemented test checking presence of all necessary files inside the snapshot build
  • Reported failed tests for CORE-3639 and CORE-6285
  • OLTP-EMUL: reported crash on build 4.0.0.2228, related to setLockAttachment
September 2020
  • Created / modified QA tests for 7 tracker tickets
  • Found / reported bugs: CORE-6411
  • Refactored tests functional/transactions/read-consist-sttm-restart*
  • fbt-cross-report: implemented new report that shows distribution of known (standard) FB errors per tests/builds
  • Fixed script that makes FB snapshot builds
  • Reported fbt-run hanging on 4.0.0.2194 Classic during test for CORE-4298
  • Reported several crashes for OLTP-EMUL when DB is in backup-lock state
  • Reported crashing build 4.0.0.2195 when ran .sql with mon$ queries
  • Tested VARCHAR vs BLOB network transmission performance, with/without WireCompression
  • Finished creation of SQL-related tests for check statement-level restart
  • OLTP-EMUL: several changes / improvements

Pavel Zotov
Moscow, Russian Federation
 
September to December 2020

December 2020
  • Created / modified QA tests for 15 tracker tickets
  • Found / reported bugs: CORE-6460
  • OLTP-EMUL: reworked CONNECT/DISCONNECT triggers because of new system variable RESETTING
  • OLTP-EMUL: developed reports for estimating efficiency of ExtConnPool usage
  • Reported test for CORE-2668 hanging on build 3.0.8.33400 (Classic)
  • OLTP-EMUL: re-implemented exceptions handling block
  • Refactored several tests after noticing false failures on build 4.0.0.2298 (related to the results ordering)
November 2020
  • Created / modified QA tests for ~50 tracker tickets
  • Found / reported bugs: CORE-6441, CORE-6445, CORE-6447, CORE-6450, CORE-6453
  • OLTP-EMUL: updated table fb_errors with actual gdscodes and messages text
  • Reported build 4.0.0.2260 crash while executing "ALTER EXTERNAL CONNECTIONS POOL CLEAR ALL"
  • fbt_cross_report: changed SIMILAR-TO pattern for detect message about possible FB crash
  • OLTP-EMUL, regular launches on POSIX host: multiple crashes since build 4.0.0.2271
  • OLTP-EMUL: deep rework related to test External Connections Pool feature
  • OLTP-EMUL: reported two crashes on build 3.0.8.33392 (SS, Linux)
  • Investigated how different context variables from the SYSTEM namespace affects the performance
  • OLTP-EMUL: reported several crashes on build 4.0.0.2272
October 2020
  • Created / modified QA tests for ~20 tracker tickets
  • Found / reported bugs: CORE-6414, CORE-6415
  • OLTP-EMUL: checked build 33357 (compiled with gcc 4.8.3)
  • OLTP-EMUL: reported crashing build 4.0.0.2214 SS when changing DB state to full shutdown + several runs testing the fix
  • Refactored auxiliary script that runs .fbt-tests
  • CORE-5302: reported performance regression since Jan-2020
  • Refactored script that checks FB crashes on Windows (watch4dumps.bat)
  • Read consistency / statement-level restarts: started to implement tests which use PSQL
  • Reported crash on FB 3.x and 4.x when PSQL code contains infinite loop of SP calls
  • Reported unexpected SQLSTATE while running test for CORE-5685
  • Implemented test checking presence of all necessary files inside the snapshot build
  • Reported failed tests for CORE-3639 and CORE-6285
  • OLTP-EMUL: reported crash on build 4.0.0.2228, related to setLockAttachment
September 2020
  • Created / modified QA tests for 7 tracker tickets
  • Found / reported bugs: CORE-6411
  • Refactored tests functional/transactions/read-consist-sttm-restart*
  • fbt-cross-report: implemented new report that shows distribution of known (standard) FB errors per tests/builds
  • Fixed script that makes FB snapshot builds
  • Reported fbt-run hanging on 4.0.0.2194 Classic during test for CORE-4298
  • Reported several crashes for OLTP-EMUL when DB is in backup-lock state
  • Reported crashing build 4.0.0.2195 when ran .sql with mon$ queries
  • Tested VARCHAR vs BLOB network transmission performance, with/without WireCompression
  • Finished creation of SQL-related tests for check statement-level restart
  • OLTP-EMUL: several changes / improvements

Pavel Zotov
Moscow, Russian Federation