Hello!

As 1.39 approaches its end of support, I am about to upgrade my wikis to 1.43.

Running the update script on a freshly installed wiki with version 1.39.13 and trying to update to 1.43.3 fails here:

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 PopulateUserIsTemp... done. Dropping site_type index from table sites...Wikimedia\Rdbms\DBQueryError from line 1198 of /data/mediawiki/software/mediawiki-1.43.3/includes/libs/rdbms/database/Database.php: Error 42704: ERROR: index "site_group" does not exist

Function: Wikimedia\Rdbms\Database::sourceFile( /data/mediawiki/software/mediawiki-1.43.3/maintenance/postgres/archives/patch-sites-drop_indexes.sql ) Query: DROP INDEX site_group

#0 /data/mediawiki/software/mediawiki-1.43.3/includes/libs/rdbms/database/Database.php(1182): Wikimedia\Rdbms\Database->getQueryException() #1 /data/mediawiki/software/mediawiki-1.43.3/includes/libs/rdbms/database/Database.php(1156): Wikimedia\Rdbms\Database->getQueryExceptionAndLog() #2 /data/mediawiki/software/mediawiki-1.43.3/includes/libs/rdbms/database/Database.php(647): Wikimedia\Rdbms\Database->reportQueryError() #3 /data/mediawiki/software/mediawiki-1.43.3/includes/libs/rdbms/database/Database.php(2791): Wikimedia\Rdbms\Database->query() #4 /data/mediawiki/software/mediawiki-1.43.3/includes/libs/rdbms/database/Database.php(2729): Wikimedia\Rdbms\Database->sourceStream() #5 /data/mediawiki/software/mediawiki-1.43.3/includes/libs/rdbms/database/DBConnRef.php(127): Wikimedia\Rdbms\Database->sourceFile() #6 /data/mediawiki/software/mediawiki-1.43.3/includes/libs/rdbms/database/DBConnRef.php(799): Wikimedia\Rdbms\DBConnRef->__call() #7 /data/mediawiki/software/mediawiki-1.43.3/includes/installer/DatabaseUpdater.php(797): Wikimedia\Rdbms\DBConnRef->sourceFile() #8 /data/mediawiki/software/mediawiki-1.43.3/includes/installer/DatabaseUpdater.php(946): MediaWiki\Installer\DatabaseUpdater->applyPatch() #9 /data/mediawiki/software/mediawiki-1.43.3/includes/installer/DatabaseUpdater.php(595): MediaWiki\Installer\DatabaseUpdater->dropIndex() #10 /data/mediawiki/software/mediawiki-1.43.3/includes/installer/DatabaseUpdater.php(548): MediaWiki\Installer\DatabaseUpdater->runUpdates() #11 /data/mediawiki/software/mediawiki-1.43.3/maintenance/update.php(195): MediaWiki\Installer\DatabaseUpdater->doUpdates() #12 /data/mediawiki/software/mediawiki-1.43.3/maintenance/includes/MaintenanceRunner.php(703): UpdateMediaWiki->execute() #13 /data/mediawiki/software/mediawiki-1.43.3/maintenance/run.php(51): MediaWiki\Maintenance\MaintenanceRunner->run() #14 {main}

Rerunning the script "succeeds", i.e. finishes without an error, but the site is not working any more (internal error 500). And yes, I did notice the change from "php maintenance/update.php" to "php maintenance/run.php update" :)

Installing a new wiki with version 1.43.3 works in the same environment without problems.

I am using PostgreSQL as database backend.

Cheers, Joern