Project

General

Profile

Actions
Copy link

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 about 12 years ago. Updated over 9 years ago.

Status:
Released
Priority:
1 (highest)
Assignee:
Vincent MEMBRÉ
Category:
Web - Maintenance
Target version:
2.5.0~beta1
Pull Request:
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 open — 3 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
Copy link
 #1

Updated by Vincent MEMBRÉ about 12 years ago

I just finished a first version of manual delete reports.

Here's a Screenshot of that version.

Actions
Copy link
 #2

Updated by Vincent MEMBRÉ about 12 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
Copy link
 #3

Updated by Vincent MEMBRÉ about 12 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
Copy link
 #4

Updated by Nicolas PERRON about 12 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
Copy link
 #5

Updated by Vincent MEMBRÉ about 12 years ago

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

Actions
Copy link
 #6

Updated by Vincent MEMBRÉ about 12 years ago

  • Parent task set to #2973

This issue is a subtask of #2973

Actions
Copy link
 #7

Updated by Vincent MEMBRÉ about 12 years ago

  • Parent task changed from #2973 to #2996

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

Actions
Copy link
 #8

Updated by Vincent MEMBRÉ about 12 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
Copy link
 #9

Updated by François ARMAND almost 12 years ago

  • % Done changed from 0 to 100
Actions
Copy link
 #10

Updated by Nicolas CHARLES almost 12 years ago

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

This is valid, thank you Vincent

Actions
Copy link
 #11

Updated by Vincent MEMBRÉ almost 12 years ago

  • Status changed from 12 to Pending release
Actions
Copy link
 #12

Updated by Matthieu CERDA almost 12 years ago

  • Status changed from Pending release to Released
Actions
Copy link
 #13

Updated by Benoît PECCATTE over 9 years ago

  • Tracker changed from Enhancement to User story
Actions
Copy link

Also available in: Atom PDF