[Wikidata-bugs] [Maniphest] [Commented On] T135471: Hundreds of concurrent SELECT MASTER_POS_WAIT('db1049-bin.002927', 354219766, 10) without debugging information (no user, not function) on s5 API node

[jcrespo]

jcrespo added a comment.


  I think I found it:
  
    | COMMIT /* DatabaseBase::deadlockLoop BotNinja */                          
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | COMMIT /* DatabaseBase::deadlockLoop BotNinja */                          
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | COMMIT /* DatabaseBase::deadlockLoop BotNinja */                          
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | DELETE /* Wikibase\TermSqlIndex::deleteTermsInternal BotNinja */ FROM 
`wb_terms` WHERE term_language |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | COMMIT /* DatabaseBase::deadlockLoop BotNinja */                          
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | COMMIT /* DatabaseBase::deadlockLoop BotNinja */                          
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | COMMIT /* DatabaseBase::deadlockLoop BotNinja */                          
                           |    0.000 |
    | COMMIT /* DatabaseBase::deadlockLoop BotNinja */                          
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | COMMIT /* DatabaseBase::deadlockLoop BotNinja */                          
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | COMMIT /* DatabaseBase::deadlockLoop BotNinja */                          
                           |    0.000 |
    | COMMIT /* DatabaseBase::deadlockLoop BotNinja */                          
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | COMMIT /* DatabaseBase::deadlockLoop BotNinja */                          
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | NULL                                                                      
                           |    0.000 |
    | UPDATE /* SiteStatsUpdate::tryDBUpdateInternal BotNinja */  `site_stats` 
SET ss_total_edits=ss_total |
  
  BotNinja has at the very least 13 concurrent commits happening (maybe 
hundreds) + the job queue tasks generated. That goes against the API policy, 
and he has been already warned- I propose to ban it.

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

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

To: jcrespo
Cc: Legoktm, hoo, Aklapper, jcrespo, Zppix, Vali.matei, Minhnv-2809, Volans, 
D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, GWicke, Mbch331, Jay8g, Krenair



_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs