Page MenuHomeMiraheze

Migrate revision_actor_temp usage back to the revision table
Closed, ResolvedPublic

Description

The steps will be as follows:

  • Set $wgActorTableSchemaMigrationStage to SCHEMA_COMPAT_WRITE_TEMP_AND_NEW | SCHEMA_COMPAT_READ_TEMP
    • On beta
    • On production
  • Run maintenance/migrateRevisionActorTemp.php
    • On all beta wikis
    • On all production wikis
    • On all wikis currently marked as deleted (to ensure it being ran if they are undeleted)
  • Set $wgActorTableSchemaMigrationStage to SCHEMA_COMPAT_WRITE_TEMP_AND_NEW | SCHEMA_COMPAT_READ_NEW to allow for rollback if issues come (leave for at least a couple days)
    • On beta
    • On production
  • Set $wgActorTableSchemaMigrationStage to SCHEMA_COMPAT_NEW
    • On beta
    • On production
  • Drop the revision_actor_temp table
    • On all beta wikis
    • On all production wikis
    • On all wikis currently marked as deleted (to ensure it being dropped even if they are undeleted; no point in keeping it around)

Test extensions and skins referencing revision_actor_temp:

  • ApprovedRevs
  • BlogPage
  • DPLforum
  • DynamicPageList3 (T9538)
  • FlaggedRevs
  • Flow
  • MyVariables
  • Nimbus
  • SimpleBlogPage
  • SocialProfile

Make MirahezeMagic maintenance scripts support it:

Related Objects

StatusAssignedTask
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedRhinosF1
DeclinedUnknown Object (User)
ResolvedRhinosF1
ResolvedRhinosF1
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
DeclinedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)
ResolvedUnknown Object (User)

Event Timeline

Unknown Object (User) triaged this task as Low priority.Mar 23 2022, 19:53
Unknown Object (User) created this task.
Unknown Object (User) changed the task status from Open to Stalled.Mar 23 2022, 19:54
Unknown Object (User) added a subtask: T8743: Upgrade to MediaWiki 1.38.1.
Unknown Object (User) moved this task from Backlog to Long Term on the MediaWiki (SRE) board.May 9 2022, 19:14
Unknown Object (User) added a project: Database.
Unknown Object (User) moved this task from Backlog to Maintenance Script Run on the MediaWiki board.
Unknown Object (User) changed the task status from Stalled to Open.Jun 16 2022, 00:25
Unknown Object (User) closed subtask T8743: Upgrade to MediaWiki 1.38.1 as Resolved.
Unknown Object (User) updated the task description. (Show Details)Jun 23 2022, 20:51
Unknown Object (User) added a parent task: T9446: Upgrade to MediaWiki 1.39.1.
Unknown Object (User) added a comment.Jun 25 2022, 07:18

It is now done on beta. After testing and ensuring everything works, we can begin work for production migration.

Unknown Object (User) claimed this task.Jun 25 2022, 07:18
Unknown Object (User) updated the task description. (Show Details)Jun 25 2022, 07:34
Unknown Object (User) updated the task description. (Show Details)Jun 25 2022, 17:45
Unknown Object (User) added a comment.Jun 26 2022, 22:52

I forgot to update here, but I started running the script for production actor migration about 26 hours ago. It will likely take quite a long time before it is finished.

Unknown Object (User) added a comment.Jul 1 2022, 02:11

Just to update this a little bit and to note, at the current rate the script is going, I am not even sure it will be done in time for the 1.39 upgrade, and we should prepare to postpone that if needed. I started it as early as possible (right after 1.38), to hopefully get it done long-before the upgrade, but the script is so slow, and with the other issues on your servers combined with this makes mwtask111 severely slow down sometimes. Today has been especially slow, and if it continued at todays pace the whole time, it would take over a year to complete. We either have to figure out another way to do it, or hope it speeds up, completes before the stable release of 1.39, and postpone the upgrade if it does not.

Unknown Object (User) added a comment.Jul 2 2022, 16:01

Can we please take a list of all renamed wikis in this task as well @Reception123. Any renamed wiki, or now-undeleted wiki will need to be ran separately due to the fact they wouldn't be in the current database list.

The script will also be ran on deleted.json database list after the current finishes as well. We've never done that before either, but we've never had such a long running script. And the current deleted.json does not support foreachwikiindblist, it will have to be modified to make it a combi list before it can be ran also.

thehorriblemusicandsongswikia was renamed to horriblemusicwiki

thebestmusicandsongswikiawiki was renamed to excellentmusicwiki

Unknown Object (User) updated the task description. (Show Details)Jul 29 2022, 18:10
Unknown Object (User) updated the task description. (Show Details)Jul 29 2022, 18:12
Unknown Object (User) moved this task from Maintenance Script Run to Upgrade Blockers on the MediaWiki board.
Unknown Object (User) updated the task description. (Show Details)
Unknown Object (User) closed subtask T9532: Database Error (Rothwell Wiki) as Resolved.
Unknown Object (User) updated the task description. (Show Details)Jul 29 2022, 19:41
Unknown Object (User) updated the task description. (Show Details)
Unknown Object (User) updated the task description. (Show Details)Jul 29 2022, 22:17
Unknown Object (User) updated the task description. (Show Details)
Unknown Object (User) added a comment.Jul 30 2022, 17:50
This comment was removed by Unknown Object (User).
Unknown Object (User) updated the task description. (Show Details)Aug 5 2022, 09:16
Unknown Object (User) updated the task description. (Show Details)
Unknown Object (User) updated the task description. (Show Details)Sep 11 2022, 18:43
Unknown Object (User) moved this task from Unsorted to Goals on the Universal Omega board.Sep 11 2022, 18:43
Unknown Object (User) closed this task as Resolved.Sep 19 2022, 07:17