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   
    Blobs: N, total length: M, blob pages: P
  - Level 0: X, total length: M, blob pages: P
  - Level 1: X, total length: M, blob pages: P
  - Level 2: X, total length: M, blob pages: P
  - Table size: N bytes

LOG DETAILS:

2025-02-14 14:31:22.675
2025-02-14 14:31:22.686 act = <firebird.qa.plugin.Action object at [hex]>
2025-02-14 14:31:22.696 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-02-14 14:31:22.705
2025-02-14 14:31:22.712 @pytest.mark.version('>=5.0.2')
2025-02-14 14:31:22.723 def test_1(act: Action, capsys):
2025-02-14 14:31:22.731
2025-02-14 14:31:22.741 act.isql(switches = ['-q'], input = test_sql, combine_output = True)
2025-02-14 14:31:22.753
2025-02-14 14:31:22.766 # Pipe of command to ISQL before 6.x leads to appearing of following 'noise info':
2025-02-14 14:31:22.776 # Database: localhost:..., User: SYSDBA
2025-02-14 14:31:22.785 # ...
2025-02-14 14:31:22.792 # We have to use 'clean_stdout' in order to ignore this:
2025-02-14 14:31:22.800 assert act.clean_stdout == ''
2025-02-14 14:31:22.806 act.reset()
2025-02-14 14:31:22.814
2025-02-14 14:31:22.820 #---------------------------------------------------------------------------------
2025-02-14 14:31:22.830
2025-02-14 14:31:22.843 blob_overall_info_ptn = re.compile( r'Blobs:\s+\d+,\s+total\s+length:\s+\d+,\s+blob\s+pages', re.IGNORECASE )
2025-02-14 14:31:22.855 blob_level_info_ptn = re.compile( r'Level\s+\d+: \d+,\s+total\s+length: \d+,\s+blob\s+pages', re.IGNORECASE )
2025-02-14 14:31:22.865 table_size_ptn = re.compile( r'Table\s+size:\s+\d+\s+bytes', re.IGNORECASE )
2025-02-14 14:31:22.874
2025-02-14 14:31:22.887 act.gstat(switches=['-r'])
2025-02-14 14:31:22.897 blob_overall_found = False
2025-02-14 14:31:22.910 for line in act.stdout.splitlines():
2025-02-14 14:31:22.920 if blob_overall_info_ptn.search(line):
2025-02-14 14:31:22.928 blob_overall_found = True
2025-02-14 14:31:22.941 print(line)
2025-02-14 14:31:22.949 if blob_overall_found:
2025-02-14 14:31:22.964 if blob_level_info_ptn.search(line):
2025-02-14 14:31:22.975 print(line)
2025-02-14 14:31:22.984 if table_size_ptn.search(line):
2025-02-14 14:31:22.994 print(line)
2025-02-14 14:31:23.004
2025-02-14 14:31:23.013
2025-02-14 14:31:23.020 act.expected_stdout = """
2025-02-14 14:31:23.028 Blobs: N, total length: M, blob pages: P
2025-02-14 14:31:23.034 Level 0: X, total length: M, blob pages: P
2025-02-14 14:31:23.044 Level 1: X, total length: M, blob pages: P
2025-02-14 14:31:23.053 Level 2: X, total length: M, blob pages: P
2025-02-14 14:31:23.061 Table size: N bytes
2025-02-14 14:31:23.071 """
2025-02-14 14:31:23.083 act.stdout = capsys.readouterr().out
2025-02-14 14:31:23.098 >       assert act.clean_stdout == act.clean_expected_stdout
2025-02-14 14:31:23.109 E       assert
2025-02-14 14:31:23.118 E           Blobs: N, total length: M, blob pages: P
2025-02-14 14:31:23.134 E         - Level 0: X, total length: M, blob pages: P
2025-02-14 14:31:23.144 E         - Level 1: X, total length: M, blob pages: P
2025-02-14 14:31:23.153 E         - Level 2: X, total length: M, blob pages: P
2025-02-14 14:31:23.161 E         - Table size: N bytes
2025-02-14 14:31:23.169
2025-02-14 14:31:23.177 tests/bugs/gh_8394_test.py:101: AssertionError
2025-02-14 14:31:23.184 ---------------------------- Captured stdout setup -----------------------------
2025-02-14 14:31:23.191 Creating db: localhost:/var/tmp/qa_2024/test_11682/test.fdb [page_size=8192, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
3 #text
act = <firebird.qa.plugin.Action pytest object at [hex]>
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>

    @pytest.mark.version('>=5.0.2')
    def test_1(act: Action, capsys):
    
        act.isql(switches = ['-q'], input = test_sql, combine_output = True)
    
        # Pipe of command to ISQL before 6.x leads to appearing of following 'noise info':
        # Database: localhost:..., User: SYSDBA
        # SQL> SQL> SQL> SQL> SQL> SQL> SQL> ...
        # We have to use 'clean_stdout' in order to ignore this:
        assert act.clean_stdout == ''
        act.reset()
    
        #---------------------------------------------------------------------------------
    
        blob_overall_info_ptn = re.compile( r'Blobs:\s+\d+,\s+total\s+length:\s+\d+,\s+blob\s+pages', re.IGNORECASE )
        blob_level_info_ptn = re.compile( r'Level\s+\d+: \d+,\s+total\s+length: \d+,\s+blob\s+pages', re.IGNORECASE )
        table_size_ptn = re.compile( r'Table\s+size:\s+\d+\s+bytes', re.IGNORECASE )
    
        act.gstat(switches=['-r'])
        blob_overall_found = False
        for line in act.stdout.splitlines():
            if blob_overall_info_ptn.search(line):
                blob_overall_found = True
                print(line)
            if blob_overall_found:
               if blob_level_info_ptn.search(line):
                   print(line)
               if table_size_ptn.search(line):
                   print(line)
    
    
        act.expected_stdout = """
            Blobs: N, total length: M, blob pages: P
            Level 0: X, total length: M, blob pages: P
            Level 1: X, total length: M, blob pages: P
            Level 2: X, total length: M, blob pages: P
            Table size: N bytes
        """
        act.stdout = capsys.readouterr().out
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E           Blobs: N, total length: M, blob pages: P
E         - Level 0: X, total length: M, blob pages: P
E         - Level 1: X, total length: M, blob pages: P
E         - Level 2: X, total length: M, blob pages: P
E         - Table size: N bytes

tests/bugs/gh_8394_test.py:101: 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.1674 2025.06.27 3ee5c P P 7015 6752 2025.06.30 12:49:27.698 2025.06.30 12:49:34.713 2025.06.30 11:28:36.833 2025.06.30 11:28:43.585
2 5.0.3.1657 2025.06.19 4bd4c P P 6890 6701 2025.06.27 12:21:38.271 2025.06.27 12:21:45.161 2025.06.27 11:02:40.430 2025.06.27 11:02:47.131
3 5.0.3.1657 2025.06.11 dae6f P P 7287 7277 2025.06.17 07:26:43.845 2025.06.17 07:26:51.132 2025.06.17 06:06:33.128 2025.06.17 06:06:40.405
4 5.0.3.1657 2025.06.10 dbc92 P P 7095 7831 2025.06.11 12:17:14.663 2025.06.11 12:17:21.758 2025.06.11 10:48:25.015 2025.06.11 10:48:32.846
5 5.0.3.1656 2025.05.20 c4b11 P P 8118 7976 2025.06.10 12:11:01.183 2025.06.10 12:11:09.301 2025.06.10 10:46:50.425 2025.06.10 10:46:58.401
6 5.0.3.1652 2025.05.13 f51c6 P P 9314 9628 2025.05.20 05:15:18.064 2025.05.20 05:15:27.378 2025.05.20 03:39:12.444 2025.05.20 03:39:22.072
7 5.0.3.1651 2025.04.30 141ef P P 9198 8231 2025.05.13 12:13:20.127 2025.05.13 12:13:29.325 2025.05.13 10:36:11.524 2025.05.13 10:36:19.755
8 5.0.3.1650 2025.04.28 4cbff P P 8818 8088 2025.05.01 11:47:07.085 2025.05.01 11:47:15.903 2025.05.01 10:10:56.626 2025.05.01 10:11:04.714
9 5.0.3.1649 2025.04.21 5b2d0 P P 8512 7952 2025.04.28 05:44:53.220 2025.04.28 05:45:01.732 2025.04.28 04:10:36.255 2025.04.28 04:10:44.207
10 5.0.3.1648 2025.04.18 2f4c5 P P 8713 7934 2025.04.20 05:36:38.430 2025.04.20 05:36:47.143 2025.04.20 04:04:55.805 2025.04.20 04:05:03.739
11 5.0.3.1635 2025.03.31 22ec6 P P 8556 8131 2025.04.18 11:59:42.995 2025.04.18 11:59:51.551 2025.04.18 10:24:06.719 2025.04.18 10:24:14.850
12 5.0.3.1633 2025.03.28 3123a P P 8258 8645 2025.03.31 10:33:30.544 2025.03.31 10:33:38.802 2025.03.31 09:04:15.367 2025.03.31 09:04:24.012
13 5.0.3.1633 2025.03.27 e0fb8 P P 8809 9732 2025.03.28 11:08:52.167 2025.03.28 11:09:00.976 2025.03.28 09:36:49.701 2025.03.28 09:36:59.433
14 5.0.3.1631 2025.03.21 1925b P P 9560 8395 2025.03.27 10:56:38.076 2025.03.27 10:56:47.636 2025.03.27 09:25:29.001 2025.03.27 09:25:37.396
15 5.0.3.1628 2025.03.14 16d05 P P 42962 26493 2025.03.17 08:29:50.582 2025.03.17 08:30:33.544 2025.03.17 06:49:48.945 2025.03.17 06:50:15.438
16 5.0.3.1627 2025.02.26 4e218 P P 43892 25829 2025.03.14 11:44:12.698 2025.03.14 11:44:56.590 2025.03.14 10:03:07.926 2025.03.14 10:03:33.755
17 5.0.3.1624 2025.02.25 dc3b2 P P 47391 26032 2025.02.26 10:34:46.138 2025.02.26 10:35:33.529 2025.02.26 08:59:11.278 2025.02.26 08:59:37.310
18 5.0.2.1615 2025.02.20 4a726 P P 3909 2170 2025.02.25 11:02:08.112 2025.02.25 11:02:12.021 2025.02.25 09:24:44.811 2025.02.25 09:24:46.981
19 5.0.2.1615 2025.02.14 9cb76 P P 2607 2365 2025.02.20 07:51:21.236 2025.02.20 07:51:23.843 2025.02.20 06:17:40.421 2025.02.20 06:17:42.786
20 5.0.2.1577 2024.12.24 3c80e F F 2703 2349 2025.02.14 11:05:17.483 2025.02.14 11:05:20.186 2025.02.14 09:31:14.115 2025.02.14 09:31:16.464

Elapsed time, ms. Chart for last 20 runs:

Last commits information (all timestamps in UTC):