promote(db): register extra_large via migration 0038 to UAT (GRO-2004) #131

Merged

The Dogfather merged 3 commits from dev into uat 2026-06-01 14:52:14 +00:00

Conversation 0 Commits 3 Files Changed 3

+12

The Dogfather commented 2026-06-01 14:49:56 +00:00

Member

Copy Link

Copy Source

Promotes migration 0038 (extra_large pet_size_category re-register) from dev to uat.

• Source: PR #130 (merged to dev), QA + CTO approved
• After UAT deploy + migrate runs, pet_size_category enum gains extra_large, unblocking the crashlooping seed-test-data job
• Fixes the [GRO-1999] drizzle journal skip

cc @cpfarhood

Promotes migration 0038 (extra_large pet_size_category re-register) from `dev` to `uat`. - Source: PR #130 (merged to dev), QA + CTO approved - After UAT deploy + migrate runs, `pet_size_category` enum gains `extra_large`, unblocking the crashlooping `seed-test-data` job - Fixes the [GRO-1999] drizzle journal skip cc @cpfarhood

The Dogfather added 3 commits 2026-06-01 14:49:56 +00:00

docs(UAT_PLAYBOOK): add TC-API-3.28 for pet_size_category enum (GRO-1999) (#127) a9bac033fd

fix(db): register extra_large via migration 0038 (GRO-1999) ... 423d4bf72d

GRO-1979 added 0037_add_extra_large_to_pet_size_category with a journal
'when' of 1751500000000 — below the 0033 high-water mark (1779500000000)
on existing UAT/persistent DBs. Drizzle only applies a migration when its
journal.when is strictly greater than max(applied created_at), so 0037
was silently skipped, leaving pet_size_category without 'extra_large'
and crashing the UAT seed-test-data job (22P02 enum error).

This adds 0038 with a monotonic 'when' (1780000000000) so it applies on
both existing UAT/persistent DBs and fresh DBs. Statement is idempotent
(ADD VALUE IF NOT EXISTS) and a single auto-commit DDL (ADD VALUE cannot
run inside a transaction block).

Do not modify 0033/0034/0036/0037 — re-registering extra_large is correct
since the drizzle PetSizeCategory type and seed.ts both use that value.

GRO-2004

Co-Authored-By: Paperclip <noreply@paperclip.ing>

Merge pull request 'fix(db): register extra_large via migration 0038 (GRO-1999)' (#130) from flea/gro-1999-migration-0038 into dev 7f8a1f4bcd

The Dogfather merged commit f7f88156e1 into uat 2026-06-01 14:52:14 +00:00

Sign in to join this conversation.

Reviewers

No Reviewers

Labels

Clear labels

bug

Something isn't working

documentation

Improvements or additions to documentation

duplicate

This issue or pull request already exists

enhancement

New feature or request

good first issue

Good for newcomers

help wanted

Extra attention is needed

invalid

This doesn't seem right

question

Further information is requested

wontfix

This will not be worked on

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

ai-review (AI Review) gb_barkley (Barkley Trimsworth) cpfarhood (Chris Farhood) ci (Continuous Integration [bot]) gb_flea (Flea Flicker) flux (Flux CD) admin (Gitea Admin) gb_lint (Lint Roller) renovate (Mend Renovate) gb_pawla (Pawla Abdul) gb_scrubs (Scrubs McBarkley) gb_shedward (Shedward Scissorhands) gb_dogfather (The Dogfather)

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: groombook/api#131