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