Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Retry didn't happen #1991

Open
nitishxp opened this issue Aug 10, 2024 · 0 comments
Open

Retry didn't happen #1991

nitishxp opened this issue Aug 10, 2024 · 0 comments
Assignees
Labels
api: bigquery Issues related to the googleapis/python-bigquery API.

Comments

@nitishxp
Copy link

nitishxp commented Aug 10, 2024

Hi team,

I have google-cloud-bigquery==3.24.0

Error Type: <class 'google.api_core.exceptions.BadRequest'> error: 400 GET https://bigquery.googleapis.com/bigquery/v2/projects/<>/queries/JOB_ID?maxResults=0&location=US&prettyPrint=false: The job encountered an error during execution. Retrying the job may solve the problem. Location: US Job ID: JOB_ID 
File "/layers/google.python.runtime/python/lib/python3.9/concurrent/futures/_base.py", line 439, in result return self.__get_result() File "/layers/google.python.runtime/python/lib/python3.9/concurrent/futures/_base.py", line 391, in __get_result raise self._exception 
File "/layers/google.python.runtime/python/lib/python3.9/concurrent/futures/thread.py", line 58, in run result = self.fn(*self.args, **self.kwargs) 
File "/workspace/main.py", line 312, in ( File "/workspace/main.py", line 267, in partition for row in job.result(): 
File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/cloud/bigquery/job/query.py", line 1675, in result while not is_job_done(): 
File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/api_core/retry/retry_unary.py", line 293, in retry_wrapped_func return retry_target( File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/api_core/retry/retry_unary.py", line 153, in retry_target _retry_error_helper( 
File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/api_core/retry/retry_base.py", line 212, in _retry_error_helper raise final_exc from source_exc File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/api_core/retry/retry_unary.py", line 144, in retry_target result = target() 
File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/cloud/bigquery/job/query.py", line 1644, in is_job_done self._reload_query_results(retry=retry, **reload_query_results_kwargs) 
File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/cloud/bigquery/job/query.py", line 1443, in _reload_query_results self._query_results = self._client._get_query_results( 
File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/cloud/bigquery/client.py", line 2024, in _get_query_results resource = self._call_api( 
File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/cloud/bigquery/client.py", line 833, in _call_api return call() File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/api_core/retry/retry_unary.py", line 293, in retry_wrapped_func return retry_target( 
File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/api_core/retry/retry_unary.py", line 153, in retry_target _retry_error_helper( File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/api_core/retry/retry_base.py", line 212, in _retry_error_helper raise final_exc from source_exc 
File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/api_core/retry/retry_unary.py", line 144, in retry_target result = target() File "/layers/google.python.pip/pip/lib/python3.9/site-packages/google/cloud/_http/__init__.py", line 494, in api_request raise exceptions.from_http_response(response) google.api_core.exceptions.BadRequest 
 400 GET https://bigquery.googleapis.com/bigquery/v2/projects/<>queries/<>?maxResults=0&location=US&prettyPrint=false: The job encountered an error during execution. Retrying the 
```job may solve the problem. Location: US Job ID: <> --

SDK should have retried this request 
@product-auto-label product-auto-label bot added the api: bigquery Issues related to the googleapis/python-bigquery API. label Aug 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
api: bigquery Issues related to the googleapis/python-bigquery API.
Projects
None yet
Development

No branches or pull requests

3 participants