Project

General

Profile

Actions

User story #2972

closed

User story #2996: Clean report database v1 : Add a manual report deleting

Allow to delete report from database

Added by François ARMAND over 11 years ago. Updated almost 9 years ago.

Status:
Released
Priority:
1
Category:
Web - Maintenance
Target version:
UX impact:
Suggestion strength:
User visibility:
Effort required:
Name check:
Fix check:
Regression:

Description

Some of our user are experiencing a big problem with their PostgresSQL DB growing out of control due to to much agent execution reports.

We are already able to archive them, but we want to also be able to simply delete report older than a given date.

The "DB administration UI" should be updated to "clean reports", and allow to choose between "archive" and "delete" with a radio button.

That feature should go in Rudder 2.4 because of the huge impact on users. Nevertheless, once the code is available, a validation of its impact will have to be done before going to 2.4.0.


Files

DB_management.png (117 KB) DB_management.png Vincent MEMBRÉ, 2012-10-31 15:42

Related issues 3 (0 open3 closed)

Related to Rudder - User story #2974: Archive reports does not free space on diskReleasedNicolas CHARLES2012-10-31Actions
Related to Rudder - User story #2976: Archived reports size is not displayedReleasedNicolas CHARLES2012-11-02Actions
Blocks Rudder - User story #2973: Allow to automatically clean reports from database (simple version)ReleasedNicolas CHARLESActions
Actions #1

Updated by Vincent MEMBRÉ over 11 years ago

I just finished a first version of manual delete reports.

Here's a Screenshot of that version.

Actions #2

Updated by Vincent MEMBRÉ over 11 years ago

Size of database will not changed until a "vacuum"/"vacuum full" request is executed by the database

See #2974 for more details

Actions #3

Updated by Vincent MEMBRÉ over 11 years ago

  • Status changed from In progress to Pending technical review

I made a pull request about that, https://github.com/Normation/rudder/pull/4

technical review can now be done

Actions #4

Updated by Nicolas PERRON over 11 years ago

  • Target version changed from 2.4.0~rc1 to 2.5.0~beta1

The new feature about automation of DB management tasks will not be included in Rudder 2.4. Then, postponed to Rudder 2.5

Actions #5

Updated by Vincent MEMBRÉ over 11 years ago

Added #2974 (add the vacuum) #2976 (display archive size) as subtask of that issue

Actions #6

Updated by Vincent MEMBRÉ over 11 years ago

  • Parent task set to #2973

This issue is a subtask of #2973

Actions #7

Updated by Vincent MEMBRÉ over 11 years ago

  • Parent task changed from #2973 to #2996

Sorry, this issue is the implementation part of #2996, not a subtask from #2973

Actions #8

Updated by Vincent MEMBRÉ over 11 years ago

As we can't change pull request target, I made another pull request about that issue, https://github.com/Normation/rudder/pull/8

technical review can now be done.

Actions #9

Updated by François ARMAND over 11 years ago

  • % Done changed from 0 to 100
Actions #10

Updated by Nicolas CHARLES over 11 years ago

  • Tracker changed from Bug to Enhancement
  • Status changed from Pending technical review to 12

This is valid, thank you Vincent

Actions #11

Updated by Vincent MEMBRÉ over 11 years ago

  • Status changed from 12 to Pending release
Actions #12

Updated by Matthieu CERDA about 11 years ago

  • Status changed from Pending release to Released
Actions #13

Updated by Benoît PECCATTE almost 9 years ago

  • Tracker changed from Enhancement to User story
Actions

Also available in: Atom PDF