Title: fix(clickhouse): renumber task_kind migration 029 → 031 by ericallam · Pull Request #3631 · triggerdotdev/trigger.dev · GitHub
Open Graph Title: fix(clickhouse): renumber task_kind migration 029 → 031 by ericallam · Pull Request #3631 · triggerdotdev/trigger.dev
X Title: fix(clickhouse): renumber task_kind migration 029 → 031 by ericallam · Pull Request #3631 · triggerdotdev/trigger.dev
Description: Summary Renumber 029_add_task_kind_to_task_runs_v2.sql → 031_add_task_kind_to_task_runs_v2.sql to fix a deploy-blocking out-of-order migration, and make the DDL idempotent with ADD COLUMN IF NOT EXISTS / DROP COLUMN IF EXISTS. Root cause Migration 030_create_sessions_v1.sql landed on main on 2026-04-28 (PR #3417) and was applied to test cloud ClickHouse on a subsequent deploy. Current goose version on test ClickHouse: 30. Migration 029_add_task_kind_to_task_runs_v2.sql was authored later on 2026-05-10 as part of the Sessions primitive PR series (be1a6cf8). The next test cloud deploy failed because goose strict-mode refused to apply a missing version before the current version: goose run: error: found 1 missing migrations before current version 30: version 29: 029_add_task_kind_to_task_runs_v2.sql Fix Rename to 031_* (next available number after 030). Goose now treats it as a new migration after 030 and applies it cleanly on test/prod where the column does not yet exist. Make the DDL idempotent (ADD COLUMN IF NOT EXISTS). The original 029 may have been applied in environments that ran goose with --allow-missing (e.g. some local dev databases) — those would have the column already, and the rename causes goose to see 031 as new and re-attempt the ADD. Idempotent DDL keeps that path safe. The Down mirrors with DROP COLUMN IF EXISTS. Test plan Test cloud deploy (after this lands) successfully runs the ClickHouse migration step task_kind column shows up on trigger_dev.task_runs_v2 post-migration Local environments that had previously applied 029 do not error on the next goose up
Open Graph Description: Summary Renumber 029_add_task_kind_to_task_runs_v2.sql → 031_add_task_kind_to_task_runs_v2.sql to fix a deploy-blocking out-of-order migration, and make the DDL idempotent with ADD COLUMN IF NOT EX...
X Description: Summary Renumber 029_add_task_kind_to_task_runs_v2.sql → 031_add_task_kind_to_task_runs_v2.sql to fix a deploy-blocking out-of-order migration, and make the DDL idempotent with ADD COLUMN IF NOT EX...
Opengraph URL: https://github.com/triggerdotdev/trigger.dev/pull/3631
X: @github
Domain: github.com
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react-reconciler,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@d5750093facf |
| route-pattern | /:user_id/:repository/pull/:id/files(.:format) |
| route-controller | pull_requests |
| route-action | files |
| fetch-nonce | v2:f3b370d7-16a0-712f-a019-e47cd974cd59 |
| current-catalog-service-hash | ae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b |
| request-id | B228:1E77:5F9C8A:8EDEFC:6AFAF1F2 |
| html-safe-nonce | ac581640650b8f8d15424873ab4833e7a73086cb107e905f00b27475f0d58286 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMjI4OjFFNzc6NUY5QzhBOjhFREVGQzo2QUZBRjFGMiIsInZpc2l0b3JfaWQiOiI0OTQwODE5NTAwMjM3NTE3Mjk4IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | 83321c5617e90ecbbccb00659943aadb5248689635dd3e4fc0254d9d6b22e9b6 |
| hovercard-subject-tag | pull_request:3690801533 |
| github-keyboard-shortcuts | repository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/triggerdotdev/trigger.dev/pull/3631/files |
| twitter:image | https://avatars.githubusercontent.com/u/534?s=400&v=4 |
| twitter:card | summary_large_image |
| og:image | https://avatars.githubusercontent.com/u/534?s=400&v=4 |
| og:image:alt | Summary Renumber 029_add_task_kind_to_task_runs_v2.sql → 031_add_task_kind_to_task_runs_v2.sql to fix a deploy-blocking out-of-order migration, and make the DDL idempotent with ADD COLUMN IF NOT EX... |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | 0178036d8230524a18422872393ab7e708443ae4c2047f758560a2db870c1913 |
| turbo-cache-control | no-preview |
| diff-view | unified |
| go-import | github.com/triggerdotdev/trigger.dev git https://github.com/triggerdotdev/trigger.dev.git |
| octolytics-dimension-user_id | 95297378 |
| octolytics-dimension-user_login | triggerdotdev |
| octolytics-dimension-repository_id | 572570113 |
| octolytics-dimension-repository_nwo | triggerdotdev/trigger.dev |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 572570113 |
| octolytics-dimension-repository_network_root_nwo | triggerdotdev/trigger.dev |
| turbo-body-classes | logged-out env-production page-responsive full-width |
| disable-turbo | true |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | a85e96a83bed7871993e6b1ffda24105928eee17 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width