Page MenuHomePhabricator

Create notification-log table in Production (wikishared)
Closed, ResolvedPublic

Description

Create notification-log table with cx prefix in wikishared (x1) database. This was missing and caused issue as reported in T261189.

SQL for table: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/ContentTranslation/+/refs/heads/master/sql/notification-log.sql

Event Timeline

Marostegui triaged this task as Medium priority.Aug 25 2020, 9:13 AM
Marostegui moved this task from Triage to In progress on the DBA board.
Marostegui added a subscriber: Marostegui.

Please note that normally DBAs do not create tables, as this should be done during normal deployments windows (https://wikitech.wikimedia.org/wiki/Schema_changes#What_is_not_a_schema_change).
However if this is causing or blocking something at the moment, I can go ahead and create the table for you.
I would need to know if this data is private or could be replicated to labsdb infrastructure if we ever replicate wikishared.

The table will contain just a few timestamps. I can't think of any privacy implications to necessitate keeping it private.

This is blocking us to enable pre-notifications about old drafts being deleted.

The table will contain just a few timestamps. I can't think of any privacy implications to necessitate keeping it private.

Thank you - I will not filter it then

This is blocking us to enable pre-notifications about old drafts being deleted.

Going to create it now

Mentioned in SAL (#wikimedia-operations) [2020-08-25T09:45:51Z] <marostegui> Create missing table cx_notification_log on x1 wikishared T261190

Marostegui closed this task as Resolved.Aug 25 2020, 9:49 AM
Marostegui claimed this task.

Table created in x1:

 ./section x1 | while read host port; do echo "$host:$port"; mysql.py -h$host:$port wikishared -e "show create table cx_notification_log\G";done
dbstore1005.eqiad.wmnet:3320
*************************** 1. row ***************************
       Table: cx_notification_log
Create Table: CREATE TABLE `cx_notification_log` (
  `cxn_id` int(11) NOT NULL AUTO_INCREMENT,
  `cxn_date` varbinary(14) NOT NULL,
  `cxn_newest` varbinary(14) NOT NULL,
  PRIMARY KEY (`cxn_id`),
  UNIQUE KEY `cx_notification_log_index` (`cxn_date`,`cxn_newest`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
db2131.codfw.wmnet:3306
*************************** 1. row ***************************
       Table: cx_notification_log
Create Table: CREATE TABLE `cx_notification_log` (
  `cxn_id` int(11) NOT NULL AUTO_INCREMENT,
  `cxn_date` varbinary(14) NOT NULL,
  `cxn_newest` varbinary(14) NOT NULL,
  PRIMARY KEY (`cxn_id`),
  UNIQUE KEY `cx_notification_log_index` (`cxn_date`,`cxn_newest`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
db2115.codfw.wmnet:3306
*************************** 1. row ***************************
       Table: cx_notification_log
Create Table: CREATE TABLE `cx_notification_log` (
  `cxn_id` int(11) NOT NULL AUTO_INCREMENT,
  `cxn_date` varbinary(14) NOT NULL,
  `cxn_newest` varbinary(14) NOT NULL,
  PRIMARY KEY (`cxn_id`),
  UNIQUE KEY `cx_notification_log_index` (`cxn_date`,`cxn_newest`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
db2101.codfw.wmnet:3320
*************************** 1. row ***************************
       Table: cx_notification_log
Create Table: CREATE TABLE `cx_notification_log` (
  `cxn_id` int(11) NOT NULL AUTO_INCREMENT,
  `cxn_date` varbinary(14) NOT NULL,
  `cxn_newest` varbinary(14) NOT NULL,
  PRIMARY KEY (`cxn_id`),
  UNIQUE KEY `cx_notification_log_index` (`cxn_date`,`cxn_newest`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
db2096.codfw.wmnet:3306
*************************** 1. row ***************************
       Table: cx_notification_log
Create Table: CREATE TABLE `cx_notification_log` (
  `cxn_id` int(11) NOT NULL AUTO_INCREMENT,
  `cxn_date` varbinary(14) NOT NULL,
  `cxn_newest` varbinary(14) NOT NULL,
  PRIMARY KEY (`cxn_id`),
  UNIQUE KEY `cx_notification_log_index` (`cxn_date`,`cxn_newest`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
db1137.eqiad.wmnet:3306
*************************** 1. row ***************************
       Table: cx_notification_log
Create Table: CREATE TABLE `cx_notification_log` (
  `cxn_id` int(11) NOT NULL AUTO_INCREMENT,
  `cxn_date` varbinary(14) NOT NULL,
  `cxn_newest` varbinary(14) NOT NULL,
  PRIMARY KEY (`cxn_id`),
  UNIQUE KEY `cx_notification_log_index` (`cxn_date`,`cxn_newest`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
db1120.eqiad.wmnet:3306
*************************** 1. row ***************************
       Table: cx_notification_log
Create Table: CREATE TABLE `cx_notification_log` (
  `cxn_id` int(11) NOT NULL AUTO_INCREMENT,
  `cxn_date` varbinary(14) NOT NULL,
  `cxn_newest` varbinary(14) NOT NULL,
  PRIMARY KEY (`cxn_id`),
  UNIQUE KEY `cx_notification_log_index` (`cxn_date`,`cxn_newest`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
db1103.eqiad.wmnet:3306
*************************** 1. row ***************************
       Table: cx_notification_log
Create Table: CREATE TABLE `cx_notification_log` (
  `cxn_id` int(11) NOT NULL AUTO_INCREMENT,
  `cxn_date` varbinary(14) NOT NULL,
  `cxn_newest` varbinary(14) NOT NULL,
  PRIMARY KEY (`cxn_id`),
  UNIQUE KEY `cx_notification_log_index` (`cxn_date`,`cxn_newest`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
db1102.eqiad.wmnet:3320
*************************** 1. row ***************************
       Table: cx_notification_log
Create Table: CREATE TABLE `cx_notification_log` (
  `cxn_id` int(11) NOT NULL AUTO_INCREMENT,
  `cxn_date` varbinary(14) NOT NULL,
  `cxn_newest` varbinary(14) NOT NULL,
  PRIMARY KEY (`cxn_id`),
  UNIQUE KEY `cx_notification_log_index` (`cxn_date`,`cxn_newest`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8