Skip to content

fix(coderd/database/migrations): renumber the workspace_app_stats index migration to 000641 - #31997

Merged
dylanhuff-at-coder merged 1 commit into
mainfrom
dylan/core-439-renumber-app-stats-index-migration
Nov 10, 2026
Merged

dylanhuff-at-coder merged 1 commit into
mainfrom
dylan/core-439-renumber-app-stats-index-migration

Conversation

@dylanhuff-at-coder

Copy link
Copy Markdown
Collaborator

#31766 and #31748 both added a 000640 migration and both merged, so main currently has two migrations with the same number. Migrations fail to load with duplicate migration file: 000640_workspace_app_stats_session_ended_at_idx.down.sql, which breaks every test that sets up a database.

This moves the workspace_app_stats index to 000641. It's a rename only and dump.sql regenerates unchanged. go test ./coderd/database/migrations/... and the insights and dbrollup tests pass with it.

Part of CORE-439.

…ex migration to 000641

#31766 and #31748 both added a 000640 migration and both merged, so main
has two migrations with the same number and migrations fail to load
("duplicate migration file"). Move the session_ended_at index to 000641.
The schema dump is unchanged.
@dylanhuff-at-coder
dylanhuff-at-coder temporarily deployed to main November 10, 2026 16:09 — with GitHub Actions Inactive
@dylanhuff-at-coder
dylanhuff-at-coder temporarily deployed to main November 10, 2026 16:09 — with GitHub Actions Inactive
@linear-code

linear-code Bot commented Nov 10, 2026

Copy link
Copy Markdown

CORE-439

@f0ssel
f0ssel marked this pull request as ready for review November 10, 2026 16:23
@f0ssel
f0ssel temporarily deployed to main November 10, 2026 16:23 — with GitHub Actions Inactive
@f0ssel
f0ssel marked this pull request as draft November 10, 2026 16:23
@dylanhuff-at-coder
dylanhuff-at-coder marked this pull request as ready for review November 10, 2026 16:25
@dylanhuff-at-coder
dylanhuff-at-coder temporarily deployed to main November 10, 2026 16:25 — with GitHub Actions Inactive
@dylanhuff-at-coder
dylanhuff-at-coder enabled auto-merge (squash) November 10, 2026 16:26
@dylanhuff-at-coder
dylanhuff-at-coder merged commit 66dca90 into main Nov 10, 2026
82 of 85 checks passed
@dylanhuff-at-coder
dylanhuff-at-coder deleted the dylan/core-439-renumber-app-stats-index-migration branch November 10, 2026 16:39
@dylanhuff-at-coder
dylanhuff-at-coder temporarily deployed to main November 10, 2026 16:39 — with GitHub Actions Inactive
@github-actions github-actions Bot locked and limited conversation to collaborators Nov 10, 2026

This branch was previously deployed

1 inactive deployment
main — 9f4ebe4d Deployed Nov 10, 2026 by dylanhuff-at-coder via cla #253572
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants