Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Search / My Jetpack: Function get_raw_post_type_breakdown can render back end inaccessible #38130

Open
stevedaily opened this issue Jun 30, 2024 · 2 comments
Open

Search / My Jetpack: Function get_raw_post_type_breakdown can render back end inaccessible #38130

stevedaily opened this issue Jun 30, 2024 · 2 comments
Labels
[Feature] Search For all things related to Search [Focus] Performance [Package] My Jetpack [Plugin] Backup A plugin that allows users to save every change and get back online quickly with one-click restores. [Pri] High [Status] Priority Review Triggered The guild in charge of triage has been notified of this issue in Slack Triaged [Type] Bug When a feature is broken and / or not performing as intended

Comments

@stevedaily
Copy link

Impacted plugin

Backup

Quick summary

I have a very large site with millions of records in the _posts table. The admin area (admin.php) is now inaccessible due to this query: "SELECT post_type, post_status, COUNT( * ) AS num_posts FROM ***_posts WHERE post_password = '' GROUP BY post_type, post_status"

I traced this back to plugins\jetpack-backup\jetpack_vendor\automattic\jetpack-my-jetpack\src\products\class-search-stats.php,
Line 140
The function get_raw_post_type_breakdown() is the culprit.

Steps to reproduce

  1. Start with a site having a very large number of posts in the posts table
  2. Visit admin.php
  3. Notice the time taken to process the query, "SELECT post_type, post_status, COUNT( * ) AS num_posts FROM ***_posts WHERE post_password = '' GROUP BY post_type, post_status"

A clear and concise description of what you expected to happen.

Back end should load without much delay.

What actually happened

The back end timed out.

Impact

All

Available workarounds?

No but the platform is still usable

Platform (Simple and/or Atomic)

Self-hosted

Logs or notes

Jetpack Backup 2.6
@stevedaily stevedaily added [Type] Bug When a feature is broken and / or not performing as intended Needs triage Ticket needs to be triaged labels Jun 30, 2024
@github-actions github-actions bot added [Status] Priority Review Triggered The guild in charge of triage has been notified of this issue in Slack [Plugin] Backup A plugin that allows users to save every change and get back online quickly with one-click restores. [Pri] High labels Jun 30, 2024
@jeherve jeherve added [Focus] Performance [Package] My Jetpack Triaged [Feature] Search For all things related to Search and removed Needs triage Ticket needs to be triaged labels Jul 1, 2024
@jeherve
Copy link
Member

jeherve commented Jul 1, 2024

cc @kangzj who initially worked on it in #26463.
@jeherve jeherve changed the title Function get_raw_post_type_breakdown can render back end inaccessible Jul 1, 2024
@lsl
Copy link
Contributor

lsl commented Aug 8, 2024

Bump, would be nice to fix this.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
[Feature] Search For all things related to Search [Focus] Performance [Package] My Jetpack [Plugin] Backup A plugin that allows users to save every change and get back online quickly with one-click restores. [Pri] High [Status] Priority Review Triggered The guild in charge of triage has been notified of this issue in Slack Triaged [Type] Bug When a feature is broken and / or not performing as intended
3 participants
@jeherve @lsl @stevedaily