Project

General

Profile

Actions

Defect #17430

closed

Broken Subtask Tree

Added by Ewan Makepeace over 9 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Duplicate
Affected version:

Description

I just hit the problem of a broken subtask tree once more. This is a long standing problem that I have seen and reported before. See for example:

#11011 - reported by me - ultimately closed as not reproducible.
#15581 - reported by my colleague.

I was creating a 3 level tree of bugs to be fixed using multiple tabs to add new subtasks at each level. This is how far I got:

However when I click on issue 8644 in that tree (first level child) it gets most of the rest of the tree displayed on its page:

I checked in the database and this is what I see in the left and right :

id parent_id root_id lft rgt
8798 8644 8642 11 18
8803 8798 8642 12 13
8804 8798 8642 14 15
8805 8798 8642 16 17
8799 8644 8642 19 20
8800 8644 8642 21 22
8801 8644 8642 23 24
8802 8644 8642 25 26

Using

select id, parent_id, root_id, lft, rgt from issues where id > 8797 order by lft, rgt;


Files

Parent.jpg (93.8 KB) Parent.jpg Ewan Makepeace, 2014-07-09 12:50
Child.jpg (104 KB) Child.jpg Ewan Makepeace, 2014-07-09 12:59

Related issues

Is duplicate of Redmine - Defect #6579: Tree hierachy being currupted on multiple submissions of an issueClosedJean-Philippe Lang2010-10-05

Actions
Actions #1

Updated by Ewan Makepeace over 9 years ago

Actions #2

Updated by Ewan Makepeace over 9 years ago

Sorry - more complete output from the database:

id parent_id root_id lft rgt
8642 NULL 8642 1 28
8643 8642 8642 2 9
8645 8643 8642 3 4
8646 8643 8642 5 6
8647 8643 8642 7 8
8644 8642 8642 10 27
8798 8644 8642 11 18
8803 8798 8642 12 13
8804 8798 8642 14 15
8805 8798 8642 16 17
8799 8644 8642 19 20
8800 8644 8642 21 22
8801 8644 8642 23 24
8802 8644 8642 25 26

Using select id, parent_id, root_id, lft, rgt from issues where root_id=8642 order by lft, rgt;

Actions #3

Updated by Ewan Makepeace over 9 years ago

  • Status changed from New to Resolved

I need to check this again.

Actions #4

Updated by Toshi MARUYAMA over 9 years ago

  • Status changed from Resolved to Closed
  • Resolution set to Duplicate
Actions #5

Updated by Toshi MARUYAMA over 9 years ago

  • Is duplicate of Defect #6579: Tree hierachy being currupted on multiple submissions of an issue added
Actions

Also available in: Atom PDF