___________ TestBigQuery.test_dbapi_connection_does_not_leak_sockets ___________

self = <tests.system.test_client.TestBigQuery testMethod=test_dbapi_connection_does_not_leak_sockets>

    @unittest.skipIf(
        bigquery_storage is None, "Requires `google-cloud-bigquery-storage`"
    )
    def test_dbapi_connection_does_not_leak_sockets(self):
        current_process = psutil.Process()
        conn_count_start = len(current_process.connections())

        # Provide no explicit clients, so that the connection will create and own them.
        connection = dbapi.connect()
        cursor = connection.cursor()

        cursor.execute(
            """
            SELECT id, `by`, time_ts
            FROM `bigquery-public-data.hacker_news.comments`
            ORDER BY `id` ASC
            LIMIT 100000
        """
        )
        rows = cursor.fetchall()
        self.assertEqual(len(rows), 100000)

        connection.close()
        conn_count_end = len(current_process.connections())
>       self.assertEqual(conn_count_end, conn_count_start)
E       AssertionError: 3 != 7

tests/system/test_client.py:1728: AssertionError