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
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 5
    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= [1.2800000000000011, 1.1799999999999926, 1.2600000000000051, 1.2199999999999989, 1.2600000000000051, 1.230000000000004, 1.289999999999992, 1.1799999999999926, 1.210000000000008]  min= 1.1799999999999926  max= 1.289999999999992
  + compressed_bin= [1.2000000000000028, 1.1599999999999966, 1.2600000000000051, 1.2700000000000102, 1.1400000000000006, 1.279999999999987, 1.2999999999999972, 1.2199999999999989, 1.259999999999991]  min= 1.1400000000000006  max= 1.2999999999999972
  + non_comprs_txt= [0.21000000000000796, 0.22999999999998977, 0.25, 0.28000000000000114, 0.21999999999999886, 0.2400000000000091, 0.25, 0.269999999999996, 0.25]  min= 0.21000000000000796  max= 0.28000000000000114
  + non_comprs_bin= [0.23999999999999488, 0.2600000000000051, 0.23999999999999488, 0.25, 0.29000000000000625, 0.23999999999999488, 0.3400000000000034, 0.28000000000000114, 0.25]  min= 0.23999999999999488  max= 0.3400000000000034
  + median(compressed_txt) / median(non_comprs_txt) = 4.920000000000016
  + median(compressed_bin) / median(non_comprs_bin) = 5.039999999999964
  + median(non_comprs_txt) / median(non_comprs_bin) = 1.0

LOG DETAILS:

2025-03-13 08:28:12.230
2025-03-13 08:28:12.240 act = <firebird.qa.plugin.Action object at [hex]>
2025-03-13 08:28:12.252 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-03-13 08:28:12.261
2025-03-13 08:28:12.267 @pytest.mark.version('>=3.0')
2025-03-13 08:28:12.274 def test_1(act: Action, capsys):
2025-03-13 08:28:12.279
2025-03-13 08:28:12.285 # OPTIONAL CHECK: minimal ratio between CPU user time when WireCompression = false
2025-03-13 08:28:12.293 # and engine sends to client: 1) 'IDEALLY COMPRESSABLE'; 2) 'ABSOLUTELY IMCOMPRESSIBLE' data.
2025-03-13 08:28:12.300 # This can be useful to estimate record-level compression: textual data can be compressed
2025-03-13 08:28:12.305 # very well, so its transfer must take much less time then for GEN_UUID.
2025-03-13 08:28:12.310 # Experiments show that this ratio can be on Windows in the scope 0.3.... 0.8,
2025-03-13 08:28:12.315 # but on Linux it can be 1.0 or even slightly more then 1(!)
2025-03-13 08:28:12.321 # Windows: 0.500; 0.600; 0.571; 0.428; 0.714; 0.667; 0.625; 0.429; 0.571 // 4.0.1
2025-03-13 08:28:12.326 #          0.454; 0.357; 0.357; 0.500; 0.250; 0.385; 0.333; 0.200; 0.500 // 3.0.8
2025-03-13 08:28:12.331 # Linux:   0.684; 1.000; 1.000; 1.067; 0.867; 0.813; 0.800; 0.777; 0.750 // 4.0.1
2025-03-13 08:28:12.336 #          0.928; 1.000; 0.933; 1.000; 1.077; 0.750; 0.938; 0.929; 0.928 // 3.0.8
2025-03-13 08:28:12.341 if act.is_version('<4'):
2025-03-13 08:28:12.346 # 16.09.2022, 4.3.0.8 Classic: Windows -> 1.2
2025-03-13 08:28:12.351 MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF = 1.1 if platform.system() == 'Linux' else 1.5
2025-03-13 08:28:12.356 else:
2025-03-13 08:28:12.361 # 05.03.2023, 5.0.0.970, SS, Linux: 1.1 --> 1.3
2025-03-13 08:28:12.367 # 05.04.2023, 5.0.0.1001, SS, WIndows: 0.95 --> 1.5
2025-03-13 08:28:12.372 MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF = 1.3 if platform.system() == 'Linux' else 1.5
2025-03-13 08:28:12.377
2025-03-13 08:28:12.382 # Register Firebird server (D:\FB\probes\fid-set-dpb-probe-05x.py)
2025-03-13 08:28:12.387 srv_cfg = driver_config.register_server(name = 'test_srv_core_0733', config = '')
2025-03-13 08:28:12.392
2025-03-13 08:28:12.397 #srv_config_key_value_text = \
2025-03-13 08:28:12.403 #f"""
2025-03-13 08:28:12.408 #    [test_srv_core_0733]
2025-03-13 08:28:12.414 #    protocol = inet
2025-03-13 08:28:12.420 #"""
2025-03-13 08:28:12.425 #driver_config.register_server(name = 'test_srv_core_0733', config = srv_config_key_value_text)
2025-03-13 08:28:12.432 #db_cfg_object = driver_config.register_database(name = 'test_db_core_0733')
2025-03-13 08:28:12.439 #db_cfg_object.database.value = str(act.db.db_path)
2025-03-13 08:28:12.444
2025-03-13 08:28:12.449 benchmark_data = defaultdict(list)
2025-03-13 08:28:12.455
2025-03-13 08:28:12.460 for w_compr in (True, False):
2025-03-13 08:28:12.465
2025-03-13 08:28:12.470 db_cfg_name = f'test_db_core_0733__wcompr_{w_compr}'
2025-03-13 08:28:12.475 db_cfg_object = driver_config.register_database(name = db_cfg_name)
2025-03-13 08:28:12.480 db_cfg_object.server.value = srv_cfg.name
2025-03-13 08:28:12.486 # db_cfg_object.protocol.value = None /  XNET /  WNET -- these can not be used in this test!
2025-03-13 08:28:12.491 db_cfg_object.protocol.value = NetProtocol.INET
2025-03-13 08:28:12.496 db_cfg_object.database.value = str(act.db.db_path)
2025-03-13 08:28:12.502 db_cfg_object.config.value = f"""
2025-03-13 08:28:12.507 WireCrypt = Disabled
2025-03-13 08:28:12.512 WireCompression = {w_compr}
2025-03-13 08:28:12.517 """
2025-03-13 08:28:12.522 for i in range(0, N_MEASURES):
2025-03-13 08:28:12.527 with connect(db_cfg_name, user = act.db.user, password = act.db.password) as con:
2025-03-13 08:28:12.533 prot_name = db_cfg_object.protocol.value.name if db_cfg_object.protocol.value else 'Embedded'
2025-03-13 08:28:12.538 assert w_compr == con.info.is_compressed(), f'Protocol: {prot_name} - can not be used to measure wire_compression'
2025-03-13 08:28:12.543
2025-03-13 08:28:12.548 with con.cursor() as cur:
2025-03-13 08:28:12.554 cur.execute('select mon$server_pid, mon$remote_protocol as p from mon$attachments where mon$attachment_id = current_connection')
2025-03-13 08:28:12.559 for r in cur:
2025-03-13 08:28:12.564 fb_pid, connection_protocol = r
2025-03-13 08:28:12.569 assert connection_protocol.startswith('TCP'), f'Invalid connection protocol: {connection_protocol}'
2025-03-13 08:28:12.574
2025-03-13 08:28:12.580 for data_source in ('t_common_text', 't_binary_data'):
2025-03-13 08:28:12.586 cur.execute('select s from ' + data_source)
2025-03-13 08:28:12.592
2025-03-13 08:28:12.597 fb_info_a = psutil.Process(fb_pid).cpu_times()
2025-03-13 08:28:12.603 for r in cur:
2025-03-13 08:28:12.608 # *** FULL FETCH ***
2025-03-13 08:28:12.614 pass
2025-03-13 08:28:12.620 fb_info_b = psutil.Process(fb_pid).cpu_times()
2025-03-13 08:28:12.626
2025-03-13 08:28:12.632 k = ('WireCompression=%d' % (1 if w_compr else 0), 'DataSource='+data_source)
2025-03-13 08:28:12.637 benchmark_data[k] += fb_info_b.user - fb_info_a.user,
2025-03-13 08:28:12.642
2025-03-13 08:28:12.647
2025-03-13 08:28:12.653 compressed_txt = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=1' and k[1] == 'DataSource=t_common_text'][0]
2025-03-13 08:28:12.658 compressed_bin = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=1' and k[1] == 'DataSource=t_binary_data'][0]
2025-03-13 08:28:12.663 non_comprs_txt = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=0' and k[1] == 'DataSource=t_common_text'][0]
2025-03-13 08:28:12.669 non_comprs_bin = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=0' and k[1] == 'DataSource=t_binary_data'][0]
2025-03-13 08:28:12.674
2025-03-13 08:28:12.680 cpu_txt_wcompr_ON_vs_OFF = median(compressed_txt) / max(0.00001, median(non_comprs_txt))
2025-03-13 08:28:12.685 cpu_bin_wcompr_ON_vs_OFF = median(compressed_bin) / max(0.00001, median(non_comprs_bin))
2025-03-13 08:28:12.690 cpu_txt2bin_wcompr_OFF = median(non_comprs_txt) / max(0.00001, median(non_comprs_bin))
2025-03-13 08:28:12.695
2025-03-13 08:28:12.700 msg_result1 = 'CPU time ratio when sending %s and WireCompression is ON vs OFF: %s'
2025-03-13 08:28:12.705 what_sent1 = 'COMPRESSABLE TEXTUAL DATA'
2025-03-13 08:28:12.710 all_fine = 1
2025-03-13 08:28:12.716 if cpu_txt_wcompr_ON_vs_OFF > MIN_CPU_RATIO_TXT_WCOMPR_ON_OFF:
2025-03-13 08:28:12.721 print(msg_result1 % (what_sent1, 'EXPECTED') )
2025-03-13 08:28:12.726 else:
2025-03-13 08:28:12.733 print(msg_result1 % (what_sent1, '/* perf_issue_tag */ UNEXPECTED less than '+str(MIN_CPU_RATIO_TXT_WCOMPR_ON_OFF)) )
2025-03-13 08:28:12.740 all_fine = 0
2025-03-13 08:28:12.747
2025-03-13 08:28:12.754
2025-03-13 08:28:12.762 what_sent2 = 'INCOMPRESSABLE BINARY DATA'
2025-03-13 08:28:12.770 if cpu_bin_wcompr_ON_vs_OFF > MIN_CPU_RATIO_BIN_WCOMPR_ON_OFF:
2025-03-13 08:28:12.777 print(msg_result1 % (what_sent2, 'EXPECTED') )
2025-03-13 08:28:12.783 else:
2025-03-13 08:28:12.789 print(msg_result1 % (what_sent2, '/* perf_issue_tag */ UNEXPECTED, less than '+str(MIN_CPU_RATIO_BIN_WCOMPR_ON_OFF)) )
2025-03-13 08:28:12.795 all_fine = 0
2025-03-13 08:28:12.801
2025-03-13 08:28:12.806
2025-03-13 08:28:12.812 msg_result2 = 'CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: %s'
2025-03-13 08:28:12.818 if cpu_txt2bin_wcompr_OFF <= MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF:
2025-03-13 08:28:12.824 print(msg_result2 % ('EXPECTED') )
2025-03-13 08:28:12.829 else:
2025-03-13 08:28:12.835 print(msg_result2 % ('/* perf_issue_tag */ UNEXPECTED, more than ' + str(MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF)) )
2025-03-13 08:28:12.841 all_fine = 0
2025-03-13 08:28:12.846
2025-03-13 08:28:12.851 if not all_fine:
2025-03-13 08:28:12.856 print('compressed_txt=',compressed_txt,' min=',min(compressed_txt),' max=',max(compressed_txt))
2025-03-13 08:28:12.862 print('compressed_bin=',compressed_bin,' min=',min(compressed_bin),' max=',max(compressed_bin))
2025-03-13 08:28:12.867 print('non_comprs_txt=',non_comprs_txt,' min=',min(non_comprs_txt),' max=',max(non_comprs_txt))
2025-03-13 08:28:12.872 print('non_comprs_bin=',non_comprs_bin,' min=',min(non_comprs_bin),' max=',max(non_comprs_bin))
2025-03-13 08:28:12.877
2025-03-13 08:28:12.883 print('median(compressed_txt) / median(non_comprs_txt) =',1.000 * median(compressed_txt) / max(0.00001, median(non_comprs_txt)) )
2025-03-13 08:28:12.888 print('median(compressed_bin) / median(non_comprs_bin) =',1.000 * median(compressed_bin) / max(0.00001, median(non_comprs_bin)) )
2025-03-13 08:28:12.894 print('median(non_comprs_txt) / median(non_comprs_bin) =',1.000 * median(non_comprs_txt) / max(0.00001, median(non_comprs_bin)) )
2025-03-13 08:28:12.900
2025-03-13 08:28:12.906
2025-03-13 08:28:12.912 expected_stdout = ''
2025-03-13 08:28:12.917 for f in (what_sent1, what_sent2):
2025-03-13 08:28:12.924 expected_stdout += ''.join( (msg_result1 % (f, 'EXPECTED'), '\n')  )
2025-03-13 08:28:12.929 expected_stdout += (msg_result2 % 'EXPECTED')
2025-03-13 08:28:12.936
2025-03-13 08:28:12.943 act.expected_stdout = expected_stdout
2025-03-13 08:28:12.949 act.stdout = capsys.readouterr().out
2025-03-13 08:28:12.956 >       assert act.clean_stdout == act.clean_expected_stdout
2025-03-13 08:28:12.962 E       assert
2025-03-13 08:28:12.968 E         - CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: EXPECTED
2025-03-13 08:28:12.975 E         + CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: /* perf_issue_tag */ UNEXPECTED less than 5
2025-03-13 08:28:12.995 E           CPU time ratio when sending INCOMPRESSABLE BINARY DATA and WireCompression is ON vs OFF: EXPECTED
2025-03-13 08:28:13.004 E           CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: EXPECTED
2025-03-13 08:28:13.012 E         + compressed_txt= [1.2800000000000011, 1.1799999999999926, 1.2600000000000051, 1.2199999999999989, 1.2600000000000051, 1.230000000000004, 1.289999999999992, 1.1799999999999926, 1.210000000000008]  min= 1.1799999999999926  max= 1.289999999999992
2025-03-13 08:28:13.021 E         + compressed_bin= [1.2000000000000028, 1.1599999999999966, 1.2600000000000051, 1.2700000000000102, 1.1400000000000006, 1.279999999999987, 1.2999999999999972, 1.2199999999999989, 1.259999999999991]  min= 1.1400000000000006  max= 1.2999999999999972
2025-03-13 08:28:13.033 E         + non_comprs_txt= [0.21000000000000796, 0.22999999999998977, 0.25, 0.28000000000000114, 0.21999999999999886, 0.2400000000000091, 0.25, 0.269999999999996, 0.25]  min= 0.21000000000000796  max= 0.28000000000000114
2025-03-13 08:28:13.048 E         + non_comprs_bin= [0.23999999999999488, 0.2600000000000051, 0.23999999999999488, 0.25, 0.29000000000000625, 0.23999999999999488, 0.3400000000000034, 0.28000000000000114, 0.25]  min= 0.23999999999999488  max= 0.3400000000000034
2025-03-13 08:28:13.059 E         + median(compressed_txt) / median(non_comprs_txt) = 4.920000000000016
2025-03-13 08:28:13.073 E         + median(compressed_bin) / median(non_comprs_bin) = 5.039999999999964
2025-03-13 08:28:13.084 E         + median(non_comprs_txt) / median(non_comprs_bin) = 1.0
2025-03-13 08:28:13.093
2025-03-13 08:28:13.104 tests/bugs/core_0733_test.py:254: AssertionError
2025-03-13 08:28:13.113 ---------------------------- Captured stdout setup -----------------------------
2025-03-13 08:28:13.121 Creating db: localhost:/var/tmp/qa_2024/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 5
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= [1.2800000000000011, 1.1799999999999926, 1.2600000000000051, 1.2199999999999989, 1.2600000000000051, 1.230000000000004, 1.289999999999992, 1.1799999999999926, 1.210000000000008]  min= 1.1799999999999926  max= 1.289999999999992
E         + compressed_bin= [1.2000000000000028, 1.1599999999999966, 1.2600000000000051, 1.2700000000000102, 1.1400000000000006, 1.279999999999987, 1.2999999999999972, 1.2199999999999989, 1.259999999999991]  min= 1.1400000000000006  max= 1.2999999999999972
E         + non_comprs_txt= [0.21000000000000796, 0.22999999999998977, 0.25, 0.28000000000000114, 0.21999999999999886, 0.2400000000000091, 0.25, 0.269999999999996, 0.25]  min= 0.21000000000000796  max= 0.28000000000000114
E         + non_comprs_bin= [0.23999999999999488, 0.2600000000000051, 0.23999999999999488, 0.25, 0.29000000000000625, 0.23999999999999488, 0.3400000000000034, 0.28000000000000114, 0.25]  min= 0.23999999999999488  max= 0.3400000000000034
E         + median(compressed_txt) / median(non_comprs_txt) = 4.920000000000016
E         + median(compressed_bin) / median(non_comprs_bin) = 5.039999999999964
E         + median(non_comprs_txt) / median(non_comprs_bin) = 1.0

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.3215 2025.06.25 6461d P P 46228 44194 2025.07.02 07:58:10.313 2025.07.02 07:58:56.541 2025.07.02 06:51:44.606 2025.07.02 06:52:28.800
2 4.0.6.3214 2025.06.21 e11f6 P P 40767 40446 2025.06.25 07:01:46.752 2025.06.25 07:02:27.519 2025.06.25 05:58:55.207 2025.06.25 05:59:35.653
3 4.0.6.3213 2025.06.14 f015c P P 41505 40969 2025.06.21 06:38:11.019 2025.06.21 06:38:52.524 2025.06.21 05:25:30.078 2025.06.21 05:26:11.047
4 4.0.6.3212 2025.06.11 bc50d P P 42072 45038 2025.06.14 07:36:18.535 2025.06.14 07:37:00.607 2025.06.14 06:32:39.303 2025.06.14 06:33:24.341
5 4.0.6.3208 2025.06.10 19fe3 P F 49975 48149 2025.06.11 06:16:49.086 2025.06.11 06:17:39.061 2025.06.11 05:06:36.821 2025.06.11 05:07:24.970
6 4.0.6.3207 2025.06.07 205ff P P 51994 49759 2025.06.10 06:18:25.290 2025.06.10 06:19:17.284 2025.06.10 05:06:31.350 2025.06.10 05:07:21.109
7 4.0.6.3206 2025.05.22 d7d10 P P 52046 51269 2025.06.06 06:24:10.569 2025.06.06 06:25:02.615 2025.06.06 05:02:22.331 2025.06.06 05:03:13.600
8 4.0.6.3205 2025.05.07 00148 P F 52055 51643 2025.05.21 06:17:26.471 2025.05.21 06:18:18.526 2025.05.21 05:04:48.882 2025.05.21 05:05:40.525
9 4.0.6.3204 2025.05.06 35b85 P P 51909 49604 2025.05.07 05:50:44.018 2025.05.07 05:51:35.927 2025.05.07 04:39:41.649 2025.05.07 04:40:31.253
10 4.0.6.3203 2025.05.05 c2cbd P F 49232 50312 2025.05.06 05:47:39.737 2025.05.06 05:48:28.969 2025.05.06 04:36:59.547 2025.05.06 04:37:49.859
11 4.0.6.3200 2025.04.18 7ef56 P P 48590 47109 2025.05.01 05:39:06.681 2025.05.01 05:39:55.271 2025.05.01 04:29:07.250 2025.05.01 04:29:54.359
12 4.0.6.3199 2025.04.14 33a10 P P 50027 49860 2025.04.18 05:49:41.270 2025.04.18 05:50:31.297 2025.04.18 04:38:16.962 2025.04.18 04:39:06.822
13 4.0.6.3198 2025.04.13 64a7f P P 44849 43751 2025.04.14 05:00:05.396 2025.04.14 05:00:50.245 2025.04.14 03:54:19.883 2025.04.14 03:55:03.634
14 4.0.6.3195 2025.03.28 b9faf P P 42951 42335 2025.04.13 04:48:41.153 2025.04.13 04:49:24.104 2025.04.13 03:42:58.059 2025.04.13 03:43:40.394
15 4.0.6.3194 2025.03.26 912aa P P 52939 48338 2025.03.28 05:25:44.422 2025.03.28 05:26:37.361 2025.03.28 04:17:45.157 2025.03.28 04:18:33.495
16 4.0.6.3193 2025.03.20 80234 P P 51188 49307 2025.03.24 05:40:55.671 2025.03.24 05:41:46.859 2025.03.24 04:28:47.173 2025.03.24 04:29:36.480
17 4.0.6.3192 2025.03.13 2a9da P F 768 468 2025.03.17 02:24:19.072 2025.03.17 02:24:19.840 2025.03.17 01:11:51.738 2025.03.17 01:11:52.206
18 4.0.6.3191 2025.03.10 3d9fd F F 733 481 2025.03.13 05:32:10.175 2025.03.13 05:32:10.908 2025.03.13 04:19:18.481 2025.03.13 04:19:18.962
19 4.0.6.3190 2025.02.25 c9928 P P 742 496 2025.03.09 05:19:03.004 2025.03.09 05:19:03.746 2025.03.09 04:07:42.729 2025.03.09 04:07:43.225
20 4.0.6.3189 2025.02.22 3fb0b P P 732 446 2025.02.25 05:10:08.295 2025.02.25 05:10:09.027 2025.02.25 03:59:47.354 2025.02.25 03:59:47.800
21 4.0.6.3188 2025.02.21 8ee1c P P 713 491 2025.02.22 05:07:00.149 2025.02.22 05:07:00.862 2025.02.22 03:54:05.214 2025.02.22 03:54:05.705
22 4.0.6.3186 2025.02.19 92cb6 P P 727 459 2025.02.20 02:01:16.390 2025.02.20 02:01:17.117 2025.02.20 00:50:48.458 2025.02.20 00:50:48.917
23 4.0.6.3185 2025.02.16 9cac4 P P 1070 483 2025.02.16 22:40:05.630 2025.02.16 22:40:06.700 2025.02.16 21:19:06.773 2025.02.16 21:19:07.256
24 4.0.6.3183 2025.02.04 bf738 P P 709 481 2025.02.14 05:21:06.781 2025.02.14 05:21:07.490 2025.02.14 04:08:55.160 2025.02.14 04:08:55.641
25 4.0.6.3181 2025.02.01 00b64 P P 778 476 2025.02.04 05:24:37.653 2025.02.04 05:24:38.431 2025.02.04 04:04:29.280 2025.02.04 04:04:29.756
26 4.0.6.3180 2025.01.27 2edb8 P P 744 486 2025.01.28 05:15:25.063 2025.01.28 05:15:25.807 2025.01.28 04:04:48.440 2025.01.28 04:04:48.926
27 4.0.6.3179 2025.01.24 008d4 P P 670 495 2025.01.25 05:11:19.115 2025.01.25 05:11:19.785 2025.01.25 04:00:17.603 2025.01.25 04:00:18.098
28 4.0.6.3178 2025.01.20 ec94d P P 739 463 2025.01.24 05:11:05.162 2025.01.24 05:11:05.901 2025.01.24 04:00:45.565 2025.01.24 04:00:46.028
29 4.0.6.3176 2025.01.16 79cc1 P P 762 527 2025.01.20 05:02:02.159 2025.01.20 05:02:02.921 2025.01.20 03:51:52.284 2025.01.20 03:51:52.811
30 4.0.6.3175 2025.01.15 91361 P P 680 483 2025.01.16 05:01:24.477 2025.01.16 05:01:25.157 2025.01.16 03:51:54.467 2025.01.16 03:51:54.950
31 4.0.6.3174 2024.12.23 ffd39 P P 715 503 2025.01.14 05:05:55.719 2025.01.14 05:05:56.434 2025.01.14 03:55:40.667 2025.01.14 03:55:41.170
32 4.0.6.3173 2024.12.19 60b32 P P 567 395 2024.12.21 16:55:37.434 2024.12.21 16:55:38.001 2024.12.21 15:59:11.707 2024.12.21 15:59:12.102
33 4.0.6.3172 2024.12.11 33f5d P P 570 394 2024.12.16 03:48:49.049 2024.12.16 03:48:49.619 2024.12.16 02:52:23.888 2024.12.16 02:52:24.282
34 4.0.6.3171 2024.12.10 ab1d4 P P 554 386 2024.12.11 03:35:20.493 2024.12.11 03:35:21.047 2024.12.11 02:39:19.934 2024.12.11 02:39:20.320
35 4.0.6.3170 2024.12.02 68abd P P 559 386 2024.12.04 03:23:59.360 2024.12.04 03:23:59.919 2024.12.04 02:28:16.931 2024.12.04 02:28:17.317
36 4.0.6.3169 2024.11.28 1673f P P 523 372 2024.11.30 03:37:37.059 2024.11.30 03:37:37.582 2024.11.30 02:41:47.508 2024.11.30 02:41:47.880
37 4.0.6.3168 2024.11.07 f67e2 P P 539 399 2024.11.27 03:13:32.567 2024.11.27 03:13:33.106 2024.11.27 02:19:40.615 2024.11.27 02:19:41.014
38 4.0.6.3167 2024.11.04 c9228 P P 573 379 2024.11.05 05:02:00.382 2024.11.05 05:02:00.955 2024.11.05 04:09:15.007 2024.11.05 04:09:15.386
39 4.0.6.3165 2024.10.23 b0c36 P P 565 375 2024.11.04 05:05:55.767 2024.11.04 05:05:56.332 2024.11.04 04:12:20.150 2024.11.04 04:12:20.525
40 4.0.6.3164 2024.10.17 35344 P P 587 403 2024.10.23 05:18:46.792 2024.10.23 05:18:47.379 2024.10.23 04:23:27.697 2024.10.23 04:23:28.100
41 4.0.6.3163 2024.10.14 2e35e P P 550 390 2024.10.15 05:07:04.156 2024.10.15 05:07:04.706 2024.10.15 04:13:28.930 2024.10.15 04:13:29.320
42 4.0.6.3161 2024.10.05 91502 P P 620 624 2024.10.06 03:07:37.135 2024.10.06 03:07:37.755 2024.10.06 02:06:58.313 2024.10.06 02:06:58.937
43 4.0.6.3159 2024.10.01 85136 P P 962 438 2024.10.02 00:15:17.664 2024.10.02 00:15:18.626 2024.10.01 23:17:34.336 2024.10.01 23:17:34.774
44 4.0.6.3158 2024.09.30 d2c33 P P 577 360 2024.10.01 05:15:11.608 2024.10.01 05:15:12.185 2024.10.01 04:20:04.463 2024.10.01 04:20:04.823
45 4.0.6.3157 2024.09.24 3bb2e P P 586 378 2024.09.30 05:18:40.970 2024.09.30 05:18:41.556 2024.09.30 04:22:37.501 2024.09.30 04:22:37.879
46 4.0.6.3156 2024.09.21 f6416 P P 611 358 2024.09.24 03:24:27.819 2024.09.24 03:24:28.430 2024.09.24 02:28:41.458 2024.09.24 02:28:41.816
47 4.0.6.3155 2024.09.20 1ed0c P P 586 394 2024.09.21 03:19:36.779 2024.09.21 03:19:37.365 2024.09.21 02:24:05.825 2024.09.21 02:24:06.219
48 4.0.6.3151 2024.09.09 1b77f P P 864 577 2024.09.17 05:29:39.159 2024.09.17 05:29:40.023 2024.09.17 04:10:26.530 2024.09.17 04:10:27.107
49 4.0.6.3149 2024.09.04 32ce9 P P 986 620 2024.09.06 05:37:50.666 2024.09.06 05:37:51.652 2024.09.06 04:18:32.920 2024.09.06 04:18:33.540
50 4.0.6.3148 2024.09.02 4be5c P P 1190 572 2024.09.04 07:29:17.618 2024.09.04 07:29:18.808 2024.09.04 05:57:38.577 2024.09.04 05:57:39.149
51 4.0.6.3147 2024.08.30 5ffd7 P P 854 640 2024.09.02 06:44:14.534 2024.09.02 06:44:15.388 2024.09.02 05:09:47.909 2024.09.02 05:09:48.549
52 4.0.6.3146 2024.08.27 38582 P P 923 613 2024.08.30 06:26:54.481 2024.08.30 06:26:55.404 2024.08.30 04:56:45.569 2024.08.30 04:56:46.182
53 4.0.6.3145 2024.08.21 87240 P P 1567 657 2024.08.27 05:14:00.043 2024.08.27 05:14:01.610 2024.08.27 03:50:28.143 2024.08.27 03:50:28.800
54 4.0.6.3144 2024.08.20 5a3b7 P P 887 728 2024.08.21 06:12:17.008 2024.08.21 06:12:17.895 2024.08.21 04:43:38.188 2024.08.21 04:43:38.916
55 4.0.6.3142 2024.08.11 b9f39 P P 740 541 2024.08.19 03:46:07.072 2024.08.19 03:46:07.812 2024.08.19 02:41:59.835 2024.08.19 02:42:00.376
56 4.0.6.3141 2024.08.09 6d39f P P 712 528 2024.08.10 03:39:42.599 2024.08.10 03:39:43.311 2024.08.10 02:37:11.271 2024.08.10 02:37:11.799
57 4.0.5.3140 2024.08.06 64f3a P P 739 550 2024.08.09 03:35:23.781 2024.08.09 03:35:24.520 2024.08.09 02:33:13.050 2024.08.09 02:33:13.600
58 4.0.5.3139 2024.08.01 3bc8b P P 466 289 2024.08.06 02:53:49.308 2024.08.06 02:53:49.774 2024.08.06 01:58:14.702 2024.08.06 01:58:14.991
59 4.0.5.3136 2024.07.31 e41ec P P 495 347 2024.08.01 02:53:35.401 2024.08.01 02:53:35.896 2024.08.01 01:58:23.575 2024.08.01 01:58:23.922
60 4.0.5.3135 2024.07.26 b4981 P P 476 349 2024.07.30 02:50:59.954 2024.07.30 02:51:00.430 2024.07.30 01:55:58.276 2024.07.30 01:55:58.625
61 4.0.5.3129 2024.07.24 b8184 P P 509 315 2024.07.25 02:48:50.924 2024.07.25 02:48:51.433 2024.07.25 01:53:44.472 2024.07.25 01:53:44.787
62 4.0.5.3128 2024.07.13 aa318 P P 486 311 2024.07.24 02:55:03.912 2024.07.24 02:55:04.398 2024.07.24 01:59:41.438 2024.07.24 01:59:41.749
63 4.0.5.3127 2024.07.10 eace3 P P 468 320 2024.07.13 02:46:42.311 2024.07.13 02:46:42.779 2024.07.13 01:52:26.657 2024.07.13 01:52:26.977
64 4.0.5.3123 2024.06.24 c27c6 P P 487 318 2024.07.10 02:40:57.217 2024.07.10 02:40:57.704 2024.07.10 01:47:12.494 2024.07.10 01:47:12.812
65 4.0.5.3112 2024.06.13 d2e61 P P 477 351 2024.06.22 02:42:13.528 2024.06.22 02:42:14.005 2024.06.22 01:48:26.549 2024.06.22 01:48:26.900
66 4.0.5.3098 2024.05.09 4c3ec P P 669 479 2024.05.14 07:13:58.229 2024.05.14 07:13:58.898 2024.05.14 06:19:06.175 2024.05.14 06:19:06.654
67 4.0.5.3092 2024.05.06 bbc47 P P 461 318 2024.05.08 18:38:42.602 2024.05.08 18:38:43.063 2024.05.08 17:50:22.261 2024.05.08 17:50:22.579
68 4.0.5.3091 2024.04.29 062a7 P P 415 302 2024.05.01 11:23:48.541 2024.05.01 11:23:48.956 2024.05.01 10:36:09.483 2024.05.01 10:36:09.785
69 4.0.5.3089 2024.04.19 08c92 P P 415 282 2024.04.27 13:22:08.666 2024.04.27 13:22:09.081 2024.04.27 12:34:00.740 2024.04.27 12:34:01.022

Elapsed time, ms. Chart for last 69 runs:

Last commits information (all timestamps in UTC):