[Labs-l] Query results are inconsistent between DBs

Mon Jan 18 00:04:33 UTC 2016

How can I ask for that replica to be synchronized? Phabricator task?

On Fri, Jan 15, 2016 at 8:29 PM, John <phoenixoverride at gmail.com> wrote:

> 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
>>
>>
>
> _______________________________________________
> 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/20160117/26540b97/attachment.html>