migrations – Page 5 – Türker Yıldırım

A DELETE that should have been a partition drop

NoteFebruary 29, 20242 min read

A retention job deleting eleven million rows a month from a partitioned table, one batch at a time, without touching the partition boundary. The partitioning had been done…

PHPUnit 11, and a suite that had already been migrated

Deep diveFebruary 29, 20249 min read

11.0 in February, a year after the 10.0 migration did the hard part, and eleven deprecations that were all things 10 had warned about.

removed blocks, and forgetting a resource on purpose

NoteFebruary 28, 20242 min read

Taking a resource out of management used to mean state rm, which is a command run against state and invisible in review. The default being destroy is the…

The service we merged back

Deep diveFebruary 15, 202414 min read

Two services extracted in 2021, a team of four maintaining four pipelines, and forty-one of forty-four releases touching both.

The migration Rector wrote and we rewrote

Deep diveFebruary 7, 202410 min read

An automated refactor across 412 files, a diff of 8,000 lines, and three wrong hunks in it. The review nobody could actually do.

Block hooks, and the plugin that inserts itself

Deep diveDecember 21, 202310 min read

6.4 in November, and a plugin that can insert a block without editing a template. Install instructions that said “now edit your footer”.

Typed class constants, and the interface that had been lying

Deep diveDecember 7, 202310 min read

8.3 on 23 November, and a constant can finally declare a type. An interface constant documented as a string, implemented as an int in one class.

The method that stopped overriding anything in 2019

Deep diveDecember 5, 202310 min read

#[Override] in 8.3, and what it asserts. A subclass method dead since a parent rename four years ago, with a bug report closed as not reproducible.

The unique index we could not add, and the duplicates we had to find first

Deep diveNovember 7, 202310 min read

A constraint that should have existed since 2016, and 1,240 rows that violate it. Support merging customer records by hand, monthly.

The online DDL that was not online

NoteOctober 31, 20231 min read

ALGORITHM=INPLACE does not mean lock-free, and the operation that needed a table rebuild took a metadata lock at the end anyway. Specifying LOCK=NONE turns an unpleasant surprise into…