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
Network / firewall ?

failed on teardown with "firebird.driver.types.DatabaseError: Unable to complete network request to host "localhost".
-Failed to establish a connection."

LOG DETAILS:

2025-02-25 13:12:01.000
2025-02-25 13:12:01.000 act = <firebird.qa.plugin.Action object at [hex]>
2025-02-25 13:12:01.000
2025-02-25 13:12:01.000     @pytest.mark.version('>=3.0,<6')
2025-02-25 13:12:01.000     def test_1(act: Action):
2025-02-25 13:12:01.000         script = f"""
2025-02-25 13:12:01.000         create database '{act.db.dsn}' user '{act.db.user}'
2025-02-25 13:12:01.000           password '{act.db.password}'
2025-02-25 13:12:01.000           FILE '{act.db.db_path.with_name('TMP_CREATE_DB_10.F00')}' STARTING AT PAGE 301
2025-02-25 13:12:01.000           FILE '{act.db.db_path.with_name('TMP_CREATE_DB_10.F01')}' STARTING AT PAGE 601
2025-02-25 13:12:01.000           FILE '{act.db.db_path.with_name('TMP_CREATE_DB_10.F02')}' STARTING AT PAGE 1001
2025-02-25 13:12:01.000         ;
2025-02-25 13:12:01.000         set list on ;
2025-02-25 13:12:01.000         select
2025-02-25 13:12:01.000             cast(rdb$file_name as varchar(100)) db_file
2025-02-25 13:12:01.000             ,rdb$file_sequence
2025-02-25 13:12:01.000             ,rdb$file_start
2025-02-25 13:12:01.001             ,rdb$file_length
2025-02-25 13:12:01.001         from rdb$files ;
2025-02-25 13:12:01.001         """
2025-02-25 13:12:01.001         act.expected_stdout = expected_stdout
2025-02-25 13:12:01.001         act.isql(switches = ['-q'], input=script, connect_db=False, combine_output = True)
2025-02-25 13:12:01.001 >       assert act.clean_stdout == act.clean_expected_stdout
2025-02-25 13:12:01.001 E       assert
2025-02-25 13:12:01.001 E         + Statement	failed,	SQLSTATE	=	08006
2025-02-25 13:12:01.001 E         + Unable	to	complete	network	request	to	host	"localhost".
2025-02-25 13:12:01.001 E         + -Failed	to	establish	a	connection.
2025-02-25 13:12:01.001 E         - TMP_CREATE_DB_10.F00
2025-02-25 13:12:01.001 E         - RDB$FILE_SEQUENCE	1
2025-02-25 13:12:01.001 E         - RDB$FILE_START	301
2025-02-25 13:12:01.001 E         - RDB$FILE_LENGTH	300
2025-02-25 13:12:01.001 E         - TMP_CREATE_DB_10.F01
2025-02-25 13:12:01.001 E         - RDB$FILE_SEQUENCE	2
2025-02-25 13:12:01.001 E         - RDB$FILE_START	601
2025-02-25 13:12:01.001 E         - RDB$FILE_LENGTH	400
2025-02-25 13:12:01.001 E         - TMP_CREATE_DB_10.F02
2025-02-25 13:12:01.001 E         - RDB$FILE_SEQUENCE	3
2025-02-25 13:12:01.002 E         - RDB$FILE_START	1001
2025-02-25 13:12:01.002 E         - RDB$FILE_LENGTH	0
2025-02-25 13:12:01.002
2025-02-25 13:12:01.002 tests\functional\database\create\test_10.py:55: AssertionError
3 #text
request = <SubRequest 'db' for <Function test_1>>
db_path = WindowsPath('H:/QA/temp/qa2024.tmp/fbqa/test_11745')
db_cache = <firebird.qa.plugin.DbCache pytest object at [hex]>

    @pytest.fixture
    def database_fixture(request: pytest.FixtureRequest, db_path, db_cache) -> Database:
        db = Database(db_path, filename, user, password, charset, debug=str(request.module),
                      config_name=config_name, utf8filename=utf8filename)
        if not do_not_create:
            if from_backup is None and copy_of is None:
                db.create(page_size, sql_dialect, db_cache)
            elif from_backup is not None:
                db.restore(from_backup)
            elif copy_of is not None:
                db.copy(copy_of)
            if async_write:
                db.set_async_write()
            if init: # Do not check for None, we want to skip empty scripts as well
                try:
                    db.init(init)
                except Error as exc:
                    if hasattr(exc, 'stderr'):
                        request.node.user_properties.append(("dbinit-stderr", exc.stderr))
                    raise
        yield db
        if not do_not_drop:
>           db.drop()

src\firebird\qa\plugin.py:987: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

server = 'qa_rundaily_hq40'

    def connect_server(server: str, *, user: str=None, password: str=None,
                       crypt_callback: iCryptKeyCallbackImpl=None,
                       expected_db: str=None, role: str=None, encoding: str=None,
                       encoding_errors: str=None) -> Server:
        """Establishes a connection to server's service manager.
    
        Arguments:
            server: Server host machine or Server configuration name.
            user: User name.
            password: User password.
            crypt_callback: Callback that provides encryption key.
            expected_db: Database that would be accessed (for using services with non-default
                         security database)
            role: SQL role used for connection.
            encoding: Encoding for string values passed in parameter buffer. Default is
               `.ServerConfig.encoding`.
            encoding_errors: Error handler used for encoding errors. Default is
               `.ServerConfig.encoding_errors`.
    
        Hooks:
            Event `.ServerHook.ATTACHED`: Executed before `Service` instance is
            returned. Hook must have signature::
    
                hook_func(server: Server) -> None
    
            Any value returned by hook is ignored.
        """
        srv_config = driver_config.get_server(server)
        if srv_config is None:
            srv_config = driver_config.server_defaults
            host = server or None
            port = None
        else:
            host = srv_config.host.value
            port = srv_config.port.value
        if host is None:
            host = 'service_mgr'
        if not host.endswith('service_mgr'):
            if host and not host.endswith(':'):
                if port:
                    host += f"/{port}"
                host += ':'
            host += 'service_mgr'
        if user is None:
            user = srv_config.user.value
        if password is None:
            password = srv_config.password.value
        spb = SPB_ATTACH(user=user, password=password, config=srv_config.config.value,
                         trusted_auth=srv_config.trusted_auth.value,
                         auth_plugin_list=srv_config.auth_plugin_list.value,
                         expected_db=expected_db, role=role)
        spb_buf = spb.get_buffer()
        with a.get_api().master.get_dispatcher() as provider:
            if crypt_callback is not None:
                provider.set_dbcrypt_callback(crypt_callback)
>           svc = provider.attach_service_manager(host, spb_buf)

C:\Python3x\Lib\site-packages\firebird\driver\core.py:5596: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <firebird.driver.interfaces.iProvider pytest object at [hex]>
service = 'localhost/33337:service_mgr'
spb = b'\x02\x02\x1c\x06SYSDBA\x1d\tmasterkey'

    def attach_service_manager(self, service: str, spb: bytes) -> iService:
        "Replaces `isc_service_attach()`"
        result = self.vtable.attachServiceManager(self, self.status, service.encode(), len(spb), spb)
>       self._check()

C:\Python3x\Lib\site-packages\firebird\driver\interfaces.py:1305: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

self = <firebird.driver.interfaces.iProvider pytest object at [hex]>

    def _check(self) -> None:
        state = self.status.get_state()
        if StateFlag.ERRORS in state:
>           raise self.__report(DatabaseError, self.status.get_errors())
E           firebird.driver.types.DatabaseError: Unable to complete network request to host "localhost".
E           -Failed to establish a connection.

C:\Python3x\Lib\site-packages\firebird\driver\interfaces.py:113: DatabaseError
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 437 314 2025.06.30 13:19:12.153 2025.06.30 13:19:12.590 2025.06.30 12:19:54.616 2025.06.30 12:19:54.930
2 4.0.6.3184 2025.02.24 9388c P E 430 4239 2025.02.25 11:01:10.571 2025.02.25 11:01:11.001 2025.02.25 09:47:57.973 2025.02.25 09:48:02.212
3 4.0.6.3183 2025.02.17 e4762 P P 430 331 2025.02.24 11:33:13.765 2025.02.24 11:33:14.195 2025.02.24 10:33:43.432 2025.02.24 10:33:43.763
4 4.0.6.3169 2024.12.13 42cc1 P P 441 333 2025.02.14 08:20:57.881 2025.02.14 08:20:58.322 2025.02.14 07:21:26.854 2025.02.14 07:21:27.187
5 4.0.6.3169 2024.12.08 50eb6 P P 438 311 2024.12.11 11:17:30.995 2024.12.11 11:17:31.433 2024.12.11 10:18:19.950 2024.12.11 10:18:20.261
6 4.0.6.3168 2024.12.07 98d69 P P 459 334 2024.12.08 04:01:05.785 2024.12.08 04:01:06.244 2024.12.08 03:00:03.499 2024.12.08 03:00:03.833
7 4.0.6.3168 2024.12.05 cee43 P P 504 341 2024.12.06 04:04:24.265 2024.12.06 04:04:24.769 2024.12.06 03:04:37.354 2024.12.06 03:04:37.695
8 4.0.6.3168 2024.11.28 48149 P P 434 326 2024.12.03 10:57:30.491 2024.12.03 10:57:30.925 2024.12.03 09:59:01.179 2024.12.03 09:59:01.505
9 4.0.6.3163 2024.10.30 832db P P 436 335 2024.11.28 10:56:12.735 2024.11.28 10:56:13.171 2024.11.28 09:57:52.703 2024.11.28 09:57:53.038
10 4.0.6.3163 2024.10.16 2bb10 P P 439 325 2024.10.30 11:05:11.958 2024.10.30 11:05:12.397 2024.10.30 10:06:46.079 2024.10.30 10:06:46.404
11 4.0.6.3147 2024.09.10 a4d11 P E 443 4427 2024.10.16 04:12:45.400 2024.10.16 04:12:45.843 2024.10.16 02:59:55.250 2024.10.16 02:59:59.677
12 4.0.6.3147 2024.08.31 4655b P P 451 322 2024.09.10 11:10:48.387 2024.09.10 11:10:48.838 2024.09.10 10:08:06.382 2024.09.10 10:08:06.704
13 4.0.6.3140 2024.08.16 1dd8b P E 502 4445 2024.09.01 11:33:08.340 2024.09.01 11:33:08.842 2024.09.01 10:17:34.975 2024.09.01 10:17:39.420
14 4.0.6.3140 2024.08.09 34747 P P 503 362 2024.08.16 11:13:22.093 2024.08.16 11:13:22.596 2024.08.16 10:11:07.240 2024.08.16 10:11:07.602
15 4.0.5.3110 2024.08.06 f851c P P 504 364 2024.08.09 10:52:10.134 2024.08.09 10:52:10.638 2024.08.09 09:50:38.155 2024.08.09 09:50:38.519
16 4.0.5.3110 2024.07.30 c6527 P P 503 363 2024.08.06 06:28:37.236 2024.08.06 06:28:37.739 2024.08.06 05:32:44.837 2024.08.06 05:32:45.200
17 4.0.5.3109 2024.06.11 6addf P P 554 366 2024.07.30 09:46:16.126 2024.07.30 09:46:16.680 2024.07.30 08:52:25.297 2024.07.30 08:52:25.663
18 4.0.5.3097 2024.05.09 27fa6 P P 484 282 2024.06.11 06:03:53.275 2024.06.11 06:03:53.759 2024.06.11 05:14:09.070 2024.06.11 05:14:09.352
19 4.0.5.3091 2024.04.29 bd0aa F F 438 281 2024.05.09 18:42:53.653 2024.05.09 18:42:54.091 2024.05.09 17:53:40.624 2024.05.09 17:53:40.905
20 4.0.5.3089 2024.04.20 9eb9b P P 422 281 2024.04.29 06:51:22.517 2024.04.29 06:51:22.939 2024.04.29 06:02:29.647 2024.04.29 06:02:29.928
21 4.0.5.3083 2024.04.06 300f9 P P 453 282 2024.04.20 07:14:43.412 2024.04.20 07:14:43.865 2024.04.20 06:25:28.932 2024.04.20 06:25:29.214
22 4.0.5.3052 2024.03.16 0f422 P P 438 282 2024.04.05 03:40:57.498 2024.04.05 03:40:57.936 2024.04.05 02:53:31.903 2024.04.05 02:53:32.185
23 4.0.5.3052 2024.03.16 ce273 P P 437 280 2024.03.29 15:06:29.485 2024.03.29 15:06:29.922 2024.03.29 14:21:33.750 2024.03.29 14:21:34.030
24 4.0.5.3052 2024.02.12 cd058 P P 421 280 2024.03.29 16:34:54.181 2024.03.29 16:34:54.602 2024.03.29 15:49:59.805 2024.03.29 15:50:00.085
25 4.0.5.3052 2024.02.07 be290 P P 421 265 2024.03.29 18:46:25.992 2024.03.29 18:46:26.413 2024.03.29 18:01:27.993 2024.03.29 18:01:28.258
26 4.0.5.3052 2024.02.07 6409b P P 436 264 2024.03.29 20:30:35.864 2024.03.29 20:30:36.300 2024.03.29 19:45:41.172 2024.03.29 19:45:41.436
27 4.0.5.3052 2024.02.02 bbc3f P P 421 264 2024.03.29 22:39:39.552 2024.03.29 22:39:39.973 2024.03.29 21:54:41.986 2024.03.29 21:54:42.250
28 4.0.5.3052 2024.01.26 48b7c P P 420 280 2024.03.30 00:06:55.142 2024.03.30 00:06:55.562 2024.03.29 23:21:53.428 2024.03.29 23:21:53.708
29 4.0.5.3052 2024.01.26 9a7b3 P P 437 265 2024.03.30 07:07:51.073 2024.03.30 07:07:51.510 2024.03.30 06:22:53.971 2024.03.30 06:22:54.236
30 4.0.5.3049 2024.01.25 f6b9d P P 374 234 2024.03.30 09:14:58.004 2024.03.30 09:14:58.378 2024.03.30 08:30:23.607 2024.03.30 08:30:23.841
31 4.0.5.3049 2024.01.08 b67ce P P 483 264 2024.03.30 11:01:58.032 2024.03.30 11:01:58.515 2024.03.30 10:08:41.024 2024.03.30 10:08:41.288
32 4.0.5.3049 2024.01.08 97577 P P 467 265 2024.03.30 16:06:53.071 2024.03.30 16:06:53.538 2024.03.30 15:13:55.559 2024.03.30 15:13:55.824
33 4.0.5.3049 2024.01.05 2d8b0 P P 468 265 2024.03.30 19:24:42.253 2024.03.30 19:24:42.721 2024.03.30 18:31:56.563 2024.03.30 18:31:56.828
34 4.0.5.3049 2024.01.04 431e5 P P 374 233 2024.03.30 21:03:53.113 2024.03.30 21:03:53.487 2024.03.30 20:19:27.612 2024.03.30 20:19:27.845
35 4.0.5.3049 2024.01.04 e33b4 P P 358 233 2024.03.30 23:15:46.036 2024.03.30 23:15:46.394 2024.03.30 22:31:13.331 2024.03.30 22:31:13.564
36 4.0.5.3049 2024.01.04 207ef P P 358 233 2024.03.31 00:59:16.203 2024.03.31 00:59:16.561 2024.03.31 00:14:40.906 2024.03.31 00:14:41.139
37 4.0.5.3034 2023.12.12 c05ff P P 359 233 2024.03.31 06:51:52.485 2024.03.31 06:51:52.844 2024.03.31 06:07:14.520 2024.03.31 06:07:14.753
38 4.0.5.3034 2023.12.12 3a40e P P 343 233 2024.03.31 15:26:35.934 2024.03.31 15:26:36.277 2024.03.31 14:41:57.122 2024.03.31 14:41:57.355
39 4.0.5.3034 2023.12.02 5934b P P 359 234 2024.03.31 09:59:37.448 2024.03.31 09:59:37.807 2024.03.31 09:15:00.402 2024.03.31 09:15:00.636
40 4.0.5.3034 2023.12.02 7ea5a P P 374 233 2024.03.31 17:50:57.298 2024.03.31 17:50:57.672 2024.03.31 17:06:17.835 2024.03.31 17:06:18.068
41 4.0.5.3034 2023.11.30 4fbc9 P P 374 233 2024.03.31 19:51:51.132 2024.03.31 19:51:51.506 2024.03.31 19:07:08.967 2024.03.31 19:07:09.200

Elapsed time, ms. Chart for last 41 runs:

Last commits information (all timestamps in UTC):