Page MenuHomePhabricator

Drop ipblocks in production
Closed, ResolvedPublic

Description

Last part of T355034: Deploy new block_target schema. It is already dropped from core.

  • s1 (renamed in db1169 - T367632#9902949)
  • s2
  • s3
  • s4
  • s5
  • s6
  • s7
  • s8
  • labtestwiki

Event Timeline

@Ladsgroup is this table on all wikis?
For what is worth - not written in enwiki since Apr 8

root@db1163:/srv/sqldata/enwiki# ls -lh ipblocks.ibd
-rw-rw---- 1 mysql mysql 260M Apr  8 23:33 ipblocks.ibd
Marostegui updated the task description. (Show Details)

Mentioned in SAL (#wikimedia-operations) [2024-06-18T11:40:10Z] <marostegui> Rename ipblocks table on db1169 (enwiki) T367632

I have renamed this table on db1169 (enwiki) and will leave it like that for a few days:

cumin2024@db1169.eqiad.wmnet[enwiki]> show tables like 'T%';
+-----------------------+
| Tables_in_enwiki (T%) |
+-----------------------+
| T367632_ipblocks      |
+-----------------------+
1 row in set (0.001 sec)

Mentioned in SAL (#wikimedia-operations) [2024-06-18T11:42:27Z] <marostegui> Delete ipblocks table on clouddb2002-dev (labtestwiki) T367632

Mentioned in SAL (#wikimedia-operations) [2024-06-26T04:51:05Z] <marostegui> dbmaint eqiad Drop ipblocks in s8 T367632

Mentioned in SAL (#wikimedia-operations) [2024-06-26T04:53:29Z] <marostegui> dbmaint eqiad Drop ipblocks in s2 T367632

Mentioned in SAL (#wikimedia-operations) [2024-06-26T05:01:56Z] <marostegui> dbmaint eqiad Drop ipblocks in s5 T367632

Mentioned in SAL (#wikimedia-operations) [2024-06-26T05:57:36Z] <marostegui> dbmaint eqiad Drop ipblocks in s4 T367632

Mentioned in SAL (#wikimedia-operations) [2024-06-26T05:59:56Z] <marostegui> dbmaint eqiad Drop ipblocks in s3 T367632

Dropping it in s3, which will take around 8 hours.

Mentioned in SAL (#wikimedia-operations) [2024-06-26T06:01:37Z] <marostegui> dbmaint eqiad Drop ipblocks in s1 T367632