ShortUrlUtils::encodeTitle() tries to insert row with duplicate value for 'shorturls_ns_title'
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	ori
	Jul 24 2015, 5:09 PM

Description

Function: ShortUrlUtils::encodeTitle
Error: 1062 Duplicate entry '0-\xE0\xAE\x95\xE0\xAE\xBE\xE0\xAE\x9E\xE0\xAF\x8D\xE0\xAE\x9A\x' for key 'shorturls_ns_title' (10.64.16.27)
{"exception":"[object] (DBQueryError(code: 0): A database error has occurred. Did you forget to run maintenance/update.php after upgrading?  See: https:     //www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script\nQuery: INSERT  INTO `shorturls` (su_id,su_namespace,su_title) VALUES (NULL,'0','காஞ்சனா_(நடி     கை)')\nFunction: ShortUrlUtils::encodeTitle\nError: 1062 Duplicate entry '0-\\xE0\\xAE\\x95\\xE0\\xAE\\xBE\\xE0\\xAE\\x9E\\xE0\\xAF\\x8D\\xE0\\xAE\\x9A\\x     ' for key 'shorturls_ns_title' (10.64.16.27)
 at /srv/mediawiki/php-1.26wmf15/includes/db/Database.php:1131)"}
  88 2015-07-24 08:40:43 mw1180 wikidatawiki exception ERROR: [8c58b564] /wiki/Special:Log/Art-top   DBQueryError from line 1131 of /srv/mediawiki/php-1.26wmf     15/includes/db/Database.php: A database error has occurred. Did you forget to run maintenance/update.php after upgrading?  See: https://www.mediawiki.org     /wiki/Manual:Upgrading#Run_the_update_script

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	Avoid exceptions on encodeTitle() INSERT races	mediawiki/extensions/ShortUrl	master	+36 -14

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		LSobanski	T106854 Duplicate key errors (tracking)
		Resolved		aaron	T106849 ShortUrlUtils::encodeTitle() tries to insert row with duplicate value for 'shorturls_ns_title'