Topic on Project:Support desk

Tracked in Phabricator
Task T229092

Hi,

when running the upgrade script upgrade.php inside the maitenance folder the following error occurs:

Beginning migration of logging.log_user and logging.log_user_text to logging.log_actor

[d0923ea25688c2ffc826f976] [no req]   Wikimedia\Rdbms\DBQueryError from line 1587 of /var/customers/webs/mgfvlw/wiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: INSERT  INTO `actor` (actor_name) VALUES ('')

Function: MigrateActors::addActorsForRows

Error: 1062 Duplicate entry '' for key 'actor_name' (localhost)

Backtrace:

#0 /var/customers/webs/mgfvlw/wiki/includes/libs/rdbms/database/Database.php(1556): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#1 /var/customers/webs/mgfvlw/wiki/includes/libs/rdbms/database/Database.php(1274): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#2 /var/customers/webs/mgfvlw/wiki/includes/libs/rdbms/database/Database.php(2149): Wikimedia\Rdbms\Database->query(string, string)

#3 /var/customers/webs/mgfvlw/wiki/maintenance/includes/MigrateActors.php(226): Wikimedia\Rdbms\Database->insert(string, array, string)

#4 /var/customers/webs/mgfvlw/wiki/maintenance/includes/MigrateActors.php(306): MigrateActors->addActorsForRows(Wikimedia\Rdbms\DatabaseMysqli, string, array, array, integer)

#5 /var/customers/webs/mgfvlw/wiki/maintenance/includes/MigrateActors.php(122): MigrateActors->migrate(string, array, string, string, string)

#6 /var/customers/webs/mgfvlw/wiki/maintenance/Maintenance.php(1719): MigrateActors->doDBUpdates()

#7 /var/customers/webs/mgfvlw/wiki/includes/installer/DatabaseUpdater.php(1318): LoggedUpdateMaintenance->execute()

#8 /var/customers/webs/mgfvlw/wiki/includes/installer/DatabaseUpdater.php(489): DatabaseUpdater->migrateActors()

#9 /var/customers/webs/mgfvlw/wiki/includes/installer/DatabaseUpdater.php(453): DatabaseUpdater->runUpdates(array, boolean)

#10 /var/customers/webs/mgfvlw/wiki/maintenance/update.php(203): DatabaseUpdater->doUpdates(array)

#11 /var/customers/webs/mgfvlw/wiki/maintenance/doMaintenance.php(96): UpdateMediaWiki->execute()

#12 /var/customers/webs/mgfvlw/wiki/maintenance/update.php(266): require_once(string)

#13 {main}

The system is Debian 9 with PHP version 7.1.30 and MariaDB 10.1

I searched a lot of pages but nothing really fixed the issue.

Is there anyone who call help me?

Kind regards Michael

Wondering if running maintenance/migrateActors.php and/or maintenance/cleanupUsersWithNoId.php might help, as per

Hi,

maintenance/migrateActors.php hast the same result as above and maintenance/cleanupUsersWithNoId.php does not help either

KR Michael

Hi,

problem solved by deleting an "empty" entry in the actors table: Duplicate entry '' for key 'actor_name' (localhost)

Thanks

Michael

If you have more information about how that entry with a blank actor name did end up in your database, it would be good to bugreport that so the migration script takes that into account.