google-cloud-php icon indicating copy to clipboard operation
google-cloud-php copied to clipboard

bug(BigQuery): Throw exception when reload function returns 499 status code

Open zajca opened this issue 1 year ago • 0 comments

When jobTimeoutMs is set to run query and query timeouts WaitTrait causes to wait for result "indefinetly" (Job::MAX_RETRIES).

How to replicate issue:

$client = new BigQueryClient(...);
$client->runQuery($client->query(
    'WITH RECURSIVE counter AS (
              SELECT 1 AS n
              UNION ALL
              SELECT n+1 FROM counter WHERE n < 10000
            )
            
            SELECT 
              a.n AS val1, 
              b.n AS val2
            FROM 
              counter a 
            CROSS JOIN 
              counter b;',
    [
        'configuration' => [
            'jobTimeoutMs' => 10 * 1000,
        ],
    ]
));

Maybe there should be more status codes which should not be retried, but I so far run only into this problem.

zajca avatar Nov 01 '23 10:11 zajca