Sorry about the late response... it's been an exciting week :) I'm not hammering BQ yet. Probably a few dozen requests a minute at peak.
The problem does not appear to be in BQ itself; I'm not even getting a jobid back. It's also not just queries; I also get errors periodically from insertAll and creating tables. It's the same opaque "Could not fetch URL" - not timeout, nothing that explains the underlying cause. Here's a representative stacktrace: java.io.IOException: Could not fetch URL: https://www.googleapis.com/bigquery/v2/projects/gearlaunch-hub/datasets/orders/tables/orders_20150825 at com.google.appengine.api.urlfetch.URLFetchServiceImpl.convertApplicationException (URLFetchServiceImpl.java:140) at com.google.appengine.api.urlfetch.URLFetchServiceImpl.fetch ( URLFetchServiceImpl.java:45) at com.google.api.client.extensions.appengine.http.UrlFetchRequest.execute ( UrlFetchRequest.java:74) at com.google.api.client.http.HttpRequest.execute (HttpRequest.java:972) "Could not fetch URL" sounds like a DNS failure or something like that. But there's no way that could happen for www.googleapis.com, right? Thanks, Jeff On Thu, Aug 20, 2015 at 1:43 PM, Patrice (Cloud Platform Support) < pvoutsi...@google.com> wrote: > Hi Jeff, > > Just a quick check to be sure : Are you hammering the server with those > requests? Just to make sure there's not a burst limit holding you back. > > In general, whenever you make those requests, are you sure the underlying > query finished running? > > Normally I would suggest you give me an example of a jobID that returned > this with a timestamp and relevant data, and then send this to the BQ team. > But the BQ team is highly active on StackOverflow, and do these checks if > all the relevant information is provided. > > Cheers! > > > On Thursday, August 20, 2015 at 12:11:51 PM UTC-4, Jeff Schnitzer wrote: >> >> I'm getting a lot of "Could not fetch URL" errors from BigQuery. I'm not >> driving significant amounts of traffic to it (yet), but I get one of these >> maybe every 50 or so queries: >> >> Could not fetch URL: >> https://www.googleapis.com/bigquery/v2/projects/gearlaunch-hub/queries >> >> I'm using the standard google-published bigquery client library (Java). >> Any idea what is wrong? I don't have problems fetching from any other >> service. >> >> I'm ramping up traffic next week and this is going to start happening a >> lot.... >> >> Thanks, >> Jeff >> > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to google-appengine+unsubscr...@googlegroups.com. > To post to this group, send email to google-appengine@googlegroups.com. > Visit this group at http://groups.google.com/group/google-appengine. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-appengine/19ac2e15-72b3-4189-ac26-a09674bcf8fd%40googlegroups.com > <https://groups.google.com/d/msgid/google-appengine/19ac2e15-72b3-4189-ac26-a09674bcf8fd%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-appengine+unsubscr...@googlegroups.com. To post to this group, send email to google-appengine@googlegroups.com. Visit this group at http://groups.google.com/group/google-appengine. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/CADK-0uiQ4hhNZyAwA35uv0PK%3D3xP5GZ80n1jaosPyxxtH7vSaA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
