DBUnexpectedError from line 2877 of Database.php: MWCallableUpdate::doUpdate: Cannot flush snapshot because writes are pending (JobQueueDB::doBatchPush).
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Kghbln
	Jun 2 2017, 9:17 AM

Description

Setup

MediaWiki 1.29.0-rc.0 (c749bf6) 14:52, 25 May 2017
PHP 5.6.30-0+deb8u1 (apache2handler)
MariaDB 10.0.31-MariaDB-1~jessie

Issue
2017-06-01 20:31:06 phalaris 0210020150926-02100_: [738bba996c4371210be0b65d] /w/index.php?title=Sp%x%A9cial:Cr%x%A9er_un_compte&returnto=Cat%x%A9gorie:Cities Wikimedia\Rdbms\DBUnexpectedError from line 2877 of /../w/includes/libs/rdbms/database/Database.php: MWCallableUpdate::doUpdate: Cannot flush snapshot because writes are pending (JobQueueDB::doBatchPush).

Backtrace

#0 /../w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1192): Wikimedia\Rdbms\Database->flushSnapshot(string)
#1 [internal function]: Wikimedia\Rdbms\LoadBalancer->Wikimedia\Rdbms\{closure}(Wikimedia\Rdbms\DatabaseMysqli)
#2 /../w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1490): call_user_func_array(Closure, array)
#3 /../w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1200): Wikimedia\Rdbms\LoadBalancer->forEachOpenMasterConnection(Closure)
#4 [internal function]: Wikimedia\Rdbms\LoadBalancer->beginMasterChanges(string)
#5 /../w/includes/libs/rdbms/lbfactory/LBFactory.php(183): call_user_func_array(array, array)
#6 [internal function]: Wikimedia\Rdbms\LBFactory->Wikimedia\Rdbms\{closure}(Wikimedia\Rdbms\LoadBalancer, string, array)
#7 /../w/includes/libs/rdbms/lbfactory/LBFactorySimple.php(149): call_user_func_array(Closure, array)
#8 /../w/includes/libs/rdbms/lbfactory/LBFactory.php(186): Wikimedia\Rdbms\LBFactorySimple->forEachLB(Closure, array)
#9 /../w/includes/libs/rdbms/lbfactory/LBFactory.php(207): Wikimedia\Rdbms\LBFactory->forEachLBCallMethod(string, array)
#10 /../w/includes/deferred/DeferredUpdates.php(265): Wikimedia\Rdbms\LBFactory->beginMasterChanges(string)
#11 /../w/includes/deferred/DeferredUpdates.php(228): DeferredUpdates::runUpdate(MWCallableUpdate, Wikimedia\Rdbms\LBFactorySimple, integer)
#12 /../w/includes/deferred/DeferredUpdates.php(136): DeferredUpdates::execute(array, string, integer)
#13 /../w/includes/MediaWiki.php(902): DeferredUpdates::doUpdates(string)
#14 /../w/includes/MediaWiki.php(731): MediaWiki->restInPeace(string)
#15 /../w/includes/MediaWiki.php(750): MediaWiki->{closure}()
#16 /../w/includes/MediaWiki.php(554): MediaWiki->doPostOutputShutdown(string)
#17 /../w/index.php(43): MediaWiki->run()
#18 {main}

Related Objects

Mentioned In: T154438: Special:MovePage throws MWCallableUpdate::doUpdate: Cannot flush snapshot because writes are pending (JobQueueDB::doBatchPush, JobQueueDB::doBatchPush)
T100085: PHP Notice: JobQueueGroup::__destruct: 1 buffered job(s) never inserted
T165714: BagOStuff::trackDuplicateKeys causes a "MWCallableUpdate::doUpdate: transaction round ..." during JobRunner::executeJob
T154425: Delete action throws a DBUnexpectedError with "MWCallableUpdate::doUpdate: Cannot flush snapshot because writes are pending (JobQueueDB::doBatchPush)"
Mentioned Here: T154425: Delete action throws a DBUnexpectedError with "MWCallableUpdate::doUpdate: Cannot flush snapshot because writes are pending (JobQueueDB::doBatchPush)"
rMWc749bf6b05e5: rdbms: Add compat alias for renamed LBFactory class

Event Timeline

Kghbln created this task.Jun 2 2017, 9:17 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 2 2017, 9:17 AM

Probably related to T154425

Kghbln added a project: MediaWiki-libs-Rdbms.Jun 2 2017, 9:22 AM

Yes, it’s probably the same as T154425. I cannot be absolutely sure since it is a different action (not delete, restore, or move), so it will be better to check once T154425 will be fixed, but there is a high probability it will be fixed also.

In T166867#3310511, @Seb35 wrote:

Yes, it’s probably the same as T154425. I cannot be absolutely sure since it is a different action (not delete, restore, or move), so it will be better to check once T154425 will be fixed, but there is a high probability it will be fixed also.

Yeah, that's why I created a new task. Keeping fingers crossed.

Seb35 mentioned this in T154425: Delete action throws a DBUnexpectedError with "MWCallableUpdate::doUpdate: Cannot flush snapshot because writes are pending (JobQueueDB::doBatchPush)".Jun 3 2017, 10:49 AM

Seb35 mentioned this in T165714: BagOStuff::trackDuplicateKeys causes a "MWCallableUpdate::doUpdate: transaction round ..." during JobRunner::executeJob.

Seb35 mentioned this in T100085: PHP Notice: JobQueueGroup::__destruct: 1 buffered job(s) never inserted.

Seb35 mentioned this in T154438: Special:MovePage throws MWCallableUpdate::doUpdate: Cannot flush snapshot because writes are pending (JobQueueDB::doBatchPush, JobQueueDB::doBatchPush).

Reception123 subscribed.Jun 9 2017, 5:45 AM

Closed this task given it is almost a duplicate for T154425, it is solved by https://gerrit.wikimedia.org/r/#/c/356619/ (fixed in 1.28, 1.29, 1.30). An issue remains as of now, see T154425 for details.

@Seb35 Thanks a lot!

An issue remains as of now, see T154425 for details.

Keeping fingers crossed!

Krinkle added a project: MW-1.29-release-notes.Jul 8 2017, 4:52 AM

DBUnexpectedError from line 2877 of Database.php: MWCallableUpdate::doUpdate: Cannot flush snapshot because writes are pending (JobQueueDB::doBatchPush).Closed, ResolvedPublicActions

Description

Related Objects

Event Timeline

DBUnexpectedError from line 2877 of Database.php: MWCallableUpdate::doUpdate: Cannot flush snapshot because writes are pending (JobQueueDB::doBatchPush).
Closed, ResolvedPublic
Actions