0030279: log clean up process doesn't vacuum tables deleted via FK cascaded deletion

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0030279

Openbravo ERP

A. Platform

public

2015-06-29 13:43

2022-02-01 08:09

Reporter

alostale

Assigned To

Triage Platform Base

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

acknowledged

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0030279: log clean up process doesn't vacuum tables deleted via FK cascaded deletion

Description

When log clean up process is run in PostgreSQL, tables that where cleaned up are vacuumed.

If there are tables that are deleted because they have a delete cascade FK to one of the tables marked to be deleted, vacuum is not executed for them.

Steps To Reproduce

In the default configuration ad_session is marked to be deleted, ad_session_usage_audit is also deleted via FK.

Execute clean up process and check there is a vacuum for ad_session but not for ad_session_usage_audit.

Proposed Solution

Check cascaded FK tables to also vacuum them:

           SELECT distinct pc1.relname
             FROM pg_constraint pc, pg_class pc1, pg_class pc2
            WHERE pc.contype='f' and pc.conrelid= pc1.oid
              and pc.confrelid = pc2.oid
              and pc2.relname in :deletedTables

Note this can be recursive to several levels

Additional Information