Project

General

Profile

Actions
Copy link

Defect #3368

closed

Cannot create project on postgresql

Added by Andrew Kouznetsov over 15 years ago. Updated over 15 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Projects
Target version:
-
Start date:
2009-05-16
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

Hello. I have just installed redmine. When i am trying create new project i see exception

RuntimeError: ERROR    C23505    Mduplicate key value violates unique constraint "projects_trackers_unique"    Fnbtinsert.c    L298    R_bt_check_unique: INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (11, 1)

sql log:
  SQL (0.8ms)   SELECT max("settings".updated_on) AS max_updated_on FROM "settings" 
  User Load (2.3ms)   SELECT * FROM "users" WHERE ("users"."id" = 1) AND (users.status = 1) 
  IssueCustomField Load (2.0ms)   SELECT * FROM "custom_fields" WHERE ( ("custom_fields"."type" = 'IssueCustomField' ) ) ORDER BY custom_fields.position
  Tracker Load (1.6ms)   SELECT * FROM "trackers" ORDER BY position                                                                                     
  Tracker Load (1.5ms)   SELECT * FROM "trackers" WHERE ("trackers"."id" IN (1,2,3))                                                                    
  SQL (0.3ms)   BEGIN                                                                                                                                   
  SQL (0.2ms)   COMMIT                                                                                                                                  
  SQL (0.3ms)   BEGIN                                                                                                                                   
  SQL (0.2ms)   COMMIT                                                                                                                                  
  SQL (0.2ms)   BEGIN                                                                                                                                   
  SQL (0.2ms)   COMMIT                                                                                                                                  
  SQL (0.2ms)   BEGIN                                                                                                                                   
  SQL (0.2ms)   COMMIT                                                                                                                                  
  SQL (0.2ms)   BEGIN                                                                                                                                   
  SQL (0.2ms)   COMMIT                                                                                                                                  
  SQL (0.2ms)   BEGIN                                                                                                                                   
  SQL (0.2ms)   COMMIT                                                                                                                                  
  SQL (0.3ms)   BEGIN                                                                                                                                   
  SQL (0.3ms)   COMMIT                                                                                                                                  
  SQL (0.3ms)   BEGIN                                                                                                                                   
  SQL (0.3ms)   COMMIT                                                                                                                                  
  SQL (0.3ms)   BEGIN                                                                                                                                   
  SQL (0.2ms)   COMMIT                                                                                                                                  
  SQL (0.2ms)   BEGIN                                                                                                                                   
  CustomField Load (1.7ms)   SELECT * FROM "custom_fields" WHERE (type = 'ProjectCustomField') ORDER BY position                                        
  EnabledModule Exists (0.9ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'issue_tracking' AND "enabled_modules".project_id IS NULL) LIMIT 1
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'time_tracking' AND "enabled_modules".project_id IS NULL) LIMIT 1 
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'news' AND "enabled_modules".project_id IS NULL) LIMIT 1          
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'documents' AND "enabled_modules".project_id IS NULL) LIMIT 1     
  EnabledModule Exists (0.5ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'files' AND "enabled_modules".project_id IS NULL) LIMIT 1         
  EnabledModule Exists (0.5ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'wiki' AND "enabled_modules".project_id IS NULL) LIMIT 1          
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'repository' AND "enabled_modules".project_id IS NULL) LIMIT 1
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'boards' AND "enabled_modules".project_id IS NULL) LIMIT 1
  Tracker Exists (0.6ms)   SELECT "trackers".id FROM "trackers" WHERE ("trackers"."name" = E'Ошибка' AND "trackers".id <> 1) LIMIT 1
  Tracker Exists (0.6ms)   SELECT "trackers".id FROM "trackers" WHERE ("trackers"."name" = E'Улучшение' AND "trackers".id <> 2) LIMIT 1
  Tracker Exists (0.6ms)   SELECT "trackers".id FROM "trackers" WHERE ("trackers"."name" = E'Поддержка' AND "trackers".id <> 3) LIMIT 1
  Project Exists (0.7ms)   SELECT "projects".id FROM "projects" WHERE ("projects"."name" = E'Магазин Автозапчастей') LIMIT 1
  Project Exists (0.5ms)   SELECT "projects".id FROM "projects" WHERE ("projects"."identifier" = E'autoshop') LIMIT 1
  CACHE (0.0ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'issue_tracking' AND "enabled_modules".project_id IS NULL) LIMIT 1
  CACHE (0.0ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'time_tracking' AND "enabled_modules".project_id IS NULL) LIMIT 1
  CACHE (0.0ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'news' AND "enabled_modules".project_id IS NULL) LIMIT 1
  CACHE (0.0ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'documents' AND "enabled_modules".project_id IS NULL) LIMIT 1
  CACHE (0.0ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'files' AND "enabled_modules".project_id IS NULL) LIMIT 1
  CACHE (0.0ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'wiki' AND "enabled_modules".project_id IS NULL) LIMIT 1
  CACHE (0.0ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'repository' AND "enabled_modules".project_id IS NULL) LIMIT 1
  CACHE (0.0ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'boards' AND "enabled_modules".project_id IS NULL) LIMIT 1
  CACHE (0.0ms)   SELECT "trackers".id FROM "trackers" WHERE ("trackers"."name" = E'Ошибка' AND "trackers".id <> 1) LIMIT 1
  CACHE (0.0ms)   SELECT "trackers".id FROM "trackers" WHERE ("trackers"."name" = E'Улучшение' AND "trackers".id <> 2) LIMIT 1
  CACHE (0.0ms)   SELECT "trackers".id FROM "trackers" WHERE ("trackers"."name" = E'Поддержка' AND "trackers".id <> 3) LIMIT 1
  CACHE (0.0ms)   SELECT "projects".id FROM "projects" WHERE ("projects"."name" = E'Магазин Автозапчастей') LIMIT 1
  CACHE (0.0ms)   SELECT "projects".id FROM "projects" WHERE ("projects"."identifier" = E'autoshop') LIMIT 1
  SQL (0.7ms)   SELECT max("projects".rgt) AS max_rgt FROM "projects" 
  CACHE (0.0ms)   SELECT max("projects".rgt) AS max_rgt FROM "projects" 
  SQL (0.7ms)   INSERT INTO "projects" ("name", "created_on", "lft", "updated_on", "homepage", "parent_id", "description", "is_public", "identifier", "status", "rgt") VALUES(E'Магазин Автозапчастей', '2009-05-16 03:05:01.633750', 1, '2009-05-16 03:05:01.633750', E'', NULL, E'', 't', E'autoshop', 1, 2) RETURNING "id" 
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'issue_tracking' AND "enabled_modules".project_id = 2) LIMIT 1
  SQL (0.6ms)   INSERT INTO "enabled_modules" ("name", "project_id") VALUES(E'issue_tracking', 2) RETURNING "id" 
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'time_tracking' AND "enabled_modules".project_id = 2) LIMIT 1
  SQL (0.6ms)   INSERT INTO "enabled_modules" ("name", "project_id") VALUES(E'time_tracking', 2) RETURNING "id" 
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'news' AND "enabled_modules".project_id = 2) LIMIT 1
  SQL (0.6ms)   INSERT INTO "enabled_modules" ("name", "project_id") VALUES(E'news', 2) RETURNING "id" 
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'documents' AND "enabled_modules".project_id = 2) LIMIT 1
  SQL (0.5ms)   INSERT INTO "enabled_modules" ("name", "project_id") VALUES(E'documents', 2) RETURNING "id" 
  EnabledModule Exists (0.7ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'files' AND "enabled_modules".project_id = 2) LIMIT 1
  SQL (0.6ms)   INSERT INTO "enabled_modules" ("name", "project_id") VALUES(E'files', 2) RETURNING "id" 
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'wiki' AND "enabled_modules".project_id = 2) LIMIT 1
  SQL (0.6ms)   INSERT INTO "enabled_modules" ("name", "project_id") VALUES(E'wiki', 2) RETURNING "id" 
  Project Load (1.6ms)   SELECT * FROM "projects" WHERE ("projects"."id" = 2)
  Wiki Load (0.9ms)   SELECT * FROM "wikis" WHERE ("wikis".project_id = 2) LIMIT 1
  SQL (0.7ms)   INSERT INTO "wikis" ("project_id", "start_page", "status") VALUES(2, E'Wiki', 1) RETURNING "id" 
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'repository' AND "enabled_modules".project_id = 2) LIMIT 1
  SQL (0.6ms)   INSERT INTO "enabled_modules" ("name", "project_id") VALUES(E'repository', 2) RETURNING "id" 
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'boards' AND "enabled_modules".project_id = 2) LIMIT 1
  SQL (0.6ms)   INSERT INTO "enabled_modules" ("name", "project_id") VALUES(E'boards', 2) RETURNING "id" 
  SQL (0.4ms)   INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (2, 1)
  SQL (0.3ms)   INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (2, 2)
  SQL (0.3ms)   INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (2, 3)
  EnabledModule Exists (0.7ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'issue_tracking' AND "enabled_modules".project_id = 2 AND "enabled_modules".id <> 9) LIMIT 1
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'time_tracking' AND "enabled_modules".project_id = 2 AND "enabled_modules".id <> 10) LIMIT 1
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'news' AND "enabled_modules".project_id = 2 AND "enabled_modules".id <> 11) LIMIT 1
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'documents' AND "enabled_modules".project_id = 2 AND "enabled_modules".id <> 12) LIMIT 1
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'files' AND "enabled_modules".project_id = 2 AND "enabled_modules".id <> 13) LIMIT 1
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'wiki' AND "enabled_modules".project_id = 2 AND "enabled_modules".id <> 14) LIMIT 1
  EnabledModule Exists (0.6ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'repository' AND "enabled_modules".project_id = 2 AND "enabled_modules".id <> 15) LIMIT 1
  EnabledModule Exists (0.7ms)   SELECT "enabled_modules".id FROM "enabled_modules" WHERE ("enabled_modules"."name" = E'boards' AND "enabled_modules".project_id = 2 AND "enabled_modules".id <> 16) LIMIT 1
  SQL (0.0ms)   RuntimeError: ERROR     C23505  Mduplicate key value violates unique constraint "projects_trackers_unique"      Fnbtinsert.c    L298    R_bt_check_unique: INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (2, 1)
  SQL (0.2ms)   ROLLBACK

Actions
Copy link

Also available in: Atom PDF