Maniphest T206353

Database error while renaming a file in Wikimedia Commons: "Replication wait failed: MySQL server has gone away"
Closed, ResolvedPublicPRODUCTION ERROR
Actions

Assigned To

None

Authored By

	Ankry
	Oct 5 2018, 6:38 PM

Description

While renaming a 100+ page .djvu files I received the following errors:

Wystąpił błąd podczas wykonywania zapytania do bazy danych. Może to wskazywać na błąd w oprogramowaniu.
[W7dvpgrAADsAAExNO0QAAACG] 2018-10-05 14:06:41: Krytyczny wyjątek typu "Wikimedia\Rdbms\DBExpectedError"

(while moving File:PL Karol May - Grobowiec Rodrigandów.djvu -> File:Karol May - Grobowiec Rodrigandów.djvu)

Wystąpił błąd podczas wykonywania zapytania do bazy danych. Może to wskazywać na błąd w oprogramowaniu.
[W7eQGgrAIFAAALDOcM8AAAAD] 2018-10-05 16:25:06: Krytyczny wyjątek typu "Wikimedia\Rdbms\DBExpectedError"

(while moving File:PL Karol May - Benito Juarez.djvu -> File:Karol May - Benito Juarez.djvu)

The circumstances were the same in both cases: the move took a lot of time and after about a minute since it has been initiated, I checked in another tab whether the move has completed already. The check result was: there was already a redirect under the source name and a message that the file does not exist under the target name. A while after the check, the error message appeared in the file move window.

I did not observe a problem with the moved file after receiving the error. So reporting here just for tracking.

It seems to me that the errors are related to the access attempt to a file while its move is in progress.

Event Timeline

Ankry created this task.Oct 5 2018, 6:38 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 5 2018, 6:38 PM

exception.file	       	/srv/mediawiki/php-1.32.0-wmf.24/includes/libs/rdbms/database/DatabaseMysqlBase.php:947
exception.message	       	Replication wait failed: MySQL server has gone away (10.192.32.130)
exception.trace
#0 /srv/mediawiki/php-1.32.0-wmf.24/includes/libs/rdbms/loadbalancer/LoadBalancer.php(662): Wikimedia\Rdbms\DatabaseMysqlBase->masterPosWait(Wikimedia\Rdbms\MySQLMasterPos, integer)
#1 /srv/mediawiki/php-1.32.0-wmf.24/includes/libs/rdbms/loadbalancer/LoadBalancer.php(557): Wikimedia\Rdbms\LoadBalancer->doWait(integer, boolean, integer)
#2 /srv/mediawiki/php-1.32.0-wmf.24/includes/libs/rdbms/lbfactory/LBFactory.php(429): Wikimedia\Rdbms\LoadBalancer->waitForAll(Wikimedia\Rdbms\MySQLMasterPos, integer)
#3 /srv/mediawiki/php-1.32.0-wmf.24/includes/libs/rdbms/lbfactory/LBFactory.php(475): Wikimedia\Rdbms\LBFactory->waitForReplication(array)
#4 /srv/mediawiki/php-1.32.0-wmf.24/includes/jobqueue/utils/PurgeJobUtils.php(78): Wikimedia\Rdbms\LBFactory->commitAndWaitForReplication(string, integer)
#5 /srv/mediawiki/php-1.32.0-wmf.24/includes/deferred/AutoCommitUpdate.php(42): Closure$PurgeJobUtils::invalidatePages(Wikimedia\Rdbms\DatabaseMysqli, string)
#6 /srv/mediawiki/php-1.32.0-wmf.24/includes/deferred/DeferredUpdates.php(268): AutoCommitUpdate->doUpdate()
#7 /srv/mediawiki/php-1.32.0-wmf.24/includes/deferred/DeferredUpdates.php(226): DeferredUpdates::runUpdate(AutoCommitUpdate, Wikimedia\Rdbms\LBFactoryMulti, string, integer)
#8 /srv/mediawiki/php-1.32.0-wmf.24/includes/deferred/DeferredUpdates.php(134): DeferredUpdates::execute(array, string, integer)
#9 /srv/mediawiki/php-1.32.0-wmf.24/includes/MediaWiki.php(914): DeferredUpdates::doUpdates(string)
#10 /srv/mediawiki/php-1.32.0-wmf.24/includes/MediaWiki.php(734): MediaWiki->restInPeace(string, boolean)
#11 [internal function]: Closure$MediaWiki::doPostOutputShutdown()
#12 {main}
exception_id	       	W7dvpgrAADsAAExNO0QAAACG
exception_url	       	/w/index.php?title=Special:MovePage&action=submit

Ankry renamed this task from Database error wile renaming a file in Wikimedia Commons: "Replication wait failed: MySQL server has gone away" to Database error while renaming a file in Wikimedia Commons: "Replication wait failed: MySQL server has gone away".Oct 5 2018, 6:58 PM

Not a new issue. According to @aaron likely related due to the size of the file being moved in Swift. I think there's a couple of related reports with different side-effects/error messages from the same underlying issue.

Krinkle edited projects, added MediaWiki-File-management; removed MediaWiki-libs-Rdbms.Oct 9 2018, 7:56 PM

Restricted Application added projects: Commons, Multimedia. · View Herald TranscriptOct 9 2018, 7:56 PM

• Ramsey-WMF moved this task from Untriaged to Tracking on the Multimedia board.Oct 17 2018, 5:09 PM

• mmodell changed the subtype of this task from "Task" to "Production Error".Aug 28 2019, 11:08 PM

Would say this is fixed with https://gerrit.wikimedia.org/r/c/mediawiki/core/+/740381, which improves file moves

Umherirrender closed this task as Resolved.Feb 10 2023, 7:46 PM

Database error while renaming a file in Wikimedia Commons: "Replication wait failed: MySQL server has gone away"Closed, ResolvedPublicPRODUCTION ERRORActions

Description

Event Timeline

Database error while renaming a file in Wikimedia Commons: "Replication wait failed: MySQL server has gone away"
Closed, ResolvedPublicPRODUCTION ERROR
Actions