error upgrading from 1.39.13 to 1.43.3

Clausen, Jörn <[email protected]> Tue, 8 Jul 2025 11:24:26 +0200
Newsgroups gmane.org.wikimedia.mediawiki
Message-ID <[email protected]>
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

-- 
Jörn Clausen
Plattformen & Serverdienste
BITS - Bielefelder IT-Servicezentrum
https://www.uni-bielefeld.de/bits

_______________________________________________
MediaWiki-l mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/