On Tue, Apr 28, 2020 at 2:25 PM Federico Leva (Nemo) <[email protected]> wrote:
> [Again in the saga of me trying to query the revision and logging tables > against comment text and usernames...] > > Am I dreaming or is the timeout on DB queries today something like 2 > minutes? Is it a temporary measure? Is a query killer particularly > aggressive due to some overload? Should we expect this to last? > > This query works: > > MariaDB [enwiki_p]> select count(*) from revision where rev_id > > 950000000 AND rev_comment_id = 1334144; > > +----------+ > | count(*) | > +----------+ > | 174 | > +----------+ > 1 row in set (1 min 57.35 sec) > > A slightly bigger one times out pretty quick: > > MariaDB [enwiki_p]> select count(*) from revision where rev_id > > 930000000 AND rev_comment_id = 1334144; > ERROR 2013 (HY000): Lost connection to MySQL server during query > > This is because we are doing maintenance on the usual host that serves the slow queries, and we placed a different one and we (I) didn't change the query killer, which kills queries after 5 minutes. I am going to change it now, to give it some more room (but won't set the 4h query, as we need a balance there now that we are serving with less hosts). Thanks for pointing this out Manuel.
_______________________________________________ Wikimedia Cloud Services mailing list [email protected] (formerly [email protected]) https://lists.wikimedia.org/mailman/listinfo/cloud
