Skip to content

PrestaShop 1.7 Server Storage Exhaustion #1341

Description

@qplussystems

Prerequisites

Describe the bug and add attachments

  1. Issue SummaryThe VPS disk space reached 100% capacity (0 Bytes free), causing core backend failure, MySQL table lockup, PHP session write failures, and an infinite SSL redirect loop (HTTP 301 -> ERR_TOO_MANY_REDIRECTS) on the PrestaShop back office (/admin-ets).3. Root Cause AnalysisInspection of the MySQL data directory (/var/lib/mysql/prestashop17) revealed massive database table bloat consuming over 44 GiB of storage: ps_layered_filter_block (~40.2 GiB): Cause: A known bug/caching flaw in the Faceted Search (ps_facetedsearch) module. Stale filter indexes are continuously appended rather than overwritten/purged during background indexing or crawler requests.ps_guest & ps_connections (~4.0 GiB): Cause: PrestaShop's native visitor tracking module (statsdata) logs every individual bot, crawler, and user hit directly to the database without automatic lifecycle rotation or purging.Nginx Admin Redirect Misconfiguration:Nginx was attempting to process /admin-ets without a trailing slash over listen 80; (HTTP), sending an internal 301 location header (http://kamyoun.tn/admin-ets/) back to Cloudflare, which then redirected back to HTTPS.4. Steps Taken to Resolve : deleted some packages to claim few MB of disk space then goes to ps_facetedsearch module and cleared the module cache !
Image

Steps to reproduce

just install the V 4.1 and a 42gb ll produce soon

Expected behavior

No response

Actual Result

No response

PrestaShop version where the bug happens

1.7

Module version where the bug happens

4.1

PHP version(s) where the bug happened

No response

Your company or customer's name goes here (if applicable).

No response

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions