```
Query affected 1553 row(s):
query-m: REPLACE INTO `translate_groupstats` (tgs_group,tgs_lang,tgs_total,tgs_translated,tgs_fuzzy,tgs_proofread) VALUES ('X') [TRX#90add3]
#0 /srv/mediawiki/php-1.33.0-wmf.4/includes/libs/rdbms/database/Database.php(1296): Wikimedia\Rdbms\TransactionProfiler->recordQueryCompletion()
#1 /srv/mediawiki/php-1.33.0-wmf.4/includes/libs/rdbms/database/Database.php(1193): Wikimedia\Rdbms\Database->doProfiledQuery()
#2 /srv/mediawiki/php-1.33.0-wmf.4/includes/libs/rdbms/database/Database.php(2852): Wikimedia\Rdbms\Database->query()
#3 /srv/mediawiki/php-1.33.0-wmf.4/includes/libs/rdbms/database/DatabaseMysqlBase.php(498): Wikimedia\Rdbms\Database->nativeReplace()
#4 /srv/mediawiki/php-1.33.0-wmf.4/includes/libs/rdbms/database/DBConnRef.php(49): Wikimedia\Rdbms\DatabaseMysqlBase->replace()
#5 /srv/mediawiki/php-1.33.0-wmf.4/includes/libs/rdbms/database/DBConnRef.php(412): Wikimedia\Rdbms\DBConnRef->__call()
#6 /srv/mediawiki/php-1.33.0-wmf.4/extensions/Translate/utils/MessageGroupStats.php(537): Wikimedia\Rdbms\DBConnRef->replace()
#7 /srv/mediawiki/php-1.33.0-wmf.4/extensions/Translate/utils/MessageGroupStats.php(558): Closure$MessageGroupStats::queueUpdates()
#8 /srv/mediawiki/php-1.33.0-wmf.4/includes/deferred/MWCallableUpdate.php(34): Closure$MessageGroupStats::withLock()
#9 /srv/mediawiki/php-1.33.0-wmf.4/includes/deferred/DeferredUpdates.php(270): MWCallableUpdate->doUpdate()
#10 /srv/mediawiki/php-1.33.0-wmf.4/includes/deferred/DeferredUpdates.php(216): DeferredUpdates::runUpdate()
#11 /srv/mediawiki/php-1.33.0-wmf.4/includes/deferred/DeferredUpdates.php(140): DeferredUpdates::execute()
#12 /srv/mediawiki/php-1.33.0-wmf.4/includes/MediaWiki.php(905): DeferredUpdates::doUpdates()
#13 /srv/mediawiki/php-1.33.0-wmf.4/includes/MediaWiki.php(728): MediaWiki->restInPeace()
#14 (): Closure$MediaWiki::doPostOutputShutdown()
#15 {main}
```
== Impact
This is a production issue, which alerts about inefficient database updates which may cause lag and other operational issues.
== Status
Multiple improvements to the code has been done, which has brought the rate of these alerts down considerably. However, there are still unexplained cases, so debugging continues with further fixes expected. Progress is slow due to needing to wait for deployment, and some days after deployment to see what's the status after fixes, and then repeat with more investigation.
== Expected outcome
These alerts from this piece of code reach zero, or very close to zero with understood conditions when that happens.