admin backend terribly slow after upgrade to 3.9.1 (missing db migrations?)

  • Resolved leitmedium

    (@leitmedium)


    9 years, 11 months ago

    Hello,

    I run a multisite setup and recently updated from 3.8.x to recent 3.9.1. All wordpress blogs can be surfed without delays or errors after the upgrade, but the admin backend is terribly slow. I assume there is an issue with a failed or incomplete database migration. WordPress itself states on

    wp-admin/network/upgrade.php (calling this site takes minutes to load)

    that it wants to upgrade the database tables for the sites. Calling

    wp-admin/network/upgrade.php?action=upgrade

    takes minutes to load and just results in a blank page. I did not find any error messages in Apache’s log files (log_errors is On, and error_reporting is “E_ALL & ~E_DEPRECATED”). A “show full processlist” shows no long running MySQL queries (actually no at all).

    I checked the “db_version” option in all (sub)blogs and it shows the outdated version 26691 instead of 27916.

    I reinstalled the update to 3.9.1 via admin interface, which runs just fine, but still, the admin backend is slow, db_version is outdated and I cannot get a successfull rin of “upgrade.php?action=upgrade”.

    How can I proceed from here? I guess the best way’d be, upgrading table structures manually via sql scripts or similar, but I did not find information about this so far. Other hints welcome.

    Best.

Viewing 1 replies (of 1 total)
  • Thread Starter leitmedium

    (@leitmedium)

    9 years, 11 months ago

    Hey,

    I fixed the issue, by installing “wp-cli” and running:

    wp core update-db

    as well as

    wp core update-db --url=domain.of.subblog

    for every subblog. Now all blogs have the correct db_version and the backup is snappy again.

Viewing 1 replies (of 1 total)
  • The topic ‘admin backend terribly slow after upgrade to 3.9.1 (missing db migrations?)’ is closed to new replies.