Bug #13211

The deletion of archival descriptions with a lot of descendants is prone to web server timeouts

Added by José Raddaoui Marín 3 months ago. Updated about 1 month ago.

Status:QA/ReviewStart date:11/13/2019
Priority:MediumDue date:
Assignee:Dan Gillean% Done:

0%

Category:Performance / scalability
Target version:Release 2.6.0
Google Code Legacy ID: Tested version:2.5, 2.6
Sponsored:No Requires documentation:

Description

When a full hierarchy of descriptions is deleted from the database it has to be deleted from the bottom to the top to avoid foreign key constraint errors related to the parent-son relations. This is taking too much time in large datasets causing web server timeouts in some cases (it depends on the amount of descendants and the position in the entire archival descriptions tree). Additionally, when the timeout occurs, the process keeps running causing issues in the MySQL server.


Related issues

Related to Access to Memory (AtoM) - Task #13224: Improve hierarchy management queries Code Review 12/09/2019
Related to Access to Memory (AtoM) - Task #13239: Improve deletion of nested set hierarchies (specially terms) New 01/13/2020

History

#1 Updated by José Raddaoui Marín 3 months ago

  • Status changed from In progress to Code Review

This is ready for code review in https://github.com/artefactual/atom/pull/1000.

As you can see I broke the PR and it's already merged so I'll address the feedback and merge any changes in different PRs if needed.

#2 Updated by José Raddaoui Marín 3 months ago

  • Assignee changed from José Raddaoui Marín to David Juhasz

#3 Updated by José Raddaoui Marín about 1 month ago

  • Status changed from Code Review to QA/Review
  • Assignee changed from David Juhasz to Dan Gillean

#4 Updated by José Raddaoui Marín about 1 month ago

  • Related to Task #13224: Improve hierarchy management queries added

#5 Updated by José Raddaoui Marín about 1 month ago

  • Related to Task #13239: Improve deletion of nested set hierarchies (specially terms) added

Also available in: Atom PDF