Page MenuHomePhabricator

Wikimedia\Rdbms\DBTransactionSizeError: Transaction spent {time}s in writes, exceeding the 3s limit
Closed, DuplicatePublicPRODUCTION ERROR

Description

Error
normalized_message
[{reqId}] {exception_url}   Wikimedia\Rdbms\DBTransactionSizeError: Transaction spent {time}s in writes, exceeding the 3s limit
exception.trace
from /srv/mediawiki/php-1.39.0-wmf.22/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1706)
#0 /srv/mediawiki/php-1.39.0-wmf.22/includes/libs/rdbms/lbfactory/LBFactory.php(324): Wikimedia\Rdbms\LoadBalancer->approvePrimaryChanges(array, string)
#1 /srv/mediawiki/php-1.39.0-wmf.22/includes/MediaWiki.php(677): Wikimedia\Rdbms\LBFactory->commitPrimaryChanges(string, array)
#2 /srv/mediawiki/php-1.39.0-wmf.22/includes/api/ApiMain.php(901): MediaWiki::preOutputCommit(DerivativeContext)
#3 /srv/mediawiki/php-1.39.0-wmf.22/includes/api/ApiMain.php(846): ApiMain->executeActionWithErrorHandling()
#4 /srv/mediawiki/php-1.39.0-wmf.22/api.php(90): ApiMain->execute()
#5 /srv/mediawiki/php-1.39.0-wmf.22/api.php(45): wfApiMain()
#6 /srv/mediawiki/w/api.php(3): require(string)
#7 {main}
Notes
  • Seems to happen at a steady rate—less than 15/day
  • Happens on Commons—all via API or special upload

Details

Request URL
https://commons.wikimedia.org/w/api.php