Skip to content

perf: trust the presence table's version option and recheck it only after a failed write - #682

Merged
josephfusco merged 5 commits into
mainfrom
perf/presence-table-check
Sep 30, 2026
Merged

josephfusco merged 5 commits into
mainfrom
perf/presence-table-check

Conversation

@josephfusco

@josephfusco josephfusco commented Sep 30, 2026 •

Copy link
Copy Markdown
Collaborator

A dropped table is now caught by the first write that fails, not by a check on every admin page, which keeps #235's recovery free per request and makes gutenberg-sync-engines fall back to its own store right away.

Related: #344

Use of AI Tools

AI assistance: Yes
Tool(s): Claude Code
Model(s): Claude Opus 5.5
Used for: Assisting with the table check and its recovery path.

@github-actions

github-actions Bot commented Sep 30, 2026 •

Copy link
Copy Markdown
Contributor

🛝 WordPress Playgrounds

Built from 260013b

25 users 100 users
Single site Launch single site, 25 users Launch single site, 100 users
Multisite Launch multisite, 25 users Launch multisite, 100 users

@josephfusco
josephfusco marked this pull request as ready for review September 30, 2026 12:44
@github-actions

Copy link
Copy Markdown
Contributor

The following accounts have interacted with this PR and/or linked issues. I will continue to update these lists as activity occurs. You can also manually ask me to refresh this list by adding the props-bot label.

Core Committers: Use this line as a base for the props when committing in SVN:

Props joefusco.

To understand the WordPress project's expectations around crediting contributors, please review the Contributor Attribution page in the Core Handbook.

@codecov

codecov Bot commented Sep 30, 2026 •

Copy link
Copy Markdown

Codecov Report

❌ Patch coverage is 83.33333% with 1 line in your changes missing coverage. Please review.
✅ Project coverage is 94.49%. Comparing base (1202961) to head (260013b).

Additional details and impacted files
@@             Coverage Diff              @@
##               main     #682      +/-   ##
============================================
- Coverage     94.51%   94.49%   -0.02%     
  Complexity      270      270              
============================================
  Files            28       28              
  Lines          3972     3976       +4     
============================================
+ Hits           3754     3757       +3     
- Misses          218      219       +1     
Flag Coverage Δ
multisite 94.49% <83.33%> (-0.02%) ⬇️
phpunit 73.84% <83.33%> (+<0.01%) ⬆️

Flags with carried forward coverage won't be shown. Click here to find out more.

🚀 New features to boost your workflow:
  • ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
  • 📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

@josephfusco josephfusco added [Area] Database Issues for the wp_presence table and cron cleanup Performance Work relates to query load, cache behavior, or scaling labels Sep 30, 2026
@josephfusco josephfusco changed the title perf: trust the presence table's version option and recheck the table on activation perf: trust the presence table's version option and recheck it only after a failed write Sep 30, 2026
github-actions Bot added a commit that referenced this pull request Sep 30, 2026
github-actions Bot added a commit that referenced this pull request Sep 30, 2026
github-actions Bot added a commit that referenced this pull request Sep 30, 2026
@josephfusco
josephfusco merged commit b08836c into main Sep 30, 2026
22 checks passed
@josephfusco
josephfusco deleted the perf/presence-table-check branch September 30, 2026 16:18
@josephfusco josephfusco added this to the 0.12.2 milestone Sep 30, 2026
i-am-chitti pushed a commit that referenced this pull request Sep 30, 2026
…fter a failed write (#682)

* perf: trust the presence table's version option and recheck the table on activation

* docs: leave the recovery story to wp_presence_provision_site()

* fix: forget the table version when a write finds the table gone

* test: simulate a missing presence table without a DROP that SQLite rolls back
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

[Area] Database Issues for the wp_presence table and cron cleanup Performance Work relates to query load, cache behavior, or scaling

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant