gerritbot added a comment.
Change 354246 merged by jenkins-bot:
[operations/mediawiki-config@master] Log "api-readonly" errors
https://gerrit.wikimedia.org/r/354246TASK DETAILhttps://phabricator.wikimedia.org/T123867EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences
gerritbot added a comment.
Change 354246 had a related patch set uploaded (by Hoo man; owner: Hoo man):
[operations/mediawiki-config@master] Log "api-readonly" errors
https://gerrit.wikimedia.org/r/354246TASK DETAILhttps://phabricator.wikimedia.org/T123867EMAIL PREFERENCEShttps://phabricator.wikim
Ladsgroup added a comment.
In T123867#3238244, @gerritbot wrote:
Change 349867 abandoned by Ladsgroup:
[WIP] [Code experiment] Try to select all columns from wb_terms
https://gerrit.wikimedia.org/r/349867
This patch was not related to this and had the incorrect bug numberTASK DETAILhttps://pha
gerritbot added a comment.
Change 349867 abandoned by Ladsgroup:
[WIP] [Code experiment] Try to select all columns from wb_terms
https://gerrit.wikimedia.org/r/349867TASK DETAILhttps://phabricator.wikimedia.org/T123867EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferenc
Ladsgroup added a comment.
Thanks. This is a sample of slow queries in tendril which it might be useful. Some slow queries (I don't see any slow write queries causing replication lag)
Just improvements in the database queries not probably related to this bug
SELECT /* ApiQueryPagePropNames::exec
Marostegui added a comment.
In T123867#3204830, @Ladsgroup wrote:
Shard and datacenter is wrong in the grafana link. I think the correct one is: https://grafana.wikimedia.org/dashboard/db/mysql-aggregated?panelId=6&fullscreen&orgId=1&from=now-24h&to=now&var-dc=codfw%20prometheus%2Fops&var-group=co
Ladsgroup added a comment.
Shard and datacenter is wrong in the grafana link. I think the correct one is: https://grafana.wikimedia.org/dashboard/db/mysql-aggregated?panelId=6&fullscreen&orgId=1&from=now-24h&to=now&var-dc=codfw%20prometheus%2Fops&var-group=core&var-shard=s5&var-role=All
To my shoc
Marostegui added a comment.
In T123867#3203898, @Multichill wrote:
Just had it again:
pywikibot.data.api.APIError: readonly: The database has been automatically locked while the slave database servers catch up to the master [readonlyreason:Waiting for 3 lagged database(s); help:See https://www.wi
Multichill added a comment.
Just had it again:
pywikibot.data.api.APIError: readonly: The database has been automatically locked while the slave database servers catch up to the master [readonlyreason:Waiting for 3 lagged database(s); help:See https://www.wikidata.org/w/api.php for API usage. Subs
Multichill added a comment.
In the last 10 minutes:
pywikibot.data.api.APIError: readonly: The database has been automatically locked while the slave database servers catch up to the master [readonlyreason:Waiting for 7 lagged database(s); help:See https://www.wikidata.org/w/api.php for API usage.
Ladsgroup added a comment.
@Multichill: Do you get such issues recently? My bot stopped getting themTASK DETAILhttps://phabricator.wikimedia.org/T123867EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: Ladsgroup, Aklapper, StudiesWorld, aaron, danie
Ladsgroup added a comment.
I did this edit that might help in the short term. But definitely there should be some limits on how people behave on Wikis. I check the db query and might be able to do something.TASK DETAILhttps://phabricator.wikimedia.org/T123867EMAIL PREFERENCEShttps://phabricator.wik
Ladsgroup added a comment.
I still get read-only mode when editing via API several times per weekTASK DETAILhttps://phabricator.wikimedia.org/T123867EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: Ladsgroup, Aklapper, StudiesWorld, aaron, daniel,
hoo added a comment.
@Multichill: Is this relevant still?
We could also start listening to 'api-readonly' logs, to find out how often this happens.TASK DETAILhttps://phabricator.wikimedia.org/T123867EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hooCc: Aklap
14 matches
Mail list logo