Page MenuHomePhabricator

Exception: Wikimedia\Rdbms\DBUnexpectedError when attempting to move within File: namespace
Closed, DuplicatePublic

Description

When attempting to move a File: page, the following exception is thrown:

[4df9e13d36749dcf1afb2176] /w/index.php?title=Special:MovePage&action=submit Wikimedia\Rdbms\DBUnexpectedError from line 2677 of /var/www/w/includes/libs/rdbms/database/Database.php: No atomic transaction is open (got LocalFile::lockingTransaction).

Backtrace:

#0 /var/www/w/includes/filerepo/file/LocalFile.php(2055): Wikimedia\Rdbms\Database->endAtomic(string)
#1 /var/www/w/includes/filerepo/file/LocalFile.php(2073): LocalFile->unlock()
#2 /var/www/w/includes/filerepo/file/LocalFile.php(2961): LocalFile->__destruct()
#3 /var/www/w/includes/filerepo/file/LocalFile.php(1692): LocalFileMoveBatch->execute()
#4 /var/www/w/includes/MovePage.php(252): LocalFile->move(Title)
#5 /var/www/w/includes/specials/SpecialMovepage.php(590): MovePage->move(User, string, boolean)
#6 /var/www/w/includes/specials/SpecialMovepage.php(128): MovePageForm->doSubmit()
#7 /var/www/w/includes/specialpage/SpecialPage.php(522): MovePageForm->execute(NULL)
#8 /var/www/w/includes/specialpage/SpecialPageFactory.php(578): SpecialPage->run(NULL)
#9 /var/www/w/includes/MediaWiki.php(287): SpecialPageFactory::executePath(Title, RequestContext)
#10 /var/www/w/includes/MediaWiki.php(862): MediaWiki->performRequest()
#11 /var/www/w/includes/MediaWiki.php(523): MediaWiki->main()
#12 /var/www/w/index.php(43): MediaWiki->run()
#13 {main}

This happens for every File: page. Normal pages can be renamed without issues.

Versions:
MediaWiki 1.29.0
PHP 7.1.7 (fpm-fcgi)
PostgreSQL 9.6.3
ICU 58.2

Disabling extensions does not resolve the problem.
This is after upgrading; on 1.28.2 the exception was Expected mass rollback of all peer databases (DBO_TRX set), like in T167927.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
dr0ptp4kt triaged this task as Medium priority.Jul 24 2017, 3:32 PM
dr0ptp4kt added projects: DBA, PostgreSQL.
dr0ptp4kt subscribed.

Updating tags, setting to Normal. At first glance it's unclear whether perhaps this has to do with Postgres DAL or something else.

Marostegui subscribed.

I am removing the DBA project, as I am not really sure what we, DBAs, are expected to do here. I will remain subscribed here, just in case our help is needed.

It most likely is a duplicate, my apologies — should have searched better prior to creating this one.