Page MenuHomePhabricator
Create Task
Maniphest T157679

Exception thrown with an uncommited database transaction: MWCallableUpdate::doUpdate: Flush failed on server(s)
Closed, ResolvedPublic
Actions

Description

2017-02-09 13:14:20 translatewiki.net translatewiki_net-bw_: Exception thrown with an uncommited database transaction: [e825b3b1f84ed390adc0c586] /wiki/Special:ImportTranslations DBExpectedError from line 1136 of /srv/mediawiki/tags/2017-02-09_08:44:01/includes/libs/rdbms/loadbalancer/LoadBalancer.php: MWCallableUpdate::doUpdate: Flush failed on server(s) 127.0.0.1:3306:

Probably triggered by users importing new translations since T151585 was fixed. We don't know of any loss of data (i.e. any translations which failed to be imported from the PO file).

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Use AutoCommitUpdate instead of Database->onTransactionIdlemediawiki/coreREL1_29+17 -15
Use AutoCommitUpdate instead of Database->onTransactionIdlemediawiki/coreREL1_28+17 -15
Use AutoCommitUpdate instead of Database->onTransactionIdlemediawiki/coremaster+17 -15
Customize query in gerrit

Related Objects

Event Timeline

Nemo_bis created this task.Feb 9 2017, 1:18 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 9 2017, 1:18 PM
Nemo_bis added a parent task: T41480: [DO NOT USE] Issues affecting translatewiki.net [superseded by #affects-translatewiki.net].Feb 9 2017, 1:19 PM
mwjames subscribed.Feb 9 2017, 2:05 PM

Maybe those are related T154438 and T154425 (was reported a month ago) but without any comment or activity on them, it is unclear whether they share a common root cause or not.

Krinkle moved this task from Untriaged to Usage problem on the MediaWiki-libs-Rdbms board.May 8 2017, 1:06 AM
Seb35 mentioned this in T165714: BagOStuff::trackDuplicateKeys causes a "MWCallableUpdate::doUpdate: transaction round ..." during JobRunner::executeJob.May 29 2017, 11:25 PM
Seb35 mentioned this in T154425: Delete action throws a DBUnexpectedError with "MWCallableUpdate::doUpdate: Cannot flush snapshot because writes are pending (JobQueueDB::doBatchPush)".May 30 2017, 8:23 AM
Seb35 subscribed.May 30 2017, 8:27 AM
gerritbot subscribed.Jun 1 2017, 3:50 PM

Change 356619 had a related patch set uploaded (by Seb35; owner: Seb35):
[mediawiki/core@master] Use AtomicSectionUpdate instead of Database->onTransactionIdle

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

gerritbot added a project: Patch-For-Review.Jun 1 2017, 3:50 PM
Seb35 claimed this task.Jun 1 2017, 4:39 PM
Seb35 mentioned this in T100085: PHP Notice: JobQueueGroup::__destruct: 1 buffered job(s) never inserted.Jun 3 2017, 10:50 AM
Seb35 mentioned this in T154438: Special:MovePage throws MWCallableUpdate::doUpdate: Cannot flush snapshot because writes are pending (JobQueueDB::doBatchPush, JobQueueDB::doBatchPush).
gerritbot added a comment.Jun 7 2017, 3:20 AM

Change 356619 merged by jenkins-bot:
[mediawiki/core@master] Use AutoCommitUpdate instead of Database->onTransactionIdle

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

ReleaseTaggerBot added a project: MW-1.30-release-notes.Jun 7 2017, 4:00 AM
gerritbot added a comment.Jun 7 2017, 7:44 AM

Change 357560 had a related patch set uploaded (by Seb35; owner: Seb35):
[mediawiki/core@REL1_29] Use AutoCommitUpdate instead of Database->onTransactionIdle

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

gerritbot added a comment.Jun 7 2017, 7:45 AM

Change 357561 had a related patch set uploaded (by Seb35; owner: Seb35):
[mediawiki/core@REL1_28] Use AutoCommitUpdate instead of Database->onTransactionIdle

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

gerritbot added a comment.Jun 8 2017, 6:24 PM

Change 357561 merged by jenkins-bot:
[mediawiki/core@REL1_28] Use AutoCommitUpdate instead of Database->onTransactionIdle

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

gerritbot added a comment.Jun 8 2017, 6:25 PM

Change 357560 merged by jenkins-bot:
[mediawiki/core@REL1_29] Use AutoCommitUpdate instead of Database->onTransactionIdle

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

ReleaseTaggerBot added projects: MW-1.28-release-notes, MW-1.29-release-notes.Jun 8 2017, 7:00 PM
Seb35 closed this task as Resolved.Jun 9 2017, 7:34 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.

• Phabricator_maintenance added a project: affects-translatewiki.net.Sep 26 2019, 1:53 PM
• Phabricator_maintenance removed a parent task: T41480: [DO NOT USE] Issues affecting translatewiki.net [superseded by #affects-translatewiki.net].Sep 26 2019, 1:55 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits