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 14:21:04.361
2024-08-09 14:21:04.366 act = <firebird.qa.plugin.Action object at [hex]>
2024-08-09 14:21:04.371
2024-08-09 14:21:04.376 @pytest.mark.es_eds
2024-08-09 14:21:04.381 @pytest.mark.version('>=3.0.1')
2024-08-09 14:21:04.386 def test_1(act: Action):
2024-08-09 14:21:04.391
2024-08-09 14:21:04.396 if (res := check_ipv6_avail()) < 0:
2024-08-09 14:21:04.401 pytest.skip(f"IPv6 not avail, retcode: {res}")
2024-08-09 14:21:04.406
2024-08-09 14:21:04.412 sql_chk = f"""
2024-08-09 14:21:04.417 set list on;
2024-08-09 14:21:04.422 commit;
2024-08-09 14:21:04.427 connect 'inet4://127.0.0.1/{act.db.db_path}';
2024-08-09 14:21:04.432
2024-08-09 14:21:04.437 select mon$remote_protocol as procotol_when_connect_from_isql
2024-08-09 14:21:04.442 from mon$attachments where mon$attachment_id = current_connection;
2024-08-09 14:21:04.452
2024-08-09 14:21:04.457 set term ^;
2024-08-09 14:21:04.462 execute block returns(protocol_when_connect_by_es_eds varchar(20) ) as
2024-08-09 14:21:04.467 declare stt varchar(255) = 'select mon$remote_protocol from mon$attachments where mon$attachment_id = current_connection';
2024-08-09 14:21:04.473 begin
2024-08-09 14:21:04.478 for
2024-08-09 14:21:04.483 execute statement (stt)
2024-08-09 14:21:04.487 on external 'inet4://127.0.0.1/{act.db.db_path}'
2024-08-09 14:21:04.492 as user '{act.db.user}' password '{act.db.password}'
2024-08-09 14:21:04.501 into protocol_when_connect_by_es_eds
2024-08-09 14:21:04.511 do
2024-08-09 14:21:04.517 suspend;
2024-08-09 14:21:04.529 end
2024-08-09 14:21:04.534 ^
2024-08-09 14:21:04.545 set term ;^
2024-08-09 14:21:04.550 commit;
2024-08-09 14:21:04.555
2024-08-09 14:21:04.563 -- since 27.10.2019; checked again 13.06.2024
2024-08-09 14:21:04.573 connect 'inet6://[::1]/{act.db.db_path}';
2024-08-09 14:21:04.578
2024-08-09 14:21:04.585 select mon$remote_protocol as procotol_when_connect_from_isql
2024-08-09 14:21:04.595 from mon$attachments where mon$attachment_id = current_connection;
2024-08-09 14:21:04.600
2024-08-09 14:21:04.611 set term ^;
2024-08-09 14:21:04.617 execute block returns(protocol_when_connect_by_es_eds varchar(20) ) as
2024-08-09 14:21:04.627 declare stt varchar(255) = 'select mon$remote_protocol from mon$attachments where mon$attachment_id = current_connection';
2024-08-09 14:21:04.633 begin
2024-08-09 14:21:04.645 for
2024-08-09 14:21:04.651 execute statement (stt)
2024-08-09 14:21:04.659 -- Failed before fix #8156 ("Can not specify concrete IPv6 address in ES/EDS connection string"):
2024-08-09 14:21:04.667 on external 'inet6://[::1]/{act.db.db_path}'
2024-08-09 14:21:04.675 as user '{act.db.user}' password '{act.db.password}'
2024-08-09 14:21:04.683 into protocol_when_connect_by_es_eds
2024-08-09 14:21:04.691 do
2024-08-09 14:21:04.698 suspend;
2024-08-09 14:21:04.706 end
2024-08-09 14:21:04.713 ^
2024-08-09 14:21:04.720 set term ;^
2024-08-09 14:21:04.736 commit;
2024-08-09 14:21:04.744 """
2024-08-09 14:21:04.752
2024-08-09 14:21:04.757 expected_stdout = """
2024-08-09 14:21:04.764 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv4
2024-08-09 14:21:04.769 PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv4
2024-08-09 14:21:04.773 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv6
2024-08-09 14:21:04.782 PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv6
2024-08-09 14:21:04.787 """
2024-08-09 14:21:04.792
2024-08-09 14:21:04.798 act.expected_stdout = expected_stdout
2024-08-09 14:21:04.803 >       act.isql(switches=['-q', f'inet://{act.db.db_path}'], input=sql_chk, connect_db=False)
2024-08-09 14:21:04.808 E       firebird.qa.plugin.ExecutionError: ISQL execution failed
2024-08-09 14:21:04.813
2024-08-09 14:21:04.818 tests/bugs/core_5229_test.py:144: ExecutionError
2024-08-09 14:21:04.824 ---------------------------- Captured stdout setup -----------------------------
2024-08-09 14:21:04.829 Creating db: localhost:/var/tmp/qa_2024/test_11044/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
2024-08-09 14:21:04.834 -------------------------- Captured ISQL stdout call ---------------------------
2024-08-09 14:21:04.839
2024-08-09 14:21:04.848 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv4
2024-08-09 14:21:04.853
2024-08-09 14:21:04.858
2024-08-09 14:21:04.863
2024-08-09 14:21:04.869 PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv4
2024-08-09 14:21:04.874
2024-08-09 14:21:04.879
2024-08-09 14:21:04.883
2024-08-09 14:21:04.888 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv6
2024-08-09 14:21:04.893
2024-08-09 14:21:04.899
2024-08-09 14:21:04.905
2024-08-09 14:21:04.910 -------------------------- Captured ISQL stderr call ---------------------------
2024-08-09 14:21:04.915 Statement failed, SQLSTATE = 42000
2024-08-09 14:21:04.920 External Data Source provider 'inet6://[' not found
2024-08-09 14:21:04.925 -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 4.0.6.3189 2025.02.25 1a1a5 P P 855 467 2025.06.26 14:21:42.695 2025.06.26 14:21:43.550 2025.06.26 13:15:16.694 2025.06.26 13:15:17.161
2 4.0.6.3184 2025.02.24 9388c P P 2499 2244 2025.02.25 13:18:10.908 2025.02.25 13:18:13.407 2025.02.25 12:02:26.431 2025.02.25 12:02:28.675
3 4.0.6.3183 2025.02.16 cf6ca P P 2678 2672 2025.02.17 07:11:42.987 2025.02.17 07:11:45.665 2025.02.17 05:55:35.452 2025.02.17 05:55:38.124
4 4.0.6.3169 2024.12.13 42cc1 P P 2478 2256 2025.02.16 04:09:52.045 2025.02.16 04:09:54.523 2025.02.16 02:55:55.260 2025.02.16 02:55:57.516
5 4.0.6.3169 2024.12.08 50eb6 P P 1969 1844 2024.12.12 18:33:08.261 2024.12.12 18:33:10.230 2024.12.12 17:33:53.299 2024.12.12 17:33:55.143
6 4.0.6.3168 2024.11.28 48149 P P 2101 1723 2024.12.06 02:54:50.321 2024.12.06 02:54:52.422 2024.12.06 01:57:02.471 2024.12.06 01:57:04.194
7 4.0.6.3163 2024.10.16 2bb10 P P 1996 1886 2024.11.27 11:18:36.514 2024.11.27 11:18:38.510 2024.11.27 10:19:59.084 2024.11.27 10:20:00.970
8 4.0.6.3163 2024.10.15 f387e P P 1958 1818 2024.10.16 04:25:23.312 2024.10.16 04:25:25.270 2024.10.16 03:30:11.626 2024.10.16 03:30:13.444
9 4.0.6.3147 2024.08.31 4655b P P 2031 1967 2024.09.30 11:39:06.077 2024.09.30 11:39:08.108 2024.09.30 10:37:42.403 2024.09.30 10:37:44.370
10 4.0.6.3140 2024.08.16 1dd8b P P 3607 3000 2024.08.31 17:50:18.628 2024.08.31 17:50:22.235 2024.08.31 16:00:46.773 2024.08.31 16:00:49.773
11 4.0.6.3140 2024.08.09 34747 P P 2118 2215 2024.08.16 10:42:26.423 2024.08.16 10:42:28.541 2024.08.16 09:35:32.588 2024.08.16 09:35:34.803
12 4.0.5.3110 2024.07.30 c6527 F F 2126 1945 2024.08.09 10:33:41.208 2024.08.09 10:33:43.334 2024.08.09 09:26:59.295 2024.08.09 09:27:01.240
13 4.0.5.3109 2024.06.11 6addf F F 1912 1779 2024.07.30 08:53:52.271 2024.07.30 08:53:54.183 2024.07.30 07:55:31.826 2024.07.30 07:55:33.605
14 4.0.5.3097 2024.05.09 27fa6 S S 2289 2001 2024.05.14 09:39:34.621 2024.05.14 09:39:36.910 2024.05.14 08:40:25.634 2024.05.14 08:40:27.635
15 4.0.5.3091 2024.04.29 bd0aa S S 1915 1825 2024.05.08 20:43:34.870 2024.05.08 20:43:36.785 2024.05.08 19:52:29.297 2024.05.08 19:52:31.122
16 4.0.5.3089 2024.04.25 4b9c7 S S 1966 1749 2024.04.27 15:27:42.039 2024.04.27 15:27:44.005 2024.04.27 14:36:12.052 2024.04.27 14:36:13.801

Elapsed time, ms. Chart for last 16 runs:

Last commits information (all timestamps in UTC):