| NN | Test name | mode |
4.0.6.3223
|
4.0.6.3222
|
4.0.6.3189
|
4.0.6.3184
|
4.0.6.3183
|
4.0.6.3169
|
4.0.6.3169
|
4.0.6.3168
|
4.0.6.3163
|
4.0.6.3163
|
4.0.6.3147
|
4.0.6.3140
|
4.0.6.3140
|
4.0.5.3110
|
4.0.5.3109
|
4.0.5.3097
|
4.0.5.3091
|
4.0.5.3089
|
X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Test TITLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SS | F | 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 | X | X | X | X | X | X | X | X | X | Prohibit an ability to issue DML or DDL statements on RDB$ tables |
|
| 2 | SS | 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 | X | X | X | X | X | X | X | X | X | Get the modification time of a config file with a higher precision to fix cases when it's not reloaded after modification/replacement |
|
| 3 | CS | 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 | X | X | X | X | X | X | X | X | X | Wrong SQLSTATE in case of table alias conflict |
|
| 4 | SS | 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 | X | X | X | X | X | X | X | X | X | Wrong SQLSTATE in case of table alias conflict |
|
| 5 | CS | F | P | P | P | P | P | P | P | P | 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 | Replicator must have access to the table with blob regardless SELECT grant on this table to the user who created blob. |
|
| 6 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different |
|
| 7 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record |
|
| 8 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Problem with replication of BLOB segments longer than 32KB |
|
| 9 | CS | F | 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 | X | 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 |
|
| 10 | CS | F | 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 | X | X | X | X | X | X | X | X | X | DDL-triggers must fire only on master DB |
|
| 11 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Disallow replication of RDB$BACKUP_HISTORY |
|
| 12 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear |
|
| 13 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Failed DDL commands can be replicated |
|
| 14 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Generator values may not replicate after commit |
|
| 15 | CS | F | 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 | X | X | X | X | X | X | X | DDL-Changes in replication does not set the correct grantor |
|
| 16 | CS | F | 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 | X | 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 |
|
| 17 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Applying full DDL from OLTP-EMUL test on master with further check replica |
|
| 18 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Permission error with replication |
|
| 19 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Crash or hang while shutting down the replica database if segments are being applied |
|
| 20 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Some updates can crash Firebird server on replica side |
|
| 21 | CS | F | 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 | X | X | X | X | X | X | X | X | X | Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error |
| NN | Test name | mode | median_ms |
4.0.6.3223
|
4.0.6.3222
|
4.0.6.3189
|
4.0.6.3184
|
4.0.6.3183
|
4.0.6.3169
|
4.0.6.3169
|
4.0.6.3168
|
4.0.6.3163
|
4.0.6.3163
|
4.0.6.3147
|
4.0.6.3140
|
4.0.6.3140
|
4.0.5.3110
|
4.0.5.3109
|
4.0.5.3097
|
4.0.5.3091
|
4.0.5.3089
|
X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | Test TITLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SS | 451 | 28099 | 11420 | 10540 | 538 | 512 | 453 | 406 | 383 | 406 | 396 | 414 | 1408 | 500 | 579 | 355 | 450 | 288 | 314 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Prohibit an ability to issue DML or DDL statements on RDB$ tables |
|
| 2 | SS | 791 | 791 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Get the modification time of a config file with a higher precision to fix cases when it's not reloaded after modification/replacement |
|
| 3 | CS | 704 | 704 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wrong SQLSTATE in case of table alias conflict |
|
| 4 | SS | 430 | 430 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Wrong SQLSTATE in case of table alias conflict |
|
| 5 | CS | 8987 | 145117 | 8612 | 10807 | 8468 | 9374 | 8691 | 8967 | 8806 | 8978 | 8987 | 9116 | 9182 | 9250 | 9009 | 8288 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Replicator must have access to the table with blob regardless SELECT grant on this table to the user who created blob. |
|
| 6 | CS | 12396 | 67519 | 8399 | 9072 | 12771 | 12727 | 12363 | 12192 | 11853 | 12383 | 12383 | 12935 | 16671 | 12393 | 12623 | 13237 | 12399 | 12225 | 12454 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Characters are garbled when replicating fields with type BLOB SUB_TYPE TEXT if the character set of the connection and the field are different |
|
| 7 | CS | 8917 | 65941 | 12313 | 12868 | 9199 | 9373 | 9421 | 6273 | 7137 | 6250 | 6033 | 8931 | 8821 | 8904 | 9141 | 8977 | 6210 | 6152 | 6378 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record |
|
| 8 | CS | 6419 | 69318 | 9583 | 8810 | 5836 | 6041 | 5893 | 6446 | 5383 | 6421 | 6417 | 6477 | 6472 | 5795 | 6099 | 5708 | 6449 | 6394 | 6425 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Problem with replication of BLOB segments longer than 32KB |
|
| 9 | CS | 6697 | 67527 | 6689 | 6705 | 7416 | 6528 | 6549 | 6823 | 6632 | 6773 | 6770 | 5843 | 7563 | 7195 | 6546 | 7214 | 5874 | 5792 | 5700 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 |
|
| 10 | CS | 6170 | 68159 | 6122 | 6177 | 5916 | 6000 | 6792 | 5398 | 6358 | 5496 | 5386 | 6522 | 8568 | 5728 | 6163 | 5649 | 6530 | 6526 | 6409 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DDL-triggers must fire only on master DB |
|
| 11 | CS | 9066 | 67462 | 6704 | 5632 | 9428 | 9428 | 9353 | 8973 | 8719 | 9007 | 9994 | 8967 | 9267 | 9270 | 9121 | 9150 | 9011 | 8928 | 8934 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Disallow replication of RDB$BACKUP_HISTORY |
|
| 12 | CS | 6342 | 67280 | 9065 | 9287 | 5805 | 5835 | 5714 | 6321 | 6305 | 6358 | 5396 | 6411 | 6316 | 6675 | 5863 | 6582 | 6327 | 6401 | 6409 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear |
|
| 13 | CS | 5644 | 67301 | 5601 | 6540 | 5678 | 5610 | 6511 | 6273 | 6268 | 6254 | 6306 | 5328 | 5503 | 5497 | 5361 | 5372 | 6202 | 5243 | 5287 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Failed DDL commands can be replicated |
|
| 14 | CS | 13067 | 67383 | 6567 | 5372 | 6707 | 7696 | 6524 | 13465 | 12357 | 12543 | 13438 | 13447 | 13486 | 12767 | 13367 | 13677 | 12491 | 13723 | 13558 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Generator values may not replicate after commit |
|
| 15 | CS | 12269 | 67734 | 6149 | 6997 | 12937 | 11788 | 12751 | 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 | 0 | 0 | 0 | 0 | DDL-Changes in replication does not set the correct grantor |
|
| 16 | CS | 35992 | 134709 | 12686 | 12646 | 47211 | 50217 | 53204 | 48924 | 33036 | 32840 | 31874 | 36109 | 66792 | 37400 | 39741 | 35876 | 33345 | 32725 | 33112 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 |
|
| 17 | CS | 6364 | 102307 | 36296 | 36765 | 6132 | 6192 | 6092 | 6729 | 5579 | 6635 | 6683 | 6762 | 6279 | 5854 | 6450 | 5969 | 6685 | 5607 | 5716 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Applying full DDL from OLTP-EMUL test on master with further check replica |
|
| 18 | CS | 13990 | 67842 | 5840 | 5860 | 14174 | 14158 | 13983 | 13426 | 14078 | 14133 | 13460 | 13410 | 17424 | 13868 | 17274 | 13748 | 13302 | 14009 | 13997 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Permission error with replication |
|
| 19 | CS | 6343 | 16755 | 14175 | 14205 | 6567 | 6781 | 6585 | 6333 | 6177 | 6288 | 6243 | 6287 | 6094 | 6554 | 5727 | 6473 | 6354 | 6318 | 6284 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Crash or hang while shutting down the replica database if segments are being applied |
|
| 20 | CS | 6302 | 67339 | 6496 | 6412 | 5617 | 5662 | 5643 | 6303 | 6307 | 6247 | 6256 | 6301 | 6112 | 5484 | 6694 | 6517 | 6463 | 6232 | 6377 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Some updates can crash Firebird server on replica side |
|
| 21 | CS | 631 | 67368 | 6481 | 6524 | 671 | 652 | 686 | 578 | 499 | 489 | 490 | 568 | 1037 | 660 | 1037 | 464 | 610 | 375 | 429 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Replication gets stuck due to "Blob xxx.xx is not found for table xxx" error |