0

YQL returning no data randomly?

I'm developing an app on App Engine and YQL is giving me some serious headaches. I use it extensively and it seems YQL returns JSON with no data completely randomly. For example, I click on a link, YQL fetches data... and it turns out to be empty. A few seconds later I click on the same link that runs the same query and it'll actually get usable data. For some reason this doesn't happen when i'm developing locally on my PC, but it happens very frequently when it's deployed on the server. At first I thought it had something to do with using the public API so I signed up for a key and re-wrote my code to use it, but i'm still having the same problem. It's completely random and very frustrating.

Any help? An unreliable tool is a useless tool.

13 Replies
  • Are you using an open table? If you are you can pass along debug=true as a query parameter in your request. Documented here:

    http://developer.yahoo.com/yql/guide/yql-n...rk-logging.html

    This should isolate the issue as being a downstream issue or a quirk within YQL.
    0
  • QUOTE (The Josh @ Jan 27 2011, 10:58 PM) <{POST_SNAPBACK}>
    Are you using an open table? If you are you can pass along debug=true as a query parameter in your request. Documented here:

    http://developer.yahoo.com/yql/guide/yql-n...rk-logging.html

    This should isolate the issue as being a downstream issue or a quirk within YQL.


    No, it's not an open table.
    0
  • QUOTE (radical.dreamer@... @ Jan 27 2011, 11:47 PM) <{POST_SNAPBACK}>
    No, it's not an open table.


    it seems I have the same issue.

    if you click on this url and refresh it a few times you'll notice that teh data is returned sometimes but other times the result is null
    http://query.yahooapis.com/v1/public/yql?c...ltableswithkeys
    0
  • The same happens to us: even from YQL console the same query, e.g. select * from music.artist.search where keyword="Madonna", returns results and one moment later does not.

    Any ideas on what the cause is?

    Needless to say that it is impossible to deploy an application that depends on such a behavior: this is causing us a delay in our project. We would like to stay with yahoo as a data provider, but in this condition it is not feasible. Please, give us at least a clue on how to make it work: we use the music tables (I guess they are public tables).

    Thanks.

    Al
    0
  • QUOTE (radical.dreamer@... @ Jan 27 2011, 11:47 PM) <{POST_SNAPBACK}>
    No, it's not an open table.


    Please provide a sample query.
    0
  • QUOTE (DJ LT @ Jan 28 2011, 09:41 AM) <{POST_SNAPBACK}>
    it seems I have the same issue.

    if you click on this url and refresh it a few times you'll notice that teh data is returned sometimes but other times the result is null
    http://query.yahooapis.com/v1/public/yql?c...ltableswithkeys


    Did the network logging return you any information about what was coming back from the downstream service? (add debug=true and follow the guidelines in the twiki above to capture network debug)
    0
  • QUOTE (Alberto @ Feb 2 2011, 05:35 AM) <{POST_SNAPBACK}>
    The same happens to us: even from YQL console the same query, e.g. select * from music.artist.search where keyword="Madonna", returns results and one moment later does not.

    Any ideas on what the cause is?

    Needless to say that it is impossible to deploy an application that depends on such a behavior: this is causing us a delay in our project. We would like to stay with yahoo as a data provider, but in this condition it is not feasible. Please, give us at least a clue on how to make it work: we use the music tables (I guess they are public tables).

    Thanks.

    Al


    When you don't get any data back, does that mean a response from YQL that contains 0 results or are you literally getting no bytes back from YQL? Where are most of your calls initiated from geographically (US East Coast/Europe...). If you can help us pinpoint the behavior we can try and track down the issue. I've run a fairly high load of requests and haven't seen the behavior myself.
    0
  • QUOTE (The Josh @ Feb 3 2011, 01:58 PM) <{POST_SNAPBACK}>
    When you don't get any data back, does that mean a response from YQL that contains 0 results or are you literally getting no bytes back from YQL? Where are most of your calls initiated from geographically (US East Coast/Europe...). If you can help us pinpoint the behavior we can try and track down the issue. I've run a fairly high load of requests and haven't seen the behavior myself.


    Josh, I've had the same problem:

    select * from yql.query.multi where queries='select * from html where url="http://en.wikipedia.org/wiki/French_food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Italian_food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Chinese_Food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Indian_Food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Mexican_cuisine" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Thai_food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Japanese_food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Greek_Food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Spanish_food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Lebanese_Food" and xpath="/html/head/title";'

    Its a big request, but when running around 3-4 urls the console it works 80% of the time, in console, 60% of the time it will return all 10 results, however the rest request always fails.

    It returns a fully formed response with 10 entries, but they are all null. Occasionally 1 or 2 of the 10 will have the requested title.

    I'm in the UK.

    edit: Just ran the request all 10 returned fine...
    0
  • 4 request returned fine, now all null again....
    0
  • Josh, the above request has been working for an hour now, but has broken again below is the query and the response, I'm not cache-busting, the params are the same and I've disabled jQuery's own unique ID callback param.

    select * from yql.query.multi where queries='select * from html where url="http://en.wikipedia.org/wiki/French_food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Italian_food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Chinese_Food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Indian_Food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Mexican_cuisine" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Thai_food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Japanese_food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Greek_Food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Spanish_food" and xpath="/html/head/title";select * from html where url="http://en.wikipedia.org/wiki/Lebanese_Food" and xpath="/html/head/title";'


    link_cbfunc({"query":{"count":10,"created":"2011-02-04T14:38:43Z","lang":"en-US","results":{"results":[null,null,null,null,null,null,null,null,null,null]}}});
    0
  • Hi,

    I have the same problem as the above.

    Sometimes 'result' contains data some times no data. :(Nigel Crawley
    0
    • Apr 25, 2012
    I have the same problem. Can it be, that this problem is, 12 months after reporting it, still not fixed? :-/
    0
    • Apr 25, 2012
    &nbsp;Anyone else seeing this today? &nbsp;I&#39;m getting result: null with YQL and oauth request for social profile data.<br>
    0

Recent Posts

in YQL