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

Annotation type Annotation details
2 @message
Server crashed ?
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:

2024-08-31 20:01:17.612
2024-08-31 20:01:17.627 act = <firebird.qa.plugin.Action object at [hex]>
2024-08-31 20:01:17.635
2024-08-31 20:01:17.646 @pytest.mark.version('>=4.0.6')
2024-08-31 20:01:17.664 def test_1(act: Action):
2024-08-31 20:01:17.677
2024-08-31 20:01:17.687 expected_stdout = f"""
2024-08-31 20:01:17.698 Statement failed, SQLSTATE = 39000
2024-08-31 20:01:17.708 function MAKE_DBKEY could not be matched
2024-08-31 20:01:17.716
2024-08-31 20:01:17.724 Statement failed, SQLSTATE = 39000
2024-08-31 20:01:17.731 function MAKE_DBKEY could not be matched
2024-08-31 20:01:17.738 """
2024-08-31 20:01:17.749 act.expected_stdout = expected_stdout
2024-08-31 20:01:17.761 act.execute(combine_output = True)
2024-08-31 20:01:17.774 >       assert act.clean_stdout == act.clean_expected_stdout
2024-08-31 20:01:17.785 E       assert
2024-08-31 20:01:17.796 E         - Statement failed, SQLSTATE = 39000
2024-08-31 20:01:17.817 E         + Statement failed, SQLSTATE = 08006
2024-08-31 20:01:17.837 E         - function MAKE_DBKEY could not be matched
2024-08-31 20:01:17.847 E         + Error reading data from the connection.
2024-08-31 20:01:17.857 E         - Statement failed, SQLSTATE = 39000
2024-08-31 20:01:17.878 E         + Statement failed, SQLSTATE = 08006
2024-08-31 20:01:17.899 E         - function MAKE_DBKEY could not be matched
2024-08-31 20:01:17.911 E         + Error writing data to the connection.
2024-08-31 20:01:17.922 E         + Statement failed, SQLSTATE = 08006
2024-08-31 20:01:17.932 E         + Error writing data to the connection.
2024-08-31 20:01:17.942 E         + Statement failed, SQLSTATE = 08006
2024-08-31 20:01:17.953 E         + Error writing data to the connection.
2024-08-31 20:01:17.967
2024-08-31 20:01:17.979 tests/bugs/gh_8221_test.py:38: AssertionError
2024-08-31 20:01:17.991 ---------------------------- Captured stdout setup -----------------------------
2024-08-31 20:01:18.004 Creating db: localhost:/var/tmp/qa_2024/test_11555/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
3 #text
request = <SubRequest 'db' for <Function test_1>>
db_path = PosixPath('/var/tmp/qa_2024/test_11555')
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)

../lib/python3.11/site-packages/firebird/driver/core.py:5596: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 

self = <firebird.driver.interfaces.iProvider pytest object at [hex]>
service = 'localhost/3720: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()

../lib/python3.11/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.

../lib/python3.11/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 570 426 2025.06.29 15:54:44.772 2025.06.29 15:54:45.342 2025.06.29 14:40:39.893 2025.06.29 14:40:40.319
2 4.0.6.3184 2025.02.24 9388c P P 1053 747 2025.02.25 13:50:00.227 2025.02.25 13:50:01.280 2025.02.25 12:30:46.629 2025.02.25 12:30:47.376
3 4.0.6.3183 2025.02.16 cf6ca P P 948 873 2025.02.17 07:44:14.680 2025.02.17 07:44:15.628 2025.02.17 06:24:22.319 2025.02.17 06:24:23.192
4 4.0.6.3169 2024.12.13 42cc1 P P 1037 879 2025.02.16 04:41:19.207 2025.02.16 04:41:20.244 2025.02.16 03:23:39.274 2025.02.16 03:23:40.153
5 4.0.6.3169 2024.12.08 50eb6 P P 785 638 2024.12.12 18:58:05.973 2024.12.12 18:58:06.758 2024.12.12 17:55:57.272 2024.12.12 17:55:57.910
6 4.0.6.3168 2024.11.28 48149 P P 785 627 2024.12.06 03:18:57.503 2024.12.06 03:18:58.288 2024.12.06 02:18:30.542 2024.12.06 02:18:31.169
7 4.0.6.3163 2024.10.16 2bb10 P P 823 736 2024.11.27 13:43:38.385 2024.11.27 13:43:39.208 2024.11.27 10:42:14.405 2024.11.27 10:42:15.141
8 4.0.6.3163 2024.10.15 f387e P P 805 658 2024.10.16 04:48:57.773 2024.10.16 04:48:58.578 2024.10.16 03:51:29.260 2024.10.16 03:51:29.918
9 4.0.6.3147 2024.08.31 4655b P P 854 653 2024.09.30 12:05:14.793 2024.09.30 12:05:15.647 2024.09.30 11:01:01.219 2024.09.30 11:01:01.872
10 4.0.6.3140 2024.08.16 1dd8b F E 2886 2628 2024.08.31 18:37:50.402 2024.08.31 18:37:53.288 2024.08.31 16:41:48.280 2024.08.31 16:41:50.908

Elapsed time, ms. Chart for last 10 runs:

Last commits information (all timestamps in UTC):