Defect #3368

Cannot create project on postgresql

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

Status:ClosedStart date:2009-05-16
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Projects
Target version:-
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

History

#1 Updated by Andrew Kouznetsov over 10 years ago

ruby 1.8.7 (2008-08-11 patchlevel 72) [x86_64-linux]
rails (2.2.2)
postgres-pr (0.6.1)
PostgreSQL 8.3.7

You can see the error on http://redmine.bellax.net

#2 Updated by Andrew Kouznetsov over 10 years ago

stuff_to_do plugin makes this error

#3 Updated by Andrew Kouznetsov over 10 years ago

sorry. I forgotten to launch rake task for plugins db migration

#4 Updated by Andrew Kouznetsov over 10 years ago

  • Status changed from New to Resolved

#5 Updated by Jean-Philippe Lang over 10 years ago

  • Status changed from Resolved to Closed
  • Affected version (unused) deleted (devel)
  • Resolution set to Invalid

Also available in: Atom PDF