Defect #7032

Issue relation table doesn't have constraints to issues id

Added by Bruno Medeiros almost 10 years ago. Updated over 1 year ago.

Status:ClosedStart date:2010-12-03
Priority:NormalDue date:
Assignee:-% Done:


Target version:-
Resolution:Invalid Affected version:


I have a Redmine 1.0.4 running on MySQL. For some reason I didn't discovered it, at some time there was a lot of entries in 'issues_relation' table referencing deleted issues. This caused the defect #7018 and may cause some other problems in the future.


#1 Updated by Jean-Philippe Lang almost 10 years ago

Of course, FK would be a clean solution to ensure that this problem never occurs but Rails doesn't provide support for FK.

That said, the rows in issue_relations should be deleted by the application when deleting one of the issues. Do you know a way to reproduce this situation?

#2 Updated by Bruno Medeiros almost 10 years ago

Jean, I the last 3 weeks I was trying some plugins and external tools to import MS Project files into Redmine. The first plugin I tried was:

I prefer to think that it was caused to some abrupt termination of the server then a plugin's fault, but everything need to be considered.

I loaded tons of issues (400+) in a row and deleted then using the issue tab several times (load via plugin, see the results, select all, right click, delete). I tried to reproduce that without success. It can be a combination of factors, like server being stopped when deleting issues, or something like that. Don't know if it's worth worry about it...

#3 Updated by Marius BALTEANU over 1 year ago

  • Status changed from New to Closed
  • Resolution set to Invalid

#4 Updated by Marius BALTEANU over 1 year ago

I'm closing this because is obsolete and there are no such problems in the recent Redmine versions.

Also available in: Atom PDF