google-cloud-node: Intermittent BigQuery failures
Our system test which validates that we return a PartialFailureError
when invalid data is inserted into a table.
The schema states that the name
property must be a string.
Our request body looks like this:
{
"rows": [
{
"json": {
"name": "dave"
}
},
{
"json": {
"name": 11
}
}
]
}
The response is either:
// incorrect (frequent)
{
kind: 'bigquery#tableDataInsertAllResponse'
}
// correct (infrequent)
{
"kind": "bigquery#tableDataInsertAllResponse",
"insertErrors": [
{
"index": 1,
"errors": [
{
"reason": "invalid",
"location": "name",
"debugInfo": "generic::invalid_argument: Conversion from int64 to string is unsupported.",
"message": "Conversion from int64 to string is unsupported."
}
]
},
{
"index": 0,
"errors": [
{
"reason": "stopped"
}
]
}
]
}
The first I noticed this error was Friday, 3/3/17.
@tswast any ideas? Thanks!
About this issue
- Original URL
- State: closed
- Created 7 years ago
- Reactions: 1
- Comments: 15 (15 by maintainers)
It doesn’t look like that old code would have returned errors, since they were previously returned through the ‘insertErrors’ argument and not through the ‘err’ argument. The err, back then, was for request failures like 404, 503, but didn’t include insertErrors.
So, I think like you said, you’re also experiencing these intermittent failures, but they are coming from BQ’s API and not ours. Unless there’s another way we’re supposed to be sending the requests than we do: https://github.com/GoogleCloudPlatform/google-cloud-node/blob/master/packages/bigquery/src/table.js#L1059