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 setup with "firebird.driver.types.DatabaseError: Unable to complete network request to host "localhost".
-Failed to establish a connection."
3 #text
request = <SubRequest 'act' for <Function test_1>>

    @pytest.fixture
    def isql_act_fixture(request: pytest.FixtureRequest) -> Action:
>       db: Database = request.getfixturevalue(db_fixture_name)

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

request = <SubRequest 'db' for <Function test_1>>
db_path = WindowsPath('H:/QA/temp/qa2024.tmp/fbqa/test_11784')
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)

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

database = 'pytest'

    def create_database(database: str, *, user: str=None, password: str=None, role: str=None,
                        no_gc: bool=None, no_db_triggers: bool=None, dbkey_scope: DBKeyScope=None,
                        crypt_callback: iCryptKeyCallbackImpl=None, charset: str=None,
                        overwrite: bool=False, auth_plugin_list=None,
                        session_time_zone: str=None) -> Connection:
        """Creates new database.
    
        Arguments:
            database: DSN or Database configuration name.
            user: User name.
            password: User password.
            role: User role.
            no_gc: Do not perform garbage collection for this connection.
            no_db_triggers: Do not execute database triggers for this connection.
            dbkey_scope: DBKEY scope override for connection.
            crypt_callback: Callback that provides encryption key for the database.
            charset: Character set for connection.
            overwrite: Overwite the existing database.
            auth_plugin_list: List of authentication plugins override
            session_time_zone: Session time zone [Firebird 4]
    
        Hooks:
            Event `.ConnectionHook.ATTACHED`: Executed before `Connection` instance is
            returned. Hook must have signature::
    
                hook_func(connection: Connection) -> None
    
            Any value returned by hook is ignored.
        """
        db_config = driver_config.get_database(database)
        if db_config is None:
            db_config = driver_config.db_defaults
            db_config.database.value = database
            if db_config.server.value is None:
                srv_config = driver_config.server_defaults
            else:
                srv_config = driver_config.get_server(db_config.server.value)
                if srv_config is None:
                    raise ValueError(f"Configuration for server '{db_config.server.value}' not found")
        else:
            if db_config.server.value is None:
                srv_config = driver_config.server_defaults
            else:
                srv_config = driver_config.get_server(db_config.server.value)
                if srv_config is None:
                    raise ValueError(f"Configuration for server '{db_config.server.value}' not found")
        if user is None:
            user = db_config.user.value
            if user is None:
                user = srv_config.user.value
        if password is None:
            password = db_config.password.value
            if password is None:
                password = srv_config.password.value
        if role is None:
            role = db_config.role.value
        if charset is None:
            charset = db_config.charset.value
        if charset:
            charset = charset.upper()
        if auth_plugin_list is None:
            auth_plugin_list = db_config.auth_plugin_list.value
        if session_time_zone is None:
            session_time_zone = db_config.session_time_zone.value
        dsn = _connect_helper(db_config.dsn.value, srv_config.host.value, srv_config.port.value,
                              db_config.database.value, db_config.protocol.value)
        dpb = DPB(user=user, password=password, role=role, trusted_auth=db_config.trusted_auth.value,
                  sql_dialect=db_config.db_sql_dialect.value, timeout=db_config.timeout.value,
                  charset=charset, cache_size=db_config.cache_size.value,
                  no_linger=db_config.no_linger.value, utf8filename=db_config.utf8filename.value,
                  no_gc=no_gc, no_db_triggers=no_db_triggers, dbkey_scope=dbkey_scope,
                  dummy_packet_interval=db_config.dummy_packet_interval.value,
                  config=db_config.config.value, auth_plugin_list=auth_plugin_list,
                  session_time_zone=session_time_zone, set_bind=db_config.set_bind.value,
                  decfloat_round=db_config.decfloat_round.value,
                  decfloat_traps=db_config.decfloat_traps.value,
                  overwrite=overwrite, db_cache_size=db_config.db_cache_size.value,
                  forced_writes=db_config.forced_writes.value, page_size=db_config.page_size.value,
                  reserve_space=db_config.reserve_space.value, sweep_interval=db_config.sweep_interval.value,
                  db_sql_dialect=db_config.db_sql_dialect.value, db_charset=db_config.db_charset.value)
>       return __make_connection(True, dsn, db_config.utf8filename.value,
                                 dpb.get_buffer(for_create=True), db_config.sql_dialect.value,
                                 charset, crypt_callback)

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

create = True
dsn = 'localhost/33337:H:\\QA\\temp\\qa2024.tmp\\fbqa\\test_11784\\test.fdb'
utf8filename = False
dpb = b'\x01\x1c\x06SYSDBA\x1d\tmasterkey0\x04NONED\x04NONED\x04NONE'
sql_dialect = 3, charset = 'NONE', crypt_callback = None

    def __make_connection(create: bool, dsn: str, utf8filename: bool, dpb: bytes,
                          sql_dialect: int, charset: str,
                          crypt_callback: iCryptKeyCallbackImpl) -> Connection:
        with a.get_api().master.get_dispatcher() as provider:
            if crypt_callback is not None:
                provider.set_dbcrypt_callback(crypt_callback)
            if create:
>               att = provider.create_database(dsn, dpb, 'utf-8' if utf8filename else FS_ENCODING)

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

self = <firebird.driver.interfaces.iProvider pytest object at [hex]>
filename = 'localhost/33337:H:\\QA\\temp\\qa2024.tmp\\fbqa\\test_11784\\test.fdb'
dpb = b'\x01\x1c\x06SYSDBA\x1d\tmasterkey0\x04NONED\x04NONED\x04NONE'
encoding = 'utf-8'

    def create_database(self, filename: str, dpb: bytes, encoding: str = 'ascii') -> iAttachment:
        "Replaces `isc_create_database()`"
        result = self.vtable.createDatabase(self, self.status, filename.encode(encoding), len(dpb), dpb)
>       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 5.0.3.1674 2025.06.27 3ee5c P P 801 554 2025.06.30 11:08:22.493 2025.06.30 11:08:23.294 2025.06.30 10:06:37.327 2025.06.30 10:06:37.881
2 5.0.3.1657 2025.06.26 dcb8a P P 862 546 2025.06.27 11:09:46.800 2025.06.27 11:09:47.662 2025.06.27 10:08:12.918 2025.06.27 10:08:13.464
3 5.0.3.1657 2025.06.20 8b4d2 P P 798 548 2025.06.26 11:24:12.592 2025.06.26 11:24:13.390 2025.06.26 10:22:29.446 2025.06.26 10:22:29.994
4 5.0.3.1657 2025.06.19 4bd4c P P 883 550 2025.06.20 05:28:29.118 2025.06.20 05:28:30.001 2025.06.20 04:26:48.110 2025.06.20 04:26:48.660
5 5.0.3.1657 2025.06.11 dae6f P P 825 544 2025.06.19 10:59:54.166 2025.06.19 10:59:54.991 2025.06.19 09:58:12.124 2025.06.19 09:58:12.668
6 5.0.3.1657 2025.06.10 dbc92 P P 975 556 2025.06.11 08:46:14.536 2025.06.11 08:46:15.511 2025.06.11 07:44:08.904 2025.06.11 07:44:09.460
7 5.0.3.1656 2025.06.05 00512 P P 844 549 2025.06.10 10:01:34.084 2025.06.10 10:01:34.928 2025.06.10 08:59:14.033 2025.06.10 08:59:14.582
8 5.0.3.1656 2025.05.20 c4b11 P P 827 531 2025.06.03 09:48:25.641 2025.06.03 09:48:26.468 2025.06.03 08:47:16.939 2025.06.03 08:47:17.470
9 5.0.3.1652 2025.05.13 f51c6 P P 808 543 2025.05.21 06:29:23.923 2025.05.21 06:29:24.731 2025.05.21 05:28:32.352 2025.05.21 05:28:32.895
10 5.0.3.1651 2025.05.08 ee9d2 P E 848 2391 2025.05.13 06:42:04.290 2025.05.13 06:42:05.138 2025.05.13 05:24:54.269 2025.05.13 05:24:56.660
11 5.0.3.1651 2025.05.04 3d914 P E 861 2433 2025.05.09 04:31:07.138 2025.05.09 04:31:07.999 2025.05.09 03:13:52.422 2025.05.09 03:13:54.855
12 5.0.3.1651 2025.04.30 141ef P E 830 2399 2025.05.02 04:38:43.182 2025.05.02 04:38:44.012 2025.05.02 03:21:45.314 2025.05.02 03:21:47.713
13 5.0.3.1650 2025.04.30 6253f P E 802 2395 2025.05.01 04:37:46.560 2025.05.01 04:37:47.362 2025.05.01 03:20:41.989 2025.05.01 03:20:44.384
14 5.0.3.1650 2025.04.28 4cbff P E 797 2240 2025.04.30 04:36:47.648 2025.04.30 04:36:48.445 2025.04.30 03:19:55.029 2025.04.30 03:19:57.269
15 5.0.3.1649 2025.04.21 5b2d0 P E 828 2435 2025.04.26 10:10:46.768 2025.04.26 10:10:47.596 2025.04.26 08:52:55.447 2025.04.26 08:52:57.882
16 5.0.3.1648 2025.04.18 2f4c5 P P 849 575 2025.04.20 04:22:01.617 2025.04.20 04:22:02.466 2025.04.20 03:20:07.239 2025.04.20 03:20:07.814
17 5.0.3.1635 2025.04.03 f6bd1 P E 853 2241 2025.04.18 06:49:44.101 2025.04.18 06:49:44.954 2025.04.18 05:32:07.501 2025.04.18 05:32:09.742
18 5.0.3.1635 2025.03.31 22ec6 P E 823 2430 2025.04.03 09:55:31.973 2025.04.03 09:55:32.796 2025.04.03 08:37:33.230 2025.04.03 08:37:35.660
19 5.0.3.1633 2025.03.28 3123a P E 826 2405 2025.03.31 09:53:58.564 2025.03.31 09:53:59.390 2025.03.31 08:36:06.878 2025.03.31 08:36:09.283
20 5.0.3.1633 2025.03.27 e0fb8 P E 846 2431 2025.03.28 10:25:41.141 2025.03.28 10:25:41.987 2025.03.28 09:04:02.864 2025.03.28 09:04:05.295
21 5.0.3.1631 2025.03.25 bda65 P P 877 588 2025.03.27 10:06:12.005 2025.03.27 10:06:12.882 2025.03.27 09:00:35.869 2025.03.27 09:00:36.457
22 5.0.3.1631 2025.03.21 1925b P P 862 593 2025.03.25 06:40:14.587 2025.03.25 06:40:15.449 2025.03.25 05:34:28.690 2025.03.25 05:34:29.283
23 5.0.3.1629 2025.03.18 506d7 P P 853 585 2025.03.20 09:40:28.722 2025.03.20 09:40:29.575 2025.03.20 08:34:35.140 2025.03.20 08:34:35.725
24 5.0.3.1628 2025.03.14 16d05 P P 825 551 2025.03.18 09:34:36.782 2025.03.18 09:34:37.607 2025.03.18 08:30:15.243 2025.03.18 08:30:15.794
25 5.0.3.1627 2025.02.26 4e218 P P 916 583 2025.03.13 09:53:57.486 2025.03.13 09:53:58.402 2025.03.13 08:47:49.527 2025.03.13 08:47:50.110
26 5.0.3.1624 2025.02.25 dc3b2 P P 911 597 2025.02.26 15:26:07.821 2025.02.26 15:26:08.732 2025.02.26 14:20:44.445 2025.02.26 14:20:45.042
27 5.0.2.1615 2025.02.20 4a726 P E 841 2428 2025.02.25 08:40:16.709 2025.02.25 08:40:17.550 2025.02.25 07:20:25.408 2025.02.25 07:20:27.836
28 5.0.2.1615 2025.02.14 9cb76 P P 848 561 2025.02.15 04:07:51.153 2025.02.15 04:07:52.001 2025.02.15 03:04:29.539 2025.02.15 03:04:30.100
29 5.0.2.1577 2025.02.07 f50a2 P P 851 551 2025.02.14 06:20:28.812 2025.02.14 06:20:29.663 2025.02.14 05:18:18.194 2025.02.14 05:18:18.745
30 5.0.2.1577 2024.12.24 3c80e P P 827 564 2025.02.06 09:34:01.190 2025.02.06 09:34:02.017 2025.02.06 08:31:53.390 2025.02.06 08:31:53.954
31 5.0.2.1576 2024.12.17 646b0 P P 876 564 2024.12.24 09:17:03.301 2024.12.24 09:17:04.177 2024.12.24 08:15:07.949 2024.12.24 08:15:08.513
32 5.0.2.1575 2024.12.09 9af52 P P 867 565 2024.12.16 09:13:49.674 2024.12.16 09:13:50.541 2024.12.16 08:11:58.997 2024.12.16 08:11:59.562
33 5.0.2.1575 2024.12.08 63d39 P P 748 484 2024.12.09 15:03:43.860 2024.12.09 15:03:44.608 2024.12.09 14:06:51.664 2024.12.09 14:06:52.148
34 5.0.2.1571 2024.12.08 8d11a P P 772 489 2024.12.09 06:17:21.902 2024.12.09 06:17:22.674 2024.12.09 05:18:28.113 2024.12.09 05:18:28.602
35 5.0.2.1567 2024.12.07 b01a2 P P 761 483 2024.12.08 01:55:36.939 2024.12.08 01:55:37.700 2024.12.08 00:55:15.609 2024.12.08 00:55:16.092
36 5.0.2.1567 2024.12.02 6ae74 P P 780 481 2024.12.04 08:59:16.383 2024.12.04 08:59:17.163 2024.12.04 08:02:21.125 2024.12.04 08:02:21.606
37 5.0.2.1567 2024.11.26 56e63 P P 841 557 2024.11.30 09:04:50.398 2024.11.30 09:04:51.239 2024.11.30 08:03:32.794 2024.11.30 08:03:33.351
38 5.0.2.1567 2024.11.21 96f61 P P 839 554 2024.11.27 09:01:35.360 2024.11.27 09:01:36.199 2024.11.27 08:00:53.507 2024.11.27 08:00:54.061
39 5.0.2.1567 2024.11.18 e1289 P E 836 2243 2024.11.21 09:19:58.751 2024.11.21 09:19:59.587 2024.11.21 08:02:47.060 2024.11.21 08:02:49.303
40 5.0.2.1533 2024.10.23 0ec43 P P 827 551 2024.11.18 08:55:48.810 2024.11.18 08:55:49.637 2024.11.18 07:54:23.600 2024.11.18 07:54:24.151
41 5.0.2.1533 2024.10.22 8af7a P P 849 554 2024.10.23 09:03:02.406 2024.10.23 09:03:03.255 2024.10.23 08:02:13.890 2024.10.23 08:02:14.444
42 5.0.2.1532 2024.10.15 36dc0 P P 850 568 2024.10.22 15:05:09.977 2024.10.22 15:05:10.827 2024.10.22 14:04:22.197 2024.10.22 14:04:22.765
43 5.0.2.1518 2024.10.04 259ba P P 845 571 2024.10.15 08:59:10.141 2024.10.15 08:59:10.986 2024.10.15 07:58:38.448 2024.10.15 07:58:39.019
44 5.0.2.1518 2024.09.26 703cd P P 859 550 2024.10.03 09:04:04.423 2024.10.03 09:04:05.282 2024.10.03 08:03:10.035 2024.10.03 08:03:10.585
45 5.0.2.1489 2024.08.31 994a6 P E 839 2247 2024.09.26 09:23:06.581 2024.09.26 09:23:07.420 2024.09.26 08:05:20.689 2024.09.26 08:05:22.936
46 5.0.2.1476 2024.08.09 843ea P E 897 2404 2024.09.01 09:11:42.817 2024.09.01 09:11:43.714 2024.09.01 07:52:26.171 2024.09.01 07:52:28.575
47 5.0.1.1454 2024.08.08 30f9f P P 1004 597 2024.08.09 08:52:26.313 2024.08.09 08:52:27.317 2024.08.09 07:51:56.668 2024.08.09 07:51:57.265
48 5.0.1.1453 2024.08.07 ebbc3 P P 981 600 2024.08.08 20:06:44.525 2024.08.08 20:06:45.506 2024.08.08 19:05:48.773 2024.08.08 19:05:49.373
49 5.0.1.1453 2024.08.06 1b9d0 P P 855 481 2024.08.07 08:21:45.345 2024.08.07 08:21:46.200 2024.08.07 07:25:59.440 2024.08.07 07:25:59.921
50 5.0.1.1453 2024.07.30 48044 P P 820 472 2024.08.03 08:19:46.109 2024.08.03 08:19:46.929 2024.08.03 07:23:52.205 2024.08.03 07:23:52.677
51 5.0.1.1453 2024.07.28 8d956 P P 855 482 2024.07.30 08:00:28.999 2024.07.30 08:00:29.854 2024.07.30 07:06:17.781 2024.07.30 07:06:18.263
52 5.0.1.1429 2024.07.19 8ee90 P P 806 465 2024.07.27 07:59:12.419 2024.07.27 07:59:13.225 2024.07.27 07:05:23.853 2024.07.27 07:05:24.318
53 5.0.1.1428 2024.07.15 00392 P P 800 453 2024.07.19 07:54:37.930 2024.07.19 07:54:38.730 2024.07.19 07:00:56.785 2024.07.19 07:00:57.238
54 5.0.1.1428 2024.06.30 67a31 P P 757 486 2024.07.15 08:06:04.832 2024.07.15 08:06:05.589 2024.07.15 07:11:13.728 2024.07.15 07:11:14.214
55 5.0.1.1415 2024.06.12 f8731 P P 838 485 2024.06.22 05:04:43.702 2024.06.22 05:04:44.540 2024.06.22 04:11:31.004 2024.06.22 04:11:31.489
56 5.0.1.1415 2024.06.11 31d74 P P 641 375 2024.06.11 23:35:03.493 2024.06.11 23:35:04.134 2024.06.11 22:45:20.798 2024.06.11 22:45:21.173
57 5.0.1.1401 2024.06.05 f9b76 P P 641 375 2024.06.11 04:25:56.064 2024.06.11 04:25:56.705 2024.06.11 03:35:57.944 2024.06.11 03:35:58.319
58 5.0.1.1398 2024.05.10 5e3ce P P 641 375 2024.05.25 05:20:47.613 2024.05.25 05:20:48.254 2024.05.25 04:31:11.449 2024.05.25 04:31:11.824
59 5.0.1.1397 2024.05.09 ee2ef P P 641 376 2024.05.10 05:16:43.570 2024.05.10 05:16:44.211 2024.05.10 04:27:42.587 2024.05.10 04:27:42.963
60 5.0.1.1392 2024.04.29 7dbc2 P P 640 375 2024.05.09 17:06:25.800 2024.05.09 17:06:26.440 2024.05.09 16:17:11.372 2024.05.09 16:17:11.747
61 5.0.1.1386 2024.04.25 c0328 P P 625 360 2024.04.29 05:15:41.867 2024.04.29 05:15:42.492 2024.04.29 04:26:41.550 2024.04.29 04:26:41.910
62 5.0.1.1386 2024.04.20 80571 P P 610 356 2024.04.25 05:18:20.719 2024.04.25 05:18:21.329 2024.04.25 04:28:30.261 2024.04.25 04:28:30.617
63 5.0.1.1378 2024.04.07 5292b P E 641 2297 2024.04.20 05:37:59.872 2024.04.20 05:38:00.513 2024.04.20 04:29:31.246 2024.04.20 04:29:33.543
64 5.0.1.1346 2024.03.16 fe320 P P 563 359 2024.04.07 03:37:09.201 2024.04.07 03:37:09.764 2024.04.07 02:52:08.306 2024.04.07 02:52:08.665
65 5.0.1.1346 2024.03.02 da408 P P 562 343 2024.03.25 22:24:45.859 2024.03.25 22:24:46.421 2024.03.25 21:39:51.940 2024.03.25 21:39:52.283
66 5.0.1.1340 2024.02.17 08a71 P P 561 358 2024.03.25 23:54:28.243 2024.03.25 23:54:28.804 2024.03.25 23:09:39.388 2024.03.25 23:09:39.746
67 5.0.1.1325 2024.02.06 c98fb P E 561 2296 2024.03.26 02:25:56.226 2024.03.26 02:25:56.787 2024.03.26 01:22:23.397 2024.03.26 01:22:25.693
68 5.0.1.1325 2024.02.02 1d438 P E 577 2296 2024.03.26 07:43:16.146 2024.03.26 07:43:16.723 2024.03.26 06:38:49.817 2024.03.26 06:38:52.113
69 5.0.1.1325 2024.01.26 cffb6 P E 562 2281 2024.03.26 10:09:08.712 2024.03.26 10:09:09.274 2024.03.26 09:05:33.930 2024.03.26 09:05:36.211
70 5.0.1.1325 2024.01.26 d3810 P E 561 2296 2024.03.26 12:00:48.103 2024.03.26 12:00:48.664 2024.03.26 10:57:22.033 2024.03.26 10:57:24.329
71 5.0.1.1318 2024.01.21 a7ca3 P P 562 343 2024.03.26 13:29:49.488 2024.03.26 13:29:50.050 2024.03.26 12:45:01.742 2024.03.26 12:45:02.085
72 5.0.1.1318 2024.01.21 d429d P P 561 358 2024.03.26 15:11:26.639 2024.03.26 15:11:27.200 2024.03.26 14:26:41.614 2024.03.26 14:26:41.972
73 5.0.1.1318 2024.01.21 f1ab5 P P 561 327 2024.03.26 17:27:26.765 2024.03.26 17:27:27.326 2024.03.26 16:42:40.403 2024.03.26 16:42:40.730
74 5.0.1.1318 2024.01.20 46722 P P 578 343 2024.03.26 18:54:23.609 2024.03.26 18:54:24.187 2024.03.26 18:09:43.857 2024.03.26 18:09:44.200

Elapsed time, ms. Chart for last 74 runs:

Last commits information (all timestamps in UTC):