Hello!

I just tried to upgrade some wikis from 1.31.6 and 1.34.1 to 1.35.0. The process fails with

...recentchanges table does not contain rc_user_text field. ...logging table does not contain log_user field. ...logging table does not contain log_user_text field. Adding index redirect_pkey to table redirect ...Wikimedia\Rdbms\DBQueryError from line 1699 of /data/mediawiki/software/mediaw iki-1.35.0/includes/libs/rdbms/database/Database.php: Error 23505: ERROR: could not create unique index "redirect_pkey" DETAIL: Key (rd_from)=(2527) is duplicated.

Function: Wikimedia\Rdbms\Database::sourceFile( /data/mediawiki/software/mediawiki-1.35.0/maintenance/postgres/archives/patch- redirect-pk.sql ) Query: ALTER TABLE redirect ADD PRIMARY KEY (rd_from)

and the table "redirect" indeed contains duplicate and triplicate entries for a lot of my wikis.

IMHO either the update script should collapse these entries, or the requirement for an index should be dropped from the installer. Does anyone have a quick SQL snippet to fix these tables?

Joern