Jump to content

Manual:$wgCommentTempTableSchemaMigrationStage

From mediawiki.org
Database settings: $wgCommentTempTableSchemaMigrationStage
Comment temp tables schema migration stage.
Introduced in version:1.40.0 (Gerrit change 872985; git #cf127211)
Removed in version:1.41.0 (Gerrit change 924123; git #27beeac2)
Allowed values:(array)
Default value:[]

Details

Comment temp tables schema migration stage. Use the SCHEMA_COMPAT_XXX flags.

The default value is an empty array, which is equivalent to:

[
    'rev_comment' => MIGRATION_OLD,
]

To perform the migration, set this configuration variable to write to both tables but read from old temp table:

[
    'rev_comment' => SCHEMA_COMPAT_WRITE_BOTH | SCHEMA_COMPAT_READ_OLD,
]

Then, run Manual:migrateRevisionCommentTemp.php to backfill the new table.

Once the script has completed, for testing, this configuration can be changed to still write to both tables but read only from new table (done in Gerrit change 923749). This allows easy rollback to read from the old table in case bugs or incompatibilities are found:

[
    'rev_comment' => SCHEMA_COMPAT_WRITE_BOTH | SCHEMA_COMPAT_READ_NEW,
]