Jump to: output_first_mismatch    outcomes_full_history    elapsed_time_chart
Show cross-report outcomes.

Annotation type Annotation details
2 @message
Performance problem

assert   
  - CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: EXPECTED
  + CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: /* perf_issue_tag */ UNEXPECTED less than 6
    CPU time ratio when sending INCOMPRESSABLE BINARY DATA and WireCompression is ON vs OFF: EXPECTED
    CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: EXPECTED
  + compressed_txt= [0.375, 0.375, 0.328125, 0.34375, 0.328125, 0.3125, 0.328125, 0.265625, 0.375]  min= 0.265625  max= 0.375
  + compressed_bin= [0.40625, 0.328125, 0.375, 0.3125, 0.375, 0.390625, 0.34375, 0.375, 0.328125]  min= 0.3125  max= 0.40625
  + non_comprs_txt= [0.0625, 0.03125, 0.109375, 0.046875, 0.078125, 0.046875, 0.0625, 0.109375, 0.0625]  min= 0.03125  max= 0.109375
  + non_comprs_bin= [0.09375, 0.09375, 0.078125, 0.078125, 0.03125, 0.03125, 0.109375, 0.09375, 0.046875]  min= 0.03125  max= 0.109375
  + median(compressed_txt) / median(non_comprs_txt) = 5.25
  + median(compressed_bin) / median(non_comprs_bin) = 4.8
  + median(non_comprs_txt) / median(non_comprs_bin) = 0.8

LOG DETAILS:

2024-09-01 14:46:59.151
2024-09-01 14:46:59.151 act = <firebird.qa.plugin.Action object at [hex]>
2024-09-01 14:46:59.151 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2024-09-01 14:46:59.151
2024-09-01 14:46:59.151     @pytest.mark.version('>=3.0')
2024-09-01 14:46:59.151     def test_1(act: Action, capsys):
2024-09-01 14:46:59.151
2024-09-01 14:46:59.151         # OPTIONAL CHECK: minimal ratio between CPU user time when WireCompression = false
2024-09-01 14:46:59.151         # and engine sends to client: 1) 'IDEALLY COMPRESSABLE'; 2) 'ABSOLUTELY IMCOMPRESSIBLE' data.
2024-09-01 14:46:59.151         # This can be useful to estimate record-level compression: textual data can be compressed
2024-09-01 14:46:59.151         # very well, so its transfer must take much less time then for GEN_UUID.
2024-09-01 14:46:59.151         # Experiments show that this ratio can be on Windows in the scope 0.3.... 0.8,
2024-09-01 14:46:59.151         # but on Linux it can be 1.0 or even slightly more then 1(!)
2024-09-01 14:46:59.151         # Windows: 0.500; 0.600; 0.571; 0.428; 0.714; 0.667; 0.625; 0.429; 0.571 // 4.0.1
2024-09-01 14:46:59.151         #          0.454; 0.357; 0.357; 0.500; 0.250; 0.385; 0.333; 0.200; 0.500 // 3.0.8
2024-09-01 14:46:59.151         # Linux:   0.684; 1.000; 1.000; 1.067; 0.867; 0.813; 0.800; 0.777; 0.750 // 4.0.1
2024-09-01 14:46:59.151         #          0.928; 1.000; 0.933; 1.000; 1.077; 0.750; 0.938; 0.929; 0.928 // 3.0.8
2024-09-01 14:46:59.151         if act.is_version('<4'):
2024-09-01 14:46:59.152             # 16.09.2022, 4.3.0.8 Classic: Windows -> 1.2
2024-09-01 14:46:59.152             MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF = 1.1 if platform.system() == 'Linux' else 1.5
2024-09-01 14:46:59.152         else:
2024-09-01 14:46:59.152             # 05.03.2023, 5.0.0.970, SS, Linux: 1.1 --> 1.3
2024-09-01 14:46:59.152             # 05.04.2023, 5.0.0.1001, SS, WIndows: 0.95 --> 1.5
2024-09-01 14:46:59.152             MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF = 1.3 if platform.system() == 'Linux' else 1.5
2024-09-01 14:46:59.152
2024-09-01 14:46:59.152         # Register Firebird server (D:\FB\probes\fid-set-dpb-probe-05x.py)
2024-09-01 14:46:59.152         srv_cfg = driver_config.register_server(name = 'test_srv_core_0733', config = '')
2024-09-01 14:46:59.152
2024-09-01 14:46:59.152         #srv_config_key_value_text = \
2024-09-01 14:46:59.152         #f"""
2024-09-01 14:46:59.152         #    [test_srv_core_0733]
2024-09-01 14:46:59.152         #    protocol = inet
2024-09-01 14:46:59.152         #"""
2024-09-01 14:46:59.152         #driver_config.register_server(name = 'test_srv_core_0733', config = srv_config_key_value_text)
2024-09-01 14:46:59.152         #db_cfg_object = driver_config.register_database(name = 'test_db_core_0733')
2024-09-01 14:46:59.152         #db_cfg_object.database.value = str(act.db.db_path)
2024-09-01 14:46:59.152
2024-09-01 14:46:59.153         benchmark_data = defaultdict(list)
2024-09-01 14:46:59.153
2024-09-01 14:46:59.153         for w_compr in (True, False):
2024-09-01 14:46:59.153
2024-09-01 14:46:59.153             db_cfg_name = f'test_db_core_0733__wcompr_{w_compr}'
2024-09-01 14:46:59.153             db_cfg_object = driver_config.register_database(name = db_cfg_name)
2024-09-01 14:46:59.153             db_cfg_object.server.value = srv_cfg.name
2024-09-01 14:46:59.153             # db_cfg_object.protocol.value = None /  XNET /  WNET -- these can not be used in this test!
2024-09-01 14:46:59.153             db_cfg_object.protocol.value = NetProtocol.INET
2024-09-01 14:46:59.153             db_cfg_object.database.value = str(act.db.db_path)
2024-09-01 14:46:59.153             db_cfg_object.config.value = f"""
2024-09-01 14:46:59.153                 WireCrypt = Disabled
2024-09-01 14:46:59.153                 WireCompression = {w_compr}
2024-09-01 14:46:59.153             """
2024-09-01 14:46:59.153             for i in range(0, N_MEASURES):
2024-09-01 14:46:59.153                 with connect(db_cfg_name, user = act.db.user, password = act.db.password) as con:
2024-09-01 14:46:59.153                     prot_name = db_cfg_object.protocol.value.name if db_cfg_object.protocol.value else 'Embedded'
2024-09-01 14:46:59.153                     assert w_compr == con.info.is_compressed(), f'Protocol: {prot_name} - can not be used to measure wire_compression'
2024-09-01 14:46:59.154
2024-09-01 14:46:59.154                     with con.cursor() as cur:
2024-09-01 14:46:59.154                         cur.execute('select mon$server_pid, mon$remote_protocol as p from mon$attachments where mon$attachment_id = current_connection')
2024-09-01 14:46:59.154                         for r in cur:
2024-09-01 14:46:59.154                             fb_pid, connection_protocol = r
2024-09-01 14:46:59.154                             assert connection_protocol.startswith('TCP'), f'Invalid connection protocol: {connection_protocol}'
2024-09-01 14:46:59.154
2024-09-01 14:46:59.154                         for data_source in ('t_common_text', 't_binary_data'):
2024-09-01 14:46:59.154                             cur.execute('select s from ' + data_source)
2024-09-01 14:46:59.154
2024-09-01 14:46:59.154                             fb_info_a = psutil.Process(fb_pid).cpu_times()
2024-09-01 14:46:59.154                             for r in cur:
2024-09-01 14:46:59.154                                 # *** FULL FETCH ***
2024-09-01 14:46:59.154                                 pass
2024-09-01 14:46:59.154                             fb_info_b = psutil.Process(fb_pid).cpu_times()
2024-09-01 14:46:59.154
2024-09-01 14:46:59.154                             k = ('WireCompression=%d' % (1 if w_compr else 0), 'DataSource='+data_source)
2024-09-01 14:46:59.155                             benchmark_data[k] += fb_info_b.user - fb_info_a.user,
2024-09-01 14:46:59.155
2024-09-01 14:46:59.155
2024-09-01 14:46:59.155         compressed_txt = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=1' and k[1] == 'DataSource=t_common_text'][0]
2024-09-01 14:46:59.155         compressed_bin = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=1' and k[1] == 'DataSource=t_binary_data'][0]
2024-09-01 14:46:59.155         non_comprs_txt = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=0' and k[1] == 'DataSource=t_common_text'][0]
2024-09-01 14:46:59.155         non_comprs_bin = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=0' and k[1] == 'DataSource=t_binary_data'][0]
2024-09-01 14:46:59.155
2024-09-01 14:46:59.155         cpu_txt_wcompr_ON_vs_OFF = median(compressed_txt) / max(0.00001, median(non_comprs_txt))
2024-09-01 14:46:59.155         cpu_bin_wcompr_ON_vs_OFF = median(compressed_bin) / max(0.00001, median(non_comprs_bin))
2024-09-01 14:46:59.155         cpu_txt2bin_wcompr_OFF = median(non_comprs_txt) / max(0.00001, median(non_comprs_bin))
2024-09-01 14:46:59.155
2024-09-01 14:46:59.155         msg_result1 = 'CPU time ratio when sending %s and WireCompression is ON vs OFF: %s'
2024-09-01 14:46:59.155         what_sent1 = 'COMPRESSABLE TEXTUAL DATA'
2024-09-01 14:46:59.155         all_fine = 1
2024-09-01 14:46:59.155         if cpu_txt_wcompr_ON_vs_OFF > MIN_CPU_RATIO_TXT_WCOMPR_ON_OFF:
2024-09-01 14:46:59.155             print(msg_result1 % (what_sent1, 'EXPECTED') )
2024-09-01 14:46:59.155         else:
2024-09-01 14:46:59.155             print(msg_result1 % (what_sent1, '/* perf_issue_tag */ UNEXPECTED less than '+str(MIN_CPU_RATIO_TXT_WCOMPR_ON_OFF)) )
2024-09-01 14:46:59.156             all_fine = 0
2024-09-01 14:46:59.156
2024-09-01 14:46:59.156
2024-09-01 14:46:59.156         what_sent2 = 'INCOMPRESSABLE BINARY DATA'
2024-09-01 14:46:59.156         if cpu_bin_wcompr_ON_vs_OFF > MIN_CPU_RATIO_BIN_WCOMPR_ON_OFF:
2024-09-01 14:46:59.156             print(msg_result1 % (what_sent2, 'EXPECTED') )
2024-09-01 14:46:59.156         else:
2024-09-01 14:46:59.156             print(msg_result1 % (what_sent2, '/* perf_issue_tag */ UNEXPECTED, less than '+str(MIN_CPU_RATIO_BIN_WCOMPR_ON_OFF)) )
2024-09-01 14:46:59.156             all_fine = 0
2024-09-01 14:46:59.156
2024-09-01 14:46:59.156
2024-09-01 14:46:59.156         msg_result2 = 'CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: %s'
2024-09-01 14:46:59.156         if cpu_txt2bin_wcompr_OFF <= MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF:
2024-09-01 14:46:59.156             print(msg_result2 % ('EXPECTED') )
2024-09-01 14:46:59.156         else:
2024-09-01 14:46:59.156             print(msg_result2 % ('/* perf_issue_tag */ UNEXPECTED, more than ' + str(MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF)) )
2024-09-01 14:46:59.156             all_fine = 0
2024-09-01 14:46:59.156
2024-09-01 14:46:59.156         if not all_fine:
2024-09-01 14:46:59.156             print('compressed_txt=',compressed_txt,' min=',min(compressed_txt),' max=',max(compressed_txt))
2024-09-01 14:46:59.157             print('compressed_bin=',compressed_bin,' min=',min(compressed_bin),' max=',max(compressed_bin))
2024-09-01 14:46:59.157             print('non_comprs_txt=',non_comprs_txt,' min=',min(non_comprs_txt),' max=',max(non_comprs_txt))
2024-09-01 14:46:59.157             print('non_comprs_bin=',non_comprs_bin,' min=',min(non_comprs_bin),' max=',max(non_comprs_bin))
2024-09-01 14:46:59.157
2024-09-01 14:46:59.157             print('median(compressed_txt) / median(non_comprs_txt) =',1.000 * median(compressed_txt) / max(0.00001, median(non_comprs_txt)) )
2024-09-01 14:46:59.157             print('median(compressed_bin) / median(non_comprs_bin) =',1.000 * median(compressed_bin) / max(0.00001, median(non_comprs_bin)) )
2024-09-01 14:46:59.157             print('median(non_comprs_txt) / median(non_comprs_bin) =',1.000 * median(non_comprs_txt) / max(0.00001, median(non_comprs_bin)) )
2024-09-01 14:46:59.157
2024-09-01 14:46:59.157
2024-09-01 14:46:59.157         expected_stdout = ''
2024-09-01 14:46:59.157         for f in (what_sent1, what_sent2):
2024-09-01 14:46:59.157             expected_stdout += ''.join( (msg_result1 % (f, 'EXPECTED'), '\n')  )
2024-09-01 14:46:59.157         expected_stdout += (msg_result2 % 'EXPECTED')
2024-09-01 14:46:59.157
2024-09-01 14:46:59.157         act.expected_stdout = expected_stdout
2024-09-01 14:46:59.157         act.stdout = capsys.readouterr().out
2024-09-01 14:46:59.157 >       assert act.clean_stdout == act.clean_expected_stdout
2024-09-01 14:46:59.157 E       assert
2024-09-01 14:46:59.158 E         - CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: EXPECTED
2024-09-01 14:46:59.158 E         + CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: /* perf_issue_tag */ UNEXPECTED less than 6
2024-09-01 14:46:59.158 E           CPU time ratio when sending INCOMPRESSABLE BINARY DATA and WireCompression is ON vs OFF: EXPECTED
2024-09-01 14:46:59.158 E           CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: EXPECTED
2024-09-01 14:46:59.158 E         + compressed_txt= [0.375, 0.375, 0.328125, 0.34375, 0.328125, 0.3125, 0.328125, 0.265625, 0.375]  min= 0.265625  max= 0.375
2024-09-01 14:46:59.158 E         + compressed_bin= [0.40625, 0.328125, 0.375, 0.3125, 0.375, 0.390625, 0.34375, 0.375, 0.328125]  min= 0.3125  max= 0.40625
2024-09-01 14:46:59.158 E         + non_comprs_txt= [0.0625, 0.03125, 0.109375, 0.046875, 0.078125, 0.046875, 0.0625, 0.109375, 0.0625]  min= 0.03125  max= 0.109375
2024-09-01 14:46:59.158 E         + non_comprs_bin= [0.09375, 0.09375, 0.078125, 0.078125, 0.03125, 0.03125, 0.109375, 0.09375, 0.046875]  min= 0.03125  max= 0.109375
2024-09-01 14:46:59.158 E         + median(compressed_txt) / median(non_comprs_txt) = 5.25
2024-09-01 14:46:59.158 E         + median(compressed_bin) / median(non_comprs_bin) = 4.8
2024-09-01 14:46:59.158 E         + median(non_comprs_txt) / median(non_comprs_bin) = 0.8
2024-09-01 14:46:59.158
2024-09-01 14:46:59.158 tests\bugs\core_0733_test.py:254: AssertionError
2024-09-01 14:46:59.158 ---------------------------- Captured stdout setup ----------------------------
2024-09-01 14:46:59.158 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_173\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]>
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>

    @pytest.mark.version('>=3.0')
    def test_1(act: Action, capsys):
    
        # OPTIONAL CHECK: minimal ratio between CPU user time when WireCompression = false
        # and engine sends to client: 1) 'IDEALLY COMPRESSABLE'; 2) 'ABSOLUTELY IMCOMPRESSIBLE' data.
        # This can be useful to estimate record-level compression: textual data can be compressed
        # very well, so its transfer must take much less time then for GEN_UUID.
        # Experiments show that this ratio can be on Windows in the scope 0.3.... 0.8,
        # but on Linux it can be 1.0 or even slightly more then 1(!)
        # Windows: 0.500; 0.600; 0.571; 0.428; 0.714; 0.667; 0.625; 0.429; 0.571 // 4.0.1
        #          0.454; 0.357; 0.357; 0.500; 0.250; 0.385; 0.333; 0.200; 0.500 // 3.0.8
        # Linux:   0.684; 1.000; 1.000; 1.067; 0.867; 0.813; 0.800; 0.777; 0.750 // 4.0.1
        #          0.928; 1.000; 0.933; 1.000; 1.077; 0.750; 0.938; 0.929; 0.928 // 3.0.8
        if act.is_version('<4'):
            # 16.09.2022, 4.3.0.8 Classic: Windows -> 1.2
            MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF = 1.1 if platform.system() == 'Linux' else 1.5
        else:
            # 05.03.2023, 5.0.0.970, SS, Linux: 1.1 --> 1.3
            # 05.04.2023, 5.0.0.1001, SS, WIndows: 0.95 --> 1.5
            MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF = 1.3 if platform.system() == 'Linux' else 1.5
    
        # Register Firebird server (D:\FB\probes\fid-set-dpb-probe-05x.py)
        srv_cfg = driver_config.register_server(name = 'test_srv_core_0733', config = '')
    
        #srv_config_key_value_text = \
        #f"""
        #    [test_srv_core_0733]
        #    protocol = inet
        #"""
        #driver_config.register_server(name = 'test_srv_core_0733', config = srv_config_key_value_text)
        #db_cfg_object = driver_config.register_database(name = 'test_db_core_0733')
        #db_cfg_object.database.value = str(act.db.db_path)
    
        benchmark_data = defaultdict(list)
    
        for w_compr in (True, False):
    
            db_cfg_name = f'test_db_core_0733__wcompr_{w_compr}'
            db_cfg_object = driver_config.register_database(name = db_cfg_name)
            db_cfg_object.server.value = srv_cfg.name
            # db_cfg_object.protocol.value = None /  XNET /  WNET -- these can not be used in this test!
            db_cfg_object.protocol.value = NetProtocol.INET
            db_cfg_object.database.value = str(act.db.db_path)
            db_cfg_object.config.value = f"""
                WireCrypt = Disabled
                WireCompression = {w_compr}
            """
            for i in range(0, N_MEASURES):
                with connect(db_cfg_name, user = act.db.user, password = act.db.password) as con:
                    prot_name = db_cfg_object.protocol.value.name if db_cfg_object.protocol.value else 'Embedded'
                    assert w_compr == con.info.is_compressed(), f'Protocol: {prot_name} - can not be used to measure wire_compression'
    
                    with con.cursor() as cur:
                        cur.execute('select mon$server_pid, mon$remote_protocol as p from mon$attachments where mon$attachment_id = current_connection')
                        for r in cur:
                            fb_pid, connection_protocol = r
                            assert connection_protocol.startswith('TCP'), f'Invalid connection protocol: {connection_protocol}'
    
                        for data_source in ('t_common_text', 't_binary_data'):
                            cur.execute('select s from ' + data_source)
    
                            fb_info_a = psutil.Process(fb_pid).cpu_times()
                            for r in cur:
                                # *** FULL FETCH ***
                                pass
                            fb_info_b = psutil.Process(fb_pid).cpu_times()
    
                            k = ('WireCompression=%d' % (1 if w_compr else 0), 'DataSource='+data_source)
                            benchmark_data[k] += fb_info_b.user - fb_info_a.user,
    
    
        compressed_txt = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=1' and k[1] == 'DataSource=t_common_text'][0]
        compressed_bin = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=1' and k[1] == 'DataSource=t_binary_data'][0]
        non_comprs_txt = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=0' and k[1] == 'DataSource=t_common_text'][0]
        non_comprs_bin = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=0' and k[1] == 'DataSource=t_binary_data'][0]
    
        cpu_txt_wcompr_ON_vs_OFF = median(compressed_txt) / max(0.00001, median(non_comprs_txt))
        cpu_bin_wcompr_ON_vs_OFF = median(compressed_bin) / max(0.00001, median(non_comprs_bin))
        cpu_txt2bin_wcompr_OFF = median(non_comprs_txt) / max(0.00001, median(non_comprs_bin))
    
        msg_result1 = 'CPU time ratio when sending %s and WireCompression is ON vs OFF: %s'
        what_sent1 = 'COMPRESSABLE TEXTUAL DATA'
        all_fine = 1
        if cpu_txt_wcompr_ON_vs_OFF > MIN_CPU_RATIO_TXT_WCOMPR_ON_OFF:
            print(msg_result1 % (what_sent1, 'EXPECTED') )
        else:
            print(msg_result1 % (what_sent1, '/* perf_issue_tag */ UNEXPECTED less than '+str(MIN_CPU_RATIO_TXT_WCOMPR_ON_OFF)) )
            all_fine = 0
    
    
        what_sent2 = 'INCOMPRESSABLE BINARY DATA'
        if cpu_bin_wcompr_ON_vs_OFF > MIN_CPU_RATIO_BIN_WCOMPR_ON_OFF:
            print(msg_result1 % (what_sent2, 'EXPECTED') )
        else:
            print(msg_result1 % (what_sent2, '/* perf_issue_tag */ UNEXPECTED, less than '+str(MIN_CPU_RATIO_BIN_WCOMPR_ON_OFF)) )
            all_fine = 0
    
    
        msg_result2 = 'CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: %s'
        if cpu_txt2bin_wcompr_OFF <= MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF:
            print(msg_result2 % ('EXPECTED') )
        else:
            print(msg_result2 % ('/* perf_issue_tag */ UNEXPECTED, more than ' + str(MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF)) )
            all_fine = 0
    
        if not all_fine:
            print('compressed_txt=',compressed_txt,' min=',min(compressed_txt),' max=',max(compressed_txt))
            print('compressed_bin=',compressed_bin,' min=',min(compressed_bin),' max=',max(compressed_bin))
            print('non_comprs_txt=',non_comprs_txt,' min=',min(non_comprs_txt),' max=',max(non_comprs_txt))
            print('non_comprs_bin=',non_comprs_bin,' min=',min(non_comprs_bin),' max=',max(non_comprs_bin))
    
            print('median(compressed_txt) / median(non_comprs_txt) =',1.000 * median(compressed_txt) / max(0.00001, median(non_comprs_txt)) )
            print('median(compressed_bin) / median(non_comprs_bin) =',1.000 * median(compressed_bin) / max(0.00001, median(non_comprs_bin)) )
            print('median(non_comprs_txt) / median(non_comprs_bin) =',1.000 * median(non_comprs_txt) / max(0.00001, median(non_comprs_bin)) )
    
    
        expected_stdout = ''
        for f in (what_sent1, what_sent2):
            expected_stdout += ''.join( (msg_result1 % (f, 'EXPECTED'), '\n')  )
        expected_stdout += (msg_result2 % 'EXPECTED')
    
        act.expected_stdout = expected_stdout
        act.stdout = capsys.readouterr().out
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E         - CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: EXPECTED
E         + CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: /* perf_issue_tag */ UNEXPECTED less than 6
E           CPU time ratio when sending INCOMPRESSABLE BINARY DATA and WireCompression is ON vs OFF: EXPECTED
E           CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: EXPECTED
E         + compressed_txt= [0.375, 0.375, 0.328125, 0.34375, 0.328125, 0.3125, 0.328125, 0.265625, 0.375]  min= 0.265625  max= 0.375
E         + compressed_bin= [0.40625, 0.328125, 0.375, 0.3125, 0.375, 0.390625, 0.34375, 0.375, 0.328125]  min= 0.3125  max= 0.40625
E         + non_comprs_txt= [0.0625, 0.03125, 0.109375, 0.046875, 0.078125, 0.046875, 0.0625, 0.109375, 0.0625]  min= 0.03125  max= 0.109375
E         + non_comprs_bin= [0.09375, 0.09375, 0.078125, 0.078125, 0.03125, 0.03125, 0.109375, 0.09375, 0.046875]  min= 0.03125  max= 0.109375
E         + median(compressed_txt) / median(non_comprs_txt) = 5.25
E         + median(compressed_bin) / median(non_comprs_bin) = 4.8
E         + median(non_comprs_txt) / median(non_comprs_bin) = 0.8

tests\bugs\core_0733_test.py:254: 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 4.0.6.3189 2025.02.25 1a1a5 F F 16972 16081 2025.06.29 12:32:57.901 2025.06.29 12:33:14.873 2025.06.29 11:42:16.237 2025.06.29 11:42:32.318
2 4.0.6.3184 2025.02.24 9388c F F 16906 16232 2025.02.25 10:14:53.979 2025.02.25 10:15:10.885 2025.02.25 09:05:57.787 2025.02.25 09:06:14.019
3 4.0.6.3183 2025.02.17 e4762 F F 16975 16688 2025.02.24 10:47:08.659 2025.02.24 10:47:25.634 2025.02.24 09:56:10.019 2025.02.24 09:56:26.707
4 4.0.6.3169 2024.12.13 42cc1 F F 17182 16387 2025.02.14 07:34:46.052 2025.02.14 07:35:03.234 2025.02.14 06:43:56.568 2025.02.14 06:44:12.955
5 4.0.6.3169 2024.12.08 50eb6 F F 17223 16210 2024.12.11 10:31:37.973 2024.12.11 10:31:55.196 2024.12.11 09:41:14.632 2024.12.11 09:41:30.842
6 4.0.6.3168 2024.12.07 98d69 F F 17781 16834 2024.12.08 03:12:37.903 2024.12.08 03:12:55.684 2024.12.08 02:20:55.136 2024.12.08 02:21:11.970
7 4.0.6.3168 2024.12.05 cee43 F F 17807 16963 2024.12.06 03:17:03.350 2024.12.06 03:17:21.157 2024.12.06 02:26:45.069 2024.12.06 02:27:02.032
8 4.0.6.3168 2024.11.28 48149 F F 16753 16596 2024.12.03 10:11:19.741 2024.12.03 10:11:36.494 2024.12.03 09:21:34.756 2024.12.03 09:21:51.352
9 4.0.6.3163 2024.10.30 832db F F 17106 16155 2024.11.28 10:10:07.187 2024.11.28 10:10:24.293 2024.11.28 09:20:47.566 2024.11.28 09:21:03.721
10 4.0.6.3163 2024.10.16 2bb10 F F 17286 16520 2024.10.30 10:18:54.431 2024.10.30 10:19:11.717 2024.10.30 09:29:04.355 2024.10.30 09:29:20.875
11 4.0.6.3147 2024.09.10 a4d11 F F 17093 16403 2024.10.16 03:26:44.760 2024.10.16 03:27:01.853 2024.10.16 02:18:16.146 2024.10.16 02:18:32.549
12 4.0.6.3147 2024.08.31 4655b F F 17817 16647 2024.09.10 10:20:19.111 2024.09.10 10:20:36.928 2024.09.10 09:30:23.924 2024.09.10 09:30:40.571
13 4.0.6.3140 2024.08.16 1dd8b F F 17150 18322 2024.09.01 10:44:16.601 2024.09.01 10:44:33.751 2024.09.01 09:34:03.170 2024.09.01 09:34:21.492
14 4.0.6.3140 2024.08.09 34747 F F 17139 16505 2024.08.16 10:23:41.553 2024.08.16 10:23:58.692 2024.08.16 09:32:50.882 2024.08.16 09:33:07.387
15 4.0.5.3110 2024.08.06 f851c F F 17481 16512 2024.08.09 10:03:25.813 2024.08.09 10:03:43.294 2024.08.09 09:13:10.558 2024.08.09 09:13:27.070
16 4.0.5.3110 2024.07.30 c6527 P P 25055 24459 2024.08.06 05:44:02.031 2024.08.06 05:44:27.086 2024.08.06 04:57:46.892 2024.08.06 04:58:11.351
17 4.0.5.3109 2024.06.11 6addf P P 25163 23232 2024.07.30 09:03:38.191 2024.07.30 09:04:03.354 2024.07.30 08:18:39.064 2024.07.30 08:19:02.296
18 4.0.5.3097 2024.05.09 27fa6 P P 23971 23549 2024.06.11 05:24:19.110 2024.06.11 05:24:43.081 2024.06.11 04:44:54.799 2024.06.11 04:45:18.348
19 4.0.5.3091 2024.04.29 bd0aa P P 24440 23830 2024.05.09 18:03:49.430 2024.05.09 18:04:13.870 2024.05.09 17:24:46.764 2024.05.09 17:25:10.594
20 4.0.5.3089 2024.04.20 9eb9b P P 24237 23409 2024.04.29 06:12:32.958 2024.04.29 06:12:57.195 2024.04.29 05:33:53.530 2024.04.29 05:34:16.939
21 4.0.5.3083 2024.04.06 300f9 P P 24206 23503 2024.04.20 06:35:39.329 2024.04.20 06:36:03.535 2024.04.20 05:56:47.901 2024.04.20 05:57:11.404
22 4.0.5.3052 2024.03.16 0f422 P P 24019 23128 2024.04.05 03:03:24.657 2024.04.05 03:03:48.676 2024.04.05 02:25:57.615 2024.04.05 02:26:20.743
23 4.0.5.3052 2024.03.16 ce273 P P 23861 23053 2024.03.29 14:31:09.819 2024.03.29 14:31:33.680 2024.03.29 13:54:00.457 2024.03.29 13:54:23.510
24 4.0.5.3052 2024.02.12 cd058 P P 23767 23022 2024.03.29 15:59:32.235 2024.03.29 15:59:56.002 2024.03.29 15:22:28.552 2024.03.29 15:22:51.574
25 4.0.5.3052 2024.02.07 be290 P P 23814 23083 2024.03.29 18:11:02.185 2024.03.29 18:11:25.999 2024.03.29 17:33:55.751 2024.03.29 17:34:18.834
26 4.0.5.3052 2024.02.07 6409b P P 23798 23115 2024.03.29 19:55:18.116 2024.03.29 19:55:41.914 2024.03.29 19:18:08.681 2024.03.29 19:18:31.796
27 4.0.5.3052 2024.02.02 bbc3f P P 23829 23052 2024.03.29 22:04:18.309 2024.03.29 22:04:42.138 2024.03.29 21:27:14.705 2024.03.29 21:27:37.757
28 4.0.5.3052 2024.01.26 48b7c P P 23751 22959 2024.03.29 23:31:31.157 2024.03.29 23:31:54.908 2024.03.29 22:54:21.717 2024.03.29 22:54:44.676
29 4.0.5.3052 2024.01.26 9a7b3 P P 23736 22990 2024.03.30 06:32:26.046 2024.03.30 06:32:49.782 2024.03.30 05:55:14.798 2024.03.30 05:55:37.788
30 4.0.5.3049 2024.01.25 f6b9d P P 23703 22990 2024.03.30 08:39:57.622 2024.03.30 08:40:21.325 2024.03.30 08:03:08.228 2024.03.30 08:03:31.218
31 4.0.5.3049 2024.01.08 b67ce P P 24783 23361 2024.03.30 10:19:12.740 2024.03.30 10:19:37.523 2024.03.30 09:38:59.853 2024.03.30 09:39:23.214
32 4.0.5.3049 2024.01.08 97577 P P 24721 23283 2024.03.30 15:24:41.940 2024.03.30 15:25:06.661 2024.03.30 14:44:23.691 2024.03.30 14:44:46.974
33 4.0.5.3049 2024.01.05 2d8b0 P P 24704 23252 2024.03.30 18:42:21.908 2024.03.30 18:42:46.612 2024.03.30 18:02:21.559 2024.03.30 18:02:44.811
34 4.0.5.3049 2024.01.04 431e5 P P 23720 23007 2024.03.30 20:28:57.524 2024.03.30 20:29:21.244 2024.03.30 19:52:11.491 2024.03.30 19:52:34.498
35 4.0.5.3049 2024.01.04 e33b4 P P 23736 23021 2024.03.30 22:40:47.342 2024.03.30 22:41:11.078 2024.03.30 22:03:55.272 2024.03.30 22:04:18.293
36 4.0.5.3049 2024.01.04 207ef P P 23768 23112 2024.03.31 00:24:15.614 2024.03.31 00:24:39.382 2024.03.30 23:47:17.288 2024.03.30 23:47:40.400
37 4.0.5.3034 2023.12.12 c05ff P P 23610 22943 2024.03.31 06:16:46.710 2024.03.31 06:17:10.320 2024.03.31 05:39:51.244 2024.03.31 05:40:14.187
38 4.0.5.3034 2023.12.12 3a40e P P 23860 22944 2024.03.31 14:51:30.889 2024.03.31 14:51:54.749 2024.03.31 14:14:34.578 2024.03.31 14:14:57.522
39 4.0.5.3034 2023.12.02 5934b P P 23736 23022 2024.03.31 09:24:34.853 2024.03.31 09:24:58.589 2024.03.31 08:47:40.378 2024.03.31 08:48:03.400
40 4.0.5.3034 2023.12.02 7ea5a P P 23861 23053 2024.03.31 17:15:52.641 2024.03.31 17:16:16.502 2024.03.31 16:38:51.641 2024.03.31 16:39:14.694
41 4.0.5.3034 2023.11.30 4fbc9 P P 23705 22990 2024.03.31 19:16:44.854 2024.03.31 19:17:08.559 2024.03.31 18:39:45.503 2024.03.31 18:40:08.493

Elapsed time, ms. Chart for last 41 runs:

Last commits information (all timestamps in UTC):