[Wikidata-bugs] [Maniphest] [Updated] T103282: 30 second timeout on testRecentchanges connected to wikidata

[jcrespo]

jcrespo added a comment.

@hoo you are right, but check my comment 
 on a very similar issue on 
https://phabricator.wikimedia.org/T101502.

We need to validate that change on all queries from the same piece of code (not 
only for this particular instance), on all server versions and all wikis, 
hopefully eliminating all FORCE INDEXes in the future.

Actually, now that I see it, is this the same issue?


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

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

To: jcrespo
Cc: jcrespo, Springle, aaron, aude, JanZerebecki, hoo, Lydia_Pintscher, greg, 
Aklapper, jayvdb, pywikibot-bugs-list, Wikidata-bugs, GWicke, Anomie, Krenair, 
Legoktm



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

[Wikidata-bugs] [Maniphest] [Updated] T103282: 30 second timeout on testRecentchanges connected to wikidata

[JanZerebecki]

JanZerebecki added projects: MediaWiki-API, Performance.

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

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

To: JanZerebecki
Cc: jcrespo, Springle, aaron, aude, JanZerebecki, hoo, Lydia_Pintscher, greg, 
Aklapper, jayvdb, pywikibot-bugs-list, Wikidata-bugs, GWicke, Anomie, Krenair, 
Legoktm



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

[Wikidata-bugs] [Maniphest] [Updated] T103282: 30 second timeout on testRecentchanges connected to wikidata

[hoo]

hoo added a project: Wikimedia-log-errors.
hoo added a comment.

Example exception:

  2015-06-24 12:18:59 mw1202 wikidatawiki exception INFO: [695b346b] 
/w/api.php?rcprop=user%7Ccomment%7Ctimestamp%7Ctitle%7Cids%7Csizes%7Credirect%7Cloginfo%7Cflags&maxlag=5&format=json&rclimit=5&list=recentchanges&rcnamespace=6%7C7&rcshow=&continue=&meta=userinfo&indexpageids=&action=query&uiprop=blockinfo%7Chasmsg
   DBQueryError from line 1274 of 
/srv/mediawiki/php-1.26wmf10/includes/db/Database.php: A database error has 
occurred. Did you forget to run maintenance/update.php after upgrading?  See: 
https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script   


  Query: SELECT  
rc_id,rc_timestamp,rc_namespace,rc_title,rc_cur_id,rc_type,rc_deleted,rc_this_oldid,rc_last_oldid,rc_comment,rc_user,rc_user_text,rc_minor,rc_type,rc_bot,rc_old_len,rc_new_len,rc_logid,rc_log_type,rc_log_action,rc_params,page_is_redirect
  FROM `recentchanges` FORCE INDEX (rc_timestamp) LEFT JOIN `page` ON 
((rc_namespace=page_namespace) AND (rc_title=page_title))  WHERE rc_namespace 
IN ('6','7')  AND rc_type IN ('0','1','3')   ORDER BY rc_timestamp DESC,rc_id 
DESC LIMIT 6

 
  Function: ApiQueryRecentChanges::run  

   
  Error: 2013 Lost connection to MySQL server during query (10.64.16.34)

   


   
  #0 /srv/mediawiki/php-1.26wmf10/includes/db/Database.php(1212): 
DatabaseBase->reportQueryError()

 
  #1 /srv/mediawiki/php-1.26wmf10/includes/db/Database.php(1754): 
DatabaseBase->query()   

 
  #2 /srv/mediawiki/php-1.26wmf10/includes/api/ApiQueryBase.php(376): 
DatabaseBase->select()  

 
  #3 /srv/mediawiki/php-1.26wmf10/includes/api/ApiQueryRecentChanges.php(367): 
ApiQueryBase->select()  

  #4 /srv/mediawiki/php-1.26wmf10/includes/api/ApiQueryRecentChanges.php(131): 
ApiQueryRecentChanges->run()

  #5 /srv/mediawiki/php-1.26wmf10/includes/api/ApiQuery.php(286): 
ApiQueryRecentChanges->execute()

 
  #6 /srv/mediawiki/php-1.26wmf10/includes/api/ApiMain.php(1130): 
ApiQuery->execute() 

 
  #7 /srv/mediawiki/php-1.26wmf10/includes/api/ApiMain.php(469): 
ApiMain->executeAction()

  
  #8 /srv/mediawiki/php-1.26wmf10/includes/api/ApiMain.php(442): 
ApiMain->executeActionWithErrorHandling()   

  
  #9 /srv/mediawiki/php-1.26wmf10/api.php(88): ApiMain->execute()   

   
  #10 /srv/mediawiki/w/api.php(3): include()   


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

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

To: hoo
Cc: aude, JanZerebecki, hoo, Lydia_Pintscher, greg, Aklapper, jayvdb, 
pywikibot-bugs-list, Wikidata-bugs, Krenair

[Wikidata-bugs] [Maniphest] [Updated] T103282: 30 second timeout on testRecentchanges connected to wikidata

[greg]

greg added a project: Wikidata.
greg added a comment.

Then let's add some relevant projects :)


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

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

To: greg
Cc: greg, Aklapper, jayvdb, pywikibot-bugs-list, Wikidata-bugs, aude



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