https://bugzilla.wikimedia.org/show_bug.cgi?id=27285
Summary: category_title index for Pg is wrong?
Product: MediaWiki
Version: 1.18-svn
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Normal
Component: Database
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: m...@everybody.org
Found "duplicate key value violates unique constraint "category_title"" in my
logs while doing importDump and seeing that it is defined in tables.sql as
CREATE UNIQUE INDEX category_title ON category(cat_title);
I thought there might be something wrong with the dump, but grepping for the
title ("Articles_with_example_pseudocode") only found the following in my logs:
LOG: statement: INSERT /* LinksUpdate::incrTableUpdate 127.0.0.1 */ INTO
categorylinks
(cl_from,cl_to,cl_sortkey,cl_timestamp,cl_sortkey_prefix,cl_collation,cl_type)
VALUES ('439','Articles_with_example_pseudocode','ALGORITHMS FOR CALCULATING
VARIANCE
LOG: statement: SELECT /* LinksUpdate::invalidatePages 127.0.0.1 */ page_id
FROM page WHERE page_namespace = '14' AND (page_title IN
('Statistical_algorithms','Statistical_deviation_and_dispersion','Articles_with_example_pseudocode'))
AND (page_touched < '2011-02-09 18:07:14 GMT')
LOG: statement: INSERT /* Article::updateCategoryCounts 127.0.0.1 */ INTO
category (cat_id,cat_title) VALUES ('1586','Articles_with_example_pseudocode')
STATEMENT: INSERT /* Article::updateCategoryCounts 127.0.0.1 */ INTO category
(cat_id,cat_title) VALUES ('1586','Articles_with_example_pseudocode')
LOG: statement: UPDATE /* Article::updateCategoryCounts 127.0.0.1 */ category
SET cat_pages = cat_pages + 1 WHERE cat_title IN
('Statistical_algorithms','Statistical_deviation_and_dispersion','Articles_with_example_pseudocode')
(The error occured on the "category" INSERT statement)
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
