Page MenuHomePhabricator
Create Task
Maniphest T343174

Add missing column cuc_only_for_read_old to testcommonswiki
Closed, ResolvedPublic
Actions

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
Search...

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
· · ·
OpenNoneT321063 Fix CheckUser database schema drifts in production
ResolvedPRODUCTION ERRORDreamy_JazzT342902 Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cuc_only_for_read_old' in 'field list'Function: MediaWiki\CheckUser\Hooks::onAuthManagerLoginAuthenticateAuditQuery: INSERT INTO `cu_changes` (cuc_page_id,cuc_namespac
Resolved• MarosteguiT343174 Add missing column cuc_only_for_read_old to testcommonswiki
· · ·

Event Timeline

Dreamy_Jazz created this task.Jul 31 2023, 11:17 PM
Dreamy_Jazz moved this task from Untriaged to Tracking work by others on the Anti-Harassment board.
Dreamy_Jazz added a parent task: T342902: Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cuc_only_for_read_old' in 'field list'Function: MediaWiki\CheckUser\Hooks::onAuthManagerLoginAuthenticateAuditQuery: INSERT INTO `cu_changes` (cuc_page_id,cuc_namespac.
Dreamy_Jazz updated the task description. (Show Details)Jul 31 2023, 11:21 PM
Dreamy_Jazz updated the task description. (Show Details)Jul 31 2023, 11:26 PM
• Marostegui subscribed.Aug 1 2023, 5:18 AM

Done

Stashbot added a comment.Aug 1 2023, 5:18 AM

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

• Marostegui closed this task as Resolved.Aug 1 2023, 5:19 AM
• 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)
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits