[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
Federico
On Tue, Apr 28, 2020 at 2:25 PM Federico Leva (Nemo) nemowiki@gmail.com 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.
Thank you, makes sense. My "normal" queries seem ok now and the longer ones can wait until after the maintenance.
Have a nice day, Federico
On Apr 28, 2020, at 8:31 AM, Manuel Arostegui marostegui@wikimedia.org wrote:
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).
Is there any ETA on when the query killer will get back to normal?
On Thu, Apr 30, 2020 at 2:49 PM Russell Blau russblau@imapmail.org wrote:
On Apr 28, 2020, at 8:31 AM, Manuel Arostegui marostegui@wikimedia.org wrote:
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).
Is there any ETA on when the query killer will get back to normal?
Hello,
The query killer is now killing queries longer than 1h. Unfortunately the maintenance will take a few more days, as we are facing some unexpected issues. If you want to follow this progress, this is the task we are using: https://phabricator.wikimedia.org/T249188
Sorry for the inconvenience. Manuel.
Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud