Page MenuHomePhabricator

Add missing column cuc_only_for_read_old to testcommonswiki
Closed, ResolvedPublic

Description

testcommonswiki is missing the column cuc_only_for_read_old in the table cu_changes. The column was added to production in T329203: Add new column cuc_only_for_read_old to cu_changes for migration purposes to wmf wikis, but this wiki was missed.

This can be seen in the drift tracker report at https://drift-tracker.toolforge.org/report/checkuser/, including the relevant DB hosts.

  1. ALTERs to run: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/022f35b72c3b379394483101d78a78c761677a35/schema/mysql/patch-cu_changes-add-cuc_only_for_read_old.sql
  2. Where to run those changes: testcommonswiki
  3. When to run those changes: Ideally quickly, as this holds up writing new on group0 wikis.
  4. If the schema change is backwards compatible: Yes.
  5. If the schema change has been tested already on some of the test/beta wikis: Schema change is applied to all production wikis, except from testcommonswiki. This column is being written to on testwiki.
  6. if the data should be made available on the labs replicas and/or dumps: Everything is private

Related Objects

StatusSubtypeAssignedTask
OpenNone
ResolvedSecurityZabe
ResolvedSecurityDreamy_Jazz
ResolvedSecurityDreamy_Jazz
ResolvedSecurityDreamy_Jazz
OpenBUG REPORTNone
OpenBUG REPORTNone
OpenBUG REPORTNone
OpenDreamy_Jazz
OpenNone
OpenNone
OpenNone
OpenFeatureDreamy_Jazz
DuplicateNone
OpenFeatureNone
OpenFeatureNone
OpenFeatureNone
ResolvedFeatureDreamy_Jazz
ResolvedFeatureDreamy_Jazz
ResolvedFeatureDreamy_Jazz
OpenFeatureNone
OpenFeatureNone
ResolvedBUG REPORTDreamy_Jazz
OpenFeatureNone
OpenFeatureNone
ResolvedGlaisher
OpenNone
ResolvedFeatureDreamy_Jazz
ResolvedGlaisher
Resolved Niharika
ResolvedNone
ResolvedFeatureDreamy_Jazz
DeclinedNone
ResolvedFeatureDreamy_Jazz
ResolvedFeatureDreamy_Jazz
DuplicateNone
OpenNone
DuplicateNone
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
OpenFeatureNone
ResolvedDreamy_Jazz
OpenBUG REPORTNone
ResolvedBUG REPORTDreamy_Jazz
OpenNone
OpenFeatureNone
DeclinedFeatureNone
OpenFeatureNone
OpenDreamy_Jazz
Resolvedkostajh
OpenNone
OpenNone
Resolvedtstarling
OpenNone
OpenTchanders
OpenFeatureDreamy_Jazz
ResolvedLadsgroup
ResolvedMilimetric
OpenNone
OpenNone
OpenNone
OpenDreamy_Jazz
OpenNone
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedMarostegui
ResolvedPRODUCTION ERRORDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedBUG REPORTDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
OpenDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedPRODUCTION ERRORpmiazga
OpenNone
ResolvedDreamy_Jazz
OpenNone
ResolvedDreamy_Jazz
OpenNone
OpenNone
OpenNone
ResolvedMarostegui

Event Timeline

Mentioned in SAL (#wikimedia-operations) [2023-08-01T05:18:29Z] <marostegui> dbmaint s4 testcommonswiki eqiad T343174

Marostegui claimed this task.
root@db1160.eqiad.wmnet[testcommonswiki]> show create table cu_changes\G
*************************** 1. row ***************************
       Table: cu_changes
Create Table: CREATE TABLE `cu_changes` (
  `cuc_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cuc_namespace` int(11) NOT NULL DEFAULT 0,
  `cuc_title` varbinary(255) NOT NULL DEFAULT '',
  `cuc_actor` bigint(20) unsigned NOT NULL,
  `cuc_actiontext` varbinary(255) NOT NULL DEFAULT '',
  `cuc_comment_id` bigint(20) unsigned NOT NULL,
  `cuc_minor` tinyint(1) NOT NULL DEFAULT 0,
  `cuc_page_id` int(10) unsigned NOT NULL DEFAULT 0,
  `cuc_this_oldid` int(10) unsigned NOT NULL DEFAULT 0,
  `cuc_last_oldid` int(10) unsigned NOT NULL DEFAULT 0,
  `cuc_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `cuc_timestamp` binary(14) NOT NULL,
  `cuc_ip` varbinary(255) DEFAULT '',
  `cuc_ip_hex` varbinary(255) DEFAULT NULL,
  `cuc_xff` varbinary(255) DEFAULT '',
  `cuc_xff_hex` varbinary(255) DEFAULT NULL,
  `cuc_agent` varbinary(255) DEFAULT NULL,
  `cuc_private` mediumblob DEFAULT NULL,
  `cuc_only_for_read_old` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`cuc_id`),
  KEY `cuc_ip_hex_time` (`cuc_ip_hex`,`cuc_timestamp`),
  KEY `cuc_xff_hex_time` (`cuc_xff_hex`,`cuc_timestamp`),
  KEY `cuc_timestamp` (`cuc_timestamp`),
  KEY `cuc_actor_ip_time` (`cuc_actor`,`cuc_ip`,`cuc_timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=10270 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED
1 row in set (0.001 sec)