0

Getting inconsistent answers for the last few days

Hi - I was wondering if anyone else is having the same problem I'm having.

I have some YQL queries that I use that are coming back with different answers sometimes. If I re-run the query 10 or 20 times in a row, one time the answer will be wrong. This is either in our application or if I use the console.

Is this a known issue? Has something changed? Does anyone else have a problem like this one?

Our code has been live for a very long time without any changes.

by
19 Replies
  • Can you provide an example of something that exhibits the behavior? We can take a look and see if we can pinpoint anything.
    0
  • Sure - I tested this in the YQL console.

    Query: select * FROM yahoo.identity where yid='spulara'

    Here's where it works:

    CODEBOX
    <?xml version="1.0" encoding="UTF-8"?>
    <query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng"
    yahoo:count="1" yahoo:created="2011-06-28T03:53:21Z" yahoo:lang="en-US">
    <diagnostics>
    <publiclyCallable>false</publiclyCallable>
    <url execution-time="58"><![CDATA[http://profiles.yahoo.com/v2/identities.handle(spulara~yid)]]></url>
    <user-time>61</user-time>
    <service-time>58</service-time>
    <build-version>19081</build-version>
    </diagnostics>
    <results>
    <identity>
    <guid>2YSHPLQ5SKSJRZZZQJS5327DDU</guid>
    </identity>
    </results>
    </query>

    But if I click the 'test' button enough in the console, I eventually get this:

    CODEBOX
    <?xml version="1.0" encoding="UTF-8"?>
    <query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng"
    yahoo:count="0" yahoo:created="2011-06-28T03:54:06Z" yahoo:lang="en-US">
    <diagnostics>
    <publiclyCallable>false</publiclyCallable>
    <url execution-time="58" http-status-code="404" http-status-message="Not Found"><![CDATA[http://profiles.yahoo.com/v2/identities.handle(spulara~yid)]]></url>
    <user-time>61</user-time>
    <service-time>58</service-time>
    <build-version>19081</build-version>
    </diagnostics>
    <results/>
    </query>
    0
  • The best answer we've come up with - which still is pretty horrible - is to re-run the query on negative results to make sure it's *really* negative. That seems...pretty yucky to have to do; but it's the best we can come up with so far.

    I figure if it's one of the back-end servers being down, I could maybe just ignore that one server; but there's no reporting as to which server serviced the request that I can see.
    0
  • <font face="Arial">Last post didn&#39;t work so well; let&#39;s try this again:<br><br>Recently, I&#39;ve been having problems with YQL, even in the console. Sometimes I get a partial answer, and sometimes I get no answer at all. When the latter is true, the result contains the following:<br><span style="line-height:13px;white-space:pre;"><span class="sc3" style="color:#000080;"><span class="re1" style="color:#000000;font-weight:normal;"></span></span><span class="sc3"><span class="re1" style="color:#000000;font-weight:normal;">&lt;url</span><font color="#000080"> </font><span class="re0" style="color:#008080;">error</span><span class="sy0" style="color:#000000;">=</span><span class="st0" style="color:#dd1144;">&quot;Connect Failure&quot;</span><font color="#000080"> </font><span class="re0" style="color:#008080;">execution-time</span><span class="sy0" style="color:#000000;">=</span><span class="st0" style="color:#dd1144;">&quot;5003&quot;</span><span class="re4" style="color:#000000;font-weight:normal;">&gt;</span><span class="re2" style="color:#cccccc;font-weight:normal;">&lt;!<span class="br0">[</span>CDATA<span class="br0">[</span></span><font color="#000080">http://fantasysports.yahooapis.com/fantasy/v2/players;</font><span class="re0" style="color:#008080;">player_keys</span><span class="sy0" style="color:#000000;">=</span><font color="#000080">248.p.1772</font><span class="re3" style="color:#cccccc;font-weight:normal;"><span class="br0">]</span><span class="br0">]</span><span class="re4" style="color:#cccccc;font-weight:normal;">&gt;</span></span><span class="re1" style="font-weight:normal;">&lt;/url<span class="re4" style="font-weight:normal;">&gt;<font color="#000080"></font></span></span></span><span class="sc3"><span class="re1" style="font-weight:normal;"><span class="re4" style="font-weight:normal;"><font color="#000080"></font>This was done in the YQL console with the following query:select name.full from fantasysports.players where player_key = &#39;248.p.1772&#39;When I get a result, it&#39;s pretty fast, but when I get no result, it takes a couple of seconds to return. I&#39;m getting the same thing in my clojure code as well.Rarely, I&#39;ll get the whole answer, but usually it&#39;s just partial. If I do a query for multiple players, I might get a handful, but almost never all of them.</span></span></span></span></font>
    0
  • I&#39;ve having the same issues querying yahoo.finance.historicaldata using the following query:<br><br>select * from yahoo.finance.historicaldata where symbol = &quot;000001.sz&quot; and startDate = &quot;2011-07-28&quot; and endDate = &quot;2011-08-04&quot;<br><br>When I try this query over and over (from both the console and a PHP script), about half of the responses don&#39;t include 2011-08-04, the endDate, in the result. The other half do.<br><br>When I try this using the console, I&#39;m logged in. When I query via my script, I&#39;m using oAuth. There doesn&#39;t seem to be any rhyme or reason to the inconsistent and incomplete data responses.<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(Brady @ 27 Jun 2011 12:30 PM)</cite><blockquote class="quotemain">Hi - I was wondering if anyone else is having the same problem I&#39;m having.<br><br>I have some YQL queries that I use that are coming back with different answers sometimes. If I re-run the query 10 or 20 times in a row, one time the answer will be wrong. This is either in our application or if I use the console.<br><br>Is this a known issue? Has something changed? Does anyone else have a problem like this one?<br><br>Our code has been live for a very long time without any changes.</blockquote></div></div>
    0
  • I can confirm this problem. I&#39;m querying data from Yahoo finance though YQL, and am getting old data regularly. It can be reproduced by reloading <a href="http://query.yahooapis.com/v1/public/yql?q=select%20symbol%2CLastTradeDate%2CChangePercentRealtime%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22%5EBVSP%22%2C%20%22%5EGDAXI%22%2C%20%22INDU%22%2C%22%5EHSI%22%2C%20%22%5EIXIC%22%2C%22%5EN225%22%2C%20%22%5EOMXSPI%22%2C%20%22%5EGSPC%22%29&env=http%3A%2F%2Fdatatables.org%2Falltables.env">this public URL</a> around 10 times. For me the problem does not occur in the Console (<a href="http://developer.yahoo.com/yql/console/?q=select%20symbol%2CLastTradeDate%2CChangePercentRealtime%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22%5EBVSP%22%2C%20%22%5EGDAXI%22%2C%20%22INDU%22%2C%22%5EHSI%22%2C%20%22%5EIXIC%22%2C%22%5EN225%22%2C%20%22%5EOMXSPI%22%2C%20%22%5EGSPC%22%29%0A%09%09&env=http%3A%2F%2Fdatatables.org%2Falltables.env">permlink to query in Console</a>). Notice that using the public URL you sometimes get data with LastTradeDate older than the last time you reloaded it. I think this may be caused by the backend system, because I am getting the same old data when using the nonofficial way of querying Yahoo finance <a href="http://www.gummy-stuff.org/Yahoo-data.htm">described here</a>.
    0
  • I can confirm this problem. I&#39;m querying data from Yahoo finance though YQL, and am getting old data regularly. It can be reproduced by reloading <a href="http://query.yahooapis.com/v1/public/yql?q=select%20symbol%2CLastTradeDate%2CChangePercentRealtime%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22%5EBVSP%22%2C%20%22%5EGDAXI%22%2C%20%22INDU%22%2C%22%5EHSI%22%2C%20%22%5EIXIC%22%2C%22%5EN225%22%2C%20%22%5EOMXSPI%22%2C%20%22%5EGSPC%22%29&env=http%3A%2F%2Fdatatables.org%2Falltables.env">this public URL</a> around 10 times. For me the problem does not occur in the Console (<a href="../../../../yql/console/?q=select%20symbol%2CLastTradeDate%2CChangePercentRealtime%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22%5EBVSP%22%2C%20%22%5EGDAXI%22%2C%20%22INDU%22%2C%22%5EHSI%22%2C%20%22%5EIXIC%22%2C%22%5EN225%22%2C%20%22%5EOMXSPI%22%2C%20%22%5EGSPC%22%29%0A%09%09&env=http%3A%2F%2Fdatatables.org%2Falltables.env">permlink to query in Console</a>). Notice that using the public URL you sometimes get data with LastTradeDate older than the last time you reloaded it. I think this may be caused by the backend system, because I am getting the same old data when using the nonofficial way of querying Yahoo finance <a href="http://www.gummy-stuff.org/Yahoo-data.htm">described here</a>.
    0
  • I&#39;ve been seeing a similar issues....prices seem to be incorrect on quotes.<br><br>as a simple test:<br><br>curl &quot;<a href="http://download.finance.yahoo.com/d/quotes.csv?s=BARC.L&f=abb4c1c8d2e7f6jg3g6j1j5k2k5l2m2m5m8op2qr2r7s7t7v1w1ya2b2b6c3dee8gkg4ij3j6k3ll3m3m6npp5rr5st1t8v7w4a5b3cc6d1e1e9hg1g5i5j4k1k4l1mm4m7n4p1p6r1r6s1t6vwx&e=.csv">http://download.finance.yahoo.com/d/quotes.csv?s=BARC.L&f=abb4c1c8d2e7f6jg3g6j1j5k2k5l2m2m5m8op2qr2r7s7t7v1w1ya2b2b6c3dee8gkg4ij3j6k3ll3m3m6npp5rr5st1t8v7w4a5b3cc6d1e1e9hg1g5i5j4k1k4l1mm4m7n4p1p6r1r6s1t6vwx&e=.csv</a>&quot;<br><br>some queries will be correct displaying data as on the webpage, but frequently it comes back with 216.8 which is way off what it is right now.<br><br>Having a Wrong price is worse than no price atall!<br><br>The same happens through YQL, but oddly not through the website. <br><br>Can someone tell me whats happening...and when it might be fixed....its been like this for atleast a week, possibly longer.<br><br>Cliff.<br><br><div class="quote"><div class="quotetop">QUOTE<cite>(ssbean @ 4 Aug 2011 10:56 PM)</cite></div><blockquote class="quotemain">I&#39;ve having the same issues querying yahoo.finance.historicaldata using the following query:<br><br>select * from yahoo.finance.historicaldata where symbol = &quot;000001.sz&quot; and startDate = &quot;2011-07-28&quot; and endDate = &quot;2011-08-04&quot;<br><br>When I try this query over and over (from both the console and a PHP script), about half of the responses don&#39;t include 2011-08-04, the endDate, in the result. The other half do.<br><br>When I try this using the console, I&#39;m logged in. When I query via my script, I&#39;m using oAuth. There doesn&#39;t seem to be any rhyme or reason to the inconsistent and incomplete data responses.<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(Brady @ 27 Jun 2011 12:30 PM)</cite><blockquote class="quotemain">Hi - I was wondering if anyone else is having the same problem I&#39;m having.<br><br>I have some YQL queries that I use that are coming back with different answers sometimes. If I re-run the query 10 or 20 times in a row, one time the answer will be wrong. This is either in our application or if I use the console.<br><br>Is this a known issue? Has something changed? Does anyone else have a problem like this one?<br><br>Our code has been live for a very long time without any changes.</blockquote></div></div></blockquote></div>
    0
  • I&#39;ve been seeing similar when trying to get:<br><br>curl &quot;<a href="http://download.finance.yahoo.com/d/quotes.csv?s=BARC.L&f=abb4c1c8d2e7f6jg3g6j1j5k2k5l2m2m5m8op2qr2r7s7t7v1w1ya2b2b6c3dee8gkg4ij3j6k3ll3m3m6npp5rr5st1t8v7w4a5b3cc6d1e1e9hg1g5i5j4k1k4l1mm4m7n4p1p6r1r6s1t6vwx&e=.csv">http://download.finance.yahoo.com/d/quotes.csv?s=BARC.L&f=abb4c1c8d2e7f6jg3g6j1j5k2k5l2m2m5m8op2qr2r7s7t7v1w1ya2b2b6c3dee8gkg4ij3j6k3ll3m3m6npp5rr5st1t8v7w4a5b3cc6d1e1e9hg1g5i5j4k1k4l1mm4m7n4p1p6r1r6s1t6vwx&e=.csv</a>&quot;<br><br>the response is correct a few times, then it gives a completely wrong answer. 216.8 - Its been doing it atleast a week now. <br><br>A Wrong answer is worse than no answer!<br><br><div class="quote"><div class="quotetop">QUOTE<cite>(ssbean @ 4 Aug 2011 10:56 PM)</cite></div><blockquote class="quotemain">I&#39;ve having the same issues querying yahoo.finance.historicaldata using the following query:<br><br>select * from yahoo.finance.historicaldata where symbol = &quot;000001.sz&quot; and startDate = &quot;2011-07-28&quot; and endDate = &quot;2011-08-04&quot;<br><br>When I try this query over and over (from both the console and a PHP script), about half of the responses don&#39;t include 2011-08-04, the endDate, in the result. The other half do.<br><br>When I try this using the console, I&#39;m logged in. When I query via my script, I&#39;m using oAuth. There doesn&#39;t seem to be any rhyme or reason to the inconsistent and incomplete data responses.<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(Brady @ 27 Jun 2011 12:30 PM)</cite><blockquote class="quotemain">Hi - I was wondering if anyone else is having the same problem I&#39;m having.<br><br>I have some YQL queries that I use that are coming back with different answers sometimes. If I re-run the query 10 or 20 times in a row, one time the answer will be wrong. This is either in our application or if I use the console.<br><br>Is this a known issue? Has something changed? Does anyone else have a problem like this one?<br><br>Our code has been live for a very long time without any changes.</blockquote></div></div></blockquote></div>
    0
  • Hi,<br><br>I can confirm this issue, querying yahoo.finance.quotes. The problem only occurs for me when using the public URL, not on the console. Here is a public URL that shows the problem. Reload this URL 10-20 times and notice that sometimes you get old ata. It can be seen by the fact that LastTradeDate suddenly is several days old. This is stopping me from using this service altogether, which seams is a shame since it is just what I am looking for. I believe the problem has started happening a few weeks ago.<br><br>Josh, please let me know what I can do to help further debug this problem. I&#39;m very interested in seeing it resolved.<br><br>For your reference, here is the query used to create the above mentioned public URL:<br><br>select symbol, LastTradeDate, ChangePercentRealtime from yahoo.finance.quotes where symbol in (&quot;^BVSP&quot;,&quot;^GDAXI&quot;,&quot;INDU&quot;,^HSI&quot;,&quot;^IXIC&quot;,^N225&quot;,&quot;^OMXSPI&quot;, &quot;^GSPC&quot;)
    0
  • I missed some double quotes in the query I provided. The correct one should be the following:<br><br>select symbol, LastTradeDate, ChangePercentRealtime from yahoo.finance.quotes where symbol in (&quot;^BVSP&quot;,&quot;^GDAXI&quot;,&quot;INDU&quot;,&quot;^HSI&quot;,&quot;^IXIC&quot;,&quot;^N225&quot;,&quot;^OMXSPI&quot;, &quot;^GSPC&quot;)<br>
    0
  • I missed to include the public URL also. Here it is: <a href="http://query.yahooapis.com/v1/public/yql?q=select%20symbol%2CLastTradeDate%2CChangePercentRealtime%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22%5EBVSP%22%2C%20%22%5EGDAXI%22%2C%20%22INDU%22%2C%22%5EHSI%22%2C%20%22%5EIXIC%22%2C%22%5EN225%22%2C%20%22%5EOMXSPI%22%2C%20%22%5EGSPC%22%29&env=http%3A%2F%2Fdatatables.org%2Falltables.env">public URL</a>.<br>
    0
  • I also missed including the public URL. Here it is: <span style="text-decoration:underline;"><a href="http://query.yahooapis.com/v1/public/yql?q=select%20symbol%2CLastTradeDate%2CChangePercentRealtime%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22%5EBVSP%22%2C%20%22%5EGDAXI%22%2C%20%22INDU%22%2C%22%5EHSI%22%2C%20%22%5EIXIC%22%2C%22%5EN225%22%2C%20%22%5EOMXSPI%22%2C%20%22%5EGSPC%22%29&env=http%3A%2F%2Fdatatables.org%2Falltables.env">public URL</a>.</span><br>
    0
  • I forgot the public url. Here it is: <a href="http://query.yahooapis.com/v1/public/yql?q=select%20symbol%2CLastTradeDate%2CChangePercentRealtime%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22%5EBVSP%22%2C%20%22%5EGDAXI%22%2C%20%22INDU%22%2C%22%5EHSI%22%2C%20%22%5EIXIC%22%2C%22%5EN225%22%2C%20%22%5EOMXSPI%22%2C%20%22%5EGSPC%22%29&env=http%3A%2F%2Fdatatables.org%2Falltables.env">public URL</a>.
    0
  • <a href="http://query.yahooapis.com/v1/public/yql?q=select%20symbol%2CLastTradeDate%2CChangePercentRealtime%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22%5EBVSP%22%2C%20%22%5EGDAXI%22%2C%20%22INDU%22%2C%22%5EHSI%22%2C%20%22%5EIXIC%22%2C%22%5EN225%22%2C%20%22%5EOMXSPI%22%2C%20%22%5EGSPC%22%29&env=http%3A%2F%2Fdatatables.org%2Falltables.env">Public URL</a><br><div class="quote"><div class="quotetop">QUOTE<cite>(Gizero @ 9 Aug 2011 7:09 PM)</cite></div><blockquote class="quotemain">I missed some double quotes in the query I provided. The correct one should be the following:<br><br>select symbol, LastTradeDate, ChangePercentRealtime from yahoo.finance.quotes where symbol in (&quot;^BVSP&quot;,&quot;^GDAXI&quot;,&quot;INDU&quot;,&quot;^HSI&quot;,&quot;^IXIC&quot;,&quot;^N225&quot;,&quot;^OMXSPI&quot;, &quot;^GSPC&quot;)<br></blockquote></div>
    0
  • Here is the public URL I meant to include: <a><a href="http://query.yahooapis.com/v1/public/yql?q=select%20symbol%2CLastTradeDate%2CChangePercentRealtime%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22^BVSP%22%2C%20%22^GDAXI%22%2C%20%22INDU%22%2C%22^HSI%22%2C%20%22^IXIC%22%2C%22^N225%22%2C%20%22^OMXSPI%22%2C%20%22^GSPC%22%29&env=http%3A%2F%2Fdatatables.org%2Falltables.env">public URL</a></a>.<br><br><div class="quote"><div class="quotetop">QUOTE<cite>(Gizero @ 9 Aug 2011 7:09 PM)</cite></div><blockquote class="quotemain">I missed some double quotes in the query I provided. The correct one should be the following:<br><br>select symbol, LastTradeDate, ChangePercentRealtime from yahoo.finance.quotes where symbol in (&quot;^BVSP&quot;,&quot;^GDAXI&quot;,&quot;INDU&quot;,&quot;^HSI&quot;,&quot;^IXIC&quot;,&quot;^N225&quot;,&quot;^OMXSPI&quot;, &quot;^GSPC&quot;)<br></blockquote></div>
    0
  • Public URL:<br><br><a href="http://query.yahooapis.com/v1/public/yql?q=select%20symbol%2CLastTradeDate%2CChangePercentRealtime%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22^BVSP%22%2C%20%22^GDAXI%22%2C%20%22INDU%22%2C%22^HSI%22%2C%20%22^IXIC%22%2C%22^N225%22%2C%20%22^OMXSPI%22%2C%20%22^GSPC%22%29&env=http%3A%2F%2Fdatatables.org%2Falltables.env">http://query.yahooapis.com/v1/public/yql?q=select%20symbol%2CLastTradeDate%2CChangePercentRealtime%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22^BVSP%22%2C%20%22^GDAXI%22%2C%20%22INDU%22%2C%22^HSI%22%2C%20%22^IXIC%22%2C%22^N225%22%2C%20%22^OMXSPI%22%2C%20%22^GSPC%22%29&env=http%3A%2F%2Fdatatables.org%2Falltables.env</a><br><br><div class="quote"><div class="quotetop">QUOTE<cite>(Gizero @ 9 Aug 2011 7:09 PM)</cite></div><blockquote class="quotemain">I missed some double quotes in the query I provided. The correct one should be the following:<br><br>select symbol, LastTradeDate, ChangePercentRealtime from yahoo.finance.quotes where symbol in (&quot;^BVSP&quot;,&quot;^GDAXI&quot;,&quot;INDU&quot;,&quot;^HSI&quot;,&quot;^IXIC&quot;,&quot;^N225&quot;,&quot;^OMXSPI&quot;, &quot;^GSPC&quot;)<br></blockquote></div>
    0
  • i thinks this form page hvae some problem alot off solution is not read wany one resolve this problem write the fix plss 










    ukash
    0
  • Thanks a lot. I am working for an e-ticaret in my country and I was looking this code.

    Thank you so much

    0

Recent Posts

in YQL