[root@mwinstance /opt/mwinstance/www]# php maintenance/run update
Deprecated: Use of PrefixSearchBackend hook (used in TitleKey::prefixSearchBackend) was deprecated in MediaWiki 1.27. [Called from MediaWiki\HookContainer\HookContainer::register in /opt/mwinstance/www/includes/HookContainer/HookContainer.php at line 436] in /opt/mwinstance/www/includes/debug/MWDebug.php on line 379
MediaWiki 1.42.1 Updater

Your composer.lock file is up to date with current dependencies!
Going to run database updates for mwinstance-mediawiki-
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds (skip this countdown with --quick) ...0
Updating category collations...
Selecting next 100 pages from cl_from = 0... processing... 0 done.
Selecting next 100 pages from cl_from = 100... processing... 0 done.
Selecting next 100 pages from cl_from = 200... processing... 0 done.
Selecting next 100 pages from cl_from = 300... processing... 0 done.
Selecting next 100 pages from cl_from = 400... processing... 0 done.
Selecting next 100 pages from cl_from = 500... processing... 0 done.
Selecting next 100 pages from cl_from = 600... processing... 0 done.
Selecting next 100 pages from cl_from = 700... processing... 0 done.
Selecting next 100 pages from cl_from = 800... processing... 0 done.
Selecting next 100 pages from cl_from = 900... processing... 0 done.
Selecting next 100 pages from cl_from = 1000... processing... 0 done.
Selecting next 100 pages from cl_from = 1100... processing... 0 done.
Selecting next 100 pages from cl_from = 1200... processing... 0 done.
Selecting next 100 pages from cl_from = 1300... processing... 0 done.
0 rows processed
...done.
...column 'revision.rev_actor' already exists
...index 'rev_actor_timestamp' on table 'revision' already exists
...index 'rev_page_actor_timestamp' on table 'revision' already exists
...index redirect_pkey already set on redirect table.
...watchlist_expiry table already exists.
Changing 'user_newtalk.user_ip' default value
...column 'user_newtalk.user_ip' is already set as NOT NULL
Changing 'user_newtalk.user_id' default value
...revision table does not contain rev_user field.
...revision table does not contain rev_user_text field.
...revision table does not contain rev_comment field.
...revision table does not contain rev_text_id field.
...revision table does not contain rev_content_model field.
...revision table does not contain rev_content_format field.
...column 'revision.rev_comment_id' already exists
...archive table does not contain ar_text_id field.
...archive table does not contain ar_content_model field.
...archive table does not contain ar_content_format field.
Changing column type of 'updatelog.ul_key' from 'varchar' to 'varchar(255)'
...column 'updatelog.ul_value' is already of type 'TEXT'
...column 'site_identifiers.si_type' is already of type 'TEXT'
...column 'site_identifiers.si_key' is already of type 'TEXT'
...column 'actor.actor_id' is already of type 'BIGINT'
...column 'actor.actor_name' is already of type 'TEXT'
...column 'user_former_groups.ufg_group' is already of type 'TEXT'
...foreign key constraint on 'user_former_groups.ufg_user' already does not exist
...no need to drop index 'ipb_address_unique'
...index 'ipb_address_unique' exists
Changing 'bot_passwords.bp_token' default value
...column 'comment.comment_id' is already of type 'BIGINT'
...column 'slots.slot_revision_id' is already of type 'BIGINT'
...column 'slots.slot_content_id' is already of type 'BIGINT'
...column 'slots.slot_origin' is already of type 'BIGINT'
...column 'site_stats.ss_total_edits' is already of type 'BIGINT'
...column 'site_stats.ss_good_articles' is already of type 'BIGINT'
...column 'site_stats.ss_total_pages' is already of type 'BIGINT'
...column 'site_stats.ss_users' is already of type 'BIGINT'
...column 'site_stats.ss_active_users' is already of type 'BIGINT'
...column 'site_stats.ss_images' is already of type 'BIGINT'
...foreign key constraint on 'user_properties.up_user' already does not exist
...index user_properties_pkey already set on user_properties table.
Changing column type of 'log_search.ls_value' from 'varchar' to 'VARCHAR(255)'
...column 'content.content_id' is already of type 'BIGINT'
...column 'l10n_cache.lc_value' is already of type 'TEXT'
Changing column type of 'l10n_cache.lc_key' from 'varchar' to 'VARCHAR(255)'
...index l10n_cache_pkey already set on l10n_cache table.
...index module_deps_pkey already set on module_deps table.
Changing column type of 'redirect.rd_namespace' from 'integer' to 'INT'
Changing 'redirect.rd_title' default value
Changing 'redirect.rd_from' default value
...foreign key constraint on 'redirect.rd_from' already does not exist
Changing column type of 'redirect.rd_interwiki' from 'varchar' to 'VARCHAR(32)'
...foreign key constraint on 'pagelinks.pl_from' already does not exist
Changing column type of 'pagelinks.pl_namespace' from 'integer' to 'INT'
Changing 'pagelinks.pl_title' default value
...index 'pl_namespace' on table 'pagelinks' already exists
...index 'pl_backlinks_namespace' on table 'pagelinks' already exists
...foreign key constraint on 'templatelinks.tl_from' already does not exist
...foreign key constraint on 'imagelinks.il_from' already does not exist
Changing 'imagelinks.il_to' default value
...index 'il_to' on table 'imagelinks' already exists
...index 'il_backlinks_namespace' on table 'imagelinks' already exists
...foreign key constraint on 'langlinks.ll_from' already does not exist
...index langlinks_pkey already set on langlinks table.
...index ll_lang already set on langlinks table.
Changing 'langlinks.ll_lang' default value
Changing 'langlinks.ll_from' default value
Changing 'langlinks.ll_title' default value
...column 'langlinks.ll_lang' is already set as NOT NULL
...column 'langlinks.ll_title' is already set as NOT NULL
...index iwlinks_pkey already set on iwlinks table.
...index cat_title already set on category table.
...index cat_pages already set on category table.
...column 'change_tag_def.ctd_count' is already of type 'BIGINT'
...foreign key constraint on 'ipblocks_restrictions.ir_ipb_id' already does not exist
Changing 'querycache.qc_value' default value
Changing column type of 'querycache.qc_namespace' from 'integer' to 'INT'
Changing 'querycache.qc_title' default value
...index qc_type already set on querycache table.
...index qcc_type already set on querycachetwo table.
...index qcc_title already set on querycachetwo table.
...index qcc_titletwo already set on querycachetwo table.
...foreign key constraint on 'page_restrictions.pr_page' already does not exist
...index 'pr_pagetype' on table 'page_restrictions' already exists
...index 'pr_typelevel' on table 'page_restrictions' already exists
...index 'pr_level' on table 'page_restrictions' already exists
...index 'pr_cascade' on table 'page_restrictions' already exists
...no need to change primary key of 'page_restrictions'
...column 'page_restrictions.pr_page' is already set as NOT NULL
...foreign key constraint on 'user_groups.ug_user' already does not exist
Changing 'user_groups.ug_user' default value
Changing 'user_groups.ug_group' default value
...index ug_group already set on user_groups table.
...index ug_expiry already set on user_groups table.
Changing 'querycache_info.qci_type' default value
Changing 'querycache_info.qci_timestamp' default value
...column 'querycache_info.qci_type' is already set as NOT NULL
...column 'querycache_info.qci_timestamp' is already set as NOT NULL
...index querycache_info_pkey already set on querycache_info table.
Changing 'watchlist.wl_title' default value
Changing column type of 'watchlist.wl_namespace' from 'integer' to 'INT'
...foreign key constraint on 'watchlist.wl_user' already does not exist
...index 'namespace_title' on table 'watchlist' already exists
Dropping obsolete version of index 'wl_user'
Creating index 'wl_user'
Changing column type of 'sites.site_domain' from 'varchar' to 'VARCHAR(255)'
...index sites_group already set on sites table.
...foreign key constraint on 'user_newtalk.user_id' already does not exist
...index un_user_id already set on user_newtalk table.
...index un_user_ip already set on user_newtalk table.
Changing column type of 'interwiki.iw_prefix' from 'varchar' to 'VARCHAR(32)'
Changing column type of 'interwiki.iw_wikiid' from 'varchar' to 'VARCHAR(64)'
...foreign key constraint on 'protected_titles.pt_user' already does not exist
...column 'protected_titles.pt_user' is already set as NOT NULL
...column 'protected_titles.pt_expiry' is already set as NOT NULL
...column 'protected_titles.pt_reason_id' is already of type 'BIGINT'
...foreign key constraint on 'externallinks.el_from' already does not exist
...index el_from already set on externallinks table.
...index el_index already set on externallinks table.
...column 'ip_changes.ipc_hex' is already of type 'TEXT'
Changing 'ip_changes.ipc_rev_id' default value
...index wl_namespace_title already set on watchlist table.
...WARNING: namespace_title still exists, despite it has been renamed into wl_namespace_title (which also exists).
            namespace_title should be manually removed if not needed anymore.
...foreign key constraint on 'page_props.pp_page' already does not exist
...no need to change primary key of 'page_props'
Changing 'job.job_cmd' default value
...column 'job.job_namespace' is already of type 'INTEGER'
...index 'job_cmd' on table 'job' already exists
...index job_timestamp already set on job table.
...column 'slot_roles.role_id' is already of type 'INTEGER'
...column 'content_models.model_id' is already of type 'INTEGER'
...index page_len already set on page table.
...index page_random already set on page table.
...index page_name_title already set on page table.
...index 'page_redirect_namespace_len' on table 'page' already exists
...foreign key constraint on 'categorylinks.cl_from' already does not exist
Changing 'categorylinks.cl_from' default value
Changing 'categorylinks.cl_to' default value
Changing 'categorylinks.cl_sortkey' default value
Changing 'categorylinks.cl_collation' default value
...column 'categorylinks.cl_sortkey' is already set as NOT NULL
...index categorylinks_pkey already set on categorylinks table.
...index 'cl_timestamp' on table 'categorylinks' already exists
...index 'cl_collation_ext' on table 'categorylinks' already exists
Dropping obsolete version of index 'cl_sortkey'
Creating index 'cl_sortkey'
...skipping: index logging_type_name doesn't exist.
...skipping: index logging_actor_time_backwards doesn't exist.
...skipping: index logging_page_time doesn't exist.
...skipping: index logging_times doesn't exist.
...index log_actor_type_time already set on logging table.
...index log_page_id_time already set on logging table.
...index log_type_action already set on logging table.
...column 'logging.log_params' is already set as NOT NULL
Changing 'logging.log_action' default value
Changing 'logging.log_type' default value
Changing 'logging.log_title' default value
Changing 'logging.log_timestamp' default value
...column 'logging.log_actor' is already of type 'BIGINT'
...column 'logging.log_comment_id' is already of type 'BIGINT'
Changing column type of 'logging.log_namespace' from 'integer' to 'INT'
Changing column type of 'uploadstash.us_key' from 'varchar' to 'VARCHAR(255)'
Changing column type of 'uploadstash.us_orig_path' from 'varchar' to 'VARCHAR(255)'
Changing column type of 'uploadstash.us_path' from 'varchar' to 'VARCHAR(255)'
Changing column type of 'uploadstash.us_source_type' from 'varchar' to 'VARCHAR(50)'
...column 'uploadstash.us_props' is already of type 'TEXT'
Changing column type of 'uploadstash.us_status' from 'varchar' to 'VARCHAR(50)'
Changing column type of 'uploadstash.us_sha1' from 'varchar' to 'VARCHAR(31)'
Changing column type of 'uploadstash.us_mime' from 'varchar' to 'VARCHAR(255)'
...column 'uploadstash.us_key' is already set as NOT NULL
...column 'uploadstash.us_user' is already set as NOT NULL
...column 'uploadstash.us_orig_path' is already set as NOT NULL
...column 'uploadstash.us_path' is already set as NOT NULL
...column 'uploadstash.us_timestamp' is already set as NOT NULL
...column 'uploadstash.us_status' is already set as NOT NULL
...column 'uploadstash.us_size' is already set as NOT NULL
...column 'uploadstash.us_sha1' is already set as NOT NULL
...index us_user already set on uploadstash table.
...index us_key already set on uploadstash table.
...index us_timestamp already set on uploadstash table.
...index up_property already set on user_properties table.
...skipping: index sites_group,  doesn't exist.
...index log_type_time already set on logging table.
...index log_actor_time already set on logging table.
...index log_page_time already set on logging table.
...index log_times already set on logging table.
Changing 'filearchive.fa_name' default value
Changing 'filearchive.fa_archive_name' default value
Changing 'filearchive.fa_storage_key' default value
...foreign key constraint on 'filearchive.fa_deleted_user' already does not exist
...column 'filearchive.fa_deleted_reason_id' is already of type 'BIGINT'
...column 'filearchive.fa_metadata' is already of type 'TEXT'
...column 'filearchive.fa_bits' is already of type 'INTEGER'
...column 'filearchive.fa_description_id' is already of type 'BIGINT'
...column 'filearchive.fa_actor' is already of type 'BIGINT'
...index fa_name already set on filearchive table.
...index fa_storage_group already set on filearchive table.
...index fa_deleted_timestamp already set on filearchive table.
...index 'fa_actor_timestamp' on table 'filearchive' already exists
...index 'ipb_expiry' on table 'ipblocks' already exists
...index 'ipb_timestamp' on table 'ipblocks' already exists
...index text_pkey already set on text table.
...column 'text.old_text' is already set as NOT NULL
...column 'text.old_flags' is already set as NOT NULL
Changing 'oldimage.oi_name' default value
Changing 'oldimage.oi_archive_name' default value
Changing 'oldimage.oi_size' default value
Changing 'oldimage.oi_width' default value
Changing 'oldimage.oi_height' default value
Changing 'oldimage.oi_bits' default value
Changing 'oldimage.oi_name' default value
...column 'oldimage.oi_bits' is already of type 'INTEGER'
...column 'oldimage.oi_description_id' is already of type 'BIGINT'
...column 'oldimage.oi_actor' is already of type 'BIGINT'
...column 'oldimage.oi_metadata' is already of type 'TEXT'
...column 'oldimage.oi_minor_mime' is already set as NOT NULL
...column 'oldimage.oi_minor_mime' is already set as NOT NULL
...foreign key constraint on 'oldimage.oi_name' already does not exist
...index 'oi_actor_timestamp' on table 'oldimage' already exists
...index 'rc_ns_actor' on table 'recentchanges' already exists
...index 'rc_actor' on table 'recentchanges' already exists
...keyname key doesn't exist.
...column 'objectcache.value' is already of type 'TEXT'
...column 'objectcache.value' is already set as NULL
...foreign key constraint on 'ipblocks.ipb_user' already does not exist
...foreign key constraint on 'ipblocks.ipb_parent_block_id' already does not exist
Changing 'ipblocks.ipb_user' default value
...column 'ipblocks.ipb_user' is already set as NOT NULL
...column 'ipblocks.ipb_range_start' is already set as NOT NULL
...column 'ipblocks.ipb_range_end' is already set as NOT NULL
...column 'ipblocks.ipb_by_actor' is already of type 'BIGINT'
...column 'ipblocks.ipb_reason_id' is already of type 'BIGINT'
...index ar_name_title_timestamp already set on archive table.
...index 'ar_actor_timestamp' on table 'archive' already exists
Changing 'image.img_name' default value
Changing 'image.img_size' default value
Changing 'image.img_width' default value
Changing 'image.img_height' default value
Changing 'image.img_bits' default value
...column 'image.img_bits' is already of type 'INTEGER'
...column 'image.img_description_id' is already of type 'BIGINT'
...column 'image.img_actor' is already of type 'BIGINT'
...column 'image.img_metadata' is already of type 'TEXT'
...column 'image.img_major_mime' is already set as NOT NULL
...column 'image.img_minor_mime' is already set as NOT NULL
...column 'image.img_timestamp' is already set as NOT NULL
...index img_size already set on image table.
...index img_timestamp already set on image table.
...index 'img_actor_timestamp' on table 'image' already exists
...index 'img_media_mime' on table 'image' already exists
...index si_site already set on site_identifiers table.
...index si_key already set on site_identifiers table.
...column 'recentchanges.rc_actor' is already of type 'BIGINT'
...column 'recentchanges.rc_comment_id' is already of type 'BIGINT'
...column 'recentchanges.rc_ip' is already of type 'TEXT'
...column 'recentchanges.rc_namespace' is already of type 'INTEGER'
Changing 'recentchanges.rc_title' default value
Changing 'recentchanges.rc_source' default value
Changing 'recentchanges.rc_ip' default value
Changing 'recentchanges.rc_namespace' default value
Changing 'recentchanges.rc_cur_id' default value
Changing 'recentchanges.rc_this_oldid' default value
Changing 'recentchanges.rc_last_oldid' default value
...column 'recentchanges.rc_cur_id' is already set as NOT NULL
...column 'recentchanges.rc_ip' is already set as NOT NULL
...index rc_new_name_timestamp already set on recentchanges table.
...column 'archive.ar_namespace' is already of type 'INTEGER'
Changing 'archive.ar_namespace' default value
Changing 'archive.ar_title' default value
...column 'archive.ar_comment_id' is already of type 'BIGINT'
...column 'archive.ar_actor' is already of type 'BIGINT'
...index user_email_token already set on user table.
...index 'user_email' on table 'user' already exists
...index 'user_name' on table 'user' already exists
...column 'page.page_namespace' is already of type 'INTEGER'
...column 'page.page_touched' is already set as NOT NULL
Changing column type of 'page.page_random' from 'float8' to 'FLOAT'
...skipping: index revision_unique doesn't exist.
...index rev_timestamp already set on revision table.
...index 'rev_page_timestamp' on table 'revision' already exists
...column 'user.user_touched' is already set as NOT NULL
Changing 'user.user_name' default value
Changing 'user.user_token' default value
Changing 'user.user_real_name' default value
Changing 'user.user_email' default value
Changing 'user.user_newpassword' default value
Changing 'user.user_password' default value
...column 'user.user_token' is already set as NOT NULL
...column 'user.user_real_name' is already set as NOT NULL
...column 'user.user_email' is already set as NOT NULL
...column 'user.user_newpassword' is already set as NOT NULL
...column 'user.user_password' is already set as NOT NULL
Removing 'user.user_email' default value
Removing 'user.user_newpassword' default value
Removing 'user.user_password' default value
...have modtoken field in objectcache table.
...foreign key constraint on 'revision.rev_page' already does not exist
...column 'revision.rev_page' is already set as NOT NULL
...column 'revision.rev_comment_id' is already of type 'BIGINT'
...column 'revision.rev_actor' is already of type 'BIGINT'
...no need to drop index 'rev_page_id'
Creating index 'rev_page_id'
...searchindex table already exists.
...index 'oi_timestamp' on table 'oldimage' already exists
...index page_name_title already set on page table.
...index ct_rc_tag_id already set on change_tag table.
...index ct_log_tag_id already set on change_tag table.
...index ct_rev_tag_id already set on change_tag table.
...index ct_tag_id_id already set on change_tag table.
...page_restrictions table does not contain pr_user field.
...linktarget table already exists.
Dropping rev_page_id index from table revision...done.
...have tl_target_id field in templatelinks table.
...user_autocreate_serial table already exists.
Running maintenance/migrateRevisionActorTemp.php...
...Update 'MigrateRevisionActorTemp' already logged as completed. Use --force to run it again.
done.
...revision_actor_temp doesn't exist.
Running maintenance/updateRestrictions.php...
Migration is not needed.
done.
...page table does not contain page_restrictions field.
...templatelinks table has already been migrated.
...column 'templatelinks.tl_target_id' is already set as NOT NULL
...no need to change primary key of 'templatelinks'
...templatelinks table does not contain tl_title field.
...have el_to_path field in externallinks table.
Adding user_is_temp field to table user...done.
Running maintenance/migrateRevisionCommentTemp.php...
Merging the revision_comment_temp table into the revision table...
... rev_id=208, updated 200
... rev_id=408, updated 400
... rev_id=654, updated 600
... rev_id=857, updated 800
... rev_id=1057, updated 1000
... rev_id=1259, updated 1200
... rev_id=1461, updated 1400
... rev_id=1662, updated 1600
... rev_id=1862, updated 1800
... rev_id=2062, updated 2000
... rev_id=2262, updated 2200
... rev_id=2462, updated 2400
... rev_id=2832, updated 2600
Completed merge of revision_comment_temp into the revision table, 2604 rows updated.
done.
Dropping table revision_comment_temp ...done.
Running maintenance/migrateExternallinks.php...
Populating el_to_domain_index and el_to_path columns
Updated 685 rows
Updated 321 rows
Completed normalization of externallinks, 1006 rows updated.
done.
Modifying el_to field of table externallinks...done.
Adding pl_target_id field to table pagelinks...done.
Table externallinks contains el_to field. Dropping...done.
Running maintenance/fixInconsistentRedirects.php...
Fixing inconsistent redirects ...
Estimated redirect page count: 176
0/100
0/176
Done, updated 0 of 176 rows.
done.
Modifying img_size field of table image...done.
Modifying fa_size field of table filearchive...done.
Modifying oi_size field of table oldimage...done.
Modifying us_size field of table uploadstash...done.
Adding uas_year field to table user_autocreate_serial...done.
Creating block_target table...done.
Dropping cl_collation_ext index from table categorylinks...done.
Running maintenance/populateUserIsTemp.php...
done.
Dropping site_type index from table sites...Wikimedia\Rdbms\DBQueryError from line 1203 of /opt/mwinstance/www/includes/libs/rdbms/database/Database.php: Error 42704: ERROR:  index "site_group" does not exist

Function: Wikimedia\Rdbms\Database::sourceFile( /opt/mwinstance/www/maintenance/postgres/archives/patch-sites-drop_indexes.sql )
Query: DROP INDEX site_group


#0 /opt/mwinstance/www/includes/libs/rdbms/database/Database.php(1187): Wikimedia\Rdbms\Database->getQueryException('ERROR:  index "...', '42704', 'DROP INDEX site...', 'Wikimedia\\Rdbms...')
#1 /opt/mwinstance/www/includes/libs/rdbms/database/Database.php(1161): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('ERROR:  index "...', '42704', 'DROP INDEX site...', 'Wikimedia\\Rdbms...')
#2 /opt/mwinstance/www/includes/libs/rdbms/database/Database.php(652): Wikimedia\Rdbms\Database->reportQueryError('ERROR:  index "...', '42704', 'DROP INDEX site...', 'Wikimedia\\Rdbms...', false)
#3 /opt/mwinstance/www/includes/libs/rdbms/database/Database.php(2809): Wikimedia\Rdbms\Database->query(Object(Wikimedia\Rdbms\Query), 'Wikimedia\\Rdbms...')
#4 /opt/mwinstance/www/includes/libs/rdbms/database/Database.php(2747): Wikimedia\Rdbms\Database->sourceStream(Resource id #941, NULL, NULL, 'Wikimedia\\Rdbms...', NULL)
#5 /opt/mwinstance/www/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->sourceFile('/opt/mwinstance/...')
#6 /opt/mwinstance/www/includes/libs/rdbms/database/DBConnRef.php(810): Wikimedia\Rdbms\DBConnRef->__call('sourceFile', Array)
#7 /opt/mwinstance/www/includes/installer/DatabaseUpdater.php(767): Wikimedia\Rdbms\DBConnRef->sourceFile('/opt/mwinstance/...')
#8 /opt/mwinstance/www/includes/installer/DatabaseUpdater.php(916): MediaWiki\Installer\DatabaseUpdater->applyPatch('/opt/mwinstance/...', false, 'Dropping site_t...')
#9 /opt/mwinstance/www/includes/installer/DatabaseUpdater.php(605): MediaWiki\Installer\DatabaseUpdater->dropIndex('sites', 'site_type', 'patch-sites-dro...')
#10 /opt/mwinstance/www/includes/installer/DatabaseUpdater.php(558): MediaWiki\Installer\DatabaseUpdater->runUpdates(Array, false)
#11 /opt/mwinstance/www/maintenance/update.php(189): MediaWiki\Installer\DatabaseUpdater->doUpdates(Array)
#12 /opt/mwinstance/www/maintenance/includes/MaintenanceRunner.php(698): UpdateMediaWiki->execute()
#13 /opt/mwinstance/www/maintenance/run.php(51): MediaWiki\Maintenance\MaintenanceRunner->run()
#14 /opt/mwinstance/www/maintenance/run(3): require('/opt/mwinstance/...')
#15 {main}