question

Hi @JS,

the error says:

Unable to connect to the metadata service at https://26502f4d-475b-401a-9bbc-63ab53023eaf-us-east1.db.astra.datastax.com:32279/metadata. Check the cluster status in the cloud console.

That means that the secure bundle was definitely found, and the connection fails on the connection to the database itself.

I assume you have already verified the status of the Astra database and that it is running, and you have verified all the login details, and everything is correct.

The most likely cause of this error now is that the connection from your local machine to the Astra instance is a bit too slow for the connection timeouts that are set by default. We have seen this in a couple of instances when connecting from local machines, and sometimes from Gitpod.

Try to add more generous timeouts in the db_connection.py file where we define the connection:

class Connection:
    def __init__(self):
        self.secure_connect_bundle=SECURE_CONNECT_BUNDLE
        self.path_to_creds=''
        self.cluster = Cluster(
            cloud={
                'secure_connect_bundle': self.secure_connect_bundle,
                'init-query-timeout': 10,
                'connect_timeout': 10,
                'set-keyspace-timeout': 10
            },
            auth_provider=PlainTextAuthProvider(USERNAME, PASSWORD)
        )
        self.session = self.cluster.connect(KEYSPACE)
    def close(self):
        self.cluster.shutdown()
        self.session.shutdown()

We found that especially the 'init-query-timeout' default of 500ms is too tight in some cases. In the code above we have increased it to 10s.

Let us know if this gets you over this hurdle, your feedback is appreciated.