René's URL Explorer Experiment


Title: fix(db): optimize Project backfill and repair archived workflows by mzxchandra · Pull Request #8962 · simstudioai/sim · GitHub

Open Graph Title: fix(db): optimize Project backfill and repair archived workflows by mzxchandra · Pull Request #8962 · simstudioai/sim

X Title: fix(db): optimize Project backfill and repair archived workflows by mzxchandra · Pull Request #8962 · simstudioai/sim

Description: Summary Keep healthy Project backfill batches at 200 new-Project singletons or 50 existing-Project singletons; process fork families atomically. Remove elapsed-time batch shrinking and the pause after successful batches. Bulk-load existing Project evidence with indexed membership lookups and combine timeout/validation queries to reduce database round trips. Remove the outer 20-minute and 10,000-batch scheduling caps. Preserve transaction timeouts, bounded contention retries, authority/constraint guards, and resumable completion receipts for the existing migration. Automatically archive workflows left active inside archived workspaces, disabling their dependent records in a bounded transaction. Preserve existing archive timestamps and the provider-cleanup guard. Type of Change Bug fix Testing 72 focused PostgreSQL integration tests, including partial-progress retry, bulk evidence for distinct/shared Projects, automatic archive repair, rollback, timestamp preservation, provider-cleanup refusal, and temporary/persistent advisory-lock contention. Synthetic database-latency benchmarks verify preserved identities, replay, final constraints, and zero invariant violations. Targeted Biome and git diff checks. Full repository checks run in hosted CI. Checklist Code follows project style guidelines Self-reviewed my changes Tests added/updated and passing 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 Keep healthy Project backfill batches at 200 new-Project singletons or 50 existing-Project singletons; process fork families atomically. Remove elapsed-time batch shrinking and the pause ...

X Description: Summary Keep healthy Project backfill batches at 200 new-Project singletons or 50 existing-Project singletons; process fork families atomically. Remove elapsed-time batch shrinking and the pause ...

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

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:c8487686-87ee-f61b-d1d5-fd2df285c3f0
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idE458:73CE1:9AA8F4:D45AA3:6AFB4BFF
html-safe-nonce1b4d902e24bb88e3fcd2f49f161e2417ba91324911c30218d6b92b3c6cdcd22c
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFNDU4OjczQ0UxOjlBQThGNDpENDVBQTM6NkFGQjRCRkYiLCJ2aXNpdG9yX2lkIjoiOTAwMjkxNjUxMjcxNjc3MDMwMyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmacf17cd92446a56803c0f7c7ddc9a276a2a90662b36eea82ca036018a707773c0f
hovercard-subject-tagpull_request:4838770126
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/8962/files
twitter:imagehttps://avatars.githubusercontent.com/u/129460234?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/129460234?s=400&v=4
og:image:altSummary Keep healthy Project backfill batches at 200 new-Project singletons or 50 existing-Project singletons; process fork families atomically. Remove elapsed-time batch shrinking and the pause ...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Noneacf7616d06cc051644705b379878c9bb13dc5e70ecf4ffd9b34140f8ac01d7e1
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
release26504db649b58525278f77a52b80ba5f10d5f4de
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/8962/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8962%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%2F8962%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/8962/files
Reloadhttps://github.com/simstudioai/sim/pull/8962/files
Reloadhttps://github.com/simstudioai/sim/pull/8962/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues129 (129)https://github.com/simstudioai/sim/issues
Pull requests197 (197)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
mzxchandrahttps://github.com/mzxchandra
staginghttps://github.com/simstudioai/sim/tree/staging
codex/project-backfill-benchhttps://github.com/simstudioai/sim/tree/codex/project-backfill-bench
Conversation 10 https://github.com/simstudioai/sim/pull/8962
Commits 3 https://github.com/simstudioai/sim/pull/8962/commits
Checks 51 https://github.com/simstudioai/sim/pull/8962/checks
Files changed https://github.com/simstudioai/sim/pull/8962/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8962/files
fix(db): optimize Project backfill and repair archived workflows https://github.com/simstudioai/sim/pull/8962/files#top
Show all changes 3 commits https://github.com/simstudioai/sim/pull/8962/files
a58c696 fix(db): reduce Project backfill round trips and scheduling limits mzxchandra Oct 13, 2026 https://github.com/simstudioai/sim/pull/8962/commits/a58c6961cec5573061209e539bbb3090f29e6e7b
5518616 fix(db): repair archived workspace workflows during Project backfill mzxchandra Oct 13, 2026 https://github.com/simstudioai/sim/pull/8962/commits/551861669d52f6faac519068c05593885c31ada8
358283e fix(db): retry busy Project archive repairs mzxchandra Oct 13, 2026 https://github.com/simstudioai/sim/pull/8962/commits/358283e3df65feb32231b7a4944f95608f30025c
Clear filters https://github.com/simstudioai/sim/pull/8962/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8962/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8962/files
project-backfill.ts https://github.com/simstudioai/sim/pull/8962/files#diff-66f5f36696cfc32d71813a17b8316defc112a22431ad68929663e4eb0a58b56e
project-repairs.ts https://github.com/simstudioai/sim/pull/8962/files#diff-9a86a1c03e3e15e2bf03c2d6996c816d7fe35d78ff6c522ba2a00772400b8464
0032_project_membership.ts https://github.com/simstudioai/sim/pull/8962/files#diff-8a6ad2bda7ebc6230d751b9845c93b171e4ff2e3dae24b0463b2bf0d11ed96a4
project-contract.integration.ts https://github.com/simstudioai/sim/pull/8962/files#diff-b1a77ba5f5c2b26e53d56261961d57e2156eedb345d9a2e892504b7fbcbb363a
packages/db/maintenance/project-backfill.tshttps://github.com/simstudioai/sim/pull/8962/files#diff-66f5f36696cfc32d71813a17b8316defc112a22431ad68929663e4eb0a58b56e
View file https://github.com/simstudioai/sim/blob/358283e3df65feb32231b7a4944f95608f30025c/packages/db/maintenance/project-backfill.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8962/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8962/files#diff-66f5f36696cfc32d71813a17b8316defc112a22431ad68929663e4eb0a58b56e
https://github.com/simstudioai/sim/pull/8962/files#diff-66f5f36696cfc32d71813a17b8316defc112a22431ad68929663e4eb0a58b56e
https://github.com/simstudioai/sim/pull/8962/files#diff-66f5f36696cfc32d71813a17b8316defc112a22431ad68929663e4eb0a58b56e
https://github.com/simstudioai/sim/pull/8962/files#diff-66f5f36696cfc32d71813a17b8316defc112a22431ad68929663e4eb0a58b56e
https://github.com/simstudioai/sim/pull/8962/files#diff-66f5f36696cfc32d71813a17b8316defc112a22431ad68929663e4eb0a58b56e
https://github.com/simstudioai/sim/pull/8962/files#diff-66f5f36696cfc32d71813a17b8316defc112a22431ad68929663e4eb0a58b56e
https://github.com/simstudioai/sim/pull/8962/files#diff-66f5f36696cfc32d71813a17b8316defc112a22431ad68929663e4eb0a58b56e
https://github.com/simstudioai/sim/pull/8962/files#diff-66f5f36696cfc32d71813a17b8316defc112a22431ad68929663e4eb0a58b56e
packages/db/maintenance/project-repairs.tshttps://github.com/simstudioai/sim/pull/8962/files#diff-9a86a1c03e3e15e2bf03c2d6996c816d7fe35d78ff6c522ba2a00772400b8464
View file https://github.com/simstudioai/sim/blob/358283e3df65feb32231b7a4944f95608f30025c/packages/db/maintenance/project-repairs.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8962/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8962/files#diff-9a86a1c03e3e15e2bf03c2d6996c816d7fe35d78ff6c522ba2a00772400b8464
https://github.com/simstudioai/sim/pull/8962/files#diff-9a86a1c03e3e15e2bf03c2d6996c816d7fe35d78ff6c522ba2a00772400b8464
packages/db/script-migrations/0032_project_membership.tshttps://github.com/simstudioai/sim/pull/8962/files#diff-8a6ad2bda7ebc6230d751b9845c93b171e4ff2e3dae24b0463b2bf0d11ed96a4
View file https://github.com/simstudioai/sim/blob/358283e3df65feb32231b7a4944f95608f30025c/packages/db/script-migrations/0032_project_membership.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8962/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8962/files#diff-8a6ad2bda7ebc6230d751b9845c93b171e4ff2e3dae24b0463b2bf0d11ed96a4
https://github.com/simstudioai/sim/pull/8962/files#diff-8a6ad2bda7ebc6230d751b9845c93b171e4ff2e3dae24b0463b2bf0d11ed96a4
https://github.com/simstudioai/sim/pull/8962/files#diff-8a6ad2bda7ebc6230d751b9845c93b171e4ff2e3dae24b0463b2bf0d11ed96a4
https://github.com/simstudioai/sim/pull/8962/files#diff-8a6ad2bda7ebc6230d751b9845c93b171e4ff2e3dae24b0463b2bf0d11ed96a4
https://github.com/simstudioai/sim/pull/8962/files#diff-8a6ad2bda7ebc6230d751b9845c93b171e4ff2e3dae24b0463b2bf0d11ed96a4
https://github.com/simstudioai/sim/pull/8962/files#diff-8a6ad2bda7ebc6230d751b9845c93b171e4ff2e3dae24b0463b2bf0d11ed96a4
https://github.com/simstudioai/sim/pull/8962/files#diff-8a6ad2bda7ebc6230d751b9845c93b171e4ff2e3dae24b0463b2bf0d11ed96a4
https://github.com/simstudioai/sim/pull/8962/files#diff-8a6ad2bda7ebc6230d751b9845c93b171e4ff2e3dae24b0463b2bf0d11ed96a4
Please reload this pagehttps://github.com/simstudioai/sim/pull/8962/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8962/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.