Problem/Motivation

In our company, we have a site with a huge amount of nodes that are using sitestudio components.
Once we import and rebuild the components, purge module is triggered and tries to massive insert data into purge_queue table.

Steps to reproduce

Rebuild a massive amount of nodes with sitestudio (in my case, by a sitestudio:package:import command). Purge module will try to insert lots of data into a single INSERT statement.

Proposed resolution

Refactor createItemMultiple() method and split it to avoid a huge amount of data to be inserted.
Check for the attached patch file

Remaining tasks

User interface changes

API changes

Data model changes

CommentFileSizeAuthor
#2 purge_insert_hotfix.patch2.17 KBdaniel_arend

Issue fork purge-3437679

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

    About issue forks

    Comments

    daniel_arend created an issue. See original summary.

    daniel_arend’s picture

    daniel_arend commented
    Issue summary: View changes
    StatusFileSize
    new purge_insert_hotfix.patch2.17 KB
    daniel_arend’s picture

    daniel_arend commented

    I can't understand why the test fails on d10. BTW, I'm using this patch in d10 version and PHP 8.2 and it works fine. It does not seem to be related to the patch itself, but some hash assertion with drupal libraries. Any help here would be much appreciated.

    o'briat’s picture

    o'briat
    Primary language French
    Location Nantes
    commented

    I got the same problem with daily massive update from external source. May be the Deduplicate Queued Items issue could help ?