[Labs-l] Query takes forever on labsdb

Sat Aug 29 20:36:44 UTC 2015

Looks like it works on labsdb1001, but not labsdb1002 and labsdb1003.

On 29 August 2015 at 20:38, Huji Lee <huji.huji at gmail.com> wrote:

> Hi,
>
> When I run this query <http://quarry.wmflabs.org/query/3760> using Quarry
> I get a result in less than one minute. When I run that on tools via the
> mysql command line, it never finishes.
>
> It is interesting because many other queries that I run on labsdb via
> command line work fine. Only this query is slow. It was suggested on the
> IRC that this could be due to caching issues. I waited for 24 hours and
> repeated the experiment and same results occurred.
>
> I also thought maybe the instance of labsdb that I access via "become
> huji" is faulty. So I created a job for it and run it via jsub, but that
> job has also been stalling for close to half an hour now.
>
> Since this is not a particularly complex query (simply a join of three
> tables) and this exact query used to run very quickly on labsdb before.
>
> Any advice on how to resolve the issue is appreciated.
>
> Thanks,
>
> 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/20150829/2f88e600/attachment.html>