[Labs-l] Query results are inconsistent between DBs

Mon Jan 18 01:05:13 UTC 2016

On 1/17/16 4:04 PM, Huji Lee wrote:
> How can I ask for that replica to be synchronized? Phabricator task?

Yes, please open a phabricator case. Also be warned that our one and 
only DBA is on holiday so it may be a few days before we're able to 
address it adequately.

-Andrew
>
> On Fri, Jan 15, 2016 at 8:29 PM, John <phoenixoverride at gmail.com 
> <mailto: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
>     <mailto: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 <mailto:Labs-l at lists.wikimedia.org>
>         https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>
>
>     _______________________________________________
>     Labs-l mailing list
>     Labs-l at lists.wikimedia.org <mailto: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/17d9e70b/attachment.html>