Project

General

Profile

Forums » Help »

Tracker hierarchy (parent, subtask, nesting) not displayed consistently, esp. when parent changes

Added by Mike Stell about 1 year ago

We recently upgraded from 4.x and I liked the new '>' for subtasks in issue list and tracker view itself, BUT it seems to have broken the task view rendering of parent/child links in cases when parent is changed, e.g. these screenshots show that there SHOULD be up/down links but none are there (same project/user permissions):
task view with missing parent/sub links

I was not able to recreate that exact symptom in our sandbox environment, but contriving some trees of task type, I do notice that they are not consistently rendered with the '>' nesting in issue lists. Perhaps the same mechanism is involved with those indents as for the parent/sub rendering in the tracker view?
list that misses nesting of 500026/27 under 500025
view up/down from 500026 (showing 25/27 relationships)

Here is our current environment:

RAILS_ENV = PRODUCTION
OS: Windows Server 2019 (QA) and 2022 (Civil)
Database: MS SQL Server 2016
Ruby-aware server: Puma

environment details

Thanks!

Download all files
clipboard-202404191043-qrecy.png (200 KB) clipboard-202404191043-qrecy.png task view with missing parent/sub links
clipboard-202404191044-vs8je.png (17.3 KB) clipboard-202404191044-vs8je.png list that misses nesting of 500026/27 under 500025
clipboard-202404191052-zwsto.png (20.3 KB) clipboard-202404191052-zwsto.png view up/down from 500026 (showing 25/27 relationships)
clipboard-202404191055-ehckx.png (6.08 KB) clipboard-202404191055-ehckx.png environment details

Replies (6)

RE: Tracker hierarchy (parent, subtask, nesting) not displayed consistently, esp. when parent changes - Added by James H about 1 year ago

as a note, i believe the indent in the issues list only happens when it is ordered in that specific way where the children come right after the parent.

RE: Tracker hierarchy (parent, subtask, nesting) not displayed consistently, esp. when parent changes - Added by Mike Stell 10 months ago

I agree that the list indentation isn't "supposed to" work when IDs aren't in a certain order, but the main problem of missing relations still persists. Here is another instance where you can see the children in notes but not in subtask pane or looking back from child (please excuse my sloppy redactions):

clipboard-202408261000-zb9zk.png (57.9 KB) clipboard-202408261000-zb9zk.png

RE: Tracker hierarchy (parent, subtask, nesting) not displayed consistently, esp. when parent changes - Added by Abeesh M P 2 days ago

Hi Mike Stell,

Did you get any solution for the problem, I am also facing same issue.

RE: Tracker hierarchy (parent, subtask, nesting) not displayed consistently, esp. when parent changes - Added by Holger Just 2 days ago

In previous versions of Redmine on MySQL / MariaDB, it was possible that the issue tree could become inconsistent if there are concurrent changes to it. This was resolved in Redmine 5.1.1 / #39437 for new changes to the issue trees. Note that this may also require a change of your database.yml file to work correctly, See MySQL_configuration for details.

If your issue tree was already inconsistent previously, you may also have to repair it once. Note that it will obtain a database lock of all issues for the duration it runs. Any concurrent issue updates will block / wait until the repair process is completed.

To repair your issue tree, you can start a rails console with RAILS_ENV=production rails console. In the console, you can then start the process by entering:

Issue.rebuild_tree!

This will rebuilt the issue trees in the database based on the parent_id pointers. Depending on the number of issues and depth of your issue trees, this can take a long time though. This procedure should be safe in any case. As with all maintenance procedures, you should still make sure you have a working database backup beforehand to be able to go back to the previous state in case anything still goes wrong.

Once the rebuild process is finished, you can exit the console again by typing exit or pressing Ctrl+D.

RE: Tracker hierarchy (parent, subtask, nesting) not displayed consistently, esp. when parent changes - Added by Abeesh M P 1 day ago

Hi Holger ,

Thankyou for the quick reply. Please see the details of my current installation.

Is it possible to have a patch to this version to get this issue resolved ? because its very difficult for us to upgrade the redmine to 5.1.1 version as per our current situation. Please help on this.

clipboard-202506290823-15syf.png (9.62 KB) clipboard-202506290823-15syf.png

RE: Tracker hierarchy (parent, subtask, nesting) not displayed consistently, esp. when parent changes - Added by Mike Stell about 4 hours ago

Our team did develop a script to identify these inconsistencies and rebuild the "corrupt" trees, but it has recurred in the environment below, so we are still periodically surveilling. I'll ask whether their script is using the rails Issue.rebuild_tree! call or otherwise:

Environment:
Redmine version 6.0.3.stable
Ruby version 3.3.6-p108 (2024-11-05) [x64-mingw-ucrt]
Rails version 7.2.2.1
Environment production
Database adapter SQLServer

    (1-6/6)