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:06:28.055
2024-08-09 14:06:28.055 act = <firebird.qa.plugin.Action object at [hex]>
2024-08-09 14:06:28.055
2024-08-09 14:06:28.055     @pytest.mark.es_eds
2024-08-09 14:06:28.055     @pytest.mark.version('>=3.0.1')
2024-08-09 14:06:28.055     def test_1(act: Action):
2024-08-09 14:06:28.055
2024-08-09 14:06:28.055         if (res := check_ipv6_avail()) < 0:
2024-08-09 14:06:28.055             pytest.skip(f"IPv6 not avail, retcode: {res}")
2024-08-09 14:06:28.055
2024-08-09 14:06:28.056         sql_chk = f"""
2024-08-09 14:06:28.056             set list on;
2024-08-09 14:06:28.056             commit;
2024-08-09 14:06:28.056             connect 'inet4://127.0.0.1/{act.db.db_path}';
2024-08-09 14:06:28.056
2024-08-09 14:06:28.056             select mon$remote_protocol as procotol_when_connect_from_isql
2024-08-09 14:06:28.056             from mon$attachments where mon$attachment_id = current_connection;
2024-08-09 14:06:28.056
2024-08-09 14:06:28.056             set term ^;
2024-08-09 14:06:28.056             execute block returns(protocol_when_connect_by_es_eds varchar(20) ) as
2024-08-09 14:06:28.056                 declare stt varchar(255) = 'select mon$remote_protocol from mon$attachments where mon$attachment_id = current_connection';
2024-08-09 14:06:28.056             begin
2024-08-09 14:06:28.056                 for
2024-08-09 14:06:28.056                     execute statement (stt)
2024-08-09 14:06:28.056                         on external 'inet4://127.0.0.1/{act.db.db_path}'
2024-08-09 14:06:28.056                         as user '{act.db.user}' password '{act.db.password}'
2024-08-09 14:06:28.056                     into protocol_when_connect_by_es_eds
2024-08-09 14:06:28.056                 do
2024-08-09 14:06:28.057                     suspend;
2024-08-09 14:06:28.057             end
2024-08-09 14:06:28.057             ^
2024-08-09 14:06:28.057             set term ;^
2024-08-09 14:06:28.057             commit;
2024-08-09 14:06:28.057
2024-08-09 14:06:28.057             -- since 27.10.2019; checked again 13.06.2024
2024-08-09 14:06:28.057             connect 'inet6://[::1]/{act.db.db_path}';
2024-08-09 14:06:28.057
2024-08-09 14:06:28.057             select mon$remote_protocol as procotol_when_connect_from_isql
2024-08-09 14:06:28.057             from mon$attachments where mon$attachment_id = current_connection;
2024-08-09 14:06:28.057
2024-08-09 14:06:28.057             set term ^;
2024-08-09 14:06:28.057             execute block returns(protocol_when_connect_by_es_eds varchar(20) ) as
2024-08-09 14:06:28.057                 declare stt varchar(255) = 'select mon$remote_protocol from mon$attachments where mon$attachment_id = current_connection';
2024-08-09 14:06:28.057             begin
2024-08-09 14:06:28.057                 for
2024-08-09 14:06:28.057                     execute statement (stt)
2024-08-09 14:06:28.057                         -- Failed before fix #8156 ("Can not specify concrete IPv6 address in ES/EDS connection string"):
2024-08-09 14:06:28.057                         on external 'inet6://[::1]/{act.db.db_path}'
2024-08-09 14:06:28.058                         as user '{act.db.user}' password '{act.db.password}'
2024-08-09 14:06:28.058                     into protocol_when_connect_by_es_eds
2024-08-09 14:06:28.058                 do
2024-08-09 14:06:28.058                     suspend;
2024-08-09 14:06:28.058             end
2024-08-09 14:06:28.058             ^
2024-08-09 14:06:28.058             set term ;^
2024-08-09 14:06:28.058             commit;
2024-08-09 14:06:28.058         """
2024-08-09 14:06:28.058
2024-08-09 14:06:28.058         expected_stdout = """
2024-08-09 14:06:28.058             PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv4
2024-08-09 14:06:28.058             PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv4
2024-08-09 14:06:28.058             PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv6
2024-08-09 14:06:28.058             PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv6
2024-08-09 14:06:28.058         """
2024-08-09 14:06:28.058
2024-08-09 14:06:28.058         act.expected_stdout = expected_stdout
2024-08-09 14:06:28.058 >       act.isql(switches=['-q', f'inet://{act.db.db_path}'], input=sql_chk, connect_db=False)
2024-08-09 14:06:28.058 E       firebird.qa.plugin.ExecutionError: ISQL execution failed
2024-08-09 14:06:28.059
2024-08-09 14:06:28.059 tests\bugs\core_5229_test.py:144: ExecutionError
2024-08-09 14:06:28.059 ---------------------------- Captured stdout setup ----------------------------
2024-08-09 14:06:28.059 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11052\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
2024-08-09 14:06:28.059 -------------------------- Captured ISQL stdout call --------------------------
2024-08-09 14:06:28.059 Database: inet://H:\QA\temp\qa2024.tmp\fbqa\test_11052\test.fdb, User: SYSDBA
2024-08-09 14:06:28.059 Database: 'inet4://127.0.0.1/H:\QA\temp\qa2024.tmp\fbqa\test_11052\test.fdb', User: SYSDBA
2024-08-09 14:06:28.059
2024-08-09 14:06:28.059 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv4
2024-08-09 14:06:28.059
2024-08-09 14:06:28.059
2024-08-09 14:06:28.059
2024-08-09 14:06:28.059 PROTOCOL_WHEN_CONNECT_BY_ES_EDS TCPv4
2024-08-09 14:06:28.059
2024-08-09 14:06:28.059
2024-08-09 14:06:28.059 Database: 'inet6://[::1]/H:\QA\temp\qa2024.tmp\fbqa\test_11052\test.fdb', User: SYSDBA
2024-08-09 14:06:28.059
2024-08-09 14:06:28.059 PROCOTOL_WHEN_CONNECT_FROM_ISQL TCPv6
2024-08-09 14:06:28.059
2024-08-09 14:06:28.060
2024-08-09 14:06:28.060
2024-08-09 14:06:28.060
2024-08-09 14:06:28.060 -------------------------- Captured ISQL stderr call --------------------------
2024-08-09 14:06:28.060 Statement failed, SQLSTATE = 42000
2024-08-09 14:06:28.060 External Data Source provider 'inet6://[' not found
2024-08-09 14:06:28.060 -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 878 479 2025.06.30 12:54:59.190 2025.06.30 12:55:00.068 2025.06.30 11:58:49.950 2025.06.30 11:58:50.429
2 4.0.6.3184 2025.02.24 9388c P P 902 485 2025.02.25 10:36:43.318 2025.02.25 10:36:44.220 2025.02.25 09:23:40.701 2025.02.25 09:23:41.186
3 4.0.6.3183 2025.02.17 e4762 P P 872 474 2025.02.24 11:08:46.649 2025.02.24 11:08:47.521 2025.02.24 10:13:56.476 2025.02.24 10:13:56.950
4 4.0.6.3169 2024.12.13 42cc1 P P 906 444 2025.02.14 07:57:02.034 2025.02.14 07:57:02.940 2025.02.14 07:02:11.022 2025.02.14 07:02:11.466
5 4.0.6.3169 2024.12.08 50eb6 P P 891 455 2024.12.11 10:53:24.010 2024.12.11 10:53:24.901 2024.12.11 09:59:00.702 2024.12.11 09:59:01.157
6 4.0.6.3168 2024.12.07 98d69 P P 1270 449 2024.12.08 03:36:24.444 2024.12.08 03:36:25.714 2024.12.08 02:40:32.712 2024.12.08 02:40:33.161
7 4.0.6.3168 2024.12.05 cee43 P P 874 468 2024.12.06 03:39:36.789 2024.12.06 03:39:37.663 2024.12.06 02:45:14.239 2024.12.06 02:45:14.707
8 4.0.6.3168 2024.11.28 48149 P P 877 468 2024.12.03 10:33:23.900 2024.12.03 10:33:24.777 2024.12.03 09:39:42.251 2024.12.03 09:39:42.719
9 4.0.6.3163 2024.10.30 832db P P 928 452 2024.11.28 10:31:46.387 2024.11.28 10:31:47.315 2024.11.28 09:38:33.677 2024.11.28 09:38:34.129
10 4.0.6.3163 2024.10.16 2bb10 P P 887 460 2024.10.30 10:41:00.907 2024.10.30 10:41:01.794 2024.10.30 09:47:17.310 2024.10.30 09:47:17.770
11 4.0.6.3147 2024.09.10 a4d11 P P 905 454 2024.10.16 03:48:33.931 2024.10.16 03:48:34.836 2024.10.16 02:35:56.949 2024.10.16 02:35:57.403
12 4.0.6.3147 2024.08.31 4655b P P 976 455 2024.09.10 10:45:05.555 2024.09.10 10:45:06.531 2024.09.10 09:48:36.888 2024.09.10 09:48:37.343
13 4.0.6.3140 2024.08.16 1dd8b P P 951 509 2024.09.01 11:08:01.974 2024.09.01 11:08:02.925 2024.09.01 09:53:05.725 2024.09.01 09:53:06.234
14 4.0.6.3140 2024.08.09 34747 P P 1056 483 2024.08.16 10:47:54.601 2024.08.16 10:47:55.657 2024.08.16 09:51:53.706 2024.08.16 09:51:54.189
15 4.0.5.3110 2024.08.06 f851c F F 982 482 2024.08.09 10:27:18.539 2024.08.09 10:27:19.521 2024.08.09 09:31:37.134 2024.08.09 09:31:37.616
16 4.0.5.3110 2024.07.30 c6527 F F 1134 805 2024.08.06 06:05:40.254 2024.08.06 06:05:41.388 2024.08.06 05:14:58.561 2024.08.06 05:14:59.366
17 4.0.5.3109 2024.06.11 6addf F F 1123 708 2024.07.30 09:24:00.168 2024.07.30 09:24:01.291 2024.07.30 08:35:04.556 2024.07.30 08:35:05.264
18 4.0.5.3097 2024.05.09 27fa6 S S 0 0 2024.06.11 05:43:02.341 2024.06.11 05:43:02.341 2024.06.11 04:59:08.503 2024.06.11 04:59:08.503
19 4.0.5.3091 2024.04.29 bd0aa S S 0 0 2024.05.09 18:22:29.943 2024.05.09 18:22:29.943 2024.05.09 17:39:01.529 2024.05.09 17:39:01.529
20 4.0.5.3089 2024.04.20 9eb9b S S 0 0 2024.04.29 06:31:11.072 2024.04.29 06:31:11.072 2024.04.29 05:47:58.689 2024.04.29 05:47:58.689
21 4.0.5.3083 2024.04.06 300f9 S S 0 0 2024.04.20 06:54:23.420 2024.04.20 06:54:23.420 2024.04.20 06:10:56.086 2024.04.20 06:10:56.086
22 4.0.5.3052 2024.03.16 0f422 S S 0 0 2024.04.05 03:21:37.278 2024.04.05 03:21:37.278 2024.04.05 02:39:42.188 2024.04.05 02:39:42.188
23 4.0.5.3052 2024.03.16 ce273 S S -1 -1 2024.03.29 14:48:21.416 2024.03.29 14:48:21.415 2024.03.29 14:07:46.833 2024.03.29 14:07:46.832
24 4.0.5.3052 2024.02.12 cd058 S S -1 -1 2024.03.29 16:16:45.439 2024.03.29 16:16:45.438 2024.03.29 15:36:12.920 2024.03.29 15:36:12.919
25 4.0.5.3052 2024.02.07 be290 S S -1 -1 2024.03.29 18:28:14.969 2024.03.29 18:28:14.968 2024.03.29 17:47:42.036 2024.03.29 17:47:42.035
26 4.0.5.3052 2024.02.07 6409b S S -1 -1 2024.03.29 20:12:26.714 2024.03.29 20:12:26.713 2024.03.29 19:31:54.834 2024.03.29 19:31:54.833
27 4.0.5.3052 2024.02.02 bbc3f S S -1 -1 2024.03.29 22:21:29.046 2024.03.29 22:21:29.045 2024.03.29 21:40:57.878 2024.03.29 21:40:57.877
28 4.0.5.3052 2024.01.26 48b7c S S -1 -1 2024.03.29 23:48:41.534 2024.03.29 23:48:41.533 2024.03.29 23:08:07.308 2024.03.29 23:08:07.307
29 4.0.5.3052 2024.01.26 9a7b3 S S -1 -1 2024.03.30 06:49:40.792 2024.03.30 06:49:40.791 2024.03.30 06:09:06.989 2024.03.30 06:09:06.988
30 4.0.5.3049 2024.01.25 f6b9d S S -1 -1 2024.03.30 08:57:02.256 2024.03.30 08:57:02.255 2024.03.30 08:16:48.313 2024.03.30 08:16:48.312
31 4.0.5.3049 2024.01.08 b67ce S S -1 -1 2024.03.30 10:40:01.515 2024.03.30 10:40:01.514 2024.03.30 09:53:48.684 2024.03.30 09:53:48.683
32 4.0.5.3049 2024.01.08 97577 S S -1 -1 2024.03.30 15:45:16.182 2024.03.30 15:45:16.181 2024.03.30 14:59:07.431 2024.03.30 14:59:07.430
33 4.0.5.3049 2024.01.05 2d8b0 S S -1 -1 2024.03.30 19:02:58.655 2024.03.30 19:02:58.654 2024.03.30 18:17:05.283 2024.03.30 18:17:05.282
34 4.0.5.3049 2024.01.04 431e5 S S -1 -1 2024.03.30 20:46:01.849 2024.03.30 20:46:01.848 2024.03.30 20:05:54.609 2024.03.30 20:05:54.608
35 4.0.5.3049 2024.01.04 e33b4 S S 15 -1 2024.03.30 22:57:54.236 2024.03.30 22:57:54.251 2024.03.30 22:17:38.820 2024.03.30 22:17:38.819
36 4.0.5.3049 2024.01.04 207ef S S -1 -1 2024.03.31 00:41:22.601 2024.03.31 00:41:22.600 2024.03.31 00:01:03.721 2024.03.31 00:01:03.720
37 4.0.5.3034 2023.12.12 c05ff S S -1 -1 2024.03.31 06:33:57.591 2024.03.31 06:33:57.590 2024.03.31 05:53:39.858 2024.03.31 05:53:39.857
38 4.0.5.3034 2023.12.12 3a40e S S -1 -1 2024.03.31 15:08:41.047 2024.03.31 15:08:41.046 2024.03.31 14:28:20.674 2024.03.31 14:28:20.673
39 4.0.5.3034 2023.12.02 5934b S S -1 -1 2024.03.31 09:41:43.844 2024.03.31 09:41:43.843 2024.03.31 09:01:26.184 2024.03.31 09:01:26.183
40 4.0.5.3034 2023.12.02 7ea5a S S -1 -1 2024.03.31 17:33:00.931 2024.03.31 17:33:00.930 2024.03.31 16:52:39.561 2024.03.31 16:52:39.560
41 4.0.5.3034 2023.11.30 4fbc9 S S -1 -1 2024.03.31 19:33:55.329 2024.03.31 19:33:55.328 2024.03.31 18:53:32.754 2024.03.31 18:53:32.753

Elapsed time, ms. Chart for last 18 runs:

Last commits information (all timestamps in UTC):