Page MenuHomePhabricator

namespaceDupes.php can fail if new target does not have a linktarget entry
Closed, ResolvedPublic

Description

Wikimedia\Rdbms\DBQueryError from line 1300 of /srv/mediawiki/php-1.41.0-wmf.17/includes/libs/rdbms/database/Database.php: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1=0 WHERE tl_from = '552170' AND tl_target_id = 78258' at line 1
	Function: NamespaceDupes::checkLinkTable
	Query: UPDATE IGNORE `templatelinks` SET 1=0 WHERE tl_from = '552170' AND tl_target_id = 78258
	
	#0 /srv/mediawiki/php-1.41.0-wmf.17/includes/libs/rdbms/database/Database.php(1284): Wikimedia\Rdbms\Database->getQueryException('You have an err...', 1064, 'UPDATE IGNORE `...', 'NamespaceDupes:...')
	#1 /srv/mediawiki/php-1.41.0-wmf.17/includes/libs/rdbms/database/Database.php(1258): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('You have an err...', 1064, 'UPDATE IGNORE `...', 'NamespaceDupes:...')
	#2 /srv/mediawiki/php-1.41.0-wmf.17/includes/libs/rdbms/database/Database.php(743): Wikimedia\Rdbms\Database->reportQueryError('You have an err...', 1064, 'UPDATE IGNORE `...', 'NamespaceDupes:...', false)
	#3 /srv/mediawiki/php-1.41.0-wmf.17/includes/libs/rdbms/database/Database.php(1572): Wikimedia\Rdbms\Database->query(Object(Wikimedia\Rdbms\Query), 'NamespaceDupes:...')
	#4 /srv/mediawiki/php-1.41.0-wmf.17/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->update('templatelinks', Array, Array, 'NamespaceDupes:...', Array)
	#5 /srv/mediawiki/php-1.41.0-wmf.17/includes/libs/rdbms/database/DBConnRef.php(403): Wikimedia\Rdbms\DBConnRef->__call('update', Array)
	#6 /srv/mediawiki/php-1.41.0-wmf.17/maintenance/namespaceDupes.php(467): Wikimedia\Rdbms\DBConnRef->update('templatelinks', Array, Array, 'NamespaceDupes:...', Array)
	#7 /srv/mediawiki/php-1.41.0-wmf.17/maintenance/namespaceDupes.php(226): NamespaceDupes->checkLinkTable('templatelinks', 'tl', 100, 'Appendix', Array)
	#8 /srv/mediawiki/php-1.41.0-wmf.17/maintenance/namespaceDupes.php(117): NamespaceDupes->checkAll(Array)
	#9 /srv/mediawiki/php-1.41.0-wmf.17/maintenance/includes/MaintenanceRunner.php(681): NamespaceDupes->execute()
	#10 /srv/mediawiki/php-1.41.0-wmf.17/maintenance/run.php(51): MediaWiki\Maintenance\MaintenanceRunner->run()
	#11 /srv/mediawiki/multiversion/MWScript.php(159): require_once('/srv/mediawiki/...')
	#12 {main}

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Previously seen in T328634#8581729 and T334277#8775922; purging affected pages seems to be a viable workaround.

Change 992474 had a related patch set uploaded (by Umherirrender; author: Umherirrender):

[mediawiki/core@master] maintenance: Acquire new linktarget in namespaceDupes.php

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

Change 992474 merged by jenkins-bot:

[mediawiki/core@master] maintenance: Acquire new linktarget in namespaceDupes.php

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

Umherirrender claimed this task.