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
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
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
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
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 /*
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=1=now-24h=now=codfw%20prometheus%2Fops=core=s5=All
To my shock, it has one spike
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=1=now-24h=now=codfw%20prometheus%2Fops=core=s5=All
To my shock, it has one spike of two minutes lag:
F7734856:
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
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.
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
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,
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
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:
14 matches
Mail list logo
