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.61, 0.8, 0.7799999999999999, 0.77, 0.6599999999999999, 0.62, 0.7, 0.6799999999999999, 0.74]  min= 0.61  max= 0.8
  + compressed_bin= [0.65, 0.82, 0.7000000000000001, 0.81, 0.76, 0.7599999999999999, 0.8400000000000001, 0.79, 0.84]  min= 0.65  max= 0.8400000000000001
  + non_comprs_txt= [0.19999999999999998, 0.18, 0.22000000000000003, 0.2, 0.15, 0.19999999999999998, 0.18, 0.18, 0.15000000000000002]  min= 0.15  max= 0.22000000000000003
  + non_comprs_bin= [0.26, 0.28, 0.21999999999999997, 0.22999999999999998, 0.26, 0.28, 0.22999999999999998, 0.30000000000000004, 0.27]  min= 0.21999999999999997  max= 0.30000000000000004
  + median(compressed_txt) / median(non_comprs_txt) = 3.888888888888889
  + median(compressed_bin) / median(non_comprs_bin) = 3.0384615384615383
  + median(non_comprs_txt) / median(non_comprs_bin) = 0.6923076923076923

LOG DETAILS:

2025-03-27 14:21:58.232
2025-03-27 14:21:58.238 act = <firebird.qa.plugin.Action object at [hex]>
2025-03-27 14:21:58.246 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-03-27 14:21:58.253
2025-03-27 14:21:58.260 @pytest.mark.version('>=3.0')
2025-03-27 14:21:58.267 def test_1(act: Action, capsys):
2025-03-27 14:21:58.274
2025-03-27 14:21:58.282 # OPTIONAL CHECK: minimal ratio between CPU user time when WireCompression = false
2025-03-27 14:21:58.289 # and engine sends to client: 1) 'IDEALLY COMPRESSABLE'; 2) 'ABSOLUTELY IMCOMPRESSIBLE' data.
2025-03-27 14:21:58.296 # This can be useful to estimate record-level compression: textual data can be compressed
2025-03-27 14:21:58.303 # very well, so its transfer must take much less time then for GEN_UUID.
2025-03-27 14:21:58.311 # Experiments show that this ratio can be on Windows in the scope 0.3.... 0.8,
2025-03-27 14:21:58.325 # but on Linux it can be 1.0 or even slightly more then 1(!)
2025-03-27 14:21:58.333 # Windows: 0.500; 0.600; 0.571; 0.428; 0.714; 0.667; 0.625; 0.429; 0.571 // 4.0.1
2025-03-27 14:21:58.339 #          0.454; 0.357; 0.357; 0.500; 0.250; 0.385; 0.333; 0.200; 0.500 // 3.0.8
2025-03-27 14:21:58.346 # Linux:   0.684; 1.000; 1.000; 1.067; 0.867; 0.813; 0.800; 0.777; 0.750 // 4.0.1
2025-03-27 14:21:58.354 #          0.928; 1.000; 0.933; 1.000; 1.077; 0.750; 0.938; 0.929; 0.928 // 3.0.8
2025-03-27 14:21:58.362 if act.is_version('<4'):
2025-03-27 14:21:58.371 # 16.09.2022, 4.3.0.8 Classic: Windows -> 1.2
2025-03-27 14:21:58.378 MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF = 1.1 if platform.system() == 'Linux' else 1.5
2025-03-27 14:21:58.385 else:
2025-03-27 14:21:58.391 # 05.03.2023, 5.0.0.970, SS, Linux: 1.1 --> 1.3
2025-03-27 14:21:58.398 # 05.04.2023, 5.0.0.1001, SS, WIndows: 0.95 --> 1.5
2025-03-27 14:21:58.405 MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF = 1.3 if platform.system() == 'Linux' else 1.5
2025-03-27 14:21:58.411
2025-03-27 14:21:58.418 # Register Firebird server (D:\FB\probes\fid-set-dpb-probe-05x.py)
2025-03-27 14:21:58.428 srv_cfg = driver_config.register_server(name = 'test_srv_core_0733', config = '')
2025-03-27 14:21:58.441
2025-03-27 14:21:58.454 #srv_config_key_value_text = \
2025-03-27 14:21:58.464 #f"""
2025-03-27 14:21:58.472 #    [test_srv_core_0733]
2025-03-27 14:21:58.479 #    protocol = inet
2025-03-27 14:21:58.486 #"""
2025-03-27 14:21:58.493 #driver_config.register_server(name = 'test_srv_core_0733', config = srv_config_key_value_text)
2025-03-27 14:21:58.500 #db_cfg_object = driver_config.register_database(name = 'test_db_core_0733')
2025-03-27 14:21:58.506 #db_cfg_object.database.value = str(act.db.db_path)
2025-03-27 14:21:58.513
2025-03-27 14:21:58.520 benchmark_data = defaultdict(list)
2025-03-27 14:21:58.527
2025-03-27 14:21:58.535 for w_compr in (True, False):
2025-03-27 14:21:58.542
2025-03-27 14:21:58.549 db_cfg_name = f'test_db_core_0733__wcompr_{w_compr}'
2025-03-27 14:21:58.555 db_cfg_object = driver_config.register_database(name = db_cfg_name)
2025-03-27 14:21:58.562 db_cfg_object.server.value = srv_cfg.name
2025-03-27 14:21:58.569 # db_cfg_object.protocol.value = None /  XNET /  WNET -- these can not be used in this test!
2025-03-27 14:21:58.576 db_cfg_object.protocol.value = NetProtocol.INET
2025-03-27 14:21:58.584 db_cfg_object.database.value = str(act.db.db_path)
2025-03-27 14:21:58.591 db_cfg_object.config.value = f"""
2025-03-27 14:21:58.598 WireCrypt = Disabled
2025-03-27 14:21:58.606 WireCompression = {w_compr}
2025-03-27 14:21:58.614 """
2025-03-27 14:21:58.620 for i in range(0, N_MEASURES):
2025-03-27 14:21:58.626 with connect(db_cfg_name, user = act.db.user, password = act.db.password) as con:
2025-03-27 14:21:58.635 prot_name = db_cfg_object.protocol.value.name if db_cfg_object.protocol.value else 'Embedded'
2025-03-27 14:21:58.643 assert w_compr == con.info.is_compressed(), f'Protocol: {prot_name} - can not be used to measure wire_compression'
2025-03-27 14:21:58.648
2025-03-27 14:21:58.654 with con.cursor() as cur:
2025-03-27 14:21:58.661 cur.execute('select mon$server_pid, mon$remote_protocol as p from mon$attachments where mon$attachment_id = current_connection')
2025-03-27 14:21:58.667 for r in cur:
2025-03-27 14:21:58.674 fb_pid, connection_protocol = r
2025-03-27 14:21:58.681 assert connection_protocol.startswith('TCP'), f'Invalid connection protocol: {connection_protocol}'
2025-03-27 14:21:58.687
2025-03-27 14:21:58.694 for data_source in ('t_common_text', 't_binary_data'):
2025-03-27 14:21:58.701 cur.execute('select s from ' + data_source)
2025-03-27 14:21:58.708
2025-03-27 14:21:58.715 fb_info_a = psutil.Process(fb_pid).cpu_times()
2025-03-27 14:21:58.722 for r in cur:
2025-03-27 14:21:58.729 # *** FULL FETCH ***
2025-03-27 14:21:58.736 pass
2025-03-27 14:21:58.744 fb_info_b = psutil.Process(fb_pid).cpu_times()
2025-03-27 14:21:58.752
2025-03-27 14:21:58.761 k = ('WireCompression=%d' % (1 if w_compr else 0), 'DataSource='+data_source)
2025-03-27 14:21:58.769 benchmark_data[k] += fb_info_b.user - fb_info_a.user,
2025-03-27 14:21:58.777
2025-03-27 14:21:58.785
2025-03-27 14:21:58.794 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-27 14:21:58.802 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-27 14:21:58.811 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-27 14:21:58.821 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-27 14:21:58.827
2025-03-27 14:21:58.842 cpu_txt_wcompr_ON_vs_OFF = median(compressed_txt) / max(0.00001, median(non_comprs_txt))
2025-03-27 14:21:58.851 cpu_bin_wcompr_ON_vs_OFF = median(compressed_bin) / max(0.00001, median(non_comprs_bin))
2025-03-27 14:21:58.858 cpu_txt2bin_wcompr_OFF = median(non_comprs_txt) / max(0.00001, median(non_comprs_bin))
2025-03-27 14:21:58.865
2025-03-27 14:21:58.871 msg_result1 = 'CPU time ratio when sending %s and WireCompression is ON vs OFF: %s'
2025-03-27 14:21:58.878 what_sent1 = 'COMPRESSABLE TEXTUAL DATA'
2025-03-27 14:21:58.883 all_fine = 1
2025-03-27 14:21:58.890 if cpu_txt_wcompr_ON_vs_OFF > MIN_CPU_RATIO_TXT_WCOMPR_ON_OFF:
2025-03-27 14:21:58.898 print(msg_result1 % (what_sent1, 'EXPECTED') )
2025-03-27 14:21:58.905 else:
2025-03-27 14:21:58.912 print(msg_result1 % (what_sent1, '/* perf_issue_tag */ UNEXPECTED less than '+str(MIN_CPU_RATIO_TXT_WCOMPR_ON_OFF)) )
2025-03-27 14:21:58.918 all_fine = 0
2025-03-27 14:21:58.924
2025-03-27 14:21:58.931
2025-03-27 14:21:58.937 what_sent2 = 'INCOMPRESSABLE BINARY DATA'
2025-03-27 14:21:58.943 if cpu_bin_wcompr_ON_vs_OFF > MIN_CPU_RATIO_BIN_WCOMPR_ON_OFF:
2025-03-27 14:21:58.950 print(msg_result1 % (what_sent2, 'EXPECTED') )
2025-03-27 14:21:58.957 else:
2025-03-27 14:21:58.963 print(msg_result1 % (what_sent2, '/* perf_issue_tag */ UNEXPECTED, less than '+str(MIN_CPU_RATIO_BIN_WCOMPR_ON_OFF)) )
2025-03-27 14:21:58.969 all_fine = 0
2025-03-27 14:21:58.976
2025-03-27 14:21:58.982
2025-03-27 14:21:58.989 msg_result2 = 'CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: %s'
2025-03-27 14:21:58.997 if cpu_txt2bin_wcompr_OFF <= MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF:
2025-03-27 14:21:59.004 print(msg_result2 % ('EXPECTED') )
2025-03-27 14:21:59.010 else:
2025-03-27 14:21:59.017 print(msg_result2 % ('/* perf_issue_tag */ UNEXPECTED, more than ' + str(MAX_CPU_RATIO_TXT2BIN_WCOMPR_OFF)) )
2025-03-27 14:21:59.024 all_fine = 0
2025-03-27 14:21:59.033
2025-03-27 14:21:59.043 if not all_fine:
2025-03-27 14:21:59.050 print('compressed_txt=',compressed_txt,' min=',min(compressed_txt),' max=',max(compressed_txt))
2025-03-27 14:21:59.063 print('compressed_bin=',compressed_bin,' min=',min(compressed_bin),' max=',max(compressed_bin))
2025-03-27 14:21:59.072 print('non_comprs_txt=',non_comprs_txt,' min=',min(non_comprs_txt),' max=',max(non_comprs_txt))
2025-03-27 14:21:59.078 print('non_comprs_bin=',non_comprs_bin,' min=',min(non_comprs_bin),' max=',max(non_comprs_bin))
2025-03-27 14:21:59.083
2025-03-27 14:21:59.089 print('median(compressed_txt) / median(non_comprs_txt) =',1.000 * median(compressed_txt) / max(0.00001, median(non_comprs_txt)) )
2025-03-27 14:21:59.094 print('median(compressed_bin) / median(non_comprs_bin) =',1.000 * median(compressed_bin) / max(0.00001, median(non_comprs_bin)) )
2025-03-27 14:21:59.100 print('median(non_comprs_txt) / median(non_comprs_bin) =',1.000 * median(non_comprs_txt) / max(0.00001, median(non_comprs_bin)) )
2025-03-27 14:21:59.105
2025-03-27 14:21:59.110
2025-03-27 14:21:59.115 expected_stdout = ''
2025-03-27 14:21:59.121 for f in (what_sent1, what_sent2):
2025-03-27 14:21:59.126 expected_stdout += ''.join( (msg_result1 % (f, 'EXPECTED'), '\n')  )
2025-03-27 14:21:59.131 expected_stdout += (msg_result2 % 'EXPECTED')
2025-03-27 14:21:59.136
2025-03-27 14:21:59.141 act.expected_stdout = expected_stdout
2025-03-27 14:21:59.154 act.stdout = capsys.readouterr().out
2025-03-27 14:21:59.162 >       assert act.clean_stdout == act.clean_expected_stdout
2025-03-27 14:21:59.169 E       assert
2025-03-27 14:21:59.177 E         - CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: EXPECTED
2025-03-27 14:21:59.184 E         + CPU time ratio when sending COMPRESSABLE TEXTUAL DATA and WireCompression is ON vs OFF: /* perf_issue_tag */ UNEXPECTED less than 5
2025-03-27 14:21:59.210 E         - CPU time ratio when sending INCOMPRESSABLE BINARY DATA and WireCompression is ON vs OFF: EXPECTED
2025-03-27 14:21:59.222 E         + CPU time ratio when sending INCOMPRESSABLE BINARY DATA and WireCompression is ON vs OFF: /* perf_issue_tag */ UNEXPECTED, less than 4
2025-03-27 14:21:59.239 E           CPU time ratio when WireCompression is OFF and sending TEXTUAL vs BINARY data: EXPECTED
2025-03-27 14:21:59.247 E         + compressed_txt= [0.61, 0.8, 0.7799999999999999, 0.77, 0.6599999999999999, 0.62, 0.7, 0.6799999999999999, 0.74]  min= 0.61  max= 0.8
2025-03-27 14:21:59.254 E         + compressed_bin= [0.65, 0.82, 0.7000000000000001, 0.81, 0.76, 0.7599999999999999, 0.8400000000000001, 0.79, 0.84]  min= 0.65  max= 0.8400000000000001
2025-03-27 14:21:59.261 E         + non_comprs_txt= [0.19999999999999998, 0.18, 0.22000000000000003, 0.2, 0.15, 0.19999999999999998, 0.18, 0.18, 0.15000000000000002]  min= 0.15  max= 0.22000000000000003
2025-03-27 14:21:59.269 E         + non_comprs_bin= [0.26, 0.28, 0.21999999999999997, 0.22999999999999998, 0.26, 0.28, 0.22999999999999998, 0.30000000000000004, 0.27]  min= 0.21999999999999997  max= 0.30000000000000004
2025-03-27 14:21:59.276 E         + median(compressed_txt) / median(non_comprs_txt) = 3.888888888888889
2025-03-27 14:21:59.283 E         + median(compressed_bin) / median(non_comprs_bin) = 3.0384615384615383
2025-03-27 14:21:59.292 E         + median(non_comprs_txt) / median(non_comprs_bin) = 0.6923076923076923
2025-03-27 14:21:59.301
2025-03-27 14:21:59.307 tests/bugs/core_0733_test.py:254: AssertionError
2025-03-27 14:21:59.313 ---------------------------- Captured stdout setup -----------------------------
2025-03-27 14:21:59.319 Creating db: localhost:/var/tmp/qa_2024/test_173/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
2025-03-27 14:21:59.325 ____________________ tests/bugs/core_1263_test.py::test_1_a ____________________
2025-03-27 14:21:59.330
2025-03-27 14:21:59.339 act = <firebird.qa.plugin.Action object at [hex]>
2025-03-27 14:21:59.349
2025-03-27 14:21:59.357 @pytest.mark.version('>=3.0')
2025-03-27 14:21:59.363 @pytest.mark.platform('Linux', 'Darwin')
2025-03-27 14:21:59.369 def test_1_a(act: Action):
2025-03-27 14:21:59.375 act.expected_stderr = expected_stderr_a
2025-03-27 14:21:59.381 act.gsec(input=commands)
2025-03-27 14:21:59.388 >       assert act.clean_stderr == act.clean_expected_stderr
2025-03-27 14:21:59.393 E       assert
2025-03-27 14:21:59.399 E           GSEC> invalid switch specified in interactive mode
2025-03-27 14:21:59.404 E           GSEC> invalid switch specified in interactive mode
2025-03-27 14:21:59.411 E           GSEC> invalid switch specified in interactive mode
2025-03-27 14:21:59.416 E           GSEC> invalid switch specified in interactive mode
2025-03-27 14:21:59.422 E           GSEC> invalid switch specified in interactive mode
2025-03-27 14:21:59.428 E         - GSEC> invalid switch specified
2025-03-27 14:21:59.434 E         + GSEC> invalid switch specified in interactive mode
2025-03-27 14:21:59.445 E         - error in switch specifications
2025-03-27 14:21:59.451 E           GSEC>
2025-03-27 14:21:59.460
2025-03-27 14:21:59.468 tests/bugs/core_1263_test.py:44: AssertionError
2025-03-27 14:21:59.477 ---------------------------- Captured stdout setup -----------------------------
2025-03-27 14:21:59.485 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.61, 0.8, 0.7799999999999999, 0.77, 0.6599999999999999, 0.62, 0.7, 0.6799999999999999, 0.74]  min= 0.61  max= 0.8
E         + compressed_bin= [0.65, 0.82, 0.7000000000000001, 0.81, 0.76, 0.7599999999999999, 0.8400000000000001, 0.79, 0.84]  min= 0.65  max= 0.8400000000000001
E         + non_comprs_txt= [0.19999999999999998, 0.18, 0.22000000000000003, 0.2, 0.15, 0.19999999999999998, 0.18, 0.18, 0.15000000000000002]  min= 0.15  max= 0.22000000000000003
E         + non_comprs_bin= [0.26, 0.28, 0.21999999999999997, 0.22999999999999998, 0.26, 0.28, 0.22999999999999998, 0.30000000000000004, 0.27]  min= 0.21999999999999997  max= 0.30000000000000004
E         + median(compressed_txt) / median(non_comprs_txt) = 3.888888888888889
E         + median(compressed_bin) / median(non_comprs_bin) = 3.0384615384615383
E         + median(non_comprs_txt) / median(non_comprs_bin) = 0.6923076923076923

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 29198 30069 2025.07.03 09:59:06.368 2025.07.03 09:59:35.566 2025.07.03 08:52:26.128 2025.07.03 08:52:56.197
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):