[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-05-05 Thread ReleaseTaggerBot 
ReleaseTaggerBot edited projects, added MW-1.35-notes (1.35.0-wmf.30; 
2020-04-28); removed MW-1.35-notes (1.35.0-wmf.31; 2020-05-05).

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: daniel, ReleaseTaggerBot
Cc: Ladsgroup, Nikerabbit, Tgr, Agusbou2015, Pchelolo, daniel, DannyS712, 
Jdforrester-WMF, Krinkle, Marostegui, Liuxinyu970226, brennen, Bugreporter, 
LarsWirzenius, Hogue, Aklapper, Naike, eprodromou, darthmon_wmde, Nandana, 
Banyek, Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Agabi10, Scott_WUaS, Jonas, Wikidata-bugs, aude, Dinoguy1000, 
Lydia_Pintscher, Mbch331, Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-05-04 Thread Maintenance_bot 
Maintenance_bot removed a project: Patch-For-Review.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: daniel, Maintenance_bot
Cc: Ladsgroup, Nikerabbit, Tgr, Agusbou2015, Pchelolo, daniel, DannyS712, 
Jdforrester-WMF, Krinkle, Marostegui, Liuxinyu970226, brennen, Bugreporter, 
LarsWirzenius, Hogue, Aklapper, Naike, eprodromou, darthmon_wmde, Nandana, 
Banyek, Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Agabi10, Scott_WUaS, Jonas, Wikidata-bugs, aude, Dinoguy1000, 
Lydia_Pintscher, Mbch331, Rxy, Jay8g, Krenair, Blissjay007, Oblanco79, 
Alter-paule, Beast1978, Un1tY, Hook696, Daryl-TTMG, RomaAmorRoma, E.S.A-Sheild, 
Kent7301, Meekrab2012, joker88john, CucyNoiD, NebulousIris, Gaboe420, Versusxo, 
Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Af420, Darkminds3113, 
Bsandipan, Lordiis, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, WSH1906, Lewizho99, 
Maathavan
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-05-01 Thread ReleaseTaggerBot 
ReleaseTaggerBot added a project: MW-1.35-notes (1.35.0-wmf.31; 2020-05-05).

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: ReleaseTaggerBot
Cc: Tgr, Agusbou2015, Pchelolo, daniel, DannyS712, Jdforrester-WMF, Krinkle, 
Marostegui, Liuxinyu970226, brennen, Bugreporter, LarsWirzenius, Hogue, 
Aklapper, Naike, Blissjay007, Oblanco79, Alter-paule, Beast1978, Un1tY, 
eprodromou, Hook696, Daryl-TTMG, RomaAmorRoma, E.S.A-Sheild, darthmon_wmde, 
Kent7301, Meekrab2012, joker88john, CucyNoiD, Nandana, NebulousIris, Banyek, 
Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, 
Rayssa-, Lahi, Gq86, Af420, Darkminds3113, Bsandipan, Lordiis, 
GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, 
LawExplorer, WSH1906, Lewizho99, Maathavan, _jensen, rosalieper, Agabi10, 
Scott_WUaS, Jonas, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, 
Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-05-01 Thread gerritbot 
gerritbot added a project: Patch-For-Review.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: gerritbot
Cc: Tgr, Agusbou2015, Pchelolo, daniel, DannyS712, Jdforrester-WMF, Krinkle, 
Marostegui, Liuxinyu970226, brennen, Bugreporter, LarsWirzenius, Hogue, 
Aklapper, Naike, Blissjay007, Oblanco79, Alter-paule, Beast1978, Un1tY, 
eprodromou, Hook696, Daryl-TTMG, RomaAmorRoma, E.S.A-Sheild, darthmon_wmde, 
Kent7301, Meekrab2012, joker88john, CucyNoiD, Nandana, NebulousIris, Banyek, 
Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, 
Rayssa-, Lahi, Gq86, Af420, Darkminds3113, Bsandipan, Lordiis, 
GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, 
LawExplorer, WSH1906, Lewizho99, Maathavan, _jensen, rosalieper, Agabi10, 
Scott_WUaS, Jonas, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, 
Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread Maintenance_bot 
Maintenance_bot removed a project: Patch-For-Review.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: Maintenance_bot
Cc: Pchelolo, daniel, DannyS712, Jdforrester-WMF, Krinkle, Marostegui, 
Liuxinyu970226, brennen, Bugreporter, LarsWirzenius, Hogue, Aklapper, Naike, 
eprodromou, darthmon_wmde, Nandana, Banyek, Rayssa-, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Agabi10, 
Scott_WUaS, Jonas, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, 
Rxy, Jay8g, Krenair, Blissjay007, Oblanco79, Alter-paule, Beast1978, Un1tY, 
Hook696, Daryl-TTMG, RomaAmorRoma, E.S.A-Sheild, Kent7301, Meekrab2012, 
joker88john, CucyNoiD, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, 
Giuliamocci, Adrian1985, Cpaulf30, Af420, Darkminds3113, Bsandipan, Lordiis, 
Adik2382, Th3d3v1ls, Ramalepe, Liugev6, WSH1906, Lewizho99, Maathavan
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread daniel 
daniel added a comment.


  Interesting. RevisionStore::insertRevisionRowOn() does uses GET_LOCK when it 
detects the auto-increment value of the revision table to be out of sync. This 
was introduced as a fix for  T202032: Duplicate ar_rev_id values in several 
wikis .
  
  I suppose multiple saves detecting this, and all attempting to acquire the 
same lock, can lead to a pile-up, causing some such requests to time out.
  
  The pile-up could perhaps be avoided by intropducing a randomized delay 
before trying to acquire the lock. But that may still cause the transaction to 
time out.
  
  The big question is - why does the auto-increment value get out of whack? Was 
there a master switch? As far as I know, the original cause of T202032 
 should no longer happen with recent 
versions of Maria...

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: daniel
Cc: Pchelolo, daniel, DannyS712, Jdforrester-WMF, Krinkle, Marostegui, 
Liuxinyu970226, brennen, Bugreporter, LarsWirzenius, Hogue, Aklapper, Naike, 
Blissjay007, Oblanco79, Alter-paule, Beast1978, Un1tY, eprodromou, Hook696, 
Daryl-TTMG, RomaAmorRoma, E.S.A-Sheild, darthmon_wmde, Kent7301, Meekrab2012, 
joker88john, CucyNoiD, Nandana, NebulousIris, Banyek, Gaboe420, Versusxo, 
Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Rayssa-, Lahi, Gq86, 
Af420, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, 
Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, WSH1906, Lewizho99, 
Maathavan, _jensen, rosalieper, Agabi10, Scott_WUaS, Jonas, Wikidata-bugs, 
aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread gerritbot 
gerritbot added a project: Patch-For-Review.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: gerritbot
Cc: daniel, DannyS712, Jdforrester-WMF, Krinkle, Marostegui, Liuxinyu970226, 
brennen, Bugreporter, LarsWirzenius, Hogue, Aklapper, Naike, Blissjay007, 
Oblanco79, Alter-paule, Beast1978, Un1tY, eprodromou, Hook696, Daryl-TTMG, 
RomaAmorRoma, E.S.A-Sheild, darthmon_wmde, Kent7301, Meekrab2012, joker88john, 
CucyNoiD, Nandana, NebulousIris, Banyek, Gaboe420, Versusxo, 
Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Rayssa-, Lahi, Gq86, 
Af420, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, 
Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, WSH1906, Lewizho99, 
Maathavan, _jensen, rosalieper, Agabi10, Scott_WUaS, Pchelolo, Jonas, 
Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, Mbch331, Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread Krinkle 
Krinkle added a parent task: T249962: 1.35.0-wmf.30 deployment blockers.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: Krinkle
Cc: Jdforrester-WMF, Krinkle, Marostegui, Liuxinyu970226, brennen, Bugreporter, 
LarsWirzenius, Hogue, Aklapper, Naike, eprodromou, darthmon_wmde, Nandana, 
Banyek, Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Agabi10, Scott_WUaS, Pchelolo, Jonas, Wikidata-bugs, aude, 
Dinoguy1000, Lydia_Pintscher, Mbch331, Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread Jdforrester-WMF 
Jdforrester-WMF added a comment.


  Possibly caused by changes to EditPage this train?
  
  - rMW4721717527f9: Replace uses and hard deprecate Article:: and 
WikiPage::getRevision 

  - rMWd4e06a3d658a: Hard deprecate WikiPage::getUndoContent 

  - rMWca8aa4d6b25e: Replace uses and hard deprecate 
Article::getRevisionFetched 

  - rMW257fd5237e23: EditPage::showHeader - only warn editing an old revision 
if it exists 


TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: Jdforrester-WMF
Cc: Jdforrester-WMF, Krinkle, Marostegui, Liuxinyu970226, brennen, Bugreporter, 
LarsWirzenius, Hogue, Aklapper, Naike, eprodromou, darthmon_wmde, Nandana, 
Banyek, Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Agabi10, Scott_WUaS, Pchelolo, Jonas, Wikidata-bugs, aude, 
Dinoguy1000, Lydia_Pintscher, Mbch331, Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread Marostegui 
Marostegui removed a project: DBA.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: Marostegui
Cc: Marostegui, Liuxinyu970226, brennen, Bugreporter, LarsWirzenius, Hogue, 
Aklapper, Naike, eprodromou, darthmon_wmde, Nandana, Banyek, Rayssa-, Lahi, 
Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Agabi10, 
Scott_WUaS, Pchelolo, Jonas, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, 
Jdforrester-WMF, Mbch331, Rxy, Jay8g, Krenair, Iflorez, Minhnv-2809
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread brennen 
brennen removed a parent task: T249962: 1.35.0-wmf.30 deployment blockers.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: brennen
Cc: Marostegui, Liuxinyu970226, brennen, Bugreporter, LarsWirzenius, Hogue, 
Aklapper, Naike, eprodromou, Iflorez, darthmon_wmde, Nandana, Banyek, Rayssa-, 
Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Minhnv-2809, _jensen, 
rosalieper, Agabi10, Scott_WUaS, Pchelolo, Jonas, Wikidata-bugs, aude, 
Dinoguy1000, Lydia_Pintscher, Jdforrester-WMF, Mbch331, Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread brennen 
brennen added a project: DBA.
brennen added a comment.


  Adding DBA in case this reflects load balancing issues.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: brennen
Cc: Liuxinyu970226, brennen, Bugreporter, LarsWirzenius, Hogue, Aklapper, 
Naike, eprodromou, Iflorez, darthmon_wmde, Nandana, Banyek, Rayssa-, Lahi, 
Gq86, GoranSMilovanovic, QZanden, Marostegui, LawExplorer, Minhnv-2809, 
_jensen, rosalieper, Agabi10, Scott_WUaS, Pchelolo, Jonas, Wikidata-bugs, aude, 
Dinoguy1000, Lydia_Pintscher, Jdforrester-WMF, Mbch331, Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread daniel 
daniel edited projects, added Core Platform Team Workboards (Clinic Duty Team); 
removed Core Platform Team.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: daniel
Cc: Liuxinyu970226, brennen, Bugreporter, LarsWirzenius, Hogue, Aklapper, 
Naike, eprodromou, darthmon_wmde, Nandana, Banyek, Rayssa-, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Agabi10, 
Scott_WUaS, Pchelolo, Jonas, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, 
Jdforrester-WMF, Mbch331, Rxy, Jay8g, Krenair, WDoranWMF, holger.knust, 
EvanProdromou
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread brennen 
brennen added a parent task: T249962: 1.35.0-wmf.30 deployment blockers.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: brennen
Cc: Liuxinyu970226, brennen, Bugreporter, LarsWirzenius, Hogue, Aklapper, 
darthmon_wmde, WDoranWMF, holger.knust, EvanProdromou, Nandana, Banyek, 
Rayssa-, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, 
rosalieper, Agabi10, Scott_WUaS, Pchelolo, Jonas, Wikidata-bugs, aude, 
Dinoguy1000, Lydia_Pintscher, Jdforrester-WMF, Mbch331, Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread brennen 
brennen added a project: User-brennen.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: brennen
Cc: brennen, Bugreporter, LarsWirzenius, Hogue, Aklapper, darthmon_wmde, 
WDoranWMF, holger.knust, EvanProdromou, Nandana, Banyek, Rayssa-, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Agabi10, 
Scott_WUaS, Pchelolo, Jonas, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, 
Jdforrester-WMF, Mbch331, Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Updated] T251457: LoadBalancer: Transaction spent [n] second(s) in writes, exceeding the limit of [n]

2020-04-30 Thread brennen 
brennen added a comment.


  This is still happening now that 1.35.0-wmf.30 (T249962 
) is on all wikis, at a rate of ~100 
in the last hour or so.
  
  I mistakenly believed this was fully accounted for, but I now think it likely 
should have been a blocker.  Seeking advice.

TASK DETAIL
  https://phabricator.wikimedia.org/T251457

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

To: brennen
Cc: brennen, Bugreporter, LarsWirzenius, Hogue, Aklapper, darthmon_wmde, 
WDoranWMF, holger.knust, EvanProdromou, Nandana, Banyek, Rayssa-, Lahi, Gq86, 
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Agabi10, 
Scott_WUaS, Pchelolo, Jonas, Wikidata-bugs, aude, Dinoguy1000, Lydia_Pintscher, 
Jdforrester-WMF, Mbch331, Rxy, Jay8g, Krenair
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs