[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.