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 09:37:03.850
2025-02-14 09:37:03.850 act = <firebird.qa.plugin.Action object at [hex]>
2025-02-14 09:37:03.850 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-02-14 09:37:03.851
2025-02-14 09:37:03.851     @pytest.mark.version('>=5.0.2')
2025-02-14 09:37:03.851     def test_1(act: Action, capsys):
2025-02-14 09:37:03.851
2025-02-14 09:37:03.851         act.isql(switches = ['-q'], input = test_sql, combine_output = True)
2025-02-14 09:37:03.851
2025-02-14 09:37:03.851         # Pipe of command to ISQL before 6.x leads to appearing of following 'noise info':
2025-02-14 09:37:03.851         # Database: localhost:..., User: SYSDBA
2025-02-14 09:37:03.851         # ...
2025-02-14 09:37:03.851         # We have to use 'clean_stdout' in order to ignore this:
2025-02-14 09:37:03.851         assert act.clean_stdout == ''
2025-02-14 09:37:03.851         act.reset()
2025-02-14 09:37:03.851
2025-02-14 09:37:03.851         #---------------------------------------------------------------------------------
2025-02-14 09:37:03.851
2025-02-14 09:37:03.851         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 09:37:03.851         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 09:37:03.851         table_size_ptn = re.compile( r'Table\s+size:\s+\d+\s+bytes', re.IGNORECASE )
2025-02-14 09:37:03.851
2025-02-14 09:37:03.852         act.gstat(switches=['-r'])
2025-02-14 09:37:03.852         blob_overall_found = False
2025-02-14 09:37:03.852         for line in act.stdout.splitlines():
2025-02-14 09:37:03.852             if blob_overall_info_ptn.search(line):
2025-02-14 09:37:03.852                 blob_overall_found = True
2025-02-14 09:37:03.852                 print(line)
2025-02-14 09:37:03.852             if blob_overall_found:
2025-02-14 09:37:03.852                if blob_level_info_ptn.search(line):
2025-02-14 09:37:03.852                    print(line)
2025-02-14 09:37:03.852                if table_size_ptn.search(line):
2025-02-14 09:37:03.852                    print(line)
2025-02-14 09:37:03.852
2025-02-14 09:37:03.852
2025-02-14 09:37:03.852         act.expected_stdout = """
2025-02-14 09:37:03.852             Blobs: N, total length: M, blob pages: P
2025-02-14 09:37:03.852             Level 0: X, total length: M, blob pages: P
2025-02-14 09:37:03.852             Level 1: X, total length: M, blob pages: P
2025-02-14 09:37:03.852             Level 2: X, total length: M, blob pages: P
2025-02-14 09:37:03.852             Table size: N bytes
2025-02-14 09:37:03.852         """
2025-02-14 09:37:03.853         act.stdout = capsys.readouterr().out
2025-02-14 09:37:03.853 >       assert act.clean_stdout == act.clean_expected_stdout
2025-02-14 09:37:03.853 E       assert
2025-02-14 09:37:03.853 E           Blobs: N, total length: M, blob pages: P
2025-02-14 09:37:03.853 E         - Level 0: X, total length: M, blob pages: P
2025-02-14 09:37:03.853 E         - Level 1: X, total length: M, blob pages: P
2025-02-14 09:37:03.853 E         - Level 2: X, total length: M, blob pages: P
2025-02-14 09:37:03.853 E         - Table size: N bytes
2025-02-14 09:37:03.853
2025-02-14 09:37:03.853 tests\bugs\gh_8394_test.py:101: AssertionError
2025-02-14 09:37:03.853 ---------------------------- Captured stdout setup ----------------------------
2025-02-14 09:37:03.853 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11704\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 1233 925 2025.06.29 11:07:35.844 2025.06.29 11:07:37.077 2025.06.29 10:06:42.278 2025.06.29 10:06:43.203
2 5.0.3.1657 2025.06.26 dcb8a P P 1199 933 2025.06.27 11:08:15.825 2025.06.27 11:08:17.024 2025.06.27 10:07:20.130 2025.06.27 10:07:21.063
3 5.0.3.1657 2025.06.20 8b4d2 P P 1183 907 2025.06.26 11:22:43.800 2025.06.26 11:22:44.983 2025.06.26 10:21:36.875 2025.06.26 10:21:37.782
4 5.0.3.1657 2025.06.19 4bd4c P P 1185 911 2025.06.20 05:26:58.080 2025.06.20 05:26:59.265 2025.06.20 04:25:55.091 2025.06.20 04:25:56.002
5 5.0.3.1657 2025.06.11 dae6f P P 1226 913 2025.06.19 10:58:25.327 2025.06.19 10:58:26.553 2025.06.19 09:57:18.753 2025.06.19 09:57:19.666
6 5.0.3.1657 2025.06.10 dbc92 P P 1185 914 2025.06.11 08:44:35.302 2025.06.11 08:44:36.487 2025.06.11 07:43:15.752 2025.06.11 07:43:16.666
7 5.0.3.1656 2025.06.05 00512 P P 1249 914 2025.06.10 10:00:05.427 2025.06.10 10:00:06.676 2025.06.10 08:58:20.612 2025.06.10 08:58:21.526
8 5.0.3.1656 2025.05.20 c4b11 P P 1208 903 2025.06.03 09:46:58.396 2025.06.03 09:46:59.604 2025.06.03 08:46:24.525 2025.06.03 08:46:25.428
9 5.0.3.1652 2025.05.13 f51c6 P P 1189 928 2025.05.21 06:27:58.096 2025.05.21 06:27:59.285 2025.05.21 05:27:40.285 2025.05.21 05:27:41.213
10 5.0.3.1651 2025.05.08 ee9d2 P E 1200 2377 2025.05.13 06:40:37.275 2025.05.13 06:40:38.475 2025.05.13 05:21:54.302 2025.05.13 05:21:56.679
11 5.0.3.1651 2025.05.04 3d914 P E 1221 2381 2025.05.09 04:29:40.200 2025.05.09 04:29:41.421 2025.05.09 03:10:52.133 2025.05.09 03:10:54.514
12 5.0.3.1651 2025.04.30 141ef P E 1219 2393 2025.05.02 04:37:17.212 2025.05.02 04:37:18.431 2025.05.02 03:18:45.477 2025.05.02 03:18:47.870
13 5.0.3.1650 2025.04.30 6253f P E 1208 2383 2025.05.01 04:36:19.957 2025.05.01 04:36:21.165 2025.05.01 03:17:41.748 2025.05.01 03:17:44.131
14 5.0.3.1650 2025.04.28 4cbff P E 1186 2400 2025.04.30 04:35:21.591 2025.04.30 04:35:22.777 2025.04.30 03:16:54.756 2025.04.30 03:16:57.156
15 5.0.3.1649 2025.04.21 5b2d0 P E 1196 2387 2025.04.26 10:09:16.866 2025.04.26 10:09:18.062 2025.04.26 08:49:54.776 2025.04.26 08:49:57.163
16 5.0.3.1648 2025.04.18 2f4c5 P P 1217 939 2025.04.20 04:20:30.949 2025.04.20 04:20:32.166 2025.04.20 03:19:11.782 2025.04.20 03:19:12.721
17 5.0.3.1635 2025.04.03 f6bd1 P E 1195 2412 2025.04.18 06:48:11.806 2025.04.18 06:48:13.001 2025.04.18 05:29:05.066 2025.04.18 05:29:07.478
18 5.0.3.1635 2025.03.31 22ec6 P E 1226 2384 2025.04.03 09:54:00.927 2025.04.03 09:54:02.153 2025.04.03 08:34:35.355 2025.04.03 08:34:37.739
19 5.0.3.1633 2025.03.28 3123a P E 1215 2377 2025.03.31 09:52:30.158 2025.03.31 09:52:31.373 2025.03.31 08:33:11.418 2025.03.31 08:33:13.795
20 5.0.3.1633 2025.03.27 e0fb8 P E 1309 2438 2025.03.28 10:24:08.970 2025.03.28 10:24:10.279 2025.03.28 09:01:05.740 2025.03.28 09:01:08.178
21 5.0.3.1631 2025.03.25 bda65 P P 1245 975 2025.03.27 10:04:40.318 2025.03.27 10:04:41.563 2025.03.27 08:59:38.808 2025.03.27 08:59:39.783
22 5.0.3.1631 2025.03.21 1925b P P 1287 971 2025.03.25 06:38:42.629 2025.03.25 06:38:43.916 2025.03.25 05:33:32.034 2025.03.25 05:33:33.005
23 5.0.3.1629 2025.03.18 506d7 P P 1202 935 2025.03.20 09:39:00.088 2025.03.20 09:39:01.290 2025.03.20 08:33:39.102 2025.03.20 08:33:40.037
24 5.0.3.1628 2025.03.14 16d05 P P 1193 920 2025.03.18 09:33:07.945 2025.03.18 09:33:09.138 2025.03.18 08:29:20.945 2025.03.18 08:29:21.865
25 5.0.3.1627 2025.02.26 4e218 P P 1274 960 2025.03.13 09:52:25.822 2025.03.13 09:52:27.096 2025.03.13 08:46:53.160 2025.03.13 08:46:54.120
26 5.0.3.1624 2025.02.25 dc3b2 P P 1238 917 2025.02.26 15:24:41.122 2025.02.26 15:24:42.360 2025.02.26 14:19:49.883 2025.02.26 14:19:50.800
27 5.0.2.1615 2025.02.20 4a726 P P 1221 937 2025.02.25 08:39:15.036 2025.02.25 08:39:16.257 2025.02.25 07:17:35.434 2025.02.25 07:17:36.371
28 5.0.2.1615 2025.02.14 9cb76 P P 1241 927 2025.02.15 04:06:53.757 2025.02.15 04:06:54.998 2025.02.15 03:03:51.456 2025.02.15 03:03:52.383
29 5.0.2.1577 2025.02.07 f50a2 F F 1230 951 2025.02.14 06:19:31.340 2025.02.14 06:19:32.570 2025.02.14 05:17:39.878 2025.02.14 05:17:40.829
30 5.0.2.1577 2024.12.24 3c80e F F 1308 948 2025.02.06 09:33:03.627 2025.02.06 09:33:04.935 2025.02.06 08:31:14.965 2025.02.06 08:31:15.913

Elapsed time, ms. Chart for last 30 runs:

Last commits information (all timestamps in UTC):