Project

General

Profile

Actions

Bug #15413

closed

Autovacuum may never finish, or take more than one day, on busy Rudder instance, because of resources attrition

Added by Nicolas CHARLES over 5 years ago. Updated over 5 years ago.

Status:
Released
Priority:
N/A
Category:
System integration
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
0
Name check:
Reviewed
Fix check:
Checked
Regression:

Description

In https://issues.rudder.io/issues/14336 we introduced autovacuum on most table, and especialy ruddersysevents
Problem is postgres cannot keep up with the rate of data on this table, and on a busy instance, it can take more than a day. In result, it block the standart vacuum made every night, and so disk space grows out of limit

In this case, the only solution is to
ALTER TABLE ruddersysevents SET (autovacuum_enabled = false);
select pg_terminate_backend(<autovacuum id>);

and hope the database can recover

we need to remove this autovacuum as it is too risky

Note, it may be the cause of https://issues.rudder.io/issues/14789


Subtasks 2 (0 open2 closed)

Bug #15416: Create migration script to remove autovacuum for ruddersyseventsReleasedAlexis MoussetActions
Bug #15653: Missing migration script for vacuum changeReleasedAlexis MoussetActions

Related issues 2 (0 open2 closed)

Related to Rudder - Bug #14336: Rudder database grows with time because of defaults values for autovacuum that don't fit our needsReleasedFrançois ARMANDActions
Related to Rudder - Bug #14789: Postgres fills up and can't be vaccumedReleasedVincent MEMBRÉActions
Actions #1

Updated by Nicolas CHARLES over 5 years ago

  • Related to Bug #14336: Rudder database grows with time because of defaults values for autovacuum that don't fit our needs added
Actions #2

Updated by Nicolas CHARLES over 5 years ago

  • Related to Bug #14789: Postgres fills up and can't be vaccumed added
Actions #3

Updated by Nicolas CHARLES over 5 years ago

  • Status changed from New to In progress
  • Assignee set to Nicolas CHARLES
Actions #4

Updated by Nicolas CHARLES over 5 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Nicolas CHARLES to Alexis Mousset
  • Pull Request set to https://github.com/Normation/rudder/pull/2376
Actions #5

Updated by Nicolas CHARLES over 5 years ago

  • Status changed from Pending technical review to Pending release
Actions #6

Updated by Nicolas CHARLES over 5 years ago

  • Fix check changed from To do to Checked
Actions #7

Updated by Alexis Mousset over 5 years ago

  • Name check changed from To do to Reviewed
Actions #8

Updated by Vincent MEMBRÉ over 5 years ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 5.0.13 which was released today.

Actions

Also available in: Atom PDF