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

Annotation type Annotation details
2 @message
firebird.qa.plugin.ExecutionError: ISQL execution failed

LOG DETAILS:

2024-08-09 16:27:06.509
2024-08-09 16:27:06.516 act = <firebird.qa.plugin.Action object at [hex]>
2024-08-09 16:27:06.521
2024-08-09 16:27:06.527 @pytest.mark.es_eds
2024-08-09 16:27:06.533 @pytest.mark.version('>=3.0.1')
2024-08-09 16:27:06.539 def test_1(act: Action):
2024-08-09 16:27:06.544
2024-08-09 16:27:06.553 if (res := check_ipv6_avail()) < 0:
2024-08-09 16:27:06.565 pytest.skip(f"IPv6 not avail, retcode: {res}")
2024-08-09 16:27:06.575
2024-08-09 16:27:06.584 sql_chk = f"""
2024-08-09 16:27:06.591 set list on;
2024-08-09 16:27:06.597 commit;
2024-08-09 16:27:06.604 connect 'inet4://127.0.0.1/{act.db.db_path}';
2024-08-09 16:27:06.609
2024-08-09 16:27:06.618 select mon$remote_protocol as procotol_when_connect_from_isql
2024-08-09 16:27:06.628 from mon$attachments where mon$attachment_id = current_connection;
2024-08-09 16:27:06.639
2024-08-09 16:27:06.646 set term ^;
2024-08-09 16:27:06.657 execute block returns(protocol_when_connect_by_es_eds varchar(20) ) as
2024-08-09 16:27:06.667 declare stt varchar(255) = 'select mon$remote_protocol from mon$attachments where mon$attachment_id = current_connection';
2024-08-09 16:27:06.676 begin
2024-08-09 16:27:06.686 for
2024-08-09 16:27:06.698 execute statement (stt)
2024-08-09 16:27:06.707 on external 'inet4://127.0.0.1/{act.db.db_path}'
2024-08-09 16:27:06.715 as user '{act.db.user}' password '{act.db.password}'
2024-08-09 16:27:06.720 into protocol_when_connect_by_es_eds
2024-08-09 16:27:06.725 do
2024-08-09 16:27:06.730 suspend;
2024-08-09 16:27:06.735 end
2024-08-09 16:27:06.745 ^
2024-08-09 16:27:06.758 set term ;^
2024-08-09 16:27:06.767 commit;
2024-08-09 16:27:06.775
2024-08-09 16:27:06.783 -- since 27.10.2019; checked again 13.06.2024
2024-08-09 16:27:06.789 connect 'inet6://[::1]/{act.db.db_path}';
2024-08-09 16:27:06.795
2024-08-09 16:27:06.801 select mon$remote_protocol as procotol_when_connect_from_isql
2024-08-09 16:27:06.807 from mon$attachments where mon$attachment_id = current_connection;
2024-08-09 16:27:06.813
2024-08-09 16:27:06.819 set term ^;
2024-08-09 16:27:06.826 execute block returns(protocol_when_connect_by_es_eds varchar(20) ) as
2024-08-09 16:27:06.833 declare stt varchar(255) = 'select mon$remote_protocol from mon$attachments where mon$attachment_id = current_connection';
2024-08-09 16:27:06.839 begin
2024-08-09 16:27:06.845 for
2024-08-09 16:27:06.851 execute statement (stt)
2024-08-09 16:27:06.859 -- Failed before fix #8156 ("Can not specify concrete IPv6 address in ES/EDS connection string"):
2024-08-09 16:27:06.865 on external 'inet6://[::1]/{act.db.db_path}'
2024-08-09 16:27:06.872 as user '{act.db.user}' password '{act.db.password}'
2024-08-09 16:27:06.879 into protocol_when_connect_by_es_eds
2024-08-09 16:27:06.885 do
2024-08-09 16:27:06.897 suspend;
2024-08-09 16:27:06.906 end
2024-08-09 16:27:06.915 ^
2024-08-09 16:27:06.925 set term ;^
2024-08-09 16:27:06.934 commit;
2024-08-09 16:27:06.941 """
2024-08-09 16:27:06.948
2024-08-09 16:27:06.955 expected_stdout = """
2024-08-09 16:27:06.961 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv4
2024-08-09 16:27:06.967 PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv4
2024-08-09 16:27:06.972 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv6
2024-08-09 16:27:06.977 PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv6
2024-08-09 16:27:06.983 """
2024-08-09 16:27:06.988
2024-08-09 16:27:06.994 act.expected_stdout = expected_stdout
2024-08-09 16:27:07.001 >       act.isql(switches=['-q', f'inet://{act.db.db_path}'], input=sql_chk, connect_db=False)
2024-08-09 16:27:07.012 E       firebird.qa.plugin.ExecutionError: ISQL execution failed
2024-08-09 16:27:07.018
2024-08-09 16:27:07.024 tests/bugs/core_5229_test.py:144: ExecutionError
2024-08-09 16:27:07.036 ---------------------------- Captured stdout setup -----------------------------
2024-08-09 16:27:07.047 Creating db: localhost:/var/tmp/qa_2024/test_11052/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
2024-08-09 16:27:07.060 -------------------------- Captured ISQL stdout call ---------------------------
2024-08-09 16:27:07.069
2024-08-09 16:27:07.075 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv4
2024-08-09 16:27:07.082
2024-08-09 16:27:07.088
2024-08-09 16:27:07.093
2024-08-09 16:27:07.103 PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv4
2024-08-09 16:27:07.113
2024-08-09 16:27:07.120
2024-08-09 16:27:07.128
2024-08-09 16:27:07.137 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv6
2024-08-09 16:27:07.144
2024-08-09 16:27:07.155
2024-08-09 16:27:07.162
2024-08-09 16:27:07.170 -------------------------- Captured ISQL stderr call ---------------------------
2024-08-09 16:27:07.177 Statement failed, SQLSTATE = 42000
2024-08-09 16:27:07.190 External Data Source provider 'inet6://[' not found
2024-08-09 16:27:07.198 -At block line: 4, col: 13
3 #text
act = <firebird.qa.plugin.Action pytest object at [hex]>

    @pytest.mark.es_eds
    @pytest.mark.version('>=3.0.1')
    def test_1(act: Action):
    
        if (res := check_ipv6_avail()) < 0:
            pytest.skip(f"IPv6 not avail, retcode: {res}")
    
        sql_chk = f"""
            set list on;
            commit;
            connect 'inet4://127.0.0.1/{act.db.db_path}';
    
            select mon$remote_protocol as procotol_when_connect_from_isql
            from mon$attachments where mon$attachment_id = current_connection;
    
            set term ^;
            execute block returns(protocol_when_connect_by_es_eds varchar(20) ) as
                declare stt varchar(255) = 'select mon$remote_protocol from mon$attachments where mon$attachment_id = current_connection';
            begin
                for
                    execute statement (stt)
                        on external 'inet4://127.0.0.1/{act.db.db_path}'
                        as user '{act.db.user}' password '{act.db.password}'
                    into protocol_when_connect_by_es_eds
                do
                    suspend;
            end
            ^
            set term ;^
            commit;
    
            -- since 27.10.2019; checked again 13.06.2024
            connect 'inet6://[::1]/{act.db.db_path}';
    
            select mon$remote_protocol as procotol_when_connect_from_isql
            from mon$attachments where mon$attachment_id = current_connection;
    
            set term ^;
            execute block returns(protocol_when_connect_by_es_eds varchar(20) ) as
                declare stt varchar(255) = 'select mon$remote_protocol from mon$attachments where mon$attachment_id = current_connection';
            begin
                for
                    execute statement (stt)
                        -- Failed before fix #8156 ("Can not specify concrete IPv6 address in ES/EDS connection string"):
                        on external 'inet6://[::1]/{act.db.db_path}'
                        as user '{act.db.user}' password '{act.db.password}'
                    into protocol_when_connect_by_es_eds
                do
                    suspend;
            end
            ^
            set term ;^
            commit;
        """
    
        expected_stdout = """
            PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv4
            PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv4
            PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv6
            PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv6
        """
    
        act.expected_stdout = expected_stdout
>       act.isql(switches=['-q', f'inet://{act.db.db_path}'], input=sql_chk, connect_db=False)
E       firebird.qa.plugin.ExecutionError: ISQL execution failed

tests/bugs/core_5229_test.py:144: ExecutionError
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 3.0.13.33809 2025.05.06 28ad0 P P 1377 482 2025.06.30 14:52:48.179 2025.06.30 14:52:49.556 2025.06.30 14:00:01.321 2025.06.30 14:00:01.803
2 3.0.13.33808 2025.04.25 28426 P P 1655 593 2025.05.06 13:53:18.987 2025.05.06 13:53:20.642 2025.05.06 12:51:06.461 2025.05.06 12:51:07.054
3 3.0.13.33803 2025.02.25 08ebd P P 1657 598 2025.04.25 17:08:21.160 2025.04.25 17:08:22.817 2025.04.25 16:06:38.061 2025.04.25 16:06:38.659
4 3.0.13.33796 2025.01.29 0ab85 P P 3106 2541 2025.02.25 15:40:58.606 2025.02.25 15:41:01.712 2025.02.25 14:39:20.219 2025.02.25 14:39:22.760
5 3.0.13.33796 2025.01.14 99b3b P P 2923 2558 2025.01.28 17:55:28.947 2025.01.28 17:55:31.870 2025.01.28 16:52:04.162 2025.01.28 16:52:06.720
6 3.0.13.33795 2024.11.24 b8847 P P 2745 2751 2025.01.13 15:32:46.051 2025.01.13 15:32:48.796 2025.01.13 14:30:22.873 2025.01.13 14:30:25.624
7 3.0.13.33794 2024.10.15 abe09 P P 2301 1880 2024.11.23 06:37:20.463 2024.11.23 06:37:22.764 2024.11.23 05:50:29.869 2024.11.23 05:50:31.749
8 3.0.13.33793 2024.10.04 82ccc P P 2426 1886 2024.10.14 04:33:35.918 2024.10.14 04:33:38.344 2024.10.14 03:42:10.642 2024.10.14 03:42:12.528
9 3.0.13.33792 2024.08.31 d8791 P P 2545 2091 2024.10.03 09:40:41.908 2024.10.03 09:40:44.453 2024.10.03 08:45:37.055 2024.10.03 08:45:39.146
10 3.0.13.33787 2024.08.17 2e0d6 P P 5801 3174 2024.08.25 15:35:39.672 2024.08.25 15:35:45.473 2024.08.25 13:35:38.885 2024.08.25 13:35:42.059
11 3.0.13.33787 2024.08.09 df740 P P 2766 2043 2024.08.16 12:57:02.420 2024.08.16 12:57:05.186 2024.08.16 11:54:43.541 2024.08.16 11:54:45.584
12 3.0.12.33746 2024.07.15 11dd4 F F 2611 1948 2024.08.09 12:52:38.172 2024.08.09 12:52:40.783 2024.08.09 11:49:13.784 2024.08.09 11:49:15.732
13 3.0.12.33746 2024.06.11 8a5eb F F 2397 2023 2024.07.15 10:43:56.389 2024.07.15 10:43:58.786 2024.07.15 09:50:48.855 2024.07.15 09:50:50.878
14 3.0.12.33744 2024.05.09 9cf37 S S 2334 1966 2024.05.12 15:50:04.364 2024.05.12 15:50:06.698 2024.05.12 15:02:15.151 2024.05.12 15:02:17.117
15 3.0.12.33744 2024.04.20 af6b2 S S 2269 1861 2024.05.08 17:05:33.434 2024.05.08 17:05:35.703 2024.05.08 16:19:54.070 2024.05.08 16:19:55.931

Elapsed time, ms. Chart for last 15 runs:

Last commits information (all timestamps in UTC):