| Smalyshev added a comment. |
@EBernhardson we have per-IP limits, and they work fine in 99% of cases. In this case, however, the query is bad enough that it is causing load even when only 5 instances of it run in parallel. Which would be not a big deal if it happened just once, but since it is hammering all the time, as soon as one of the heavy queries is finished, it is replaced with another instance of the same. So server is constantly running 5 heavy queries on top of the usual load, which brings it down. We could lower the limits & timeouts, but given that it is just one client, I feel it would be more fair to block this one than to further limit the service for all other well-behaving ones.
TASK DETAIL
EMAIL PREFERENCES
To: Smalyshev
Cc: Esc3300, Gymel, EBernhardson, Lydia_Pintscher, Sjoerddebruin, debt, BBlack, Gehel, Aklapper, Smalyshev, GoranSMilovanovic, Th3d3v1ls, Hfbn0, QZanden, EBjune, merbst, Avner, Zppix, Jonas, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, faidon, Mbch331, Jay8g, fgiunchedi
Cc: Esc3300, Gymel, EBernhardson, Lydia_Pintscher, Sjoerddebruin, debt, BBlack, Gehel, Aklapper, Smalyshev, GoranSMilovanovic, Th3d3v1ls, Hfbn0, QZanden, EBjune, merbst, Avner, Zppix, Jonas, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, faidon, Mbch331, Jay8g, fgiunchedi
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
