GCP Composer unable to install cloud-sql-python-connector pypi package

[software1tkh]

Bug Description

Tried to install latest cloud-sql-python-connector pypi package into GCP Composer but failed.
Tried it on both images:
composer-2.6.1-airflow-2.6.3
composer-2.7.1-airflow-2.7.3

The following cloud-sql-python-connector pypi package version installed successfully: 0.6.2 0.7.0 0.9.0 1.1.0 1.4.0 1.6.0

Anything higher than 1.6.0 and lower than 0.6.2 will fail.

Error logs caused this issue : There was an error creating your Issue: body is too long (maximum is 65536 characters). So paste the logs in https://pastebin.com/k5Pa8tpW instead

Example code (or command)

No response

Stacktrace

https://pastebin.com/k5Pa8tpW

Steps to reproduce?

1. Login into GCP web console -> GCP Composer -> Pypi Package -> Edit -> key in the following: Package Name 1 : cloud-sql-python-connector Extras and Version 1 : ==1.9.2

Environment

1. OS type and version: composer-2.6.1-airflow-2.6.3 & composer-2.7.1-airflow-2.7.3
2. Python version: 3.11.5 & 3.11.8
3. Cloud SQL Python Connector version: 1.70, 1.8.0, 1.9.0, 1.9.1, 1.9.2

Additional Details

No response