Migration Seems to Stop or Time Out

  • Megan

    (@megabyterose)


    8 years, 7 months ago

    I purchased/followed the installation guide and tested SharDB on localhost with 229 sites/16 databases (+ home & global). I had to increase my max_execution_time, but it all worked fine.

    Now I have been trying to set up SharDB on my production site (4,000+ sites) with 256 databases (+ home & global), but it seems like it times out or just stops partway through migrating the global tables. It copied 6 tables successfully, but stops there and doesn’t show the success message and stops loading. (The only difference between my localhost install and the live one is the amount of sites. & I don’t have any errors in my debug log.)

    Is there something else I should increase/look at in php.ini or wp-config.php?

    https://www.ads-software.com/plugins/shardb/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Ron Rennick

    (@wpmuguru)

    Have you tried running the migration with all plugins deactivated?

    You could have a script error interfering with the migration.

    Thread Starter Megan

    (@megabyterose)

    Well I have all the same plugins (& same versions) installed/activated on localhost, so the only difference is that the production multisite has more sites. I tried pushing my localhost install further by creating more sites (up to 676 sites now), but can’t seem to reproduce what’s happening on the live site. Any other suggestions? (I’m trying to avoid deactivating plugins on my production site.)

    Plugin Author Ron Rennick

    (@wpmuguru)

    While you are running the migration on a large install you should be in more or less in maintenance mode (users locked out, etc.)

    If you have a large busy install you are bound to run into table locks, etc. which will cause it to stop.

    Thread Starter Megan

    (@megabyterose)

    Thanks for the response! It seems like a logical explanation… I’ll have to try locking them out & see how it goes then.

    Thread Starter Megan

    (@megabyterose)

    Locked users out, changed auth salts, tried to migrate global tables. Same problem.

    There are 8 tables in the global db, but only one row even gets copied (XX_aiowps_failed_logins has 1 row). When I try to migrate sites, it just shows (1) https://home-blog.com/ and stops loading.

    I turned off more plugins (that wouldn’t alter the look of the front end), too. – Though I still don’t think it’s a plugin issue since localhost had the same versions.

    Thread Starter Megan

    (@megabyterose)

    Interestingly, I just exported/imported the vanilla WPMU global tables (wp_blogs, wp_users, etc.) and the global table migration got to 28 tables copied this time (still not all the way to the button/confirmation).

    Maybe the site has some residual tables from old plugins that didn’t remove their tables on deactivation…? Which would mean it’s just the massive quantity that is killing it?

    Plugin Author Ron Rennick

    (@wpmuguru)

    Are any of the tables really large?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Migration Seems to Stop or Time Out’ is closed to new replies.