- ALTERs to run: https://gerrit.wikimedia.org/g/mediawiki/extensions/CheckUser/+/672094be322cae71913a8d6a66f6833330248895/schema/mysql/patch-cusi_case-add-sic_updated_timestamp.sql
- Where to run those changes: checkuser-suggested-investigations.dblist on the extension1 database cluster
- When to run those changes: When DBA has time
- If the schema change is backwards compatible: Yes
- If the schema change has been tested already on some of the test/beta wikis: CheckUser is not on the beta cluster, has been tested elsewhere
- If the data should be made available on the labs replicas and/or dumps: No changes needed to existing visibility (should all be private)
Description
Description
Related Objects
Related Objects
Event Timeline
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2025-12-15T11:03:39Z] <marostegui> Deploy schema change on x1 with replication https://phabricator.wikimedia.org/T412687
Comment Actions
This has been done
[11:03:32] marostegui@cumin1003:~/git/mediawiki-config$ sudo /home/marostegui/section x1 | while read host port; do echo "$host:$port"; sudo db-mysql $host:$port zhwiki -e "show create table cusi_case\G" | egrep "sic_updated_timestamp_id" ; done dbstore1009.eqiad.wmnet:3320 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db2231.codfw.wmnet:3306 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db2215.codfw.wmnet:3306 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db2201.codfw.wmnet:3320 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db2197.codfw.wmnet:3320 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db2196.codfw.wmnet:3306 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db2191.codfw.wmnet:3306 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db2186.codfw.wmnet:3306 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db1264.eqiad.wmnet:3306 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db1237.eqiad.wmnet:3306 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db1225.eqiad.wmnet:3320 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db1224.eqiad.wmnet:3306 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db1220.eqiad.wmnet:3306 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db1216.eqiad.wmnet:3320 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`) db1179.eqiad.wmnet:3306 UNIQUE KEY `sic_updated_timestamp_id` (`sic_updated_timestamp`,`sic_id`)