Bug #10171
closed
If the Rudder Web Interface is interrupted during the second step of reports archiving, then it won't never succeed in archiving again
Added by Nicolas CHARLES almost 8 years ago.
Updated almost 8 years ago.
Category:
Web - Maintenance
Description
Reports archiving happens by default every day.
It's a 3 steps procedure, with:
- reports insertion into archivedruddersysevents from ruddersysevents
- deletion from ruddersysevents
- vaccuum
If this is interupted during step 2, then reports already moved will not be deleted, and on the following day they won't be archived (because of duplicate keys)
We should have a more robust system that would recover from where it stopped
(alternatives are to drop the unicity constraints on archivedruddersysevents, but this would lead to duplicate entries in this case)
- Status changed from New to In progress
- Assignee set to Nicolas CHARLES
Suggested implementation
- get A max id of archivedruddersysevents
- get R min id of ruddersysevents
- get C max id of ruddersysevents where date < archive date
- insert reports from [max(R,A) to C] to archivedruddersysevents
- delete reports smaller than C from ruddersysevents
risk is: if insert into ruddersysevents is too long, and web interface is restarted, deletion never occurs, so we may add a delete in 3bis for all overlap
- Status changed from In progress to Pending technical review
- Assignee changed from Nicolas CHARLES to François ARMAND
- Pull Request set to https://github.com/Normation/rudder/pull/1491
- Status changed from Pending technical review to Pending release
- % Done changed from 0 to 100
- Status changed from Pending release to Released
This bug has been fixed in Rudder 3.1.18, 3.2.11, 4.0.3 and 4.1.0~beta3 which were released today.
- Is duplicate of Bug #3917: Archiving reports should not break on on duplicate IDs or key added
- Is duplicate of deleted (Bug #3917: Archiving reports should not break on on duplicate IDs or key)
- Has duplicate Bug #3917: Archiving reports should not break on on duplicate IDs or key added
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by