[{reqId}] {exception_url}   Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry 'Flag_of_Aminoac.png' for key 'file_name'
Function: LocalFileMoveBatch::doDBUpdates
Query: UPDATE  `file` SET file_name = 'Flag_of_Aminoac.png' WHERE file_id = '69014'

Frame	Location	Call
from	/srv/mediawiki/php-1.44.0-wmf.21/includes/libs/rdbms/database/Database.php(1230)
#0	/srv/mediawiki/php-1.44.0-wmf.21/includes/libs/rdbms/database/Database.php(1214)	Wikimedia\Rdbms\Database->getQueryException(string, int, string, string)
#1	/srv/mediawiki/php-1.44.0-wmf.21/includes/libs/rdbms/database/Database.php(1188)	Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, int, string, string)
#2	/srv/mediawiki/php-1.44.0-wmf.21/includes/libs/rdbms/database/Database.php(647)	Wikimedia\Rdbms\Database->reportQueryError(string, int, string, string, bool)
#3	/srv/mediawiki/php-1.44.0-wmf.21/includes/libs/rdbms/database/Database.php(1516)	Wikimedia\Rdbms\Database->query(Wikimedia\Rdbms\Query, string)
#4	/srv/mediawiki/php-1.44.0-wmf.21/includes/libs/rdbms/database/DBConnRef.php(127)	Wikimedia\Rdbms\Database->update(string, array, array, string, array)
#5	/srv/mediawiki/php-1.44.0-wmf.21/includes/libs/rdbms/database/DBConnRef.php(413)	Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6	/srv/mediawiki/php-1.44.0-wmf.21/includes/libs/rdbms/querybuilder/UpdateQueryBuilder.php(333)	Wikimedia\Rdbms\DBConnRef->update(string, array, array, string, array)
#7	/srv/mediawiki/php-1.44.0-wmf.21/includes/filerepo/file/LocalFileMoveBatch.php(384)	Wikimedia\Rdbms\UpdateQueryBuilder->execute()
#8	/srv/mediawiki/php-1.44.0-wmf.21/includes/filerepo/file/LocalFileMoveBatch.php(296)	LocalFileMoveBatch->doDBUpdates()
#9	/srv/mediawiki/php-1.44.0-wmf.21/includes/filerepo/file/LocalFile.php(2376)	LocalFileMoveBatch->execute()
#10	/srv/mediawiki/php-1.44.0-wmf.21/includes/page/MovePage.php(788)	LocalFile->move(MediaWiki\Title\Title)
#11	/srv/mediawiki/php-1.44.0-wmf.21/includes/page/MovePage.php(732)	MediaWiki\Page\MovePage->moveFile(MediaWiki\Title\Title, MediaWiki\Title\Title)
#12	/srv/mediawiki/php-1.44.0-wmf.21/includes/page/MovePage.php(496)	MediaWiki\Page\MovePage->moveUnsafe(MediaWiki\User\User, string, bool, array)
#13	/srv/mediawiki/php-1.44.0-wmf.21/includes/specials/SpecialMovePage.php(786)	MediaWiki\Page\MovePage->moveIfAllowed(MediaWiki\User\User, string, bool)
#14	/srv/mediawiki/php-1.44.0-wmf.21/includes/specials/SpecialMovePage.php(225)	MediaWiki\Specials\SpecialMovePage->doSubmit()
#15	/srv/mediawiki/php-1.44.0-wmf.21/includes/specialpage/SpecialPage.php(729)	MediaWiki\Specials\SpecialMovePage->execute(null)
#16	/srv/mediawiki/php-1.44.0-wmf.21/includes/specialpage/SpecialPageFactory.php(1737)	MediaWiki\SpecialPage\SpecialPage->run(null)
#17	/srv/mediawiki/php-1.44.0-wmf.21/includes/actions/ActionEntryPoint.php(501)	MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, MediaWiki\Context\RequestContext)
#18	/srv/mediawiki/php-1.44.0-wmf.21/includes/actions/ActionEntryPoint.php(145)	MediaWiki\Actions\ActionEntryPoint->performRequest()
#19	/srv/mediawiki/php-1.44.0-wmf.21/includes/MediaWikiEntryPoint.php(202)	MediaWiki\Actions\ActionEntryPoint->execute()
#20	/srv/mediawiki/php-1.44.0-wmf.21/index.php(58)	MediaWiki\MediaWikiEntryPoint->run()
#21	/srv/mediawiki/w/index.php(3)	require(string)
#22	{main}

Impact

Notes

Details

Request URL: https://zh.wikipedia.org/w/index.php?action=submit&title=*

Related Changes in Gerrit:

	Subject	Author	Repo	Branch	Lines +/-
	filerepo: Delete the file table entry if move target exists but deleted	Ladsgroup	mediawiki/core	master	+22 -0

Customize query in gerrit

Related Objects

Mentioned In: T385167: Run data migration script for file migration
T28741: Migrate file tables to a modern layout (image/oldimage; file/filerevision; add primary keys)
T391206: Propose to add "stack trace requested" column to #wikimedia-production-error

Event Timeline

SD_hehua created this task.Mar 21 2025, 6:21 AM

Restricted Application added subscribers: Stang, • Aklapper. · View Herald TranscriptMar 21 2025, 6:21 AM

A_smart_kitten added projects: Wikimedia-production-error, MediaWiki-Page-rename.Mar 21 2025, 6:24 AM

A_smart_kitten subscribed.

Restricted Application changed the subtype of this task from "Bug Report" to "Production Error". · View Herald TranscriptMar 21 2025, 6:24 AM

SD_hehua updated the task description. (Show Details)Mar 21 2025, 6:25 AM

SD_hehua moved this task from Backlog to MediaWiki core on the Chinese-Sites board.Mar 21 2025, 9:11 AM

Reedy moved this task from Untriaged to Mar 2025 on the Wikimedia-production-error board.Mar 21 2025, 10:17 PM

Maybe related information: The target file name has been deleted in Commons.

Krinkle moved this task from Mar 2025 to Jan-Mar 2025 on the Wikimedia-production-error board.Apr 1 2025, 2:06 AM

Bugreporter mentioned this in T391206: Propose to add "stack trace requested" column to #wikimedia-production-error.Apr 6 2025, 7:41 PM

• Aklapper renamed this task from Wikimedia\Rdbms\DBQueryError when moving a file on zhwiki to Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry moving a file; Function: LocalFileMoveBatch::doDBUpdates.Apr 6 2025, 8:58 PM

• Aklapper set Request URL to https://zh.wikipedia.org/w/index.php?action=submit&title=*.

• Aklapper updated the task description. (Show Details)

• Aklapper added a project: MediaWiki-File-management.

Maintenance_bot added a project: Commons.Apr 6 2025, 9:30 PM

Bugreporter mentioned this in T28741: Migrate file tables to a modern layout (image/oldimage; file/filerevision; add primary keys).Apr 7 2025, 2:15 AM

Ladsgroup claimed this task.Apr 7 2025, 12:07 PM

Ciencia_Al_Poder subscribed.Apr 7 2025, 8:23 PM

Jdforrester-WMF added a project: Regression.Apr 8 2025, 8:58 PM

Jdforrester-WMF subscribed.Apr 8 2025, 9:03 PM

Change #1136468 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[mediawiki/core@master] filerepo: Delete the file table entry if move target exists but deleted

https://gerrit.wikimedia.org/r/1136468

gerritbot added a project: Patch-For-Review.Apr 14 2025, 11:16 PM

Change #1136468 merged by jenkins-bot:

[mediawiki/core@master] filerepo: Delete the file table entry if move target exists but deleted

https://gerrit.wikimedia.org/r/1136468

ReleaseTaggerBot added a project: MW-1.44-notes (1.44.0-wmf.27; 2025-04-29).Apr 15 2025, 12:00 PM

Maintenance_bot removed a project: Patch-For-Review.Apr 15 2025, 12:30 PM

It seems unresolved till now...? I still meet the error when I try to move it.

In T389586#10743423, @SD_hehua wrote:

It seems unresolved till now...? I still meet the error when I try to move it.

It still needs to be backported/deployed. It'll take a bit.

OK, thank you.

In T389586#10743441, @SD_hehua wrote:

OK, thank you.

Is it fixed now?

Let me try.

Yes.It is fixed now.

在T389586#10793913中，@Ladsgroup写道：

In T389586#10743441, @SD_hehua wrote:

OK, thank you.

Is it fixed now?

\o/

Ladsgroup moved this task from Triage to Done on the DBA board.May 6 2025, 9:05 AM

Stang moved this task from MediaWiki core to Closed on the Chinese-Sites board.May 6 2025, 9:31 AM

Stang unsubscribed.May 10 2025, 4:33 AM

Ladsgroup mentioned this in T385167: Run data migration script for file migration.Jun 18 2025, 9:05 PM

Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry moving a file; Function: LocalFileMoveBatch::doDBUpdatesClosed, ResolvedPublicPRODUCTION ERRORActions

Description

Error

Impact

Notes

Details

Related Objects

Event Timeline

Wikimedia\Rdbms\DBQueryError: Error 1062: Duplicate entry moving a file; Function: LocalFileMoveBatch::doDBUpdates
Closed, ResolvedPublicPRODUCTION ERROR
Actions