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

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 */ INTO
VALUES ('439','Articles_with_example_pseudocode','ALGORITHMS FOR CALCULATING
LOG:  statement: SELECT /* LinksUpdate::invalidatePages */  page_id 
FROM page  WHERE page_namespace = '14' AND (page_title IN
AND (page_touched < '2011-02-09 18:07:14 GMT')  
LOG:  statement: INSERT /* Article::updateCategoryCounts */ INTO
category (cat_id,cat_title) VALUES ('1586','Articles_with_example_pseudocode')
STATEMENT:  INSERT /* Article::updateCategoryCounts */ INTO category
(cat_id,cat_title) VALUES ('1586','Articles_with_example_pseudocode')
LOG:  statement: UPDATE /* Article::updateCategoryCounts */  category
SET cat_pages = cat_pages + 1 WHERE cat_title IN

(The error occured on the "category" INSERT statement)

Configure bugmail:
------- 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

Reply via email to