René's URL Explorer Experiment


Title: chore(search): add paced projection replacement and data retirement by icecrasher321 · Pull Request #8534 · simstudioai/sim · GitHub

Open Graph Title: chore(search): add paced projection replacement and data retirement by icecrasher321 · Pull Request #8534 · simstudioai/sim

X Title: chore(search): add paced projection replacement and data retirement by icecrasher321 · Pull Request #8534 · simstudioai/sim

Description: Summary Follow #8528, now merged into staging. Add operator-run, checkpointed replacement of embedding_search that retains ordinary-KB vectors and retires indexed Search chunks in paced batches. Deploying this PR starts no maintenance. Build shared HNSW indexes on the empty replacement and populate them incrementally. Validate retained data and concurrent changes before an explicit, fail-fast cutover; retire the backup and remove capture at separate operator gates. No final reindex or vacuum runs. Require a verified direct PlanetScale primary connection, fresh primary/replica/application telemetry, bounded transactions and cooldowns. Preserve ordinary KBs, canonical document ACLs and live Search configuration. Stop after connection loss instead of reconnecting without the maintenance lock. Require the code-removal release to be fully deployed and older workers drained. Start with single-page runs while watching telemetry; verify ordinary-KB retrieval, ACL denials, connector ingestion and live Search before begin-purge. The CLI help contains the command sequence and health-file contract. Fence the entire schema-push command chain against retirement, refuse pushes once retirement starts, and disable the old bulk-cleanup CLI. Remaining legacy compatibility columns and tables need a separate writer/bootstrap cleanup and schema contraction. Type of Change Improvement Testing 23 real PostgreSQL cases with both schema-push and versioned-migration provisioning, covering concurrent writes, all vector widths, deferred repair, snapshot/lock refusal, late writes, dependency drift, CLI health/connection gates, schema-push contention and process connection loss. JSON reports use INTEGRATION_REPORT_PATH. 61 focused health and schema-push unit tests. The corrected late-write precondition, both schema-push races, endpoint admission and lost-session checkpoint protection were verified failing before their fixes. Database and explicit CLI type-checks, lint, all 54 audits, artifact generation, docs manifest, block registry and migration checks. 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 Follow #8528, now merged into staging. Add operator-run, checkpointed replacement of embedding_search that retains ordinary-KB vectors and retires indexed Search chunks in paced batches. D...

X Description: Summary Follow #8528, now merged into staging. Add operator-run, checkpointed replacement of embedding_search that retains ordinary-KB vectors and retires indexed Search chunks in paced batches. D...

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

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:856e892d-f9b5-f334-a33d-1b651a3fa52d
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-id9E2A:24E4B4:9D7BDF:D7BB2E:6AFB4E18
html-safe-nonce267713364f8d6406b7ae19a0d8a485a211d2986a14a5c47c52d37025229f4c07
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5RTJBOjI0RTRCNDo5RDdCREY6RDdCQjJFOjZBRkI0RTE4IiwidmlzaXRvcl9pZCI6Ijg3MDA2OTE5Nzc3Njg0ODg0NzIiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacaac0bf4dfbbd87811e9fef0764d0c420a74b96198e0ad60b90da27bc5430c18c
hovercard-subject-tagpull_request:4708133298
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/8534/files
twitter:imagehttps://avatars.githubusercontent.com/u/17950982?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/17950982?s=400&v=4
og:image:altSummary Follow #8528, now merged into staging. Add operator-run, checkpointed replacement of embedding_search that retains ordinary-KB vectors and retires indexed Search chunks in paced batches. D...
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/8534/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F8534%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%2F8534%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/8534/files
Reloadhttps://github.com/simstudioai/sim/pull/8534/files
Reloadhttps://github.com/simstudioai/sim/pull/8534/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
icecrasher321https://github.com/icecrasher321
staginghttps://github.com/simstudioai/sim/tree/staging
codex/safe-search-data-retirementhttps://github.com/simstudioai/sim/tree/codex/safe-search-data-retirement
Conversation 49 https://github.com/simstudioai/sim/pull/8534
Commits 4 https://github.com/simstudioai/sim/pull/8534/commits
Checks 32 https://github.com/simstudioai/sim/pull/8534/checks
Files changed https://github.com/simstudioai/sim/pull/8534/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8534/files
chore(search): add paced projection replacement and data retirement https://github.com/simstudioai/sim/pull/8534/files#top
Show all changes 4 commits https://github.com/simstudioai/sim/pull/8534/files
46e9c73 chore(search): add paced projection replacement and data retirement Oct 1, 2026 https://github.com/simstudioai/sim/pull/8534/commits/46e9c7314c49f00579fdb1ecef41839dfaae59d5
ce207dd chore(search): keep retirement usage in the CLI Oct 1, 2026 https://github.com/simstudioai/sim/pull/8534/commits/ce207dd9787e001f56cd0f5d6bf5782212177a6c
6ec913c fix(db): fence schema push and require direct retirement sessions Oct 1, 2026 https://github.com/simstudioai/sim/pull/8534/commits/6ec913c09f19d9becf23d5af55d78de949e65a78
5593bea fix(db): preserve test connection URL parameters Oct 1, 2026 https://github.com/simstudioai/sim/pull/8534/commits/5593bea1e4424c4408b87fa1a2416a90eb732a3a
Clear filters https://github.com/simstudioai/sim/pull/8534/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8534/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8534/files
drizzle.config.ts https://github.com/simstudioai/sim/pull/8534/files#diff-54c8d090c9cda7bb97e4eb20770cf757731ccef5edf568976a2566056f3fac78
index.ts https://github.com/simstudioai/sim/pull/8534/files#diff-369c800ca2861c4e8b60295e216e73115b8b31bd17b6d81578f1fae9577a29e8
search-retirement-health.test.ts https://github.com/simstudioai/sim/pull/8534/files#diff-396d8f326a1f467b74dc45aad8b15d3ba0d2929c1ecd095d68d46a1a0aba3b08
search-retirement-health.ts https://github.com/simstudioai/sim/pull/8534/files#diff-124ea5a56618744743753b63881159783ca9a785ce9b6c1917e2848562de373f
search-retirement.integration.ts https://github.com/simstudioai/sim/pull/8534/files#diff-157708b80684ff8713d933a1cb9f2fc7852062f39ed77123ca919c54e652321b
search-retirement.ts https://github.com/simstudioai/sim/pull/8534/files#diff-c41e7819cab17d60b632707a65e24713b6fcc6d2ce44c4fda49d638441d46bfd
package.json https://github.com/simstudioai/sim/pull/8534/files#diff-c89735ad606b83e822d493ca765a37afb7fcd2e5621f828a2cfc984ed5e67367
0027_retire_search_embeddings.ts https://github.com/simstudioai/sim/pull/8534/files#diff-96715460a502d59053405cf39229bf0663576a2d865174d5cbdf25e3d6d01bdc
index.ts https://github.com/simstudioai/sim/pull/8534/files#diff-4c8058a0b924ce061c5ce010c1308148ea03720952dda10d03cee092b61adbd6
search-embedding-retirement.md https://github.com/simstudioai/sim/pull/8534/files#diff-35b3bda34ec67653fcd46b1b2f93525a0282f6bb7407a7c2533d97ae4a7cc689
push.test.ts https://github.com/simstudioai/sim/pull/8534/files#diff-eabd820bfe82986531b81fdd4a0fc052c7b3b499b568ad5cf47a048b22522e85
push.ts https://github.com/simstudioai/sim/pull/8534/files#diff-1cea81461793525069fcd588c91151e4913e3557208c7c31bb416794e6e76f30
retire-indexed-search.ts https://github.com/simstudioai/sim/pull/8534/files#diff-5e77d9bc8ac9b7a9a52784409d620bcff2e1956b11306d4380d58e4d26ea0c4d
vitest.config.ts https://github.com/simstudioai/sim/pull/8534/files#diff-860b2c4640bb2b3454c31e687dfc8fa095f2413b416615e04794315e77757078
packages/db/drizzle.config.tshttps://github.com/simstudioai/sim/pull/8534/files#diff-54c8d090c9cda7bb97e4eb20770cf757731ccef5edf568976a2566056f3fac78
View file https://github.com/simstudioai/sim/blob/5593bea1e4424c4408b87fa1a2416a90eb732a3a/packages/db/drizzle.config.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8534/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/8534/files#diff-54c8d090c9cda7bb97e4eb20770cf757731ccef5edf568976a2566056f3fac78
packages/db/maintenance/index.tshttps://github.com/simstudioai/sim/pull/8534/files#diff-369c800ca2861c4e8b60295e216e73115b8b31bd17b6d81578f1fae9577a29e8
View file https://github.com/simstudioai/sim/blob/5593bea1e4424c4408b87fa1a2416a90eb732a3a/packages/db/maintenance/index.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8534/{{ revealButtonHref }}
packages/db/maintenance/search-retirement-health.test.tshttps://github.com/simstudioai/sim/pull/8534/files#diff-396d8f326a1f467b74dc45aad8b15d3ba0d2929c1ecd095d68d46a1a0aba3b08
View file https://github.com/simstudioai/sim/blob/5593bea1e4424c4408b87fa1a2416a90eb732a3a/packages/db/maintenance/search-retirement-health.test.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/8534/{{ revealButtonHref }}
Please reload this pagehttps://github.com/simstudioai/sim/pull/8534/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/8534/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.