Unable to delete issue statuses
I'm still using redmine 0.5.0 and wanted to give a try to redmine 0.6.3. I'm using PostgreSQL as the redmine database. So I did a dump of the database from one server, and imported to the test server. Configured the version 0.6.3 to use the new database, and did a
rake db:migrate RAILS_ENV="production"
Everything went ok and I started testing the new version (running with webbrick).
If I go to Administration and then Issue statuses and create a new issue status, I cannot delete the issue status I just created. I get the message "Unable to delete issue status".
Looking at the logs, i find the following:
IssueStatus Load (0.000132) SELECT * FROM issue_statuses WHERE (issue_statuses."id" = 11)
SQL (0.000047) BEGIN
Issue Load (0.000383) SELECT * FROM issues WHERE (status_id=11) LIMIT 1
Workflow Delete all (0.000195) DELETE FROM workflows WHERE (old_status_id = 11)
IssueStatus Update (0.000125) UPDATE issue_statuses SET position = (position - 1) WHERE (1 = 1 AND position > 8)
IssueStatus Update (0.000000) PGError: ERROR: null value in column "position" violates not-null constraint
: UPDATE issue_statuses SET "is_closed" = 'f', "name" = 'klklkl', "position" = NULL, "is_default" = 'f' WHERE "id" = 11
SQL (0.000052) ROLLBACK
Redirected to http://10.112.64.1:3000/issue_statuses/list
Perhaps this only happens with PostgreSQL.
#1 Updated by Thomas Lecavelier about 10 years ago
Could you try to reuse the update SQL line in a postgresql terminal, please?
UPDATE issue_statuses SET position = (position - 1) WHERE (1 = 1 AND position > 8)
I'm rather sure that the problem is (position -1) where position should be already replaced by the old position value. Trying the exact line confirm that Postgresql can't reuse a referential value during an Update command.
#2 Updated by Mario Moreira about 10 years ago
No, the problem is not with that statement. If you check the log above you see that the error is with the next statement:
UPDATE issue_statuses SET "is_closed" = 'f', "name" = 'klklkl', "position" = NULL, "is_default" = 'f' WHERE "id" = 11
Just to confirm that:
redmine=# UPDATE issue_statuses SET position = (position - 1) WHERE (1 = 1 AND position > 8);
redmine=# UPDATE issue_statuses SET "is_closed" = 'f', "name" = 'klklkl', "position" = NULL, "is_default" = 'f' WHERE "id" = 11;
ERROR: null value in column "position" violates not-null constraint
#3 Updated by Mario Moreira about 10 years ago
A bit more of info on this. The rake db:migrate command run without errors, and my schema is in the version 86 as expected:
redmine=# SELECT * from schema_info ; version --------- 86 (1 row)
So i think that migration 76 is not working properly with postgres. If we check table issue_statuses, we get:
redmine=# \d issue_statuses Table "public.issue_statuses" Column | Type | Modifiers ------------+-----------------------+------------------------------------------------------------- id | integer | not null default nextval('issue_statuses_id_seq'::regclass) name | character varying(30) | not null default ''::character varying is_closed | boolean | not null default false is_default | boolean | not null default false position | integer | not null default 1 Indexes: "issue_statuses_pkey" PRIMARY KEY, btree (id)
I have the last version of the postgres adapter and I'm running PostgreSQL 8.2.4:
postgres (0.7.9.2008.01.28, 0.7.1)
Ruby extension library providing an API to PostgreSQL
#4 Updated by Jean-Philippe Lang about 10 years ago
There was a bug on a few migrations. Some not null constraints were not removed with Postgresql.
This is fixed in r1140 and ported in 0.6 stable branch.
You can checkout the
branches/0.6-stable, but you'll have to rerun the migration from your 0.5 database copy.
I hope you will enjoy the new features :-)
#7 Updated by Colan Schwartz over 9 years ago
- Status changed from Closed to Reopened
- Target version changed from 0.7 to 0.7.1
This still doesn't work on MySQL. I even changed the status on all issues to something other than the one I want to delete, and it still didn't work: "Unable to delete issue status".
#8 Updated by Colan Schwartz over 9 years ago
After further investigation, it seems as though the status initially named "Closed" (the name can be changed) cannot be deleted. I swapped names with a created status, and then I could delete it. Is it really necessary that this status needs to be special (i.e. cannot be deleted)?
#10 Updated by Jean-Philippe Lang over 9 years ago
- Status changed from Reopened to Closed
- Target version set to 0.7
There is no special behaviour for the "Closed" status.
Please open a new ticket with the information requested in SubmittingBugs and the exact steps to reproduce if this problem still occurs.