search

SmartDataAnalytics / OpenResearch

Public issue system for OPENRESEARCH/ConfIDent
8 stars 3 forks source link

MediaWiki 1.35 upgrade fails #199

Closed WolfgangFahl closed 3 years ago

WolfgangFahl commented 3 years ago 
Wikimedia\Rdbms\DBQueryError from line 1699 of /var/www/mediawiki/mediawiki-1.35.1/includes/libs/rdbms/database/Database.php: Error 1062: Duplicate entry '' for key 'actor_name' (localhost)
Function: MigrateActors::addActorsForRows
Query: INSERT INTO `actor` (actor_name) VALUES ('')
WolfgangFahl commented 3 years ago

see my workaround proposal in https://phabricator.wikimedia.org/T229092 and https://phabricator.wikimedia.org/T224854

select count(*) from logging where log_user_text="";
+----------+
| count(*) |
+----------+
|      879 |
+----------+
1 row in set (0.001 sec)

delete from logging where log_user_text="";
grep cleanupUsersWithNoId Mediawiki135update.log | wc -l
     856
WolfgangFahl commented 3 years ago 
Error 1062: Duplicate entry '201270' for key 'ar_revid_uniq'
WolfgangFahl commented 3 years ago

4 attempts later we can close this - see documentation of these