Create a maintenance script to populate block and block_target from ipblocks
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	dmaza
	Nov 2 2023, 10:35 AM

Description

Review parent task (T346293) for more context, and a high-level overview of the migration plan.

Context:

block is the new table that holds blocks against accounts, IPs and IP ranges.
block_target is a new table introduced to support multiple blocks.

This task is to create a script to populate block and block_target with the data from ipblocks.

Details

	Subject	Repo	Branch	Lines +/-
	MigrateBlocks: maintenance script for migrating to multiblocks schema	mediawiki/core	master	+165 -0

Customize query in gerrit

Related Objects
Search...

Status	Subtype	Assigned	Task
Open		None	T204903 Epic ⚡️ unprioritized Partial Blocks features
Open	BUG REPORT	None	T25310 Global suppression does not work properly when the target has already been locally blocked
Open		None	T366388 Multiblocks: Edit and Remove a block
Open		None	T349689 Admins should be able to edit an active block without needing to delete it first
Open		None	T194697 Multiblocks — Allow for multiple, simultaneous blocks with different expiration dates.
Resolved	Aug 21 2018	dbarratt	T201692 Prepare a technical plan for Multi-blocks
Declined		None	T202572 Create Migration Plan from current schema to Multi-block schema
Open		None	T202673 RFC: Multiblocks - let admins create multiple, overlapping blocks on a single user
Resolved		tstarling	T345683 Review of MediaWiki block-related code
Resolved		tstarling	T346293 ipblocks schema redesign for multiblocks
Resolved		MusikAnimal	T350361 Create a maintenance script to populate block and block_target from ipblocks
Resolved		tstarling	T349883 Multiblocks support in ApiBlockInfoTrait and ApiQueryBlockInfoTrait
Open		None	T351508 Decide the limit of multiblocks
Open		None	T351511 How to deal with redundant block

Event Timeline

dmaza claimed this task.Nov 2 2023, 10:35 AM

dmaza created this task.

dmaza moved this task from Ready 🎬 to In Development 💻 on the Community-Tech (CommTech-Kanban) board.

Please fix T282890 -- if any rows have ipb_parent_block_id=0, they should have bl_parent_block_id=null in the new schema.

In T350361#9307303, @tstarling wrote:

Please fix T282890 -- if any rows have ipb_parent_block_id=0, they should have bl_parent_block_id=null in the new schema.

Sure

dmaza removed dmaza as the assignee of this task.Nov 27 2023, 3:46 PM

dmaza moved this task from In Development 💻 to Ready 🎬 on the Community-Tech (CommTech-Kanban) board.

MusikAnimal claimed this task.Nov 27 2023, 5:31 PM

MusikAnimal moved this task from Ready 🎬 to In Development 💻 on the Community-Tech (CommTech-Kanban) board.

MusikAnimal renamed this task from Create a maintenance script to populate block_target and ipb_target on ipblocks to Create a maintenance script to populate block and block_target from ipblocks.Nov 28 2023, 1:11 AM

MusikAnimal updated the task description. (Show Details)

Change 977985 had a related patch set uploaded (by MusikAnimal; author: MusikAnimal):

[mediawiki/core@master] MigrateBlocks: maintenance script for migrating to multiblocks schema

https://gerrit.wikimedia.org/r/977985

gerritbot added a project: Patch-For-Review.Nov 28 2023, 7:41 AM

MusikAnimal moved this task from In Development 💻 to Review/Feedback 💬 on the Community-Tech (CommTech-Kanban) board.Nov 28 2023, 6:49 PM

MusikAnimal mentioned this in T353483: Converge infinity values into one constant.Dec 15 2023, 2:58 AM

Change 977985 merged by jenkins-bot:

[mediawiki/core@master] MigrateBlocks: maintenance script for migrating to multiblocks schema

https://gerrit.wikimedia.org/r/977985

Maintenance_bot removed a project: Patch-For-Review.Jan 11 2024, 4:30 AM

tstarling closed this task as Resolved.Jan 15 2024, 5:53 AM

MusikAnimal moved this task from Review/Feedback 💬 to Done 🏁 on the Community-Tech (CommTech-Kanban) board.Apr 10 2024, 4:35 PM

Create a maintenance script to populate block and block_target from ipblocksClosed, ResolvedPublicActions

Description

Details

Related ObjectsSearch...

Event Timeline

Create a maintenance script to populate block and block_target from ipblocks
Closed, ResolvedPublic
Actions

Related Objects
Search...