Topic on Project:Support desk

When upgrading from 1.32.1 to 1.33.0 the upgrade.php scripts failes on the actor migration step:

[b59a22daeb86391045110594] [no req]   Wikimedia\Rdbms\DBQueryError from line 1587 of /var/www/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT  rev_id,rev_user,rev_user_text,CASE WHEN rev_user = 0 OR rev_user IS NULL THEN (SELECT  actor_id  FROM `wiki_actor`    WHERE (rev_user_text = actor_name)  ) ELSE (SELECT  actor_id  FROM `wiki_actor`    WHERE (rev_user = actor_user)  ) END AS `actor_id`,rev_timestamp AS `revactor_timestamp`,rev_page AS `revactor_page`  FROM `wiki_revision` LEFT JOIN `wiki_revision_actor_temp` ON ((rev_id=revactor_rev))   WHERE revactor_rev IS NULL  ORDER BY rev_id LIMIT 100

Function: MigrateActors::migrateToTemp

Error: 1146 Table 'wiki.wiki_revision_actor_temp' doesn't exist (localhost)

I can only pass the upgrade now when setting wgActorTableSchemaMigrationStage to the setting SCHEMA_COMPAT_OLD. This basically skips the migration but is there a way to let the migration happen without having this error?

Note: Before the wgActorTableSchemaMigrationStage was not set, so it was respecting default values.

This sounds like a similar situation to what's described at phab:T227662. The comment at phab:T227662#5325853 probably applies here as well.

I found the script in 1.32 and after partially executing it the upgrade completed. Thanks for the tip.