René's URL Explorer Experiment


Title: fix(engine) prevent MVCC race in blockRunWithWaitpoint pending check by ericallam · Pull Request #3075 · triggerdotdev/trigger.dev · GitHub

Open Graph Title: fix(engine) prevent MVCC race in blockRunWithWaitpoint pending check by ericallam · Pull Request #3075 · triggerdotdev/trigger.dev

X Title: fix(engine) prevent MVCC race in blockRunWithWaitpoint pending check by ericallam · Pull Request #3075 · triggerdotdev/trigger.dev

Description: Split the CTE in blockRunWithWaitpoint so the pending waitpoint check is a separate SQL statement. In READ COMMITTED isolation, each statement gets its own snapshot, so a separate SELECT sees the latest committed state from concurrent completeWaitpoint calls. Previously, the CTE did INSERT + pending check in one statement (one snapshot). If completeWaitpoint committed between the CTE start and the SELECT, the SELECT would still see PENDING due to the stale snapshot. Neither side would enqueue continueRunIfUnblocked, leaving the run stuck forever.

Open Graph Description: Split the CTE in blockRunWithWaitpoint so the pending waitpoint check is a separate SQL statement. In READ COMMITTED isolation, each statement gets its own snapshot, so a separate SELECT sees the l...

X Description: Split the CTE in blockRunWithWaitpoint so the pending waitpoint check is a separate SQL statement. In READ COMMITTED isolation, each statement gets its own snapshot, so a separate SELECT sees the l...

Opengraph URL: https://github.com/triggerdotdev/trigger.dev/pull/3075

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:a4fec186-b47b-ec10-90b9-ef6ee63f300b
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idDEBC:2550AC:AE8552:F5EDF3:6AFB79BF
html-safe-noncefaefd55b9143714bbdca99b1b03cf0cca615a63661bb127660eadedba43ef04e
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJERUJDOjI1NTBBQzpBRTg1NTI6RjVFREYzOjZBRkI3OUJGIiwidmlzaXRvcl9pZCI6IjMyNDY2MzcwNTA1MDI0OTY2MyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac8f559e68203135bd96735d3cbe44b7bf716a73f56d6c152e31572a96e25da57a
hovercard-subject-tagpull_request:3294094436
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/3075/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:altSplit the CTE in blockRunWithWaitpoint so the pending waitpoint check is a separate SQL statement. In READ COMMITTED isolation, each statement gets its own snapshot, so a separate SELECT sees the l...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None0e29e7974fdda2feeaf5c891efd4b23b0734b23480232b62c7bdef13f40b5b48
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
release2e8872b770cc4d5d0cc1f2026afab747a268e2ce
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/triggerdotdev/trigger.dev/pull/3075/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ftriggerdotdev%2Ftrigger.dev%2Fpull%2F3075%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%2F3075%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/3075/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/3075/files
Reloadhttps://github.com/triggerdotdev/trigger.dev/pull/3075/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/waitpoint-mvcc-racehttps://github.com/triggerdotdev/trigger.dev/tree/fix/waitpoint-mvcc-race
Conversation 14 https://github.com/triggerdotdev/trigger.dev/pull/3075
Commits 4 https://github.com/triggerdotdev/trigger.dev/pull/3075/commits
Checks 40 https://github.com/triggerdotdev/trigger.dev/pull/3075/checks
Files changed https://github.com/triggerdotdev/trigger.dev/pull/3075/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/3075/files
fix(engine) prevent MVCC race in blockRunWithWaitpoint pending check https://github.com/triggerdotdev/trigger.dev/pull/3075/files#top
Show all changes 4 commits https://github.com/triggerdotdev/trigger.dev/pull/3075/files
45e4887 fix: prevent MVCC race in blockRunWithWaitpoint pending check ericallam Feb 17, 2026 https://github.com/triggerdotdev/trigger.dev/pull/3075/commits/45e48877cc494f5b90a4df2e83b00533499aac01
ef26a93 docs: add detailed comment explaining MVCC-safe two-statement design … ericallam Feb 17, 2026 https://github.com/triggerdotdev/trigger.dev/pull/3075/commits/ef26a93416da536946d3f62484daf37517193de2
2cff7c0 add server changeset ericallam Feb 25, 2026 https://github.com/triggerdotdev/trigger.dev/pull/3075/commits/2cff7c0c94b68b44e375d383f9d1f5b8167ebf55
a70c48e fixed grammer ericallam Feb 25, 2026 https://github.com/triggerdotdev/trigger.dev/pull/3075/commits/a70c48e8d1c89488001729f1fcae24569d286482
Clear filters https://github.com/triggerdotdev/trigger.dev/pull/3075/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/3075/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/3075/files
fix-blocking-waitpoint-race-condition.md https://github.com/triggerdotdev/trigger.dev/pull/3075/files#diff-d12ffb962b165c1a40c4f784f10a0a500d4d69ca7ebd28bd82237f1afcf9ad0b
waitpointSystem.ts https://github.com/triggerdotdev/trigger.dev/pull/3075/files#diff-18bdabc2533cc85221b94d4292bdd96c0e035ae336748f18ce978efb957c1efd
.server-changes/fix-blocking-waitpoint-race-condition.mdhttps://github.com/triggerdotdev/trigger.dev/pull/3075/files#diff-d12ffb962b165c1a40c4f784f10a0a500d4d69ca7ebd28bd82237f1afcf9ad0b
View file https://github.com/triggerdotdev/trigger.dev/blob/a70c48e8d1c89488001729f1fcae24569d286482/.server-changes/fix-blocking-waitpoint-race-condition.md
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/3075/{{ revealButtonHref }}
internal-packages/run-engine/src/engine/systems/waitpointSystem.tshttps://github.com/triggerdotdev/trigger.dev/pull/3075/files#diff-18bdabc2533cc85221b94d4292bdd96c0e035ae336748f18ce978efb957c1efd
View file https://github.com/triggerdotdev/trigger.dev/blob/a70c48e8d1c89488001729f1fcae24569d286482/internal-packages/run-engine/src/engine/systems/waitpointSystem.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/triggerdotdev/trigger.dev/pull/3075/{{ revealButtonHref }}
https://github.com/triggerdotdev/trigger.dev/pull/3075/files#diff-18bdabc2533cc85221b94d4292bdd96c0e035ae336748f18ce978efb957c1efd
https://github.com/triggerdotdev/trigger.dev/pull/3075/files#diff-18bdabc2533cc85221b94d4292bdd96c0e035ae336748f18ce978efb957c1efd
https://github.com/triggerdotdev/trigger.dev/pull/3075/files#diff-18bdabc2533cc85221b94d4292bdd96c0e035ae336748f18ce978efb957c1efd
https://github.com/triggerdotdev/trigger.dev/pull/3075/files#diff-18bdabc2533cc85221b94d4292bdd96c0e035ae336748f18ce978efb957c1efd
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/3075/files
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/3075/files
https://github.com/triggerdotdev/trigger.dev/pull/3075/files#diff-18bdabc2533cc85221b94d4292bdd96c0e035ae336748f18ce978efb957c1efd
Please reload this pagehttps://github.com/triggerdotdev/trigger.dev/pull/3075/files
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.