0. Total results for each kind of outcome and server mode, for previous 30 runs
1. CRASHES/BUGCHECKS: tests that caused Firebird process abend for previous 30 runs (0 rows)
2. FRESH FAILS: tests which failed for LAST execution only (3 rows)
3. FRESH ERRORS: tests which raised runtime error for LAST execution only (10 rows)
4. STILL FAILS: tests which fail for at least TWO LAST runs (7 rows)
[CURRENT] 5. Has fails: tests with at least one fail for previous 30 runs (64 rows)
6. Has runtime errors: tests with at least one runtime error for previous 30 runs (17 rows)
7. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent (6 rows)
8. All tests: outcomes for previous 30 runs (2343 rows)
9. All tests: durations for previous 30 runs (4576 rows)
A. Skipped: tests which was intentionally excluded from execution (55 rows)

Generated 23.03.2023 02:01
Tested: FB40.   Build: 4.0.3.2913;   SS: 23.03.23 00:02:00 - 23.03.23 00:56:09;   CS: 23.03.23 00:57:45 - 23.03.23 01:59:26;
OS and hardware info:  Linux 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5 (2019-06-19) ; logical CPUs: 2 ; total memory: 7.6 Gb 
QA-software: Python 3.10.9, virtual env; pytest: 7.2.1; firebird.driver: 1.8.0; Firebird.Qa: 0.17.2

Test with at least one result = "FAIL" for last 30 runs:

Jump to LIST of unique test names from this report

NN Test name mode 4.0.3.2913
2023-03-23
4.0.3.2911
2023-03-22
4.0.3.2909
2023-03-17
4.0.3.2908
2023-03-14
4.0.3.2907
2023-03-10
4.0.3.2906
2023-03-08
4.0.3.2905
2023-03-04
4.0.3.2904
2023-03-03
4.0.3.2903
2023-02-27
4.0.3.2902
2023-02-18
4.0.3.2900
2023-02-14
4.0.3.2899
2023-02-09
4.0.3.2898
2023-02-08
4.0.3.2895
2023-02-05
4.0.3.2891
2023-01-24
4.0.3.2890
2023-01-17
4.0.3.2887
2023-01-12
4.0.3.2885
2023-01-18
4.0.3.2882
2023-01-18
4.0.3.2878
2023-01-05
4.0.3.2873
2023-01-06
4.0.3.2863
2023-01-03
X X X X X X X X
Test TITLE
1 CS P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Compress Data over the Network
2 SS P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Compress Data over the Network
3 CS     E     P P P P P P P P P P P P     F     P P P P P P P P X X X X X X X X
Write note into log when automatic sweep is started
4 CS P P P P P P P P P P P P P     F     P P P P P P P P X X X X X X X X
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
5 SS     F     P P P P P P P P P P P P P P P P P P P P P X X X X X X X X
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
6 CS P P P P P P P P P P P P P     F     P P P P P P P P X X X X X X X X
exclude_filter doesn't work for <services></section> section of the Trace facility
7 SS     F     P P P P P P P P P P P P P P P P P P P P P X X X X X X X X
exclude_filter doesn't work for <services></section> section of the Trace facility
8 CS P P P P P P P P P P P P P P P P P P P     F     P P X X X X X X X X
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
9 CS P P P P P P P P P P P P     F         F     P P P P P P P P X X X X X X X X
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
10 CS P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
11 SS P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
12 CS P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Prohibit an ability to issue DML or DDL statements on RDB$ tables
13 SS     E     P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Prohibit an ability to issue DML or DDL statements on RDB$ tables
14 CS P P P P P P P P P P P P P     F     P P P P P P P P X X X X X X X X
Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work
15 CS     F         F         F         F         F         F     P     F         F         F         F         F         F         F     P P P P P P P P X X X X X X X X
Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
16 SS P P P P P     F     P P P     F     P P P P P P P P P P P P X X X X X X X X
Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
17 CS P P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Support for DROP IDENTITY clause
18 SS P P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Support for DROP IDENTITY clause
19 CS P P P P P P     F         F         F         F         F         F         F         F         F         F     P     F         F     P P P X X X X X X X X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
20 SS P P P P P P     F         F         F         F         F         F         F         F         F         F     P     F         F     P P P X X X X X X X X
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
21 CS P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Timeouts for running SQL statements and idle connections
22 SS P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Timeouts for running SQL statements and idle connections
23 SS     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     P P P X X X X X X X X
Parse error when compiling a statement causes memory leak until attachment is disconnected
24 CS P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Wire compression causes freezes
25 SS P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Wire compression causes freezes
26 CS P P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Ability to query Firebird configuration using SQL
27 SS P P P P P P P P P     F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Ability to query Firebird configuration using SQL
28 CS P P P P P P     F         F     X X X X X X X X X X X X X X X X X X X X X X
Incorrect transliteration of field names in constraint violation errors
29 SS P P P P P P     F         F     X X X X X X X X X X X X X X X X X X X X X X
Incorrect transliteration of field names in constraint violation errors
30 SS P     F     P P P P P P X X X X X X X X X X X X X X X X X X X X X X
DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress
31 CS P P P P P P P     F         F     X X X X X X X X X X X X X X X X X X X X X
Inconsistent conversion of non-TEXT blobs in BLOB_APPEND
32 SS P P P P P P P     F         F     X X X X X X X X X X X X X X X X X X X X X
Inconsistent conversion of non-TEXT blobs in BLOB_APPEND
33 CS P P P P     F     X X X X X X X X X X X X X X X X X X X X X X X X X
Invalid real to string cast.
34 SS P P P P     F     X X X X X X X X X X X X X X X X X X X X X X X X X
Invalid real to string cast.
35 CS X X X X X X     F         F         F         F     X X X X X X X X X X X X X X X X X X X X
Basic test of RDB$BLOB_UTIL package functionality
36 SS X X X X X X     F         F         F         F     X X X X X X X X X X X X X X X X X X X X
Basic test of RDB$BLOB_UTIL package functionality
37 CS P P P P P P P P P P P P P P     F         F         F         F         F         F         F         F     X X X X X X X X
Miscelaneous time zone tests
38 SS P P P P P P P P P P P P P P     F         F         F         F         F         F         F         F     X X X X X X X X
Miscelaneous time zone tests
39 CS     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
40 CS     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Problem with replication of BLOB segments longer than 32KB
41 CS P P P     F     P P P P     F     P P     F     P P P P     F     P     F         F         F         F     X X X X X X X X
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
42 CS     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
DDL-triggers must fire only on master DB
43 CS P P P P P P P P P P P P P P P P P P P     F         F     P X X X X X X X X
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
44 CS P P P P P P P P P P P P P P P P P P P     F         F     P X X X X X X X X
Failed DDL commands can be replicated
45 CS P P P P P P P P P P P P P P P P P P P     F         F     P X X X X X X X X
Generator values may not replicate after commit
46 CS P P P P P P P P P P P P P P P P P P P     F         F     P X X X X X X X X
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
47 CS     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Permission error with replication
48 CS     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Crash or hang while shutting down the replica database if segments are being applied
49 SS P P P P P P P P P P P P P     F         F         F         F         F         F         F         F         F     X X X X X X X X
Crash or hang while shutting down the replica database if segments are being applied
50 CS P P P P P P P P P P P P P     F     P P P P P P P P X X X X X X X X
Some updates can crash Firebird server on replica side
51 SS P P P P P P P P P P P P P     F     P P P P P P P P X X X X X X X X
Some updates can crash Firebird server on replica side
52 CS P P P P P P P P P P P P P     F     P P P P P P P P X X X X X X X X
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
53 CS P P P P P P P P P P P P P     F     P P P P P P P P X X X X X X X X
Check ability to change some database header attributes by non-sysdba user who is granted with necessary system privileges
54 CS S S S S S S S     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Verify ability to make REMOTE connect to security.db
55 SS S S S S S S S     F         F         F         F         F         F         F         F         F         F         F         F         F         F         F     X X X X X X X X
Verify ability to make REMOTE connect to security.db
56 CS P P     F         F         F         F         F     P     F     P     F         F     P     F         F     P     F     P     F     P     F     P X X X X X X X X
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
57 SS P P P P P P P P     F     P P P P P P P P P P P P P X X X X X X X X
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
58 CS P     F     P     F     P P P     F         F     P P P P P     F         F     P     F         F     P     F         F     X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
59 SS     F     P P P P P P P P P P P P P     F     P     F     P     F         F         F         F     X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
60 CS P     F     P P     F     P     F         F     P P     F         F         F     P     F     P     F         F         F         F         F         F     X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
61 SS P     F     P P     F     P P P     F     P     F         F     P P     F         F         F         F         F     P     F     P X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
62 CS S S P P P     F     P P P P P P P P P P P P P P P P X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
63 CS P     F     P     F     P     F     P P     F     P P P     F         F     P     F         F     P P P     F         F     X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
64 SS P P P P P     F     P P P P P P     F     P     F         F         F         F         F     P P P X X X X X X X X
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.

Elapsed time, milliseconds:
NN Test name mode median_ms 4.0.3.2913
2023-03-23
4.0.3.2911
2023-03-22
4.0.3.2909
2023-03-17
4.0.3.2908
2023-03-14
4.0.3.2907
2023-03-10
4.0.3.2906
2023-03-08
4.0.3.2905
2023-03-04
4.0.3.2904
2023-03-03
4.0.3.2903
2023-02-27
4.0.3.2902
2023-02-18
4.0.3.2900
2023-02-14
4.0.3.2899
2023-02-09
4.0.3.2898
2023-02-08
4.0.3.2895
2023-02-05
4.0.3.2891
2023-01-24
4.0.3.2890
2023-01-17
4.0.3.2887
2023-01-12
4.0.3.2885
2023-01-18
4.0.3.2882
2023-01-18
4.0.3.2878
2023-01-05
4.0.3.2873
2023-01-06
4.0.3.2863
2023-01-03
X X X X X X X X
Test TITLE
1 CS 2282 42786 43366 41817 42129 41891 43521 42177 2295 2089 2270 2373 2425 2264 2494 1927 1918 1994 1941 2038 2098 2005 2001 0 0 0 0 0 0 0 0
Compress Data over the Network
2 SS 2048 52670 42665 42434 41141 41652 41825 42043 2227 1839 1776 2050 2163 2047 2106 1586 1765 1685 1682 1768 1717 1668 1693 0 0 0 0 0 0 0 0
Compress Data over the Network
3 CS 5613 116 5565 5486 5501 5476 5529 5550 5542 5569 5539 5658 5668 5751 533 5850 5828 5864 5834 5832 5904 5883 5840 0 0 0 0 0 0 0 0
Write note into log when automatic sweep is started
4 CS 751 573 537 542 530 489 541 534 530 549 515 740 763 783 10630 796 813 876 778 809 852 846 844 0 0 0 0 0 0 0 0
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
5 SS 417 10309 321 311 321 334 313 334 362 337 354 500 491 483 450 416 458 430 434 427 485 418 416 0 0 0 0 0 0 0 0
Client receive event's with count equal to 1 despite of how many times EVENT was POSTed in same transaction
6 CS 2771 2595 2672 2613 2570 2586 2588 2583 2613 2647 2597 2858 2832 2798 2744 3105 3109 3146 3167 3100 3139 3147 3139 0 0 0 0 0 0 0 0
exclude_filter doesn't work for <services></section> section of the Trace facility
7 SS 2527 2404 2450 2426 2411 2416 2439 2450 2415 2439 2415 2562 2553 2550 2548 2527 2537 2530 2527 2538 2551 2545 2536 0 0 0 0 0 0 0 0
exclude_filter doesn't work for <services></section> section of the Trace facility
8 CS 3931 3733 3819 3735 3766 3764 3788 3780 3718 3738 3722 3904 3986 3958 4065 4085 4036 4097 4086 4098 4107 4169 4134 0 0 0 0 0 0 0 0
DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
9 CS 11410 11540 11402 11520 11354 11380 11497 11577 11486 11381 11409 11423 11472 11385 12369 11380 11327 11412 11386 11435 11465 11313 11383 0 0 0 0 0 0 0 0
Database shutdown is reported as successfully completed before all active connections are in fact interrupted
10 CS 3103 3019 3001 2768 2777 2982 3007 2907 2984 2933 2911 3097 3213 3109 3536 3253 3182 3285 3207 3198 3210 3243 3236 0 0 0 0 0 0 0 0
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
11 SS 2538 2542 2502 2453 2464 2493 2487 2450 2473 2452 2460 2572 2579 2605 2555 2535 2534 2581 2557 2582 2550 2565 2582 0 0 0 0 0 0 0 0
Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
12 CS 13441 13402 13669 13442 13440 13263 13774 15384 15260 15351 14999 15554 15580 15453 19196 11704 11820 12105 11535 12027 11986 12184 11982 0 0 0 0 0 0 0 0
Prohibit an ability to issue DML or DDL statements on RDB$ tables
13 SS 9282 90 9444 9001 9120 9457 9556 11022 10921 10583 11467 11411 11384 11261 10867 8425 8408 8329 8384 8281 8349 8361 8385 0 0 0 0 0 0 0 0
Prohibit an ability to issue DML or DDL statements on RDB$ tables
14 CS 6144 5988 5958 5887 5887 5873 5973 5980 6039 5911 6088 6201 6201 6212 4946 6266 6317 6379 6247 6295 6425 6359 6373 0 0 0 0 0 0 0 0
Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work
15 CS 17181 9046 8945 8951 17014 16989 16980 17092 17055 17002 16973 17252 17197 17244 17165 17410 17455 17527 17390 17460 17539 17532 17444 0 0 0 0 0 0 0 0
Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
16 SS 16741 8541 8669 8606 16637 16595 16607 16672 16671 16688 16662 16775 16851 16825 16764 16751 16772 16751 16732 16788 16761 16778 16751 0 0 0 0 0 0 0 0
Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
17 CS 591 470 442 431 485 469 476 415 450 454 443 671 629 601 582 723 706 725 658 746 776 741 749 0 0 0 0 0 0 0 0
Support for DROP IDENTITY clause
18 SS 379 280 322 293 285 263 283 304 295 310 309 418 448 420 429 382 407 394 400 384 421 377 382 0 0 0 0 0 0 0 0
Support for DROP IDENTITY clause
19 CS 2638 2586 2629 1 2611 5 2596 7 2640 2637 8 2804 2845 2798 2719 2896 3134 5 2843 3122 3183 3190 1 0 0 0 0 0 0 0 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
20 SS 2463 4 1 2404 1 2444 3 2490 2457 2448 2470 7 2527 2545 2550 2546 2549 1 2546 2530 3 2536 2533 0 0 0 0 0 0 0 0
Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
21 CS 5775 5582 5599 5608 5608 5608 5597 5608 5624 5618 5640 5830 5782 5768 6010 6143 6112 6164 6090 6124 6154 6168 6168 0 0 0 0 0 0 0 0
Timeouts for running SQL statements and idle connections
22 SS 5534 5452 5447 5417 5451 5447 5412 5431 5469 5466 5457 5549 5535 5560 5543 5545 5569 5543 5575 5561 5552 5557 5533 0 0 0 0 0 0 0 0
Timeouts for running SQL statements and idle connections
23 SS 639 522 709 641 622 639 735 732 705 628 648 749 814 755 821 624 640 631 608 639 635 589 611 0 0 0 0 0 0 0 0
Parse error when compiling a statement causes memory leak until attachment is disconnected
24 CS 861 71147 71339 56899 64934 61897 62718 66738 529 579 564 748 739 744 1215 810 842 897 865 933 852 852 858 0 0 0 0 0 0 0 0
Wire compression causes freezes
25 SS 558 71538 69571 60514 66275 61369 65485 68293 414 457 474 574 572 594 571 546 525 507 526 511 513 523 531 0 0 0 0 0 0 0 0
Wire compression causes freezes
26 CS 599 408 434 418 457 411 425 425 485 496 418 574 673 624 962 716 694 720 691 707 734 809 772 0 0 0 0 0 0 0 0
Ability to query Firebird configuration using SQL
27 SS 361 238 286 296 266 284 272 281 297 287 271 422 427 436 407 353 395 390 379 477 394 369 437 0 0 0 0 0 0 0 0
Ability to query Firebird configuration using SQL
28 CS 446 437 471 484 398 423 456 420 506 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect transliteration of field names in constraint violation errors
29 SS 295 299 311 304 280 275 291 259 304 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorrect transliteration of field names in constraint violation errors
30 SS 4119 4051 4186 4209 4048 4177 4109 4130 3033 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DROP DATABASE lead FB to hang if it is issued while DB encrypting/decrypting is in progress
31 CS 627 627 615 654 596 613 574 633 693 651 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inconsistent conversion of non-TEXT blobs in BLOB_APPEND
32 SS 427 422 442 449 431 391 436 385 427 399 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Inconsistent conversion of non-TEXT blobs in BLOB_APPEND
33 CS 434 438 458 434 408 419 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Invalid real to string cast.
34 SS 273 273 299 282 273 245 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Invalid real to string cast.
35 CS 465 0 0 0 0 0 0 489 464 467 421 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Basic test of RDB$BLOB_UTIL package functionality
36 SS 292 0 0 0 0 0 0 293 292 338 277 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Basic test of RDB$BLOB_UTIL package functionality
37 CS 754 672 582 571 585 552 546 651 556 720 628 748 797 761 1101 856 904 874 813 876 870 842 908 0 0 0 0 0 0 0 0
Miscelaneous time zone tests
38 SS 500 471 416 389 419 408 481 442 443 413 477 581 553 528 618 505 553 535 495 558 526 524 509 0 0 0 0 0 0 0 0
Miscelaneous time zone tests
39 CS 16858 16941 15078 16139 15945 15158 15602 15702 16959 16331 14681 15494 16776 17197 16202 31255 31194 45715 32749 27642 44890 45465 46255 0 0 0 0 0 0 0 0
Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record
40 CS 4809 4734 4686 4671 4736 4689 4739 4838 4869 4328 4780 4891 4258 4990 5872 4403 4334 7056 82075 5544 82231 8333 8601 0 0 0 0 0 0 0 0
Problem with replication of BLOB segments longer than 32KB
41 CS 5917 5977 5908 5794 6844 6033 5804 5844 5832 81218 5843 6050 82901 6030 7781 5945 6073 2960 5926 2706 2985 2780 4246 0 0 0 0 0 0 0 0
Replica DB must not fire DB-level triggers but their activity on master must be eventually seen in replica
42 CS 3256 3167 3189 3354 3266 3216 3216 3113 3271 3219 3247 3217 3246 3233 4293 3284 3394 3711 3404 3244 3850 3836 3722 0 0 0 0 0 0 0 0
DDL-triggers must fire only on master DB
43 CS 5926 5908 5706 5880 5668 5803 5816 5901 5983 5806 6049 6040 5895 5929 6967 5984 5903 5996 5924 5968 6618 6549 6168 0 0 0 0 0 0 0 0
Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear
44 CS 4367 4272 4212 4218 4434 4413 4249 4243 4156 4261 4373 4371 4407 4507 5205 4405 4456 4485 4364 4358 1952 2143 4533 0 0 0 0 0 0 0 0
Failed DDL commands can be replicated
45 CS 4530 4400 4516 4544 4504 4512 4491 4463 4506 4629 4419 4504 4634 4586 5520 4857 4707 4903 4730 4705 2841 2636 4827 0 0 0 0 0 0 0 0
Generator values may not replicate after commit
46 CS 6176 6157 6133 6044 6009 6035 5943 6134 5971 6039 6169 6294 6158 6184 7534 6433 6250 6442 6310 6307 7261 7337 6462 0 0 0 0 0 0 0 0
Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no its "replica" flag set
47 CS 82627 81661 83906 84376 83246 83394 83656 82542 82712 82197 83085 84480 83141 82718 91587 81286 81308 80885 80821 81253 80803 80936 81226 0 0 0 0 0 0 0 0
Permission error with replication
48 CS 83165 82756 84493 85862 84311 84295 84567 83139 83762 83192 83678 84732 83790 83013 90600 82174 82078 81693 81439 82396 81852 81927 82076 0 0 0 0 0 0 0 0
Crash or hang while shutting down the replica database if segments are being applied
49 SS 20064 20923 20073 20806 20846 20960 21196 20081 20949 20746 21065 21016 20013 20056 3963 5292 5225 5249 5283 5390 5287 4997 5225 0 0 0 0 0 0 0 0
Crash or hang while shutting down the replica database if segments are being applied
50 CS 4615 4468 4638 4547 4594 4482 4462 4504 4674 4505 4560 4652 4524 4613 2527 4736 4974 4828 4618 4740 4807 4821 4842 0 0 0 0 0 0 0 0
Some updates can crash Firebird server on replica side
51 SS 6598 5659 6664 6482 6561 6477 5672 6604 6561 5543 6588 5600 6586 6593 66685 9622 9632 9577 9617 9608 9564 9621 9582 0 0 0 0 0 0 0 0
Some updates can crash Firebird server on replica side
52 CS 4272 4192 4245 4158 4258 4183 4228 4301 4255 4198 4250 4276 4354 4269 3056 4401 4583 4437 4348 4406 4438 4422 4423 0 0 0 0 0 0 0 0
Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error
53 CS 1998 1847 1724 1817 1748 1801 1776 2027 1941 1900 1923 1969 2142 2107 1962 2200 2256 2294 2037 2219 2303 2332 2420 0 0 0 0 0 0 0 0
Check ability to change some database header attributes by non-sysdba user who is granted with necessary system privileges
54 CS 567 2 445 463 401 450 422 4 439 471 416 525 660 609 1068 723 704 712 670 683 692 724 748 0 0 0 0 0 0 0 0
Verify ability to make REMOTE connect to security.db
55 SS 296 304 320 270 -1 305 283 290 201 182 189 318 337 346 385 286 306 271 266 276 296 307 309 0 0 0 0 0 0 0 0
Verify ability to make REMOTE connect to security.db
56 CS 28191 28207 28440 27579 27843 28248 28405 28479 28140 28890 28102 28474 28959 28967 28905 28107 27824 28176 27722 27854 27908 27839 28227 0 0 0 0 0 0 0 0
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
57 SS 25840 26213 26264 25401 25804 25504 26276 25877 25968 26095 25974 26533 26813 26515 26181 23892 23831 23915 23794 23855 23942 23727 23738 0 0 0 0 0 0 0 0
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
58 CS 3783 3646 3662 3533 3678 3542 3697 3620 3781 3712 3656 3816 3925 3966 3701 3794 3848 3860 3786 3869 3889 3862 3954 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
59 SS 3207 3314 3366 3223 3168 3152 3149 3216 3230 3198 3290 3367 3407 3438 3393 3159 3147 3157 3287 3090 3130 3134 3128 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
60 CS 3791 3664 3767 3561 3573 3615 3660 3627 3776 3556 3541 3895 3907 3890 4070 3773 3810 3847 3847 3807 3907 3914 3932 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
61 SS 3188 3282 3325 3196 3210 3205 3285 3181 3181 3153 3226 3408 3433 3385 3459 3121 3118 3129 3117 3136 3079 3163 3142 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
62 CS 3803 1 3618 3563 3616 3681 5496913 3675 3712 3598 3762 3798 3852 3850 4424 3808 3897 3939 3794 3863 4020 3863 3894 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
63 CS 3779 3651 3680 3631 3604 3510 3596 3736 3719 3648 3622 3822 3844 3945 4523 3835 3820 3845 3782 3776 3961 3910 3922 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
64 SS 3211 3259 3300 3168 3206 3226 3217 3216 3202 3295 3269 3354 3370 3393 3337 3156 3092 3091 3169 3130 3135 3128 3116 0 0 0 0 0 0 0 0
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.

List of tests in this report:


http://tracker.firebirdsql.org/browse/core-2668
http://tracker.firebirdsql.org/browse/core-3095
http://tracker.firebirdsql.org/browse/core-3168
http://tracker.firebirdsql.org/browse/core-3977
http://tracker.firebirdsql.org/browse/core-4236
http://tracker.firebirdsql.org/browse/core-4319
http://tracker.firebirdsql.org/browse/core-4731
http://tracker.firebirdsql.org/browse/core-5210
http://tracker.firebirdsql.org/browse/core-5275
http://tracker.firebirdsql.org/browse/core-5431
http://tracker.firebirdsql.org/browse/core-5470
http://tracker.firebirdsql.org/browse/core-5488
http://tracker.firebirdsql.org/browse/core-5646
http://tracker.firebirdsql.org/browse/core-6348
http://tracker.firebirdsql.org/browse/core-6444
http://tracker.firebirdsql.org/browse/core-733
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/blob/test_rdb_blob_util_basic.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_time_zone.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_blob_not_found_in_rw_replica_if_target_row_exists.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_blob_segments_longer_32kb_are_not_replicated.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_dblevel_triggers_must_not_fire_on_replica.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_ddl_triggers_must_not_fire_on_replica.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_duplicates_in_rw_replica_after_conflicting_insert.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_failed_ddl_commands_can_be_replicated.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_generator_could_not_be_transferred_to_replica.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_invalid_msg_if_target_db_has_no_replica_flag.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_permission_error_on_ddl_issued_by_non_sysdba.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_shutdown_during_applying_segments_leads_to_crash.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_some_updates_crash_server_on_replica_side.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/replication/test_updating_blob_with_empty_string_stops_replication.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/syspriv/test_change_header_settings.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_remote_access_to_security_db.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_max_limit.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_delete_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_merge_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_04.py
https://github.com/FirebirdSQL/firebird/issues/7167
https://github.com/FirebirdSQL/firebird/issues/7200
https://github.com/FirebirdSQL/firebird/issues/7256
https://github.com/FirebirdSQL/firebird/issues/7488

=== end of list ===