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 sending INCOMPRESSABLE BINARY DATA and WireCompression is ON vs OFF: /* perf_issue_tag */ UNEXPECTED, less than 4
    CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: EXPECTED
  + compressed_txt= [0.6899999999999977, 0.6099999999999994, 0.6400000000000006, 0.7400000000000091, 0.6200000000000045, 0.75, 0.6000000000000085, 0.6900000000000119, 0.5999999999999943]  min= 0.5999999999999943  max= 0.75
  + compressed_bin= [0.6499999999999915, 0.5999999999999943, 0.6700000000000017, 0.7599999999999909, 0.75, 0.6600000000000108, 0.6099999999999994, 0.75, 0.6699999999999875]  min= 0.5999999999999943  max= 0.7599999999999909
  + non_comprs_txt= [0.20999999999999375, 0.21999999999999886, 0.2400000000000091, 0.20000000000000284, 0.21000000000000796, 0.20999999999999375, 0.1699999999999875, 0.12999999999999545, 0.20999999999999375]  min= 0.12999999999999545  max= 0.2400000000000091
  + non_comprs_bin= [0.28000000000000114, 0.269999999999996, 0.3299999999999983, 0.28999999999999204, 0.19000000000001194, 0.21999999999999886, 0.2400000000000091, 0.2600000000000051, 0.28000000000000114]  min= 0.19000000000001194  max= 0.3299999999999983
  + median(compressed_txt) / median(non_comprs_txt) = 3.047619047619141
  + median(compressed_bin) / median(non_comprs_bin) = 2.4814814814814716
  + median(non_comprs_txt) / median(non_comprs_bin) = 0.7777777777777661

LOG DETAILS:

2025-04-18 13:46:10.202
2025-04-18 13:46:10.208 act = <firebird.qa.plugin.Action object at [hex]>
2025-04-18 13:46:10.214 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-04-18 13:46:10.220
2025-04-18 13:46:10.225 @pytest.mark.version('>=3.0')
2025-04-18 13:46:10.231 def test_1(act: Action, capsys):
2025-04-18 13:46:10.239
2025-04-18 13:46:10.248 # OPTIONAL CHECK: minimal ratio between CPU user time when WireCompression = false
2025-04-18 13:46:10.259 # and engine sends to client: 1) 'IDEALLY COMPRESSABLE'; 2) 'ABSOLUTELY IMCOMPRESSIBLE' data.
2025-04-18 13:46:10.268 # This can be useful to estimate record-level compression: textual data can be compressed
2025-04-18 13:46:10.276 # very well, so its transfer must take much less time then for GEN_UUID.
2025-04-18 13:46:10.282 # Experiments show that this ratio can be on Windows in the scope 0.3.... 0.8,
2025-04-18 13:46:10.290 # but on Linux it can be 1.0 or even slightly more then 1(!)
2025-04-18 13:46:10.297 # Windows: 0.500; 0.600; 0.571; 0.428; 0.714; 0.667; 0.625; 0.429; 0.571 // 4.0.1
2025-04-18 13:46:10.311 #          0.454; 0.357; 0.357; 0.500; 0.250; 0.385; 0.333; 0.200; 0.500 // 3.0.8
2025-04-18 13:46:10.319 # Linux:   0.684; 1.000; 1.000; 1.067; 0.867; 0.813; 0.800; 0.777; 0.750 // 4.0.1
2025-04-18 13:46:10.326 #          0.928; 1.000; 0.933; 1.000; 1.077; 0.750; 0.938; 0.929; 0.928 // 3.0.8
2025-04-18 13:46:10.334 if act.is_version('<4'):
2025-04-18 13:46:10.344 # 16.09.2022, 4.3.0.8 Classic: Windows -> 1.2
2025-04-18 13:46:10.353 MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF = 1.1 if platform.system() == 'Linux' else 1.5
2025-04-18 13:46:10.359 else:
2025-04-18 13:46:10.367 # 05.03.2023, 5.0.0.970, SS, Linux: 1.1 --> 1.3
2025-04-18 13:46:10.376 # 05.04.2023, 5.0.0.1001, SS, WIndows: 0.95 --> 1.5
2025-04-18 13:46:10.385 MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF = 1.3 if platform.system() == 'Linux' else 1.5
2025-04-18 13:46:10.391
2025-04-18 13:46:10.397 # Register Firebird server (D:\FB\probes\fid-set-dpb-probe-05x.py)
2025-04-18 13:46:10.406 srv_cfg = driver_config.register_server(name = 'test_srv_core_0733', config = '')
2025-04-18 13:46:10.414
2025-04-18 13:46:10.421 #srv_config_key_value_text = \
2025-04-18 13:46:10.429 #f"""
2025-04-18 13:46:10.436 #    [test_srv_core_0733]
2025-04-18 13:46:10.444 #    protocol = inet
2025-04-18 13:46:10.456 #"""
2025-04-18 13:46:10.465 #driver_config.register_server(name = 'test_srv_core_0733', config = srv_config_key_value_text)
2025-04-18 13:46:10.471 #db_cfg_object = driver_config.register_database(name = 'test_db_core_0733')
2025-04-18 13:46:10.478 #db_cfg_object.database.value = str(act.db.db_path)
2025-04-18 13:46:10.486
2025-04-18 13:46:10.494 benchmark_data = defaultdict(list)
2025-04-18 13:46:10.502
2025-04-18 13:46:10.508 for w_compr in (True, False):
2025-04-18 13:46:10.518
2025-04-18 13:46:10.531 db_cfg_name = f'test_db_core_0733__wcompr_{w_compr}'
2025-04-18 13:46:10.537 db_cfg_object = driver_config.register_database(name = db_cfg_name)
2025-04-18 13:46:10.544 db_cfg_object.server.value = srv_cfg.name
2025-04-18 13:46:10.555 # db_cfg_object.protocol.value = None /  XNET /  WNET -- these can not be used in this test!
2025-04-18 13:46:10.566 db_cfg_object.protocol.value = NetProtocol.INET
2025-04-18 13:46:10.575 db_cfg_object.database.value = str(act.db.db_path)
2025-04-18 13:46:10.584 db_cfg_object.config.value = f"""
2025-04-18 13:46:10.592 WireCrypt = Disabled
2025-04-18 13:46:10.599 WireCompression = {w_compr}
2025-04-18 13:46:10.607 """
2025-04-18 13:46:10.616 for i in range(0, N_MEASURES):
2025-04-18 13:46:10.625 with connect(db_cfg_name, user = act.db.user, password = act.db.password) as con:
2025-04-18 13:46:10.640 prot_name = db_cfg_object.protocol.value.name if db_cfg_object.protocol.value else 'Embedded'
2025-04-18 13:46:10.651 assert w_compr == con.info.is_compressed(), f'Protocol: {prot_name} - can not be used to measure wire_compression'
2025-04-18 13:46:10.659
2025-04-18 13:46:10.671 with con.cursor() as cur:
2025-04-18 13:46:10.680 cur.execute('select mon$server_pid, mon$remote_protocol as p from mon$attachments where mon$attachment_id = current_connection')
2025-04-18 13:46:10.686 for r in cur:
2025-04-18 13:46:10.693 fb_pid, connection_protocol = r
2025-04-18 13:46:10.701 assert connection_protocol.startswith('TCP'), f'Invalid connection protocol: {connection_protocol}'
2025-04-18 13:46:10.717
2025-04-18 13:46:10.732 for data_source in ('t_common_text', 't_binary_data'):
2025-04-18 13:46:10.742 cur.execute('select s from ' + data_source)
2025-04-18 13:46:10.750
2025-04-18 13:46:10.759 fb_info_a = psutil.Process(fb_pid).cpu_times()
2025-04-18 13:46:10.766 for r in cur:
2025-04-18 13:46:10.775 # *** FULL FETCH ***
2025-04-18 13:46:10.783 pass
2025-04-18 13:46:10.797 fb_info_b = psutil.Process(fb_pid).cpu_times()
2025-04-18 13:46:10.813
2025-04-18 13:46:10.824 k = ('WireCompression=%d' % (1 if w_compr else 0), 'DataSource='+data_source)
2025-04-18 13:46:10.838 benchmark_data[k] += fb_info_b.user - fb_info_a.user,
2025-04-18 13:46:10.851
2025-04-18 13:46:10.860
2025-04-18 13:46:10.874 compressed_txt = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=1' and k[1] == 'DataSource=t_common_text'][0]
2025-04-18 13:46:10.886 compressed_bin = [ v for k,v in benchmark_data.items() if k[0] == 'WireCompression=1' and k[1] == 'DataSource=t_binary_data'][0]
2025-04-18 13:46:10.896 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-04-18 13:46:10.913 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-04-18 13:46:10.925
2025-04-18 13:46:10.934 cpu_txt_wcompr_ON_vs_OFF = median(compressed_txt) / max(0.00001, median(non_comprs_txt))
2025-04-18 13:46:10.947 cpu_bin_wcompr_ON_vs_OFF = median(compressed_bin) / max(0.00001, median(non_comprs_bin))
2025-04-18 13:46:10.959 cpu_txt2bin_wcompr_OFF = median(non_comprs_txt) / max(0.00001, median(non_comprs_bin))
2025-04-18 13:46:10.967
2025-04-18 13:46:10.976 msg_result1 = 'CPU time ratio when sending %s and WireCompression is ON vs OFF: %s'
2025-04-18 13:46:10.984 what_sent1 = 'COMPRESSABLE TEXTUAL DATA'
2025-04-18 13:46:10.992 all_fine = 1
2025-04-18 13:46:11.000 if cpu_txt_wcompr_ON_vs_OFF > MIN_CPU_RATIO_TXT_WCOMPR_ON_OFF:
2025-04-18 13:46:11.009 print(msg_result1 % (what_sent1, 'EXPECTED') )
2025-04-18 13:46:11.016 else:
2025-04-18 13:46:11.024 print(msg_result1 % (what_sent1, '/* perf_issue_tag */ UNEXPECTED less than '+str(MIN_CPU_RATIO_TXT_WCOMPR_ON_OFF)) )
2025-04-18 13:46:11.032 all_fine = 0
2025-04-18 13:46:11.039
2025-04-18 13:46:11.046
2025-04-18 13:46:11.058 what_sent2 = 'INCOMPRESSABLE BINARY DATA'
2025-04-18 13:46:11.068 if cpu_bin_wcompr_ON_vs_OFF > MIN_CPU_RATIO_BIN_WCOMPR_ON_OFF:
2025-04-18 13:46:11.076 print(msg_result1 % (what_sent2, 'EXPECTED') )
2025-04-18 13:46:11.083 else:
2025-04-18 13:46:11.092 print(msg_result1 % (what_sent2, '/* perf_issue_tag */ UNEXPECTED, less than '+str(MIN_CPU_RATIO_BIN_WCOMPR_ON_OFF)) )
2025-04-18 13:46:11.101 all_fine = 0
2025-04-18 13:46:11.109
2025-04-18 13:46:11.116
2025-04-18 13:46:11.131 msg_result2 = 'CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: %s'
2025-04-18 13:46:11.142 if cpu_txt2bin_wcompr_OFF <= MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF:
2025-04-18 13:46:11.151 print(msg_result2 % ('EXPECTED') )
2025-04-18 13:46:11.158 else:
2025-04-18 13:46:11.173 print(msg_result2 % ('/* perf_issue_tag */ UNEXPECTED, more than ' + str(MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF)) )
2025-04-18 13:46:11.184 all_fine = 0
2025-04-18 13:46:11.194
2025-04-18 13:46:11.201 if not all_fine:
2025-04-18 13:46:11.209 print('compressed_txt=',compressed_txt,' min=',min(compressed_txt),' max=',max(compressed_txt))
2025-04-18 13:46:11.217 print('compressed_bin=',compressed_bin,' min=',min(compressed_bin),' max=',max(compressed_bin))
2025-04-18 13:46:11.229 print('non_comprs_txt=',non_comprs_txt,' min=',min(non_comprs_txt),' max=',max(non_comprs_txt))
2025-04-18 13:46:11.239 print('non_comprs_bin=',non_comprs_bin,' min=',min(non_comprs_bin),' max=',max(non_comprs_bin))
2025-04-18 13:46:11.250
2025-04-18 13:46:11.258 print('median(compressed_txt) / median(non_comprs_txt) =',1.000 * median(compressed_txt) / max(0.00001, median(non_comprs_txt)) )
2025-04-18 13:46:11.269 print('median(compressed_bin) / median(non_comprs_bin) =',1.000 * median(compressed_bin) / max(0.00001, median(non_comprs_bin)) )
2025-04-18 13:46:11.279 print('median(non_comprs_txt) / median(non_comprs_bin) =',1.000 * median(non_comprs_txt) / max(0.00001, median(non_comprs_bin)) )
2025-04-18 13:46:11.290
2025-04-18 13:46:11.302
2025-04-18 13:46:11.310 expected_stdout = ''
2025-04-18 13:46:11.319 for f in (what_sent1, what_sent2):
2025-04-18 13:46:11.332 expected_stdout += ''.join( (msg_result1 % (f, 'EXPECTED'), '\n')  )
2025-04-18 13:46:11.339 expected_stdout += (msg_result2 % 'EXPECTED')
2025-04-18 13:46:11.348
2025-04-18 13:46:11.357 act.expected_stdout = expected_stdout
2025-04-18 13:46:11.365 act.stdout = capsys.readouterr().out
2025-04-18 13:46:11.372 >       assert act.clean_stdout == act.clean_expected_stdout
2025-04-18 13:46:11.379 E       assert
2025-04-18 13:46:11.387 E         - CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: EXPECTED
2025-04-18 13:46:11.396 E         + CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: /* perf_issue_tag */ UNEXPECTED less than 5
2025-04-18 13:46:11.424 E         - CPU time ratio when sending INCOMPRESSABLE BINARY DATA and WireCompression is ON vs OFF: EXPECTED
2025-04-18 13:46:11.432 E         + CPU time ratio when sending INCOMPRESSABLE BINARY DATA and WireCompression is ON vs OFF: /* perf_issue_tag */ UNEXPECTED, less than 4
2025-04-18 13:46:11.455 E           CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: EXPECTED
2025-04-18 13:46:11.471 E         + compressed_txt= [0.6899999999999977, 0.6099999999999994, 0.6400000000000006, 0.7400000000000091, 0.6200000000000045, 0.75, 0.6000000000000085, 0.6900000000000119, 0.5999999999999943]  min= 0.5999999999999943  max= 0.75
2025-04-18 13:46:11.483 E         + compressed_bin= [0.6499999999999915, 0.5999999999999943, 0.6700000000000017, 0.7599999999999909, 0.75, 0.6600000000000108, 0.6099999999999994, 0.75, 0.6699999999999875]  min= 0.5999999999999943  max= 0.7599999999999909
2025-04-18 13:46:11.493 E         + non_comprs_txt= [0.20999999999999375, 0.21999999999999886, 0.2400000000000091, 0.20000000000000284, 0.21000000000000796, 0.20999999999999375, 0.1699999999999875, 0.12999999999999545, 0.20999999999999375]  min= 0.12999999999999545  max= 0.2400000000000091
2025-04-18 13:46:11.513 E         + non_comprs_bin= [0.28000000000000114, 0.269999999999996, 0.3299999999999983, 0.28999999999999204, 0.19000000000001194, 0.21999999999999886, 0.2400000000000091, 0.2600000000000051, 0.28000000000000114]  min= 0.19000000000001194  max= 0.3299999999999983
2025-04-18 13:46:11.526 E         + median(compressed_txt) / median(non_comprs_txt) = 3.047619047619141
2025-04-18 13:46:11.537 E         + median(compressed_bin) / median(non_comprs_bin) = 2.4814814814814716
2025-04-18 13:46:11.546 E         + median(non_comprs_txt) / median(non_comprs_bin) = 0.7777777777777661
2025-04-18 13:46:11.553
2025-04-18 13:46:11.561 tests/bugs/core_0733_test.py:254: AssertionError
2025-04-18 13:46:11.571 ---------------------------- Captured stdout setup -----------------------------
2025-04-18 13:46:11.579 Creating db: localhost:/var/tmp/qa_2024/test_173/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
2025-04-18 13:46:11.587 ____________________ tests/bugs/core_1263_test.py::test_1_a ____________________
2025-04-18 13:46:11.594
2025-04-18 13:46:11.602 act = <firebird.qa.plugin.Action object at [hex]>
2025-04-18 13:46:11.609
2025-04-18 13:46:11.617 @pytest.mark.version('>=3.0')
2025-04-18 13:46:11.625 @pytest.mark.platform('Linux', 'Darwin')
2025-04-18 13:46:11.640 def test_1_a(act: Action):
2025-04-18 13:46:11.651 act.expected_stderr = expected_stderr_a
2025-04-18 13:46:11.660 act.gsec(input=commands)
2025-04-18 13:46:11.666 >       assert act.clean_stderr == act.clean_expected_stderr
2025-04-18 13:46:11.679 E       assert
2025-04-18 13:46:11.687 E           GSEC> invalid switch specified in interactive mode
2025-04-18 13:46:11.696 E           GSEC> invalid switch specified in interactive mode
2025-04-18 13:46:11.706 E           GSEC> invalid switch specified in interactive mode
2025-04-18 13:46:11.716 E           GSEC> invalid switch specified in interactive mode
2025-04-18 13:46:11.730 E           GSEC> invalid switch specified in interactive mode
2025-04-18 13:46:11.739 E         - GSEC> invalid switch specified
2025-04-18 13:46:11.756 E         + GSEC> invalid switch specified in interactive mode
2025-04-18 13:46:11.775 E         - error in switch specifications
2025-04-18 13:46:11.784 E           GSEC>
2025-04-18 13:46:11.791
2025-04-18 13:46:11.797 tests/bugs/core_1263_test.py:44: AssertionError
2025-04-18 13:46:11.805 ---------------------------- Captured stdout setup -----------------------------
2025-04-18 13:46:11.814 Creating db: localhost:/var/tmp/qa_2024/test_1_a0/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 sending INCOMPRESSABLE BINARY DATA and WireCompression is ON vs OFF: /* perf_issue_tag */ UNEXPECTED, less than 4
E           CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: EXPECTED
E         + compressed_txt= [0.6899999999999977, 0.6099999999999994, 0.6400000000000006, 0.7400000000000091, 0.6200000000000045, 0.75, 0.6000000000000085, 0.6900000000000119, 0.5999999999999943]  min= 0.5999999999999943  max= 0.75
E         + compressed_bin= [0.6499999999999915, 0.5999999999999943, 0.6700000000000017, 0.7599999999999909, 0.75, 0.6600000000000108, 0.6099999999999994, 0.75, 0.6699999999999875]  min= 0.5999999999999943  max= 0.7599999999999909
E         + non_comprs_txt= [0.20999999999999375, 0.21999999999999886, 0.2400000000000091, 0.20000000000000284, 0.21000000000000796, 0.20999999999999375, 0.1699999999999875, 0.12999999999999545, 0.20999999999999375]  min= 0.12999999999999545  max= 0.2400000000000091
E         + non_comprs_bin= [0.28000000000000114, 0.269999999999996, 0.3299999999999983, 0.28999999999999204, 0.19000000000001194, 0.21999999999999886, 0.2400000000000091, 0.2600000000000051, 0.28000000000000114]  min= 0.19000000000001194  max= 0.3299999999999983
E         + median(compressed_txt) / median(non_comprs_txt) = 3.047619047619141
E         + median(compressed_bin) / median(non_comprs_bin) = 2.4814814814814716
E         + median(non_comprs_txt) / median(non_comprs_bin) = 0.7777777777777661

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 5.0.3.1674 2025.06.27 3ee5c F F 33577 28916 2025.06.30 11:50:16.731 2025.06.30 11:50:50.308 2025.06.30 10:43:55.225 2025.06.30 10:44:24.141
2 5.0.3.1657 2025.06.19 4bd4c F F 29429 27334 2025.06.27 11:23:55.757 2025.06.27 11:24:25.186 2025.06.27 10:18:44.639 2025.06.27 10:19:11.973
3 5.0.3.1657 2025.06.11 dae6f F F 30469 27570 2025.06.17 06:27:53.539 2025.06.17 06:28:24.008 2025.06.17 05:21:36.477 2025.06.17 05:22:04.047
4 5.0.3.1657 2025.06.10 dbc92 F F 37875 36448 2025.06.11 11:13:54.746 2025.06.11 11:14:32.621 2025.06.11 09:56:25.917 2025.06.11 09:57:02.365
5 5.0.3.1656 2025.05.20 c4b11 F F 31684 30337 2025.06.10 11:09:31.787 2025.06.10 11:10:03.471 2025.06.10 10:00:04.389 2025.06.10 10:00:34.726
6 5.0.3.1652 2025.05.13 f51c6 F F 36825 34884 2025.05.20 04:05:31.144 2025.05.20 04:06:07.969 2025.05.20 02:47:14.351 2025.05.20 02:47:49.235
7 5.0.3.1651 2025.04.30 141ef F F 39906 38268 2025.05.13 11:03:27.539 2025.05.13 11:04:07.445 2025.05.13 09:42:55.104 2025.05.13 09:43:33.372
8 5.0.3.1650 2025.04.28 4cbff F F 40243 38790 2025.05.01 10:37:12.131 2025.05.01 10:37:52.374 2025.05.01 09:18:11.881 2025.05.01 09:18:50.671
9 5.0.3.1649 2025.04.21 5b2d0 F F 37666 35390 2025.04.28 04:36:51.204 2025.04.28 04:37:28.870 2025.04.28 03:19:34.172 2025.04.28 03:20:09.562
10 5.0.3.1648 2025.04.18 2f4c5 F F 33362 32253 2025.04.20 04:29:19.845 2025.04.20 04:29:53.207 2025.04.20 03:14:24.588 2025.04.20 03:14:56.841
11 5.0.3.1635 2025.03.31 22ec6 F F 39272 35410 2025.04.18 10:49:35.414 2025.04.18 10:50:14.686 2025.04.18 09:30:46.144 2025.04.18 09:31:21.554
12 5.0.3.1633 2025.03.28 3123a F F 33374 32196 2025.03.31 09:28:06.203 2025.03.31 09:28:39.577 2025.03.31 08:14:45.643 2025.03.31 08:15:17.839
13 5.0.3.1633 2025.03.27 e0fb8 F F 39827 34778 2025.03.28 09:59:22.842 2025.03.28 10:00:02.669 2025.03.28 08:42:15.515 2025.03.28 08:42:50.293
14 5.0.3.1631 2025.03.21 1925b F F 36894 34557 2025.03.27 09:48:10.160 2025.03.27 09:48:47.054 2025.03.27 08:32:12.609 2025.03.27 08:32:47.166
15 5.0.3.1628 2025.03.14 16d05 F F 857 453 2025.03.17 07:16:08.997 2025.03.17 07:16:09.854 2025.03.17 05:51:52.459 2025.03.17 05:51:52.912
16 5.0.3.1627 2025.02.26 4e218 F F 893 462 2025.03.14 10:25:44.502 2025.03.14 10:25:45.395 2025.03.14 09:04:54.397 2025.03.14 09:04:54.859
17 5.0.3.1624 2025.02.25 dc3b2 F F 831 453 2025.02.26 09:23:41.967 2025.02.26 09:23:42.798 2025.02.26 08:04:47.473 2025.02.26 08:04:47.926
18 5.0.2.1615 2025.02.20 4a726 F F 776 449 2025.02.25 09:50:12.309 2025.02.25 09:50:13.085 2025.02.25 08:29:50.238 2025.02.25 08:29:50.687
19 5.0.2.1615 2025.02.14 9cb76 F F 804 464 2025.02.20 06:41:49.328 2025.02.20 06:41:50.132 2025.02.20 05:24:03.903 2025.02.20 05:24:04.367
20 5.0.2.1577 2024.12.24 3c80e F F 843 438 2025.02.14 09:55:06.433 2025.02.14 09:55:07.276 2025.02.14 08:39:52.909 2025.02.14 08:39:53.347
21 5.0.2.1576 2024.12.17 646b0 F F 625 319 2024.12.24 17:34:04.352 2024.12.24 17:34:04.977 2024.12.24 16:35:46.670 2024.12.24 16:35:46.989
22 5.0.2.1575 2024.12.08 63d39 F F 582 334 2024.12.16 07:16:30.359 2024.12.16 07:16:30.941 2024.12.16 06:19:45.567 2024.12.16 06:19:45.901
23 5.0.2.1567 2024.11.26 56e63 F F 665 369 2024.12.04 06:55:23.414 2024.12.04 06:55:24.079 2024.12.04 05:56:28.761 2024.12.04 05:56:29.130
24 5.0.2.1567 2024.11.21 96f61 F F 580 340 2024.11.26 04:39:34.098 2024.11.26 04:39:34.678 2024.11.26 03:44:08.377 2024.11.26 03:44:08.717
25 5.0.2.1567 2024.11.18 e1289 F F 590 326 2024.11.21 06:44:51.155 2024.11.21 06:44:51.745 2024.11.21 05:49:00.831 2024.11.21 05:49:01.157
26 5.0.2.1533 2024.10.23 0ec43 F F 582 355 2024.11.18 06:59:25.019 2024.11.18 06:59:25.601 2024.11.18 06:02:23.239 2024.11.18 06:02:23.594
27 5.0.2.1533 2024.10.22 8af7a F F 688 345 2024.10.23 08:55:27.929 2024.10.23 08:55:28.617 2024.10.23 07:58:08.107 2024.10.23 07:58:08.452
28 5.0.2.1532 2024.10.15 36dc0 F F 678 372 2024.10.22 19:07:45.617 2024.10.22 19:07:46.295 2024.10.22 18:10:44.870 2024.10.22 18:10:45.242
29 5.0.2.1518 2024.10.04 259ba F F 603 344 2024.10.15 08:41:09.951 2024.10.15 08:41:10.554 2024.10.15 07:43:46.562 2024.10.15 07:43:46.906
30 5.0.2.1518 2024.09.26 703cd F F 661 343 2024.10.03 07:06:38.861 2024.10.03 07:06:39.522 2024.10.03 06:08:22.277 2024.10.03 06:08:22.620
31 5.0.2.1489 2024.09.05 40838 F F 682 388 2024.09.25 07:06:42.516 2024.09.25 07:06:43.198 2024.09.25 06:07:33.400 2024.09.25 06:07:33.788
32 5.0.2.1489 2024.08.31 994a6 F F 1292 450 2024.09.05 10:54:20.357 2024.09.05 10:54:21.649 2024.09.05 09:40:49.658 2024.09.05 09:40:50.108
33 5.0.2.1476 2024.08.09 843ea F F 1280 694 2024.08.31 13:03:48.714 2024.08.31 13:03:49.994 2024.08.31 11:21:50.876 2024.08.31 11:21:51.570
34 5.0.1.1454 2024.08.08 30f9f F F 783 466 2024.08.09 07:42:36.547 2024.08.09 07:42:37.330 2024.08.09 06:42:52.597 2024.08.09 06:42:53.063
35 5.0.1.1453 2024.08.06 1b9d0 F F 892 528 2024.08.08 20:21:11.458 2024.08.08 20:21:12.350 2024.08.08 19:20:26.810 2024.08.08 19:20:27.338
36 5.0.1.1453 2024.07.30 48044 P P 542 354 2024.08.06 06:30:58.992 2024.08.06 06:30:59.534 2024.08.06 05:37:24.807 2024.08.06 05:37:25.161
37 5.0.1.1453 2024.07.28 8d956 P P 492 313 2024.07.30 06:25:56.686 2024.07.30 06:25:57.178 2024.07.30 05:32:43.482 2024.07.30 05:32:43.795
38 5.0.1.1429 2024.07.19 8ee90 P P 519 342 2024.07.27 06:25:21.555 2024.07.27 06:25:22.074 2024.07.27 05:30:40.799 2024.07.27 05:30:41.141
39 5.0.1.1428 2024.07.15 00392 P P 557 282 2024.07.19 06:19:26.954 2024.07.19 06:19:27.511 2024.07.19 05:26:59.322 2024.07.19 05:26:59.604
40 5.0.1.1428 2024.06.30 67a31 P P 525 294 2024.07.15 06:20:39.587 2024.07.15 06:20:40.112 2024.07.15 05:27:09.837 2024.07.15 05:27:10.131
41 5.0.1.1415 2024.06.11 31d74 P P 583 304 2024.06.22 06:10:10.899 2024.06.22 06:10:11.482 2024.06.22 05:19:10.490 2024.06.22 05:19:10.794

Elapsed time, ms. Chart for last 41 runs:

Last commits information (all timestamps in UTC):