Generated 29.03.2024 07:46
Tested: FB50. Build: 5.0.1.1372; SS: 29.03.24 05:58:45 - 29.03.24 06:44:15; CS: 29.03.24 06:45:26 - 29.03.24 07:45:32;
OS and hardware info: Linux 6.5.0-5-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.5.13-1 (2023-11-29) ; logical CPUs: 2 ; total memory: 7.6 Gb
QA-software: Python 3.11.7, virtual env; pytest: 7.4.4; firebird.driver: 1.10.1; Firebird.Qa: 0.19.1
NN | Test name | mode | 5.0.1.1372 2024-03-29 |
5.0.1.1371 2024-03-24 |
5.0.1.1370 2024-03-22 |
5.0.1.1369 2024-03-17 |
5.0.1.1368 2024-03-16 |
5.0.1.1363 2024-03-15 |
5.0.1.1360 2024-03-14 |
5.0.1.1358 2024-03-13 |
5.0.1.1348 2024-03-09 |
5.0.1.1347 2024-03-05 |
5.0.1.1344 2024-02-21 |
5.0.1.1342 2024-02-19 |
5.0.1.1340 2024-02-18 |
5.0.1.1339 2024-02-13 |
5.0.1.1338 2024-02-12 |
5.0.1.1336 2024-02-11 |
5.0.1.1335 2024-02-10 |
5.0.1.1332 2024-02-07 |
5.0.1.1331 2024-02-04 |
5.0.1.1330 2024-02-03 |
5.0.1.1329 2024-02-02 |
5.0.1.1328 2024-01-31 |
5.0.1.1327 2024-01-30 |
5.0.1.1325 2024-01-26 |
5.0.1.1324 2024-01-25 |
5.0.1.1322 2024-01-24 |
5.0.1.1316 2024-01-17 |
5.0.0.1305 2023-12-31 |
5.0.0.1304 2023-12-19 |
5.0.0.1303 2023-12-15 |
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | Suboptimal join plan if there are selective non-indexed predicates involved |
|
2 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | Suboptimal join plan if there are selective non-indexed predicates involved |
|
3 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT |
|
4 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | Alter computed field type does not work |
|
5 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | Alter computed field type does not work |
|
6 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work |
|
7 | CS | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Slow changes on domain |
|
8 | SS | F | F | F | F | F | F | F | F | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | Slow changes on domain |
|
9 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified) |
|
10 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | The size of the database with big records becomes bigger after backup/restore |
|
11 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | garbage collection in indexes and blobs is not performed in VIO_backout |
|
12 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | INNER JOIN join order LIKE and STARTING WITH |
|
13 | SS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | INNER JOIN join order LIKE and STARTING WITH |
|
14 | CS | P | F | F | F | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Bugcheck 183 (wrong record length) could happen on replica database after UK violation on insert DESCRIPTION Test temporary changes mode of replica to READ-WRITE. We create table 'PERF_AGG' on master with PK-column and UNIQUE constraint for other several columns (<S>) After this we wait until replica becomes actual to master, and this delay will last no more then threshold that is defined by MAX_TIME_FOR_WAIT_DATA_IN_REPLICA variable (measured in seconds), see QA_ROOT/files/test_config.ini Then we change mode of replica to *READ-WRITE* and add record in its 'PERF_AGG' table. After this, we add record in master 'PERF_AGG' with same values in <S> (but value in PK differs from replica one). This causes violation of UNIQUE index in replica DB but no error must raise (UPDATE should be with warning). We monintor replication.log until appropriate message appear in it. |
|
15 | SS | P | F | F | F | P | P | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Bugcheck 183 (wrong record length) could happen on replica database after UK violation on insert DESCRIPTION Test temporary changes mode of replica to READ-WRITE. We create table 'PERF_AGG' on master with PK-column and UNIQUE constraint for other several columns (<S>) After this we wait until replica becomes actual to master, and this delay will last no more then threshold that is defined by MAX_TIME_FOR_WAIT_DATA_IN_REPLICA variable (measured in seconds), see QA_ROOT/files/test_config.ini Then we change mode of replica to *READ-WRITE* and add record in its 'PERF_AGG' table. After this, we add record in master 'PERF_AGG' with same values in <S> (but value in PK differs from replica one). This causes violation of UNIQUE index in replica DB but no error must raise (UPDATE should be with warning). We monintor replication.log until appropriate message appear in it. |
|
16 | CS | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | F | P | P | P | External Connections Pool, functionality test 01 |
NN | Test name | mode | median_ms | 5.0.1.1372 2024-03-29 |
5.0.1.1371 2024-03-24 |
5.0.1.1370 2024-03-22 |
5.0.1.1369 2024-03-17 |
5.0.1.1368 2024-03-16 |
5.0.1.1363 2024-03-15 |
5.0.1.1360 2024-03-14 |
5.0.1.1358 2024-03-13 |
5.0.1.1348 2024-03-09 |
5.0.1.1347 2024-03-05 |
5.0.1.1344 2024-02-21 |
5.0.1.1342 2024-02-19 |
5.0.1.1340 2024-02-18 |
5.0.1.1339 2024-02-13 |
5.0.1.1338 2024-02-12 |
5.0.1.1336 2024-02-11 |
5.0.1.1335 2024-02-10 |
5.0.1.1332 2024-02-07 |
5.0.1.1331 2024-02-04 |
5.0.1.1330 2024-02-03 |
5.0.1.1329 2024-02-02 |
5.0.1.1328 2024-01-31 |
5.0.1.1327 2024-01-30 |
5.0.1.1325 2024-01-26 |
5.0.1.1324 2024-01-25 |
5.0.1.1322 2024-01-24 |
5.0.1.1316 2024-01-17 |
5.0.0.1305 2023-12-31 |
5.0.0.1304 2023-12-19 |
5.0.0.1303 2023-12-15 |
Test TITLE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | CS | 1627 | 1480 | 1413 | 1515 | 1414 | 1442 | 1400 | 1584 | 1412 | 1392 | 1292 | 1664 | 1664 | 1803 | 1793 | 1837 | 1954 | 1766 | 1599 | 1794 | 1804 | 1817 | 1834 | 1647 | 1672 | 1608 | 1659 | 1658 | 1371 | 1297 | 1345 | Suboptimal join plan if there are selective non-indexed predicates involved |
|
2 | SS | 1082 | 979 | 900 | 883 | 969 | 1007 | 998 | 953 | 1322 | 883 | 891 | 1037 | 1068 | 1091 | 1289 | 1143 | 1174 | 1239 | 1239 | 1094 | 1259 | 1206 | 1199 | 971 | 1254 | 1093 | 1152 | 1181 | 971 | 1073 | 978 | Suboptimal join plan if there are selective non-indexed predicates involved |
|
3 | CS | 18790 | 18581 | 18663 | 18527 | 18592 | 18398 | 18543 | 18585 | 18641 | 18693 | 18797 | 19432 | 18748 | 18816 | 20110 | 19141 | 19931 | 19035 | 18784 | 19129 | 19035 | 18994 | 19031 | 19168 | 18988 | 19013 | 18637 | 22294 | 18599 | 18445 | 18740 | Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT |
|
4 | CS | 870 | 765 | 785 | 733 | 773 | 772 | 815 | 754 | 766 | 716 | 747 | 1019 | 901 | 878 | 1044 | 985 | 923 | 1013 | 940 | 841 | 928 | 919 | 1033 | 886 | 899 | 929 | 835 | 1084 | 822 | 863 | 843 | Alter computed field type does not work |
|
5 | SS | 584 | 454 | 465 | 449 | 629 | 411 | 477 | 675 | 465 | 475 | 476 | 529 | 593 | 637 | 597 | 611 | 523 | 597 | 660 | 501 | 643 | 567 | 586 | 587 | 575 | 583 | 587 | 956 | 556 | 586 | 623 | Alter computed field type does not work |
|
6 | CS | 6052 | 5896 | 5900 | 5895 | 5959 | 5925 | 6042 | 5918 | 5961 | 5878 | 5885 | 6250 | 6062 | 6184 | 6171 | 6266 | 6160 | 6198 | 6100 | 6152 | 6145 | 6201 | 6143 | 6144 | 6154 | 6111 | 6034 | 1831 | 5958 | 6003 | 6000 | Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work |
|
7 | CS | 7930 | 9834 | 8929 | 9084 | 10507 | 10666 | 10876 | 10549 | 11289 | 10762 | 6620 | 7092 | 7497 | 7490 | 7444 | 8598 | 8449 | 8904 | 7065 | 7429 | 7883 | 8423 | 8455 | 7667 | 7786 | 7542 | 7977 | 6485 | 7193 | 7239 | 6960 | Slow changes on domain |
|
8 | SS | 7612 | 9078 | 8420 | 8441 | 10370 | 10252 | 10207 | 14003 | 10115 | 13824 | 6285 | 6653 | 6798 | 7267 | 7644 | 7580 | 7945 | 7830 | 7580 | 6729 | 7882 | 7504 | 7321 | 7180 | 7127 | 6833 | 7823 | 8049 | 6671 | 6501 | 6455 | Slow changes on domain |
|
9 | SS | 4592 | 3795 | 3721 | 3957 | 3759 | 4036 | 3976 | 3867 | 3756 | 3919 | 3820 | 4483 | 4723 | 4427 | 5697 | 4585 | 5408 | 5833 | 5726 | 4828 | 5701 | 5336 | 5941 | 4599 | 4838 | 4747 | 5083 | 5335 | 4439 | 4304 | 4616 | Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified) |
|
10 | SS | 1224 | 1173 | 1082 | 1189 | 1212 | 1134 | 1231 | 1084 | 1286 | 1030 | 1053 | 1127 | 1324 | 1208 | 1262 | 1279 | 1193 | 1377 | 1367 | 1171 | 1308 | 1307 | 1270 | 1481 | 1146 | 1243 | 1228 | 1626 | 1264 | 1220 | 1170 | The size of the database with big records becomes bigger after backup/restore |
|
11 | SS | 509 | 431 | 383 | 434 | 403 | 415 | 430 | 428 | 403 | 395 | 383 | 548 | 571 | 584 | 556 | 495 | 509 | 535 | 558 | 464 | 566 | 536 | 521 | 494 | 458 | 561 | 515 | 715 | 574 | 509 | 518 | garbage collection in indexes and blobs is not performed in VIO_backout |
|
12 | CS | 736 | 739 | 666 | 663 | 734 | 733 | 634 | 683 | 714 | 637 | 599 | 667 | 722 | 755 | 869 | 929 | 793 | 1018 | 794 | 815 | 853 | 789 | 811 | 1113 | 713 | 808 | 741 | 953 | 669 | 662 | 714 | INNER JOIN join order LIKE and STARTING WITH |
|
13 | SS | 507 | 462 | 377 | 397 | 481 | 456 | 456 | 462 | 476 | 412 | 396 | 622 | 559 | 548 | 561 | 508 | 516 | 541 | 551 | 473 | 504 | 687 | 547 | 562 | 496 | 484 | 571 | 730 | 506 | 532 | 581 | INNER JOIN join order LIKE and STARTING WITH |
|
14 | CS | 41469 | 6713 | 70064 | 69162 | 69242 | 13777 | 13727 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bugcheck 183 (wrong record length) could happen on replica database after UK violation on insert DESCRIPTION Test temporary changes mode of replica to READ-WRITE. We create table 'PERF_AGG' on master with PK-column and UNIQUE constraint for other several columns (<S>) After this we wait until replica becomes actual to master, and this delay will last no more then threshold that is defined by MAX_TIME_FOR_WAIT_DATA_IN_REPLICA variable (measured in seconds), see QA_ROOT/files/test_config.ini Then we change mode of replica to *READ-WRITE* and add record in its 'PERF_AGG' table. After this, we add record in master 'PERF_AGG' with same values in <S> (but value in PK differs from replica one). This causes violation of UNIQUE index in replica DB but no error must raise (UPDATE should be with warning). We monintor replication.log until appropriate message appear in it. |
|
15 | SS | 40851 | 6065 | 68456 | 69609 | 68495 | 13166 | 13247 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Bugcheck 183 (wrong record length) could happen on replica database after UK violation on insert DESCRIPTION Test temporary changes mode of replica to READ-WRITE. We create table 'PERF_AGG' on master with PK-column and UNIQUE constraint for other several columns (<S>) After this we wait until replica becomes actual to master, and this delay will last no more then threshold that is defined by MAX_TIME_FOR_WAIT_DATA_IN_REPLICA variable (measured in seconds), see QA_ROOT/files/test_config.ini Then we change mode of replica to *READ-WRITE* and add record in its 'PERF_AGG' table. After this, we add record in master 'PERF_AGG' with same values in <S> (but value in PK differs from replica one). This causes violation of UNIQUE index in replica DB but no error must raise (UPDATE should be with warning). We monintor replication.log until appropriate message appear in it. |
|
16 | CS | 29544 | 29141 | 29051 | 29130 | 29169 | 29030 | 29084 | 29020 | 29231 | 28961 | 28945 | 29587 | 29647 | 29652 | 30032 | 29861 | 29828 | 29987 | 29467 | 29623 | 30082 | 29864 | 29875 | 29595 | 29501 | 29663 | 29601 | 31784 | 29434 | 29145 | 28962 | External Connections Pool, functionality test 01 |