[Wikidata-bugs] [Maniphest] [Commented On] T144010: Drop eu_touched in production

[Marostegui]

Marostegui added a comment.

A quick salt run:

sudo salt -C 'G@mysql_role:master and G@site:codfw and G@mysql_group:core' cmd.run 'find /srv/sqldata/ -name wbc_entity_usage.frm '

Shows it is present in all the shards, so what I have done is rename this column in db2048 (s1 - enwiki) to make sure nothing breaks before starting to drop it for good.

So I have run this:

./software/dbtools/osc_host.sh --host=db2048.codfw.wmnet --port=3306 --db=enwiki --table=wbc_entity_usage --method=ddl --no-replicate "change column eu_touched TO_DROP_eu_touched binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0';"

So:

root@neodymium:/home/marostegui/git# mysql -hdb2048.codfw.wmnet enwiki -e "show create table wbc_entity_usage\G"
*************************** 1. row ***************************
       Table: wbc_entity_usage
Create Table: CREATE TABLE `wbc_entity_usage` (
  `eu_row_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `eu_entity_id` varbinary(255) NOT NULL,
  `eu_aspect` varbinary(37) NOT NULL,
  `eu_page_id` int(11) NOT NULL,
  `TO_DROP_eu_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  PRIMARY KEY (`eu_row_id`),
  UNIQUE KEY `eu_entity_id` (`eu_entity_id`,`eu_aspect`,`eu_page_id`),
  KEY `eu_page_id` (`eu_page_id`,`eu_entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28284267 DEFAULT CHARSET=binary

TASK DETAIL

https://phabricator.wikimedia.org/T144010

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Marostegui
Cc: jcrespo, Aklapper, gerritbot, hoo, Marostegui, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs