Page MenuHomePhabricator
Create Task
Maniphest T226898

Database error while moving over redirect: Transaction exceeding the limit of 3 seconds
Open, Needs TriagePublicPRODUCTION ERROR
Actions

Description

Second similar error today. This is also the first time I've seen this error.

To avoid creating high replication lag, this transaction was aborted because the write duration (3.068653345108) exceeded the 3 second limit. If you are changing many items at once, try doing multiple smaller operations instead.

[XReuagpAMFgAAILDXVcAAAAJ] 2019-06-29 18:31:14: Fatal exception of type "Wikimedia\Rdbms\DBTransactionSizeError"
exception.file          /srv/mediawiki/php-1.34.0-wmf.11/includes/libs/rdbms/loadbalancer/LoadBalancer.php:1462
exception.message       Transaction spent 3.068653345108 second(s) in writes, exceeding the limit of 3
exception.trace
#0 /srv/mediawiki/php-1.34.0-wmf.11/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1910): Closure$Wikimedia\Rdbms\LoadBalancer::approveMasterChanges(Wikimedia\Rdbms\DatabaseMysqli)
#1 /srv/mediawiki/php-1.34.0-wmf.11/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1472): Wikimedia\Rdbms\LoadBalancer->forEachOpenMasterConnection(Closure$Wikimedia\Rdbms\LoadBalancer::approveMasterChanges;482)
#2 /srv/mediawiki/php-1.34.0-wmf.11/includes/libs/rdbms/lbfactory/LBFactory.php(230): Wikimedia\Rdbms\LoadBalancer->approveMasterChanges(array, string, integer)
#3 /srv/mediawiki/php-1.34.0-wmf.11/includes/libs/rdbms/lbfactory/LBFactoryMulti.php(401): Closure$Wikimedia\Rdbms\LBFactory::forEachLBCallMethod(Wikimedia\Rdbms\LoadBalancer, string, array)
#4 /srv/mediawiki/php-1.34.0-wmf.11/includes/libs/rdbms/lbfactory/LBFactory.php(233): Wikimedia\Rdbms\LBFactoryMulti->forEachLB(Closure$Wikimedia\Rdbms\LBFactory::forEachLBCallMethod;195, array)
#5 /srv/mediawiki/php-1.34.0-wmf.11/includes/libs/rdbms/lbfactory/LBFactory.php(281): Wikimedia\Rdbms\LBFactory->forEachLBCallMethod(string, array)
#6 /srv/mediawiki/php-1.34.0-wmf.11/includes/MediaWiki.php(596): Wikimedia\Rdbms\LBFactory->commitMasterChanges(string, array)
#7 /srv/mediawiki/php-1.34.0-wmf.11/includes/MediaWiki.php(566): MediaWiki::preOutputCommit(RequestContext, Closure$MediaWiki::main;391)
#8 /srv/mediawiki/php-1.34.0-wmf.11/includes/MediaWiki.php(900): MediaWiki->doPreOutputCommit(Closure$MediaWiki::main;391)
#9 /srv/mediawiki/php-1.34.0-wmf.11/includes/MediaWiki.php(515): MediaWiki->main()
#10 /srv/mediawiki/php-1.34.0-wmf.11/index.php(42): MediaWiki->run()
#11 /srv/mediawiki/w/index.php(3): include(string)
#12 {main}

Details

Request ID
XReuagpAMFgAAILDXVcAAAAJ

Related Objects

Event Timeline

QEDK created this task.Jun 29 2019, 6:36 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 29 2019, 6:36 PM
Krinkle moved this task from Untriaged to Usage problem on the MediaWiki-libs-Rdbms board.Jul 11 2019, 2:48 PM
Krinkle edited projects, added MediaWiki-Special-pages; removed WMF-General-or-Unknown.
Krinkle moved this task from To triage to Special:MergeHistory on the MediaWiki-Special-pages board.
Aklapper renamed this task from Database error while moving over redirect to Database error while moving over redirect: Transaction exceeding the limit of 3 seconds.Jul 11 2019, 10:37 PM
Aklapper added a project: Wikimedia-production-error.
Aklapper updated the task description. (Show Details)
Krinkle moved this task from Untriaged to Jul2019/1.34.wmf.13+ on the Wikimedia-production-error board.Jul 16 2019, 2:54 PM
Krinkle moved this task from Jul2019/1.34.wmf.13+ to Jun 2019 / 1.34.wmf.8+ on the Wikimedia-production-error board.
Krinkle edited projects, added Wikimedia-database-issue; removed MediaWiki-libs-Rdbms.Jul 18 2019, 7:31 PM
DannyS712 subscribed.EditedJul 18 2019, 7:32 PM

I've had a number of failed moves in the last few weeks - should they be reported each time?

Krinkle moved this task from Untriaged to Bad data & Corruption on the Wikimedia-database-issue board.Jul 18 2019, 7:36 PM
Krinkle moved this task from Bad data & Corruption to Untriaged on the Wikimedia-database-issue board.
Krinkle mentioned this in Blog Post: Production Excellence #12: June 2019.Jul 31 2019, 6:44 PM
• mmodell changed the subtype of this task from "Task" to "Production Error".Aug 28 2019, 11:05 PM
Krinkle edited projects, added MediaWiki-Page-rename; removed MediaWiki-Special-pages.Apr 8 2020, 4:11 PM
RhinosF1 mentioned this in T250551: Fatal exception of type "Wikimedia\Rdbms\DBTransactionSizeError".Apr 18 2020, 9:14 AM
RhinosF1 set Request ID to XReuagpAMFgAAILDXVcAAAAJ.Apr 18 2020, 9:18 AM
RhinosF1 edited Stack Trace. (Show Details)
RhinosF1 subscribed.
Ammarpad merged a task: T237323: DBTransactionSizeError when moving a page on enwiki: exceeding the limit of 3 seconds.Apr 18 2020, 1:45 PM
brennen added a project: User-brennen.Apr 29 2020, 3:40 PM
brennen subscribed.

Seeing a handful of these in 1.35.0-wmf.30:

brennen@mwlog1001:/srv/mw-log$ grep -ic 'DBTransactionSize' ./exception.log'
66
brennen moved this task from Backlog to Logs/Train on the User-brennen board.Apr 29 2020, 3:40 PM
Krinkle edited Stack Trace. (Show Details)Jun 23 2020, 6:43 PM
Krinkle moved this task from Jun 2019 / 1.34.wmf.8+ to Older on the Wikimedia-production-error board.
Krinkle edited projects, added Wikimedia-Slow-DB-Query; removed Wikimedia-database-issue.Apr 9 2022, 8:47 PM
Krinkle subscribed.

DBTransactionSizeError is a type of error, much like "class not found", "HTTP 404" or "out of memory". This task specifically is about transaction errors from Special:MovePage as result of (presumed) slow insertion of redirects.

Logstash query for mediawiki-warnings:
message:DBTransactionSizeError AND url:*MovePage*

This yields 2 in the last 30 days.

Other outstanding production errors that are from MovePage and may be related to timeouts and lock contention:

TheresNoTime removed a subscriber: RhinosF1.Dec 15 2022, 11:36 PM
brennen unsubscribed.Sep 11 2023, 7:23 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