Change Details

Due to expected difficulty in altering the `revision` table (see {T161671}), the actor and comment migrations created tables named `revision_comment_temp` and `revision_actor_temp` to relate the `rev_id` and the `comment_id`/`actor_id`, with the plan being to eventually alter `revision` to contain `rev_comment_id` and `rev_actor` columns and drop those relation tables. This task tracks that "eventually". [X] 0. Wait for the main actor and comment migration to be done (except for DBA work). [x] 0.1. Comment migration, through steps 7.1 and 7.2 (T166733) [X] 0.2. Actor migration, through steps 7.1 and 7.2 (T188327) [ ] 1. Alter `revision` to drop `rev_comment`, `rev_user`, and `rev_user_text` and add `rev_comment_id` and `rev_actor`. (T161671) [x] 1.1. Write and merge the MediaWiki patch. [x] 1.2. Have DBAs perform the change. [ ] 2. Introduce a migration from using `revision_comment_temp` and `revision_actor_temp` (old) to `rev_comment_id` and `rev_actor` (new). [ ] 2.1. Write and merge the MediaWiki patch, assuming it wasn't included in 1.1. [ ] 2.2. Check for extensions assuming the temp tables exist. [ ] 3. Set migration stage to write-both/read-old. [ ] 4. Run the maintenance script to backfill `rev_comment_id` and `rev_actor`. [ ] 5. Set migration stage to write-both/read-new. [ ] 5.1. Announce changes to wikitech-l and cloud. [ ] 5.2. Update WMCS views to read the new schema. [ ] 6. Set migration stage to write-new/read-new. [ ] 7. Remove old tables and code.

Due to expected difficulty in altering the `revision` table (see {T161671}), the actor and comment migrations created tables named `revision_comment_temp` and `revision_actor_temp` to relate the `rev_id` and the `comment_id`/`actor_id`, with the plan being to eventually alter `revision` to contain `rev_comment_id` and `rev_actor` columns and drop those relation tables. This task tracks that "eventually". [X] 0. Wait for the main actor and comment migration to be done (except for DBA work). [x] 0.1. Comment migration, through steps 7.1 and 7.2 (T166733) [X] 0.2. Actor migration, through steps 7.1 and 7.2 (T188327) [x] 1. Alter `revision` to drop `rev_comment`, `rev_user`, and `rev_user_text` and add `rev_comment_id` and `rev_actor`. (T161671) [x] 1.1. Write and merge the MediaWiki patch. [x] 1.2. Have DBAs perform the change. [ ] 2. Introduce a migration from using `revision_comment_temp` and `revision_actor_temp` (old) to `rev_comment_id` and `rev_actor` (new). [ ] 2.1. Write and merge the MediaWiki patch, assuming it wasn't included in 1.1. [ ] 2.2. Check for extensions assuming the temp tables exist. [ ] 3. Set migration stage to write-both/read-old. [ ] 4. Run the maintenance script to backfill `rev_comment_id` and `rev_actor`. [ ] 5. Set migration stage to write-both/read-new. [ ] 5.1. Announce changes to wikitech-l and cloud. [ ] 5.2. Update WMCS views to read the new schema. [ ] 6. Set migration stage to write-new/read-new. [ ] 7. Remove old tables and code.

Due to expected difficulty in altering the `revision` table (see {T161671}), the actor and comment migrations created tables named `revision_comment_temp` and `revision_actor_temp` to relate the `rev_id` and the `comment_id`/`actor_id`, with the plan being to eventually alter `revision` to contain `rev_comment_id` and `rev_actor` columns and drop those relation tables. This task tracks that "eventually". [X] 0. Wait for the main actor and comment migration to be done (except for DBA work). [x] 0.1. Comment migration, through steps 7.1 and 7.2 (T166733) [X] 0.2. Actor migration, through steps 7.1 and 7.2 (T188327) [ ] 1x] 1. Alter `revision` to drop `rev_comment`, `rev_user`, and `rev_user_text` and add `rev_comment_id` and `rev_actor`. (T161671) [x] 1.1. Write and merge the MediaWiki patch. [x] 1.2. Have DBAs perform the change. [ ] 2. Introduce a migration from using `revision_comment_temp` and `revision_actor_temp` (old) to `rev_comment_id` and `rev_actor` (new). [ ] 2.1. Write and merge the MediaWiki patch, assuming it wasn't included in 1.1. [ ] 2.2. Check for extensions assuming the temp tables exist. [ ] 3. Set migration stage to write-both/read-old. [ ] 4. Run the maintenance script to backfill `rev_comment_id` and `rev_actor`. [ ] 5. Set migration stage to write-both/read-new. [ ] 5.1. Announce changes to wikitech-l and cloud. [ ] 5.2. Update WMCS views to read the new schema. [ ] 6. Set migration stage to write-new/read-new. [ ] 7. Remove old tables and code.