Page MenuHomePhabricator

Fatal DB error when moving pages: Duplicate entry for key 'name_title'
Open, Needs TriagePublicPRODUCTION ERROR

Description

I've tried to move Test page A to test page B as Martin Urbanec (test) (non-sysop user), and it gave me the following error, while the move itself succeeeded.

[XShuUApAICkAAK0HVhMAAAAN] /w/index.php?title=Special:MovePage&action=submit Wikimedia\Rdbms\DBQueryError from line 1589 of /srv/mediawiki/php-1.34.0-wmf.13/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: UPDATE `page` SET page_namespace = '0',page_title = 'Test_page_B' WHERE page_id = '105431'
Function: MovePage::moveToInternal
Error: 1062 Duplicate entry '0-Test_page_B' for key 'name_title' (10.64.0.205)
Backtrace:

#0 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/database/Database.php(1557): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/database/Database.php(1146): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /srv/mediawiki/php-1.34.0-wmf.13/includes/libs/rdbms/database/Database.php(2164): Wikimedia\Rdbms\Database->query(string, string)
#3 /srv/mediawiki/php-1.34.0-wmf.13/includes/MovePage.php(756): Wikimedia\Rdbms\Database->update(string, array, array, string)
#4 /srv/mediawiki/php-1.34.0-wmf.13/includes/MovePage.php(452): MovePage->moveToInternal(User, Title, string, boolean, array)
#5 /srv/mediawiki/php-1.34.0-wmf.13/includes/MovePage.php(294): MovePage->moveUnsafe(User, string, boolean, array)
#6 /srv/mediawiki/php-1.34.0-wmf.13/includes/specials/SpecialMovepage.php(610): MovePage->moveIfAllowed(User, string, boolean)
#7 /srv/mediawiki/php-1.34.0-wmf.13/includes/specials/SpecialMovepage.php(130): MovePageForm->doSubmit()
#8 /srv/mediawiki/php-1.34.0-wmf.13/extensions/Translate/tag/SpecialPageTranslationMovePage.php(114): MovePageForm->execute(NULL)
#9 /srv/mediawiki/php-1.34.0-wmf.13/includes/specialpage/SpecialPage.php(571): SpecialPageTranslationMovePage->execute(NULL)
#10 /srv/mediawiki/php-1.34.0-wmf.13/includes/specialpage/SpecialPageFactory.php(581): SpecialPage->run(NULL)
#11 /srv/mediawiki/php-1.34.0-wmf.13/includes/MediaWiki.php(288): MediaWiki\Special\SpecialPageFactory->executePath(Title, RequestContext)
#12 /srv/mediawiki/php-1.34.0-wmf.13/includes/MediaWiki.php(884): MediaWiki->performRequest()
#13 /srv/mediawiki/php-1.34.0-wmf.13/includes/MediaWiki.php(515): MediaWiki->main()
#14 /srv/mediawiki/php-1.34.0-wmf.13/index.php(42): MediaWiki->run()
#15 /srv/mediawiki/w/index.php(3): require(string)
#16 {main}

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 12 2019, 11:30 AM
Restricted Application added a project: Discovery-Search. · View Herald TranscriptJul 12 2019, 11:30 AM
Aklapper renamed this task from Moving page caused fatal to Fatal DB error when moving pages: Duplicate entry for key 'name_title'.Jul 20 2019, 12:29 PM
mmodell changed the subtype of this task from "Task" to "Production Error".Aug 28 2019, 11:05 PM