0054980: Audit Trail infrestrucuture is creating temporary tables that could end on getting the limit of elements created in postgresql

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0054980

Openbravo ERP

A. Platform

public

2024-03-18 12:37

2024-03-19 08:56

Reporter

egoitz

Assigned To

Triage Platform Base

Priority

urgent

Severity

major

Reproducibility

have not tried

Status

new

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

0054980: Audit Trail infrestrucuture is creating temporary tables that could end on getting the limit of elements created in postgresql

Description

Every time a table, index, or Postgresql element is created the value
of the OID field is updated and incremented in one.

SELECT proname, oid, proconfig FROM pg_proc order by oid desc;

Having audit trail enabled for many tables affects the number of elements created because many temporary tables are created and deleted.

Steps To Reproduce

N/a

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0054768		closed	AugustoMauch	compilation error: [java] org.postgresql.util.PSQLException: Bad value for type int : 2173831272
related to	feature request	0038629		closed	alostale	do not use ad_session_status to disable PG triggers