bigquery.it.ITNightlyBigQueryTest: testPositionalParams failed

[flaky-bot]

Note: #2163 was also for this test, but it was closed more than 10 days ago. So, I didn't mark it flaky.

---

commit: 6231be7
buildURL: Build Status, Sponge
status: failed

Test output

com.google.api.gax.rpc.NotFoundException: io.grpc.StatusRuntimeException: NOT_FOUND: Not found: Table gcloud-devel:_d4c2e652867e06ffb3ff530d342160f9a25f05ab.anon701b4755_956b_43a4_bd1c_77b86c1aae93
Caused by: io.grpc.StatusRuntimeException: NOT_FOUND: Not found: Table gcloud-devel:_d4c2e652867e06ffb3ff530d342160f9a25f05ab.anon701b4755_956b_43a4_bd1c_77b86c1aae93

[flaky-bot]

Looks like this issue is flaky. 😟

I'm going to leave this open and stop commenting.

A human should fix and close this.

---

When run at the same commit (6231be7), this test passed in one build (Build Status, Sponge) and failed in another build (Build Status, Sponge).

[Neenu1995]

Closing as flaky for now. Investigate further if this happens again.

[flaky-bot]

Oops! Looks like this issue is still flaky. It failed again. 😬

I reopened the issue, but a human will need to close it again.

---

commit: 9484f95
buildURL: Build Status, Sponge
status: failed

Test output

com.google.api.gax.rpc.NotFoundException: io.grpc.StatusRuntimeException: NOT_FOUND: Not found: Table gcloud-devel:_d4c2e652867e06ffb3ff530d342160f9a25f05ab.anona52fa0ee_6646_40bc_b546_1485ef23f457
Caused by: io.grpc.StatusRuntimeException: NOT_FOUND: Not found: Table gcloud-devel:_d4c2e652867e06ffb3ff530d342160f9a25f05ab.anona52fa0ee_6646_40bc_b546_1485ef23f457

[brijk7]

Looks like it failed again on Aug 16 with same error. Sponge

[Neenu1995]

Hi @prash-mi,
Is this an extension of the table not found error in executeSelect?

[prash-mi]

Yes @Neenu1995 , #2222 was merged yesterday and this should take care of table not found issue

[flaky-bot]

Oops! Looks like this issue is still flaky. It failed again. 😬

I reopened the issue, but a human will need to close it again.

---

commit: a9b5fb2
buildURL: Build Status, Sponge
status: failed

Test output

com.google.cloud.bigquery.BigQuerySQLException: Error encountered during execution. Retrying may solve the problem.
	at com.google.cloud.bigquery.it.ITNightlyBigQueryTest.testPositionalParams(ITNightlyBigQueryTest.java:468)
Caused by: com.google.cloud.bigquery.BigQueryException: Error encountered during execution. Retrying may solve the problem.
	at com.google.cloud.bigquery.it.ITNightlyBigQueryTest.testPositionalParams(ITNightlyBigQueryTest.java:468)
Caused by: com.google.api.client.googleapis.json.GoogleJsonResponseException: 
400 Bad Request
POST https://www.googleapis.com/bigquery/v2/projects/gcloud-devel/queries
{
  "code" : 400,
  "errors" : [ {
    "domain" : "global",
    "message" : "Error encountered during execution. Retrying may solve the problem.",
    "reason" : "jobBackendError"
  } ],
  "message" : "Error encountered during execution. Retrying may solve the problem.",
  "status" : "INVALID_ARGUMENT"
}
	at com.google.cloud.bigquery.it.ITNightlyBigQueryTest.testPositionalParams(ITNightlyBigQueryTest.java:468)

[prash-mi]

This looks like a new error on the same test cases. I will check with backend if retrying can fix it and accordingly we can plan for a fix.

[prash-mi]

This looks stable as of now, closing and will have a look if it breaks again.