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

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

LOG DETAILS:

2024-08-09 15:25:07.299
2024-08-09 15:25:07.299 act = <firebird.qa.plugin.Action object at [hex]>
2024-08-09 15:25:07.299
2024-08-09 15:25:07.299     @pytest.mark.es_eds
2024-08-09 15:25:07.299     @pytest.mark.version('>=3.0.1')
2024-08-09 15:25:07.299     def test_1(act: Action):
2024-08-09 15:25:07.299
2024-08-09 15:25:07.299         if (res := check_ipv6_avail()) < 0:
2024-08-09 15:25:07.299             pytest.skip(f"IPv6 not avail, retcode: {res}")
2024-08-09 15:25:07.299
2024-08-09 15:25:07.299         sql_chk = f"""
2024-08-09 15:25:07.299             set list on;
2024-08-09 15:25:07.299             commit;
2024-08-09 15:25:07.300             connect 'inet4://127.0.0.1/{act.db.db_path}';
2024-08-09 15:25:07.300
2024-08-09 15:25:07.300             select mon$remote_protocol as procotol_when_connect_from_isql
2024-08-09 15:25:07.300             from mon$attachments where mon$attachment_id = current_connection;
2024-08-09 15:25:07.300
2024-08-09 15:25:07.300             set term ^;
2024-08-09 15:25:07.300             execute block returns(protocol_when_connect_by_es_eds varchar(20) ) as
2024-08-09 15:25:07.300                 declare stt varchar(255) = 'select mon$remote_protocol from mon$attachments where mon$attachment_id = current_connection';
2024-08-09 15:25:07.300             begin
2024-08-09 15:25:07.300                 for
2024-08-09 15:25:07.300                     execute statement (stt)
2024-08-09 15:25:07.300                         on external 'inet4://127.0.0.1/{act.db.db_path}'
2024-08-09 15:25:07.300                         as user '{act.db.user}' password '{act.db.password}'
2024-08-09 15:25:07.300                     into protocol_when_connect_by_es_eds
2024-08-09 15:25:07.300                 do
2024-08-09 15:25:07.300                     suspend;
2024-08-09 15:25:07.300             end
2024-08-09 15:25:07.300             ^
2024-08-09 15:25:07.300             set term ;^
2024-08-09 15:25:07.301             commit;
2024-08-09 15:25:07.301
2024-08-09 15:25:07.301             -- since 27.10.2019; checked again 13.06.2024
2024-08-09 15:25:07.301             connect 'inet6://[::1]/{act.db.db_path}';
2024-08-09 15:25:07.301
2024-08-09 15:25:07.301             select mon$remote_protocol as procotol_when_connect_from_isql
2024-08-09 15:25:07.301             from mon$attachments where mon$attachment_id = current_connection;
2024-08-09 15:25:07.301
2024-08-09 15:25:07.301             set term ^;
2024-08-09 15:25:07.301             execute block returns(protocol_when_connect_by_es_eds varchar(20) ) as
2024-08-09 15:25:07.301                 declare stt varchar(255) = 'select mon$remote_protocol from mon$attachments where mon$attachment_id = current_connection';
2024-08-09 15:25:07.301             begin
2024-08-09 15:25:07.301                 for
2024-08-09 15:25:07.301                     execute statement (stt)
2024-08-09 15:25:07.301                         -- Failed before fix #8156 ("Can not specify concrete IPv6 address in ES/EDS connection string"):
2024-08-09 15:25:07.301                         on external 'inet6://[::1]/{act.db.db_path}'
2024-08-09 15:25:07.301                         as user '{act.db.user}' password '{act.db.password}'
2024-08-09 15:25:07.301                     into protocol_when_connect_by_es_eds
2024-08-09 15:25:07.301                 do
2024-08-09 15:25:07.301                     suspend;
2024-08-09 15:25:07.302             end
2024-08-09 15:25:07.302             ^
2024-08-09 15:25:07.302             set term ;^
2024-08-09 15:25:07.302             commit;
2024-08-09 15:25:07.302         """
2024-08-09 15:25:07.302
2024-08-09 15:25:07.302         expected_stdout = """
2024-08-09 15:25:07.302             PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv4
2024-08-09 15:25:07.302             PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv4
2024-08-09 15:25:07.302             PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv6
2024-08-09 15:25:07.302             PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv6
2024-08-09 15:25:07.302         """
2024-08-09 15:25:07.302
2024-08-09 15:25:07.302         act.expected_stdout = expected_stdout
2024-08-09 15:25:07.302 >       act.isql(switches=['-q', f'inet://{act.db.db_path}'], input=sql_chk, connect_db=False)
2024-08-09 15:25:07.302 E       firebird.qa.plugin.ExecutionError: ISQL execution failed
2024-08-09 15:25:07.302
2024-08-09 15:25:07.302 tests\bugs\core_5229_test.py:144: ExecutionError
2024-08-09 15:25:07.302 ---------------------------- Captured stdout setup ----------------------------
2024-08-09 15:25:07.302 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11060\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
2024-08-09 15:25:07.303 -------------------------- Captured ISQL stdout call --------------------------
2024-08-09 15:25:07.303 Database: inet://H:\QA\temp\qa2024.tmp\fbqa\test_11060\test.fdb, User: SYSDBA
2024-08-09 15:25:07.303 Database: 'inet4://127.0.0.1/H:\QA\temp\qa2024.tmp\fbqa\test_11060\test.fdb', User: SYSDBA
2024-08-09 15:25:07.303
2024-08-09 15:25:07.303 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv4
2024-08-09 15:25:07.303
2024-08-09 15:25:07.303
2024-08-09 15:25:07.303
2024-08-09 15:25:07.303 PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv4
2024-08-09 15:25:07.303
2024-08-09 15:25:07.303
2024-08-09 15:25:07.303 Database: 'inet6://[::1]/H:\QA\temp\qa2024.tmp\fbqa\test_11060\test.fdb', User: SYSDBA
2024-08-09 15:25:07.303
2024-08-09 15:25:07.303 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv6
2024-08-09 15:25:07.303
2024-08-09 15:25:07.303
2024-08-09 15:25:07.303
2024-08-09 15:25:07.303
2024-08-09 15:25:07.303 -------------------------- Captured ISQL stderr call --------------------------
2024-08-09 15:25:07.303 Statement failed, SQLSTATE = 42000
2024-08-09 15:25:07.303 External Data Source provider 'inet6://[' not found
2024-08-09 15:25:07.304 -At block line: 4, col: 13
2 #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.14 6638e P P 853 391 2025.06.26 14:52:48.230 2025.06.26 14:52:49.083 2025.06.26 14:17:08.476 2025.06.26 14:17:08.867
2 3.0.13.33809 2025.05.06 28ad0 P P 852 380 2025.05.14 08:17:25.863 2025.05.14 08:17:26.715 2025.05.14 07:41:12.005 2025.05.14 07:41:12.385
3 3.0.13.33808 2025.04.25 28426 P P 844 381 2025.05.06 13:28:17.310 2025.05.06 13:28:18.154 2025.05.06 12:53:54.207 2025.05.06 12:53:54.588
4 3.0.13.33803 2025.04.23 307b8 P P 854 384 2025.04.25 13:36:51.223 2025.04.25 13:36:52.077 2025.04.25 13:02:19.486 2025.04.25 13:02:19.870
5 3.0.13.33803 2025.03.25 ea22a P P 844 401 2025.04.20 08:08:10.933 2025.04.20 08:08:11.777 2025.04.20 07:11:53.939 2025.04.20 07:11:54.340
6 3.0.13.33803 2025.02.25 08ebd P P 883 406 2025.03.25 10:23:44.602 2025.03.25 10:23:45.485 2025.03.25 09:26:17.852 2025.03.25 09:26:18.258
7 3.0.13.33796 2025.01.29 0ab85 P P 866 372 2025.02.25 12:14:22.241 2025.02.25 12:14:23.107 2025.02.25 11:39:35.443 2025.02.25 11:39:35.815
8 3.0.13.33796 2025.01.14 99b3b P P 853 380 2025.01.24 11:18:57.472 2025.01.24 11:18:58.325 2025.01.24 10:44:19.029 2025.01.24 10:44:19.409
9 3.0.13.33795 2024.12.13 fbbd9 P P 866 377 2025.01.01 12:29:59.299 2025.01.01 12:30:00.165 2025.01.01 11:54:53.210 2025.01.01 11:54:53.587
10 3.0.13.33795 2024.11.24 b8847 P P 875 379 2024.12.11 12:27:42.965 2024.12.11 12:27:43.840 2024.12.11 11:52:49.807 2024.12.11 11:52:50.186
11 3.0.13.33794 2024.10.15 abe09 P P 864 383 2024.11.22 12:04:04.591 2024.11.22 12:04:05.455 2024.11.22 11:29:04.181 2024.11.22 11:29:04.564
12 3.0.13.33793 2024.10.14 f831a P P 854 381 2024.10.15 12:31:41.493 2024.10.15 12:31:42.347 2024.10.15 11:56:33.267 2024.10.15 11:56:33.648
13 3.0.13.33793 2024.10.04 82ccc P P 854 378 2024.10.12 12:30:41.646 2024.10.12 12:30:42.500 2024.10.12 11:55:50.436 2024.10.12 11:55:50.814
14 3.0.13.33792 2024.08.31 d8791 P P 893 375 2024.10.03 12:38:57.696 2024.10.03 12:38:58.589 2024.10.03 12:03:06.610 2024.10.03 12:03:06.985
15 3.0.13.33787 2024.08.23 8ee81 P P 904 457 2024.09.01 12:49:08.304 2024.09.01 12:49:09.208 2024.09.01 12:10:14.072 2024.09.01 12:10:14.529
16 3.0.13.33787 2024.08.09 df740 P P 958 478 2024.08.23 12:44:51.643 2024.08.23 12:44:52.601 2024.08.23 12:06:12.852 2024.08.23 12:06:13.330
17 3.0.12.33746 2024.07.15 11dd4 F F 1280 772 2024.08.09 12:05:06.224 2024.08.09 12:05:07.504 2024.08.09 11:26:48.775 2024.08.09 11:26:49.547
18 3.0.12.33746 2024.06.11 8a5eb F F 1107 635 2024.07.15 10:58:34.102 2024.07.15 10:58:35.209 2024.07.15 10:25:01.748 2024.07.15 10:25:02.383
19 3.0.12.33745 2024.05.21 301a7 S S 16 0 2024.05.25 07:56:21.944 2024.05.25 07:56:21.960 2024.05.25 07:25:26.098 2024.05.25 07:25:26.098
20 3.0.12.33745 2024.05.09 9cf37 S S 0 0 2024.05.21 07:56:41.870 2024.05.21 07:56:41.870 2024.05.21 07:25:36.278 2024.05.21 07:25:36.278
21 3.0.12.33744 2024.04.20 af6b2 S S 16 0 2024.05.11 07:53:10.401 2024.05.11 07:53:10.417 2024.05.11 07:22:53.654 2024.05.11 07:22:53.654
22 3.0.12.33740 2024.04.06 c6cdd S S 0 0 2024.04.21 02:07:26.032 2024.04.21 02:07:26.032 2024.04.21 01:37:31.682 2024.04.21 01:37:31.682
23 3.0.12.33726 2024.03.29 1fac6 S S 0 0 2024.04.05 07:03:09.214 2024.04.05 07:03:09.214 2024.04.05 06:33:46.127 2024.04.05 06:33:46.127
24 3.0.12.33726 2024.03.11 456ca S S -1 14 2024.03.29 12:44:06.533 2024.03.29 12:44:06.532 2024.03.29 12:16:03.471 2024.03.29 12:16:03.485

Elapsed time, ms. Chart for last 21 runs:

Last commits information (all timestamps in UTC):