[Wikidata-bugs] [Maniphest] T284981: SELECT query arriving to wikidatawiki db codfw hosts causing pile ups during schema change

Marostegui closed this task as "Resolved". Marostegui claimed this task. Marostegui added a comment. I am going to consider this fixed as it never happened again. TASK DETAIL https://phabricator.wikimedia.org/T284981 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T284981: SELECT query arriving to wikidatawiki db codfw hosts causing pile ups during schema change

Marostegui edited projects, added DBA; removed SRE. TASK DETAIL https://phabricator.wikimedia.org/T284981 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Marostegui Cc: BBlack, ArielGlenn, Ladsgroup, Addshore, Aklapper, Marostegui, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T284981: SELECT query arriving to wikidatawiki db codfw hosts causing pile ups during schema change

BBlack added a comment. We chose S:BP for those queries on the assumption that, by its nature, it would be a cheap page to monitor. Is there a better option we should be using, or is this ticket more about fixing inefficiencies in it? TASK DETAIL https://phabricator.wikimedia.org/T284981

[Wikidata-bugs] [Maniphest] T284981: SELECT query arriving to wikidatawiki db codfw hosts causing pile ups during schema change

BPirkle removed a project: Platform Engineering. TASK DETAIL https://phabricator.wikimedia.org/T284981 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: BPirkle Cc: Ladsgroup, Addshore, Aklapper, Marostegui, joanna_borun, the0001, Invadibot,

[Wikidata-bugs] [Maniphest] T284981: SELECT query arriving to wikidatawiki db codfw hosts causing pile ups during schema change

jbond triaged this task as "Medium" priority. TASK DETAIL https://phabricator.wikimedia.org/T284981 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: jbond Cc: Ladsgroup, Addshore, Aklapper, Marostegui, joanna_borun, the0001, Invadibot, Ramtin0071,

[Wikidata-bugs] [Maniphest] T284981: SELECT query arriving to wikidatawiki db codfw hosts causing pile ups during schema change

Marostegui added a comment. All the hosts have been recovered. TASK DETAIL https://phabricator.wikimedia.org/T284981 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Marostegui Cc: Ladsgroup, Addshore, Aklapper, Marostegui, joanna_borun, the0001,

[Wikidata-bugs] [Maniphest] T284981: SELECT query arriving to wikidatawiki db codfw hosts causing pile ups during schema change

Maintenance_bot added a project: SRE. TASK DETAIL https://phabricator.wikimedia.org/T284981 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Maintenance_bot Cc: Ladsgroup, Addshore, Aklapper, Marostegui, joanna_borun, the0001, Invadibot, Ramtin0071,

[Wikidata-bugs] [Maniphest] T284981: SELECT query arriving to wikidatawiki db codfw hosts causing pile ups during schema change

Marostegui added a comment. My guess is that as the schema change isn't made on the same transaction, the query arrives in between the drop+create and gets stuck with that huge full scan. I have depooled the hosts that are giving too many connections (as they others have the schema change

[Wikidata-bugs] [Maniphest] T284981: SELECT query arriving to wikidatawiki db codfw hosts causing pile ups during schema change

Addshore added a comment. > 9:27 AM addshore: Maybe the issue is the schema change isn't being done o nthe same transaction, so while we drop the index and the queries arrive, there's no index until the new one is created > 9:27 AM I can definitely change that for the next iterations

[Wikidata-bugs] [Maniphest] T284981: SELECT query arriving to wikidatawiki db codfw hosts causing pile ups during schema change

Addshore renamed this task from "SELECT query arriving to wikidatawiki db codfw hosts causing pile ups" to "SELECT query arriving to wikidatawiki db codfw hosts causing pile ups during schema change". TASK DETAIL https://phabricator.wikimedia.org/T284981 EMAIL PREFERENCES