Creating staging never finishes

  • Resolved swinggraphics

    (@swinggraphics)


    9 months, 3 weeks ago

    I have used the plugin a few times successfully, but it can be incredibly slow, going one-by-one through postmeta. It gets to “50%” and then stops progressing. Looking at the log after 5 minutes, shows this:

    [INFO] – [2024/02/02 11:32:00] – DB Search & Replace: Table wpstg0_postmeta 180 to 20180 records

    In practical terms, it will “never” finish if it takes several seconds per record. ?? I could not use the plugin in this case.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Rene Hermenau

    (@renehermi)

    This likely happens because you have several rows in the post-meta table with huge amounts of data, probably dozens of megabytes, maybe even a hundred megabytes per row.

    WP Staging is so smart that it considers the maximum allowed memory consumption and reduces the rows until it can continue the copying process.

    Once it has copied these huge rows it will speed up again and copy the rest with full speed. You just have to be patient until it passes these rows.

    I also recommend that you look into the first rows of the post meta table to see what data it is that big. Usually, such big rows are an indicator of having a problematic plugin.

    Please let me know how it goes.



    Thread Starter swinggraphics

    (@swinggraphics)

    In this case, I used WP Sweep to remove Revisions, optimize tables, and then I was able to create a staging site. ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Creating staging never finishes’ is closed to new replies.