There was some feedback in the 2017 Toolforge survey that it would be helpful for all database related changes to be posted to the cloud mailing list. I can't guarantee that I'll spot all of them, but together we can probably do a pretty good job of keeping each other informed. Bryan ---------- Forwarded message ---------- From: Léa Lacroix <lea.lacroix(a)wikimedia.de> Date: Mon, Mar 12, 2018 at 7:17 AM Subject: [Wikitech-ambassadors] "autopatrolled" entries to be removed from the logging table To: wikitech-ambassadors(a)lists.wikimedia.org Hello all, This change might impact people who run tools based on the patrolling status of edits. This could also be relevant for admins. Feel free to share with your local communities. Currently, MediaWiki is storing the information about if an edit has been patrolled or autopatrolled in the logging table. This table is getting very very big, causing significant infrastructure issues. Therefore, we plan to make the following changes: Stop adding new entries for autopatrolling to the logging table Remove the old entries for autopatrolling from this table Since the distinction between autopatrol and manual patrol was introduced in April of 2016, We need to remove every patrol action (manual or not) before that date. Include information about autopatrolled in the recentchanges table. The fields rc_patrolled is current 0 for unpatrolled edits, and 1 for patrolled edits. In the future, it will be 0 for unpatrolled, 1 for manually patrolled, and 2 for autopatrolled edits. This means that the information about if an edit is autopatrolled, will be accessible only in the Recent Changes table, for 30 days. For now, manual patrolling actions will continue to be recorded in the logging table as before, and will remain visible on Special:Log. More details can be found in the technical RFC document, see phab:T184485. We plan to deploy these changes on April 4th. The script removing patrol actions in the database may take several weeks to run. If you’re maintaining a tool using logging.log_action = "autopatrolled", please consider changing your code to use recentchanges.rc_patrolled = 2. If this is going to cause large issues for an important tool, please let us know. If you have any technical question, feel free to write to user:Ladsgroup. -- Léa Lacroix Project Manager Community Communication for Wikidata Wikimedia Deutschland e.V. Tempelhofer Ufer 23-24 10963 Berlin www.wikimedia.de Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e. V. Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter der Nummer 23855 Nz. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/029/42207. _______________________________________________ Wikitech-ambassadors mailing list Wikitech-ambassadors(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-ambassadors -- Bryan Davis Wikimedia Foundation <bd808(a)wikimedia.org> [[m:User:BDavis_(WMF)]] Manager, Cloud Services Boise, ID USA irc: bd808 v:415.839.6885 x6855