[Wikidata-bugs] [Maniphest] [Created] T200563: wdq1003 is anomalous

[Smalyshev]

Smalyshev created this task. Smalyshev added a project: Wikidata-Query-Service. Herald added a subscriber: Aklapper. Herald added a project: Wikidata.

TASK DESCRIPTION

If we look at the graph of the high lag for last 30 days:

https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?refresh=1m&panelId=8&fullscreen&orgId=1&from=now-30d&to=now

it is clear that wdqs1003 has highest instance of lag problems. This is weird, since three servers 1003, 1004 and 1005 should be sharing load & updates equally, and thus if there is a problem, either with query load or update load, it should be evenly distributed.

However, it is clear that 1003 has problems more often, and they are usually more severe (higher lag, longer duration). If could be:

• 1003 has some hardware/software issue that makes it slower
• our load balancing is not balanced between hosts
• some other reason?
• just a coincidence?

I think we need to investigate this and see if there's some issue we could fix.

TASK DETAIL

https://phabricator.wikimedia.org/T200563

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Smalyshev
Cc: Gehel, Aklapper, Smalyshev, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs