René's URL Explorer Experiment


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

direct link

Domain: github.com

react-profiling0
react-import-mapreact,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-controllerpull_requests
route-actionfiles
fetch-noncev2:f3b370d7-16a0-712f-a019-e47cd974cd59
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idB228:1E77:5F9C8A:8EDEFC:6AFAF1F2
html-safe-nonceac581640650b8f8d15424873ab4833e7a73086cb107e905f00b27475f0d58286
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMjI4OjFFNzc6NUY5QzhBOjhFREVGQzo2QUZBRjFGMiIsInZpc2l0b3JfaWQiOiI0OTQwODE5NTAwMjM3NTE3Mjk4IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac83321c5617e90ecbbccb00659943aadb5248689635dd3e4fc0254d9d6b22e9b6
hovercard-subject-tagpull_request:3690801533
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/triggerdotdev/trigger.dev/pull/3631/files
twitter:imagehttps://avatars.githubusercontent.com/u/534?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/534?s=400&v=4
og:image:altSummary 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_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None0178036d8230524a18422872393ab7e708443ae4c2047f758560a2db870c1913
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/triggerdotdev/trigger.dev git https://github.com/triggerdotdev/trigger.dev.git
octolytics-dimension-user_id95297378
octolytics-dimension-user_logintriggerdotdev
octolytics-dimension-repository_id572570113
octolytics-dimension-repository_nwotriggerdotdev/trigger.dev
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id572570113
octolytics-dimension-repository_network_root_nwotriggerdotdev/trigger.dev
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releasea85e96a83bed7871993e6b1ffda24105928eee17
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/triggerdotdev/trigger.dev/pull/3631/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ftriggerdotdev%2Ftrigger.dev%2Fpull%2F3631%2Ffiles
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ftriggerdotdev%2Ftrigger.dev%2Fpull%2F3631%2Ffiles
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=triggerdotdev%2Ftrigger.dev
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/3631/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/3631/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/3631/files
triggerdotdevhttps://github.com/triggerdotdev
trigger.devhttps://github.com/triggerdotdev/trigger.dev
Codehttps://github.com/triggerdotdev/trigger.dev
Issues203 (203)https://github.com/triggerdotdev/trigger.dev/issues
Pull requests67 (67)https://github.com/triggerdotdev/trigger.dev/pulls
Discussionshttps://github.com/triggerdotdev/trigger.dev/discussions
Actionshttps://github.com/triggerdotdev/trigger.dev/actions
Projectshttps://github.com/triggerdotdev/trigger.dev/projects
Security and quality39 (39)https://github.com/triggerdotdev/trigger.dev/security
Insightshttps://github.com/triggerdotdev/trigger.dev/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Ftriggerdotdev%2Ftrigger.dev%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Ftriggerdotdev%2Ftrigger.dev%2Fissues%2Fnew%2Fchoose
ericallamhttps://github.com/ericallam
mainhttps://github.com/triggerdotdev/trigger.dev/tree/main
fix/renumber-task-kind-clickhouse-migrationhttps://github.com/triggerdotdev/trigger.dev/tree/fix/renumber-task-kind-clickhouse-migration
Conversation 5 https://github.com/triggerdotdev/trigger.dev/pull/3631
Commits 1 https://github.com/triggerdotdev/trigger.dev/pull/3631/commits
Checks 43 https://github.com/triggerdotdev/trigger.dev/pull/3631/checks
Files changed https://github.com/triggerdotdev/trigger.dev/pull/3631/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/3631/files
fix(clickhouse): renumber task_kind migration 029 → 031 https://github.com/triggerdotdev/trigger.dev/pull/3631/files#top
Show all changes 1 commit https://github.com/triggerdotdev/trigger.dev/pull/3631/files
775287c fix(clickhouse): renumber task_kind migration 029 → 031 ericallam May 15, 2026 https://github.com/triggerdotdev/trigger.dev/pull/3631/commits/775287ce33744917a4b026b514fe3a3ec660abb9
Clear filters https://github.com/triggerdotdev/trigger.dev/pull/3631/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/3631/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/3631/files
029_add_task_kind_to_task_runs_v2.sql https://github.com/triggerdotdev/trigger.dev/pull/3631/files#diff-e03cee58765300d2c79459454c6bf7b1de0c9c586834ef09af2edf31ca352dfc
031_add_task_kind_to_task_runs_v2.sql https://github.com/triggerdotdev/trigger.dev/pull/3631/files#diff-1996c0afa9086254bbf6bd405855991ad1287aa59900813f6b7eb6b60138677b
internal-packages/clickhouse/schema/029_add_task_kind_to_task_runs_v2.sqlhttps://github.com/triggerdotdev/trigger.dev/pull/3631/files#diff-e03cee58765300d2c79459454c6bf7b1de0c9c586834ef09af2edf31ca352dfc
View file https://github.com/triggerdotdev/trigger.dev/blob/eedde2793d2a2245c6bee3066179e9e5e8de6a6c/internal-packages/clickhouse/schema/029_add_task_kind_to_task_runs_v2.sql
Open in desktop https://desktop.github.com
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/3631/files
internal-packages/clickhouse/schema/031_add_task_kind_to_task_runs_v2.sqlhttps://github.com/triggerdotdev/trigger.dev/pull/3631/files#diff-1996c0afa9086254bbf6bd405855991ad1287aa59900813f6b7eb6b60138677b
View file https://github.com/triggerdotdev/trigger.dev/blob/775287ce33744917a4b026b514fe3a3ec660abb9/internal-packages/clickhouse/schema/031_add_task_kind_to_task_runs_v2.sql
Open in desktop https://desktop.github.com
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/3631/files
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/3631/{{ revealButtonHref }}
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.