[Labs-l] Query results are inconsistent between DBs

Sat Jan 16 01:29:04 UTC 2016

Just ran the query across all three DB servers and labsdb1003.eqiad.wmnet
is the culprit

On Fri, Jan 15, 2016 at 8:21 PM, Huji Lee <huji.huji at gmail.com> wrote:

> When I run this query on Quarry:
>
> https://quarry.wmflabs.org/query/6855
>
> I get 17 results, all of which are unused images. When my bot runs the
> exact same query, it gets 18 results, as shown on this FA WP page
> <https://fa.wikipedia.org/wiki/%D9%88%DB%8C%DA%A9%DB%8C%E2%80%8C%D9%BE%D8%AF%DB%8C%D8%A7:%DA%AF%D8%B2%D8%A7%D8%B1%D8%B4_%D8%AF%DB%8C%D8%AA%D8%A7%D8%A8%DB%8C%D8%B3/%D9%BE%D8%B1%D9%88%D9%86%D8%AF%D9%87%E2%80%8C%D9%87%D8%A7%DB%8C_%D8%BA%DB%8C%D8%B1_%D8%A2%D8%B2%D8%A7%D8%AF_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D9%86%D8%B4%D8%AF%D9%87>
> .
>
> The one extra is
> Image:Taylor_Swift_-_Wildest_Dreams_(Official_Single_Cover).png
> <https://fa.wikipedia.org/wiki/%D9%BE%D8%B1%D9%88%D9%86%D8%AF%D9%87:Taylor_Swift_-_Wildest_Dreams_%28Official_Single_Cover%29.png>
> which is NOT an unused image (it is used in one page on FA WP). It seems
> the DB instances that the bot hits is inconsistent. The bot is called
> HujiBot and is hosted on Labs servers.
>
> If you need me to run additional comments to pinpoint the root cause
> please let me know.
>
> Best,
>
> Huji
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20160115/aa47bb76/attachment.html>