googleapis / python-bigquery

Apache License 2.0
746 stars 306 forks source link

Retry didn't happen #1991

Open nitishxp opened 3 months ago

nitishxp commented 3 months ago

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