Skip to content

Instantly share code, notes, and snippets.

@kghbln
Last active February 8, 2024 16:58
Show Gist options
  • Save kghbln/6faaf4fd0399be073a192986dd9462bf to your computer and use it in GitHub Desktop.
Save kghbln/6faaf4fd0399be073a192986dd9462bf to your computer and use it in GitHub Desktop.
Update from 1.34 to 1.35 to 1.39
root@server:/../w#php maintenance/update.php --quick
MediaWiki 1.35.13 Updater
Your composer.lock file is up to date with current dependencies!
Going to run database updates for wikidb
Depending on the size of your database this may take a while!
...have ipb_id field in ipblocks table.
...have ipb_expiry field in ipblocks table.
...already have interwiki table
...indexes seem up to 20031107 standards.
...have rc_type field in recentchanges table.
...index new_name_timestamp already set on recentchanges table.
...have user_real_name field in user table.
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
...have pagelinks; skipping old links table updates
...il_from OK
...have rc_ip field in recentchanges table.
...index PRIMARY already set on image table.
...have rc_id field in recentchanges table.
...have rc_patrolled field in recentchanges table.
...logging table already exists.
...have user_token field in user table.
...have wl_notificationtimestamp field in watchlist table.
...watchlist talk page rows already present.
...user table does not contain user_emailauthenticationtimestamp field.
...page table already exists.
...have log_params field in logging table.
...logging table has correct log_title encoding.
...have ar_rev_id field in archive table.
...have page_len field in page table.
...revision table does not contain inverse_timestamp field.
...have rev_deleted field in revision table.
...have img_width field in image table.
...have img_metadata field in image table.
...have user_email_token field in user table.
...page_namespace is already a full int (int(11)).
...ar_namespace is already a full int (int(11)).
...rc_namespace is already a full int (int(11)).
...wl_namespace is already a full int (int(11)).
...qc_namespace is already a full int (int(11)).
...log_namespace is already a full int (int(11)).
...have img_media_type field in image table.
...already have pagelinks table.
...image table does not contain img_type field.
...already have unique user_name index.
...user_groups table exists and is in current format.
...have ss_total_pages field in site_stats table.
...user_newtalk table already exists.
...have iw_trans field in interwiki table.
...wl_notificationtimestamp is already nullable.
...index times already set on logging table.
...have ipb_range_start field in ipblocks table.
...no page_random rows needed to be set
...have user_registration field in user table.
...templatelinks table already exists
...externallinks table already exists.
...job table already exists.
...have ss_images field in site_stats table.
...langlinks table already exists.
...querycache_info table already exists.
...filearchive table already exists.
...have ipb_anon_only field in ipblocks table.
...have user_newpass_time field in user table.
...redirect table already exists.
...querycachetwo table already exists.
...have ipb_enable_autoblock field in ipblocks table.
...index pl_namespace on table pagelinks includes field pl_from.
...index tl_namespace on table templatelinks includes field tl_from.
...index il_to on table imagelinks includes field il_from.
...have rc_old_len field in recentchanges table.
...have user_editcount field in user table.
...page_restrictions table already exists.
...have log_id field in logging table.
...have rev_parent_id field in revision table.
...have pr_id field in page_restrictions table.
...have rev_len field in revision table.
...have rc_deleted field in recentchanges table.
...have log_deleted field in logging table.
...have ar_deleted field in archive table.
...have ipb_deleted field in ipblocks table.
...have fa_deleted field in filearchive table.
...have ar_len field in archive table.
...have ipb_block_email field in ipblocks table.
...index cl_sortkey on table categorylinks includes field cl_from.
...have oi_metadata field in oldimage table.
...have ar_page_id field in archive table.
...have img_sha1 field in image table.
...protected_titles table already exists.
...page_props table already exists.
...updatelog table already exists.
...category table already exists.
...category table already populated.
...have ar_parent_id field in archive table.
...have user_last_timestamp field in user_newtalk table.
...protected_titles table has correct pt_title encoding.
...have ss_active_users field in site_stats table.
...ss_active_users user count set...
...have ipb_allow_usertalk field in ipblocks table.
...change_tag table already exists.
...user_properties table already exists.
...log_search table already exists.
...l10n_cache table already exists.
...ct_rc_id key doesn't exist.
...have rd_interwiki field in redirect table.
...*_mime_minor fields are already long enough.
...iwlinks table already exists.
...index iwl_prefix_title_from already set on iwlinks table.
...have ul_value field in updatelog table.
...have iw_api field in interwiki table.
...iwl_prefix key doesn't exist.
...have cl_collation field in categorylinks table.
...categorylinks up-to-date.
...module_deps table already exists.
...ar_page_revid key doesn't exist.
...skipping index ar_revid because index ar_revid_uniq already set on archive table.
...user_last_timestamp is already nullable.
...index user_email already set on user table.
...up_property in table user_properties already modified by patch patch-up_property.sql.
...uploadstash table already exists.
...user_former_groups table already exists.
...have rev_sha1 field in revision table.
...batch conversion of user_options: nothing to migrate. done.
...user table does not contain user_options field.
...have ar_sha1 field in archive table.
...index page_redirect_namespace_len already set on page table.
...have us_chunk_inx field in uploadstash table.
...have job_timestamp field in job table.
...have ipb_parent_block_id field in ipblocks table.
...index ipb_parent_block_id already set on ipblocks table.
...category table does not contain cat_hidden field.
Adding rev_content_format field to table revision ...done.
Adding rev_content_model field to table revision ...done.
Adding ar_content_format field to table archive ...done.
Adding ar_content_model field to table archive ...done.
...have page_content_model field in page table.
...site_stats table does not contain ss_admins field.
...recentchanges table does not contain rc_moved_to_title field.
...sites table already exists.
...have fa_sha1 field in filearchive table.
...have job_token field in job table.
...have job_attempts field in job table.
...have us_props field in uploadstash table.
...ug_group in table user_groups already modified by patch patch-ug_group-length-increase-255.sql.
...ufg_group in table user_former_groups already modified by patch patch-ufg_group-length-increase-255.sql.
...index pp_propname_page already set on page_props table.
...index img_media_mime already set on image table.
...iwl_prefix_title_from index is already non-UNIQUE.
...index iwl_prefix_from_title already set on iwlinks table.
...have ar_id field in archive table.
...have el_id field in externallinks table.
...have rc_source field in recentchanges table.
...have page_links_updated field in page table.
...have user_password_expires field in user table.
...have pp_sortkey field in page_props table.
...recentchanges table does not contain rc_cur_time field.
...index wl_user_notificationtimestamp already set on watchlist table.
...have page_lang field in page table.
...have pl_from_namespace field in pagelinks table.
...have tl_from_namespace field in templatelinks table.
...have il_from_namespace field in imagelinks table.
...img_major_mime in table image already modified by patch patch-img_major_mime-chemical.sql.
...oi_major_mime in table oldimage already modified by patch patch-oi_major_mime-chemical.sql.
...fa_major_mime in table filearchive already modified by patch patch-fa_major_mime-chemical.sql.
...comment fields are up to date.
...hitcounter doesn't exist.
...site_stats table does not contain ss_total_views field.
...page table does not contain page_counter field.
...msg_resource_links doesn't exist.
...msg_resource doesn't exist.
...bot_passwords table already exists.
...have wl_id field in watchlist table.
...cl_collation key doesn't exist.
...index cl_collation_ext already set on categorylinks table.
...collations up-to-date.
...index rc_name_type_patrolled_timestamp already set on recentchanges table.
...rev_page_id index already non-unique.
...pl_namespace, tl_namespace, il_to indices are already non-UNIQUE.
...have ct_id field in change_tag table.
...rc_ip in table recentchanges already modified by patch patch-rc_ip_modify.sql.
...have el_index_60 field in externallinks table.
...ug_user_group key doesn't exist.
...have ug_expiry field in user_groups table.
...img_media_type in table image already modified by patch patch-add-3d.sql.
...ip_changes table already exists.
...index PRIMARY already set on categorylinks table.
...index PRIMARY already set on templatelinks table.
...index PRIMARY already set on pagelinks table.
...index PRIMARY already set on text table.
...index PRIMARY already set on imagelinks table.
...index PRIMARY already set on iwlinks table.
...index PRIMARY already set on langlinks table.
...index PRIMARY already set on log_search table.
...index PRIMARY already set on module_deps table.
...index PRIMARY already set on objectcache table.
...index PRIMARY already set on querycache_info table.
...index PRIMARY already set on site_stats table.
...index PRIMARY already set on user_former_groups table.
...index PRIMARY already set on user_properties table.
...comment table already exists.
...revision_comment_temp table already exists.
...have ar_comment_id field in archive table.
...have fa_description_id field in filearchive table.
...img_description field does not exist in image table, skipping modify field patch.
...have ipb_reason_id field in ipblocks table.
...have log_comment_id field in logging table.
...have oi_description_id field in oldimage table.
...have pt_reason_id field in protected_titles table.
...have rc_comment_id field in recentchanges table.
...rev_comment field does not exist in revision table, skipping modify field patch.
...have img_description_id field in image table.
...index PRIMARY already set on l10n_cache table.
...bot_passwords.bp_user is already unsigned int.
...change_tag.ct_log_id is already unsigned int.
...change_tag.ct_rev_id is already unsigned int.
...page_restrictions.pr_user is already unsigned int.
...user_newtalk.user_id is already unsigned int.
...user_properties.up_user is already unsigned int.
...slots table already exists.
...have slot_origin field in slots table.
...content table already exists.
...slot_roles table already exists.
...content_models table already exists.
...actor table already exists.
...revision_actor_temp table already exists.
...have ar_actor field in archive table.
...have ipb_by_actor field in ipblocks table.
...have img_actor field in image table.
...have oi_actor field in oldimage table.
...have fa_actor field in filearchive table.
...have rc_actor field in recentchanges table.
...have log_actor field in logging table.
...rev_text_id in table revision already modified by patch patch-rev_text_id-default.sql.
...table site_stats already modified by patch patch-site_stats-modify.sql.
...index rc_namespace_title_timestamp already set on recentchanges table.
...change_tag_def table already exists.
...el_index_60 in table externallinks already modified by patch patch-externallinks-el_index_60-drop-default.sql.
Running maintenance/deduplicateArchiveRevId.php...
...Update 'DeduplicateArchiveRevId' already logged as completed. Use --force to run it again.
done.
...have ct_tag_id field in change_tag table.
...index ar_revid_uniq already set on archive table.
...index log_type_action already set on logging table.
...type_action key doesn't exist.
...index PRIMARY already set on interwiki table.
...index PRIMARY already set on page_props table.
...index PRIMARY already set on protected_titles table.
...index PRIMARY already set on site_identifiers table.
...index rc_this_oldid already set on recentchanges table.
...transcache doesn't exist.
Running maintenance/populateChangeTagDef.php...
...Update 'PopulateChangeTagDef' already logged as completed. Use --force to run it again.
done.
...index change_tag_rc_tag_id already set on change_tag table.
...have ipb_sitewide field in ipblocks table.
...ipblocks_restrictions table already exists.
...change_tag table does not contain ct_tag field.
...valid_tag doesn't exist.
...tag_summary doesn't exist.
...archive table does not contain ar_comment field.
...ipblocks table does not contain ipb_reason field.
...image table does not contain img_description field.
...oldimage table does not contain oi_description field.
...filearchive table does not contain fa_description field.
...recentchanges table does not contain rc_comment field.
...logging table does not contain log_comment field.
...protected_titles table does not contain pt_reason field.
...table job already modified by patch patch-job-params-mediumblob.sql.
...ar_usertext_timestamp key doesn't exist.
...usertext_timestamp key doesn't exist.
...archive table does not contain ar_user field.
...ipblocks table does not contain ip_by field.
...img_user_timestamp key doesn't exist.
...image table does not contain img_user field.
...oldimage table does not contain oi_user field.
...filearchive table does not contain fa_user field.
...recentchanges table does not contain rc_user field.
...logging table does not contain log_user field.
...index un_user_ip already set on user_newtalk table.
...watchlist_expiry table already exists.
...page_restrictions in table page already modified by patch patch-page_restrictions-null.sql.
...index ipb_address_unique already set on ipblocks table.
...have rev_actor field in revision table.
Table archive contains ar_text_id field. Dropping ...done.
...lc_lang is up-to-date.
...ll_lang is up-to-date.
Updating length of site_language in `sites` ...done.
...index ipb_address_unique on table ipblocks has no field ipb_anon_only; added.
...ipb_address_unique index up-to-date.
...actor_name in table actor already modified by patch patch-actor-actor_name-varbinary.sql.
...site_global_key in table sites already modified by patch patch-sites-site_global_key.sql.
Modifying iwl_prefix field of table iwlinks ...done.
...site_stats is populated...done.
...Update 'populate rev_len and ar_len' already logged as completed. Use --force to run it again.
...Update 'populate rev_sha1' already logged as completed. Use --force to run it again.
...img_sha1 column of image table already populated.
...protocol-relative URLs in externallinks table already fixed.
...fa_sha1 column of filearchive table already populated.
...*_from_namespace column of backlink tables already populated.
...Update 'FixDefaultJsonContentPages' already logged as completed. Use --force to run it again.
...Update 'cleanup empty categories' already logged as completed. Use --force to run it again.
...RFC and PMID already added to interwiki database table.
...Update 'populate pp_sortkey' already logged as completed. Use --force to run it again.
...Update 'populate ip_changes' already logged as completed. Use --force to run it again.
Updating externallinks table index fields
el_id 0 - 708 of 708
Done, 0 rows updated, 0 deleted.
Purging caches...done.
Done in 0.2 s.
root@server:/../w#php maintenance/update.php --quick
MediaWiki 1.39.6 Updater
Your composer.lock file is up to date with current dependencies!
Going to run database updates for wikidb
Depending on the size of your database this may take a while!
...collations up-to-date.
...have rev_actor field in revision table.
...have img_description_id field in image table.
...slots table already exists.
...have slot_origin field in slots table.
...content table already exists.
...slot_roles table already exists.
...content_models table already exists.
...actor table already exists.
...have ar_actor field in archive table.
...have ipb_by_actor field in ipblocks table.
...have img_actor field in image table.
...have oi_actor field in oldimage table.
...have fa_actor field in filearchive table.
...have rc_actor field in recentchanges table.
...have log_actor field in logging table.
Changing 'revision.rev_text_id' default value.
...table site_stats already modified by patch patch-site_stats-modify.sql.
...index rc_namespace_title_timestamp already set on recentchanges table.
...change_tag_def table already exists.
Removing 'externallinks.el_index_60' default value.
Running maintenance/deduplicateArchiveRevId.php...
...Update 'DeduplicateArchiveRevId' already logged as completed. Use --force to run it again.
done.
...have ct_tag_id field in change_tag table.
...index ar_revid_uniq already set on archive table.
...index log_type_action already set on logging table.
...type_action key doesn't exist.
...index PRIMARY already set on interwiki table.
...index PRIMARY already set on page_props table.
...index PRIMARY already set on protected_titles table.
...index PRIMARY already set on site_identifiers table.
...index rc_this_oldid already set on recentchanges table.
...transcache doesn't exist.
Running maintenance/populateChangeTagDef.php...
...Update 'PopulateChangeTagDef' already logged as completed. Use --force to run it again.
done.
...change_tag_rc_tag key doesn't exist.
...have ipb_sitewide field in ipblocks table.
...ipblocks_restrictions table already exists.
...change_tag table does not contain ct_tag field.
...valid_tag doesn't exist.
...tag_summary doesn't exist.
...archive table does not contain ar_comment field.
...ipblocks table does not contain ipb_reason field.
...image table does not contain img_description field.
...oldimage table does not contain oi_description field.
...filearchive table does not contain fa_description field.
...recentchanges table does not contain rc_comment field.
...logging table does not contain log_comment field.
...protected_titles table does not contain pt_reason field.
...table job already modified by patch patch-job-params-mediumblob.sql.
...ar_usertext_timestamp key doesn't exist.
...usertext_timestamp key doesn't exist.
...archive table does not contain ar_user field.
...ipblocks table does not contain ip_by field.
...img_user_timestamp key doesn't exist.
...image table does not contain img_user field.
...oldimage table does not contain oi_user field.
...filearchive table does not contain fa_user field.
...recentchanges table does not contain rc_user field.
...logging table does not contain log_user field.
...index un_user_ip already set on user_newtalk table.
...watchlist_expiry table already exists.
...page_restrictions in table page already modified by patch patch-page_restrictions-null.sql.
...index ipb_address_unique already set on ipblocks table.
Table revision contains rev_text_id field. Dropping...Wikimedia\Rdbms\DBQueryError from line 1618 of /../w/includes/libs/rdbms/database/Database.php: Error 1091: Can't DROP INDEX `user_timestamp`; check that it exists
Function: Wikimedia\Rdbms\Database::sourceFile( /../w/maintenance/archives/patch-revision-actor-comment-MCR.sql )
Query: ALTER TABLE `revision`
DROP INDEX user_timestamp,
DROP INDEX page_user_timestamp,
DROP INDEX usertext_timestamp,
DROP COLUMN rev_text_id,
DROP COLUMN rev_comment,
DROP COLUMN rev_user,
DROP COLUMN rev_user_text,
DROP COLUMN rev_content_model,
DROP COLUMN rev_content_format
#0 /../w/includes/libs/rdbms/database/Database.php(1602): Wikimedia\Rdbms\Database->getQueryException()
#1 /../w/includes/libs/rdbms/database/Database.php(1576): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#2 /../w/includes/libs/rdbms/database/Database.php(952): Wikimedia\Rdbms\Database->reportQueryError()
#3 /../w/includes/libs/rdbms/database/Database.php(3302): Wikimedia\Rdbms\Database->query()
#4 /../w/includes/libs/rdbms/database/Database.php(3241): Wikimedia\Rdbms\Database->sourceStream()
#5 /../w/includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\Database->sourceFile()
#6 /../w/includes/libs/rdbms/database/DBConnRef.php(807): Wikimedia\Rdbms\DBConnRef->__call()
#7 /../w/includes/installer/DatabaseUpdater.php(718): Wikimedia\Rdbms\DBConnRef->sourceFile()
#8 /../w/includes/installer/DatabaseUpdater.php(843): DatabaseUpdater->applyPatch()
#9 /../w/includes/installer/DatabaseUpdater.php(547): DatabaseUpdater->dropField()
#10 /../w/includes/installer/DatabaseUpdater.php(511): DatabaseUpdater->runUpdates()
#11 /../w/maintenance/update.php(209): DatabaseUpdater->doUpdates()
#12 /../w/maintenance/includes/MaintenanceRunner.php(309): UpdateMediaWiki->execute()
#13 /../w/maintenance/doMaintenance.php(85): MediaWiki\Maintenance\MaintenanceRunner->run()
#14 /../w/maintenance/update.php(319): require_once('/../w/..')
#15 {main}
root@server:/../w# git checkout T331608
M extensions/Cite
M extensions/ParserFunctions
M extensions/PdfHandler
M extensions/Poem
M extensions/WikiEditor
Switched to branch 'T331608'
root@server:/../w# nano /../w/maintenance/archives/patch-revision-actor-comment-MCR.sql
root@server:/../w# php maintenance/update.php --quick
MediaWiki 1.39.6 Updater
Your composer.lock file is up to date with current dependencies!
Going to run database updates for wikidb
Depending on the size of your database this may take a while!
...collations up-to-date.
...have rev_actor field in revision table.
...have img_description_id field in image table.
...slots table already exists.
...have slot_origin field in slots table.
...content table already exists.
...slot_roles table already exists.
...content_models table already exists.
...actor table already exists.
...have ar_actor field in archive table.
...have ipb_by_actor field in ipblocks table.
...have img_actor field in image table.
...have oi_actor field in oldimage table.
...have fa_actor field in filearchive table.
...have rc_actor field in recentchanges table.
...have log_actor field in logging table.
Changing 'revision.rev_text_id' default value.
...table site_stats already modified by patch patch-site_stats-modify.sql.
...index rc_namespace_title_timestamp already set on recentchanges table.
...change_tag_def table already exists.
Running maintenance/deduplicateArchiveRevId.php...
...Update 'DeduplicateArchiveRevId' already logged as completed. Use --force to run it again.
done.
...have ct_tag_id field in change_tag table.
...index ar_revid_uniq already set on archive table.
...index log_type_action already set on logging table.
...type_action key doesn't exist.
...index PRIMARY already set on interwiki table.
...index PRIMARY already set on page_props table.
...index PRIMARY already set on protected_titles table.
...index PRIMARY already set on site_identifiers table.
...index rc_this_oldid already set on recentchanges table.
...transcache doesn't exist.
Running maintenance/populateChangeTagDef.php...
...Update 'PopulateChangeTagDef' already logged as completed. Use --force to run it again.
done.
...change_tag_rc_tag key doesn't exist.
...have ipb_sitewide field in ipblocks table.
...ipblocks_restrictions table already exists.
...change_tag table does not contain ct_tag field.
...valid_tag doesn't exist.
...tag_summary doesn't exist.
...archive table does not contain ar_comment field.
...ipblocks table does not contain ipb_reason field.
...image table does not contain img_description field.
...oldimage table does not contain oi_description field.
...filearchive table does not contain fa_description field.
...recentchanges table does not contain rc_comment field.
...logging table does not contain log_comment field.
...protected_titles table does not contain pt_reason field.
...table job already modified by patch patch-job-params-mediumblob.sql.
...ar_usertext_timestamp key doesn't exist.
...usertext_timestamp key doesn't exist.
...archive table does not contain ar_user field.
...ipblocks table does not contain ip_by field.
...img_user_timestamp key doesn't exist.
...image table does not contain img_user field.
...oldimage table does not contain oi_user field.
...filearchive table does not contain fa_user field.
...recentchanges table does not contain rc_user field.
...logging table does not contain log_user field.
...index un_user_ip already set on user_newtalk table.
...watchlist_expiry table already exists.
...page_restrictions in table page already modified by patch patch-page_restrictions-null.sql.
...index ipb_address_unique already set on ipblocks table.
Table revision contains rev_text_id field. Dropping...done.
...archive table does not contain ar_text_id field.
...lc_lang is up-to-date.
...ll_lang is up-to-date.
...site_language is up-to-date.
...index ipb_address_unique on table ipblocks has no field ipb_anon_only; added.
...ipb_address_unique index up-to-date.
...actor_name in table actor already modified by patch patch-actor-actor_name-varbinary.sql.
...site_global_key in table sites already modified by patch patch-sites-site_global_key.sql.
...iwl_prefix in table iwlinks already modified by patch patch-extend-iwlinks-iwl_prefix.sql.
Modifying rd_title field of table redirect...done.
Modifying pl_title field of table pagelinks...done.
Modifying tl_title field of table templatelinks...done.
Modifying il_to field of table imagelinks...done.
Modifying ll_title field of table langlinks...done.
Modifying iwl_title field of table iwlinks...done.
Modifying cat_title field of table category...done.
Modifying qc_title field of table querycache...done.
Modifying qcc_title field of table querycachetwo...done.
Modifying wl_title field of table watchlist...done.
Modifying user_last_timestamp field of table user_newtalk...done.
Modifying pt_title field of table protected_titles...done.
Removing 'protected_titles.pt_expiry' default value.
Removing 'ip_changes.ipc_rev_timestamp' default value.
Modifying ir_type field of table ipblocks_restrictions...done.
Renaming index namespace_title into wl_namespace_title to table watchlist...done.
Modifying job_title field of table job...done.
Modifying job_timestamp field of table job...done.
Modifying job_token_timestamp field of table job...done.
Modifying wl_notificationtimestamp field of table watchlist...done.
Modifying role_id field of table slot_roles...done.
Modifying model_id field of table content_models...done.
Modifying cl_to field of table categorylinks...done.
Modifying log_title field of table logging...done.
Modifying us_timestamp field of table uploadstash...done.
Renaming index user_properties_property into up_property to table user_properties...done.
Renaming index sites_global_key into site_global_key to table sites...done.
Renaming index type_time into log_type_time to table logging...done.
Modifying fa_name field of table filearchive...done.
Removing 'filearchive.fa_deleted_timestamp' default value.
Removing 'filearchive.fa_timestamp' default value.
Modifying oi_name field of table oldimage...done.
Removing 'oldimage.oi_timestamp' default value.
Modifying exptime field of table objectcache...done.
Removing 'ipblocks.ipb_timestamp' default value.
Removing 'ipblocks.ipb_expiry' default value.
Renaming index name_title_timestamp into ar_name_title_timestamp to table archive...done.
Modifying img_name field of table image...done.
Removing 'image.img_timestamp' default value.
Modifying img_timestamp field of table image...done.
Renaming index site_ids_key into si_key to table site_identifiers...done.
Modifying rc_title field of table recentchanges...done.
Removing 'recentchanges.rc_timestamp' default value.
Modifying rc_timestamp field of table recentchanges...done.
Modifying rc_id field of table recentchanges...done.
Renaming index new_name_timestamp into rc_new_name_timestamp to table recentchanges...done.
Removing 'archive.ar_timestamp' default value.
Modifying ar_title field of table archive...done.
Modifying page_title field of table page...done.
Removing 'page.page_touched' default value.
Modifying user_name field of table user...done.
Renaming index page_timestamp into rev_page_timestamp to table revision...done.
Adding modtoken field to table objectcache...done.
Removing 'revision.rev_timestamp' default value.
Adding index oi_timestamp to table oldimage...done.
Renaming index name_title into page_name_title to table page...done.
Renaming index change_tag_rc_tag_id into ct_rc_tag_id to table change_tag...done.
Converting djvu metadata...
Finished refreshing file metadata for 0 files. 0 needed to be refreshed, 0 did not need to be but were refreshed anyways, and 0 refreshes were suspicious.
...done.
Table page_restrictions contains pr_user field. Dropping...done.
Modifying fa_id field of table filearchive...done.
Modifying img_major_mime field of table image...done.
Creating linktarget table...done.
Dropping rev_page_id index from table revision...done.
Modifying pr_page field of table page_restrictions...done.
Modifying pp_page field of table page_props...done.
Modifying ir_value field of table ipblocks_restrictions...done.
Adding tl_target_id field to table templatelinks...done.
Creating user_autocreate_serial table...done.
Modifying ir_ipb_id field of table ipblocks_restrictions...done.
Modifying ipb_id field of table ipblocks...done.
Modifying user_editcount field of table user...done.
Running maintenance/migrateRevisionActorTemp.php...
Merging the revision_actor_temp table into the revision table...
... rev_id=220, updated 200
... rev_id=439, updated 400
... rev_id=654, updated 600
... rev_id=855, updated 800
... rev_id=1062, updated 1000
... rev_id=1297, updated 1200
... rev_id=1521, updated 1400
... rev_id=1746, updated 1600
... rev_id=1990, updated 1800
... rev_id=2216, updated 2000
... rev_id=2428, updated 2200
... rev_id=2636, updated 2400
... rev_id=2852, updated 2600
... rev_id=3060, updated 2800
... rev_id=3286, updated 3000
... rev_id=3528, updated 3200
... rev_id=3761, updated 3400
... rev_id=3971, updated 3600
... rev_id=4177, updated 3800
... rev_id=4397, updated 4000
... rev_id=4614, updated 4200
... rev_id=4817, updated 4400
... rev_id=5017, updated 4600
... rev_id=5221, updated 4800
... rev_id=5433, updated 5000
... rev_id=5637, updated 5200
Completed merge of revision_actor into the revision table, 5388 rows updated.
done.
Dropping table revision_actor_temp ...done.
Running maintenance/updateRestrictions.php...
...processing page IDs from 0 to 1000.
...processing page IDs from 1000 to 2000.
...Done!
done.
Table page contains page_restrictions field. Dropping...done.
Running migrateLinksTable.php on templatelinks...
Populating the tl_target_id column
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 371 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 371 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 27 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 26 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 5 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 73 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 65 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 65 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 39 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 45 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 26 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 27 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 26 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 19 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 6 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 194 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 171 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 90 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 91 rows
Starting backfill of 0:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 4 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 12 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 12 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 2 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 0 and 999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 154 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 84 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 154 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 66 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 39 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 39 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 12 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 25 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 26 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 2 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 2 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 7 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 7 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 18 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 18 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 4 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 4 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 1 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 26 rows
Starting backfill of 10:redacted title on pages between 1000 and 1999
Updated 4 rows
Completed normalization of templatelinks, 2474 rows updated.
done.
Modifying tl_namespace field of table templatelinks...done.
Table templatelinks contains tl_title field. Dropping...done.
...site_stats is populated...done.
...Update 'populate rev_len and ar_len' already logged as completed. Use --force to run it again.
...Update 'populate rev_sha1' already logged as completed. Use --force to run it again.
...img_sha1 column of image table already populated.
...protocol-relative URLs in externallinks table already fixed.
...fa_sha1 column of filearchive table already populated.
...*_from_namespace column of backlink tables already populated.
...Update 'FixDefaultJsonContentPages' already logged as completed. Use --force to run it again.
...Update 'cleanup empty categories' already logged as completed. Use --force to run it again.
...RFC and PMID already added to interwiki database table.
...Update 'populate pp_sortkey' already logged as completed. Use --force to run it again.
...Update 'populate ip_changes' already logged as completed. Use --force to run it again.
...externallinks table indexes up to date.
Purging caches...done.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment