3.0.0 errors after a time on bulk regenerate

  • Resolved lozula

    (@lozula)


    6 years, 4 months ago

    When doing a bulk regenerate of images, and having it set to “Skip regenerating existing correctly sized thumbnails (faster).”

    It runs for around 200 images, and then stops with the following in the error log. Any advice?

    [16-Dec-2017 12:24:22 UTC] PHP Warning: mysqli_query(): MySQL server has gone away in /home2/dev/public_html/ftu/wp-includes/wp-db.php on line 1931
    [16-Dec-2017 12:24:22 UTC] PHP Warning: mysqli_query(): Error reading result set’s header in /home2/dev/public_html/ftu/wp-includes/wp-db.php on line 1931
    [16-Dec-2017 12:24:22 UTC] PHP Warning: mysqli_query(): MySQL server has gone away in /home2/dev/public_html/ftu/wp-includes/wp-db.php on line 1931
    [16-Dec-2017 12:24:22 UTC] PHP Warning: mysqli_query(): Error reading result set’s header in /home2/dev/public_html/ftu/wp-includes/wp-db.php on line 1931
    [16-Dec-2017 12:24:22 UTC] PHP Warning: mysqli_query(): MySQL server has gone away in /home2/dev/public_html/ftu/wp-includes/wp-db.php on line 1931
    [16-Dec-2017 12:24:22 UTC] PHP Warning: mysqli_query(): Error reading result set’s header in /home2/dev/public_html/ftu/wp-includes/wp-db.php on line 1931
    [16-Dec-2017 12:24:22 UTC] PHP Warning: mysqli_query(): MySQL server has gone away in /home2/dev/public_html/ftu/wp-includes/wp-db.php on line 1931
    [16-Dec-2017 12:24:22 UTC] PHP Warning: mysqli_query(): Error reading result set’s header in /home2/dev/public_html/ftu/wp-includes/wp-db.php on line 1931
    [16-Dec-2017 12:24:23 UTC] PHP Warning: Error while sending QUERY packet. PID=24324 in /home2/dev/public_html/ftu/wp-includes/wp-db.php on line 1931

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter lozula

    (@lozula)

    6 years, 4 months ago

    Update – if I regenerate from the media library and bulk select 300 at a time, it seems to be both a lot faster in processing, and doesn’t error. Not sure why.

    Plugin Contributor Alex Mills

    (@viper007bond)

    6 years, 4 months ago

    Hmm, it seems your MySQL server doesn’t seem happy.

    Does it work better if you uncheck “Update the content of posts to use the new sizes.” ?

    • This reply was modified 6 years, 4 months ago by Alex Mills.
    Thread Starter lozula

    (@lozula)

    6 years, 4 months ago

    This was with that option unchecked. I worked around it by just doing them 300 at a time in the media library, which took a bit more time, but was way faster in terms of per thumbnail generation.

    Plugin Contributor Alex Mills

    (@viper007bond)

    6 years, 4 months ago

    Weird. Well glad you got it sorted. 🙂

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘3.0.0 errors after a time on bulk regenerate’ is closed to new replies.