Stuck in Database Migration

  • Resolved tonyrhnewtons

    (@tonyrhnewtons)


    1 year, 2 months ago

    I have 4 websites I manage, and the most recent update asked for a database migration.

    It’s been stuck in that migration on all 4 sites for hours now.
    I have the “WP Statistics: Process Running
    Database Migration is running in the background (28,912 records remaining).” and nothing appears to be happening.

    any idea what the issue is?

Viewing 15 replies - 1 through 15 (of 20 total)
1 2
  • Thread Starter tonyrhnewtons

    (@tonyrhnewtons)

    1 year, 2 months ago

    I realize that one has a lot of records, but other sites have far less.
    “WP Statistics: Process Running
    Database Migration is running in the background (522 records remaining“

    Matthew

    (@mhdizmni)

    1 year, 2 months ago

    Hi @tonyrhnewtons,

    Apologies for the delayed response.

    Could you please confirm whether the migration process has been completed for your site?

    Please note that the migration time may vary depending on the number of records that need to be processed.

    — Matthew

    Thread Starter tonyrhnewtons

    (@tonyrhnewtons)

    1 year, 2 months ago

    Still not completed on all 4 sites

    Thread Starter tonyrhnewtons

    (@tonyrhnewtons)

    1 year, 2 months ago

    still running on all 4 sites

    WP Statistics: Process Running
    Database Migration is running in the background (616 records remaining). You can continue working or dismiss this notice.

    Thread Starter tonyrhnewtons

    (@tonyrhnewtons)

    1 year, 2 months ago

    updated the plugin

    running the migration again

    Thread Starter tonyrhnewtons

    (@tonyrhnewtons)

    1 year, 2 months ago

    ran the update yesterday, and ran the database migration again on all 4 sites

    they are all still stuck in migration after having run overnight

    Matthew

    (@mhdizmni)

    1 year, 2 months ago

    Dear @tonyrhnewtons,

    We have been investigating the matter and have identified an issue related to the migration of large datasets.

    Our team is actively working on a solution, and we will keep you updated as soon as a fix is in place.

    Thank you for your patience and understanding!

    — Matthew

    Thread Starter tonyrhnewtons

    (@tonyrhnewtons)

    1 year, 1 month ago

    Hi Matthew

    Still stuck in Database Migration on all 4 sites

    Ran the WooCommerce update, and that had a database update, and it completed.

    Between the 4 sites, the lowest has 522 records, the highest has 28,912 records.

    Matthew

    (@mhdizmni)

    1 year, 1 month ago

    Dear @tonyrhnewtons,

    We are sorry for any inconvenience caused by this issue.

    Rest assured, we are working on a solution and are aiming to have it resolved as soon as possible.

    I will get back to you as soon as we have an update.

    — Matthew

    Thread Starter tonyrhnewtons

    (@tonyrhnewtons)

    1 year, 1 month ago

    I do not have WP-CLI through my hosting provider

    Can I use WP-Console plugin to run the command?
    https://ww.wp.xz.cn/plugins/wp-console/

    Matthew

    (@mhdizmni)

    1 year, 1 month ago

    Hey @tonyrhnewtons,

    It looks like the WP Console plugin isn’t able to run any WP-CLI commands.

    Given that, I’d recommend using the WP Crontrol plugin to manually run the cron jobs instead.

    Below is a list of our migration-related cron job hook names. You can search for them in WP Crontrol and run them.

    • wp_statistics_schema_migration_process
    • wp_statistics_data_migration_process

    Let me know how it goes.

    — Matthew

    Thread Starter tonyrhnewtons

    (@tonyrhnewtons)

    1 year, 1 month ago

    that cleared the migration message

    Thread Starter tonyrhnewtons

    (@tonyrhnewtons)

    1 year, 1 month ago

    Just a heads up, as this may help you solve this, the cron event listed that it was due to run

    January 1, 1970 12:00 am
    55 years 4 months ago

    hopefully that bit of info helps

    Thread Starter tonyrhnewtons

    (@tonyrhnewtons)

    1 year, 1 month ago

    it did not clear the message on the second site

    Matthew

    (@mhdizmni)

    1 year, 1 month ago

    Dear @tonyrhnewtons,

    We’ve just released version 14.13.2, which includes a new migrator feature.

    Kindly update the plugin at your earliest convenience and run the migration. You’ll see a migration notice appear once the plugin has been updated (if the migration process has not been already completed).

    Looking forward to your feedback.

    — Matthew

Viewing 15 replies - 1 through 15 (of 20 total)
1 2

The topic ‘Stuck in Database Migration’ is closed to new replies.