Skip to content

google.api_core.exceptions.ResourceExhausted: 429 Quota exceeded for quota metric 'Administrative requests' and limit 'Administrative requests per minute'  #104

@hadim

Description

@hadim

I am running into some quota limitations when doing a high number of read requests in parallel:

google.api_core.exceptions.ResourceExhausted: 429 Quota exceeded for quota metric 'Administrative requests' and limit 'Administrative requests per minute' of service 'spanner.googleapis.com' for consumer 'project_number:xxxx'.

The request is quite similar to a simple SELECT * FROM table1 as t1 JOIN table2 as t2 ON t1.id = t2.id.

The error says Administrative requests per minute which seems weird to me since it has nothing to do with an admin action right?

Is it something related to python-spanner-sqlalchemy?

From https://cloud.google.com/spanner/quotas#administrative_limits, it seems like the limit can't be modified.

This issue is quite limiting for us at the moment to scale our workload with Spanner.

Metadata

Metadata

Assignees

Labels

api: spannerIssues related to the googleapis/python-spanner-sqlalchemy API.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions