René's URL Explorer Experiment


Title: fix(billing): acknowledge Stripe webhooks whose subscription references a missing organization by waleedlatif1 · Pull Request #8809 · simstudioai/sim · GitHub

Open Graph Title: fix(billing): acknowledge Stripe webhooks whose subscription references a missing organization by waleedlatif1 · Pull Request #8809 · simstudioai/sim

X Title: fix(billing): acknowledge Stripe webhooks whose subscription references a missing organization by waleedlatif1 · Pull Request #8809 · simstudioai/sim

Description: Summary An Enterprise subscription whose referenced organization no longer exists made every customer.subscription.updated/created webhook return 400: the Enterprise reconcile threw "Enterprise organization not found", and the usage-limit step after it threw for the same reference. Stripe retried for ~3 days and then dropped the event; a retry can never succeed because a deleted organization does not come back The Enterprise reconcile now returns an organization-missing outcome from its locked transaction (before any write) and the handler logs it at error level with the Stripe subscription, customer, reference, event type and status, then acknowledges. Every transient case — issuance not yet matching Stripe, lease/lock, DB errors, seat/entitlement conflicts — still throws so Stripe retries. Organizations are always committed before their Stripe subscription is created, so "missing" is never "not yet" New typed SubscriptionReferenceNotFoundError (reference is neither an organization nor a user): syncSubscriptionUsageLimits throws it and handleSubscriptionUsageUpdate acknowledges only that type; other errors still fail the webhook ensureOrganizationForTeamSubscription treated a reference that is not an organization as a user id, so a dangling organization id tried to create a new organization owned by that id (failing on the member foreign key every time). It now checks the user exists first and throws the typed error; onSubscriptionUpdate logs it and returns Type of Change Bug fix Testing New lib/billing/webhooks/enterprise-missing-organization.integration.ts (real Postgres, the real Better Auth Stripe plugin over HTTP, in-memory Stripe): renewal for a row with a missing organization returns 200 and still records the Stripe period; no organization/member is created for the dangling reference; a dashboard-created subscription naming a missing organization is acknowledged and records nothing; an issuance Stripe hasn't caught up with still fails the webhook (guard against over-acknowledging). The first three fail on the previous code; each fix reverted alone turns its test red All lib/billing integration suites, root bun run test, bun run lint, bun run type-check, bun run check:audits, bun run docs-manifest:check, block-registry check Checklist Code follows project style guidelines Self-reviewed my changes Tests added/updated and passing (new tests pass the test-audit authoring gate) No new warnings introduced I confirm that I have read and agree to the terms outlined in the Contributor License Agreement (CLA)

Open Graph Description: Summary An Enterprise subscription whose referenced organization no longer exists made every customer.subscription.updated/created webhook return 400: the Enterprise reconcile threw "Enterpri...

X Description: Summary An Enterprise subscription whose referenced organization no longer exists made every customer.subscription.updated/created webhook return 400: the Enterprise reconcile threw "Ente...

Opengraph URL: https://github.com/simstudioai/sim/pull/8809

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:81ff42a4-42b6-c17d-56a9-efc40a7a5e24
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-id9F22:18732E:12AB9C5:198C007:6AFB6F43
html-safe-nonce551a08834ee4a75113b203657671dc9facc883ce19cb0117783634641fc51b3e
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5RjIyOjE4NzMyRToxMkFCOUM1OjE5OEMwMDc6NkFGQjZGNDMiLCJ2aXNpdG9yX2lkIjoiODUwODc0Nzk1OTg0MzgzODExIiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac8994f88617ea959b5c7df1514bb40c469081c19c5a8ac807d1368715a341814f
hovercard-subject-tagpull_request:4792029985
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/simstudioai/sim/pull/8809/files
twitter:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
og:image:altSummary An Enterprise subscription whose referenced organization no longer exists made every customer.subscription.updated/created webhook return 400: the Enterprise reconcile threw "Enterpri...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Nonecca289ecd54650fcf3c0b037a58b97186dee2cc4406819d87fab93728fd83700
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/simstudioai/sim git https://github.com/simstudioai/sim.git
octolytics-dimension-user_id199344406
octolytics-dimension-user_loginsimstudioai
octolytics-dimension-repository_id912559512
octolytics-dimension-repository_nwosimstudioai/sim
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id912559512
octolytics-dimension-repository_network_root_nwosimstudioai/sim
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
release88808b1fae5ab8a526a73e7ce5542a10eb9d6971
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/8809/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8809%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%2Fsimstudioai%2Fsim%2Fpull%2F8809%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=simstudioai%2Fsim
Reloadhttps://github.com/simstudioai/sim/pull/8809/files
Reloadhttps://github.com/simstudioai/sim/pull/8809/files
Reloadhttps://github.com/simstudioai/sim/pull/8809/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues129 (129)https://github.com/simstudioai/sim/issues
Pull requests198 (198)https://github.com/simstudioai/sim/pulls
Actionshttps://github.com/simstudioai/sim/actions
Projectshttps://github.com/simstudioai/sim/projects
Security and qualityhttps://github.com/simstudioai/sim/security
Insightshttps://github.com/simstudioai/sim/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
waleedlatif1https://github.com/waleedlatif1
staginghttps://github.com/simstudioai/sim/tree/staging
fix/enterprise-webhook-missing-orghttps://github.com/simstudioai/sim/tree/fix/enterprise-webhook-missing-org
Conversation 22 https://github.com/simstudioai/sim/pull/8809
Commits 3 https://github.com/simstudioai/sim/pull/8809/commits
Checks 46 https://github.com/simstudioai/sim/pull/8809/checks
Files changed https://github.com/simstudioai/sim/pull/8809/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8809/files
fix(billing): acknowledge Stripe webhooks whose subscription references a missing organization https://github.com/simstudioai/sim/pull/8809/files#top
Show all changes 3 commits https://github.com/simstudioai/sim/pull/8809/files
25d94d8 fix(billing): acknowledge Stripe webhooks whose subscription referenc… waleedlatif1 Oct 8, 2026 https://github.com/simstudioai/sim/pull/8809/commits/25d94d800c7c1b9c1cfd00121b69b9a698677762
ea4d0f9 test(billing): prove the not-yet-matching issuance branch by redelive… waleedlatif1 Oct 8, 2026 https://github.com/simstudioai/sim/pull/8809/commits/ea4d0f908a9c84e2121ae32362ff413aa82145a6
bc666fe test(testing): a swapped price in the Stripe fake no longer reports t… waleedlatif1 Oct 8, 2026 https://github.com/simstudioai/sim/pull/8809/commits/bc666fe6c383adb4adc222251a9836537176d2f8
Clear filters https://github.com/simstudioai/sim/pull/8809/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8809/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8809/files
organization.test.ts https://github.com/simstudioai/sim/pull/8809/files#diff-a039e5e03e58e6bf58e91f49d6d1b9c00a00b6146cb3f06fa4469274661e654c
organization.ts https://github.com/simstudioai/sim/pull/8809/files#diff-89b65bc5e4f411dfe94bcd00666debd6172f9f47cd8748a22b20f34b5aa3e52f
errors.ts https://github.com/simstudioai/sim/pull/8809/files#diff-56cbbde4907057356c1fe242aa2322b05beaff131587b5d2af1409f62ba10906
enterprise-missing-organization.integration.ts https://github.com/simstudioai/sim/pull/8809/files#diff-4873df096d6b6205589b1e00bdd6a0f9e2ef3e7500ea4de0d87a45f537a86f9c
enterprise.ts https://github.com/simstudioai/sim/pull/8809/files#diff-c47fa982dffc79cc96b67634720def5b91ac9924af897bd2bcf87d73cf200c46
subscription-usage.ts https://github.com/simstudioai/sim/pull/8809/files#diff-19f67a8e864e25904404a827ce2e5354c841734b750c22a938c1e8142fc1da42
stripe.mock.ts https://github.com/simstudioai/sim/pull/8809/files#diff-092183da8002e3f8ad6e6104ccc310f28df017fe8b8a6083919e34b0f7829301
apps/sim/lib/billing/organization.test.tshttps://github.com/simstudioai/sim/pull/8809/files#diff-a039e5e03e58e6bf58e91f49d6d1b9c00a00b6146cb3f06fa4469274661e654c
View file https://github.com/simstudioai/sim/blob/bc666fe6c383adb4adc222251a9836537176d2f8/apps/sim/lib/billing/organization.test.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8809/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8809/files#diff-a039e5e03e58e6bf58e91f49d6d1b9c00a00b6146cb3f06fa4469274661e654c
https://github.com/simstudioai/sim/pull/8809/files#diff-a039e5e03e58e6bf58e91f49d6d1b9c00a00b6146cb3f06fa4469274661e654c
apps/sim/lib/billing/organization.tshttps://github.com/simstudioai/sim/pull/8809/files#diff-89b65bc5e4f411dfe94bcd00666debd6172f9f47cd8748a22b20f34b5aa3e52f
View file https://github.com/simstudioai/sim/blob/bc666fe6c383adb4adc222251a9836537176d2f8/apps/sim/lib/billing/organization.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8809/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8809/files#diff-89b65bc5e4f411dfe94bcd00666debd6172f9f47cd8748a22b20f34b5aa3e52f
https://github.com/simstudioai/sim/pull/8809/files#diff-89b65bc5e4f411dfe94bcd00666debd6172f9f47cd8748a22b20f34b5aa3e52f
https://github.com/simstudioai/sim/pull/8809/files#diff-89b65bc5e4f411dfe94bcd00666debd6172f9f47cd8748a22b20f34b5aa3e52f
https://github.com/simstudioai/sim/pull/8809/files#diff-89b65bc5e4f411dfe94bcd00666debd6172f9f47cd8748a22b20f34b5aa3e52f
https://github.com/simstudioai/sim/pull/8809/files#diff-89b65bc5e4f411dfe94bcd00666debd6172f9f47cd8748a22b20f34b5aa3e52f
https://github.com/simstudioai/sim/pull/8809/files#diff-89b65bc5e4f411dfe94bcd00666debd6172f9f47cd8748a22b20f34b5aa3e52f
https://github.com/simstudioai/sim/pull/8809/files#diff-89b65bc5e4f411dfe94bcd00666debd6172f9f47cd8748a22b20f34b5aa3e52f
https://github.com/simstudioai/sim/pull/8809/files#diff-89b65bc5e4f411dfe94bcd00666debd6172f9f47cd8748a22b20f34b5aa3e52f
apps/sim/lib/billing/subscriptions/errors.tshttps://github.com/simstudioai/sim/pull/8809/files#diff-56cbbde4907057356c1fe242aa2322b05beaff131587b5d2af1409f62ba10906
View file https://github.com/simstudioai/sim/blob/bc666fe6c383adb4adc222251a9836537176d2f8/apps/sim/lib/billing/subscriptions/errors.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8809/{{ revealButtonHref }}
Please reload this pagehttps://github.com/simstudioai/sim/pull/8809/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8809/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.