[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

Stashbot added a comment.Mentioned in SAL [2016-06-09T20:36:04Z] Synchronized php-1.28.0-wmf.5/extensions/Wikidata: Update ArticlePlaceholder (without unrelated T136598 fixes this time) (duration: 01m 51s)TASK DETAILhttps://phabricator.wikimedia.org/T136598EMAIL PREFERENCEShttps://phabricator.wiki

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

gerritbot added a comment.Change 293570 merged by jenkins-bot: Update Wikibase: Revert T136598 fixes https://gerrit.wikimedia.org/r/293570TASK DETAILhttps://phabricator.wikimedia.org/T136598EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hoo, gerritbotCc: Ari

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

gerritbot added a comment.Change 293570 had a related patch set uploaded (by Hoo man): Update Wikibase: Revert T136598 fixes https://gerrit.wikimedia.org/r/293570TASK DETAILhttps://phabricator.wikimedia.org/T136598EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/T

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

gerritbot added a comment.Change 293511 merged by JanZerebecki: Avoid connection to repo master in UsageUpdater https://gerrit.wikimedia.org/r/293511TASK DETAILhttps://phabricator.wikimedia.org/T136598EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hoo, gerri

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

gerritbot added a comment.Change 293511 had a related patch set uploaded (by JanZerebecki): Avoid connection to repo master in UsageUpdater https://gerrit.wikimedia.org/r/293511TASK DETAILhttps://phabricator.wikimedia.org/T136598EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/ema

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

JanZerebecki added a comment. 19:08 < jynus> jzerebecki, as far as I can see, it is only affecting itself, and not other connections 19:09 < jynus> (the wikidata job queue executions) I think this is not needed today as it does not affect users. TASK DETAIL https://phabricator.wi

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

jcrespo added a comment. @hoo, my apologies- I thought it had been already deployed. Let me keep it open until it deploys so that 3rd parties can see it can happen for now- you can move it if you need it on the https://phabricator.wikimedia.org/tag/wikidata/ dashboard. TASK DETAIL https:/

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

hoo added a comment. Not surprising, that this is still an issue: The changes have not been backported/ deployed, yet. I can try to arrange a deploy today, if needed. To anyone deploying this: Also backport the follow-up!! TASK DETAIL https://phabricator.wikimedia.org/T136598 EMA

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

hoo added a comment. I made a mistake in the initial patch, fix up: https://gerrit.wikimedia.org/r/292834 TASK DETAIL https://phabricator.wikimedia.org/T136598 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: hoo Cc: daniel, gerritbot, JanZerebeck

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

hoo added a comment. Change has been merged on master, can be backported, if needed. TASK DETAIL https://phabricator.wikimedia.org/T136598 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: hoo Cc: daniel, gerritbot, JanZerebecki, hoo, aude, Aklapper

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

gerritbot added a comment. Change 292115 merged by jenkins-bot: Avoid connection to repo master in UsageUpdater https://gerrit.wikimedia.org/r/292115 TASK DETAIL https://phabricator.wikimedia.org/T136598 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailprefer

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

daniel added a comment. FTR, it remains unclear why the problem started when it started. The code did not change at that point, afaik. Maybe we just crossed some sort of threashold. TASK DETAIL https://phabricator.wikimedia.org/T136598 EMAIL PREFERENCES https://phabricator.wikimedia.org/

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

jcrespo added a comment. @JanZerebecki - our max_connections is very high: 1 simultaneous connections- because we use connection pooling at server side. We almost never reach that- mediawiki servers get saturated first; what fails is the connection timeout, which is set to 3 seconds (whe

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

JanZerebecki added a comment. Next one might want to look at the graph of established connections and connection attempts to the wikidatawiki master. Perhaps compare with the connection limit (even over a changing master). TASK DETAIL https://phabricator.wikimedia.org/T136598 EMAIL PREFER

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

gerritbot added a comment. Change 292115 had a related patch set uploaded (by Hoo man): Avoid connection to repo master in UsageUpdater https://gerrit.wikimedia.org/r/292115 TASK DETAIL https://phabricator.wikimedia.org/T136598 EMAIL PREFERENCES https://phabricator.wikimedia.org/se

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

jcrespo added a comment. I do not know what happened there: F4098270: Screenshot from 2016-06-01 11:36:39.png TASK DETAIL https://phabricator.wikimedia.org/T136598 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailprefe

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

jcrespo added a comment. A high sustained level of errors seem to have gone at 21:40-21:45 yesterday. The errors continue, but only in smaller spikes. We'll see if it returns when user activity grows more. TASK DETAIL https://phabricator.wikimedia.org/T136598 EMAIL PREFERENCES https://p

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

JanZerebecki added a comment. Any variation in MediaWiki.jobqueue.inserts_actual.wikibase_addUsagesForPage.rate seems normal. So this can't be a sudden increase in pages rendered. The change in rates noticed in https://phabricator.wikimedia.org/T136598#2340678 is only temporary afterwards

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

jcrespo added a comment. If you ask for wikis, this is the distribution: filter: `wikibase-addUsagesForPage and 10.64.16.144` (10.64.16.144 is s5-master) dewiki (777) enwiki (691) wikidatawiki (487) frwiki (423) zhwiki (415) commonswiki (384) svwiki (375) itwiki (287) ptwiki (

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

jcrespo added a comment. Sorry I wasn't specific enough. This issue is only happening on db1049: s5-master (Wikidata master). TASK DETAIL https://phabricator.wikimedia.org/T136598 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: jcrespo Cc: JanZer

[Wikidata-bugs] [Maniphest] [Commented On] T136598: Wikidata master database connection issue

jcrespo added a comment. There are a couple of long-running tasks on the master, from snapshot1003- that is strange, but not sure it is an issue. TASK DETAIL https://phabricator.wikimedia.org/T136598 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To