hoo added a comment. |
In T151681#2836131, @jcrespo wrote:Another example of why long running connections are a problem: I am depooling es1017 for important maintenance, I have depooled it, so I expect connections so finish within a few seconds, with the exception of wikiadmin's known long running queries, but I just see 2 sleeping connections:
| 2188112525 | wikiuser | 10.64.32.39:47222 | wikidatawiki | Sleep | 1138 | | NULL | 0.000 | | 2188171306 | wikiuser | 10.64.16.64:43004 | wikidatawiki | Sleep | 584 | | NULL | 0.000 |Should I kill them? Should I not be able to depool the server, even if I was in an emergency? I do not mind long running connections, if I know I can kill them at any time.
Hm, these are both job runners, jobs (probably) shouldn't run for so long. I wonder what's causing this.
TASK DETAIL
EMAIL PREFERENCES
To: hoo
Cc: Ladsgroup, aaron, Marostegui, jcrespo, Aklapper, Jonas, Lydia_Pintscher, hoo, daniel, Vali.matei, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, GWicke, Mbch331, Jay8g, Krenair
Cc: Ladsgroup, aaron, Marostegui, jcrespo, Aklapper, Jonas, Lydia_Pintscher, hoo, daniel, Vali.matei, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, GWicke, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs