Either tsbot or the Query killer are broken I just got an email about a killed query (Not the issue) and query killer said the lag was around 14000 seconds while tsbot and the relag graph are showing almost no lag.
Hello, At Sunday 14 October 2012 14:22:17 DaB. wrote:
Either tsbot or the Query killer are broken I just got an email about a killed query (Not the issue) and query killer said the lag was around 14000 seconds while tsbot and the relag graph are showing almost no lag.
without the query or the database-server I can't look into the log.
Sincerely, DaB.
a MySQL-query of yours was killed because you didn't mark it as SLOW_OK and it have run for 191 seconds which was longer than allowed. You can find the query below. Please have also a look at [1] to find information how you can avoid killings of your queries. Maybe you can optimze the query too? The replication lag at kill-time was 16220s.
Sincerly, Query-Killer. This eMail was sent automaticaly, please don't reply.
select page_title, page_len, rev_text_id from page left join revision on page_latest = rev_id where page_is_redirect =0 and page_namespace =0 and page_len < 200 ORDER BY rev_timestamp LIMIT 17520
(enwiki)
On 14/10/12 13:53, John wrote:
Either tsbot or the Query killer are broken I just got an email about a killed query (Not the issue) and query killer said the lag was around 14000 seconds while tsbot and the relag graph are showing almost no lag.
The enwiki db has pretty much no lag in the user server, but a lag of 5h in the round-robin one (yes, that's quite strange).
BTW, may I ask why are you using 17520 as limit? Seems an odd choice.
I do some post query processing and only need about 100 results, I check them and either fix them or whitelist them, the size of the whitelist is 17420 items.
On Sun, Oct 14, 2012 at 8:50 AM, Platonides platonides@gmail.com wrote:
On 14/10/12 13:53, John wrote:
Either tsbot or the Query killer are broken I just got an email about a killed query (Not the issue) and query killer said the lag was around 14000 seconds while tsbot and the relag graph are showing almost no lag.
The enwiki db has pretty much no lag in the user server, but a lag of 5h in the round-robin one (yes, that's quite strange).
BTW, may I ask why are you using 17520 as limit? Seems an odd choice.
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
toolserver-l@lists.wikimedia.org