sijocherian / google-bigquery

Automatically exported from code.google.com/p/google-bigquery
0 stars 0 forks source link

Error 500 : Backend Error #135

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
When I run a simple Query, sometimes works, sometimes I get this message:

/* Error in runSyncQuery:'{\n "error": {\n  "errors": [\n   {\n    "domain": 
"global",\n    "reason": "backendError",\n    "message": "Backend Error"\n   
}\n  ],\n  "code": 500,\n  "message": "Backend Error"\n }\n}\n'
None */

My system is down. Can anyone help me?

My project id : poc-big-query-815

Original issue reported on code.google.com by bthi...@gmail.com on 13 Aug 2014 at 1:50

GoogleCodeExporter commented 9 years ago
Python scripts are executing the queries

Original comment by bthi...@gmail.com on 13 Aug 2014 at 1:53

GoogleCodeExporter commented 9 years ago
This looks like a problem with the API infrastructure that sits in front of 
BigQuery, rather than with BigQuery's servers. Most likely, your query never 
even got to BigQuery.

Generally speaking, the solution to these problems is to retry your query 
requests. If you want to avoid creating duplicate query jobs, you can create 
your queries by calling jobs.insert with a client-generated job ID, and retry 
on the same job ID when necessary. Our API guarantees that you can only create 
a given job ID once, so as soon as you see a response that says that your 
jobs.insert succeeded (or that it failed because the job ID was already known), 
then you can stop retrying.

I'm going to close this bug to keep things tidy, but don't hesitate to reopen 
if you have further questions or problems.

Original comment by jcon...@google.com on 14 Aug 2014 at 10:41

GoogleCodeExporter commented 9 years ago
All right. Thanks :)

Original comment by bthi...@gmail.com on 15 Aug 2014 at 12:13