BigQuery insert error, state: pending, status code 5
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
I am having bigquery insert error, which I can not find any solution to fix. I am doing stream insert using nodejs using google app engine. The error does not occur every time though. The log of the error is given as:
{
insertId: "j5hzu8e36yg0"
logName: "projects/xxxx-xxxx/logs/cloudaudit.googleapis.com%2Fdata_access"
protoPayload: {
@type: "type.googleapis.com/google.cloud.audit.AuditLog"
authenticationInfo: {
principalEmail: "xxxx-xxxx@appspot.gserviceaccount.com"
}
authorizationInfo: [
0: {
granted: true
permission: "bigquery.jobs.create"
resource: "projects/xxxx-xxxx"
}
]
methodName: "jobservice.getqueryresults"
requestMetadata: {
callerIp: "xx.xx.xx.xx"
callerSuppliedUserAgent: "gcloud-dotnet/1.0.0-beta18 google-api-dotnet-client/1.35.1.0 (gzip),gzip(gfe)"
}
resourceName: "projects/xxxx-xxxx/queries/job_bc378dc9_240d_4caf_acfa_d54691ffe595"
serviceData: {
@type: "type.googleapis.com/google.cloud.bigquery.logging.v1.AuditData"
jobGetQueryResultsRequest: {
}
jobGetQueryResultsResponse: {
job: {
jobConfiguration: {
}
jobName: {
}
jobStatistics: {
}
jobStatus: {
error: {
}
state: "PENDING"
}
}
}
}
serviceName: "bigquery.googleapis.com"
status: {
code: 5
message: "Not found: Job xxxx-xxxx:job_bc378dc9_240d_4caf_acfa_d54691ffe595"
}
}
receiveTimestamp: "2018-11-22T07:24:42.323436659Z"
resource: {
labels: {
project_id: "xxxx-xxxx"
}
type: "bigquery_resource"
}
severity: "ERROR"
timestamp: "2018-11-22T07:24:41.794Z"Let me know if you need further information.
google-app-engine google-bigquery
edited Nov 22 '18 at 11:25
Dan Cornilescu
30.1k113867
asked Nov 22 '18 at 8:08
ituringituring
114
add a comment |
0
I am having bigquery insert error, which I can not find any solution to fix. I am doing stream insert using nodejs using google app engine. The error does not occur every time though. The log of the error is given as:
{
insertId: "j5hzu8e36yg0"
logName: "projects/xxxx-xxxx/logs/cloudaudit.googleapis.com%2Fdata_access"
protoPayload: {
@type: "type.googleapis.com/google.cloud.audit.AuditLog"
authenticationInfo: {
principalEmail: "xxxx-xxxx@appspot.gserviceaccount.com"
}
authorizationInfo: [
0: {
granted: true
permission: "bigquery.jobs.create"
resource: "projects/xxxx-xxxx"
}
]
methodName: "jobservice.getqueryresults"
requestMetadata: {
callerIp: "xx.xx.xx.xx"
callerSuppliedUserAgent: "gcloud-dotnet/1.0.0-beta18 google-api-dotnet-client/1.35.1.0 (gzip),gzip(gfe)"
}
resourceName: "projects/xxxx-xxxx/queries/job_bc378dc9_240d_4caf_acfa_d54691ffe595"
serviceData: {
@type: "type.googleapis.com/google.cloud.bigquery.logging.v1.AuditData"
jobGetQueryResultsRequest: {
}
jobGetQueryResultsResponse: {
job: {
jobConfiguration: {
}
jobName: {
}
jobStatistics: {
}
jobStatus: {
error: {
}
state: "PENDING"
}
}
}
}
serviceName: "bigquery.googleapis.com"
status: {
code: 5
message: "Not found: Job xxxx-xxxx:job_bc378dc9_240d_4caf_acfa_d54691ffe595"
}
}
receiveTimestamp: "2018-11-22T07:24:42.323436659Z"
resource: {
labels: {
project_id: "xxxx-xxxx"
}
type: "bigquery_resource"
}
severity: "ERROR"
timestamp: "2018-11-22T07:24:41.794Z"Let me know if you need further information.
google-app-engine google-bigquery
edited Nov 22 '18 at 11:25
Dan Cornilescu
30.1k113867
asked Nov 22 '18 at 8:08
ituringituring
114
Can you share the code too?
– Graham Polley
Nov 22 '18 at 12:00
bigquery .dataset('raw') .table(tbl) .insert(rows) .then(() => { console.log(Inserted ${rows.length} rows); }) .catch(err => { if (err && err.name === 'PartialFailureError') { if (err.errors && err.errors.length > 0) { console.log('Insert errors:'); err.errors.forEach(err => console.error(err)); } } else { console.error('BQ INGEST ERROR CUST RAW:', err); } }); };
– ituring
Nov 22 '18 at 13:31
Audit log entry you provided corresponds to a failed request to retrieve job results (cloud.google.com/bigquery/docs/reference/rest/v2/jobs/…). And based on the user agent it was made using github.com/googleapis/google-cloud-dotnet. Can you attach a proper streaming insert response as defined at cloud.google.com/bigquery/docs/reference/rest/v2/tabledata/…?
– Nikita Uchaev
Dec 13 '18 at 10:59
add a comment |
0
0
0
I am having bigquery insert error, which I can not find any solution to fix. I am doing stream insert using nodejs using google app engine. The error does not occur every time though. The log of the error is given as:
{
insertId: "j5hzu8e36yg0"
logName: "projects/xxxx-xxxx/logs/cloudaudit.googleapis.com%2Fdata_access"
protoPayload: {
@type: "type.googleapis.com/google.cloud.audit.AuditLog"
authenticationInfo: {
principalEmail: "xxxx-xxxx@appspot.gserviceaccount.com"
}
authorizationInfo: [
0: {
granted: true
permission: "bigquery.jobs.create"
resource: "projects/xxxx-xxxx"
}
]
methodName: "jobservice.getqueryresults"
requestMetadata: {
callerIp: "xx.xx.xx.xx"
callerSuppliedUserAgent: "gcloud-dotnet/1.0.0-beta18 google-api-dotnet-client/1.35.1.0 (gzip),gzip(gfe)"
}
resourceName: "projects/xxxx-xxxx/queries/job_bc378dc9_240d_4caf_acfa_d54691ffe595"
serviceData: {
@type: "type.googleapis.com/google.cloud.bigquery.logging.v1.AuditData"
jobGetQueryResultsRequest: {
}
jobGetQueryResultsResponse: {
job: {
jobConfiguration: {
}
jobName: {
}
jobStatistics: {
}
jobStatus: {
error: {
}
state: "PENDING"
}
}
}
}
serviceName: "bigquery.googleapis.com"
status: {
code: 5
message: "Not found: Job xxxx-xxxx:job_bc378dc9_240d_4caf_acfa_d54691ffe595"
}
}
receiveTimestamp: "2018-11-22T07:24:42.323436659Z"
resource: {
labels: {
project_id: "xxxx-xxxx"
}
type: "bigquery_resource"
}
severity: "ERROR"
timestamp: "2018-11-22T07:24:41.794Z"Let me know if you need further information.
google-app-engine google-bigquery
edited Nov 22 '18 at 11:25
Dan Cornilescu
30.1k113867
asked Nov 22 '18 at 8:08
ituringituring
114
I am having bigquery insert error, which I can not find any solution to fix. I am doing stream insert using nodejs using google app engine. The error does not occur every time though. The log of the error is given as:
{
insertId: "j5hzu8e36yg0"
logName: "projects/xxxx-xxxx/logs/cloudaudit.googleapis.com%2Fdata_access"
protoPayload: {
@type: "type.googleapis.com/google.cloud.audit.AuditLog"
authenticationInfo: {
principalEmail: "xxxx-xxxx@appspot.gserviceaccount.com"
}
authorizationInfo: [
0: {
granted: true
permission: "bigquery.jobs.create"
resource: "projects/xxxx-xxxx"
}
]
methodName: "jobservice.getqueryresults"
requestMetadata: {
callerIp: "xx.xx.xx.xx"
callerSuppliedUserAgent: "gcloud-dotnet/1.0.0-beta18 google-api-dotnet-client/1.35.1.0 (gzip),gzip(gfe)"
}
resourceName: "projects/xxxx-xxxx/queries/job_bc378dc9_240d_4caf_acfa_d54691ffe595"
serviceData: {
@type: "type.googleapis.com/google.cloud.bigquery.logging.v1.AuditData"
jobGetQueryResultsRequest: {
}
jobGetQueryResultsResponse: {
job: {
jobConfiguration: {
}
jobName: {
}
jobStatistics: {
}
jobStatus: {
error: {
}
state: "PENDING"
}
}
}
}
serviceName: "bigquery.googleapis.com"
status: {
code: 5
message: "Not found: Job xxxx-xxxx:job_bc378dc9_240d_4caf_acfa_d54691ffe595"
}
}
receiveTimestamp: "2018-11-22T07:24:42.323436659Z"
resource: {
labels: {
project_id: "xxxx-xxxx"
}
type: "bigquery_resource"
}
severity: "ERROR"
timestamp: "2018-11-22T07:24:41.794Z"Let me know if you need further information.
{
insertId: "j5hzu8e36yg0"
logName: "projects/xxxx-xxxx/logs/cloudaudit.googleapis.com%2Fdata_access"
protoPayload: {
@type: "type.googleapis.com/google.cloud.audit.AuditLog"
authenticationInfo: {
principalEmail: "xxxx-xxxx@appspot.gserviceaccount.com"
}
authorizationInfo: [
0: {
granted: true
permission: "bigquery.jobs.create"
resource: "projects/xxxx-xxxx"
}
]
methodName: "jobservice.getqueryresults"
requestMetadata: {
callerIp: "xx.xx.xx.xx"
callerSuppliedUserAgent: "gcloud-dotnet/1.0.0-beta18 google-api-dotnet-client/1.35.1.0 (gzip),gzip(gfe)"
}
resourceName: "projects/xxxx-xxxx/queries/job_bc378dc9_240d_4caf_acfa_d54691ffe595"
serviceData: {
@type: "type.googleapis.com/google.cloud.bigquery.logging.v1.AuditData"
jobGetQueryResultsRequest: {
}
jobGetQueryResultsResponse: {
job: {
jobConfiguration: {
}
jobName: {
}
jobStatistics: {
}
jobStatus: {
error: {
}
state: "PENDING"
}
}
}
}
serviceName: "bigquery.googleapis.com"
status: {
code: 5
message: "Not found: Job xxxx-xxxx:job_bc378dc9_240d_4caf_acfa_d54691ffe595"
}
}
receiveTimestamp: "2018-11-22T07:24:42.323436659Z"
resource: {
labels: {
project_id: "xxxx-xxxx"
}
type: "bigquery_resource"
}
severity: "ERROR"
timestamp: "2018-11-22T07:24:41.794Z"{
insertId: "j5hzu8e36yg0"
logName: "projects/xxxx-xxxx/logs/cloudaudit.googleapis.com%2Fdata_access"
protoPayload: {
@type: "type.googleapis.com/google.cloud.audit.AuditLog"
authenticationInfo: {
principalEmail: "xxxx-xxxx@appspot.gserviceaccount.com"
}
authorizationInfo: [
0: {
granted: true
permission: "bigquery.jobs.create"
resource: "projects/xxxx-xxxx"
}
]
methodName: "jobservice.getqueryresults"
requestMetadata: {
callerIp: "xx.xx.xx.xx"
callerSuppliedUserAgent: "gcloud-dotnet/1.0.0-beta18 google-api-dotnet-client/1.35.1.0 (gzip),gzip(gfe)"
}
resourceName: "projects/xxxx-xxxx/queries/job_bc378dc9_240d_4caf_acfa_d54691ffe595"
serviceData: {
@type: "type.googleapis.com/google.cloud.bigquery.logging.v1.AuditData"
jobGetQueryResultsRequest: {
}
jobGetQueryResultsResponse: {
job: {
jobConfiguration: {
}
jobName: {
}
jobStatistics: {
}
jobStatus: {
error: {
}
state: "PENDING"
}
}
}
}
serviceName: "bigquery.googleapis.com"
status: {
code: 5
message: "Not found: Job xxxx-xxxx:job_bc378dc9_240d_4caf_acfa_d54691ffe595"
}
}
receiveTimestamp: "2018-11-22T07:24:42.323436659Z"
resource: {
labels: {
project_id: "xxxx-xxxx"
}
type: "bigquery_resource"
}
severity: "ERROR"
timestamp: "2018-11-22T07:24:41.794Z"google-app-engine google-bigquery
google-app-engine google-bigquery
edited Nov 22 '18 at 11:25
Dan Cornilescu
30.1k113867
asked Nov 22 '18 at 8:08
ituringituring
114
edited Nov 22 '18 at 11:25
Dan Cornilescu
30.1k113867
asked Nov 22 '18 at 8:08
ituringituring
114
edited Nov 22 '18 at 11:25
Dan Cornilescu
30.1k113867
edited Nov 22 '18 at 11:25
Dan Cornilescu
30.1k113867
edited Nov 22 '18 at 11:25
Dan Cornilescu
30.1k113867
30.1k113867
asked Nov 22 '18 at 8:08
ituringituring
114
asked Nov 22 '18 at 8:08
ituringituring
114
asked Nov 22 '18 at 8:08
ituringituring
114
114
Can you share the code too?
– Graham Polley
Nov 22 '18 at 12:00
bigquery .dataset('raw') .table(tbl) .insert(rows) .then(() => { console.log(Inserted ${rows.length} rows); }) .catch(err => { if (err && err.name === 'PartialFailureError') { if (err.errors && err.errors.length > 0) { console.log('Insert errors:'); err.errors.forEach(err => console.error(err)); } } else { console.error('BQ INGEST ERROR CUST RAW:', err); } }); };
– ituring
Nov 22 '18 at 13:31
Audit log entry you provided corresponds to a failed request to retrieve job results (cloud.google.com/bigquery/docs/reference/rest/v2/jobs/…). And based on the user agent it was made using github.com/googleapis/google-cloud-dotnet. Can you attach a proper streaming insert response as defined at cloud.google.com/bigquery/docs/reference/rest/v2/tabledata/…?
– Nikita Uchaev
Dec 13 '18 at 10:59
add a comment |
Can you share the code too?
– Graham Polley
Nov 22 '18 at 12:00
bigquery .dataset('raw') .table(tbl) .insert(rows) .then(() => { console.log(Inserted ${rows.length} rows); }) .catch(err => { if (err && err.name === 'PartialFailureError') { if (err.errors && err.errors.length > 0) { console.log('Insert errors:'); err.errors.forEach(err => console.error(err)); } } else { console.error('BQ INGEST ERROR CUST RAW:', err); } }); };
– ituring
Nov 22 '18 at 13:31
Audit log entry you provided corresponds to a failed request to retrieve job results (cloud.google.com/bigquery/docs/reference/rest/v2/jobs/…). And based on the user agent it was made using github.com/googleapis/google-cloud-dotnet. Can you attach a proper streaming insert response as defined at cloud.google.com/bigquery/docs/reference/rest/v2/tabledata/…?
– Nikita Uchaev
Dec 13 '18 at 10:59
Can you share the code too?
– Graham Polley
Nov 22 '18 at 12:00
Can you share the code too?
– Graham Polley
Nov 22 '18 at 12:00
bigquery .dataset('raw') .table(tbl) .insert(rows) .then(() => { console.log(
Inserted ${rows.length} rows); }) .catch(err => { if (err && err.name === 'PartialFailureError') { if (err.errors && err.errors.length > 0) { console.log('Insert errors:'); err.errors.forEach(err => console.error(err)); } } else { console.error('BQ INGEST ERROR CUST RAW:', err); } }); };– ituring
Nov 22 '18 at 13:31
bigquery .dataset('raw') .table(tbl) .insert(rows) .then(() => { console.log(
Inserted ${rows.length} rows); }) .catch(err => { if (err && err.name === 'PartialFailureError') { if (err.errors && err.errors.length > 0) { console.log('Insert errors:'); err.errors.forEach(err => console.error(err)); } } else { console.error('BQ INGEST ERROR CUST RAW:', err); } }); };– ituring
Nov 22 '18 at 13:31
Audit log entry you provided corresponds to a failed request to retrieve job results (cloud.google.com/bigquery/docs/reference/rest/v2/jobs/…). And based on the user agent it was made using github.com/googleapis/google-cloud-dotnet. Can you attach a proper streaming insert response as defined at cloud.google.com/bigquery/docs/reference/rest/v2/tabledata/…?
– Nikita Uchaev
Dec 13 '18 at 10:59
Audit log entry you provided corresponds to a failed request to retrieve job results (cloud.google.com/bigquery/docs/reference/rest/v2/jobs/…). And based on the user agent it was made using github.com/googleapis/google-cloud-dotnet. Can you attach a proper streaming insert response as defined at cloud.google.com/bigquery/docs/reference/rest/v2/tabledata/…?
– Nikita Uchaev
Dec 13 '18 at 10:59
add a comment |
1 Answer
1
active
oldest
votes
0
It looks like BigQuery is unable to find the geographic location of the job.
Make sure to specify your region in the location property in the jobReference. Here is an github example for nodejs that you can consult.
UPDATE
Check if the job that was not found was retried and successfully done. In streaming it needs a delay between requesting the job and try to retrieving it. So you can ignore such errors and give it a second try to get info.
answered Nov 24 '18 at 0:30
MonicaPCMonicaPC
17718
Don't think it's a region or location property problem. I am using streaming insert which does not require location info. I followed the examples: cloud.google.com/bigquery/…
– ituring
Nov 26 '18 at 10:09
Can you test and see if you still have the error? This is to to eliminate/ validate this theory.
– MonicaPC
Nov 26 '18 at 21:24
This does not help.
– ituring
Nov 28 '18 at 9:09
It looks like a nodejs client libraries issue. Can you define the optional location parameter when you create the table and see if you still get the error? You should also report this issue here
– MonicaPC
Nov 29 '18 at 0:16
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53426385%2fbigquery-insert-error-state-pending-status-code-5%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
It looks like BigQuery is unable to find the geographic location of the job.
Make sure to specify your region in the location property in the jobReference. Here is an github example for nodejs that you can consult.
UPDATE
Check if the job that was not found was retried and successfully done. In streaming it needs a delay between requesting the job and try to retrieving it. So you can ignore such errors and give it a second try to get info.
answered Nov 24 '18 at 0:30
MonicaPCMonicaPC
17718
Don't think it's a region or location property problem. I am using streaming insert which does not require location info. I followed the examples: cloud.google.com/bigquery/…
– ituring
Nov 26 '18 at 10:09
Can you test and see if you still have the error? This is to to eliminate/ validate this theory.
– MonicaPC
Nov 26 '18 at 21:24
This does not help.
– ituring
Nov 28 '18 at 9:09
It looks like a nodejs client libraries issue. Can you define the optional location parameter when you create the table and see if you still get the error? You should also report this issue here
– MonicaPC
Nov 29 '18 at 0:16
add a comment |
0
It looks like BigQuery is unable to find the geographic location of the job.
Make sure to specify your region in the location property in the jobReference. Here is an github example for nodejs that you can consult.
UPDATE
Check if the job that was not found was retried and successfully done. In streaming it needs a delay between requesting the job and try to retrieving it. So you can ignore such errors and give it a second try to get info.
answered Nov 24 '18 at 0:30
MonicaPCMonicaPC
17718
Don't think it's a region or location property problem. I am using streaming insert which does not require location info. I followed the examples: cloud.google.com/bigquery/…
– ituring
Nov 26 '18 at 10:09
Can you test and see if you still have the error? This is to to eliminate/ validate this theory.
– MonicaPC
Nov 26 '18 at 21:24
This does not help.
– ituring
Nov 28 '18 at 9:09
It looks like a nodejs client libraries issue. Can you define the optional location parameter when you create the table and see if you still get the error? You should also report this issue here
– MonicaPC
Nov 29 '18 at 0:16
add a comment |
0
0
0
It looks like BigQuery is unable to find the geographic location of the job.
Make sure to specify your region in the location property in the jobReference. Here is an github example for nodejs that you can consult.
UPDATE
Check if the job that was not found was retried and successfully done. In streaming it needs a delay between requesting the job and try to retrieving it. So you can ignore such errors and give it a second try to get info.
answered Nov 24 '18 at 0:30
MonicaPCMonicaPC
17718
It looks like BigQuery is unable to find the geographic location of the job.
Make sure to specify your region in the location property in the jobReference. Here is an github example for nodejs that you can consult.
UPDATE
Check if the job that was not found was retried and successfully done. In streaming it needs a delay between requesting the job and try to retrieving it. So you can ignore such errors and give it a second try to get info.
answered Nov 24 '18 at 0:30
MonicaPCMonicaPC
17718
edited Mar 6 at 23:09
answered Nov 24 '18 at 0:30
MonicaPCMonicaPC
17718
answered Nov 24 '18 at 0:30
MonicaPCMonicaPC
17718
answered Nov 24 '18 at 0:30
MonicaPCMonicaPC
17718
17718
Don't think it's a region or location property problem. I am using streaming insert which does not require location info. I followed the examples: cloud.google.com/bigquery/…
– ituring
Nov 26 '18 at 10:09
Can you test and see if you still have the error? This is to to eliminate/ validate this theory.
– MonicaPC
Nov 26 '18 at 21:24
This does not help.
– ituring
Nov 28 '18 at 9:09
It looks like a nodejs client libraries issue. Can you define the optional location parameter when you create the table and see if you still get the error? You should also report this issue here
– MonicaPC
Nov 29 '18 at 0:16
add a comment |
Don't think it's a region or location property problem. I am using streaming insert which does not require location info. I followed the examples: cloud.google.com/bigquery/…
– ituring
Nov 26 '18 at 10:09
Can you test and see if you still have the error? This is to to eliminate/ validate this theory.
– MonicaPC
Nov 26 '18 at 21:24
This does not help.
– ituring
Nov 28 '18 at 9:09
It looks like a nodejs client libraries issue. Can you define the optional location parameter when you create the table and see if you still get the error? You should also report this issue here
– MonicaPC
Nov 29 '18 at 0:16
Don't think it's a region or location property problem. I am using streaming insert which does not require location info. I followed the examples: cloud.google.com/bigquery/…
– ituring
Nov 26 '18 at 10:09
Don't think it's a region or location property problem. I am using streaming insert which does not require location info. I followed the examples: cloud.google.com/bigquery/…
– ituring
Nov 26 '18 at 10:09
Can you test and see if you still have the error? This is to to eliminate/ validate this theory.
– MonicaPC
Nov 26 '18 at 21:24
Can you test and see if you still have the error? This is to to eliminate/ validate this theory.
– MonicaPC
Nov 26 '18 at 21:24
This does not help.
– ituring
Nov 28 '18 at 9:09
This does not help.
– ituring
Nov 28 '18 at 9:09
It looks like a nodejs client libraries issue. Can you define the optional location parameter when you create the table and see if you still get the error? You should also report this issue here
– MonicaPC
Nov 29 '18 at 0:16
It looks like a nodejs client libraries issue. Can you define the optional location parameter when you create the table and see if you still get the error? You should also report this issue here
– MonicaPC
Nov 29 '18 at 0:16
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53426385%2fbigquery-insert-error-state-pending-status-code-5%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Can you share the code too?
– Graham Polley
Nov 22 '18 at 12:00
bigquery .dataset('raw') .table(tbl) .insert(rows) .then(() => { console.log(
Inserted ${rows.length} rows); }) .catch(err => { if (err && err.name === 'PartialFailureError') { if (err.errors && err.errors.length > 0) { console.log('Insert errors:'); err.errors.forEach(err => console.error(err)); } } else { console.error('BQ INGEST ERROR CUST RAW:', err); } }); };– ituring
Nov 22 '18 at 13:31
Audit log entry you provided corresponds to a failed request to retrieve job results (cloud.google.com/bigquery/docs/reference/rest/v2/jobs/…). And based on the user agent it was made using github.com/googleapis/google-cloud-dotnet. Can you attach a proper streaming insert response as defined at cloud.google.com/bigquery/docs/reference/rest/v2/tabledata/…?
– Nikita Uchaev
Dec 13 '18 at 10:59