Page MenuHomePhabricator

Drop wikidatawiki.wb_items_per_site_old from s8 hosts
Closed, ResolvedPublic

Description

wikidatawiki.wb_items_per_site_old is the old, renamed table after it was restored for T249565's incident and it is no longer needed.
It should be dropped.

It exists on all the host:

labsdb1012.eqiad.wmnet:3306
wb_items_per_site_old
labsdb1011.eqiad.wmnet:3306
wb_items_per_site_old
labsdb1010.eqiad.wmnet:3306
wb_items_per_site_old
labsdb1009.eqiad.wmnet:3306
wb_items_per_site_old
dbstore1005.eqiad.wmnet:3318
wb_items_per_site_old
db2100.codfw.wmnet:3318
wb_items_per_site_old
db2094.codfw.wmnet:3318
wb_items_per_site_old
db2086.codfw.wmnet:3318
wb_items_per_site_old
db2085.codfw.wmnet:3318
wb_items_per_site_old
db2083.codfw.wmnet:3306
wb_items_per_site_old
db2082.codfw.wmnet:3306
wb_items_per_site_old
db2081.codfw.wmnet:3306
wb_items_per_site_old
db2080.codfw.wmnet:3306
wb_items_per_site_old
db2079.codfw.wmnet:3306
wb_items_per_site_old
db1126.eqiad.wmnet:3306
wb_items_per_site_old
db1124.eqiad.wmnet:3318
wb_items_per_site_old
db1116.eqiad.wmnet:3318
wb_items_per_site_old
db1114.eqiad.wmnet:3306
wb_items_per_site_old
db1111.eqiad.wmnet:3306
wb_items_per_site_old
db1109.eqiad.wmnet:3306
wb_items_per_site_old
db1104.eqiad.wmnet:3306
wb_items_per_site_old
db1101.eqiad.wmnet:3318
wb_items_per_site_old
db1099.eqiad.wmnet:3318
wb_items_per_site_old
db1092.eqiad.wmnet:3306
wb_items_per_site_old
db1087.eqiad.wmnet:3306
wb_items_per_site_old

Event Timeline

Marostegui triaged this task as Medium priority.Apr 16 2020, 6:00 AM
Marostegui moved this task from Triage to Pending comment on the DBA board.

Removal progress (being done by @Kormat) :

  • codfw (to be done with replication)
  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1005
  • db1126
  • db1124
  • db1116
  • db1114
  • db1111
  • db1109
  • db1104
  • db1101
  • db1099
  • db1092
  • db1087

Mentioned in SAL (#wikimedia-operations) [2020-04-17T08:15:04Z] <kormat> dropping wikidatawiki.wb_items_per_site_old table in codfw T250345

Mentioned in SAL (#wikimedia-operations) [2020-04-17T09:00:01Z] <kormat> dropping wikidatawiki.wb_items_per_site_old table in eqiad (non-labs hosts) T250345

It's gone:

root@cumin1001:~# ~kormat/section s8 | while read host port; do echo "=====> $host"; mysql.py -h $host -P $port wikidatawiki -e 'show tables like "wb_items_per_site_old";'; done
=====> labsdb1012.eqiad.wmnet
=====> labsdb1011.eqiad.wmnet
=====> labsdb1010.eqiad.wmnet
=====> labsdb1009.eqiad.wmnet
=====> dbstore1005.eqiad.wmnet
=====> db2100.codfw.wmnet
=====> db2094.codfw.wmnet
=====> db2086.codfw.wmnet
=====> db2085.codfw.wmnet
=====> db2083.codfw.wmnet
=====> db2082.codfw.wmnet
=====> db2081.codfw.wmnet
=====> db2080.codfw.wmnet
=====> db2079.codfw.wmnet
=====> db1126.eqiad.wmnet
=====> db1124.eqiad.wmnet
=====> db1116.eqiad.wmnet
=====> db1114.eqiad.wmnet
=====> db1111.eqiad.wmnet
=====> db1109.eqiad.wmnet
=====> db1104.eqiad.wmnet
=====> db1101.eqiad.wmnet
=====> db1099.eqiad.wmnet
=====> db1092.eqiad.wmnet
=====> db1087.eqiad.wmnet