Check firebird.log [no messages found for interval when this test was running]
Jump to: output_first_mismatch    outcomes_full_history    elapsed_time_chart
Show cross-report outcomes.

Annotation type Annotation details
2 @message
assert   
    gbak: ERROR:violation of PRIMARY or UNIQUE KEY constraint "PK_A3" on table "A3"
    gbak: ERROR:    Problematic key value is ("ID" = 9)
  + gbak: ERROR:action cancelled by trigger (2) to preserve data integrity
  + gbak: ERROR:    Cannot deactivate index used by an integrity constraint
  - gbak: ERROR:violation of PRIMARY or UNIQUE KEY constraint "PK_A1" on table "A1"
  - gbak: ERROR:    Problematic key value is ("ID" = 5)
  - gbak: ERROR:Cannot create foreign key constraint FK_A1. Partner index does not exist or is inactive.
  - gbak: ERROR:violation of FOREIGN KEY constraint "FK_A2" on table "B2"
  - gbak: ERROR:    Foreign key reference target does not exist
  - gbak: ERROR:    Problematic key value is ("A2_ID" = 5)
  - gbak: ERROR:Cannot create foreign key constraint FK_A3. Partner index does not exist or is inactive.
  - gbak:finishing, closing, and going home
  - gbak:adjusting the ONLINE and FORCED WRITES flags
  - gbak: ERROR:Database is not online due to failure to activate one or more indices.
  - gbak: ERROR:    Run gfix -online to bring database online without active indices.

LOG DETAILS:

2024-11-18 11:11:22.533
2024-11-18 11:11:22.538 act = <firebird.qa.plugin.Action object at [hex]>
2024-11-18 11:11:22.543 tmp_fbk = PosixPath('/var/tmp/qa_2024/test_11524/gh_7269.tmp.fbk')
2024-11-18 11:11:22.548 tmp_fdb = PosixPath('/var/tmp/qa_2024/test_11524/gh_7269.tmp.fdb')
2024-11-18 11:11:22.553 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2024-11-18 11:11:22.559
2024-11-18 11:11:22.564 @pytest.mark.version('>=5.0.2')
2024-11-18 11:11:22.569 def test_1(act: Action, tmp_fbk: Path, tmp_fdb: Path, capsys):
2024-11-18 11:11:22.574 zipped_fbk_file = zipfile.Path(act.files_dir / 'gh_7269.zip', at = 'gh-7269-unrecoverable.fbk')
2024-11-18 11:11:22.579 tmp_fbk.write_bytes(zipped_fbk_file.read_bytes())
2024-11-18 11:11:22.585
2024-11-18 11:11:22.590 allowed_patterns = \
2024-11-18 11:11:22.596 (
2024-11-18 11:11:22.601 r'gbak:(\s+)?ERROR(:)?'
2024-11-18 11:11:22.607 ,r'gbak:(\s+)?finishing, closing, and going home'
2024-11-18 11:11:22.616 ,r'gbak:(\s+)?adjusting the ONLINE and FORCED WRITES flags'
2024-11-18 11:11:22.621 )
2024-11-18 11:11:22.627 allowed_patterns = [ re.compile(p, re.IGNORECASE) for p in allowed_patterns ]
2024-11-18 11:11:22.633
2024-11-18 11:11:22.639 act.gbak(switches = ['-rep', '-v', str(tmp_fbk), str(tmp_fdb)], combine_output = True, io_enc = locale.getpreferredencoding())
2024-11-18 11:11:22.644
2024-11-18 11:11:22.650 for line in act.stdout.splitlines():
2024-11-18 11:11:22.655 if act.match_any(line.strip(), allowed_patterns):
2024-11-18 11:11:22.661 print(line)
2024-11-18 11:11:22.668
2024-11-18 11:11:22.674 expected_stdout = """
2024-11-18 11:11:22.681 gbak: ERROR:violation of PRIMARY or UNIQUE KEY constraint "PK_A3" on table "A3"
2024-11-18 11:11:22.687 gbak: ERROR:    Problematic key value is ("ID" = 9)
2024-11-18 11:11:22.693 gbak: ERROR:violation of PRIMARY or UNIQUE KEY constraint "PK_A1" on table "A1"
2024-11-18 11:11:22.699 gbak: ERROR:    Problematic key value is ("ID" = 5)
2024-11-18 11:11:22.704 gbak: ERROR:Cannot create foreign key constraint FK_A1. Partner index does not exist or is inactive.
2024-11-18 11:11:22.710 gbak: ERROR:violation of FOREIGN KEY constraint "FK_A2" on table "B2"
2024-11-18 11:11:22.715 gbak: ERROR:    Foreign key reference target does not exist
2024-11-18 11:11:22.721 gbak: ERROR:    Problematic key value is ("A2_ID" = 5)
2024-11-18 11:11:22.726 gbak: ERROR:Cannot create foreign key constraint FK_A3. Partner index does not exist or is inactive.
2024-11-18 11:11:22.732 gbak:finishing, closing, and going home
2024-11-18 11:11:22.737 gbak:adjusting the ONLINE and FORCED WRITES flags
2024-11-18 11:11:22.742 gbak: ERROR:Database is not online due to failure to activate one or more indices.
2024-11-18 11:11:22.748 gbak: ERROR:    Run gfix -online to bring database online without active indices.
2024-11-18 11:11:22.753 """
2024-11-18 11:11:22.758
2024-11-18 11:11:22.764 act.expected_stdout = expected_stdout
2024-11-18 11:11:22.769 act.stdout = capsys.readouterr().out
2024-11-18 11:11:22.778 >       assert act.clean_stdout == act.clean_expected_stdout
2024-11-18 11:11:22.788 E       assert
2024-11-18 11:11:22.794 E           gbak: ERROR:violation of PRIMARY or UNIQUE KEY constraint "PK_A3" on table "A3"
2024-11-18 11:11:22.799 E           gbak: ERROR:    Problematic key value is ("ID" = 9)
2024-11-18 11:11:22.804 E         + gbak: ERROR:action cancelled by trigger (2) to preserve data integrity
2024-11-18 11:11:22.809 E         + gbak: ERROR:    Cannot deactivate index used by an integrity constraint
2024-11-18 11:11:22.814 E         - gbak: ERROR:violation of PRIMARY or UNIQUE KEY constraint "PK_A1" on table "A1"
2024-11-18 11:11:22.820 E         - gbak: ERROR:    Problematic key value is ("ID" = 5)
2024-11-18 11:11:22.826 E         - gbak: ERROR:Cannot create foreign key constraint FK_A1. Partner index does not exist or is inactive.
2024-11-18 11:11:22.831 E         - gbak: ERROR:violation of FOREIGN KEY constraint "FK_A2" on table "B2"
2024-11-18 11:11:22.836 E         - gbak: ERROR:    Foreign key reference target does not exist
2024-11-18 11:11:22.843 E         - gbak: ERROR:    Problematic key value is ("A2_ID" = 5)
2024-11-18 11:11:22.849 E         - gbak: ERROR:Cannot create foreign key constraint FK_A3. Partner index does not exist or is inactive.
2024-11-18 11:11:22.854 E         - gbak:finishing, closing, and going home
2024-11-18 11:11:22.859 E         - gbak:adjusting the ONLINE and FORCED WRITES flags
2024-11-18 11:11:22.864 E         - gbak: ERROR:Database is not online due to failure to activate one or more indices.
2024-11-18 11:11:22.869 E         - gbak: ERROR:    Run gfix -online to bring database online without active indices.
2024-11-18 11:11:22.875
2024-11-18 11:11:22.879 tests/bugs/gh_7269_test.py:68: AssertionError
2024-11-18 11:11:22.885 ---------------------------- Captured stdout setup -----------------------------
2024-11-18 11:11:22.891 Creating db: localhost:/var/tmp/qa_2024/test_11524/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
3 #text
act = <firebird.qa.plugin.Action pytest object at [hex]>
tmp_fbk = PosixPath('/var/tmp/qa_2024/test_11524/gh_7269.tmp.fbk')
tmp_fdb = PosixPath('/var/tmp/qa_2024/test_11524/gh_7269.tmp.fdb')
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>

    @pytest.mark.version('>=5.0.2')
    def test_1(act: Action, tmp_fbk: Path, tmp_fdb: Path, capsys):
        zipped_fbk_file = zipfile.Path(act.files_dir / 'gh_7269.zip', at = 'gh-7269-unrecoverable.fbk')
        tmp_fbk.write_bytes(zipped_fbk_file.read_bytes())
    
        allowed_patterns = \
        (
             r'gbak:(\s+)?ERROR(:)?'
            ,r'gbak:(\s+)?finishing, closing, and going home'
            ,r'gbak:(\s+)?adjusting the ONLINE and FORCED WRITES flags'
        )
        allowed_patterns = [ re.compile(p, re.IGNORECASE) for p in allowed_patterns ]
    
        act.gbak(switches = ['-rep', '-v', str(tmp_fbk), str(tmp_fdb)], combine_output = True, io_enc = locale.getpreferredencoding())
    
        for line in act.stdout.splitlines():
                if act.match_any(line.strip(), allowed_patterns):
                    print(line)
    
        expected_stdout = """
            gbak: ERROR:violation of PRIMARY or UNIQUE KEY constraint "PK_A3" on table "A3"
            gbak: ERROR:    Problematic key value is ("ID" = 9)
            gbak: ERROR:violation of PRIMARY or UNIQUE KEY constraint "PK_A1" on table "A1"
            gbak: ERROR:    Problematic key value is ("ID" = 5)
            gbak: ERROR:Cannot create foreign key constraint FK_A1. Partner index does not exist or is inactive.
            gbak: ERROR:violation of FOREIGN KEY constraint "FK_A2" on table "B2"
            gbak: ERROR:    Foreign key reference target does not exist
            gbak: ERROR:    Problematic key value is ("A2_ID" = 5)
            gbak: ERROR:Cannot create foreign key constraint FK_A3. Partner index does not exist or is inactive.
            gbak:finishing, closing, and going home
            gbak:adjusting the ONLINE and FORCED WRITES flags
            gbak: ERROR:Database is not online due to failure to activate one or more indices.
            gbak: ERROR:    Run gfix -online to bring database online without active indices.
        """
    
        act.expected_stdout = expected_stdout
        act.stdout = capsys.readouterr().out
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E           gbak: ERROR:violation of PRIMARY or UNIQUE KEY constraint "PK_A3" on table "A3"
E           gbak: ERROR:    Problematic key value is ("ID" = 9)
E         + gbak: ERROR:action cancelled by trigger (2) to preserve data integrity
E         + gbak: ERROR:    Cannot deactivate index used by an integrity constraint
E         - gbak: ERROR:violation of PRIMARY or UNIQUE KEY constraint "PK_A1" on table "A1"
E         - gbak: ERROR:    Problematic key value is ("ID" = 5)
E         - gbak: ERROR:Cannot create foreign key constraint FK_A1. Partner index does not exist or is inactive.
E         - gbak: ERROR:violation of FOREIGN KEY constraint "FK_A2" on table "B2"
E         - gbak: ERROR:    Foreign key reference target does not exist
E         - gbak: ERROR:    Problematic key value is ("A2_ID" = 5)
E         - gbak: ERROR:Cannot create foreign key constraint FK_A3. Partner index does not exist or is inactive.
E         - gbak:finishing, closing, and going home
E         - gbak:adjusting the ONLINE and FORCED WRITES flags
E         - gbak: ERROR:Database is not online due to failure to activate one or more indices.
E         - gbak: ERROR:    Run gfix -online to bring database online without active indices.

tests/bugs/gh_7269_test.py:68: AssertionError
Full history of outcomes and elapsed time, ms:
NN SNAP_INFO CS_outcome SS_outcome CS_run_time SS_run_time CS_run_beg CS_run_end SS_run_beg SS_run_end
1 5.0.3.1657 2025.06.19 4bd4c P P 815 593 2025.06.27 12:16:08.807 2025.06.27 12:16:09.622 2025.06.27 10:58:20.071 2025.06.27 10:58:20.664
2 5.0.3.1657 2025.06.11 dae6f P P 838 601 2025.06.17 07:21:06.361 2025.06.17 07:21:07.199 2025.06.17 06:02:09.517 2025.06.17 06:02:10.118
3 5.0.3.1657 2025.06.10 dbc92 P P 705 691 2025.06.11 12:11:22.224 2025.06.11 12:11:22.929 2025.06.11 10:43:12.230 2025.06.11 10:43:12.921
4 5.0.3.1656 2025.05.20 c4b11 P P 870 632 2025.06.10 12:05:05.822 2025.06.10 12:05:06.692 2025.06.10 10:42:12.557 2025.06.10 10:42:13.189
5 5.0.3.1652 2025.05.13 f51c6 P P 987 684 2025.05.20 05:08:35.373 2025.05.20 05:08:36.360 2025.05.20 03:34:00.290 2025.05.20 03:34:00.974
6 5.0.3.1651 2025.04.30 141ef P P 835 680 2025.05.13 12:06:41.894 2025.05.13 12:06:42.729 2025.05.13 10:30:56.184 2025.05.13 10:30:56.864
7 5.0.3.1650 2025.04.28 4cbff P P 940 643 2025.05.01 11:40:26.343 2025.05.01 11:40:27.283 2025.05.01 10:05:41.555 2025.05.01 10:05:42.198
8 5.0.3.1649 2025.04.21 5b2d0 P P 1027 672 2025.04.28 05:38:18.512 2025.04.28 05:38:19.539 2025.04.28 04:05:32.851 2025.04.28 04:05:33.523
9 5.0.3.1648 2025.04.18 2f4c5 P P 1043 585 2025.04.20 05:30:01.233 2025.04.20 05:30:02.276 2025.04.20 04:00:05.090 2025.04.20 04:00:05.675
10 5.0.3.1635 2025.03.31 22ec6 P P 973 670 2025.04.18 11:53:01.838 2025.04.18 11:53:02.811 2025.04.18 10:18:59.697 2025.04.18 10:19:00.367
11 5.0.3.1633 2025.03.28 3123a P P 978 633 2025.03.31 10:27:28.377 2025.03.31 10:27:29.355 2025.03.31 08:59:29.799 2025.03.31 08:59:30.432
12 5.0.3.1633 2025.03.27 e0fb8 P P 1045 594 2025.03.28 11:02:25.213 2025.03.28 11:02:26.258 2025.03.28 09:31:18.905 2025.03.28 09:31:19.499
13 5.0.3.1631 2025.03.21 1925b P P 1014 634 2025.03.27 10:50:12.532 2025.03.27 10:50:13.546 2025.03.27 09:20:24.793 2025.03.27 09:20:25.427
14 5.0.3.1628 2025.03.14 16d05 P P 756 509 2025.03.17 08:22:55.987 2025.03.17 08:22:56.743 2025.03.17 06:44:21.030 2025.03.17 06:44:21.539
15 5.0.3.1627 2025.02.26 4e218 P P 820 456 2025.03.14 11:37:26.448 2025.03.14 11:37:27.268 2025.03.14 09:57:37.394 2025.03.14 09:57:37.850
16 5.0.3.1624 2025.02.25 dc3b2 P P 780 415 2025.02.26 10:28:06.506 2025.02.26 10:28:07.286 2025.02.26 08:53:56.143 2025.02.26 08:53:56.558
17 5.0.2.1615 2025.02.20 4a726 P P 768 469 2025.02.25 10:55:26.911 2025.02.25 10:55:27.679 2025.02.25 09:19:32.539 2025.02.25 09:19:33.008
18 5.0.2.1615 2025.02.14 9cb76 P P 727 482 2025.02.20 07:44:49.228 2025.02.20 07:44:49.955 2025.02.20 06:12:33.859 2025.02.20 06:12:34.341
19 5.0.2.1577 2024.12.24 3c80e P P 839 468 2025.02.14 10:58:21.140 2025.02.14 10:58:21.979 2025.02.14 09:25:59.421 2025.02.14 09:25:59.889
20 5.0.2.1576 2024.12.17 646b0 P P 573 346 2024.12.24 20:22:35.506 2024.12.24 20:22:36.079 2024.12.24 17:12:29.278 2024.12.24 17:12:29.624
21 5.0.2.1575 2024.12.08 63d39 P P 594 324 2024.12.16 08:04:00.805 2024.12.16 08:04:01.399 2024.12.16 06:55:15.210 2024.12.16 06:55:15.534
22 5.0.2.1567 2024.11.26 56e63 P P 624 312 2024.12.04 07:44:54.745 2024.12.04 07:44:55.369 2024.12.04 06:34:29.727 2024.12.04 06:34:30.039
23 5.0.2.1567 2024.11.21 96f61 P P 582 302 2024.11.26 05:26:57.175 2024.11.26 05:26:57.757 2024.11.26 04:19:44.561 2024.11.26 04:19:44.863
24 5.0.2.1567 2024.11.18 e1289 P P 569 337 2024.11.21 07:31:20.641 2024.11.21 07:31:21.210 2024.11.21 06:24:51.124 2024.11.21 06:24:51.461
25 5.0.2.1533 2024.10.23 0ec43 F F 638 327 2024.11.18 07:47:34.302 2024.11.18 07:47:34.940 2024.11.18 06:39:10.609 2024.11.18 06:39:10.936

Elapsed time, ms. Chart for last 25 runs:

Last commits information (all timestamps in UTC):